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.

APPS.PJI_FM_PLAN_MAINT_PVT dependencies on FND_GLOBAL

Line 1151: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

1147: l_count_already_locked NUMBER := 0;
1148: l_count_just_updated NUMBER := 0;
1149:
1150: l_last_update_date date := SYSDATE;
1151: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1152: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1153:
1154: excp_resource_busy EXCEPTION;
1155: PRAGMA EXCEPTION_INIT(excp_resource_busy, -54);

Line 1152: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

1148: l_count_just_updated NUMBER := 0;
1149:
1150: l_last_update_date date := SYSDATE;
1151: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1152: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1153:
1154: excp_resource_busy EXCEPTION;
1155: PRAGMA EXCEPTION_INIT(excp_resource_busy, -54);
1156:

Line 4331: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

4327: -- Inserts into FP reporting lines fact the data in the interim pjp1 table.
4328: --
4329: PROCEDURE INSERT_INTO_FP_FACT ( p_slice_type IN VARCHAR2 := NULL) IS
4330: l_last_update_date date := SYSDATE;
4331: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
4332: l_creation_date date := SYSDATE;
4333: l_created_by NUMBER := FND_GLOBAL.USER_ID;
4334: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
4335:

Line 4333: l_created_by NUMBER := FND_GLOBAL.USER_ID;

4329: PROCEDURE INSERT_INTO_FP_FACT ( p_slice_type IN VARCHAR2 := NULL) IS
4330: l_last_update_date date := SYSDATE;
4331: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
4332: l_creation_date date := SYSDATE;
4333: l_created_by NUMBER := FND_GLOBAL.USER_ID;
4334: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
4335:
4336: /*commenting for bug 7497672
4337: -- Bug 7010864

Line 4334: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

4330: l_last_update_date date := SYSDATE;
4331: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
4332: l_creation_date date := SYSDATE;
4333: l_created_by NUMBER := FND_GLOBAL.USER_ID;
4334: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
4335:
4336: /*commenting for bug 7497672
4337: -- Bug 7010864
4338: TYPE row_id_tab_type IS TABLE OF rowid index by binary_integer;

Line 5486: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

5482:
5483: PROCEDURE UPDATE_FP_ROWS IS
5484:
5485: l_last_update_date DATE := SYSDATE;
5486: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
5487: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
5488:
5489: BEGIN
5490:

Line 5487: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

5483: PROCEDURE UPDATE_FP_ROWS IS
5484:
5485: l_last_update_date DATE := SYSDATE;
5486: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
5487: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
5488:
5489: BEGIN
5490:
5491:

Line 5718: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

5714:
5715: PROCEDURE INSERT_FP_ROWS IS
5716:
5717: l_last_update_date date := SYSDATE;
5718: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
5719: l_creation_date date := SYSDATE;
5720: l_created_by NUMBER := FND_GLOBAL.USER_ID;
5721: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
5722:

Line 5720: l_created_by NUMBER := FND_GLOBAL.USER_ID;

5716:
5717: l_last_update_date date := SYSDATE;
5718: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
5719: l_creation_date date := SYSDATE;
5720: l_created_by NUMBER := FND_GLOBAL.USER_ID;
5721: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
5722:
5723: BEGIN
5724:

Line 5721: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

5717: l_last_update_date date := SYSDATE;
5718: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
5719: l_creation_date date := SYSDATE;
5720: l_created_by NUMBER := FND_GLOBAL.USER_ID;
5721: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
5722:
5723: BEGIN
5724:
5725: --Start of addition for bug 5927368

Line 5996: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

5992:
5993:
5994: PROCEDURE INSERT_INTO_AC_FACT IS
5995: l_last_update_date date := SYSDATE;
5996: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
5997: l_creation_date date := SYSDATE;
5998: l_created_by NUMBER := FND_GLOBAL.USER_ID;
5999: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6000: BEGIN

Line 5998: l_created_by NUMBER := FND_GLOBAL.USER_ID;

5994: PROCEDURE INSERT_INTO_AC_FACT IS
5995: l_last_update_date date := SYSDATE;
5996: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
5997: l_creation_date date := SYSDATE;
5998: l_created_by NUMBER := FND_GLOBAL.USER_ID;
5999: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6000: BEGIN
6001:
6002: INSERT INTO PJI_AC_XBS_ACCUM_F

Line 5999: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

5995: l_last_update_date date := SYSDATE;
5996: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
5997: l_creation_date date := SYSDATE;
5998: l_created_by NUMBER := FND_GLOBAL.USER_ID;
5999: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6000: BEGIN
6001:
6002: INSERT INTO PJI_AC_XBS_ACCUM_F
6003: (

Line 6222: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

6218:
6219: PROCEDURE UPDATE_AC_ROWS IS
6220:
6221: l_last_update_date DATE := SYSDATE;
6222: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
6223: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6224:
6225: BEGIN
6226:

Line 6223: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

6219: PROCEDURE UPDATE_AC_ROWS IS
6220:
6221: l_last_update_date DATE := SYSDATE;
6222: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
6223: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6224:
6225: BEGIN
6226:
6227: UPDATE /*+ ordered use_nl(rl) rowid(rl) */

Line 6360: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

6356:
6357:
6358: PROCEDURE INSERT_AC_ROWS IS
6359: l_last_update_date date := SYSDATE;
6360: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
6361: l_creation_date date := SYSDATE;
6362: l_created_by NUMBER := FND_GLOBAL.USER_ID;
6363: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6364: BEGIN

Line 6362: l_created_by NUMBER := FND_GLOBAL.USER_ID;

