DBA Data[Home] [Help]

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 1665: l_user_id NUMBER := FND_GLOBAL.USER_ID;

1661: l_dbi_installed VARCHAR2(1) := IS_DBI_INSTALLED;
1662: l_return_status VARCHAR2(10);
1663: l_msg_count NUMBER;
1664: l_msg_data VARCHAR2(4000);
1665: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1666: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1667: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1668: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1669: l_count NUMBER;

Line 1666: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

1662: l_return_status VARCHAR2(10);
1663: l_msg_count NUMBER;
1664: l_msg_data VARCHAR2(4000);
1665: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1666: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1667: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1668: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1669: l_count NUMBER;
1670: BEGIN

Line 1667: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;

1663: l_msg_count NUMBER;
1664: l_msg_data VARCHAR2(4000);
1665: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1666: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1667: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1668: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1669: l_count NUMBER;
1670: BEGIN
1671: IF l_dbi_installed = 'Y' THEN

Line 1668: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

1664: l_msg_data VARCHAR2(4000);
1665: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1666: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1667: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1668: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1669: l_count NUMBER;
1670: BEGIN
1671: IF l_dbi_installed = 'Y' THEN
1672: EXECUTE IMMEDIATE

Line 1831: l_user_id NUMBER := FND_GLOBAL.USER_ID;

1827: PROCEDURE LOAD_OBIEE_HIERARCHY(errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY VARCHAR2) IS
1828: err VARCHAR2(2000);
1829: ret VARCHAR2(100);
1830: l_count NUMBER := 0;
1831: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1832: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1833: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1834: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1835: l_hrchy_enabled VARCHAR2(1);

Line 1832: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

1828: err VARCHAR2(2000);
1829: ret VARCHAR2(100);
1830: l_count NUMBER := 0;
1831: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1832: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1833: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1834: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1835: l_hrchy_enabled VARCHAR2(1);
1836: l_struct_id NUMBER;

Line 1833: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;

1829: ret VARCHAR2(100);
1830: l_count NUMBER := 0;
1831: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1832: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1833: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1834: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1835: l_hrchy_enabled VARCHAR2(1);
1836: l_struct_id NUMBER;
1837: l_levels_to_flatten NUMBER := 5;

Line 1834: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

1830: l_count NUMBER := 0;
1831: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1832: l_conc_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1833: l_prog_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1834: l_conc_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1835: l_hrchy_enabled VARCHAR2(1);
1836: l_struct_id NUMBER;
1837: l_levels_to_flatten NUMBER := 5;
1838: l_sql VARCHAR2(4000);