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

1245: l_count_already_locked NUMBER := 0;
1246: l_count_just_updated NUMBER := 0;
1247:
1248: l_last_update_date date := SYSDATE;
1249: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1250: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1251:
1252: excp_resource_busy EXCEPTION;
1253: PRAGMA EXCEPTION_INIT(excp_resource_busy, -54);

Line 1250: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

1246: l_count_just_updated NUMBER := 0;
1247:
1248: l_last_update_date date := SYSDATE;
1249: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1250: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1251:
1252: excp_resource_busy EXCEPTION;
1253: PRAGMA EXCEPTION_INIT(excp_resource_busy, -54);
1254:

Line 5505: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

5501: -- Inserts into FP reporting lines fact the data in the interim pjp1 table.
5502: --
5503: PROCEDURE INSERT_INTO_FP_FACT ( p_slice_type IN VARCHAR2 := NULL) IS
5504: l_last_update_date date := SYSDATE;
5505: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
5506: l_creation_date date := SYSDATE;
5507: l_created_by NUMBER := FND_GLOBAL.USER_ID;
5508: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
5509:

Line 5507: l_created_by NUMBER := FND_GLOBAL.USER_ID;

5503: PROCEDURE INSERT_INTO_FP_FACT ( p_slice_type IN VARCHAR2 := NULL) IS
5504: l_last_update_date date := SYSDATE;
5505: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
5506: l_creation_date date := SYSDATE;
5507: l_created_by NUMBER := FND_GLOBAL.USER_ID;
5508: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
5509:
5510: /*commenting for bug 7497672
5511: -- Bug 7010864

Line 5508: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

5504: l_last_update_date date := SYSDATE;
5505: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
5506: l_creation_date date := SYSDATE;
5507: l_created_by NUMBER := FND_GLOBAL.USER_ID;
5508: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
5509:
5510: /*commenting for bug 7497672
5511: -- Bug 7010864
5512: TYPE row_id_tab_type IS TABLE OF rowid index by binary_integer;

Line 6690: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

6686:
6687: PROCEDURE UPDATE_FP_ROWS IS
6688:
6689: l_last_update_date DATE := SYSDATE;
6690: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
6691: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6692:
6693: BEGIN
6694:

Line 6691: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

6687: PROCEDURE UPDATE_FP_ROWS IS
6688:
6689: l_last_update_date DATE := SYSDATE;
6690: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
6691: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6692:
6693: BEGIN
6694:
6695:

Line 6922: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

6918:
6919: PROCEDURE INSERT_FP_ROWS IS
6920:
6921: l_last_update_date date := SYSDATE;
6922: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
6923: l_creation_date date := SYSDATE;
6924: l_created_by NUMBER := FND_GLOBAL.USER_ID;
6925: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6926:

Line 6924: l_created_by NUMBER := FND_GLOBAL.USER_ID;

6920:
6921: l_last_update_date date := SYSDATE;
6922: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
6923: l_creation_date date := SYSDATE;
6924: l_created_by NUMBER := FND_GLOBAL.USER_ID;
6925: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6926:
6927: BEGIN
6928:

Line 6925: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

6921: l_last_update_date date := SYSDATE;
6922: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
6923: l_creation_date date := SYSDATE;
6924: l_created_by NUMBER := FND_GLOBAL.USER_ID;
6925: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
6926:
6927: BEGIN
6928:
6929: --Start of addition for bug 5927368

Line 7200: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

7196:
7197:
7198: PROCEDURE INSERT_INTO_AC_FACT IS
7199: l_last_update_date date := SYSDATE;
7200: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7201: l_creation_date date := SYSDATE;
7202: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7203: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7204: BEGIN

Line 7202: l_created_by NUMBER := FND_GLOBAL.USER_ID;

7198: PROCEDURE INSERT_INTO_AC_FACT IS
7199: l_last_update_date date := SYSDATE;
7200: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7201: l_creation_date date := SYSDATE;
7202: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7203: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7204: BEGIN
7205:
7206: INSERT INTO PJI_AC_XBS_ACCUM_F

Line 7203: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

7199: l_last_update_date date := SYSDATE;
7200: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7201: l_creation_date date := SYSDATE;
7202: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7203: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7204: BEGIN
7205:
7206: INSERT INTO PJI_AC_XBS_ACCUM_F
7207: (

Line 7426: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

7422:
7423: PROCEDURE UPDATE_AC_ROWS IS
7424:
7425: l_last_update_date DATE := SYSDATE;
7426: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7427: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7428:
7429: BEGIN
7430:

Line 7427: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

7423: PROCEDURE UPDATE_AC_ROWS IS
7424:
7425: l_last_update_date DATE := SYSDATE;
7426: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7427: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7428:
7429: BEGIN
7430:
7431: UPDATE /*+ ordered use_nl(rl) rowid(rl) */

Line 7564: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

7560:
7561:
7562: PROCEDURE INSERT_AC_ROWS IS
7563: l_last_update_date date := SYSDATE;
7564: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7565: l_creation_date date := SYSDATE;
7566: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7567: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7568: BEGIN

Line 7566: l_created_by NUMBER := FND_GLOBAL.USER_ID;

7562: PROCEDURE INSERT_AC_ROWS IS
7563: l_last_update_date date := SYSDATE;
7564: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7565: l_creation_date date := SYSDATE;
7566: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7567: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7568: BEGIN
7569:
7570: INSERT INTO PJI_AC_XBS_ACCUM_F

Line 7567: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

7563: l_last_update_date date := SYSDATE;
7564: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
7565: l_creation_date date := SYSDATE;
7566: l_created_by NUMBER := FND_GLOBAL.USER_ID;
7567: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7568: BEGIN
7569:
7570: INSERT INTO PJI_AC_XBS_ACCUM_F
7571: (

Line 7970: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

7966:
7967:
7968:
7969: PROCEDURE ROLLUP_FPR_RBS IS
7970: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7971: -- l_worker_id NUMBER := 1;
7972:
7973: BEGIN
7974:

Line 8173: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

8169: END;
8170:
8171:
8172: PROCEDURE ROLLUP_FPR_RBS_T_SLICE IS
8173: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8174:
8175: BEGIN
8176:
8177: print_time(' worker id is ... ' || 1);

Line 8389: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

8385:
8386: PROCEDURE POPULATE_RBS_HDR IS
8387:
8388: l_last_update_date date := SYSDATE;
8389: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
8390: l_creation_date date := SYSDATE;
8391: l_created_by NUMBER := FND_GLOBAL.USER_ID;
8392: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8393:

Line 8391: l_created_by NUMBER := FND_GLOBAL.USER_ID;

8387:
8388: l_last_update_date date := SYSDATE;
8389: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
8390: l_creation_date date := SYSDATE;
8391: l_created_by NUMBER := FND_GLOBAL.USER_ID;
8392: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8393:
8394: BEGIN
8395:

Line 8392: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

8388: l_last_update_date date := SYSDATE;
8389: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
8390: l_creation_date date := SYSDATE;
8391: l_created_by NUMBER := FND_GLOBAL.USER_ID;
8392: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8393:
8394: BEGIN
8395:
8396: /* Added for bug 13030627 */

Line 8463: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

8459:
8460: PROCEDURE POPULATE_WBS_HDR IS
8461:
8462: l_last_update_date date := SYSDATE;
8463: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
8464: l_creation_date date := SYSDATE;
8465: l_created_by NUMBER := FND_GLOBAL.USER_ID;
8466: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8467:

Line 8465: l_created_by NUMBER := FND_GLOBAL.USER_ID;

8461:
8462: l_last_update_date date := SYSDATE;
8463: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
8464: l_creation_date date := SYSDATE;
8465: l_created_by NUMBER := FND_GLOBAL.USER_ID;
8466: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8467:
8468: BEGIN
8469:

Line 8466: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

8462: l_last_update_date date := SYSDATE;
8463: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
8464: l_creation_date date := SYSDATE;
8465: l_created_by NUMBER := FND_GLOBAL.USER_ID;
8466: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8467:
8468: BEGIN
8469:
8470: print_time ( ' Before populate wbs header ' );

Line 8537: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

8533:
8534: PROCEDURE UPDATE_WBS_HDR IS
8535: -- pragma autonomous_transaction; /* Commented for Bug 14735308 */
8536: l_last_update_date date := SYSDATE;
8537: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
8538: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8539:
8540: BEGIN
8541:

Line 8538: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

8534: PROCEDURE UPDATE_WBS_HDR IS
8535: -- pragma autonomous_transaction; /* Commented for Bug 14735308 */
8536: l_last_update_date date := SYSDATE;
8537: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
8538: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
8539:
8540: BEGIN
8541:
8542: /* Added for bug 13030627 */

Line 11890: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

11886: -- Temp fix until time table will have a record for non time phasing.
11887: --
11888: PROCEDURE INSERT_NTP_CAL_RECORD ( x_max_project_id OUT NOCOPY NUMBER ) IS
11889: l_last_update_date date := SYSDATE;
11890: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
11891: l_creation_date date := SYSDATE;
11892: l_created_by NUMBER := FND_GLOBAL.USER_ID;
11893: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
11894:

Line 11892: l_created_by NUMBER := FND_GLOBAL.USER_ID;

11888: PROCEDURE INSERT_NTP_CAL_RECORD ( x_max_project_id OUT NOCOPY NUMBER ) IS
11889: l_last_update_date date := SYSDATE;
11890: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
11891: l_creation_date date := SYSDATE;
11892: l_created_by NUMBER := FND_GLOBAL.USER_ID;
11893: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
11894:
11895: l_start_end_date DATE := TRUNC(SYSDATE);
11896: BEGIN

Line 11893: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

11889: l_last_update_date date := SYSDATE;
11890: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
11891: l_creation_date date := SYSDATE;
11892: l_created_by NUMBER := FND_GLOBAL.USER_ID;
11893: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
11894:
11895: l_start_end_date DATE := TRUNC(SYSDATE);
11896: BEGIN
11897:

Line 12582: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

12578: -- Bug 6316433 : Added batch processing logic
12579: PROCEDURE MERGE_INTO_FP_FACTS IS
12580:
12581: l_last_update_date date := SYSDATE;
12582: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
12583: l_creation_date date := SYSDATE;
12584: l_created_by NUMBER := FND_GLOBAL.USER_ID;
12585: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
12586: l_process varchar2(30); /* Added for bug 7551819 */

Line 12584: l_created_by NUMBER := FND_GLOBAL.USER_ID;

12580:
12581: l_last_update_date date := SYSDATE;
12582: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
12583: l_creation_date date := SYSDATE;
12584: l_created_by NUMBER := FND_GLOBAL.USER_ID;
12585: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
12586: l_process varchar2(30); /* Added for bug 7551819 */
12587: l_from_launch varchar2(5) := 'N'; /* Added for bug 7551819 */
12588: l_rec_exist number; --Added for bug 14636607

Line 12585: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

12581: l_last_update_date date := SYSDATE;
12582: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
12583: l_creation_date date := SYSDATE;
12584: l_created_by NUMBER := FND_GLOBAL.USER_ID;
12585: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
12586: l_process varchar2(30); /* Added for bug 7551819 */
12587: l_from_launch varchar2(5) := 'N'; /* Added for bug 7551819 */
12588: l_rec_exist number; --Added for bug 14636607
12589: /* Bug Fix 9212516*/

Line 13225: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

13221: /* Added below new procedure for bug 14517209 */
13222: PROCEDURE INSERT_INTO_FP_FACTS IS
13223:
13224: l_last_update_date date := SYSDATE;
13225: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
13226: l_creation_date date := SYSDATE;
13227: l_created_by NUMBER := FND_GLOBAL.USER_ID;
13228: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
13229: l_from_launch varchar2(5) := 'N'; /* Added for bug 7551819 */

Line 13227: l_created_by NUMBER := FND_GLOBAL.USER_ID;

13223:
13224: l_last_update_date date := SYSDATE;
13225: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
13226: l_creation_date date := SYSDATE;
13227: l_created_by NUMBER := FND_GLOBAL.USER_ID;
13228: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
13229: l_from_launch varchar2(5) := 'N'; /* Added for bug 7551819 */
13230: l_process varchar2(30); /* Added for bug 7551819 */
13231: TYPE row_id_tab_type IS TABLE OF rowid index by binary_integer;

Line 13228: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

13224: l_last_update_date date := SYSDATE;
13225: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
13226: l_creation_date date := SYSDATE;
13227: l_created_by NUMBER := FND_GLOBAL.USER_ID;
13228: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
13229: l_from_launch varchar2(5) := 'N'; /* Added for bug 7551819 */
13230: l_process varchar2(30); /* Added for bug 7551819 */
13231: TYPE row_id_tab_type IS TABLE OF rowid index by binary_integer;
13232: x_row_id row_id_tab_type;

Line 13596: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

13592: retcode OUT NOCOPY VARCHAR2,
13593: p_batch_id IN number)
13594: IS
13595: l_last_update_date date := SYSDATE;
13596: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
13597: l_creation_date date := SYSDATE;
13598: l_created_by NUMBER := FND_GLOBAL.USER_ID;
13599: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
13600: l_process varchar2(30);

Line 13598: l_created_by NUMBER := FND_GLOBAL.USER_ID;

13594: IS
13595: l_last_update_date date := SYSDATE;
13596: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
13597: l_creation_date date := SYSDATE;
13598: l_created_by NUMBER := FND_GLOBAL.USER_ID;
13599: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
13600: l_process varchar2(30);
13601: l_from_launch varchar2(5) := 'N'; /* Added for bug 8416116 */
13602:

Line 13599: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

13595: l_last_update_date date := SYSDATE;
13596: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
13597: l_creation_date date := SYSDATE;
13598: l_created_by NUMBER := FND_GLOBAL.USER_ID;
13599: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
13600: l_process varchar2(30);
13601: l_from_launch varchar2(5) := 'N'; /* Added for bug 8416116 */
13602:
13603: TYPE row_id_tab_type IS TABLE OF rowid index by binary_integer;