To update company data, use the UPD_COMPANY procedure.
The arguments of UPD_COMPANY are listed below.
Argument Name |
Type |
In/Out |
---|---|---|
P_US_ID |
NUMBER, m_user_securities.us_id |
IN |
P_COMPANY_ID |
NUMBER, m_companies.company_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_companies. When all checks succeed, the procedure updates a record in m_companies.
The following table shows the values that can be updated with the UPD_COMPANY procedure.
Column Name |
Mandatory |
Description |
---|---|---|
COMPANY_CODE |
Yes |
Company Code (VARCHAR2(20), m_companies.company_code) |
COMPANY_NAME |
Yes |
Company Name (VARCHAR2(80), m_companies.company_name) |
PROJECT_CONTEXT |
No |
Project Context (VARCHAR2(20), m_companies.project_context) |
KEY_WORD |
No |
Key Word (VARCHAR2(2000), m_companies.company_key_word) |