To create a new company contact, enter all mandatory values.
The arguments of the INS_COMPANY_CONTACT 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_CCP_ID |
NUMBER, m_company_contact_people.ccp_id |
OUT |
|
P_COMPANY_ID |
NUMBER, m_companies.company_id |
IN |
|
P_COMMIT_IND |
VARCHAR2, default ‘Y’ |
IN |
The procedure inserts a record into m_company_contact_people.
The following table shows the values that can be transferred with P_COL_ARR in the INS_COMPANY_CONTACT procedure.
|
Column Name |
Mandatory |
Description |
|---|---|---|
|
COMPANY_CODE |
Yes |
Company ID (NUMBER(12), m_company_contact_people.company_id) |
|
CCP_CODE |
Yes |
Employee (VARCHAR2(10), m_company_contact_people.ccp_code) |
|
FIRST_NAME |
Yes |
First Name (VARCHAR2(30), m_company_contact_people.first_name) |
|
LAST_NAME |
Yes |
Last Name (VARCHAR2(30), m_company_contact_people.last_name) |
|
COMMENTS |
No |
Last Name (VARCHAR2(60), m_company_contact_people.comments) |
|
DEPARTMENT |
No |
Last Name (VARCHAR2(30), m_company_contact_people.department) |
|
TELEPHONE |
No |
Last Name (VARCHAR2(30), m_company_contact_people.telephone) |
|
POSITION |
No |
Last Name (VARCHAR2(35), m_company_contact_people.position) |
|
DEFAULT_SUP_IND |
Yes |
Default Indicator (VARCHAR2(1), m_company_contact_people.default_sup_ind) |