APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on CSM_PROFILE_PKG

Line 45: < (SYSDATE - csm_profile_pkg.get_task_history_days(acc.user_id)))

41: jtf_task_statuses_b jts_jta
42: WHERE acc.task_assignment_id = jta.task_assignment_id
43: AND jt.task_id = jta.task_id
44: AND (jt.scheduled_start_date
45: < (SYSDATE - csm_profile_pkg.get_task_history_days(acc.user_id)))
46: AND jts.task_status_id = jt.task_status_id
47: AND jts_jta.task_status_id = jta.assignment_status_id
48: AND (jts.cancelled_flag = 'Y' OR jts.closed_flag = 'Y'
49: OR jts.completed_flag = 'Y' OR jts.rejected_flag = 'Y'

Line 586: l_organization_id := csm_profile_pkg.get_organization_id(l_taskassgdetails_rec.user_id);

582: RETURN;
583: END IF;
584:
585: -- get Service Inv Validation org
586: l_organization_id := csm_profile_pkg.get_organization_id(l_taskassgdetails_rec.user_id);
587:
588: --get task notes moved to task_assignments_acc processor
589:
590:

Line 1018: l_organization_id := csm_profile_pkg.get_organization_id(l_task_assg_purge_rec.user_id);

1014: RETURN;
1015: END IF;
1016: CLOSE l_task_assg_purge_csr;
1017: -- get Service Inv Validation org
1018: l_organization_id := csm_profile_pkg.get_organization_id(l_task_assg_purge_rec.user_id);
1019:
1020: -- lobs mdirty D
1021: csm_task_assignment_event_pkg.lobs_mdirty_D(p_task_assignment_id=>p_task_assignment_id,
1022: p_resource_id=>l_task_assg_purge_rec.resource_id);