APPS.CN_TABLE_MAPS_PVT dependencies on CN_MODULES

Line 31: l_parent_module_id cn_modules.parent_module_id%TYPE;

27: l_api_version CONSTANT NUMBER := 1.0;
28: l_rowid ROWID;
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;

Line 120: FROM cn_modules

116: --+ Get Repository_Id, Parent_Module_Id and Event_Id
117: --+
118: SELECT repository_id, module_id
119: INTO l_application_repository_id, l_parent_module_id
120: FROM cn_modules
121: WHERE module_type = 'COL'
122: AND org_id = l_org_id;
123:
124: SELECT cn_events_s.NEXTVAL

Line 157: SELECT cn_modules_s.NEXTVAL

153:
154: --+
155: --+ Get Module_Id
156: --+
157: SELECT cn_modules_s.NEXTVAL
158: INTO p_table_map_rec.module_id
159: FROM dual;
160: --+
161: --+ Create Module using Source Name and Event Id

Line 164: cn_modules_pkg.insert_row (

160: --+
161: --+ Create Module using Source Name and Event Id
162: --+ Added ORG_ID MOAC Change
163: --+
164: cn_modules_pkg.insert_row (
165: x_rowid => l_rowid,
166: x_module_id => p_table_map_rec.module_id,
167: x_module_type => p_table_map_rec.mapping_type,
168: x_repository_id => l_application_repository_id,

Line 516: cn_modules_pkg.delete_row (x_module_id => l_table_map_rec.module_id,

512: x_org_id => p_org_id); -- Added For R12 MOAC
513: --+
514: --+ Delete Module
515: --+
516: cn_modules_pkg.delete_row (x_module_id => l_table_map_rec.module_id,
517: x_org_id => p_org_id); -- Added For R12 MOAC
518: --+
519: --+ Delete Table Map
520: --+

Line 793: --l_mod_object_version_number cn_modules_all_b.object_version_number%TYPE;

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:
796: CURSOR l_ovn_csr IS
797: SELECT object_version_number

Line 972: FROM cn_modules_all_b

968: -- API body
969: -------------------+
970: SELECT repository_id
971: INTO l_application_repository_id
972: FROM cn_modules_all_b
973: WHERE module_type = 'COL' -- name = 'Collection';
974: AND org_id = x_org_id; -- MOAC Change Need To Verify
975: --+
976: