DBA Data[Home] [Help]

APPS.PJI_PJP_PRG_PERF_ALL dependencies on FND_GLOBAL

Line 559: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

555: RAISE;
556: END;
557:
558: PROCEDURE CREATE_FP_GL_PRI_ROLLUP IS
559: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
560: l_calendar_type VARCHAR2(15) := 'G';
561: l_line_type VARCHAR2(15) := 'GLR';
562: l_extraction_type varchar2(30); /* Added for Bug 13813361 */
563: l_process varchar2(10); /* Added for Bug 13813361 */

Line 2322: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

2318: END;
2319:
2320: PROCEDURE INSERT_INTO_FP_FACT IS
2321: l_last_update_date date := SYSDATE;
2322: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2323: l_creation_date date := SYSDATE;
2324: l_created_by NUMBER := FND_GLOBAL.USER_ID;
2325: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
2326: l_pji_schema varchar2(30); /* Added for Bug 13813361 */

Line 2324: l_created_by NUMBER := FND_GLOBAL.USER_ID;

2320: PROCEDURE INSERT_INTO_FP_FACT IS
2321: l_last_update_date date := SYSDATE;
2322: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2323: l_creation_date date := SYSDATE;
2324: l_created_by NUMBER := FND_GLOBAL.USER_ID;
2325: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
2326: l_pji_schema varchar2(30); /* Added for Bug 13813361 */
2327:
2328: BEGIN

Line 2325: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

2321: l_last_update_date date := SYSDATE;
2322: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2323: l_creation_date date := SYSDATE;
2324: l_created_by NUMBER := FND_GLOBAL.USER_ID;
2325: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
2326: l_pji_schema varchar2(30); /* Added for Bug 13813361 */
2327:
2328: BEGIN
2329:

Line 2527: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

2523:
2524: /* Added for bug 13897252 starts */
2525: PROCEDURE INSERT_INTO_FP_FACT1 IS
2526: l_last_update_date date := SYSDATE;
2527: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2528: l_creation_date date := SYSDATE;
2529: l_created_by NUMBER := FND_GLOBAL.USER_ID;
2530: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
2531: l_pji_schema varchar2(30); /* Added for Bug 13813361 */

Line 2529: l_created_by NUMBER := FND_GLOBAL.USER_ID;

2525: PROCEDURE INSERT_INTO_FP_FACT1 IS
2526: l_last_update_date date := SYSDATE;
2527: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2528: l_creation_date date := SYSDATE;
2529: l_created_by NUMBER := FND_GLOBAL.USER_ID;
2530: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
2531: l_pji_schema varchar2(30); /* Added for Bug 13813361 */
2532:
2533: BEGIN

Line 2530: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

2526: l_last_update_date date := SYSDATE;
2527: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2528: l_creation_date date := SYSDATE;
2529: l_created_by NUMBER := FND_GLOBAL.USER_ID;
2530: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
2531: l_pji_schema varchar2(30); /* Added for Bug 13813361 */
2532:
2533: BEGIN
2534:

Line 2935: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

2931:
2932: PROCEDURE POPULATE_RBS_HDR IS
2933:
2934: l_last_update_date date := SYSDATE;
2935: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2936: l_creation_date date := SYSDATE;
2937: l_created_by NUMBER := FND_GLOBAL.USER_ID;
2938: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
2939:

Line 2937: l_created_by NUMBER := FND_GLOBAL.USER_ID;

2933:
2934: l_last_update_date date := SYSDATE;
2935: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2936: l_creation_date date := SYSDATE;
2937: l_created_by NUMBER := FND_GLOBAL.USER_ID;
2938: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
2939:
2940: BEGIN
2941:

Line 2938: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

2934: l_last_update_date date := SYSDATE;
2935: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2936: l_creation_date date := SYSDATE;
2937: l_created_by NUMBER := FND_GLOBAL.USER_ID;
2938: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
2939:
2940: BEGIN
2941:
2942: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;

Line 2996: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

2992:
2993: PROCEDURE UPDATE_WBS_HDR IS
2994: pragma autonomous_transaction; /* Added for Bug 14735308 */
2995: l_last_update_date date := SYSDATE;
2996: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2997: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
2998:
2999: BEGIN
3000:

Line 2997: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

2993: PROCEDURE UPDATE_WBS_HDR IS
2994: pragma autonomous_transaction; /* Added for Bug 14735308 */
2995: l_last_update_date date := SYSDATE;
2996: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2997: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
2998:
2999: BEGIN
3000:
3001: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;

Line 4497: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

4493: END UPDATE_WBS_HDR_1;
4494:
4495: PROCEDURE MERGE_INTO_FP_FACTS IS
4496:
4497: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
4498: l_created_by NUMBER := FND_GLOBAL.USER_ID;
4499: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
4500: l_process varchar2(30);
4501: l_batch_size NUMBER := 5000000;

Line 4498: l_created_by NUMBER := FND_GLOBAL.USER_ID;

4494:
4495: PROCEDURE MERGE_INTO_FP_FACTS IS
4496:
4497: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
4498: l_created_by NUMBER := FND_GLOBAL.USER_ID;
4499: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
4500: l_process varchar2(30);
4501: l_batch_size NUMBER := 5000000;
4502: l_date VARCHAR2(20);

Line 4499: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

4495: PROCEDURE MERGE_INTO_FP_FACTS IS
4496:
4497: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
4498: l_created_by NUMBER := FND_GLOBAL.USER_ID;
4499: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
4500: l_process varchar2(30);
4501: l_batch_size NUMBER := 5000000;
4502: l_date VARCHAR2(20);
4503: