DBA Data[Home] [Help]

APPS.PJI_PJP_EXTRACTION_UTILS dependencies on FND_GLOBAL

Line 78: l_last_updated_by := FND_GLOBAL.USER_ID;

74:
75: begin
76:
77: l_last_update_date := sysdate;
78: l_last_updated_by := FND_GLOBAL.USER_ID;
79: l_creation_date := sysdate;
80: l_created_by := FND_GLOBAL.USER_ID;
81: l_last_update_login := FND_GLOBAL.LOGIN_ID;
82:

Line 80: l_created_by := FND_GLOBAL.USER_ID;

76:
77: l_last_update_date := sysdate;
78: l_last_updated_by := FND_GLOBAL.USER_ID;
79: l_creation_date := sysdate;
80: l_created_by := FND_GLOBAL.USER_ID;
81: l_last_update_login := FND_GLOBAL.LOGIN_ID;
82:
83: select count(*)
84: into l_count

Line 81: l_last_update_login := FND_GLOBAL.LOGIN_ID;

77: l_last_update_date := sysdate;
78: l_last_updated_by := FND_GLOBAL.USER_ID;
79: l_creation_date := sysdate;
80: l_created_by := FND_GLOBAL.USER_ID;
81: l_last_update_login := FND_GLOBAL.LOGIN_ID;
82:
83: select count(*)
84: into l_count
85: from PJI_PJP_PROJ_EXTR_STATUS

Line 532: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,

528: END_DATE,
529: COMPLETION_TEXT
530: )
531: select
532: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,
533: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,
534: 'STAGE3' PROCESS_NAME,
535: 'CLEANALL' RUN_TYPE,
536: substr(p_check || ', ' ||

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

529: COMPLETION_TEXT
530: )
531: select
532: FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID,
533: substr(FND_GLOBAL.USER_NAME, 1, 10) USER_NAME,
534: 'STAGE3' PROCESS_NAME,
535: 'CLEANALL' RUN_TYPE,
536: substr(p_check || ', ' ||
537: p_fpm_upgrade || ', ' ||