DBA Data[Home] [Help]

APPS.JTF_UM_ENROLLMENT_CREDENTIALS dependencies on FND_USER

Line 15: IF Fnd_User_Resp_Groups_Api.Assignment_Exists(

11: X_APPLICATION_ID NUMBER
12: )
13: IS
14: BEGIN
15: IF Fnd_User_Resp_Groups_Api.Assignment_Exists(
16: user_id => X_USER_ID,
17: responsibility_id => X_RESPONSIBILITY_ID,
18: responsibility_application_id => X_APPLICATION_ID
19: ) THEN

Line 22: Removed this direct update call as fnd_user_resp_groups is no

18: responsibility_application_id => X_APPLICATION_ID
19: ) THEN
20:
21: /*
22: Removed this direct update call as fnd_user_resp_groups is no
23: longer a table. Converted this call to use an API instead.
24:
25: UPDATE FND_USER_RESP_GROUPS SET END_DATE = SYSDATE
26: WHERE USER_ID = X_USER_ID

Line 25: UPDATE FND_USER_RESP_GROUPS SET END_DATE = SYSDATE

21: /*
22: Removed this direct update call as fnd_user_resp_groups is no
23: longer a table. Converted this call to use an API instead.
24:
25: UPDATE FND_USER_RESP_GROUPS SET END_DATE = SYSDATE
26: WHERE USER_ID = X_USER_ID
27: AND RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
28: AND RESPONSIBILITY_APPLICATION_ID = X_APPLICATION_ID;
29: */

Line 31: Fnd_User_Resp_Groups_Api.UPLOAD_ASSIGNMENT(

27: AND RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
28: AND RESPONSIBILITY_APPLICATION_ID = X_APPLICATION_ID;
29: */
30:
31: Fnd_User_Resp_Groups_Api.UPLOAD_ASSIGNMENT(
32: user_id => X_USER_ID,
33: responsibility_id => X_RESPONSIBILITY_ID,
34: responsibility_application_id => X_APPLICATION_ID,
35: start_date => sysdate,

Line 51: Fnd_User_Resp_Groups_Api.Upload_Assignment(

47: )
48: IS
49: BEGIN
50:
51: Fnd_User_Resp_Groups_Api.Upload_Assignment(
52: user_id => X_USER_ID,
53: responsibility_id => X_RESPONSIBILITY_ID,
54: responsibility_application_id => X_APPLICATION_ID,
55: start_date => sysdate,

Line 297: FROM JTF_UM_SUBSCRIPTION_REG reg, FND_USER fu

293: IS
294:
295: CURSOR FIND_ENROLL_APPWF_INFO IS
296: SELECT reg.WF_ITEM_TYPE, to_char (reg.SUBSCRIPTION_REG_ID)
297: FROM JTF_UM_SUBSCRIPTION_REG reg, FND_USER fu
298: WHERE fu.USER_NAME = P_USERNAME
299: AND fu.USER_ID = reg.USER_ID
300: AND STATUS_CODE = 'PENDING'
301: AND (reg.EFFECTIVE_END_DATE is null