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.

[Home] [Help]

APPS.CN_COLLECTION_GEN dependencies on CN_TABLE_MAPS

Line 723: x_table_map_id cn_table_maps.table_map_id%TYPE,

719: -- History
720: -- 17-NOV-93 Devesh Khatu Created
721:
722: PROCEDURE pkg_proc_init (
723: x_table_map_id cn_table_maps.table_map_id%TYPE,
724: x_procedure_name cn_obj_procedures_v.NAME%TYPE,
725: x_description cn_obj_procedures_v.description%TYPE,
726: x_parameter_list cn_obj_procedures_v.parameter_list%TYPE,
727: x_package_id cn_obj_packages_v.package_id%TYPE,

Line 865: x_table_map_id cn_table_maps.table_map_id%TYPE,

861:
862: PROCEDURE collect_stmts (
863: x_package_id cn_obj_packages_v.package_id%TYPE,
864: x_procedure_name cn_obj_procedures_v.NAME%TYPE,
865: x_table_map_id cn_table_maps.table_map_id%TYPE,
866: x_module_id cn_modules.module_id%TYPE,
867: x_repository_id cn_repositories.repository_id%TYPE,
868: x_generic BOOLEAN,
869: x_event_id cn_events.event_id%TYPE,

Line 1060: x_table_map_id cn_table_maps.table_map_id%TYPE,

1056: -- History
1057: -- 17-NOV-93 Devesh Khatu Created
1058: --
1059: PROCEDURE pkg_proc_end (
1060: x_table_map_id cn_table_maps.table_map_id%TYPE,
1061: x_procedure_name cn_objects.NAME%TYPE,
1062: x_event_id cn_events.event_id%TYPE,
1063: code IN OUT NOCOPY cn_utils.code_type,
1064: x_org_id IN NUMBER) IS

Line 1154: x_table_map_id cn_table_maps.table_map_id%TYPE,

1150: --+
1151: PROCEDURE collection_proc (
1152: package_name cn_objects.NAME%TYPE,
1153: package_id cn_objects.package_id%TYPE,
1154: x_table_map_id cn_table_maps.table_map_id%TYPE,
1155: module_id cn_modules.module_id%TYPE,
1156: repository_id cn_repositories.repository_id%TYPE,
1157: event_id cn_events.event_id%TYPE,
1158: x_generic BOOLEAN,

Line 1312: x_table_map_id cn_table_maps.table_map_id%TYPE,

1308: x_org_append VARCHAR2,
1309: x_collect_flag cn_modules.collect_flag%TYPE,
1310: x_module_id cn_modules.module_id%TYPE,
1311: x_generic BOOLEAN,
1312: x_table_map_id cn_table_maps.table_map_id%TYPE,
1313: x_org_id IN NUMBER) IS
1314:
1315: l_package_type cn_objects.package_type%TYPE;
1316: l_package_spec_id cn_obj_packages_v.package_id%TYPE;

Line 1424: x_table_map_id cn_table_maps.table_map_id%TYPE,

1420: --+
1421: PROCEDURE collection_pkg (
1422: debug_pipe VARCHAR2,
1423: debug_level NUMBER := 1,
1424: x_table_map_id cn_table_maps.table_map_id%TYPE,
1425: x_org_id IN NUMBER) IS
1426:
1427: l_generic BOOLEAN := FALSE;
1428: l_module_id cn_modules.module_id%TYPE;

Line 1447: -- Get info about this data source from cn_table_maps

1443: END IF;
1444: cn_debug.print_msg('collection_pkg>>', 1);
1445: fnd_file.put_line(fnd_file.Log, 'collection_pkg>>');
1446: --+
1447: -- Get info about this data source from cn_table_maps
1448: --+
1449: SELECT mapping_type, module_id
1450: INTO l_mapping_type, l_module_id
1451: FROM cn_table_maps

Line 1451: FROM cn_table_maps

1447: -- Get info about this data source from cn_table_maps
1448: --+
1449: SELECT mapping_type, module_id
1450: INTO l_mapping_type, l_module_id
1451: FROM cn_table_maps
1452: WHERE table_map_id = x_table_map_id
1453: AND org_id = X_ORG_ID;
1454: --+
1455: -- Process according to the mapping data source

Line 1546: p_table_map_id IN cn_table_maps.table_map_id%TYPE,

1542:
1543: PROCEDURE Collection_Install(
1544: x_errbuf OUT NOCOPY VARCHAR2,
1545: x_retcode OUT NOCOPY NUMBER,
1546: p_table_map_id IN cn_table_maps.table_map_id%TYPE,
1547: p_test IN VARCHAR2 ,
1548: x_org_id IN NUMBER)
1549: IS
1550: l_org_append VARCHAR2(10);

Line 1552: l_mapping_type cn_table_maps.mapping_type%TYPE;

1548: x_org_id IN NUMBER)
1549: IS
1550: l_org_append VARCHAR2(10);
1551: l_test_append VARCHAR2(5);
1552: l_mapping_type cn_table_maps.mapping_type%TYPE;
1553: l_module_id cn_table_maps.module_id%TYPE;
1554: l_comp_error VARCHAR2(10);
1555: l_errors BOOLEAN := FALSE;
1556: l_max_len NUMBER := 1800;

Line 1553: l_module_id cn_table_maps.module_id%TYPE;

1549: IS
1550: l_org_append VARCHAR2(10);
1551: l_test_append VARCHAR2(5);
1552: l_mapping_type cn_table_maps.mapping_type%TYPE;
1553: l_module_id cn_table_maps.module_id%TYPE;
1554: l_comp_error VARCHAR2(10);
1555: l_errors BOOLEAN := FALSE;
1556: l_max_len NUMBER := 1800;
1557: l_remainder NUMBER;

Line 1589: FROM cn_table_maps

1585: --+
1586:
1587: SELECT mapping_type, module_id
1588: INTO l_mapping_type, l_module_id
1589: FROM cn_table_maps
1590: WHERE table_map_id = p_table_map_id
1591: AND org_id = X_org_id;
1592:
1593: --dbms_output.put_line(' In Collection Install l_mapping_type : '||l_mapping_type);

Line 1814: FROM cn_table_maps_all tm,

1810: SELECT tm.table_map_id,
1811: tm.org_id,
1812: tm.module_id,
1813: mo.module_status
1814: FROM cn_table_maps_all tm,
1815: cn_modules_all_b mo
1816: WHERE tm.module_id = mo.module_id
1817: AND tm.org_id = mo.org_id
1818: AND mo.module_status = 'GENERATED'