To update qualifications, use the UPD_SUPQUALI procedure.
The arguments of UPD_SUPQUALI are listed below.
|
Argument Name |
Type |
In/Out |
|---|---|---|
|
P_US_ID |
NUMBER, m_user_securities.us_id |
IN |
|
P_SQ_ID |
NUMBER, m_sup_qualifications.sq_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_qualifications. When all checks succeed, the procedure updates a record in m_sup_qualifications.
The following table shows the values that can be updated with the UPD_SUPQUALI procedure.
|
Column Name |
Mandatory |
Description |
|---|---|---|
|
QUALI_SEQ_ID |
Yes |
Qualification ID (NUMBER(12,0), m_qualifications.order_seq) |
|
QUALI_REV_ID |
Yes |
Supplier ID (NUMBER(12,0), m_qualifications.revision_id) |
|
QUALIFICATION_RESPONSE_IND |
Yes |
Qualified (VARCHAR2(1), m_sup_qualifications.quallification_response_ind) |
|
DATE_QUALIFIED |
No |
Date Qualified (DATE), m_sup_qualifications.date_qualified) |
|
EXPLANTION_TEXT |
No |
Explanation Text (VARCHAR2(2000), m_sup_qualifications.explanation_text) |
|
QUALIFICATION_EXPIRE_DATE |
No |
Expiration (DATE), m_sup_qualifications.qualification_expire_date) |