Update Company Descriptions - Intergraph Smart Materials - Version 10.1 - Customization & Programming - Hexagon PPM

Intergraph Smart Materials Classic API Configuration (10.1)

Language
English (United States)
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Customization & Programming
Smart Materials/Smart Reference Data Version
10.1

To update company descriptions, use the UPD_NLS procedure.

The arguments of UPD_NLS are listed below.

Argument Name

Type

In/Out

P_US_ID

NUMBER, m_user_securities.us_id

IN

P_COMPANY_ID

NUMBER, m_companies.company_id

IN

P_COL_ARR

RECORD

IN

P_RESULT

VARCHAR2

OUT

P_COMMIT_IND

VARCHAR2, default ‘Y’

IN

The procedure calls check routines for all columns to be updated prior to performing the actual update of table m_company_nls. When all checks succeed, the procedure updates a record in m_company_nls.

The following table shows the values that can be updated with the UPD_NLS procedure.

Column Name

Mandatory

Description

SHORT_DESC

Yes

Short Description (VARCHAR2(20), m_company_nls.short_desc)

DESCRIPTION

Yes

Description (VARCHAR2(255), m_company_nls.description)