APPS.JTF_UM_USER_ADMIN_PVT dependencies on JTF_UM_USERTYPE_REG

Line 35: from jtf_um_usertype_reg

31: l_status_code VARCHAR2 (30) := null;
32:
33: cursor getUserStatusCodeCursor is
34: select status_code
35: from jtf_um_usertype_reg
36: where user_id = p_userid
37: and nvl (effective_end_date, sysdate + 1) > sysdate;
38:
39: BEGIN

Line 159: from jtf_um_usertype_reg

155: l_version_num NUMBER;
156:
157: cursor getUTWFInfo is
158: select wf_item_type, to_char (usertype_reg_id)
159: from jtf_um_usertype_reg
160: where user_id = l_userid
161: and status_code = 'PENDING'
162: and nvl (effective_end_date, sysdate + 1) > sysdate;
163:

Line 237: UPDATE JTF_UM_USERTYPE_REG

233: END IF;
234: CLOSE getUTWFInfo;
235:
236: -- 2. Set the usertype_reg table status to REJECTED
237: UPDATE JTF_UM_USERTYPE_REG
238: SET status_code = 'REJECTED',
239: last_updated_by = fnd_global.user_id,
240: last_update_date = sysdate,
241: last_approver_comment = 'USER DELETED',

Line 267: UPDATE JTF_UM_USERTYPE_REG

263:
264: ELSIF (l_status_code = 'UPGRADE_APPROVAL_PENDING') THEN
265:
266: -- 1. Set the usertype_reg table status to REJECTED
267: UPDATE JTF_UM_USERTYPE_REG
268: SET status_code = 'REJECTED',
269: last_updated_by = fnd_global.user_id,
270: last_update_date = sysdate,
271: last_approver_comment = 'USER DELETED',