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.

[Home] [Help]

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 1166: update JTF_UM_SUBSCRIPTION_REG

1162: LAST_UPDATE_DATE = sysdate,
1163: APPROVER_USER_ID = approverUserID
1164: where USERTYPE_REG_ID = itemkey;
1165: else
1166: update JTF_UM_SUBSCRIPTION_REG
1167: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1168: LAST_UPDATE_DATE = sysdate,
1169: APPROVER_USER_ID = approverUserID
1170: where SUBSCRIPTION_REG_ID = itemkey;

Line 1572: update JTF_UM_SUBSCRIPTION_REG

1568: LAST_UPDATE_DATE = sysdate,
1569: APPROVER_USER_ID = ownerUserID
1570: where USERTYPE_REG_ID = to_number(itemkey);
1571: elsif (requestType = 'ENROLLMENT') then
1572: update JTF_UM_SUBSCRIPTION_REG
1573: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1574: LAST_UPDATE_DATE = sysdate,
1575: APPROVER_USER_ID = ownerUserID
1576: where SUBSCRIPTION_REG_ID = to_number(itemkey);

Line 1754: update JTF_UM_SUBSCRIPTION_REG

1750: LAST_UPDATE_DATE = sysdate,
1751: APPROVER_USER_ID = userId
1752: where USERTYPE_REG_ID = to_number(itemkey);
1753: elsif (requestType = 'ENROLLMENT') then
1754: update JTF_UM_SUBSCRIPTION_REG
1755: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1756: LAST_UPDATE_DATE = sysdate,
1757: APPROVER_USER_ID = userId
1758: where SUBSCRIPTION_REG_ID = to_number(itemkey);

Line 1864: from JTF_UM_SUBSCRIPTION_REG

1860: requesterUsername varchar2 (100);
1861:
1862: cursor enrollmentNoApprovalCursor is
1863: select SUBSCRIPTION_ID
1864: from JTF_UM_SUBSCRIPTION_REG
1865: where USER_ID = requesterUserID
1866: and EFFECTIVE_START_DATE <= sysdate
1867: and nvl (EFFECTIVE_END_DATE, sysdate + 1) > sysdate
1868: and WF_ITEM_TYPE is null

Line 1873: from JTF_UM_SUBSCRIPTION_REG

1869: and STATUS_CODE = 'PENDING';
1870:
1871: cursor enrollmentApprovalCursor is
1872: select WF_ITEM_TYPE, SUBSCRIPTION_REG_ID
1873: from JTF_UM_SUBSCRIPTION_REG
1874: where USER_ID = requesterUserID
1875: and EFFECTIVE_START_DATE <= sysdate
1876: and nvl (EFFECTIVE_END_DATE, sysdate + 1) > sysdate
1877: and WF_ITEM_TYPE is not null

Line 1975: update JTF_UM_SUBSCRIPTION_REG

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

Line 2092: from JTF_UM_SUBSCRIPTION_REG

2088: -- end of changes for 4320347
2089: --
2090: cursor enrollmentsCursor is
2091: select WF_ITEM_TYPE, SUBSCRIPTION_REG_ID
2092: from JTF_UM_SUBSCRIPTION_REG
2093: where USER_ID = requesterUserID
2094: and EFFECTIVE_START_DATE <= sysdate
2095: and nvl (EFFECTIVE_END_DATE, sysdate + 1) > sysdate
2096: and STATUS_CODE = 'PENDING';

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

2156: -- wf_engine.AbortProcess (itemtype => enrollRegRow.WF_ITEM_TYPE,
2157: -- itemkey => enrollRegRow.SUBSCRIPTION_REG_ID);
2158: --end if;
2159:
2160: -- Set STATUS_CODE in JTF_UM_SUBSCRIPTION_REG to 'USER_REJECTED'
2161: update JTF_UM_SUBSCRIPTION_REG
2162: set STATUS_CODE = 'USER_REJECTED',
2163: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2164: LAST_UPDATE_DATE = sysdate,

Line 2161: update JTF_UM_SUBSCRIPTION_REG

2157: -- itemkey => enrollRegRow.SUBSCRIPTION_REG_ID);
2158: --end if;
2159:
2160: -- Set STATUS_CODE in JTF_UM_SUBSCRIPTION_REG to 'USER_REJECTED'
2161: update JTF_UM_SUBSCRIPTION_REG
2162: set STATUS_CODE = 'USER_REJECTED',
2163: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2164: LAST_UPDATE_DATE = sysdate,
2165: EFFECTIVE_END_DATE = sysdate

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

2235:
2236:
2237:
2238: else
2239: -- Set STATUS_CODE in JTF_UM_SUBSCRIPTION_REG to 'REJECTED'
2240: update JTF_UM_SUBSCRIPTION_REG
2241: set STATUS_CODE = 'REJECTED',
2242: LAST_APPROVER_COMMENT = approverComment,
2243: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 2240: update JTF_UM_SUBSCRIPTION_REG

