APPS.CN_COLLECTION_CUSTOM_GEN dependencies on CN_TABLE_MAPS_V

Line 72: l_table_map_rec cn_table_maps_v%ROWTYPE;

68: l_notify_from VARCHAR2(4000);
69: l_notify_where VARCHAR2(4000);
70: l_collect_from VARCHAR2(4000);
71: l_collect_where VARCHAR2(4000);
72: l_table_map_rec cn_table_maps_v%ROWTYPE;
73: l_header_key VARCHAR2(100);
74: l_line_key VARCHAR2(100);
75: l_org_id NUMBER;
76: l_parallel_hint VARCHAR2(4000) := '/'||'*'||'+';

Line 100: FROM cn_table_maps_v

96: --+
97:
98: SELECT *
99: INTO l_table_map_rec
100: FROM cn_table_maps_v
101: WHERE table_map_id = x_table_map_id
102: AND org_id = l_org_id; -- Added For R12 MOAC Change
103: --+
104: -- Get the name of the Line Table primary key

Line 327: x_table_map_id IN cn_table_maps_v.table_map_id%TYPE,

323: -- 03-17-00 Dave Maskell Created for Release 11i2.
324: --
325: --
326: PROCEDURE insert_comm_lines_api_select(
327: x_table_map_id IN cn_table_maps_v.table_map_id%TYPE,
328: code IN OUT NOCOPY cn_utils.code_type,
329: x_org_id IN NUMBER,
330: x_parallel_hint IN VARCHAR2)
331: IS -- Added For R12 MOAC Changes

Line 440: l_table_map_rec cn_table_maps_v%ROWTYPE;

436: l_notify_from VARCHAR2(4000);
437: l_notify_where VARCHAR2(4000);
438: l_collect_from VARCHAR2(4000);
439: l_collect_where VARCHAR2(4000);
440: l_table_map_rec cn_table_maps_v%ROWTYPE;
441: l_parallel_hint VARCHAR2(4000) := '/'||'*'||'+';
442: l_org_id NUMBER;
443:
444: BEGIN

Line 455: FROM cn_table_maps_v

451: -- Get the Table Map details for this data source
452: --+
453: SELECT *
454: INTO l_table_map_rec
455: FROM cn_table_maps_v
456: WHERE table_map_id = x_table_map_id
457: AND org_id = l_org_id;
458:
459: --+

Line 653: -- FROM cn_table_maps_v ctmv

649: -- INTO
650: -- x_dest_table_name,
651: -- x_dest_alias
652:
653: -- FROM cn_table_maps_v ctmv
654: -- WHERE ctmv.table_map_id = x_table_map_id
655: -- AND org_id =x_org_id;
656:
657: -- Code Change added by pradeep