To create a new supplier attribute, enter all mandatory values.
The arguments of the INS_UV procedure are listed below.
|
Argument Name |
Type |
In/Out |
|---|---|---|
|
P_US_ID |
NUMBER, m_user_securities.us_id |
IN |
|
P_COL_ARR |
RECORD |
IN |
|
P_RESULT |
VARCHAR2 |
OUT |
|
P_UVAL_ID |
NUMBER, m_used_values.uval_id |
OUT |
|
P_PROJ_ID |
VARCHAR2, m_projects.proj_id |
IN |
|
P_USED_TYPE |
VARCHAR2, m_used_values.used_type |
IN |
|
P_PK_ID |
NUMBER, m_used_values.pk_id |
IN |
|
P_ATTR_ID |
NUMBER, m_attrs.attr_id |
IN |
|
P_NLS_ID |
NUMBER, m_nls.nls_id |
IN |
|
P_COMMIT_IND |
VARCHAR2, default ‘Y’ |
IN |
The procedure inserts a record into m_used_values.
The following table shows the values that can be transferred with P_COL_ARR in the INS_UV procedure.
|
Column Name |
Mandatory |
Description |
|---|---|---|
|
COMPATTR_ATTR_VALUE |
Yes |
Used Value ID (NUMBER(12,0), m_used_values.uval_id) |