eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_UM_WF_APPROVAL dependencies on JTF_UM_USERTYPE_REG

Line 335: from JTF_UM_USERTYPE_REG

331: where SUBSCRIPTION_ID = requestID;
332:
333: cursor getUsertypeIdCursor is
334: select USERTYPE_ID
335: from JTF_UM_USERTYPE_REG
336: where USER_ID = requesterUserID
337: and STATUS_CODE <>'REJECTED'
338: and EFFECTIVE_START_DATE <= sysdate
339: and nvl (EFFECTIVE_END_DATE, sysdate + 1) > sysdate;

Line 492: from JTF_UM_USERTYPE_REG

488: requestRegID in number) is
489:
490: cursor get_ut_itemtype is
491: select WF_ITEM_TYPE
492: from JTF_UM_USERTYPE_REG
493: where USERTYPE_REG_ID = requestRegID;
494:
495: cursor get_enroll_itemtype is
496: select WF_ITEM_TYPE

Line 515: raise_application_error ('20000', 'Workflow itemtype is missing in the JTF_UM_USERTYPE_REG table with USERTYPE_REG_ID: ' || requestRegID);

511: open get_ut_itemtype;
512: fetch get_ut_itemtype into itemtype;
513: if (get_ut_itemtype%notfound) then
514: close get_ut_itemtype;
515: raise_application_error ('20000', 'Workflow itemtype is missing in the JTF_UM_USERTYPE_REG table with USERTYPE_REG_ID: ' || requestRegID);
516: end if;
517: close get_ut_itemtype;
518:
519: elsif (requestType = 'ENROLLMENT') then

Line 1160: update JTF_UM_USERTYPE_REG

1156: itemtype => itemtype,
1157: itemkey => itemkey,
1158: aname => 'REQUEST_TYPE');
1159: if (requestType = 'USERTYPE') then
1160: update JTF_UM_USERTYPE_REG
1161: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1162: LAST_UPDATE_DATE = sysdate,
1163: APPROVER_USER_ID = approverUserID
1164: where USERTYPE_REG_ID = itemkey;

Line 1566: update JTF_UM_USERTYPE_REG

1562: aname => 'REQUEST_TYPE');
1563:
1564: -- We need to update the approver id in the reg table
1565: if (requestType = 'USERTYPE') then
1566: update JTF_UM_USERTYPE_REG
1567: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1568: LAST_UPDATE_DATE = sysdate,
1569: APPROVER_USER_ID = ownerUserID
1570: where USERTYPE_REG_ID = to_number(itemkey);

Line 1748: update JTF_UM_USERTYPE_REG

1744: itemkey => itemkey,
1745: aname => 'REQUEST_TYPE');
1746: --
1747: if (requestType = 'USERTYPE') then
1748: update JTF_UM_USERTYPE_REG
1749: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1750: LAST_UPDATE_DATE = sysdate,
1751: APPROVER_USER_ID = userId
1752: where USERTYPE_REG_ID = to_number(itemkey);

Line 1941: -- the JTF_UM_USERTYPE_REG table.

1937: X_USERTYPE_ID => requestID);
1938:
1939:
1940: -- Save the approver comment to LAST_APPROVER_COMMENT in
1941: -- the JTF_UM_USERTYPE_REG table.
1942: update JTF_UM_USERTYPE_REG
1943: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1944: LAST_UPDATE_DATE = sysdate,
1945: LAST_APPROVER_COMMENT = approverComment

Line 1942: update JTF_UM_USERTYPE_REG

1938:
1939:
1940: -- Save the approver comment to LAST_APPROVER_COMMENT in
1941: -- the JTF_UM_USERTYPE_REG table.
1942: update JTF_UM_USERTYPE_REG
1943: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1944: LAST_UPDATE_DATE = sysdate,
1945: LAST_APPROVER_COMMENT = approverComment
1946: where USERTYPE_REG_ID = itemkey;

Line 1974: -- the JTF_UM_USERTYPE_REG table.

1970: else
1971: -- requestType is 'ENROLLMENT'
1972:
1973: -- Save the approver comment to LAST_APPROVER_COMMENT in
1974: -- the JTF_UM_USERTYPE_REG table.
1975: update JTF_UM_SUBSCRIPTION_REG
1976: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1977: LAST_UPDATE_DATE = sysdate,
1978: LAST_APPROVER_COMMENT = approverComment

