APPS.CN_TABLE_MAPS_PVT dependencies on CN_EVENTS

Line 29: l_event_id cn_events.event_id%TYPE;

25: ) IS
26: l_api_name CONSTANT VARCHAR2(30) := 'Create_Map';
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;

Line 30: l_application_repository_id cn_events.application_repository_id%TYPE;

26: l_api_name CONSTANT VARCHAR2(30) := 'Create_Map';
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;

Line 124: SELECT cn_events_s.NEXTVAL

120: FROM cn_modules
121: WHERE module_type = 'COL'
122: AND org_id = l_org_id;
123:
124: SELECT cn_events_s.NEXTVAL
125: INTO l_event_id
126: FROM dual;
127:
128: --+

Line 139: cn_events_all_pkg.insert_row (

135: --+ Create Event
136: --+ Added ORG_ID MOAC Change
137: --+
138:
139: cn_events_all_pkg.insert_row (
140: x_rowid => l_rowid,
141: x_event_id => l_event_id,
142: x_application_repository_id => l_application_repository_id,
143: x_description => NULL,

Line 441: l_event_id cn_events.event_id%TYPE;

437: ) IS
438: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Map';
439: l_api_version CONSTANT NUMBER := 1.0;
440: l_rowid ROWID;
441: l_event_id cn_events.event_id%TYPE;
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

Line 511: cn_events_all_pkg.delete_row (x_event_id => l_table_map_rec.event_id,

507: CLOSE c_table_map;
508: --+
509: --+ Delete Event
510: --+
511: cn_events_all_pkg.delete_row (x_event_id => l_table_map_rec.event_id,
512: x_org_id => p_org_id); -- Added For R12 MOAC
513: --+
514: --+ Delete Module
515: --+

Line 792: l_evn_object_version_number cn_events_all_b.object_version_number%TYPE := 1;

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

Line 861: cn_events_all_pkg.update_row

857: x_object_version_number => p_object_version_number,
858: x_org_id => l_org_id); -- Added For R12 MOAC
859:
860: IF p_event_id IS NOT NULL THEN
861: cn_events_all_pkg.update_row
862: (x_event_id => p_event_id,
863: x_application_repository_id => 100,
864: x_description => NULL,
865: x_name => p_event_name,

Line 945: l_application_repository_id cn_events.application_repository_id%TYPE;

941:
942: l_api_name CONSTANT VARCHAR2(30) := 'Create_Table_Map_Object';
943: l_api_version CONSTANT NUMBER := 1.0;
944: l_rowid ROWID;
945: l_application_repository_id cn_events.application_repository_id%TYPE;
946: l_org_id NUMBER;
947: BEGIN
948: -- Standard Start of API savepoint
949: SAVEPOINT Create_Table_Map_Object;