APPS.CSM_UTIL_PKG dependencies on CSM_PROFILE_PKG

Line 182: IF csm_profile_pkg.Get_Route_Data_To_Owner ='Y' THEN

178: AND pubresp.pub_name ='SERVICEP'
179: AND usr.USER_ID = usr.OWNER_ID;
180: BEGIN
181: i := 0;
182: IF csm_profile_pkg.Get_Route_Data_To_Owner ='Y' THEN
183: FOR r_omfs_palm_users_rec IN l_route_omfs_palm_users_csr LOOP
184: i := i + 1;
185: l_all_omfs_palm_users_list(i) := r_omfs_palm_users_rec.user_id;
186: END LOOP;

Line 227: IF csm_profile_pkg.Get_Route_Data_To_Owner ='Y' THEN

223: AND usr.USER_ID = usr.OWNER_ID;
224:
225: BEGIN
226: i := 0;
227: IF csm_profile_pkg.Get_Route_Data_To_Owner ='Y' THEN
228: FOR r_omfs_palm_resource_rec IN l_route_omfs_palm_res_csr LOOP
229: i := i + 1;
230: l_all_omfs_palm_resource_list(i) := r_omfs_palm_resource_rec.resource_id;
231: END LOOP;

Line 455: l_responsibility_id := CSM_PROFILE_PKG.GetDefaultStatusResponsibility(p_userid);

451: END IF;
452: END LOOP;
453: IF l_diff = TRUE OR l_responsibility_id IS NULL THEN
454: /* No responsibility found or rules per responisibilities are different, get profileval */
455: l_responsibility_id := CSM_PROFILE_PKG.GetDefaultStatusResponsibility(p_userid);
456: END IF;
457: return l_responsibility_id;
458: END GET_RESPONSIBILITY_ID;
459:

Line 851: IF csm_profile_pkg.Get_Route_Data_To_Owner ='Y' THEN

847: AND pubresp.pub_name ='SERVICEP'
848: AND usr.USER_ID = usr.OWNER_ID;
849: BEGIN
850: i := 0;
851: IF csm_profile_pkg.Get_Route_Data_To_Owner ='Y' THEN
852: FOR r_tl_omfs_palm_users_rec in l_route_tl_omfs_palm_users_csr LOOP
853: i := i + 1;
854: l_tl_omfs_palm_users_list(i) := r_tl_omfs_palm_users_rec.user_id;
855: END LOOP;

Line 895: IF csm_profile_pkg.Get_Route_Data_To_Owner ='Y' THEN

891: AND pubresp.pub_name ='SERVICEP'
892: AND usr.USER_ID = usr.OWNER_ID;
893: BEGIN
894: i := 0;
895: IF csm_profile_pkg.Get_Route_Data_To_Owner ='Y' THEN
896: FOR r_tl_omfs_palm_resource_rec in l_route_tl_omfs_palm_res_csr LOOP
897: i := i + 1;
898: l_tl_omfs_palm_resource_list(i) := r_tl_omfs_palm_resource_rec.resource_id;
899: END LOOP;