To create a new company address, enter all mandatory values.
The arguments of the INS_COMPANY_ADDRS 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_CA_ID |
NUMBER, m_company_addrs.ca_id |
OUT |
P_COMPANY_ID |
NUMBER, m_companies.company_id |
IN |
P_ADDRESS_TYPE_ID |
NUMBER, m_company_addrs.address_type_id |
IN |
P_CY_ID |
NUMBER, m_company_addrs.cy_id |
IN |
P_STPR_ID |
NUMBER, m_company_addrs.stpr_id |
IN |
P_COMMIT_IND |
VARCHAR2, default ‘Y’ |
IN |
The procedure inserts a record into m_company_addrs.
The following table shows the values that can be transferred with P_COL_ARR in the INS_COMPANY_ADDRS procedure.
Column Name |
Mandatory |
Description |
---|---|---|
COMPANY_CODE |
Yes |
Company ID (NUMBER(12), m_company_addrs.company_id) |
ADDRESS_TYPE_CODE |
No |
Address Type ID (NUMBER(12), m_company_addrs.address_type_id) |
CY_CODE |
Yes |
Country ID (NUMBER(12), m_company_addrs.cy_id |
CITY |
Yes |
City (VARCHAR2(80), m_company_addrs.city) |
STPR_CODE |
No |
State or Province (NUMBER(12), m_company_addrs.stpr_id) |
ADDR1 |
No |
Address1 (VARCHAR2(80), m_company_addrs.addr1) |
ADDR2 |
No |
Address2 (VARCHAR2(80), m_company_addrs.addr2) |
POSTAL_CODE |
No |
Zip or Postal Code (VARCHAR2(12), m_company_addrs.postal_code) |