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

Line 280: l_user_id NUMBER := FND_GLOBAL.USER_ID;

276: l_imm_par_id NUMBER;
277: l_length NUMBER;
278: l_count NUMBER;
279:
280: l_user_id NUMBER := FND_GLOBAL.USER_ID;
281: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
282: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
283: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
284:

Line 281: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

277: l_length NUMBER;
278: l_count NUMBER;
279:
280: l_user_id NUMBER := FND_GLOBAL.USER_ID;
281: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
282: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
283: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
284:
285: BEGIN

Line 282: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;

278: l_count NUMBER;
279:
280: l_user_id NUMBER := FND_GLOBAL.USER_ID;
281: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
282: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
283: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
284:
285: BEGIN
286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Initial Load of Denorm Hierarchy Parents table begining');

Line 283: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

279:
280: l_user_id NUMBER := FND_GLOBAL.USER_ID;
281: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
282: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
283: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
284:
285: BEGIN
286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Initial Load of Denorm Hierarchy Parents table begining');
287: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

Line 460: l_user_id NUMBER := FND_GLOBAL.USER_ID;

456: l_imm_par_id NUMBER;
457: l_length NUMBER;
458: l_count NUMBER := 0;
459:
460: l_user_id NUMBER := FND_GLOBAL.USER_ID;
461: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
462: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
463: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
464:

Line 461: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

457: l_length NUMBER;
458: l_count NUMBER := 0;
459:
460: l_user_id NUMBER := FND_GLOBAL.USER_ID;
461: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
462: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
463: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
464:
465: BEGIN

Line 462: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;

458: l_count NUMBER := 0;
459:
460: l_user_id NUMBER := FND_GLOBAL.USER_ID;
461: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
462: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
463: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
464:
465: BEGIN
466: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Incremental Load of Denorm Hierarchy Parents table begining.');

Line 463: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

459:
460: l_user_id NUMBER := FND_GLOBAL.USER_ID;
461: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
462: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
463: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
464:
465: BEGIN
466: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Incremental Load of Denorm Hierarchy Parents table begining.');
467:

Line 657: l_user_id NUMBER := FND_GLOBAL.USER_ID;

653:
654:
655: l_count NUMBER := 0;
656: l_dbi_installed VARCHAR2(1) := IS_DBI_INSTALLED; -- variable to hold installation flag for DBI
657: l_user_id NUMBER := FND_GLOBAL.USER_ID;
658: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
659: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
660: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
661: l_hrchy_enabled VARCHAR2(1);

Line 658: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

654:
655: l_count NUMBER := 0;
656: l_dbi_installed VARCHAR2(1) := IS_DBI_INSTALLED; -- variable to hold installation flag for DBI
657: l_user_id NUMBER := FND_GLOBAL.USER_ID;
658: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
659: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
660: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
661: l_hrchy_enabled VARCHAR2(1);
662: l_sql VARCHAR2(32000);

Line 659: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;

655: l_count NUMBER := 0;
656: l_dbi_installed VARCHAR2(1) := IS_DBI_INSTALLED; -- variable to hold installation flag for DBI
657: l_user_id NUMBER := FND_GLOBAL.USER_ID;
658: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
659: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
660: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
661: l_hrchy_enabled VARCHAR2(1);
662: l_sql VARCHAR2(32000);
663: l_validate_flag VARCHAR2(1); -- Bug# 3306212

Line 660: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

656: l_dbi_installed VARCHAR2(1) := IS_DBI_INSTALLED; -- variable to hold installation flag for DBI
657: l_user_id NUMBER := FND_GLOBAL.USER_ID;
658: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
659: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
660: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
661: l_hrchy_enabled VARCHAR2(1);
662: l_sql VARCHAR2(32000);
663: l_validate_flag VARCHAR2(1); -- Bug# 3306212
664: l_struct_id NUMBER; -- Bug# 3306212

Line 980: l_user_id NUMBER := FND_GLOBAL.USER_ID;

976: l_affected_child NUMBER;
977: l_affected_level NUMBER;
978: l_count NUMBER := 0;
979: l_dbi_installed VARCHAR2(1) := IS_DBI_INSTALLED; -- variable to hold installation flag for DBI
980: l_user_id NUMBER := FND_GLOBAL.USER_ID;
981: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
982: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
983: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
984: l_sql VARCHAR2(32000);

Line 981: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

977: l_affected_level NUMBER;
978: l_count NUMBER := 0;
979: l_dbi_installed VARCHAR2(1) := IS_DBI_INSTALLED; -- variable to hold installation flag for DBI
980: l_user_id NUMBER := FND_GLOBAL.USER_ID;
981: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
982: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
983: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
984: l_sql VARCHAR2(32000);
985: l_validate_flag VARCHAR2(1); -- Bug# 3306212

Line 982: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;

978: l_count NUMBER := 0;
979: l_dbi_installed VARCHAR2(1) := IS_DBI_INSTALLED; -- variable to hold installation flag for DBI
980: l_user_id NUMBER := FND_GLOBAL.USER_ID;
981: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
982: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
983: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
984: l_sql VARCHAR2(32000);
985: l_validate_flag VARCHAR2(1); -- Bug# 3306212
986: l_struct_id NUMBER; -- Bug# 3306212

Line 983: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

979: l_dbi_installed VARCHAR2(1) := IS_DBI_INSTALLED; -- variable to hold installation flag for DBI
980: l_user_id NUMBER := FND_GLOBAL.USER_ID;
981: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
982: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
983: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
984: l_sql VARCHAR2(32000);
985: l_validate_flag VARCHAR2(1); -- Bug# 3306212
986: l_struct_id NUMBER; -- Bug# 3306212
987:

Line 1694: l_user_id NUMBER := FND_GLOBAL.USER_ID;

1690: l_dbi_installed VARCHAR2(1) := IS_DBI_INSTALLED;
1691: l_return_status VARCHAR2(10);
1692: l_msg_count NUMBER;
1693: l_msg_data VARCHAR2(4000);
1694: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1695: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1696: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1697: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1698: l_count NUMBER;

Line 1695: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

1691: l_return_status VARCHAR2(10);
1692: l_msg_count NUMBER;
1693: l_msg_data VARCHAR2(4000);
1694: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1695: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1696: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1697: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1698: l_count NUMBER;
1699: BEGIN

Line 1696: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;

1692: l_msg_count NUMBER;
1693: l_msg_data VARCHAR2(4000);
1694: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1695: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1696: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1697: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1698: l_count NUMBER;
1699: BEGIN
1700: IF l_dbi_installed = 'Y' THEN

Line 1697: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

1693: l_msg_data VARCHAR2(4000);
1694: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1695: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1696: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1697: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1698: l_count NUMBER;
1699: BEGIN
1700: IF l_dbi_installed = 'Y' THEN
1701: EXECUTE IMMEDIATE

Line 1860: l_user_id NUMBER := FND_GLOBAL.USER_ID;

1856: PROCEDURE LOAD_OBIEE_HIERARCHY(errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY VARCHAR2) IS
1857: err VARCHAR2(2000);
1858: ret VARCHAR2(100);
1859: l_count NUMBER := 0;
1860: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1861: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1862: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1863: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1864: l_hrchy_enabled VARCHAR2(1);

Line 1861: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

1857: err VARCHAR2(2000);
1858: ret VARCHAR2(100);
1859: l_count NUMBER := 0;
1860: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1861: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1862: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1863: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1864: l_hrchy_enabled VARCHAR2(1);
1865: l_struct_id NUMBER;

Line 1862: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;

1858: ret VARCHAR2(100);
1859: l_count NUMBER := 0;
1860: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1861: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1862: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1863: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1864: l_hrchy_enabled VARCHAR2(1);
1865: l_struct_id NUMBER;
1866: l_levels_to_flatten NUMBER := 5;

Line 1863: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

1859: l_count NUMBER := 0;
1860: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1861: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1862: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1863: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1864: l_hrchy_enabled VARCHAR2(1);
1865: l_struct_id NUMBER;
1866: l_levels_to_flatten NUMBER := 5;
1867: l_sql VARCHAR2(4000);