APPS.CSM_SERVICE_REQUESTS_PKG dependencies on ASG_USER

Line 26: --Since from r12 the app_id and responsiblity id is available in asg_user table the cursor is mordied to take the values

22: FROM CSF_M_SR_CONTACTS_INQ
23: WHERE INCIDENT_ID = b_incident_id
24: AND TRANID$$ = b_tranid
25: AND clid$$cs = b_user_name;
26: --Since from r12 the app_id and responsiblity id is available in asg_user table the cursor is mordied to take the values
27: --from asg_user table
28: CURSOR c_csm_appl(l_userid NUMBER)
29: IS
30: SELECT APP_ID

Line 27: --from asg_user table

23: WHERE INCIDENT_ID = b_incident_id
24: AND TRANID$$ = b_tranid
25: AND clid$$cs = b_user_name;
26: --Since from r12 the app_id and responsiblity id is available in asg_user table the cursor is mordied to take the values
27: --from asg_user table
28: CURSOR c_csm_appl(l_userid NUMBER)
29: IS
30: SELECT APP_ID
31: FROM asg_user

Line 31: FROM asg_user

27: --from asg_user table
28: CURSOR c_csm_appl(l_userid NUMBER)
29: IS
30: SELECT APP_ID
31: FROM asg_user
32: WHERE user_id = l_userid;
33:
34: CURSOR c_csm_resp(l_userid NUMBER)
35: is

Line 37: FROM asg_user

33:
34: CURSOR c_csm_resp(l_userid NUMBER)
35: is
36: SELECT RESPONSIBILITY_ID
37: FROM asg_user
38: WHERE user_id = l_userid;
39:
40:
41: CURSOR c_validate_item_org(p_inventory_item_id IN NUMBER, p_organization_id IN NUMBER)

Line 186: --get responsiblity from asg_user

182: l_user_id := JTM_HOOK_UTIL_PKG.Get_User_Id( p_record.CLID$$CS );
183: l_created_by := p_record.CREATED_BY;
184: l_resp_id := TO_NUMBER(fnd_profile.value('CSM_SR_CREATE_RESP'));
185:
186: --get responsiblity from asg_user
187: OPEN c_csm_resp(l_user_id);
188: FETCH c_csm_resp INTO l_responsibility_id;
189: CLOSE c_csm_resp;
190: