DBA Data[Home] [Help]

APPS.CSM_TASK_EVENT_PKG dependencies on CSM_SR_EVENT_PKG

Line 166: CSM_UTIL_PKG.LOG(TO_CHAR(l_task_tbl.COUNT) || ' task records sent for purge', 'CSM_SR_EVENT_PKG.PURGE_INCIDENTS_CONC',FND_LOG.LEVEL_EVENT);

162: FETCH l_purge_tasks_csr BULK COLLECT INTO l_task_tbl, l_userid_tbl, l_counter_tbl,l_task_src_type_tbl LIMIT 50;
163: EXIT WHEN l_task_tbl.COUNT = 0;
164:
165: IF l_task_tbl.COUNT > 0 THEN
166: CSM_UTIL_PKG.LOG(TO_CHAR(l_task_tbl.COUNT) || ' task records sent for purge', 'CSM_SR_EVENT_PKG.PURGE_INCIDENTS_CONC',FND_LOG.LEVEL_EVENT);
167: FOR i IN l_task_tbl.FIRST..l_task_tbl.LAST LOOP
168: l_task_id := l_task_tbl(i);
169: l_user_id := l_userid_tbl(i);
170: l_tsk_counter := l_counter_tbl(i);

Line 183: IF l_task_src_type_tbl(i) ='SR' AND CSM_SR_EVENT_PKG.IS_SR_OPEN(l_task_id) = FALSE THEN

179:
180: -- do task delete only for those not to be handled by task_assignment_purge
181: IF l_tsk_counter > l_tas_counter THEN
182:
183: IF l_task_src_type_tbl(i) ='SR' AND CSM_SR_EVENT_PKG.IS_SR_OPEN(l_task_id) = FALSE THEN
184: --Delete the taskonly if the SR is closed
185: csm_task_event_pkg.task_del_init(p_task_id=>l_task_id);
186:
187: ELSIF l_task_src_type_tbl(i) ='TASK' THEN