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 FND_GLOBAL

Line 1161: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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;
1165: else

Line 1167: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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;
1171: end if;

Line 1567: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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);
1571: elsif (requestType = 'ENROLLMENT') then

Line 1573: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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);
1577: end if;

Line 1749: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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);
1753: elsif (requestType = 'ENROLLMENT') then

Line 1755: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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);
1759: end if;

Line 1943: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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;
1947:

Line 1976: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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;
1980:

Line 2146: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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,
2149: EFFECTIVE_END_DATE = sysdate
2150: where USERTYPE_REG_ID = itemkey;

Line 2163: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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
2166: where SUBSCRIPTION_REG_ID = enrollRegRow.SUBSCRIPTION_REG_ID;
2167: end loop;

Line 2243: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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,
2245: EFFECTIVE_END_DATE = sysdate
2246: where SUBSCRIPTION_REG_ID = itemkey;
2247: end if;

Line 3141: last_update_date = sysdate, last_updated_by = FND_GLOBAL.USER_ID

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:
3145: -- create record in JTF_UM_USERTYPE_REG table

Line 3157: X_CREATED_BY => FND_GLOBAL.USER_ID,

3153: X_USERTYPE_REG_ID => p_new_item_key,
3154: X_USER_ID => p_user_id,
3155: X_STATUS_CODE => 'PENDING',
3156: X_CREATION_DATE => sysdate,
3157: X_CREATED_BY => FND_GLOBAL.USER_ID,
3158: X_LAST_UPDATE_DATE => sysdate,
3159: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3160: X_LAST_UPDATE_LOGIN => null);
3161:

Line 3159: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

3155: X_STATUS_CODE => 'PENDING',
3156: X_CREATION_DATE => sysdate,
3157: X_CREATED_BY => FND_GLOBAL.USER_ID,
3158: X_LAST_UPDATE_DATE => sysdate,
3159: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3160: X_LAST_UPDATE_LOGIN => null);
3161:
3162: -- Create WF process
3163: CreateProcess (ownerUserId => FND_GLOBAL.USER_ID,

Line 3163: CreateProcess (ownerUserId => FND_GLOBAL.USER_ID,

3159: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3160: X_LAST_UPDATE_LOGIN => null);
3161:
3162: -- Create WF process
3163: CreateProcess (ownerUserId => FND_GLOBAL.USER_ID,
3164: requestType => 'USERTYPE',
3165: requestID => p_usertype_id,
3166: requesterUserID => p_user_id,
3167: requestRegID => p_new_item_key);

Line 3256: last_update_date = sysdate, last_updated_by = FND_GLOBAL.USER_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:
3260: -- create record in JTF_UM_USERTYPE_REG table

Line 3272: X_CREATED_BY => FND_GLOBAL.USER_ID,

3268: X_USERTYPE_REG_ID => p_new_item_key,
3269: X_USER_ID => p_user_id,
3270: X_STATUS_CODE => 'PENDING',
3271: X_CREATION_DATE => sysdate,
3272: X_CREATED_BY => FND_GLOBAL.USER_ID,
3273: X_LAST_UPDATE_DATE => sysdate,
3274: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3275: X_LAST_UPDATE_LOGIN => null);
3276:

Line 3274: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

3270: X_STATUS_CODE => 'PENDING',
3271: X_CREATION_DATE => sysdate,
3272: X_CREATED_BY => FND_GLOBAL.USER_ID,
3273: X_LAST_UPDATE_DATE => sysdate,
3274: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3275: X_LAST_UPDATE_LOGIN => null);
3276:
3277: -- Create WF process
3278: CreateProcess (ownerUserId => FND_GLOBAL.USER_ID,

Line 3278: CreateProcess (ownerUserId => FND_GLOBAL.USER_ID,

3274: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3275: X_LAST_UPDATE_LOGIN => null);
3276:
3277: -- Create WF process
3278: CreateProcess (ownerUserId => FND_GLOBAL.USER_ID,
3279: requestType => 'USERTYPE',
3280: requestID => p_usertype_id,
3281: requesterUserID => p_user_id,
3282: requestRegID => p_new_item_key);

Line 3407: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

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;
3409:
3410: -- create record in JTF_UM_SUBSCRIPTION_REG table
3411: JTF_UM_SUBSCRIPTIONS_PKG.INSERT_SUBREG_ROW

Line 3422: X_CREATED_BY => FND_GLOBAL.USER_ID,

3418: X_SUBSCRIPTION_REG_ID => p_new_item_key,
3419: X_USER_ID => p_user_id,
3420: X_STATUS_CODE => 'PENDING',
3421: X_CREATION_DATE => sysdate,
3422: X_CREATED_BY => FND_GLOBAL.USER_ID,
3423: X_LAST_UPDATE_DATE => sysdate,
3424: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3425: X_LAST_UPDATE_LOGIN => null);
3426: else

Line 3424: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

3420: X_STATUS_CODE => 'PENDING',
3421: X_CREATION_DATE => sysdate,
3422: X_CREATED_BY => FND_GLOBAL.USER_ID,
3423: X_LAST_UPDATE_DATE => sysdate,
3424: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3425: X_LAST_UPDATE_LOGIN => null);
3426: else
3427: -- User status is not PENDING
3428: do_approve_req (itemtype => p_wf_old_item_type,

Line 3437: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

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;
3439:
3440: -- create record in JTF_UM_SUBSCRIPTION_REG table
3441: JTF_UM_SUBSCRIPTIONS_PKG.INSERT_SUBREG_ROW

Line 3452: X_CREATED_BY => FND_GLOBAL.USER_ID,

3448: X_SUBSCRIPTION_REG_ID => p_new_item_key,
3449: X_USER_ID => p_user_id,
3450: X_STATUS_CODE => 'PENDING',
3451: X_CREATION_DATE => sysdate,
3452: X_CREATED_BY => FND_GLOBAL.USER_ID,
3453: X_LAST_UPDATE_DATE => sysdate,
3454: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3455: X_LAST_UPDATE_LOGIN => null);
3456:

Line 3454: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

3450: X_STATUS_CODE => 'PENDING',
3451: X_CREATION_DATE => sysdate,
3452: X_CREATED_BY => FND_GLOBAL.USER_ID,
3453: X_LAST_UPDATE_DATE => sysdate,
3454: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3455: X_LAST_UPDATE_LOGIN => null);
3456:
3457: -- Create WF process
3458: CreateProcess (ownerUserId => FND_GLOBAL.USER_ID,

Line 3458: CreateProcess (ownerUserId => FND_GLOBAL.USER_ID,

3454: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3455: X_LAST_UPDATE_LOGIN => null);
3456:
3457: -- Create WF process
3458: CreateProcess (ownerUserId => FND_GLOBAL.USER_ID,
3459: requestType => 'ENROLLMENT',
3460: requestID => p_subscription_id,
3461: requesterUserID => p_user_id,
3462: requestRegID => p_new_item_key);