APPS.PA_PROJECT_WF dependencies on PA_PROJECTS_ALL

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

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

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

300: l_return_status VARCHAR2(2000);
301:
302: -- 3671408 added cursor to retrieve project number
303:
304: CURSOR c_project_details(p_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE) IS
305: SELECT segment1
306: FROM PA_PROJECTS_ALL
307: WHERE PROJECT_ID = p_project_id;
308:

Line 306: FROM PA_PROJECTS_ALL

302: -- 3671408 added cursor to retrieve project number
303:
304: CURSOR c_project_details(p_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE) IS
305: SELECT segment1
306: FROM PA_PROJECTS_ALL
307: WHERE PROJECT_ID = p_project_id;
308:
309: l_project_number pa_projects_all.segment1%type;
310:

Line 309: l_project_number pa_projects_all.segment1%type;

305: SELECT segment1
306: FROM PA_PROJECTS_ALL
307: WHERE PROJECT_ID = p_project_id;
308:
309: l_project_number pa_projects_all.segment1%type;
310:
311: BEGIN
312:
313: --

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

426: */
427:
428: IF l_proj_system_status_code <> 'CLOSED' THEN
429: IF l_proj_success_sys_sts_code = 'CLOSED' THEN
430: UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
431: SET project_status_code = l_success_status_code,
432: wf_status_code = 'IN_ROUTE',
433: closed_date = sysdate,
434: last_update_date = sysdate,

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

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

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

445: WHERE project_id = l_project_id;
446: END IF;
447: ELSE
448: IF l_proj_success_sys_sts_code = 'CLOSED' THEN
449: UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
450: SET project_status_code = l_success_status_code,
451: wf_status_code = 'IN_ROUTE',
452: last_update_date = sysdate,
453: last_updated_by = fnd_global.user_id,

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

453: last_updated_by = fnd_global.user_id,
454: last_update_login = fnd_global.login_id
455: WHERE project_id = l_project_id;
456: ELSE
457: UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
458: SET project_status_code = l_success_status_code,
459: wf_status_code = 'IN_ROUTE',
460: closed_date = null,
461: last_update_date = sysdate,

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

482: WHERE project_id = l_project_id;
483: */
484: IF l_proj_system_status_code <> 'CLOSED' THEN
485: IF l_proj_success_sys_sts_code = 'CLOSED' THEN
486: UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
487: SET project_status_code = l_success_status_code,
488: wf_status_code = NULL,
489: closed_date = sysdate,
490: last_update_date = sysdate,

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

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

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

502: WHERE project_id = l_project_id;
503: END IF;
504: ELSE
505: IF l_proj_success_sys_sts_code = 'CLOSED' THEN
506: UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
507: SET project_status_code = l_success_status_code,
508: wf_status_code = NULL,
509: last_update_date = sysdate,
510: last_updated_by = fnd_global.user_id,

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

510: last_updated_by = fnd_global.user_id,
511: last_update_login = fnd_global.login_id
512: WHERE project_id = l_project_id;
513: ELSE
514: UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
515: SET project_status_code = l_success_status_code,
516: wf_status_code = NULL,
517: closed_date = null,
518: last_update_date = sysdate,

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

854: x_err_code OUT NOCOPY NUMBER ) IS --File.Sql.39 bug 4440895
855: BEGIN
856: x_err_code := 0;
857: IF x_update_db_yn = 'Y' THEN
858: UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
859: SET project_status_code = x_failure_status_code,
860: Wf_Status_code = NULL,
861: last_update_date = sysdate, -- added who columns for bug 16243557
862: last_updated_by = fnd_global.user_id,

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

953: l_err_stage VARCHAR2(2000);
954:
955:
956: CURSOR l_project_csr IS
957: SELECT * FROM pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
958: WHERE project_id = x_project_id;
959: l_project_rec l_project_csr%ROWTYPE;
960:
961: BEGIN