eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PA_PROJECT_WF dependencies on FND_GLOBAL

Line 365: FND_GLOBAL.Apps_Initialize

361:
362: /* Adding the following check so that if approver is not null then user_id
363: should be set as the approver_id and not as workflow_started_by_id */
364: IF l_project_approver_id is NOT NULL THEN
365: FND_GLOBAL.Apps_Initialize
366: ( user_id => l_project_approver_id
367: , resp_id => l_resp_id
368: , resp_appl_id => pa_workflow_utils.get_application_id(l_resp_id)
369: );

Line 435: last_updated_by = fnd_global.user_id,

431: SET project_status_code = l_success_status_code,
432: wf_status_code = 'IN_ROUTE',
433: closed_date = sysdate,
434: last_update_date = sysdate,
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 */

Line 436: last_update_login = fnd_global.login_id

432: wf_status_code = 'IN_ROUTE',
433: closed_date = sysdate,
434: last_update_date = sysdate,
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,

Line 443: last_updated_by = fnd_global.user_id,

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,
444: last_update_login = fnd_global.login_id
445: WHERE project_id = l_project_id;
446: END IF;
447: ELSE

Line 444: last_update_login = fnd_global.login_id

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,
444: last_update_login = fnd_global.login_id
445: WHERE project_id = l_project_id;
446: END IF;
447: ELSE
448: IF l_proj_success_sys_sts_code = 'CLOSED' THEN

Line 453: last_updated_by = fnd_global.user_id,

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,
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 */

Line 454: last_update_login = fnd_global.login_id

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,
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,

Line 462: last_updated_by = fnd_global.user_id,

458: SET project_status_code = l_success_status_code,
459: wf_status_code = 'IN_ROUTE',
460: closed_date = null,
461: last_update_date = sysdate,
462: last_updated_by = fnd_global.user_id,
463: last_update_login = fnd_global.login_id
464: WHERE project_id = l_project_id;
465: END IF;
466: END IF;

Line 463: last_update_login = fnd_global.login_id

459: wf_status_code = 'IN_ROUTE',
460: closed_date = null,
461: last_update_date = sysdate,
462: last_updated_by = fnd_global.user_id,
463: last_update_login = fnd_global.login_id
464: WHERE project_id = l_project_id;
465: END IF;
466: END IF;
467: /* Bug 2345889 Part-3 End*/

Line 491: last_updated_by = fnd_global.user_id,

487: SET project_status_code = l_success_status_code,
488: wf_status_code = NULL,
489: closed_date = sysdate,
490: last_update_date = sysdate,
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 */

Line 492: last_update_login = fnd_global.login_id

488: wf_status_code = NULL,
489: closed_date = sysdate,
490: last_update_date = sysdate,
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,

Line 500: last_updated_by = fnd_global.user_id,

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,
500: last_updated_by = fnd_global.user_id,
501: last_update_login = fnd_global.login_id
502: WHERE project_id = l_project_id;
503: END IF;
504: ELSE

Line 501: last_update_login = fnd_global.login_id

497: wf_status_code = NULL,
498: closed_date = null, --bug#8586702
499: last_update_date = sysdate,
500: last_updated_by = fnd_global.user_id,
501: last_update_login = fnd_global.login_id
502: WHERE project_id = l_project_id;
503: END IF;
504: ELSE
505: IF l_proj_success_sys_sts_code = 'CLOSED' THEN

Line 510: last_updated_by = fnd_global.user_id,

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,
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 */

Line 511: last_update_login = fnd_global.login_id

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,
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,

Line 519: last_updated_by = fnd_global.user_id,

515: SET project_status_code = l_success_status_code,
516: wf_status_code = NULL,
517: closed_date = null,
518: last_update_date = sysdate,
519: last_updated_by = fnd_global.user_id,
520: last_update_login = fnd_global.login_id
521: WHERE project_id = l_project_id;
522: END IF;
523: END IF;

Line 520: last_update_login = fnd_global.login_id

516: wf_status_code = NULL,
517: closed_date = null,
518: last_update_date = sysdate,
519: last_updated_by = fnd_global.user_id,
520: last_update_login = fnd_global.login_id
521: WHERE project_id = l_project_id;
522: END IF;
523: END IF;
524: /* Bug 2345889 Part-4 End*/

