To create a new company description, enter all mandatory values.
The arguments of the INS_NLS procedure 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 inserts a record into m_company_nls.
The following table shows the values that can be transferred with P_COL_ARR in the INS_NLS procedure.
Column Name |
Mandatory |
Description |
---|---|---|
NLS_ID |
Yes |
Language ID (NUMBER(2), m_company_nls.nls_id) |
SHORT_DESC |
Yes |
Short Description (VARCHAR2(20), m_company_nls.short_desc) |
DESCRIPTION |
Yes |
Description (VARCHAR2(255), m_company_nls.description) |