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 1168: update JTF_UM_USERTYPE_REG

1164: itemtype => itemtype,
1165: itemkey => itemkey,
1166: aname => 'REQUEST_TYPE');
1167: if (requestType = 'USERTYPE') then
1168: update JTF_UM_USERTYPE_REG
1169: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1170: LAST_UPDATE_DATE = sysdate,
1171: APPROVER_USER_ID = approverUserID
1172: where USERTYPE_REG_ID = itemkey;

Line 1578: update JTF_UM_USERTYPE_REG

1574: aname => 'REQUEST_TYPE');
1575:
1576: -- We need to update the approver id in the reg table
1577: if (requestType = 'USERTYPE') then
1578: update JTF_UM_USERTYPE_REG
1579: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1580: LAST_UPDATE_DATE = sysdate,
1581: APPROVER_USER_ID = ownerUserID
1582: where USERTYPE_REG_ID = to_number(itemkey);

Line 1760: update JTF_UM_USERTYPE_REG

1756: itemkey => itemkey,
1757: aname => 'REQUEST_TYPE');
1758: --
1759: if (requestType = 'USERTYPE') then
1760: update JTF_UM_USERTYPE_REG
1761: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1762: LAST_UPDATE_DATE = sysdate,
1763: APPROVER_USER_ID = userId
1764: where USERTYPE_REG_ID = to_number(itemkey);

Line 1967: -- the JTF_UM_USERTYPE_REG table.

1963: X_USERTYPE_ID => requestID);
1964:
1965:
1966: -- Save the approver comment to LAST_APPROVER_COMMENT in
1967: -- the JTF_UM_USERTYPE_REG table.
1968: update JTF_UM_USERTYPE_REG
1969: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1970: LAST_UPDATE_DATE = sysdate,
1971: LAST_APPROVER_COMMENT = approverComment

Line 1968: update JTF_UM_USERTYPE_REG

1964:
1965:
1966: -- Save the approver comment to LAST_APPROVER_COMMENT in
1967: -- the JTF_UM_USERTYPE_REG table.
1968: update JTF_UM_USERTYPE_REG
1969: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1970: LAST_UPDATE_DATE = sysdate,
1971: LAST_APPROVER_COMMENT = approverComment
1972: where USERTYPE_REG_ID = itemkey;

Line 2000: -- the JTF_UM_USERTYPE_REG table.

1996: else
1997: -- requestType is 'ENROLLMENT'
1998:
1999: -- Save the approver comment to LAST_APPROVER_COMMENT in
2000: -- the JTF_UM_USERTYPE_REG table.
2001: update JTF_UM_SUBSCRIPTION_REG
2002: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2003: LAST_UPDATE_DATE = sysdate,
2004: LAST_APPROVER_COMMENT = approverComment

Line 2128: From JTF_UM_USERTYPES_B ut , JTF_UM_USERTYPE_REG reg

2124:
2125: -- cursor for populating event parameters in case of user type rejection
2126: cursor getRejectEventData is
2127: Select ut.APPLICATION_ID,ut.USERTYPE_KEY,reg.USERTYPE_REG_ID
2128: From JTF_UM_USERTYPES_B ut , JTF_UM_USERTYPE_REG reg
2129: where ut.USERTYPE_ID=reg.USERTYPE_ID and reg.USERTYPE_REG_ID=to_number(itemkey);
2130: -- and reg.EFFECTIVE_START_DATE <= sysdate
2131: -- and reg.EFFECTIVE_END_DATE= sysdate;
2132:

Line 2170: update JTF_UM_USERTYPE_REG

2166: X_RESPONSIBILITY_KEY => 'JTF_PENDING_APPROVAL',
2167: X_APPLICATION_ID => 690);
2168:
2169: -- End date and rejected Usertype Reg
2170: update JTF_UM_USERTYPE_REG
2171: set STATUS_CODE = 'REJECTED',
2172: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2173: LAST_UPDATE_DATE = sysdate,
2174: LAST_APPROVER_COMMENT = approverComment,

Line 2710: from jtf_um_usertype_reg

2706: UNKNOWN_REQUEST_TYPE exception;
2707:
2708: cursor getLUDFromUserReg is
2709: select to_char (last_update_date, 'mmddyyyyhh24miss')
2710: from jtf_um_usertype_reg
2711: where usertype_reg_id = to_number (itemkey);
2712:
2713: cursor getLUDFromEnrollReg is
2714: select to_char (last_update_date, 'mmddyyyyhh24miss')

Line 2723: from jtf_um_usertype_reg reg , fnd_user fnd

2719: cursor getOrgDetail is
2720: SELECT party.status FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL
2721: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
2722: AND PREL.PARTY_ID = (select fnd.customer_id
2723: from jtf_um_usertype_reg reg , fnd_user fnd
2724: where usertype_reg_id = to_number(itemkey)
2725: and reg.user_id=fnd.USER_ID
2726: )
2727: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 3132: from jtf_um_usertype_reg

3128: p_old_approval_id in number) is
3129:
3130: cursor usertype_reg is
3131: select usertype_reg_id,user_id
3132: from jtf_um_usertype_reg
3133: where usertype_id = p_usertype_id
3134: and status_code = 'PENDING'
3135: and nvl (effective_end_date, sysdate + 1) > sysdate;
3136:

Line 3142: from jtf_um_usertype_reg utreg, jtf_um_usertypes_b ut

3138: p_user_id number;
3139:
3140: cursor find_old_item_type is
3141: select utreg.wf_item_type
3142: from jtf_um_usertype_reg utreg, jtf_um_usertypes_b ut
3143: where utreg.usertype_id = p_usertype_id
3144: and utreg.usertype_id = ut.usertype_id
3145: and utreg.status_code = 'PENDING'
3146: and nvl (utreg.effective_end_date, sysdate + 1) > sysdate;

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

3195:
3196: else
3197:
3198:
3199: -- end date the old record in JTF_UM_USERTYPE_REG table
3200: update JTF_UM_USERTYPE_REG set effective_end_date = sysdate,
3201: last_update_date = sysdate, last_updated_by = FND_GLOBAL.USER_ID
3202: where usertype_reg_id = p_usertype_reg_id;
3203:

Line 3200: update JTF_UM_USERTYPE_REG set effective_end_date = sysdate,

3196: else
3197:
3198:
3199: -- end date the old record in JTF_UM_USERTYPE_REG table
3200: update JTF_UM_USERTYPE_REG set effective_end_date = sysdate,
3201: last_update_date = sysdate, last_updated_by = FND_GLOBAL.USER_ID
3202: where usertype_reg_id = p_usertype_reg_id;
3203:
3204:

Line 3205: -- create record in JTF_UM_USERTYPE_REG table

3201: last_update_date = sysdate, last_updated_by = FND_GLOBAL.USER_ID
3202: where usertype_reg_id = p_usertype_reg_id;
3203:
3204:
3205: -- create record in JTF_UM_USERTYPE_REG table
3206: JTF_UM_USERTYPES_PKG.INSERT_UMREG_ROW (
3207: X_USERTYPE_ID => p_usertype_id,
3208: X_LAST_APPROVER_COMMENT => null,
3209: X_APPROVER_USER_ID => null,

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

3245: p_org_party_id in number) is
3246:
3247: cursor usertype_reg is
3248: select utreg.usertype_reg_id, utreg.user_id
3249: from jtf_um_usertype_reg utreg, fnd_user fu, hz_relationships hzr
3250: where utreg.usertype_id = p_usertype_id
3251: and utreg.status_code = 'PENDING'
3252: and nvl (utreg.effective_end_date, sysdate + 1) > sysdate
3253: and utreg.user_id = fu.user_id

Line 3267: from jtf_um_usertype_reg utreg, jtf_um_usertypes_b ut

3263: p_user_id number;
3264:
3265: cursor find_old_item_type is
3266: select utreg.wf_item_type
3267: from jtf_um_usertype_reg utreg, jtf_um_usertypes_b ut
3268: where utreg.usertype_id = p_usertype_id
3269: and utreg.usertype_id = ut.usertype_id
3270: and utreg.status_code = 'PENDING'
3271: and nvl (utreg.effective_end_date, sysdate + 1) > sysdate;

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

3310: do_approve_req(itemtype => p_wf_old_item_type,
3311: itemkey => p_usertype_reg_id);
3312: else
3313:
3314: -- end date the old record in JTF_UM_USERTYPE_REG table
3315: update JTF_UM_USERTYPE_REG set effective_end_date = sysdate,
3316: last_update_date = sysdate, last_updated_by = FND_GLOBAL.USER_ID
3317: where usertype_reg_id = p_usertype_reg_id
3318: and user_id = p_user_id and status_code='PENDING';

Line 3315: update JTF_UM_USERTYPE_REG set effective_end_date = sysdate,

3311: itemkey => p_usertype_reg_id);
3312: else
3313:
3314: -- end date the old record in JTF_UM_USERTYPE_REG table
3315: update JTF_UM_USERTYPE_REG set effective_end_date = sysdate,
3316: last_update_date = sysdate, last_updated_by = FND_GLOBAL.USER_ID
3317: where usertype_reg_id = p_usertype_reg_id
3318: and user_id = p_user_id and status_code='PENDING';
3319:

Line 3320: -- create record in JTF_UM_USERTYPE_REG table

3316: last_update_date = sysdate, last_updated_by = FND_GLOBAL.USER_ID
3317: where usertype_reg_id = p_usertype_reg_id
3318: and user_id = p_user_id and status_code='PENDING';
3319:
3320: -- create record in JTF_UM_USERTYPE_REG table
3321: JTF_UM_USERTYPES_PKG.INSERT_UMREG_ROW (
3322: X_USERTYPE_ID => p_usertype_id,
3323: X_LAST_APPROVER_COMMENT => null,
3324: X_APPROVER_USER_ID => null,

Line 3400: from jtf_um_usertype_reg

3396: or effective_end_date > sysdate);
3397:
3398: cursor check_usertype_status is
3399: select status_code
3400: from jtf_um_usertype_reg
3401: where user_id = p_user_id
3402: and (effective_end_date is null
3403: or effective_end_date > sysdate);
3404:

Line 3452: -- JTF_UM_USERTYPE_REG table.

3448: else
3449: close subscription_reg_w_org;
3450: end if;
3451: -- all Users who are using the UM should be in the
3452: -- JTF_UM_USERTYPE_REG table.
3453: raise_application_error (20000, 'User info is missing');
3454: end if;
3455: close check_usertype_status;
3456: