APPS.PA_PROJECT_WF dependencies on PA_PROJECTS_ALL

Line 178: FROM pa_projects_all pap, -- Bug#3807805 : Modified pa_projects to pa_projects_all

174: CURSOR l_get_projinfo_csr (l_project_id IN NUMBER) IS
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:

Line 283: CURSOR c_project_details(p_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE) IS

279: l_return_status VARCHAR2(2000);
280:
281: -- 3671408 added cursor to retrieve project number
282:
283: CURSOR c_project_details(p_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE) IS
284: SELECT segment1
285: FROM PA_PROJECTS_ALL
286: WHERE PROJECT_ID = p_project_id;
287:

Line 285: FROM PA_PROJECTS_ALL

281: -- 3671408 added cursor to retrieve project number
282:
283: CURSOR c_project_details(p_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE) IS
284: SELECT segment1
285: FROM PA_PROJECTS_ALL
286: WHERE PROJECT_ID = p_project_id;
287:
288: l_project_number pa_projects_all.segment1%type;
289:

Line 288: l_project_number pa_projects_all.segment1%type;

284: SELECT segment1
285: FROM PA_PROJECTS_ALL
286: WHERE PROJECT_ID = p_project_id;
287:
288: l_project_number pa_projects_all.segment1%type;
289:
290: BEGIN
291:
292: --

Line 409: UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */

405: */
406:
407: IF l_proj_system_status_code <> 'CLOSED' THEN
408: IF l_proj_success_sys_sts_code = 'CLOSED' THEN
409: UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
410: SET project_status_code = l_success_status_code,
411: wf_status_code = 'IN_ROUTE',
412: closed_date = sysdate,
413: last_update_date = sysdate,

Line 418: UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */

414: last_updated_by = fnd_global.user_id,
415: last_update_login = fnd_global.login_id
416: WHERE project_id = l_project_id;
417: ELSE
418: UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
419: SET project_status_code = l_success_status_code,
420: wf_status_code = 'IN_ROUTE',
421: last_update_date = sysdate,
422: last_updated_by = fnd_global.user_id,

Line 428: UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */

424: WHERE project_id = l_project_id;
425: END IF;
426: ELSE
427: IF l_proj_success_sys_sts_code = 'CLOSED' THEN
428: UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
429: SET project_status_code = l_success_status_code,
430: wf_status_code = 'IN_ROUTE',
431: last_update_date = sysdate,
432: last_updated_by = fnd_global.user_id,

Line 436: UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */

432: last_updated_by = fnd_global.user_id,
433: last_update_login = fnd_global.login_id
434: WHERE project_id = l_project_id;
435: ELSE
436: UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
437: SET project_status_code = l_success_status_code,
438: wf_status_code = 'IN_ROUTE',
439: closed_date = null,
440: last_update_date = sysdate,

Line 465: UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */

461: WHERE project_id = l_project_id;
462: */
463: IF l_proj_system_status_code <> 'CLOSED' THEN
464: IF l_proj_success_sys_sts_code = 'CLOSED' THEN
465: UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
466: SET project_status_code = l_success_status_code,
467: wf_status_code = NULL,
468: closed_date = sysdate,
469: last_update_date = sysdate,

Line 474: UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */

470: last_updated_by = fnd_global.user_id,
471: last_update_login = fnd_global.login_id
472: WHERE project_id = l_project_id;
473: ELSE
474: UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
475: SET project_status_code = l_success_status_code,
476: wf_status_code = NULL,
477: last_update_date = sysdate,
478: last_updated_by = fnd_global.user_id,

Line 484: UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */

480: WHERE project_id = l_project_id;
481: END IF;
482: ELSE
483: IF l_proj_success_sys_sts_code = 'CLOSED' THEN
484: UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
485: SET project_status_code = l_success_status_code,
486: wf_status_code = NULL,
487: last_update_date = sysdate,
488: last_updated_by = fnd_global.user_id,

Line 492: UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */

488: last_updated_by = fnd_global.user_id,
489: last_update_login = fnd_global.login_id
490: WHERE project_id = l_project_id;
491: ELSE
492: UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
493: SET project_status_code = l_success_status_code,
494: wf_status_code = NULL,
495: closed_date = null,
496: last_update_date = sysdate,

Line 836: UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */

832: x_err_code OUT NOCOPY NUMBER ) IS --File.Sql.39 bug 4440895
833: BEGIN
834: x_err_code := 0;
835: IF x_update_db_yn = 'Y' THEN
836: UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
837: SET project_status_code = x_failure_status_code,
838: Wf_Status_code = NULL
839: WHERE project_id = x_project_id;
840:

Line 932: SELECT * FROM pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */

928: l_err_stage VARCHAR2(2000);
929:
930:
931: CURSOR l_project_csr IS
932: SELECT * FROM pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
933: WHERE project_id = x_project_id;
934: l_project_rec l_project_csr%ROWTYPE;
935:
936: BEGIN