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 344: FND_GLOBAL.Apps_Initialize

340:
341: /* Adding the following check so that if approver is not null then user_id
342: should be set as the approver_id and not as workflow_started_by_id */
343: IF l_project_approver_id is NOT NULL THEN
344: FND_GLOBAL.Apps_Initialize
345: ( user_id => l_project_approver_id
346: , resp_id => l_resp_id
347: , resp_appl_id => pa_workflow_utils.get_application_id(l_resp_id)
348: );

Line 414: last_updated_by = fnd_global.user_id,

410: SET project_status_code = l_success_status_code,
411: wf_status_code = 'IN_ROUTE',
412: closed_date = sysdate,
413: last_update_date = sysdate,
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 */

Line 415: last_update_login = fnd_global.login_id

411: wf_status_code = 'IN_ROUTE',
412: closed_date = sysdate,
413: last_update_date = sysdate,
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,

Line 422: last_updated_by = fnd_global.user_id,

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,
423: last_update_login = fnd_global.login_id
424: WHERE project_id = l_project_id;
425: END IF;
426: ELSE

Line 423: last_update_login = fnd_global.login_id

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,
423: last_update_login = fnd_global.login_id
424: WHERE project_id = l_project_id;
425: END IF;
426: ELSE
427: IF l_proj_success_sys_sts_code = 'CLOSED' THEN

Line 432: last_updated_by = fnd_global.user_id,

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

Line 433: last_update_login = fnd_global.login_id

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

Line 441: last_updated_by = fnd_global.user_id,

437: SET project_status_code = l_success_status_code,
438: wf_status_code = 'IN_ROUTE',
439: closed_date = null,
440: last_update_date = sysdate,
441: last_updated_by = fnd_global.user_id,
442: last_update_login = fnd_global.login_id
443: WHERE project_id = l_project_id;
444: END IF;
445: END IF;

Line 442: last_update_login = fnd_global.login_id

438: wf_status_code = 'IN_ROUTE',
439: closed_date = null,
440: last_update_date = sysdate,
441: last_updated_by = fnd_global.user_id,
442: last_update_login = fnd_global.login_id
443: WHERE project_id = l_project_id;
444: END IF;
445: END IF;
446: /* Bug 2345889 Part-3 End*/

Line 470: last_updated_by = fnd_global.user_id,

466: SET project_status_code = l_success_status_code,
467: wf_status_code = NULL,
468: closed_date = sysdate,
469: last_update_date = sysdate,
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 */

Line 471: last_update_login = fnd_global.login_id

467: wf_status_code = NULL,
468: closed_date = sysdate,
469: last_update_date = sysdate,
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,

Line 478: last_updated_by = fnd_global.user_id,

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,
479: last_update_login = fnd_global.login_id
480: WHERE project_id = l_project_id;
481: END IF;
482: ELSE

Line 479: last_update_login = fnd_global.login_id

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,
479: last_update_login = fnd_global.login_id
480: WHERE project_id = l_project_id;
481: END IF;
482: ELSE
483: IF l_proj_success_sys_sts_code = 'CLOSED' THEN

Line 488: last_updated_by = fnd_global.user_id,

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

Line 489: last_update_login = fnd_global.login_id

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

Line 497: last_updated_by = fnd_global.user_id,

493: SET project_status_code = l_success_status_code,
494: wf_status_code = NULL,
495: closed_date = null,
496: last_update_date = sysdate,
497: last_updated_by = fnd_global.user_id,
498: last_update_login = fnd_global.login_id
499: WHERE project_id = l_project_id;
500: END IF;
501: END IF;

Line 498: last_update_login = fnd_global.login_id

494: wf_status_code = NULL,
495: closed_date = null,
496: last_update_date = sysdate,
497: last_updated_by = fnd_global.user_id,
498: last_update_login = fnd_global.login_id
499: WHERE project_id = l_project_id;
500: END IF;
501: END IF;
502: /* Bug 2345889 Part-4 End*/

Line 574: X_LAST_UPDATED_BY => fnd_global.user_id,

570: X_NEW_PROJECT_SYSTEM_STATUS_CO => l_new_sys_status,
571: X_OLD_PROJECT_STATUS_CODE => l_proj_stus_code,
572: X_OLD_PROJECT_SYSTEM_STATUS_CO => l_old_sys_status,
573: X_CHANGE_COMMENT => l_note,
574: X_LAST_UPDATED_BY => fnd_global.user_id,
575: X_CREATED_BY => fnd_global.user_id,
576: X_CREATION_DATE => sysdate,
577: X_LAST_UPDATE_DATE => sysdate,
578: X_LAST_UPDATE_LOGIN => fnd_global.user_id);

Line 575: X_CREATED_BY => fnd_global.user_id,

571: X_OLD_PROJECT_STATUS_CODE => l_proj_stus_code,
572: X_OLD_PROJECT_SYSTEM_STATUS_CO => l_old_sys_status,
573: X_CHANGE_COMMENT => l_note,
574: X_LAST_UPDATED_BY => fnd_global.user_id,
575: X_CREATED_BY => fnd_global.user_id,
576: X_CREATION_DATE => sysdate,
577: X_LAST_UPDATE_DATE => sysdate,
578: X_LAST_UPDATE_LOGIN => fnd_global.user_id);
579:

Line 578: X_LAST_UPDATE_LOGIN => fnd_global.user_id);

574: X_LAST_UPDATED_BY => fnd_global.user_id,
575: X_CREATED_BY => fnd_global.user_id,
576: X_CREATION_DATE => sysdate,
577: X_LAST_UPDATE_DATE => sysdate,
578: X_LAST_UPDATE_LOGIN => fnd_global.user_id);
579:
580: END;
581: /* End of code for 7299466*/
582:

Line 716: X_LAST_UPDATED_BY => fnd_global.user_id,

712: X_NEW_PROJECT_SYSTEM_STATUS_CO => l_new_sys_status,
713: X_OLD_PROJECT_STATUS_CODE => l_proj_stus_code,
714: X_OLD_PROJECT_SYSTEM_STATUS_CO => l_old_sys_status,
715: X_CHANGE_COMMENT => l_note,
716: X_LAST_UPDATED_BY => fnd_global.user_id,
717: X_CREATED_BY => fnd_global.user_id,
718: X_CREATION_DATE => sysdate,
719: X_LAST_UPDATE_DATE => sysdate,
720: X_LAST_UPDATE_LOGIN => fnd_global.user_id);

Line 717: X_CREATED_BY => fnd_global.user_id,

713: X_OLD_PROJECT_STATUS_CODE => l_proj_stus_code,
714: X_OLD_PROJECT_SYSTEM_STATUS_CO => l_old_sys_status,
715: X_CHANGE_COMMENT => l_note,
716: X_LAST_UPDATED_BY => fnd_global.user_id,
717: X_CREATED_BY => fnd_global.user_id,
718: X_CREATION_DATE => sysdate,
719: X_LAST_UPDATE_DATE => sysdate,
720: X_LAST_UPDATE_LOGIN => fnd_global.user_id);
721:

Line 720: X_LAST_UPDATE_LOGIN => fnd_global.user_id);

716: X_LAST_UPDATED_BY => fnd_global.user_id,
717: X_CREATED_BY => fnd_global.user_id,
718: X_CREATION_DATE => sysdate,
719: X_LAST_UPDATE_DATE => sysdate,
720: X_LAST_UPDATE_LOGIN => fnd_global.user_id);
721:
722: END;
723: /* End of code for 7299466*/
724: