DBA Data[Home] [Help]

APPS.PJI_EXTRACTION_UTIL dependencies on FND_GLOBAL

Line 571: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,

567: END_DATE,
568: COMPLETION_TEXT
569: )
570: select
571: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,
572: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,
573: 'STAGE1' PROCESS_NAME,
574: 'CLEANALL' RUN_TYPE,
575: substr(p_check || ', ' ||

Line 572: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,

568: COMPLETION_TEXT
569: )
570: select
571: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,
572: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,
573: 'STAGE1' PROCESS_NAME,
574: 'CLEANALL' RUN_TYPE,
575: substr(p_check || ', ' ||
576: p_truncate_pji_tables || ', ' ||

Line 630: l_last_updated_by := FND_GLOBAL.USER_ID;

626: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_FM_XBS_ACCUM_TMP1_DEBUG','NORMAL', null); /* Added for bug 6857368 */
627:
628: -- Added for bug 6603016
629: l_last_update_date := sysdate;
630: l_last_updated_by := FND_GLOBAL.USER_ID;
631: l_last_update_login := FND_GLOBAL.LOGIN_ID;
632:
633: update PA_PROJECTS_ALL
634: set PJI_SOURCE_FLAG = null,

Line 631: l_last_update_login := FND_GLOBAL.LOGIN_ID;

627:
628: -- Added for bug 6603016
629: l_last_update_date := sysdate;
630: l_last_updated_by := FND_GLOBAL.USER_ID;
631: l_last_update_login := FND_GLOBAL.LOGIN_ID;
632:
633: update PA_PROJECTS_ALL
634: set PJI_SOURCE_FLAG = null,
635: LAST_UPDATE_DATE = l_last_update_date,