Update Material/Work Groups - Intergraph Smart Materials - Version 2020 (10.0) - Customization & Programming - Hexagon

Intergraph Smart Materials Classic API Configuration (2020)

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

To update material/work groups, use the UPD_SUPMG procedure.

The arguments of UPD_SUPMG are listed below.

Argument Name

Type

In/Out

P_US_ID

NUMBER, m_user_securities.us_id

IN

P_SMG_ID

NUMBER, m_sup_material_groups.smg_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_sup_material_groups. When all checks succeed, the procedure updates a record in m_sup_material_groups.

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

Column Name

Mandatory

Description

QUALIFIED_IND

Yes

Qualified (VARCHAR2(1), m_sup_material_groups.qualified_ind)

QUALIFIED_DATE

No

Qualified Date (DATE), m_sup_material_groups.qualified_date)

APP_DEPARTMENT

No

Approval Department ID (NUMBER(12,0), m_sup_material_groups.dpt_id)

QUALIFICATION_CLASS

Yes

Classification (VARCHAR2(1), m_sup_material_groups.qualification_class)