APPS.CSM_IB_TXN_SUB_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(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;

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(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;

Line 122: g_all_palm_res_list := CSM_UTIL_PKG.get_all_omfs_palm_res_list;

118: -- conc program run date
119: l_run_date := SYSDATE;
120:
121: --get all the OMFS Palm users
122: g_all_palm_res_list := CSM_UTIL_PKG.get_all_omfs_palm_res_list;
123:
124: /****** DELETES **********/
125: --open the cursor
126: open l_deletes_cur;

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

130: EXIT WHEN l_deletes_cur%NOTFOUND;
131:
132: --mark dirty the SDQ for all users
133: FOR i IN 1 .. g_all_palm_res_list.COUNT LOOP
134: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource(l_pub_item,
135: l_access_id,
136: g_all_palm_res_list(i),
137: ASG_DOWNLOAD.DEL,
138: SYSDATE);

Line 210: g_all_palm_res_list := CSM_UTIL_PKG.get_all_omfs_palm_res_list;

206: FETCH l_updates_cur INTO l_access_id;
207: EXIT WHEN l_updates_cur%NOTFOUND;
208:
209: --get all Palm users
210: g_all_palm_res_list := CSM_UTIL_PKG.get_all_omfs_palm_res_list;
211:
212: --nullify the access list
213: l_single_access_id_list := l_null_access_list;
214: FOR i in 1 .. g_all_palm_res_list.COUNT LOOP

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

216: END LOOP;
217:
218: --mark dirty the SDQ for all users
219: IF l_single_access_id_list.count > 0 then
220: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource(l_pub_item,
221: l_single_access_id_list, g_all_palm_res_list,
222: ASG_DOWNLOAD.UPD, sysdate);
223: END IF;
224:

Line 292: g_all_palm_res_list := CSM_UTIL_PKG.get_all_omfs_palm_res_list;

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:
294: --nullify the access list
295: l_single_access_id_list := l_null_access_list;
296: FOR i in 1 .. g_all_palm_res_list.COUNT LOOP

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

298: END LOOP;
299:
300: --mark dirty the SDQ for all users
301: IF l_single_access_id_list.count > 0 then
302: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource(l_pub_item,
303: l_single_access_id_list, g_all_palm_res_list,
304: ASG_DOWNLOAD.INS, sysdate);
305: END IF;
306: