APPS.CN_TABLE_MAPS_PVT dependencies on CN_COLUMN_MAPS

Line 33: l_column_map_id cn_column_maps.column_map_id%TYPE;

29: l_event_id cn_events.event_id%TYPE;
30: l_application_repository_id cn_events.application_repository_id%TYPE;
31: l_parent_module_id cn_modules.parent_module_id%TYPE;
32: l_user_id NUMBER := nvl(fnd_profile.value('USER_ID'),-1);
33: l_column_map_id cn_column_maps.column_map_id%TYPE;
34: l_object_id cn_objects.object_id%TYPE;
35: l_table_map_object_id cn_table_map_objects.object_id%TYPE;
36: l_org_append VARCHAR2(100);
37: l_count NUMBER;

Line 242: FROM cn_column_maps

238: --+
239:
240: FOR rec IN
241: (SELECT *
242: FROM cn_column_maps
243: WHERE table_map_id = -999
244: AND org_id = l_org_id) -- MOAC Need To Verify
245: LOOP
246: l_column_map_id := NULL; -- set inside the procedure

Line 247: cn_column_maps_pkg.insert_row (

243: WHERE table_map_id = -999
244: AND org_id = l_org_id) -- MOAC Need To Verify
245: LOOP
246: l_column_map_id := NULL; -- set inside the procedure
247: cn_column_maps_pkg.insert_row (
248: x_rowid => l_rowid,
249: x_column_map_id => l_column_map_id,
250: x_destination_column_id => rec.destination_column_id,
251: x_table_map_id => p_table_map_rec.table_map_id,

Line 526: DELETE FROM cn_column_maps

522: x_org_id => p_org_id); -- Added For R12 MOAC
523: --+
524: --+ Delete column-mapping mapping rows
525: --+
526: DELETE FROM cn_column_maps
527: WHERE table_map_id = p_table_map_id
528: AND org_id = p_org_id; -- Added For R12 MOAC
529: --+
530: --+ Delete Collection Package Spec and Body objects