APPS.CSM_MTL_PARAMETERS_EVENT_PKG dependencies on MTL_INTERORG_PARAMETERS

Line 22: g_table_name2 CONSTANT VARCHAR2(30) := 'MTL_INTERORG_PARAMETERS';

18: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_PARAMETERS');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
20: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_MTL_PARAMETERS';
21:
22: g_table_name2 CONSTANT VARCHAR2(30) := 'MTL_INTERORG_PARAMETERS';
23: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_INTERORG_PARAMETERS_ACC';
24: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
25: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_INTERORG_PARAMS');
26: g_pk1_name2 CONSTANT VARCHAR2(30) := 'FROM_ORGANIZATION_ID';

Line 243: FROM MTL_INTERORG_PARAMETERS mtsn,csp_inv_loc_assignments inv

239: CURSOR c_mtl_parameters_ins_csr(b_user_id NUMBER,b_res_id NUMBER)
240: IS
241: SELECT csm_mtl_parameters_acc_s.nextval as ACCESS_ID,b_user_id as USER_ID, from_organization_id,to_organization_id
242: FROM ( SELECT distinct mtsn.from_organization_id,mtsn.to_organization_id
243: FROM MTL_INTERORG_PARAMETERS mtsn,csp_inv_loc_assignments inv
244: WHERE b_res_id =inv.resource_id
245: AND inv.organization_id in (mtsn.from_organization_id,mtsn.to_organization_id)
246: AND NOT EXISTS (SELECT 1 FROM CSM_INTERORG_PARAMETERS_ACC acc
247: WHERE acc.from_organization_id = mtsn.from_organization_id

Line 255: FROM CSM_INTERORG_PARAMETERS_ACC acc,MTL_INTERORG_PARAMETERS mtsn

251: -- updates cur
252: CURSOR c_mtl_parameters_upd_csr(p_lrd date)
253: IS
254: SELECT acc.access_id,acc.user_id
255: FROM CSM_INTERORG_PARAMETERS_ACC acc,MTL_INTERORG_PARAMETERS mtsn
256: WHERE acc.from_organization_id = mtsn.from_organization_id
257: AND acc.to_organization_id = mtsn.to_organization_id
258: AND p_lrd < mtsn.last_update_date ;
259:

Line 266: (SELECT 1 FROM MTL_INTERORG_PARAMETERS mtsn

262: IS
263: SELECT acc.access_id,acc.user_id
264: FROM CSM_INTERORG_PARAMETERS_ACC acc
265: WHERE NOT EXISTS
266: (SELECT 1 FROM MTL_INTERORG_PARAMETERS mtsn
267: WHERE mtsn.from_organization_id = acc.from_organization_id
268: AND mtsn.to_organization_id = acc.to_organization_id
269: )
270: UNION