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.PJI_FM_PLAN_MAINT_T_PVT dependencies on FND_GLOBAL

Line 4178: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

4174: -- Inserts into FP reporting lines fact the data in the interim pjp1 table.
4175: --
4176: PROCEDURE INSERT_INTO_FP_FACT ( p_slice_type IN VARCHAR2 := NULL) IS
4177: l_last_update_date date := SYSDATE;
4178: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
4179: l_creation_date date := SYSDATE;
4180: l_created_by NUMBER := FND_GLOBAL.USER_ID;
4181: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
4182: BEGIN

Line 4180: l_created_by NUMBER := FND_GLOBAL.USER_ID;

4176: PROCEDURE INSERT_INTO_FP_FACT ( p_slice_type IN VARCHAR2 := NULL) IS
4177: l_last_update_date date := SYSDATE;
4178: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
4179: l_creation_date date := SYSDATE;
4180: l_created_by NUMBER := FND_GLOBAL.USER_ID;
4181: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
4182: BEGIN
4183:
4184: IF ( (p_slice_type = 'PRI') OR (p_slice_type IS NULL) ) THEN

Line 4181: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

4177: l_last_update_date date := SYSDATE;
4178: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
4179: l_creation_date date := SYSDATE;
4180: l_created_by NUMBER := FND_GLOBAL.USER_ID;
4181: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
4182: BEGIN
4183:
4184: IF ( (p_slice_type = 'PRI') OR (p_slice_type IS NULL) ) THEN
4185:

Line 6436: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

6432:
6433: /*
6434: PROCEDURE PRORATE_TO_ENT_NONTIMEPH IS
6435: l_last_update_date date := SYSDATE;
6436: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
6437: l_creation_date date := SYSDATE;
6438: l_created_by NUMBER := FND_GLOBAL.USER_ID;
6439: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6440:

Line 6438: l_created_by NUMBER := FND_GLOBAL.USER_ID;

6434: PROCEDURE PRORATE_TO_ENT_NONTIMEPH IS
6435: l_last_update_date date := SYSDATE;
6436: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
6437: l_creation_date date := SYSDATE;
6438: l_created_by NUMBER := FND_GLOBAL.USER_ID;
6439: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6440:
6441: l_calendar_type VARCHAR2(15) := 'ENT';
6442: BEGIN

Line 6439: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

6435: l_last_update_date date := SYSDATE;
6436: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
6437: l_creation_date date := SYSDATE;
6438: l_created_by NUMBER := FND_GLOBAL.USER_ID;
6439: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6440:
6441: l_calendar_type VARCHAR2(15) := 'ENT';
6442: BEGIN
6443:

Line 6638: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

6634: l_copied_from_version_id NUMBER;
6635: l_new_plan_type_id NUMBER;
6636: /*
6637: l_last_update_date DATE := SYSDATE;
6638: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
6639: l_creation_date DATE := SYSDATE;
6640: l_created_by NUMBER := FND_GLOBAL.USER_ID;
6641: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6642: */

Line 6640: l_created_by NUMBER := FND_GLOBAL.USER_ID;

6636: /*
6637: l_last_update_date DATE := SYSDATE;
6638: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
6639: l_creation_date DATE := SYSDATE;
6640: l_created_by NUMBER := FND_GLOBAL.USER_ID;
6641: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6642: */
6643: l_max_plnver_id NUMBER := NULL;
6644:

Line 6641: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

6637: l_last_update_date DATE := SYSDATE;
6638: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
6639: l_creation_date DATE := SYSDATE;
6640: l_created_by NUMBER := FND_GLOBAL.USER_ID;
6641: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6642: */
6643: l_max_plnver_id NUMBER := NULL;
6644:
6645: BEGIN

Line 7236: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

7232:
7233: PROCEDURE UPDATE_FP_ROWS IS
7234:
7235: l_last_update_date DATE := SYSDATE;
7236: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7237: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7238:
7239: BEGIN
7240:

Line 7237: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

7233: PROCEDURE UPDATE_FP_ROWS IS
7234:
7235: l_last_update_date DATE := SYSDATE;
7236: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7237: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7238:
7239: BEGIN
7240:
7241: UPDATE /*+ ordered use_nl(rl) rowid(rl) */

Line 7464: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

7460:
7461: PROCEDURE INSERT_FP_ROWS IS
7462:
7463: l_last_update_date date := SYSDATE;
7464: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7465: l_creation_date date := SYSDATE;
7466: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7467: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7468:

Line 7466: l_created_by NUMBER := FND_GLOBAL.USER_ID;

7462:
7463: l_last_update_date date := SYSDATE;
7464: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7465: l_creation_date date := SYSDATE;
7466: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7467: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7468:
7469: BEGIN
7470:

Line 7467: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

7463: l_last_update_date date := SYSDATE;
7464: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7465: l_creation_date date := SYSDATE;
7466: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7467: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7468:
7469: BEGIN
7470:
7471: INSERT INTO pji_fp_xbs_accum_f fact

Line 7724: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

7720:
7721:
7722: PROCEDURE INSERT_INTO_AC_FACT IS
7723: l_last_update_date date := SYSDATE;
7724: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7725: l_creation_date date := SYSDATE;
7726: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7727: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7728: BEGIN

Line 7726: l_created_by NUMBER := FND_GLOBAL.USER_ID;

7722: PROCEDURE INSERT_INTO_AC_FACT IS
7723: l_last_update_date date := SYSDATE;
7724: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7725: l_creation_date date := SYSDATE;
7726: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7727: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7728: BEGIN
7729:
7730: INSERT INTO PJI_AC_XBS_ACCUM_F

Line 7727: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

7723: l_last_update_date date := SYSDATE;
7724: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7725: l_creation_date date := SYSDATE;
7726: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7727: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7728: BEGIN
7729:
7730: INSERT INTO PJI_AC_XBS_ACCUM_F
7731: (

Line 7950: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

7946:
7947: PROCEDURE UPDATE_AC_ROWS IS
7948:
7949: l_last_update_date DATE := SYSDATE;
7950: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7951: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7952:
7953: BEGIN
7954:

Line 7951: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

7947: PROCEDURE UPDATE_AC_ROWS IS
7948:
7949: l_last_update_date DATE := SYSDATE;
7950: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7951: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7952:
7953: BEGIN
7954:
7955: UPDATE /*+ ordered use_nl(rl) rowid(rl) */

Line 8088: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

8084:
8085:
8086: PROCEDURE INSERT_AC_ROWS IS
8087: l_last_update_date date := SYSDATE;
8088: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
8089: l_creation_date date := SYSDATE;
8090: l_created_by NUMBER := FND_GLOBAL.USER_ID;
8091: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8092: BEGIN

Line 8090: l_created_by NUMBER := FND_GLOBAL.USER_ID;

8086: PROCEDURE INSERT_AC_ROWS IS
8087: l_last_update_date date := SYSDATE;
8088: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
8089: l_creation_date date := SYSDATE;
8090: l_created_by NUMBER := FND_GLOBAL.USER_ID;
8091: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8092: BEGIN
8093:
8094: INSERT INTO PJI_AC_XBS_ACCUM_F

Line 8091: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

8087: l_last_update_date date := SYSDATE;
8088: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
8089: l_creation_date date := SYSDATE;
8090: l_created_by NUMBER := FND_GLOBAL.USER_ID;
8091: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8092: BEGIN
8093:
8094: INSERT INTO PJI_AC_XBS_ACCUM_F
8095: (

Line 8514: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

8510:
8511:
8512:
8513: PROCEDURE ROLLUP_FPR_RBS IS
8514: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8515: -- l_worker_id NUMBER := 1;
8516:
8517: BEGIN
8518:

Line 8717: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

8713: END;
8714:
8715:
8716: PROCEDURE ROLLUP_FPR_RBS_T_SLICE IS
8717: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8718:
8719: BEGIN
8720:
8721: print_time(' worker id is ... ' || 1);

Line 8926: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

8922:
8923: PROCEDURE POPULATE_RBS_HDR IS
8924:
8925: l_last_update_date date := SYSDATE;
8926: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
8927: l_creation_date date := SYSDATE;
8928: l_created_by NUMBER := FND_GLOBAL.USER_ID;
8929: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8930:

Line 8928: l_created_by NUMBER := FND_GLOBAL.USER_ID;

8924:
8925: l_last_update_date date := SYSDATE;
8926: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
8927: l_creation_date date := SYSDATE;
8928: l_created_by NUMBER := FND_GLOBAL.USER_ID;
8929: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8930:
8931: BEGIN
8932:

Line 8929: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

8925: l_last_update_date date := SYSDATE;
8926: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
8927: l_creation_date date := SYSDATE;
8928: l_created_by NUMBER := FND_GLOBAL.USER_ID;
8929: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8930:
8931: BEGIN
8932:
8933: print_time ( ' Before update rbs header ' );

Line 9027: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

9023:
9024: PROCEDURE POPULATE_WBS_HDR IS
9025:
9026: l_last_update_date date := SYSDATE;
9027: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
9028: l_creation_date date := SYSDATE;
9029: l_created_by NUMBER := FND_GLOBAL.USER_ID;
9030: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
9031:

Line 9029: l_created_by NUMBER := FND_GLOBAL.USER_ID;

9025:
9026: l_last_update_date date := SYSDATE;
9027: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
9028: l_creation_date date := SYSDATE;
9029: l_created_by NUMBER := FND_GLOBAL.USER_ID;
9030: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
9031:
9032: BEGIN
9033:

Line 9030: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

9026: l_last_update_date date := SYSDATE;
9027: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
9028: l_creation_date date := SYSDATE;
9029: l_created_by NUMBER := FND_GLOBAL.USER_ID;
9030: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
9031:
9032: BEGIN
9033:
9034: print_time ( ' Before populate wbs header ' );

Line 9098: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

9094:
9095: PROCEDURE UPDATE_WBS_HDR IS
9096:
9097: l_last_update_date date := SYSDATE;
9098: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
9099: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
9100:
9101: BEGIN
9102:

Line 9099: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

9095: PROCEDURE UPDATE_WBS_HDR IS
9096:
9097: l_last_update_date date := SYSDATE;
9098: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
9099: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
9100:
9101: BEGIN
9102:
9103: print_time ( ' Before update wbs header ' );

Line 9468: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

9464: -- Temp fix until time table will have a record for non time phasing.
9465: --
9466: PROCEDURE INSERT_NTP_CAL_RECORD ( x_max_plnver_id OUT NOCOPY NUMBER ) IS
9467: l_last_update_date date := SYSDATE;
9468: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
9469: l_creation_date date := SYSDATE;
9470: l_created_by NUMBER := FND_GLOBAL.USER_ID;
9471: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
9472:

Line 9470: l_created_by NUMBER := FND_GLOBAL.USER_ID;

9466: PROCEDURE INSERT_NTP_CAL_RECORD ( x_max_plnver_id OUT NOCOPY NUMBER ) IS
9467: l_last_update_date date := SYSDATE;
9468: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
9469: l_creation_date date := SYSDATE;
9470: l_created_by NUMBER := FND_GLOBAL.USER_ID;
9471: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
9472:
9473: l_start_end_date DATE := TRUNC(SYSDATE);
9474:

Line 9471: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

9467: l_last_update_date date := SYSDATE;
9468: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
9469: l_creation_date date := SYSDATE;
9470: l_created_by NUMBER := FND_GLOBAL.USER_ID;
9471: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
9472:
9473: l_start_end_date DATE := TRUNC(SYSDATE);
9474:
9475: BEGIN