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 966: l_organization_id := csm_profile_pkg.get_organization_id(l_owner_id);

962: END IF;
963:
964:
965: -- get Service Inv Validation org
966: l_organization_id := csm_profile_pkg.get_organization_id(l_owner_id);
967:
968: --get SR notes
969: csm_notes_event_pkg.notes_make_dirty_i_grp(p_sourceobjectcode=>'SR',
970: p_sourceobjectid=>p_incident_id,

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

1189: ELSE
1190: l_owner_id:=p_user_id;
1191: END IF;
1192: -- get Service Inv Validation org
1193: l_organization_id := csm_profile_pkg.get_organization_id(l_owner_id);
1194:
1195: -- delete from incidents acc
1196: csm_sr_event_pkg.incidents_acc_d(p_incident_id=>l_sr_rec.incident_id,
1197: p_user_id=>l_owner_id);

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

1394: END IF;
1395:
1396: -- get all users having access for this SR
1397: FOR r_csm_task_assg_rec IN l_csm_task_assg_csr(p_incident_id) LOOP
1398: l_organization_id := csm_profile_pkg.get_organization_id(r_csm_task_assg_rec.user_id);
1399:
1400: IF p_is_incident_location_updated = 'Y' THEN
1401: IF l_sr_rec.incident_location_type = 'HZ_LOCATION' THEN --R12 Assest
1402: --Delete old location