Line 596: X_LAST_UPDATED_BY => fnd_global.user_id,

592: X_NEW_PROJECT_SYSTEM_STATUS_CO => l_new_sys_status,
593: X_OLD_PROJECT_STATUS_CODE => l_proj_stus_code,
594: X_OLD_PROJECT_SYSTEM_STATUS_CO => l_old_sys_status,
595: X_CHANGE_COMMENT => l_note,
596: X_LAST_UPDATED_BY => fnd_global.user_id,
597: X_CREATED_BY => fnd_global.user_id,
598: X_CREATION_DATE => sysdate,
599: X_LAST_UPDATE_DATE => sysdate,
600: X_LAST_UPDATE_LOGIN => fnd_global.user_id);

Line 597: X_CREATED_BY => fnd_global.user_id,

593: X_OLD_PROJECT_STATUS_CODE => l_proj_stus_code,
594: X_OLD_PROJECT_SYSTEM_STATUS_CO => l_old_sys_status,
595: X_CHANGE_COMMENT => l_note,
596: X_LAST_UPDATED_BY => fnd_global.user_id,
597: X_CREATED_BY => fnd_global.user_id,
598: X_CREATION_DATE => sysdate,
599: X_LAST_UPDATE_DATE => sysdate,
600: X_LAST_UPDATE_LOGIN => fnd_global.user_id);
601:

Line 600: X_LAST_UPDATE_LOGIN => fnd_global.user_id);

596: X_LAST_UPDATED_BY => fnd_global.user_id,
597: X_CREATED_BY => fnd_global.user_id,
598: X_CREATION_DATE => sysdate,
599: X_LAST_UPDATE_DATE => sysdate,
600: X_LAST_UPDATE_LOGIN => fnd_global.user_id);
601:
602: END;
603: /* End of code for 7299466*/
604:

Line 738: X_LAST_UPDATED_BY => fnd_global.user_id,

734: X_NEW_PROJECT_SYSTEM_STATUS_CO => l_new_sys_status,
735: X_OLD_PROJECT_STATUS_CODE => l_proj_stus_code,
736: X_OLD_PROJECT_SYSTEM_STATUS_CO => l_old_sys_status,
737: X_CHANGE_COMMENT => l_note,
738: X_LAST_UPDATED_BY => fnd_global.user_id,
739: X_CREATED_BY => fnd_global.user_id,
740: X_CREATION_DATE => sysdate,
741: X_LAST_UPDATE_DATE => sysdate,
742: X_LAST_UPDATE_LOGIN => fnd_global.user_id);

Line 739: X_CREATED_BY => fnd_global.user_id,

735: X_OLD_PROJECT_STATUS_CODE => l_proj_stus_code,
736: X_OLD_PROJECT_SYSTEM_STATUS_CO => l_old_sys_status,
737: X_CHANGE_COMMENT => l_note,
738: X_LAST_UPDATED_BY => fnd_global.user_id,
739: X_CREATED_BY => fnd_global.user_id,
740: X_CREATION_DATE => sysdate,
741: X_LAST_UPDATE_DATE => sysdate,
742: X_LAST_UPDATE_LOGIN => fnd_global.user_id);
743:

Line 742: X_LAST_UPDATE_LOGIN => fnd_global.user_id);

738: X_LAST_UPDATED_BY => fnd_global.user_id,
739: X_CREATED_BY => fnd_global.user_id,
740: X_CREATION_DATE => sysdate,
741: X_LAST_UPDATE_DATE => sysdate,
742: X_LAST_UPDATE_LOGIN => fnd_global.user_id);
743:
744: END;
745: /* End of code for 7299466*/
746:

Line 862: last_updated_by = fnd_global.user_id,

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,
863: last_update_login = fnd_global.login_id
864: WHERE project_id = x_project_id;
865:
866: END IF;

Line 863: last_update_login = fnd_global.login_id

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,
863: last_update_login = fnd_global.login_id
864: WHERE project_id = x_project_id;
865:
866: END IF;
867: IF x_populate_msg_yn = 'Y' THEN