[Home] [Help]
738: -- History
739: -- 17-NOV-93 Devesh Khatu Created
740:
741: PROCEDURE pkg_proc_init (
742: x_table_map_id cn_table_maps.table_map_id%TYPE,
743: x_procedure_name cn_obj_procedures_v.NAME%TYPE,
744: x_description cn_obj_procedures_v.description%TYPE,
745: x_parameter_list cn_obj_procedures_v.parameter_list%TYPE,
746: x_package_id cn_obj_packages_v.package_id%TYPE,
892:
893: PROCEDURE collect_stmts (
894: x_package_id cn_obj_packages_v.package_id%TYPE,
895: x_procedure_name cn_obj_procedures_v.NAME%TYPE,
896: x_table_map_id cn_table_maps.table_map_id%TYPE,
897: x_module_id cn_modules.module_id%TYPE,
898: x_repository_id cn_repositories.repository_id%TYPE,
899: x_generic BOOLEAN,
900: x_event_id cn_events.event_id%TYPE,
1087: -- History
1088: -- 17-NOV-93 Devesh Khatu Created
1089: --
1090: PROCEDURE pkg_proc_end (
1091: x_table_map_id cn_table_maps.table_map_id%TYPE,
1092: x_procedure_name cn_objects.NAME%TYPE,
1093: x_event_id cn_events.event_id%TYPE,
1094: code IN OUT NOCOPY cn_utils.code_type,
1095: x_org_id IN NUMBER) IS
1197: --+
1198: PROCEDURE collection_proc (
1199: package_name cn_objects.NAME%TYPE,
1200: package_id cn_objects.package_id%TYPE,
1201: x_table_map_id cn_table_maps.table_map_id%TYPE,
1202: module_id cn_modules.module_id%TYPE,
1203: repository_id cn_repositories.repository_id%TYPE,
1204: event_id cn_events.event_id%TYPE,
1205: x_generic BOOLEAN,
1358: x_org_append VARCHAR2,
1359: x_collect_flag cn_modules.collect_flag%TYPE,
1360: x_module_id cn_modules.module_id%TYPE,
1361: x_generic BOOLEAN,
1362: x_table_map_id cn_table_maps.table_map_id%TYPE,
1363: x_org_id IN NUMBER) IS
1364:
1365: l_package_type cn_objects.package_type%TYPE;
1366: l_package_spec_id cn_obj_packages_v.package_id%TYPE;
1470: --+
1471: PROCEDURE collection_pkg (
1472: debug_pipe VARCHAR2,
1473: debug_level NUMBER := 1,
1474: x_table_map_id cn_table_maps.table_map_id%TYPE,
1475: x_org_id IN NUMBER) IS
1476:
1477: l_generic BOOLEAN := FALSE;
1478: l_module_id cn_modules.module_id%TYPE;
1500: END IF;
1501: cn_debug.print_msg('collection_pkg>>', 1);
1502: fnd_file.put_line(fnd_file.Log, 'collection_pkg>>');
1503: --+
1504: -- Get info about this data source from cn_table_maps
1505: --+
1506: SELECT mapping_type, module_id
1507: INTO l_mapping_type, l_module_id
1508: FROM cn_table_maps
1504: -- Get info about this data source from cn_table_maps
1505: --+
1506: SELECT mapping_type, module_id
1507: INTO l_mapping_type, l_module_id
1508: FROM cn_table_maps
1509: WHERE table_map_id = x_table_map_id
1510: AND org_id = X_ORG_ID;
1511: --+
1512: -- Process according to the mapping data source
1601:
1602: PROCEDURE Collection_Install(
1603: x_errbuf OUT NOCOPY VARCHAR2,
1604: x_retcode OUT NOCOPY NUMBER,
1605: p_table_map_id IN cn_table_maps.table_map_id%TYPE,
1606: p_test IN VARCHAR2 ,
1607: x_org_id IN NUMBER)
1608: IS
1609: l_org_append VARCHAR2(10);
1607: x_org_id IN NUMBER)
1608: IS
1609: l_org_append VARCHAR2(10);
1610: l_test_append VARCHAR2(5);
1611: l_mapping_type cn_table_maps.mapping_type%TYPE;
1612: l_module_id cn_table_maps.module_id%TYPE;
1613: l_comp_error VARCHAR2(10);
1614: l_errors BOOLEAN := FALSE;
1615: l_max_len NUMBER := 1800;
1608: IS
1609: l_org_append VARCHAR2(10);
1610: l_test_append VARCHAR2(5);
1611: l_mapping_type cn_table_maps.mapping_type%TYPE;
1612: l_module_id cn_table_maps.module_id%TYPE;
1613: l_comp_error VARCHAR2(10);
1614: l_errors BOOLEAN := FALSE;
1615: l_max_len NUMBER := 1800;
1616: l_remainder NUMBER;
1650: --+
1651:
1652: SELECT mapping_type, module_id
1653: INTO l_mapping_type, l_module_id
1654: FROM cn_table_maps
1655: WHERE table_map_id = p_table_map_id
1656: AND org_id = X_org_id;
1657:
1658: --dbms_output.put_line(' In Collection Install l_mapping_type : '||l_mapping_type);
1875: SELECT tm.table_map_id,
1876: tm.org_id,
1877: tm.module_id,
1878: mo.module_status
1879: FROM cn_table_maps_all tm,
1880: cn_modules_all_b mo
1881: WHERE tm.module_id = mo.module_id
1882: AND tm.org_id = mo.org_id
1883: AND mo.module_status = 'GENERATED'