To add a new manufacturer to a supplier, enter all mandatory values.
The arguments of the INS_SUPMANU 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_SM_ID |
NUMBER, m_supplier_manufacturers.sm_id |
OUT |
P_SUP_ID |
NUMBER, m_suppliers.sup_id |
IN |
P_COMMIT_IND |
VARCHAR2, default ‘Y’ |
IN |
The procedure inserts a record into m_supplier_manufacturers.
The following table shows the values that can be transferred with P_COL_ARR in the INS_SUPMANU procedure.
Column Name |
Mandatory |
Description |
---|---|---|
CT_CODE |
Yes |
Company Type ID (NUMBER(12,0), m_supplier_manufacturers.ct_id) |
COMPANY_CODE |
Yes |
Company ID (NUMBER(12,0), m_supplier_manufacturers.company_id) |