To update supplier data, use the UPD_SUP procedure.
The arguments of UPD_SUP are listed below.
|
Argument Name |
Type |
In/Out |
|---|---|---|
|
P_US_ID |
NUMBER, m_user_securities.us_id |
IN |
|
P_SUP_ID |
NUMBER, m_suppliers.sup_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_suppliers. When all checks succeed, the procedure updates a record in m_suppliers.
The following table shows the values that can be updated with the UPD_SUP procedure.
|
Column Name |
Mandatory |
Description |
|---|---|---|
|
SUP_CODE |
Yes |
Supplier Name (VARCHAR2(20), m_suppliers_sup_code) |
|
COMPANY_CODE |
Yes |
Company ID (NUMBER(12,0), m_suppliers.company_id) |
|
CT_CODE |
Yes |
Company Type ID (NUMBER(12,0), m_suppliers.ct_id) |
|
CURRENCY |
Yes |
Currency ID (NUMBER(12,0), m_suppliers.currency_id) |
|
PO_SALES_LIMIT |
Yes |
PO Sales Limit (NUMBER(15,4), m_suppliers.po_sales_limit) |
|
EDI_IND |
Yes |
Use EDI (VARCHAR2(1), m_suppliers.edi_ind) |
|
APPROVED_IND |
Yes |
Approved (VARCHAR2(1), m_suppliers.approved_ind) |
|
SECRECY_AGREEMENT_IND |
Yes |
Secrecy Agreement (VARCHAR2(1), m_suppliers.secrecy_agreement_ind) |
|
VRT_CODE |
No |
Vendor Rating Type (NUMBER(12,0), m_vr_types.vrt_id) |
|
VR_CODE |
No |
Vendor Rating (NUMBER(12,0), m_suppliers.vr_id) |
|
DTM_CODE |
No |
Data Transfer Medium ID (NUMBER(12,0), m_suppliers.dtm_id) |
|
CY_CODE |
No |
Country ID (NUMBER(12,0), m_suppliers.cy_id) |
|
SUPPLIER_ACCOUNT_CODE |
No |
Budget Code (VARCHAR2(10), m_suppliers.supplier_account_code) |
|
TAX_ID |
No |
Tax Id (VARCHAR2(40), m_suppliers.tax_id) |
|
COMMERCIAL_REGISTRATION |
No |
Commercial Registration (VARCHAR2(15), m_suppliers.commercial_registration) |
|
NEAREST_PORT_OF_EXIT |
No |
Port of Exit (VARCHAR2(30), m_suppliers.nearest_port_of_exit) |
|
APPROVED_DATE |
No |
Approved Date (DATE, m_suppliers.approved_date) |
|
BID_TARGET |
No |
Medium Value (VARCHAR2(80), m_suppliers.bid_target) |
|
RFQ_EMAIL_IND |
Yes |
RFQ Email (VARCHAR2(1), m_suppliers.rfq_email_ind) |
|
ALLOWED_IND |
Yes |
Allowed for (VARCHAR2(1), m_suppliers.allowed_ind) |
|
PROJECT_SUP |
No |
Project (VARCHAR2(10), m_suppliers.project_id) |