APPS.CSM_BUS_PROCESS_TXNS_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 27: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;

23: PROCEDURE Refresh_Acc(p_status OUT NOCOPY VARCHAR2,
24: p_message OUT NOCOPY VARCHAR2) AS
25: PRAGMA AUTONOMOUS_TRANSACTION;
26:
27: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
28: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
29: l_dsql varchar2(2048);
30: l_pub_item varchar2(30) := 'CSF_M_TXN_BUS_PROCESSES';
31: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

Line 28: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;

24: p_message OUT NOCOPY VARCHAR2) AS
25: PRAGMA AUTONOMOUS_TRANSACTION;
26:
27: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
28: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
29: l_dsql varchar2(2048);
30: l_pub_item varchar2(30) := 'CSF_M_TXN_BUS_PROCESSES';
31: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
32: l_sqlerrno VARCHAR2(20);

Line 79: g_all_palm_res_list := CSM_UTIL_PKG.get_all_omfs_palm_res_list;

75: -- conc program run date
76: l_run_date := SYSDATE;
77:
78: --get all the OMFS Palm users
79: g_all_palm_res_list := CSM_UTIL_PKG.get_all_omfs_palm_res_list;
80:
81: /****** DELETES **********/
82: --Process deletes only if particular access_id is passed
83: --open the cursor

Line 92: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_TXN_BUS_PROCESSES',

88: EXIT WHEN l_deletes_cur%NOTFOUND;
89:
90: --mark dirty the SDQ for all users
91: FOR i IN 1 .. g_all_palm_res_list.COUNT LOOP
92: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_TXN_BUS_PROCESSES',
93: l_access_id,
94: g_all_palm_res_list(i),
95: ASG_DOWNLOAD.DEL,
96: SYSDATE);

Line 136: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_TXN_BUS_PROCESSES',

132: EXIT WHEN l_updates_cur%NOTFOUND;
133:
134: --mark dirty the SDQ for all users
135: FOR i IN 1 .. g_all_palm_res_list.COUNT LOOP
136: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_TXN_BUS_PROCESSES',
137: l_access_id, g_all_palm_res_list(i),
138: ASG_DOWNLOAD.UPD, sysdate);
139: END LOOP;
140:

Line 176: || ' AND CSM_UTIL_PKG.generate_numpk_fromstr(to_char(bpt.business_process_id) || ''.'' || to_char(bpt.transaction_type_id)) = '

172:
173:
174: /* IF p_access_id IS NOT NULL THEN
175: l_dsql := l_dsql
176: || ' AND CSM_UTIL_PKG.generate_numpk_fromstr(to_char(bpt.business_process_id) || ''.'' || to_char(bpt.transaction_type_id)) = '
177: || p_access_id;
178: END IF;
179: */
180: --open the cursor

Line 188: -- l_access_id := csm_util_pkg.generate_numpk_fromstr(to_char(l_business_process_id) || '.' || to_char(l_transaction_type_id));

184: FETCH l_inserts_cur INTO l_business_process_id, l_transaction_type_id, l_bpt_last_update_date, l_bpr_last_update_date;
185: EXIT WHEN l_inserts_cur%NOTFOUND;
186:
187: --generate access_id
188: -- l_access_id := csm_util_pkg.generate_numpk_fromstr(to_char(l_business_process_id) || '.' || to_char(l_transaction_type_id));
189: -- get access_id from seq
190: --select csm_bus_processes_acc_s.nextval into l_access_id FROM dual;
191:
192: OPEN l_access_id_csr ;

Line 198: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_TXN_BUS_PROCESSES',

194: CLOSE l_access_id_csr;
195:
196: --mark dirty the SDQ for all users
197: FOR i IN 1 .. g_all_palm_res_list.COUNT LOOP
198: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_TXN_BUS_PROCESSES',
199: l_access_id, g_all_palm_res_list(i),
200: ASG_DOWNLOAD.INS, sysdate);
201: END LOOP;
202: