APPS.CCT_RESOURCE_ASSIGNMENT dependencies on FND_USER_RESP_GROUPS

Line 22: IF Fnd_User_Resp_Groups_Api.Assignment_Exists(

18: l_def_resp_key FND_RESPONSIBILITY_VL.RESPONSIBILITY_KEY%TYPE;
19: l_def_resp_name FND_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;
20:
21: BEGIN
22: IF Fnd_User_Resp_Groups_Api.Assignment_Exists(
23: user_id => X_USER_ID,
24: responsibility_id => X_RESPONSIBILITY_ID,
25: responsibility_application_id => X_APPLICATION_ID
26: ) THEN

Line 28: UPDATE FND_USER_RESP_GROUPS SET END_DATE = SYSDATE

24: responsibility_id => X_RESPONSIBILITY_ID,
25: responsibility_application_id => X_APPLICATION_ID
26: ) THEN
27:
28: UPDATE FND_USER_RESP_GROUPS SET END_DATE = SYSDATE
29: WHERE USER_ID = X_USER_ID
30: AND RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
31: AND RESPONSIBILITY_APPLICATION_ID = X_APPLICATION_ID;
32:

Line 48: Fnd_User_Resp_Groups_Api.UPLOAD_ASSIGNMENT(

44: )
45: IS
46: BEGIN
47:
48: Fnd_User_Resp_Groups_Api.UPLOAD_ASSIGNMENT(
49: user_id => X_USER_ID,
50: responsibility_id => X_RESPONSIBILITY_ID,
51: responsibility_application_id => X_APPLICATION_ID,
52: start_date => sysdate,