APPS.JTF_UM_USER_ADMIN_PVT dependencies on JTF_UM_SUBSCRIPTION_REG

Line 166: from jtf_um_subscription_reg

162: and nvl (effective_end_date, sysdate + 1) > sysdate;
163:
164: cursor getEnrollWFInfo is
165: select wf_item_type, subscription_reg_id
166: from jtf_um_subscription_reg
167: where user_id = l_userid
168: and status_code = 'PENDING'
169: and nvl (effective_end_date, sysdate + 1) > sysdate;
170:

Line 248: UPDATE JTF_UM_SUBSCRIPTION_REG

244: AND nvl (effective_end_date, sysdate + 1) > sysdate
245: AND status_code = 'PENDING';
246:
247: -- 3. Find all the PENDING enrollments and set USER_REJECTED.
248: UPDATE JTF_UM_SUBSCRIPTION_REG
249: SET status_code = 'USER_REJECTED',
250: last_updated_by = fnd_global.user_id,
251: last_update_date = sysdate,
252: last_approver_comment = 'USER DELETED',

Line 334: UPDATE JTF_UM_SUBSCRIPTION_REG

330: jtf_um_wf_approval.abort_process (enrollRegRow.wf_item_type, to_char(enrollRegRow.subscription_reg_id));
331: END LOOP;
332:
333: -- 2. Find all the PENDING enrollments and set USER_REJECTED.
334: UPDATE JTF_UM_SUBSCRIPTION_REG
335: SET status_code = 'USER_REJECTED',
336: last_updated_by = fnd_global.user_id,
337: last_update_date = sysdate,
338: last_approver_comment = 'USER DELETED',

Line 472: UPDATE JTF_UM_SUBSCRIPTION_REG

468: -- for bug 4378387 , end_date all subscriptions for the current
469: -- user type which might have been granted to the user before
470: -- this is done to ensure that all roles/resp are granted once again
471: -- details in bug.
472: UPDATE JTF_UM_SUBSCRIPTION_REG
473: SET effective_END_DATE =SYSDATE, last_update_login=l_user_id,last_update_date=sysdate
474: WHERE USER_ID = p_user_id and status_code='APPROVED'
475: and effective_start_date < sysdate and nvl(effective_end_date,sysdate +1) > sysdate
476: AND SUBSCRIPTION_ID IN