APPS.CSM_IB_TXN_SUB_TYPES_EVENT_PKG dependencies on CSM_IB_TXN_TYPES_ACC

Line 26: l_access_id CSM_IB_TXN_TYPES_ACC.ACCESS_ID%TYPE;

22: l_dsql varchar2(3000);
23: l_pub_item varchar2(30) := 'CSF_M_TXN_SUB_TYPES';
24: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
25: l_mark_dirty boolean;
26: l_access_id CSM_IB_TXN_TYPES_ACC.ACCESS_ID%TYPE;
27: l_language cs_transaction_types_tl.language%TYPE;
28: l_sub_type_id csi_ib_txn_types.sub_type_id%TYPE;
29:
30: l_tl_omfs_palm_resource_list asg_download.user_list;

Line 49: FROM csm_ib_txn_types_acc acc

45:
46: CURSOR l_deletes_cur
47: IS
48: SELECT acc.access_id
49: FROM csm_ib_txn_types_acc acc
50: WHERE NOT EXISTS
51: (SELECT cit.sub_type_id
52: FROM csi_ib_txn_types cit , csi_source_ib_types cst , csi_txn_types ctt ,
53: csi_instance_statuses cis , cs_transaction_types_b ttb

Line 107: FROM csm_ib_txn_types_acc

103:
104: cursor record_exists_csr( p_sub_type_id csi_ib_txn_types.sub_type_id%TYPE)
105: IS
106: SELECT 1
107: FROM csm_ib_txn_types_acc
108: WHERE sub_type_id = p_sub_type_id;
109:
110: l_dummy number;
111:

Line 142: DELETE FROM CSM_IB_TXN_TYPES_ACC

138: SYSDATE);
139: END LOOP;
140:
141: --remove from ACC
142: DELETE FROM CSM_IB_TXN_TYPES_ACC
143: WHERE ACCESS_ID = l_access_id;
144:
145: END LOOP;
146: --close the cursor

Line 152: FROM csm_ib_txn_types_acc acc ,

148:
149: /******* UPDATES **********/
150: --generate sql for updates
151: l_dsql := 'SELECT acc.access_id
152: FROM csm_ib_txn_types_acc acc ,
153: csi_ib_txn_types cit,
154: csi_source_ib_types cst ,
155: csi_txn_types ctt ,
156: csi_instance_statuses cis ,

Line 226: UPDATE CSM_IB_TXN_TYPES_ACC

222: ASG_DOWNLOAD.UPD, sysdate);
223: END IF;
224:
225: --update ACC
226: UPDATE CSM_IB_TXN_TYPES_ACC
227: SET LAST_UPDATE_DATE = l_run_date
228: WHERE ACCESS_ID = l_access_id;
229:
230: END LOOP;

Line 277: FROM csm_ib_txn_types_acc acc

273: )
274: )
275: AND NOT EXISTS
276: (SELECT 1
277: FROM csm_ib_txn_types_acc acc
278: WHERE acc.sub_type_id = cit.sub_type_id
279: ) ';
280:
281: --open the cursor

Line 289: select CSM_IB_TXN_TYPES_ACC_S.NEXTVAL into l_access_id from dual;

285: FETCH l_inserts_cur INTO l_sub_type_id;
286: EXIT WHEN l_inserts_cur%NOTFOUND;
287:
288: --generate access_id
289: select CSM_IB_TXN_TYPES_ACC_S.NEXTVAL into l_access_id from dual;
290:
291: --get all Palm users
292: g_all_palm_res_list := CSM_UTIL_PKG.get_all_omfs_palm_res_list;
293:

Line 314: INSERT INTO csm_ib_txn_types_acc(access_id, sub_type_id, CREATED_BY,

310: FETCH record_exists_csr into l_dummy;
311:
312: IF record_exists_csr%NOTFOUND then
313: --insert if the value does not already exists
314: INSERT INTO csm_ib_txn_types_acc(access_id, sub_type_id, CREATED_BY,
315: CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
316: VALUES (l_access_id,l_sub_type_id, fnd_global.user_id, l_run_date,
317: fnd_global.user_id, l_run_date, fnd_global.login_id);
318: