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 1169: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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

Line 1175: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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

Line 1579: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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

Line 1585: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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

Line 1761: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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

Line 1767: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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

Line 1969: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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

Line 2002: set LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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

Line 2172: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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

Line 2189: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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

Line 2269: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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,
2271: EFFECTIVE_END_DATE = sysdate
2272: where SUBSCRIPTION_REG_ID = itemkey;
2273: end if;

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

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

Line 3217: X_CREATED_BY => FND_GLOBAL.USER_ID,

3213: X_USERTYPE_REG_ID => p_new_item_key,
3214: X_USER_ID => p_user_id,
3215: X_STATUS_CODE => 'PENDING',
3216: X_CREATION_DATE => sysdate,
3217: X_CREATED_BY => FND_GLOBAL.USER_ID,
3218: X_LAST_UPDATE_DATE => sysdate,
3219: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3220: X_LAST_UPDATE_LOGIN => null);
3221:

Line 3219: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

3215: X_STATUS_CODE => 'PENDING',
3216: X_CREATION_DATE => sysdate,
3217: X_CREATED_BY => FND_GLOBAL.USER_ID,
3218: X_LAST_UPDATE_DATE => sysdate,
3219: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3220: X_LAST_UPDATE_LOGIN => null);
3221:
3222: -- Create WF process
3223: CreateProcess (ownerUserId => FND_GLOBAL.USER_ID,

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

3219: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3220: X_LAST_UPDATE_LOGIN => null);
3221:
3222: -- Create WF process
3223: CreateProcess (ownerUserId => FND_GLOBAL.USER_ID,
3224: requestType => 'USERTYPE',
3225: requestID => p_usertype_id,
3226: requesterUserID => p_user_id,
3227: requestRegID => p_new_item_key);

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

Line 3332: X_CREATED_BY => FND_GLOBAL.USER_ID,

3328: X_USERTYPE_REG_ID => p_new_item_key,
3329: X_USER_ID => p_user_id,
3330: X_STATUS_CODE => 'PENDING',
3331: X_CREATION_DATE => sysdate,
3332: X_CREATED_BY => FND_GLOBAL.USER_ID,
3333: X_LAST_UPDATE_DATE => sysdate,
3334: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3335: X_LAST_UPDATE_LOGIN => null);
3336:

Line 3334: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

3330: X_STATUS_CODE => 'PENDING',
3331: X_CREATION_DATE => sysdate,
3332: X_CREATED_BY => FND_GLOBAL.USER_ID,
3333: X_LAST_UPDATE_DATE => sysdate,
3334: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3335: X_LAST_UPDATE_LOGIN => null);
3336:
3337: -- Create WF process
3338: CreateProcess (ownerUserId => FND_GLOBAL.USER_ID,

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

3334: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3335: X_LAST_UPDATE_LOGIN => null);
3336:
3337: -- Create WF process
3338: CreateProcess (ownerUserId => FND_GLOBAL.USER_ID,
3339: requestType => 'USERTYPE',
3340: requestID => p_usertype_id,
3341: requesterUserID => p_user_id,
3342: requestRegID => p_new_item_key);

Line 3467: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

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;
3469:
3470: -- create record in JTF_UM_SUBSCRIPTION_REG table
3471: JTF_UM_SUBSCRIPTIONS_PKG.INSERT_SUBREG_ROW

Line 3482: X_CREATED_BY => FND_GLOBAL.USER_ID,

3478: X_SUBSCRIPTION_REG_ID => p_new_item_key,
3479: X_USER_ID => p_user_id,
3480: X_STATUS_CODE => 'PENDING',
3481: X_CREATION_DATE => sysdate,
3482: X_CREATED_BY => FND_GLOBAL.USER_ID,
3483: X_LAST_UPDATE_DATE => sysdate,
3484: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3485: X_LAST_UPDATE_LOGIN => null);
3486: else

Line 3484: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

3480: X_STATUS_CODE => 'PENDING',
3481: X_CREATION_DATE => sysdate,
3482: X_CREATED_BY => FND_GLOBAL.USER_ID,
3483: X_LAST_UPDATE_DATE => sysdate,
3484: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3485: X_LAST_UPDATE_LOGIN => null);
3486: else
3487: -- User status is not PENDING
3488: do_approve_req (itemtype => p_wf_old_item_type,

Line 3497: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

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;
3499:
3500: -- create record in JTF_UM_SUBSCRIPTION_REG table
3501: JTF_UM_SUBSCRIPTIONS_PKG.INSERT_SUBREG_ROW

Line 3512: X_CREATED_BY => FND_GLOBAL.USER_ID,

3508: X_SUBSCRIPTION_REG_ID => p_new_item_key,
3509: X_USER_ID => p_user_id,
3510: X_STATUS_CODE => 'PENDING',
3511: X_CREATION_DATE => sysdate,
3512: X_CREATED_BY => FND_GLOBAL.USER_ID,
3513: X_LAST_UPDATE_DATE => sysdate,
3514: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3515: X_LAST_UPDATE_LOGIN => null);
3516:

Line 3514: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

3510: X_STATUS_CODE => 'PENDING',
3511: X_CREATION_DATE => sysdate,
3512: X_CREATED_BY => FND_GLOBAL.USER_ID,
3513: X_LAST_UPDATE_DATE => sysdate,
3514: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3515: X_LAST_UPDATE_LOGIN => null);
3516:
3517: -- Create WF process
3518: CreateProcess (ownerUserId => FND_GLOBAL.USER_ID,

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

3514: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3515: X_LAST_UPDATE_LOGIN => null);
3516:
3517: -- Create WF process
3518: CreateProcess (ownerUserId => FND_GLOBAL.USER_ID,
3519: requestType => 'ENROLLMENT',
3520: requestID => p_subscription_id,
3521: requesterUserID => p_user_id,
3522: requestRegID => p_new_item_key);