DBA Data[Home] [Help]

APPS.CSM_WF_PKG dependencies on CSM_SR_EVENT_PKG

Line 271: IF CSM_SR_EVENT_PKG.is_sr_downloaded_to_owner(l_task_id) THEN

267: END IF;
268:
269: l_task_id := jtf_tasks_pub.p_task_user_hooks.task_id;
270:
271: IF CSM_SR_EVENT_PKG.is_sr_downloaded_to_owner(l_task_id) THEN
272: OPEN c_sr_grp_owner(l_task_id);
273: FETCH c_sr_grp_owner INTO l_user_id;
274: CLOSE c_sr_grp_owner;
275:

Line 405: IF CSM_SR_EVENT_PKG.is_sr_downloaded_to_owner(l_task_id) THEN

401: open c_task(l_task_assignment_id);
402: fetch c_task into l_task_id,l_assignee_id;
403: close c_task;
404:
405: IF CSM_SR_EVENT_PKG.is_sr_downloaded_to_owner(l_task_id) THEN
406: OPEN c_sr_grp_owner(l_task_id);
407: FETCH c_sr_grp_owner INTO l_user_id;
408: CLOSE c_sr_grp_owner;
409:

Line 648: IF CSM_SR_EVENT_PKG.is_sr_downloaded_to_owner(l_task_id) THEN

644: open c_task(l_task_assignment_id);
645: fetch c_task into l_task_id;
646: close c_task;
647:
648: IF CSM_SR_EVENT_PKG.is_sr_downloaded_to_owner(l_task_id) THEN
649: OPEN c_sr_grp_owner(l_task_id);
650: FETCH c_sr_grp_owner INTO l_owner_id;
651: CLOSE c_sr_grp_owner;
652:

Line 898: g_task_downloaded_to_owner:=CSM_SR_EVENT_PKG.is_sr_downloaded_to_owner(l_jtf_task_id);

894: l_jtf_task_id := jtf_tasks_pub.p_task_user_hooks.task_id;
895:
896:
897: --used for TASK_TYPE CHANGE
898: g_task_downloaded_to_owner:=CSM_SR_EVENT_PKG.is_sr_downloaded_to_owner(l_jtf_task_id);
899:
900: -- initialize the rec
901: g_task_pre_upd_rec := g_null_task_pre_upd_typ;
902:

Line 1013: l_task_downloadable_to_owner := CSM_SR_EVENT_PKG.is_sr_downloaded_to_owner(l_jtf_task_id);

1009: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.Task_Post_Upd for task_id:' || l_jtf_task_id ,
1010: 'CSM_WF_PKG.Task_Post_Upd',FND_LOG.LEVEL_PROCEDURE);
1011:
1012: /*12.1: TASK_TYPE CHANGE should be captured*/
1013: l_task_downloadable_to_owner := CSM_SR_EVENT_PKG.is_sr_downloaded_to_owner(l_jtf_task_id);
1014:
1015: IF (NOT g_task_downloaded_to_owner AND l_task_downloadable_to_owner) THEN
1016:
1017: OPEN c_sr_grp_owner(l_jtf_task_id);

Line 1256: csm_sr_event_pkg.sr_ins_init(l_incident_id);

1252: END IF;
1253: END IF;
1254: CLOSE l_sr_csr;
1255:
1256: csm_sr_event_pkg.sr_ins_init(l_incident_id);
1257:
1258: EXCEPTION
1259: WHEN OTHERS THEN
1260: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1552: CSM_SR_EVENT_PKG.sr_del_init(l_incident_id,l_old_owner);

1548: l_current_owner :=csm_util_pkg.get_owner(l_sr_post_upd_rec.created_by);
1549: END IF;
1550:
1551: IF l_old_owner <> l_current_owner THEN
1552: CSM_SR_EVENT_PKG.sr_del_init(l_incident_id,l_old_owner);
1553: CSM_SR_EVENT_PKG.sr_ins_init(l_incident_id);
1554: END IF;
1555:
1556: -- only start the SR upd WF if it is linked to a mobile user

Line 1553: CSM_SR_EVENT_PKG.sr_ins_init(l_incident_id);

1549: END IF;
1550:
1551: IF l_old_owner <> l_current_owner THEN
1552: CSM_SR_EVENT_PKG.sr_del_init(l_incident_id,l_old_owner);
1553: CSM_SR_EVENT_PKG.sr_ins_init(l_incident_id);
1554: END IF;
1555:
1556: -- only start the SR upd WF if it is linked to a mobile user
1557: OPEN l_is_mobile_sr_csr(l_incident_id);

Line 1613: csm_sr_event_pkg.sr_upd_init(p_incident_id=> l_incident_id,

1609: END IF;
1610:
1611: -- call the sr upd
1612: -- pass old_install_site_id though it is not used in the called procedure
1613: csm_sr_event_pkg.sr_upd_init(p_incident_id=> l_incident_id,
1614: p_is_incident_location_updated=>l_is_incident_location_updated,
1615: p_old_incident_location_id=> g_sr_pre_upd_rec.incident_location_id,
1616: p_is_install_site_updated=>l_is_install_site_updated,
1617: p_old_install_site_id=>g_sr_pre_upd_rec.install_site_id,