APPS.JTF_UM_ENROLLMENT_CREDENTIALS dependencies on JTF_UM_SUBSCRIPTION_REG

Line 242: UPDATE JTF_UM_SUBSCRIPTION_REG SET STATUS_CODE='APPROVED'

238: CLOSE SUBSCRIPTION_ROLES;
239:
240: -- Update the status
241:
242: UPDATE JTF_UM_SUBSCRIPTION_REG SET STATUS_CODE='APPROVED'
243: WHERE SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
244: AND USER_ID = X_USER_ID;
245:
246: -- Grant the delegation role, if the flag is set

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

Line 354: l_wf_item_type jtf_um_subscription_reg.wf_item_type%TYPE;

350: p_approval_id in number,
351: x_enrollment_reg_id out NOCOPY number) is
352:
353: METHOD_NAME varchar2 (22) := 'ASSIGN_USER_ENROLLMENT';
354: l_wf_item_type jtf_um_subscription_reg.wf_item_type%TYPE;
355: l_usertype_status jtf_um_usertype_reg.status_code%TYPE;
356:
357: cursor get_wf_item_type is
358: select wf_item_type

Line 408: -- insert into the jtf_um_subscription_reg table

404: end if;
405: close get_wf_item_type;
406: end if;
407:
408: -- insert into the jtf_um_subscription_reg table
409: JTF_UM_SUBSCRIPTIONS_PKG.INSERT_SUBREG_ROW (
410: X_SUBSCRIPTION_ID => p_enrollment_id,
411: X_LAST_APPROVER_COMMENT => null,
412: X_APPROVER_USER_ID => null,