To start the delete project job, enter the project you want to delete. When the record in the M_PROJECTS table should also be deleted, set del_ind to Y. The record shown on the A.20.01.02 Project Information screen will also be removed.
The arguments of the DELETE_PROJ function are listed below.
Argument Name |
Type |
In/Out |
---|---|---|
P_PROJ |
Record, del_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 DELETE_PROJ function.
Column Name |
Mandatory |
Description |
---|---|---|
proj_id |
Yes |
Project (VARCHAR2(10), m_projects.proj_id) |
del_ind |
Yes |
VARCHAR2(1), Y or N |