APPS.PA_WORKPLAN_WORKFLOW dependencies on PA_PROJECTS_ALL

Line 721: p_project_id IN pa_projects_all.project_id%TYPE --changed type from varchar to column type 3619185 Satish

717:
718: -- FP M : Project Execution Workflow
719: PROCEDURE START_PROJECT_EXECUTION_WF
720: (
721: p_project_id IN pa_projects_all.project_id%TYPE --changed type from varchar to column type 3619185 Satish
722: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
723: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
724: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
725: )

Line 740: from pa_projects_all

736:
737: CURSOR proj_number
738: IS
739: SELECT segment1
740: from pa_projects_all
741: where project_id = p_project_id ;
742:
743: -- 5369295 for pqe bug5366726 , added to_char function call for p_project_id passed parameter
744: CURSOR is_wf_running

Line 875: p_project_id IN pa_projects_all.project_id%TYPE --changed type from varchar to column type 3619185 Satish

871: END START_PROJECT_EXECUTION_WF ;
872:
873: PROCEDURE CANCEL_PROJECT_EXECUTION_WF
874: (
875: p_project_id IN pa_projects_all.project_id%TYPE --changed type from varchar to column type 3619185 Satish
876: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
877: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
878: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
879: )

Line 1295: FROM pa_projects_all pa ,

1291: IS
1292: CURSOR proj_status_cur(c_project_id in number)
1293: IS
1294: SELECT pst.project_system_status_code
1295: FROM pa_projects_all pa ,
1296: pa_project_statuses pst
1297: WHERE pa.project_id = c_project_id
1298: AND pa.project_status_code = pst.project_status_code;
1299: