APPS.CSM_TXN_BILL_TYPES_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 20: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;

16: procedure Refresh_Acc (p_status OUT NOCOPY VARCHAR2,
17: p_message OUT NOCOPY VARCHAR2)
18: IS
19: PRAGMA AUTONOMOUS_TRANSACTION;
20: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
21: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
22: l_dsql varchar2(2048);
23: l_pub_item varchar2(30) := 'CSF_M_TXN_BILLING_TYPES';
24: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

Line 21: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;

17: p_message OUT NOCOPY VARCHAR2)
18: IS
19: PRAGMA AUTONOMOUS_TRANSACTION;
20: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
21: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
22: l_dsql varchar2(2048);
23: l_pub_item varchar2(30) := 'CSF_M_TXN_BILLING_TYPES';
24: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
25: l_mark_dirty boolean;

Line 100: g_all_palm_res_list := CSM_UTIL_PKG.get_all_omfs_palm_res_list;

96: -- conc program run date
97: l_run_date := SYSDATE;
98:
99: --get all the OMFS Palm users
100: g_all_palm_res_list := CSM_UTIL_PKG.get_all_omfs_palm_res_list;
101:
102: /****** DELETES **********/
103: --open the cursor
104: open l_deletes_cur;

Line 112: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource(l_pub_item,

108: EXIT WHEN l_deletes_cur%NOTFOUND;
109:
110: --mark dirty the SDQ for all users
111: FOR i IN 1 .. g_all_palm_res_list.COUNT LOOP
112: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource(l_pub_item,
113: l_access_id,
114: g_all_palm_res_list(i),
115: ASG_DOWNLOAD.DEL,
116: SYSDATE);

Line 165: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(l_language);

161: FETCH l_updates_cur INTO l_access_id, l_language;
162: EXIT WHEN l_updates_cur%NOTFOUND;
163:
164: --get the users with this language
165: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(l_language);
166:
167: --nullify the access list
168: l_single_access_id_list := l_null_access_list;
169: FOR i in 1 .. l_tl_omfs_palm_resource_list.COUNT LOOP

Line 175: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource(l_pub_item,

171: END LOOP;
172:
173: --mark dirty the SDQ for all users
174: IF l_single_access_id_list.count > 0 then
175: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource(l_pub_item,
176: l_single_access_id_list, l_tl_omfs_palm_resource_list,
177: ASG_DOWNLOAD.UPD, sysdate);
178: END IF;
179:

Line 229: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_txn_types_tl_cur.language);

225:
226: FOR r_txn_types_tl_cur IN l_txn_types_tl_cur(l_transaction_type_id) LOOP
227: --get the users with this language
228: l_tl_omfs_palm_resource_list := l_null_resource_list;
229: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_txn_types_tl_cur.language);
230:
231: --nullify the access list
232: l_single_access_id_list := l_null_access_list;
233: FOR i in 1 .. l_tl_omfs_palm_resource_list.COUNT LOOP

Line 239: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_TXN_BILLING_TYPES',

235: END LOOP;
236:
237: --mark dirty the SDQ for all users
238: IF l_single_access_id_list.count > 0 THEN
239: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_TXN_BILLING_TYPES',
240: l_single_access_id_list, l_tl_omfs_palm_resource_list,
241: ASG_DOWNLOAD.INS, sysdate);
242: END IF;
243: