APPS.PA_PROJECT_WF dependencies on PA_PROJECT_STATUSES

Line 200: pa_project_statuses ps

196: SELECT
197: ps.workflow_item_type,
198: ps.workflow_process
199: FROM pa_projects_all pap, -- Bug#3807805 : Modified pa_projects to pa_projects_all
200: pa_project_statuses ps
201: WHERE pap.project_id = l_project_id
202: AND pap.project_status_code = ps.project_status_code;
203:
204: l_get_projinfo_rec l_get_projinfo_csr%ROWTYPE;

Line 289: l_proj_stus_code PA_PROJECT_STATUSES.PROJECT_STATUS_CODE%TYPE;

285:
286: /* Bug 2345889 Part 1- Begin*/
287: l_resp_id NUMBER ;
288: l_project_approver_id NUMBER ;
289: l_proj_stus_code PA_PROJECT_STATUSES.PROJECT_STATUS_CODE%TYPE;
290: l_proj_system_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
291: l_proj_success_sys_sts_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
292:
293: CURSOR l_proj_system_status_csr(x_project_status_code PA_PROJECT_STATUSES.PROJECT_STATUS_CODE%TYPE) IS

Line 290: l_proj_system_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;

286: /* Bug 2345889 Part 1- Begin*/
287: l_resp_id NUMBER ;
288: l_project_approver_id NUMBER ;
289: l_proj_stus_code PA_PROJECT_STATUSES.PROJECT_STATUS_CODE%TYPE;
290: l_proj_system_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
291: l_proj_success_sys_sts_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
292:
293: CURSOR l_proj_system_status_csr(x_project_status_code PA_PROJECT_STATUSES.PROJECT_STATUS_CODE%TYPE) IS
294: SELECT project_system_status_code

Line 291: l_proj_success_sys_sts_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;

287: l_resp_id NUMBER ;
288: l_project_approver_id NUMBER ;
289: l_proj_stus_code PA_PROJECT_STATUSES.PROJECT_STATUS_CODE%TYPE;
290: l_proj_system_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
291: l_proj_success_sys_sts_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
292:
293: CURSOR l_proj_system_status_csr(x_project_status_code PA_PROJECT_STATUSES.PROJECT_STATUS_CODE%TYPE) IS
294: SELECT project_system_status_code
295: FROM pa_project_statuses

Line 293: CURSOR l_proj_system_status_csr(x_project_status_code PA_PROJECT_STATUSES.PROJECT_STATUS_CODE%TYPE) IS

289: l_proj_stus_code PA_PROJECT_STATUSES.PROJECT_STATUS_CODE%TYPE;
290: l_proj_system_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
291: l_proj_success_sys_sts_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
292:
293: CURSOR l_proj_system_status_csr(x_project_status_code PA_PROJECT_STATUSES.PROJECT_STATUS_CODE%TYPE) IS
294: SELECT project_system_status_code
295: FROM pa_project_statuses
296: WHERE project_status_code = x_project_status_code;
297: /* Bug 2345889 Part 1- End*/

Line 295: FROM pa_project_statuses

291: l_proj_success_sys_sts_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
292:
293: CURSOR l_proj_system_status_csr(x_project_status_code PA_PROJECT_STATUSES.PROJECT_STATUS_CODE%TYPE) IS
294: SELECT project_system_status_code
295: FROM pa_project_statuses
296: WHERE project_status_code = x_project_status_code;
297: /* Bug 2345889 Part 1- End*/
298:
299: l_msg_count NUMBER :=0; /*Bug 3611598*/

Line 564: FROM pa_project_statuses pps

560: l_note VARCHAR2(2000);
561:
562: CURSOR cur_get_system_status(c_status_code IN VARCHAR2) IS
563: SELECT pps.project_system_status_code
564: FROM pa_project_statuses pps
565: WHERE pps.project_status_code = nvl(c_status_code,' ');
566:
567: BEGIN
568:

Line 702: FROM pa_project_statuses pps

698: l_proj_stus_code VARCHAR2(30);
699:
700: CURSOR cur_get_system_status(c_status_code IN VARCHAR2) IS
701: SELECT pps.project_system_status_code
702: FROM pa_project_statuses pps
703: WHERE pps.project_status_code = nvl(c_status_code,' ');
704:
705: BEGIN
706:

Line 893: FROM pa_project_statuses

889:
890: CURSOR l_proj_stus_csr IS
891: SELECT wf_success_status_code,
892: wf_failure_status_code
893: FROM pa_project_statuses
894: WHERE project_status_code = l_proj_stus_code;
895: BEGIN
896: x_err_code := 0;
897: x_success_proj_stus_code := NULL;