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:
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
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');
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, ' ');
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:
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
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.');
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:
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);
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);
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
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
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);
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
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
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:
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;
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
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
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
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);
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;
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;
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);