Line 2102: From JTF_UM_USERTYPES_B ut , JTF_UM_USERTYPE_REG reg

2098:
2099: -- cursor for populating event parameters in case of user type rejection
2100: cursor getRejectEventData is
2101: Select ut.APPLICATION_ID,ut.USERTYPE_KEY,reg.USERTYPE_REG_ID
2102: From JTF_UM_USERTYPES_B ut , JTF_UM_USERTYPE_REG reg
2103: where ut.USERTYPE_ID=reg.USERTYPE_ID and reg.USERTYPE_REG_ID=to_number(itemkey);
2104: -- and reg.EFFECTIVE_START_DATE <= sysdate
2105: -- and reg.EFFECTIVE_END_DATE= sysdate;
2106:

Line 2144: update JTF_UM_USERTYPE_REG

2140: X_RESPONSIBILITY_KEY => 'JTF_PENDING_APPROVAL',
2141: X_APPLICATION_ID => 690);
2142:
2143: -- End date and rejected Usertype Reg
2144: update JTF_UM_USERTYPE_REG
2145: set STATUS_CODE = 'REJECTED',
2146: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2147: LAST_UPDATE_DATE = sysdate,
2148: LAST_APPROVER_COMMENT = approverComment,

Line 2684: from jtf_um_usertype_reg

2680: UNKNOWN_REQUEST_TYPE exception;
2681:
2682: cursor getLUDFromUserReg is
2683: select to_char (last_update_date, 'mmddyyyyhh24miss')
2684: from jtf_um_usertype_reg
2685: where usertype_reg_id = to_number (itemkey);
2686:
2687: cursor getLUDFromEnrollReg is
2688: select to_char (last_update_date, 'mmddyyyyhh24miss')

Line 2697: from jtf_um_usertype_reg reg , fnd_user fnd

2693: cursor getOrgDetail is
2694: SELECT party.status FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL
2695: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
2696: AND PREL.PARTY_ID = (select fnd.customer_id
2697: from jtf_um_usertype_reg reg , fnd_user fnd
2698: where usertype_reg_id = to_number(itemkey)
2699: and reg.user_id=fnd.USER_ID
2700: )
2701: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 3072: from jtf_um_usertype_reg

3068: p_old_approval_id in number) is
3069:
3070: cursor usertype_reg is
3071: select usertype_reg_id,user_id
3072: from jtf_um_usertype_reg
3073: where usertype_id = p_usertype_id
3074: and status_code = 'PENDING'
3075: and nvl (effective_end_date, sysdate + 1) > sysdate;
3076:

Line 3082: from jtf_um_usertype_reg utreg, jtf_um_usertypes_b ut

3078: p_user_id number;
3079:
3080: cursor find_old_item_type is
3081: select utreg.wf_item_type
3082: from jtf_um_usertype_reg utreg, jtf_um_usertypes_b ut
3083: where utreg.usertype_id = p_usertype_id
3084: and utreg.usertype_id = ut.usertype_id
3085: and utreg.status_code = 'PENDING'
3086: and nvl (utreg.effective_end_date, sysdate + 1) > sysdate;

Line 3139: -- end date the old record in JTF_UM_USERTYPE_REG table

3135:
3136: else
3137:
3138:
3139: -- end date the old record in JTF_UM_USERTYPE_REG table
3140: update JTF_UM_USERTYPE_REG set effective_end_date = sysdate,
3141: last_update_date = sysdate, last_updated_by = FND_GLOBAL.USER_ID
3142: where usertype_reg_id = p_usertype_reg_id;
3143:

Line 3140: update JTF_UM_USERTYPE_REG set effective_end_date = sysdate,

3136: else
3137:
3138:
3139: -- end date the old record in JTF_UM_USERTYPE_REG table
3140: update JTF_UM_USERTYPE_REG set effective_end_date = sysdate,
3141: last_update_date = sysdate, last_updated_by = FND_GLOBAL.USER_ID
3142: where usertype_reg_id = p_usertype_reg_id;
3143:
3144:

Line 3145: -- create record in JTF_UM_USERTYPE_REG table

3141: last_update_date = sysdate, last_updated_by = FND_GLOBAL.USER_ID
3142: where usertype_reg_id = p_usertype_reg_id;
3143:
3144:
3145: -- create record in JTF_UM_USERTYPE_REG table
3146: JTF_UM_USERTYPES_PKG.INSERT_UMREG_ROW (
3147: X_USERTYPE_ID => p_usertype_id,
3148: X_LAST_APPROVER_COMMENT => null,
3149: X_APPROVER_USER_ID => null,

Line 3189: from jtf_um_usertype_reg utreg, fnd_user fu, hz_relationships hzr

3185: p_org_party_id in number) is
3186:
3187: cursor usertype_reg is
3188: select utreg.usertype_reg_id, utreg.user_id
3189: from jtf_um_usertype_reg utreg, fnd_user fu, hz_relationships hzr
3190: where utreg.usertype_id = p_usertype_id
3191: and utreg.status_code = 'PENDING'
3192: and nvl (utreg.effective_end_date, sysdate + 1) > sysdate
3193: and utreg.user_id = fu.user_id

Line 3207: from jtf_um_usertype_reg utreg, jtf_um_usertypes_b ut

3203: p_user_id number;
3204:
3205: cursor find_old_item_type is
3206: select utreg.wf_item_type
3207: from jtf_um_usertype_reg utreg, jtf_um_usertypes_b ut
3208: where utreg.usertype_id = p_usertype_id
3209: and utreg.usertype_id = ut.usertype_id
3210: and utreg.status_code = 'PENDING'
3211: and nvl (utreg.effective_end_date, sysdate + 1) > sysdate;

Line 3254: -- end date the old record in JTF_UM_USERTYPE_REG table

3250: do_approve_req(itemtype => p_wf_old_item_type,
3251: itemkey => p_usertype_reg_id);
3252: else
3253:
3254: -- end date the old record in JTF_UM_USERTYPE_REG table
3255: update JTF_UM_USERTYPE_REG set effective_end_date = sysdate,
3256: last_update_date = sysdate, last_updated_by = FND_GLOBAL.USER_ID
3257: where usertype_reg_id = p_usertype_reg_id
3258: and user_id = p_user_id and status_code='PENDING';

Line 3255: update JTF_UM_USERTYPE_REG set effective_end_date = sysdate,

3251: itemkey => p_usertype_reg_id);
3252: else
3253:
3254: -- end date the old record in JTF_UM_USERTYPE_REG table
3255: update JTF_UM_USERTYPE_REG set effective_end_date = sysdate,
3256: last_update_date = sysdate, last_updated_by = FND_GLOBAL.USER_ID
3257: where usertype_reg_id = p_usertype_reg_id
3258: and user_id = p_user_id and status_code='PENDING';
3259:

Line 3260: -- create record in JTF_UM_USERTYPE_REG table

3256: last_update_date = sysdate, last_updated_by = FND_GLOBAL.USER_ID
3257: where usertype_reg_id = p_usertype_reg_id
3258: and user_id = p_user_id and status_code='PENDING';
3259:
3260: -- create record in JTF_UM_USERTYPE_REG table
3261: JTF_UM_USERTYPES_PKG.INSERT_UMREG_ROW (
3262: X_USERTYPE_ID => p_usertype_id,
3263: X_LAST_APPROVER_COMMENT => null,
3264: X_APPROVER_USER_ID => null,

Line 3340: from jtf_um_usertype_reg

3336: or effective_end_date > sysdate);
3337:
3338: cursor check_usertype_status is
3339: select status_code
3340: from jtf_um_usertype_reg
3341: where user_id = p_user_id
3342: and (effective_end_date is null
3343: or effective_end_date > sysdate);
3344:

Line 3392: -- JTF_UM_USERTYPE_REG table.

3388: else
3389: close subscription_reg_w_org;
3390: end if;
3391: -- all Users who are using the UM should be in the
3392: -- JTF_UM_USERTYPE_REG table.
3393: raise_application_error (20000, 'User info is missing');
3394: end if;
3395: close check_usertype_status;
3396: