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_SUBSCRIPTION_REG

Line 497: from JTF_UM_SUBSCRIPTION_REG

493: where USERTYPE_REG_ID = requestRegID;
494:
495: cursor get_enroll_itemtype is
496: select WF_ITEM_TYPE
497: from JTF_UM_SUBSCRIPTION_REG
498: where SUBSCRIPTION_REG_ID = requestRegID;
499:
500: itemtype varchar2 (8);
501:

Line 525: raise_application_error ('20000', 'Workflow itemtype is missing in the JTF_UM_SUBSCRIPTION_REG table with SUBSCRIPTION_REG_ID: ' || requestRegID);

521: open get_enroll_itemtype;
522: fetch get_enroll_itemtype into itemtype;
523: if (get_enroll_itemtype%notfound) then
524: close get_enroll_itemtype;
525: raise_application_error ('20000', 'Workflow itemtype is missing in the JTF_UM_SUBSCRIPTION_REG table with SUBSCRIPTION_REG_ID: ' || requestRegID);
526: end if;
527: close get_enroll_itemtype;
528:
529: else

Line 1174: update JTF_UM_SUBSCRIPTION_REG

1170: LAST_UPDATE_DATE = sysdate,
1171: APPROVER_USER_ID = approverUserID
1172: where USERTYPE_REG_ID = itemkey;
1173: else
1174: update JTF_UM_SUBSCRIPTION_REG
1175: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1176: LAST_UPDATE_DATE = sysdate,
1177: APPROVER_USER_ID = approverUserID
1178: where SUBSCRIPTION_REG_ID = itemkey;

Line 1584: update JTF_UM_SUBSCRIPTION_REG

1580: LAST_UPDATE_DATE = sysdate,
1581: APPROVER_USER_ID = ownerUserID
1582: where USERTYPE_REG_ID = to_number(itemkey);
1583: elsif (requestType = 'ENROLLMENT') then
1584: update JTF_UM_SUBSCRIPTION_REG
1585: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1586: LAST_UPDATE_DATE = sysdate,
1587: APPROVER_USER_ID = ownerUserID
1588: where SUBSCRIPTION_REG_ID = to_number(itemkey);

Line 1766: update JTF_UM_SUBSCRIPTION_REG

1762: LAST_UPDATE_DATE = sysdate,
1763: APPROVER_USER_ID = userId
1764: where USERTYPE_REG_ID = to_number(itemkey);
1765: elsif (requestType = 'ENROLLMENT') then
1766: update JTF_UM_SUBSCRIPTION_REG
1767: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1768: LAST_UPDATE_DATE = sysdate,
1769: APPROVER_USER_ID = userId
1770: where SUBSCRIPTION_REG_ID = to_number(itemkey);

Line 1879: from JTF_UM_SUBSCRIPTION_REG

1875: profileSave boolean;
1876:
1877: cursor enrollmentNoApprovalCursor is
1878: select SUBSCRIPTION_ID
1879: from JTF_UM_SUBSCRIPTION_REG
1880: where USER_ID = requesterUserID
1881: and EFFECTIVE_START_DATE <= sysdate
1882: and nvl (EFFECTIVE_END_DATE, sysdate + 1) > sysdate
1883: and WF_ITEM_TYPE is null

Line 1888: from JTF_UM_SUBSCRIPTION_REG

1884: and STATUS_CODE = 'PENDING';
1885:
1886: cursor enrollmentApprovalCursor is
1887: select WF_ITEM_TYPE, SUBSCRIPTION_REG_ID
1888: from JTF_UM_SUBSCRIPTION_REG
1889: where USER_ID = requesterUserID
1890: and EFFECTIVE_START_DATE <= sysdate
1891: and nvl (EFFECTIVE_END_DATE, sysdate + 1) > sysdate
1892: and WF_ITEM_TYPE is not null

Line 2001: update JTF_UM_SUBSCRIPTION_REG

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
2005: where subscription_reg_id = itemkey;

Line 2118: from JTF_UM_SUBSCRIPTION_REG

2114: -- end of changes for 4320347
2115: --
2116: cursor enrollmentsCursor is
2117: select WF_ITEM_TYPE, SUBSCRIPTION_REG_ID
2118: from JTF_UM_SUBSCRIPTION_REG
2119: where USER_ID = requesterUserID
2120: and EFFECTIVE_START_DATE <= sysdate
2121: and nvl (EFFECTIVE_END_DATE, sysdate + 1) > sysdate
2122: and STATUS_CODE = 'PENDING';

Line 2186: -- Set STATUS_CODE in JTF_UM_SUBSCRIPTION_REG to 'USER_REJECTED'

2182: -- wf_engine.AbortProcess (itemtype => enrollRegRow.WF_ITEM_TYPE,
2183: -- itemkey => enrollRegRow.SUBSCRIPTION_REG_ID);
2184: --end if;
2185:
2186: -- Set STATUS_CODE in JTF_UM_SUBSCRIPTION_REG to 'USER_REJECTED'
2187: update JTF_UM_SUBSCRIPTION_REG
2188: set STATUS_CODE = 'USER_REJECTED',
2189: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2190: LAST_UPDATE_DATE = sysdate,

Line 2187: update JTF_UM_SUBSCRIPTION_REG

2183: -- itemkey => enrollRegRow.SUBSCRIPTION_REG_ID);
2184: --end if;
2185:
2186: -- Set STATUS_CODE in JTF_UM_SUBSCRIPTION_REG to 'USER_REJECTED'
2187: update JTF_UM_SUBSCRIPTION_REG
2188: set STATUS_CODE = 'USER_REJECTED',
2189: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2190: LAST_UPDATE_DATE = sysdate,
2191: EFFECTIVE_END_DATE = sysdate

Line 2265: -- Set STATUS_CODE in JTF_UM_SUBSCRIPTION_REG to 'REJECTED'

2261:
2262:
2263:
2264: else
2265: -- Set STATUS_CODE in JTF_UM_SUBSCRIPTION_REG to 'REJECTED'
2266: update JTF_UM_SUBSCRIPTION_REG
2267: set STATUS_CODE = 'REJECTED',
2268: LAST_APPROVER_COMMENT = approverComment,
2269: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 2266: update JTF_UM_SUBSCRIPTION_REG

2262:
2263:
2264: else
2265: -- Set STATUS_CODE in JTF_UM_SUBSCRIPTION_REG to 'REJECTED'
2266: update JTF_UM_SUBSCRIPTION_REG
2267: set STATUS_CODE = 'REJECTED',
2268: LAST_APPROVER_COMMENT = approverComment,
2269: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2270: LAST_UPDATE_DATE = sysdate,

Line 2715: from jtf_um_subscription_reg

2711: where usertype_reg_id = to_number (itemkey);
2712:
2713: cursor getLUDFromEnrollReg is
2714: select to_char (last_update_date, 'mmddyyyyhh24miss')
2715: from jtf_um_subscription_reg
2716: where subscription_reg_id = to_number (itemkey);
2717:
2718: -- For bug fix 3894853
2719: cursor getOrgDetail is

Line 3370: from jtf_um_subscription_reg

3366: p_wf_old_item_type varchar2(8);
3367:
3368: cursor subscription_reg is
3369: select subscription_reg_id, user_id, wf_item_type
3370: from jtf_um_subscription_reg
3371: where subscription_id = p_subscription_id
3372: and status_code = 'PENDING'
3373: and (effective_end_date is null
3374: or effective_end_date > sysdate);

Line 3378: from jtf_um_subscription_reg subreg, fnd_user fu, hz_relationships hzr

3374: or effective_end_date > sysdate);
3375:
3376: cursor subscription_reg_w_org is
3377: select subreg.subscription_reg_id, fu.user_id, subreg.wf_item_type
3378: from jtf_um_subscription_reg subreg, fnd_user fu, hz_relationships hzr
3379: where subreg.subscription_id = p_subscription_id
3380: and subreg.status_code = 'PENDING'
3381: and nvl (subreg.effective_end_date, sysdate + 1) > sysdate
3382: and subreg.user_id = fu.user_id

Line 3440: -- JTF_UM_SUBSCRIPTION_REG to null.

3436: if p_wf_new_item_type is null then
3437: -- The user selected no workflow
3438: -- Approve the request if the usertype status is approved.
3439: -- If status is PENDING, change the workflow in the
3440: -- JTF_UM_SUBSCRIPTION_REG to null.
3441:
3442: open check_usertype_status;
3443: fetch check_usertype_status into p_usertype_status;
3444: if (check_usertype_status%notfound) then

Line 3464: update JTF_UM_SUBSCRIPTION_REG

3460: if (p_usertype_status = 'PENDING') or
3461: (p_usertype_status = 'UPGRADE_PENDING') then
3462: -- usertype is 'PENDING', end date the last record and add a new
3463: -- record with null in the workflow itemtype column.
3464: update JTF_UM_SUBSCRIPTION_REG
3465: set EFFECTIVE_END_DATE = sysdate,
3466: LAST_UPDATE_DATE = sysdate,
3467: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
3468: where SUBSCRIPTION_REG_ID = p_subscription_reg_id;

Line 3470: -- create record in JTF_UM_SUBSCRIPTION_REG table

3466: LAST_UPDATE_DATE = sysdate,
3467: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
3468: where SUBSCRIPTION_REG_ID = p_subscription_reg_id;
3469:
3470: -- create record in JTF_UM_SUBSCRIPTION_REG table
3471: JTF_UM_SUBSCRIPTIONS_PKG.INSERT_SUBREG_ROW
3472: (X_SUBSCRIPTION_ID => p_subscription_id,
3473: X_LAST_APPROVER_COMMENT => null,
3474: X_APPROVER_USER_ID => null,

Line 3493: -- end date the old record in JTF_UM_SUBSCRIPTION_REG table

3489: itemkey => p_subscription_reg_id);
3490: end if;
3491: else
3492: -- p_wf_new_item_type is not null
3493: -- end date the old record in JTF_UM_SUBSCRIPTION_REG table
3494: update JTF_UM_SUBSCRIPTION_REG
3495: set EFFECTIVE_END_DATE = sysdate,
3496: LAST_UPDATE_DATE = sysdate,
3497: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

Line 3494: update JTF_UM_SUBSCRIPTION_REG

3490: end if;
3491: else
3492: -- p_wf_new_item_type is not null
3493: -- end date the old record in JTF_UM_SUBSCRIPTION_REG table
3494: update JTF_UM_SUBSCRIPTION_REG
3495: set EFFECTIVE_END_DATE = sysdate,
3496: LAST_UPDATE_DATE = sysdate,
3497: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
3498: where SUBSCRIPTION_REG_ID = p_subscription_reg_id;

Line 3500: -- create record in JTF_UM_SUBSCRIPTION_REG table

3496: LAST_UPDATE_DATE = sysdate,
3497: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
3498: where SUBSCRIPTION_REG_ID = p_subscription_reg_id;
3499:
3500: -- create record in JTF_UM_SUBSCRIPTION_REG table
3501: JTF_UM_SUBSCRIPTIONS_PKG.INSERT_SUBREG_ROW
3502: (X_SUBSCRIPTION_ID => p_subscription_id,
3503: X_LAST_APPROVER_COMMENT => null,
3504: X_APPROVER_USER_ID => null,