The arguments of the UPDATE_US function are listed below.
Argument Name |
Type |
In/Out |
---|---|---|
P_US |
Record, us_upd_rec |
IN |
P_PROJ_ID |
VARCHAR2(10), m_projects.proj_id |
IN |
P_COMMIT |
VARCHAR2 |
IN |
P_RESULT |
NUMBER |
OUT |
P_MESSAGE |
VARCHAR2 |
OUT |
The function returns the m_user_securities.us_id.
The following table shows the values that can be transferred with P_US in the UPDATE_US function.
Column Name |
Mandatory |
Description |
---|---|---|
us_id |
Yes |
User Security Identifier (NUMBER(12), m_user_securities.us_id) |
pg_code |
No |
Product Group (VARCHAR2(10), m_product_groups.pg_code) |
proj_id |
No |
Project (VARCHAR2(10), m_projects.proj_id) |
user_id |
No |
Username (VARCHAR2(10), m_users.m_usr_id) |
dp_code |
No |
Discipline (VARCHAR2(10), m_disciplines.dp_code) |
nls_id |
No |
Language Identifier (NUMBER(2), m_nls.nls_id) |
aktiv |
No |
Active (VARCHAR2(3), m_user_securities.aktiv, default 'ON') |
role_name |
No |
Role Name (VARCHAR2(20), m_appl_roles.role_name) |
list_view |
No |
List View (VARCHAR2(10), m_list_views.lv_code) |
sec_code |
No |
Section (VARCHAR2(10), m_sections.sec_code) |
api_ind |
No |
Use for APIs (VARCHAR2(1), m_user_securities.api_ind) |