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) |