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.

APPS.CN_TABLE_MAPS_PVT dependencies on CN_TABLE_MAPS

Line 1: PACKAGE BODY CN_TABLE_MAPS_PVT AS

1: PACKAGE BODY CN_TABLE_MAPS_PVT AS
2: /* $Header: cnvtmapb.pls 120.8 2006/01/11 23:53:52 apink noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_TABLE_MAPS_PVT';
5: G_LAST_UPDATE_DATE DATE := SYSDATE;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_TABLE_MAPS_PVT';

1: PACKAGE BODY CN_TABLE_MAPS_PVT AS
2: /* $Header: cnvtmapb.pls 120.8 2006/01/11 23:53:52 apink noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_TABLE_MAPS_PVT';
5: G_LAST_UPDATE_DATE DATE := SYSDATE;
6: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
7: G_CREATION_DATE DATE := SYSDATE;
8: G_CREATED_BY NUMBER := fnd_global.user_id;

Line 101: FROM cn_table_maps

97:
98: -- Check if the mapping type exists.
99: SELECT count(1)
100: INTO l_count
101: FROM cn_table_maps
102: WHERE mapping_type = p_table_map_rec.mapping_type
103: AND org_id = l_org_id;
104:
105: IF l_count >= 1 THEN

Line 187: --+ cn_table_maps.source_table_id is a legacy column, but is NOT NULL so we

183: x_last_update_login => p_table_map_rec.last_update_login,
184: x_org_id => p_table_map_rec.org_id);
185:
186: --+
187: --+ cn_table_maps.source_table_id is a legacy column, but is NOT NULL so we
188: --+ must fill it. However, we must make sure that it is the table to which
189: --+ the source_tbl_pkcol_id belongs...
190: --+
191: --+ SELECT table_id

Line 205: --+ As It Is Required Column In CN_TABLE_MAPS_ALL

201: AND org_id = p_table_map_rec.org_id;
202:
203: --+
204: --+ Select Destination Table Id For CN_COMM_LINES_API
205: --+ As It Is Required Column In CN_TABLE_MAPS_ALL
206: --+
207:
208: SELECT object_id
209: INTO p_table_map_rec.destination_table_id

Line 219: cn_table_maps_pkg.insert_row(

215: --+
216: IF p_table_map_rec.delete_flag IS NULL THEN
217: p_table_map_rec.delete_flag := 'N';
218: END IF;
219: cn_table_maps_pkg.insert_row(
220: x_rowid => l_rowid,
221: x_table_map_id => p_table_map_rec.table_map_id, -- autocreated if left null
222: x_mapping_type => p_table_map_rec.mapping_type,
223: x_module_id => p_table_map_rec.module_id,

Line 320: p_source_object_code => 'CN_TABLE_MAPS',

316: x_return_status => x_return_status,
317: x_msg_count => x_msg_count,
318: x_msg_data => x_msg_data,
319: p_source_object_id => p_table_map_rec.table_map_id,
320: p_source_object_code => 'CN_TABLE_MAPS',
321: p_notes => l_note_msg,
322: p_notes_detail => l_note_msg,
323: p_note_type => 'CN_SYSGEN',
324: x_jtf_note_id => x_note_id

Line 339: p_source_object_code => 'CN_TABLE_MAPS',

335: x_return_status => x_return_status,
336: x_msg_count => x_msg_count,
337: x_msg_data => x_msg_data,
338: p_source_object_id => p_table_map_rec.table_map_id,
339: p_source_object_code => 'CN_TABLE_MAPS',
340: p_notes => l_note_msg,
341: p_notes_detail => l_note_msg,
342: p_note_type => 'CN_SYSGEN',
343: x_jtf_note_id => x_note_id

Line 362: p_source_object_code => 'CN_TABLE_MAPS',

358: x_return_status => x_return_status,
359: x_msg_count => x_msg_count,
360: x_msg_data => x_msg_data,
361: p_source_object_id => p_table_map_rec.table_map_id,
362: p_source_object_code => 'CN_TABLE_MAPS',
363: p_notes => l_note_msg,
364: p_notes_detail => l_note_msg,
365: p_note_type => 'CN_SYSGEN',
366: x_jtf_note_id => x_note_id

Line 385: p_source_object_code => 'CN_TABLE_MAPS',

381: x_return_status => x_return_status,
382: x_msg_count => x_msg_count,
383: x_msg_data => x_msg_data,
384: p_source_object_id => p_table_map_rec.table_map_id,
385: p_source_object_code => 'CN_TABLE_MAPS',
386: p_notes => l_note_msg,
387: p_notes_detail => l_note_msg,
388: p_note_type => 'CN_SYSGEN',
389: x_jtf_note_id => x_note_id

Line 446: SELECT * FROM cn_table_maps_v

442: l_pkg_spec_id cn_objects.object_id%TYPE;
443: l_pkg_body_id cn_objects.object_id%TYPE;
444:
445: CURSOR c_table_map IS
446: SELECT * FROM cn_table_maps_v
447: WHERE table_map_id = p_table_map_id
448: AND org_id = p_org_id; -- Added For MOAC
449: -- Need To Change This View Definition
450: -- And Then Add This Clause

Line 521: cn_table_maps_pkg.delete_row(x_table_map_id => p_table_map_id,

517: x_org_id => p_org_id); -- Added For R12 MOAC
518: --+
519: --+ Delete Table Map
520: --+
521: cn_table_maps_pkg.delete_row(x_table_map_id => p_table_map_id,
522: x_org_id => p_org_id); -- Added For R12 MOAC
523: --+
524: --+ Delete column-mapping mapping rows
525: --+

Line 652: l_ovn_tbl_number cn_table_maps.object_version_number%TYPE;

648:
649: l_api_name CONSTANT VARCHAR2(30) := 'Update_Table_Map_Objects';
650: l_api_version CONSTANT NUMBER := 1.0;
651: l_ovn_obj_number cn_objects.object_version_number%TYPE;
652: l_ovn_tbl_number cn_table_maps.object_version_number%TYPE;
653:
654: l_org_id NUMBER; -- Added For R12 MOAC
655:
656: CURSOR l_ovn_obj IS

Line 664: FROM cn_table_maps

660: AND org_id = x_org_id; -- Added For R12 MOAC
661:
662: CURSOR l_ovn_tbl IS
663: SELECT object_version_number
664: FROM cn_table_maps
665: WHERE table_map_id = p_table_map_id
666: AND org_id = x_org_id; -- Added For R12 MOAC
667:
668: BEGIN

Line 714: UPDATE cn_table_maps

710: l_org_id := x_org_id;
711:
712: IF p_delete_flag = 'Y'
713: THEN
714: UPDATE cn_table_maps
715: SET delete_flag = p_delete_flag,
716: object_version_number = l_ovn_tbl_number + 1
717: WHERE table_map_id = p_table_map_id
718: AND org_id = l_org_id;

Line 791: l_object_version_number cn_table_maps.object_version_number%TYPE;

787: IS
788:
789: l_api_name CONSTANT VARCHAR2(30) := 'update_trx_source';
790: l_api_version CONSTANT NUMBER := 1.0;
791: l_object_version_number cn_table_maps.object_version_number%TYPE;
792: l_evn_object_version_number cn_events_all_b.object_version_number%TYPE := 1;
793: --l_mod_object_version_number cn_modules_all_b.object_version_number%TYPE;
794: l_org_id NUMBER; -- Added For R12 MOAC
795:

Line 798: FROM cn_table_maps

794: l_org_id NUMBER; -- Added For R12 MOAC
795:
796: CURSOR l_ovn_csr IS
797: SELECT object_version_number
798: FROM cn_table_maps
799: WHERE table_map_id = p_table_map_id
800: AND org_id = x_org_id; -- Added For R12 MOAC
801:
802:

Line 843: cn_table_maps_pkg.update_row(x_table_map_id=> p_table_map_id,

839: l_org_id := x_org_id;
840:
841:
842:
843: cn_table_maps_pkg.update_row(x_table_map_id=> p_table_map_id,
844: x_mapping_type => p_mapping_type,
845: x_module_id => p_module_id,
846: x_source_table_id => p_source_table_id,
847: x_source_tbl_pkcol_id => p_source_tbl_pkcol_id,

Line 1189: cn_table_maps_v tmv

1185: LOWER(tmv.header_table_name) hdr_tab_name,
1186: LOWER(NVL(tmv.header_table_alias,tmv.header_table_name)) hdr_tab_alias,
1187: LOWER(tmv.hdrpk_name) hdr_pk_col
1188: FROM
1189: cn_table_maps_v tmv
1190: WHERE
1191: tmv.table_map_id = p_table_map_id
1192: AND tmv.org_id = p_org_id;
1193: l_c1_rec c1%ROWTYPE;

Line 1216: -- Get the information from CN_TABLE_MAPS about the Line table and how

1212: -------------------+
1213: -- API body
1214: -------------------+
1215: --+
1216: -- Get the information from CN_TABLE_MAPS about the Line table and how
1217: -- to join it to the Header table (if there is one)
1218: --+
1219: OPEN c1;
1220: FETCH c1 into l_c1_rec;

Line 1324: END cn_table_maps_pvt;

1320: p_data => x_msg_data,
1321: p_encoded => FND_API.G_FALSE);
1322: END Get_SQL_Clauses;
1323:
1324: END cn_table_maps_pvt;
1325: