APPS.PA_PROJECT_WF dependencies on PA_PROJECT_STATUSES

Line 179: pa_project_statuses ps

175: SELECT
176: ps.workflow_item_type,
177: ps.workflow_process
178: FROM pa_projects_all pap, -- Bug#3807805 : Modified pa_projects to pa_projects_all
179: pa_project_statuses ps
180: WHERE pap.project_id = l_project_id
181: AND pap.project_status_code = ps.project_status_code;
182:
183: l_get_projinfo_rec l_get_projinfo_csr%ROWTYPE;

Line 268: l_proj_stus_code PA_PROJECT_STATUSES.PROJECT_STATUS_CODE%TYPE;

264:
265: /* Bug 2345889 Part 1- Begin*/
266: l_resp_id NUMBER ;
267: l_project_approver_id NUMBER ;
268: l_proj_stus_code PA_PROJECT_STATUSES.PROJECT_STATUS_CODE%TYPE;
269: l_proj_system_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
270: l_proj_success_sys_sts_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
271:
272: CURSOR l_proj_system_status_csr(x_project_status_code PA_PROJECT_STATUSES.PROJECT_STATUS_CODE%TYPE) IS

Line 269: l_proj_system_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;

265: /* Bug 2345889 Part 1- Begin*/
266: l_resp_id NUMBER ;
267: l_project_approver_id NUMBER ;
268: l_proj_stus_code PA_PROJECT_STATUSES.PROJECT_STATUS_CODE%TYPE;
269: l_proj_system_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
270: l_proj_success_sys_sts_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
271:
272: CURSOR l_proj_system_status_csr(x_project_status_code PA_PROJECT_STATUSES.PROJECT_STATUS_CODE%TYPE) IS
273: SELECT project_system_status_code

Line 270: l_proj_success_sys_sts_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;

266: l_resp_id NUMBER ;
267: l_project_approver_id NUMBER ;
268: l_proj_stus_code PA_PROJECT_STATUSES.PROJECT_STATUS_CODE%TYPE;
269: l_proj_system_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
270: l_proj_success_sys_sts_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
271:
272: CURSOR l_proj_system_status_csr(x_project_status_code PA_PROJECT_STATUSES.PROJECT_STATUS_CODE%TYPE) IS
273: SELECT project_system_status_code
274: FROM pa_project_statuses

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

268: l_proj_stus_code PA_PROJECT_STATUSES.PROJECT_STATUS_CODE%TYPE;
269: l_proj_system_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
270: l_proj_success_sys_sts_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
271:
272: CURSOR l_proj_system_status_csr(x_project_status_code PA_PROJECT_STATUSES.PROJECT_STATUS_CODE%TYPE) IS
273: SELECT project_system_status_code
274: FROM pa_project_statuses
275: WHERE project_status_code = x_project_status_code;
276: /* Bug 2345889 Part 1- End*/

Line 274: FROM pa_project_statuses

270: l_proj_success_sys_sts_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
271:
272: CURSOR l_proj_system_status_csr(x_project_status_code PA_PROJECT_STATUSES.PROJECT_STATUS_CODE%TYPE) IS
273: SELECT project_system_status_code
274: FROM pa_project_statuses
275: WHERE project_status_code = x_project_status_code;
276: /* Bug 2345889 Part 1- End*/
277:
278: l_msg_count NUMBER :=0; /*Bug 3611598*/

Line 542: FROM pa_project_statuses pps

538: l_note VARCHAR2(2000);
539:
540: CURSOR cur_get_system_status(c_status_code IN VARCHAR2) IS
541: SELECT pps.project_system_status_code
542: FROM pa_project_statuses pps
543: WHERE pps.project_status_code = nvl(c_status_code,' ');
544:
545: BEGIN
546:

Line 680: FROM pa_project_statuses pps

676: l_proj_stus_code VARCHAR2(30);
677:
678: CURSOR cur_get_system_status(c_status_code IN VARCHAR2) IS
679: SELECT pps.project_system_status_code
680: FROM pa_project_statuses pps
681: WHERE pps.project_status_code = nvl(c_status_code,' ');
682:
683: BEGIN
684:

Line 868: FROM pa_project_statuses

864:
865: CURSOR l_proj_stus_csr IS
866: SELECT wf_success_status_code,
867: wf_failure_status_code
868: FROM pa_project_statuses
869: WHERE project_status_code = l_proj_stus_code;
870: BEGIN
871: x_err_code := 0;
872: x_success_proj_stus_code := NULL;