[Home] [Help]
55: -- History
56: -- 03-17-00 Dave Maskell Created for Release 11i2.
57:
58: PROCEDURE insert_cn_not_trx (
59: x_table_map_id cn_table_maps.table_map_id%TYPE,
60: x_event_id cn_events.event_id%TYPE,
61: code IN OUT NOCOPY cn_utils.code_type,
62: x_org_id IN NUMBER)
63: IS
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) := '/'||'*'||'+';
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
174:
175: --+
176: -- Generate the FROM and WHERE clauses. Changed position fo fix Bug 6203234
177: --+
178: cn_table_maps_pvt.get_sql_clauses(
179: p_api_version => 1.0,
180: x_return_status => l_return_status,
181: x_msg_count => l_msg_count,
182: x_msg_data => l_msg_data,
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
423: -- 03-17-00 Dave Maskell Created for Release 11i2.
424: --
425: --
426: PROCEDURE insert_comm_lines_api (
427: x_table_map_id cn_table_maps.table_map_id%TYPE,
428: x_event_id cn_events.event_id%TYPE,
429: code IN OUT NOCOPY cn_utils.code_type,
430: x_org_id IN NUMBER)
431: IS
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
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: --+
458:
459: --+
460: -- Generate the FROM and WHERE clause code. Moved here to fix Bug 6203234
461: --+
462: cn_table_maps_pvt.get_sql_clauses(
463: p_api_version => 1.0,
464: x_return_status => l_return_status,
465: x_msg_count => l_msg_count,
466: x_msg_data => l_msg_data,
592: -- History
593: -- 16-Mar-00 Dave Maskell Created
594: --
595: PROCEDURE update_comm_lines_api (
596: x_table_map_id cn_table_maps.table_map_id%TYPE,
597: code IN OUT NOCOPY cn_utils.code_type,
598: x_org_id IN NUMBER)
599: IS
600:
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
661:
662: INTO
663: x_dest_table_name,
664: x_dest_alias
665: FROM cn_table_maps ctm, CN_OBJECTS CB
666: WHERE
667: ctm.table_map_id = x_table_map_id
668: and CB.object_id = CTM.destination_table_id
669: and cb.org_id = ctm.org_id
769: -- 03-29-00 Dave Maskell Created for Release 11i2.
770: --
771: --
772: PROCEDURE filter_comm_lines_api(
773: x_table_map_id cn_table_maps.table_map_id%TYPE,
774: code IN OUT NOCOPY cn_utils.code_type,
775: x_org_id IN NUMBER)
776: IS
777:
790: -- Decide whether to DELETE lines or just set them to 'FILTERED'
791: --+
792: SELECT delete_flag
793: INTO l_delete_flag
794: FROM cn_table_maps
795: WHERE table_map_id = x_table_map_id
796: AND org_id = x_org_id;
797:
798: IF l_delete_flag = 'Y' THEN