2236:
2237:
2238: else
2239: -- Set STATUS_CODE in JTF_UM_SUBSCRIPTION_REG to 'REJECTED'
2240: update JTF_UM_SUBSCRIPTION_REG
2241: set STATUS_CODE = 'REJECTED',
2242: LAST_APPROVER_COMMENT = approverComment,
2243: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2244: LAST_UPDATE_DATE = sysdate,

Line 2689: from jtf_um_subscription_reg

2685: where usertype_reg_id = to_number (itemkey);
2686:
2687: cursor getLUDFromEnrollReg is
2688: select to_char (last_update_date, 'mmddyyyyhh24miss')
2689: from jtf_um_subscription_reg
2690: where subscription_reg_id = to_number (itemkey);
2691:
2692: -- For bug fix 3894853
2693: cursor getOrgDetail is

Line 3310: from jtf_um_subscription_reg

3306: p_wf_old_item_type varchar2(8);
3307:
3308: cursor subscription_reg is
3309: select subscription_reg_id, user_id, wf_item_type
3310: from jtf_um_subscription_reg
3311: where subscription_id = p_subscription_id
3312: and status_code = 'PENDING'
3313: and (effective_end_date is null
3314: or effective_end_date > sysdate);

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

3314: or effective_end_date > sysdate);
3315:
3316: cursor subscription_reg_w_org is
3317: select subreg.subscription_reg_id, fu.user_id, subreg.wf_item_type
3318: from jtf_um_subscription_reg subreg, fnd_user fu, hz_relationships hzr
3319: where subreg.subscription_id = p_subscription_id
3320: and subreg.status_code = 'PENDING'
3321: and nvl (subreg.effective_end_date, sysdate + 1) > sysdate
3322: and subreg.user_id = fu.user_id

Line 3380: -- JTF_UM_SUBSCRIPTION_REG to null.

3376: if p_wf_new_item_type is null then
3377: -- The user selected no workflow
3378: -- Approve the request if the usertype status is approved.
3379: -- If status is PENDING, change the workflow in the
3380: -- JTF_UM_SUBSCRIPTION_REG to null.
3381:
3382: open check_usertype_status;
3383: fetch check_usertype_status into p_usertype_status;
3384: if (check_usertype_status%notfound) then

Line 3404: update JTF_UM_SUBSCRIPTION_REG

3400: if (p_usertype_status = 'PENDING') or
3401: (p_usertype_status = 'UPGRADE_PENDING') then
3402: -- usertype is 'PENDING', end date the last record and add a new
3403: -- record with null in the workflow itemtype column.
3404: update JTF_UM_SUBSCRIPTION_REG
3405: set EFFECTIVE_END_DATE = sysdate,
3406: LAST_UPDATE_DATE = sysdate,
3407: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
3408: where SUBSCRIPTION_REG_ID = p_subscription_reg_id;

Line 3410: -- create record in JTF_UM_SUBSCRIPTION_REG table

3406: LAST_UPDATE_DATE = sysdate,
3407: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
3408: where SUBSCRIPTION_REG_ID = p_subscription_reg_id;
3409:
3410: -- create record in JTF_UM_SUBSCRIPTION_REG table
3411: JTF_UM_SUBSCRIPTIONS_PKG.INSERT_SUBREG_ROW
3412: (X_SUBSCRIPTION_ID => p_subscription_id,
3413: X_LAST_APPROVER_COMMENT => null,
3414: X_APPROVER_USER_ID => null,

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

3429: itemkey => p_subscription_reg_id);
3430: end if;
3431: else
3432: -- p_wf_new_item_type is not null
3433: -- end date the old record in JTF_UM_SUBSCRIPTION_REG table
3434: update JTF_UM_SUBSCRIPTION_REG
3435: set EFFECTIVE_END_DATE = sysdate,
3436: LAST_UPDATE_DATE = sysdate,
3437: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

Line 3434: update JTF_UM_SUBSCRIPTION_REG

3430: end if;
3431: else
3432: -- p_wf_new_item_type is not null
3433: -- end date the old record in JTF_UM_SUBSCRIPTION_REG table
3434: update JTF_UM_SUBSCRIPTION_REG
3435: set EFFECTIVE_END_DATE = sysdate,
3436: LAST_UPDATE_DATE = sysdate,
3437: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
3438: where SUBSCRIPTION_REG_ID = p_subscription_reg_id;

Line 3440: -- create record in JTF_UM_SUBSCRIPTION_REG table

3436: LAST_UPDATE_DATE = sysdate,
3437: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
3438: where SUBSCRIPTION_REG_ID = p_subscription_reg_id;
3439:
3440: -- create record in JTF_UM_SUBSCRIPTION_REG table
3441: JTF_UM_SUBSCRIPTIONS_PKG.INSERT_SUBREG_ROW
3442: (X_SUBSCRIPTION_ID => p_subscription_id,
3443: X_LAST_APPROVER_COMMENT => null,
3444: X_APPROVER_USER_ID => null,