APPS.CSM_SR_EVENT_PKG dependencies on CSM_PROFILE_PKG

Line 57: AND (inc.creation_date < (SYSDATE - csm_profile_pkg.get_task_history_days(acc.user_id)))

53: AND decode(CSM_UTIL_PKG.get_group_owner(inc.owner_group_id),
54: -1,
55: CSM_UTIL_PKG.get_owner(inc.created_by),
56: CSM_UTIL_PKG.get_group_owner(inc.owner_group_id)) = acc.user_id
57: AND (inc.creation_date < (SYSDATE - csm_profile_pkg.get_task_history_days(acc.user_id)))
58: AND inc.INCIDENT_STATUS_ID = ists.INCIDENT_STATUS_ID
59: AND ists.CLOSE_FLAG = 'Y';
60:
61:

Line 985: l_organization_id := csm_profile_pkg.get_organization_id(l_owner_id);

981: END IF;
982:
983:
984: -- get Service Inv Validation org
985: l_organization_id := csm_profile_pkg.get_organization_id(l_owner_id);
986:
987: --get SR notes
988: csm_notes_event_pkg.notes_make_dirty_i_grp(p_sourceobjectcode=>'SR',
989: p_sourceobjectid=>p_incident_id,

Line 1215: l_organization_id := csm_profile_pkg.get_organization_id(l_owner_id);

1211: ELSE
1212: l_owner_id:=p_user_id;
1213: END IF;
1214: -- get Service Inv Validation org
1215: l_organization_id := csm_profile_pkg.get_organization_id(l_owner_id);
1216:
1217: -- delete from incidents acc
1218: csm_sr_event_pkg.incidents_acc_d(p_incident_id=>l_sr_rec.incident_id,
1219: p_user_id=>l_owner_id);

Line 1420: l_organization_id := csm_profile_pkg.get_organization_id(r_csm_task_assg_rec.user_id);

1416: END IF;
1417:
1418: -- get all users having access for this SR
1419: FOR r_csm_task_assg_rec IN l_csm_task_assg_csr(p_incident_id) LOOP
1420: l_organization_id := csm_profile_pkg.get_organization_id(r_csm_task_assg_rec.user_id);
1421:
1422: IF p_is_incident_location_updated = 'Y' THEN
1423: IF l_sr_rec.incident_location_type = 'HZ_LOCATION' THEN --R12 Assest
1424: --Delete old location