APPS.AHL_PRD_WORKORDER_CUHK SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 107

PROCEDURE  UPDATE_JOB_PRE
(
 p_prd_workorder_rec					  IN  AHL_PRD_WORKORDER_PVT.prd_workorder_rec,
 p_prd_workoper_tbl						  IN  AHL_PRD_WORKORDER_PVT.prd_workoper_tbl,
 x_return_status                OUT NOCOPY VARCHAR2,
 x_msg_count                    OUT NOCOPY NUMBER,
 x_msg_data                     OUT NOCOPY VARCHAR2)

IS
    l_api_name          VARCHAR2(30) := 'update_job_pre';

Line: 154

End UPDATE_JOB_PRE ;

Line: 158

PROCEDURE UPDATE_JOB_POST
(
 p_prd_workorder_rec				  	IN  AHL_PRD_WORKORDER_PVT.prd_workorder_rec,
 p_prd_workoper_tbl					  	IN  AHL_PRD_WORKORDER_PVT.prd_workoper_tbl,
 x_return_status                OUT NOCOPY VARCHAR2,
 x_msg_count                    OUT NOCOPY NUMBER,
 x_msg_data                     OUT NOCOPY VARCHAR2)
IS
    l_api_name          VARCHAR2(30) := 'update_job_post';

Line: 204

End UPDATE_JOB_POST;