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 4265: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

4261: -- Inserts into FP reporting lines fact the data in the interim pjp1 table.
4262: --
4263: PROCEDURE INSERT_INTO_FP_FACT ( p_slice_type IN VARCHAR2 := NULL) IS
4264: l_last_update_date date := SYSDATE;
4265: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
4266: l_creation_date date := SYSDATE;
4267: l_created_by NUMBER := FND_GLOBAL.USER_ID;
4268: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
4269: BEGIN

Line 4267: l_created_by NUMBER := FND_GLOBAL.USER_ID;

4263: PROCEDURE INSERT_INTO_FP_FACT ( p_slice_type IN VARCHAR2 := NULL) IS
4264: l_last_update_date date := SYSDATE;
4265: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
4266: l_creation_date date := SYSDATE;
4267: l_created_by NUMBER := FND_GLOBAL.USER_ID;
4268: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
4269: BEGIN
4270:
4271: IF ( (p_slice_type = 'PRI') OR (p_slice_type IS NULL) ) THEN

Line 4268: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

4264: l_last_update_date date := SYSDATE;
4265: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
4266: l_creation_date date := SYSDATE;
4267: l_created_by NUMBER := FND_GLOBAL.USER_ID;
4268: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
4269: BEGIN
4270:
4271: IF ( (p_slice_type = 'PRI') OR (p_slice_type IS NULL) ) THEN
4272:

Line 6537: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

6533:
6534: /*
6535: PROCEDURE PRORATE_TO_ENT_NONTIMEPH IS
6536: l_last_update_date date := SYSDATE;
6537: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
6538: l_creation_date date := SYSDATE;
6539: l_created_by NUMBER := FND_GLOBAL.USER_ID;
6540: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6541:

Line 6539: l_created_by NUMBER := FND_GLOBAL.USER_ID;

6535: PROCEDURE PRORATE_TO_ENT_NONTIMEPH IS
6536: l_last_update_date date := SYSDATE;
6537: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
6538: l_creation_date date := SYSDATE;
6539: l_created_by NUMBER := FND_GLOBAL.USER_ID;
6540: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6541:
6542: l_calendar_type VARCHAR2(15) := 'ENT';
6543: BEGIN

Line 6540: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

6536: l_last_update_date date := SYSDATE;
6537: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
6538: l_creation_date date := SYSDATE;
6539: l_created_by NUMBER := FND_GLOBAL.USER_ID;
6540: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6541:
6542: l_calendar_type VARCHAR2(15) := 'ENT';
6543: BEGIN
6544:

Line 6761: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

6757: l_copied_from_version_id NUMBER;
6758: l_new_plan_type_id NUMBER;
6759: /*
6760: l_last_update_date DATE := SYSDATE;
6761: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
6762: l_creation_date DATE := SYSDATE;
6763: l_created_by NUMBER := FND_GLOBAL.USER_ID;
6764: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6765: */

Line 6763: l_created_by NUMBER := FND_GLOBAL.USER_ID;

6759: /*
6760: l_last_update_date DATE := SYSDATE;
6761: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
6762: l_creation_date DATE := SYSDATE;
6763: l_created_by NUMBER := FND_GLOBAL.USER_ID;
6764: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6765: */
6766: l_max_plnver_id NUMBER := NULL;
6767:

Line 6764: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

6760: l_last_update_date DATE := SYSDATE;
6761: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
6762: l_creation_date DATE := SYSDATE;
6763: l_created_by NUMBER := FND_GLOBAL.USER_ID;
6764: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6765: */
6766: l_max_plnver_id NUMBER := NULL;
6767:
6768: BEGIN

Line 7369: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

7365:
7366: PROCEDURE UPDATE_FP_ROWS IS
7367:
7368: l_last_update_date DATE := SYSDATE;
7369: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7370: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7371:
7372: BEGIN
7373:

Line 7370: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

7366: PROCEDURE UPDATE_FP_ROWS IS
7367:
7368: l_last_update_date DATE := SYSDATE;
7369: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7370: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7371:
7372: BEGIN
7373:
7374: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 7603: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

7599:
7600: PROCEDURE INSERT_FP_ROWS IS
7601:
7602: l_last_update_date date := SYSDATE;
7603: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7604: l_creation_date date := SYSDATE;
7605: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7606: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7607: l_count NUMBER;

Line 7605: l_created_by NUMBER := FND_GLOBAL.USER_ID;

7601:
7602: l_last_update_date date := SYSDATE;
7603: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7604: l_creation_date date := SYSDATE;
7605: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7606: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7607: l_count NUMBER;
7608:
7609: BEGIN

Line 7606: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

7602: l_last_update_date date := SYSDATE;
7603: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7604: l_creation_date date := SYSDATE;
7605: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7606: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7607: l_count NUMBER;
7608:
7609: BEGIN
7610:

Line 7872: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

7868:
7869:
7870: PROCEDURE INSERT_INTO_AC_FACT IS
7871: l_last_update_date date := SYSDATE;
7872: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7873: l_creation_date date := SYSDATE;
7874: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7875: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7876: BEGIN

Line 7874: l_created_by NUMBER := FND_GLOBAL.USER_ID;

7870: PROCEDURE INSERT_INTO_AC_FACT IS
7871: l_last_update_date date := SYSDATE;
7872: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7873: l_creation_date date := SYSDATE;
7874: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7875: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7876: BEGIN
7877:
7878: INSERT INTO PJI_AC_XBS_ACCUM_F

Line 7875: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

7871: l_last_update_date date := SYSDATE;
7872: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7873: l_creation_date date := SYSDATE;
7874: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7875: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7876: BEGIN
7877:
7878: INSERT INTO PJI_AC_XBS_ACCUM_F
7879: (

Line 8098: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

8094:
8095: PROCEDURE UPDATE_AC_ROWS IS
8096:
8097: l_last_update_date DATE := SYSDATE;
8098: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
8099: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8100:
8101: BEGIN
8102:

Line 8099: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

8095: PROCEDURE UPDATE_AC_ROWS IS
8096:
8097: l_last_update_date DATE := SYSDATE;
8098: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
8099: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8100:
8101: BEGIN
8102:
8103: UPDATE /*+ ordered use_nl(rl) rowid(rl) */

Line 8236: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

8232:
8233:
8234: PROCEDURE INSERT_AC_ROWS IS
8235: l_last_update_date date := SYSDATE;
8236: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
8237: l_creation_date date := SYSDATE;
8238: l_created_by NUMBER := FND_GLOBAL.USER_ID;
8239: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8240: BEGIN

Line 8238: l_created_by NUMBER := FND_GLOBAL.USER_ID;

8234: PROCEDURE INSERT_AC_ROWS IS
8235: l_last_update_date date := SYSDATE;
8236: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
8237: l_creation_date date := SYSDATE;
8238: l_created_by NUMBER := FND_GLOBAL.USER_ID;
8239: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8240: BEGIN
8241:
8242: INSERT INTO PJI_AC_XBS_ACCUM_F

Line 8239: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

8235: l_last_update_date date := SYSDATE;
8236: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
8237: l_creation_date date := SYSDATE;
8238: l_created_by NUMBER := FND_GLOBAL.USER_ID;
8239: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8240: BEGIN
8241:
8242: INSERT INTO PJI_AC_XBS_ACCUM_F
8243: (

Line 8662: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

8658:
8659:
8660:
8661: PROCEDURE ROLLUP_FPR_RBS IS
8662: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8663: -- l_worker_id NUMBER := 1;
8664:
8665: BEGIN
8666:

Line 8865: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

8861: END;
8862:
8863:
8864: PROCEDURE ROLLUP_FPR_RBS_T_SLICE IS
8865: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8866:
8867: BEGIN
8868:
8869: print_time(' worker id is ... ' || 1);

Line 9074: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

9070:
9071: PROCEDURE POPULATE_RBS_HDR IS
9072:
9073: l_last_update_date date := SYSDATE;
9074: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
9075: l_creation_date date := SYSDATE;
9076: l_created_by NUMBER := FND_GLOBAL.USER_ID;
9077: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
9078:

Line 9076: l_created_by NUMBER := FND_GLOBAL.USER_ID;

9072:
9073: l_last_update_date date := SYSDATE;
9074: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
9075: l_creation_date date := SYSDATE;
9076: l_created_by NUMBER := FND_GLOBAL.USER_ID;
9077: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
9078:
9079: BEGIN
9080:

Line 9077: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

9073: l_last_update_date date := SYSDATE;
9074: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
9075: l_creation_date date := SYSDATE;
9076: l_created_by NUMBER := FND_GLOBAL.USER_ID;
9077: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
9078:
9079: BEGIN
9080:
9081: print_time ( ' Before update rbs header ' );

Line 9175: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

9171:
9172: PROCEDURE POPULATE_WBS_HDR IS
9173:
9174: l_last_update_date date := SYSDATE;
9175: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
9176: l_creation_date date := SYSDATE;
9177: l_created_by NUMBER := FND_GLOBAL.USER_ID;
9178: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
9179:

Line 9177: l_created_by NUMBER := FND_GLOBAL.USER_ID;

9173:
9174: l_last_update_date date := SYSDATE;
9175: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
9176: l_creation_date date := SYSDATE;
9177: l_created_by NUMBER := FND_GLOBAL.USER_ID;
9178: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
9179:
9180: BEGIN
9181:

Line 9178: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

9174: l_last_update_date date := SYSDATE;
9175: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
9176: l_creation_date date := SYSDATE;
9177: l_created_by NUMBER := FND_GLOBAL.USER_ID;
9178: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
9179:
9180: BEGIN
9181:
9182: print_time ( ' Before populate wbs header ' );

Line 9246: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

9242:
9243: PROCEDURE UPDATE_WBS_HDR IS
9244:
9245: l_last_update_date date := SYSDATE;
9246: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
9247: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
9248:
9249: BEGIN
9250:

Line 9247: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

9243: PROCEDURE UPDATE_WBS_HDR IS
9244:
9245: l_last_update_date date := SYSDATE;
9246: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
9247: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
9248:
9249: BEGIN
9250:
9251: print_time ( ' Before update wbs header ' );

Line 9623: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

9619: -- Temp fix until time table will have a record for non time phasing.
9620: --
9621: PROCEDURE INSERT_NTP_CAL_RECORD ( x_max_plnver_id OUT NOCOPY NUMBER ) IS
9622: l_last_update_date date := SYSDATE;
9623: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
9624: l_creation_date date := SYSDATE;
9625: l_created_by NUMBER := FND_GLOBAL.USER_ID;
9626: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
9627:

Line 9625: l_created_by NUMBER := FND_GLOBAL.USER_ID;

9621: PROCEDURE INSERT_NTP_CAL_RECORD ( x_max_plnver_id OUT NOCOPY NUMBER ) IS
9622: l_last_update_date date := SYSDATE;
9623: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
9624: l_creation_date date := SYSDATE;
9625: l_created_by NUMBER := FND_GLOBAL.USER_ID;
9626: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
9627:
9628: l_start_end_date DATE := TRUNC(SYSDATE);
9629:

Line 9626: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

9622: l_last_update_date date := SYSDATE;
9623: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
9624: l_creation_date date := SYSDATE;
9625: l_created_by NUMBER := FND_GLOBAL.USER_ID;
9626: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
9627:
9628: l_start_end_date DATE := TRUNC(SYSDATE);
9629:
9630: BEGIN