APPS.CN_COLLECTION_CUSTOM_GEN dependencies on CN_TABLE_MAPS_V

Line 51: l_table_map_rec cn_table_maps_v%ROWTYPE;

47: l_notify_from VARCHAR2(4000);
48: l_notify_where VARCHAR2(4000);
49: l_collect_from VARCHAR2(4000);
50: l_collect_where VARCHAR2(4000);
51: l_table_map_rec cn_table_maps_v%ROWTYPE;
52: l_header_key VARCHAR2(100);
53: l_line_key VARCHAR2(100);
54: l_org_id NUMBER;
55: l_parallel_hint VARCHAR2(4000) := '/'||'*'||'+';

Line 76: FROM cn_table_maps_v

72: -- Get the Table Map details for this data source
73: --+
74: SELECT *
75: INTO l_table_map_rec
76: FROM cn_table_maps_v
77: WHERE table_map_id = x_table_map_id
78: AND org_id = l_org_id; -- Added For R12 MOAC Change
79: --+
80: -- Get the name of the Line Table primary key

Line 277: x_table_map_id IN cn_table_maps_v.table_map_id%TYPE,

273: -- 03-17-00 Dave Maskell Created for Release 11i2.
274: --
275: --
276: PROCEDURE insert_comm_lines_api_select(
277: x_table_map_id IN cn_table_maps_v.table_map_id%TYPE,
278: code IN OUT NOCOPY cn_utils.code_type,
279: x_org_id IN NUMBER,
280: x_parallel_hint IN VARCHAR2)
281: IS -- Added For R12 MOAC Changes

Line 378: l_table_map_rec cn_table_maps_v%ROWTYPE;

374: l_notify_from VARCHAR2(4000);
375: l_notify_where VARCHAR2(4000);
376: l_collect_from VARCHAR2(4000);
377: l_collect_where VARCHAR2(4000);
378: l_table_map_rec cn_table_maps_v%ROWTYPE;
379: l_parallel_hint VARCHAR2(4000) := '/'||'*'||'+';
380: l_org_id NUMBER;
381: BEGIN
382: l_org_id := x_org_id;

Line 388: FROM cn_table_maps_v

384: -- Get the Table Map details for this data source
385: --+
386: SELECT *
387: INTO l_table_map_rec
388: FROM cn_table_maps_v
389: WHERE table_map_id = x_table_map_id
390: AND org_id = l_org_id;
391: --+
392: -- Generate the FROM and WHERE clause code. Moved here to fix Bug 6203234

Line 557: -- FROM cn_table_maps_v ctmv

553: -- LOWER(NVL(ctmv.destination_table_alias,ctmv.destination_table_name))
554: -- INTO
555: -- x_dest_table_name,
556: -- x_dest_alias
557: -- FROM cn_table_maps_v ctmv
558: -- WHERE ctmv.table_map_id = x_table_map_id
559: -- AND org_id =x_org_id;
560: -- Code Change added by pradeep
561: SELECT LOWER(cB.name),