The create project procedure gathers all the information needed to set up a project.
The create project procedure will create a log file called CR_PROJ_<sequence>.log, where <sequence> is a sequential number.
After the procedure is successfully completed, the new project is available in Smart Materials with the specified name for the specified user. You can check the created data on the A.20.01.02 Project Information screen.
The arguments of the CREATE_PROJ function are listed below.
Argument Name |
Type |
In/Out |
---|---|---|
P_PROJ |
Record, proj_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_projects.proj_id.
The following table shows the values that can be transferred with P_PROJ in the CREATE_PROJ function.
Column Name |
Mandatory |
Description |
---|---|---|
proj_id |
Yes |
Project (VARCHAR2(10), m_projects.proj_id) |
description |
No |
Project Description (VARCHAR2(60), m_projects.description) |
plain_passwd |
Yes |
Project Password (VARCHAR2(100), plain_passwd) |
user_id |
Yes |
Username (VARCHAR2(10), m_users.m_usr_id) |
def_pg_code |
Yes |
Product Group (VARCHAR2(10), m_product_groups.pg_code) |
pgr_code |
Yes |
Project Group (VARCHAR2(10), m_project_groups.pgr_code) |
dp_code |
Yes |
Discipline (VARCHAR2(m_disciplines.dp_code) |
nls_id |
Yes |
Language Identifier (NUMBER(12), m_nls.nls_id) |
role_name |
Yes |
Role Name (VARCHAR2(10), m_appl_roles.role_name) |
aktiv |
Yes |
Active (VARCHAR2(3), m_user_securities.aktiv) |
list_view |
No |
List View (VARCHAR2(10), m_list_views.lv_code) |
pp_ind |
No |
Proposal Project (VARCHAR2(1), m_projects.pp_ind) |