6358: PROCEDURE INSERT_AC_ROWS IS
6359: l_last_update_date date := SYSDATE;
6360: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
6361: l_creation_date date := SYSDATE;
6362: l_created_by NUMBER := FND_GLOBAL.USER_ID;
6363: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6364: BEGIN
6365:
6366: INSERT INTO PJI_AC_XBS_ACCUM_F

Line 6363: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

6359: l_last_update_date date := SYSDATE;
6360: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
6361: l_creation_date date := SYSDATE;
6362: l_created_by NUMBER := FND_GLOBAL.USER_ID;
6363: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6364: BEGIN
6365:
6366: INSERT INTO PJI_AC_XBS_ACCUM_F
6367: (

Line 6766: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

6762:
6763:
6764:
6765: PROCEDURE ROLLUP_FPR_RBS IS
6766: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6767: -- l_worker_id NUMBER := 1;
6768:
6769: BEGIN
6770:

Line 6969: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

6965: END;
6966:
6967:
6968: PROCEDURE ROLLUP_FPR_RBS_T_SLICE IS
6969: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6970:
6971: BEGIN
6972:
6973: print_time(' worker id is ... ' || 1);

Line 7179: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

7175:
7176: PROCEDURE POPULATE_RBS_HDR IS
7177:
7178: l_last_update_date date := SYSDATE;
7179: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7180: l_creation_date date := SYSDATE;
7181: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7182: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7183:

Line 7181: l_created_by NUMBER := FND_GLOBAL.USER_ID;

7177:
7178: l_last_update_date date := SYSDATE;
7179: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7180: l_creation_date date := SYSDATE;
7181: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7182: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7183:
7184: BEGIN
7185:

Line 7182: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

7178: l_last_update_date date := SYSDATE;
7179: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7180: l_creation_date date := SYSDATE;
7181: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7182: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7183:
7184: BEGIN
7185:
7186: print_time ( ' Before update rbs header ' );

Line 7243: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

7239:
7240: PROCEDURE POPULATE_WBS_HDR IS
7241:
7242: l_last_update_date date := SYSDATE;
7243: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7244: l_creation_date date := SYSDATE;
7245: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7246: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7247:

Line 7245: l_created_by NUMBER := FND_GLOBAL.USER_ID;

7241:
7242: l_last_update_date date := SYSDATE;
7243: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7244: l_creation_date date := SYSDATE;
7245: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7246: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7247:
7248: BEGIN
7249:

Line 7246: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

7242: l_last_update_date date := SYSDATE;
7243: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7244: l_creation_date date := SYSDATE;
7245: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7246: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7247:
7248: BEGIN
7249:
7250: print_time ( ' Before populate wbs header ' );

Line 7317: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

7313:
7314: PROCEDURE UPDATE_WBS_HDR IS
7315:
7316: l_last_update_date date := SYSDATE;
7317: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7318: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7319:
7320: BEGIN
7321:

Line 7318: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

7314: PROCEDURE UPDATE_WBS_HDR IS
7315:
7316: l_last_update_date date := SYSDATE;
7317: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7318: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7319:
7320: BEGIN
7321:
7322: print_time ( ' Before update wbs header ' );

Line 10557: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

10553: -- Temp fix until time table will have a record for non time phasing.
10554: --
10555: PROCEDURE INSERT_NTP_CAL_RECORD ( x_max_project_id OUT NOCOPY NUMBER ) IS
10556: l_last_update_date date := SYSDATE;
10557: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
10558: l_creation_date date := SYSDATE;
10559: l_created_by NUMBER := FND_GLOBAL.USER_ID;
10560: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
10561:

Line 10559: l_created_by NUMBER := FND_GLOBAL.USER_ID;

10555: PROCEDURE INSERT_NTP_CAL_RECORD ( x_max_project_id OUT NOCOPY NUMBER ) IS
10556: l_last_update_date date := SYSDATE;
10557: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
10558: l_creation_date date := SYSDATE;
10559: l_created_by NUMBER := FND_GLOBAL.USER_ID;
10560: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
10561:
10562: l_start_end_date DATE := TRUNC(SYSDATE);
10563: BEGIN

Line 10560: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

10556: l_last_update_date date := SYSDATE;
10557: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
10558: l_creation_date date := SYSDATE;
10559: l_created_by NUMBER := FND_GLOBAL.USER_ID;
10560: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
10561:
10562: l_start_end_date DATE := TRUNC(SYSDATE);
10563: BEGIN
10564:

Line 11215: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

11211: -- Bug 6316433 : Added batch processing logic
11212: PROCEDURE MERGE_INTO_FP_FACTS IS
11213:
11214: l_last_update_date date := SYSDATE;
11215: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
11216: l_creation_date date := SYSDATE;
11217: l_created_by NUMBER := FND_GLOBAL.USER_ID;
11218: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
11219:

Line 11217: l_created_by NUMBER := FND_GLOBAL.USER_ID;

11213:
11214: l_last_update_date date := SYSDATE;
11215: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
11216: l_creation_date date := SYSDATE;
11217: l_created_by NUMBER := FND_GLOBAL.USER_ID;
11218: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
11219:
11220: TYPE row_id_tab_type IS TABLE OF rowid index by binary_integer;
11221: x_row_id row_id_tab_type;

Line 11218: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

11214: l_last_update_date date := SYSDATE;
11215: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
11216: l_creation_date date := SYSDATE;
11217: l_created_by NUMBER := FND_GLOBAL.USER_ID;
11218: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
11219:
11220: TYPE row_id_tab_type IS TABLE OF rowid index by binary_integer;
11221: x_row_id row_id_tab_type;
11222: