To update communication links, use the UPD_COMMLINKS procedure.
The arguments of UPD_COMMLINKS 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_CL_ID |
NUMBER, m_communication_links.cl_id |
OUT |
P_CCP_ID |
NUMBER, m_company_contact_people.ccp_id |
IN |
P_CA_ID |
NUMBER, m_company_addrs.ca_id |
IN |
P_COMMIT_IND |
VARCHAR2, default ‘Y’ |
IN |
P_CL_FOR |
VARCHAR2, default ‘COMMLINKS’ |
IN |
The procedure calls check routines for all columns to be updated prior to performing the actual update of table m_communication_links. When all checks succeed, the procedure updates a record in m_communication_links.
The following table shows the values that can be updated with the UPD_COMMLINKS procedure.
Column Name |
Mandatory |
Description |
---|---|---|
ADDRESS_VALUE |
No |
Address Value (VARCHAR2(500), m_communication_links.address_value) |
DEFAULT_IND |
Yes |
Default indicator (VARCHAR2(1), m_communication_links.default_ind) |