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.AHL_MC_ITEMGROUP_PVT dependencies on FND_GLOBAL

Line 1261: l_last_updated_by := to_number(fnd_global.USER_ID);

1257: --Gets the sequence Number
1258: SELECT AHL_ITEM_GROUPS_B_S.nextval INTO
1259: l_item_grp_id from DUAL;
1260:
1261: l_last_updated_by := to_number(fnd_global.USER_ID);
1262: l_last_update_login := to_number(fnd_global.LOGIN_ID);
1263:
1264: AHL_ITEM_GROUPS_PKG.INSERT_ROW(
1265: X_ROWID => l_row_id,

Line 1262: l_last_update_login := to_number(fnd_global.LOGIN_ID);

1258: SELECT AHL_ITEM_GROUPS_B_S.nextval INTO
1259: l_item_grp_id from DUAL;
1260:
1261: l_last_updated_by := to_number(fnd_global.USER_ID);
1262: l_last_update_login := to_number(fnd_global.LOGIN_ID);
1263:
1264: AHL_ITEM_GROUPS_PKG.INSERT_ROW(
1265: X_ROWID => l_row_id,
1266: X_ITEM_GROUP_ID => l_item_grp_id,

Line 1290: X_CREATED_BY => to_number(fnd_global.USER_ID),

1286: X_ATTRIBUTE14 => p_x_item_grp_rec.attribute14,
1287: X_ATTRIBUTE15 => p_x_item_grp_rec.attribute15,
1288: X_DESCRIPTION => p_x_item_grp_rec.description,
1289: X_CREATION_DATE => sysdate,
1290: X_CREATED_BY => to_number(fnd_global.USER_ID),
1291: X_LAST_UPDATE_DATE => sysdate,
1292: X_LAST_UPDATED_BY => l_last_updated_by,
1293: X_LAST_UPDATE_LOGIN => l_last_update_login);
1294:

Line 1416: X_CREATED_BY => fnd_global.USER_ID,

1412: X_ATTRIBUTE14 => l_item_assoc_rec.ATTRIBUTE14,
1413: X_ATTRIBUTE15 => l_item_assoc_rec.ATTRIBUTE15,
1414: X_INTERCHANGE_REASON => l_item_assoc_rec.INTERCHANGE_REASON,
1415: X_CREATION_DATE => sysdate,
1416: X_CREATED_BY => fnd_global.USER_ID,
1417: X_LAST_UPDATE_DATE => sysdate,
1418: X_LAST_UPDATED_BY => fnd_global.USER_ID,
1419: X_LAST_UPDATE_LOGIN => fnd_global.LOGIN_ID
1420: );

Line 1418: X_LAST_UPDATED_BY => fnd_global.USER_ID,

1414: X_INTERCHANGE_REASON => l_item_assoc_rec.INTERCHANGE_REASON,
1415: X_CREATION_DATE => sysdate,
1416: X_CREATED_BY => fnd_global.USER_ID,
1417: X_LAST_UPDATE_DATE => sysdate,
1418: X_LAST_UPDATED_BY => fnd_global.USER_ID,
1419: X_LAST_UPDATE_LOGIN => fnd_global.LOGIN_ID
1420: );
1421:
1422: --Insert in AHL_ITEM_ASSOCIATIONS_B table

Line 1419: X_LAST_UPDATE_LOGIN => fnd_global.LOGIN_ID

1415: X_CREATION_DATE => sysdate,
1416: X_CREATED_BY => fnd_global.USER_ID,
1417: X_LAST_UPDATE_DATE => sysdate,
1418: X_LAST_UPDATED_BY => fnd_global.USER_ID,
1419: X_LAST_UPDATE_LOGIN => fnd_global.LOGIN_ID
1420: );
1421:
1422: --Insert in AHL_ITEM_ASSOCIATIONS_B table
1423:

Line 1671: X_LAST_UPDATED_BY => fnd_global.USER_ID,

1667: X_ATTRIBUTE14 => l_item_assoc_rec.attribute14,
1668: X_ATTRIBUTE15 => l_item_assoc_rec.attribute15,
1669: X_INTERCHANGE_REASON => l_item_assoc_rec.interchange_reason,
1670: X_LAST_UPDATE_DATE => sysdate,
1671: X_LAST_UPDATED_BY => fnd_global.USER_ID,
1672: X_LAST_UPDATE_LOGIN => fnd_global.LOGIN_ID);
1673:
1674:
1675: CLOSE Item_assoc_csr;

Line 1672: X_LAST_UPDATE_LOGIN => fnd_global.LOGIN_ID);

1668: X_ATTRIBUTE15 => l_item_assoc_rec.attribute15,
1669: X_INTERCHANGE_REASON => l_item_assoc_rec.interchange_reason,
1670: X_LAST_UPDATE_DATE => sysdate,
1671: X_LAST_UPDATED_BY => fnd_global.USER_ID,
1672: X_LAST_UPDATE_LOGIN => fnd_global.LOGIN_ID);
1673:
1674:
1675: CLOSE Item_assoc_csr;
1676:

Line 2303: X_LAST_UPDATED_BY => fnd_global.USER_ID,

2299: X_ATTRIBUTE14 => l_item_group_rec.ATTRIBUTE14,
2300: X_ATTRIBUTE15 => l_item_group_rec.ATTRIBUTE15,
2301: X_DESCRIPTION => l_item_group_rec.DESCRIPTION,
2302: X_LAST_UPDATE_DATE => sysdate,
2303: X_LAST_UPDATED_BY => fnd_global.USER_ID,
2304: X_LAST_UPDATE_LOGIN => fnd_global.LOGIN_ID);
2305:
2306: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2307: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 2304: X_LAST_UPDATE_LOGIN => fnd_global.LOGIN_ID);

2300: X_ATTRIBUTE15 => l_item_group_rec.ATTRIBUTE15,
2301: X_DESCRIPTION => l_item_group_rec.DESCRIPTION,
2302: X_LAST_UPDATE_DATE => sysdate,
2303: X_LAST_UPDATED_BY => fnd_global.USER_ID,
2304: X_LAST_UPDATE_LOGIN => fnd_global.LOGIN_ID);
2305:
2306: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2307: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2308: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'After Table Handler');

Line 3044: P_REQUESTER_USERID =>fnd_global.user_id,

3040: P_OBJECT_VERSION_NUMBER =>l_object_version_number+1,
3041: P_ORIG_STATUS_CODE =>'ACTIVE',
3042: P_NEW_STATUS_CODE =>'APPROVED',
3043: P_REJECT_STATUS_CODE =>'REJECTED',
3044: P_REQUESTER_USERID =>fnd_global.user_id,
3045: P_NOTES_FROM_REQUESTER =>NULL,
3046: P_WORKFLOWPROCESS =>'AHL_GEN_APPROVAL',
3047: P_ITEM_TYPE =>'AHLGAPP');
3048: ELSE

Line 3353: l_last_updated_by := to_number(fnd_global.USER_ID);

3349: Select AHL_ITEM_GROUPS_B_S.nextval
3350: into l_item_group_id
3351: from dual;
3352:
3353: l_last_updated_by := to_number(fnd_global.USER_ID);
3354: l_last_update_login := to_number(fnd_global.LOGIN_ID);
3355: l_created_by := to_number(fnd_global.user_id);
3356:
3357:

Line 3354: l_last_update_login := to_number(fnd_global.LOGIN_ID);

3350: into l_item_group_id
3351: from dual;
3352:
3353: l_last_updated_by := to_number(fnd_global.USER_ID);
3354: l_last_update_login := to_number(fnd_global.LOGIN_ID);
3355: l_created_by := to_number(fnd_global.user_id);
3356:
3357:
3358: -- Inserting a new Revision in the Header Table Using table Handler

Line 3355: l_created_by := to_number(fnd_global.user_id);

3351: from dual;
3352:
3353: l_last_updated_by := to_number(fnd_global.USER_ID);
3354: l_last_update_login := to_number(fnd_global.LOGIN_ID);
3355: l_created_by := to_number(fnd_global.user_id);
3356:
3357:
3358: -- Inserting a new Revision in the Header Table Using table Handler
3359:

Line 3978: last_updated_by = to_number(fnd_global.user_id),

3974: update ahl_item_groups_b
3975: set status_code=l_status,
3976: object_version_number = object_version_number+1,
3977: last_update_date = sysdate,
3978: last_updated_by = to_number(fnd_global.user_id),
3979: last_update_login = to_number(fnd_global.login_id)
3980: where item_group_id=l_itemgroup_det.item_group_id
3981: and object_version_number = l_itemgroup_det.object_version_number;
3982:

Line 3979: last_update_login = to_number(fnd_global.login_id)

3975: set status_code=l_status,
3976: object_version_number = object_version_number+1,
3977: last_update_date = sysdate,
3978: last_updated_by = to_number(fnd_global.user_id),
3979: last_update_login = to_number(fnd_global.login_id)
3980: where item_group_id=l_itemgroup_det.item_group_id
3981: and object_version_number = l_itemgroup_det.object_version_number;
3982:
3983: l_action :='C';

Line 4025: last_updated_by = to_number(fnd_global.user_id),

4021: set status_code = 'COMPLETE',
4022: object_version_number = object_version_number + 1,
4023: source_item_group_id = NULL,
4024: last_update_date = sysdate,
4025: last_updated_by = to_number(fnd_global.user_id),
4026: last_update_login = to_number(fnd_global.login_id)
4027: where item_group_id = l_itemgroup_det.item_group_id and
4028: object_version_number = l_itemgroup_det.object_version_number;
4029:

Line 4026: last_update_login = to_number(fnd_global.login_id)

4022: object_version_number = object_version_number + 1,
4023: source_item_group_id = NULL,
4024: last_update_date = sysdate,
4025: last_updated_by = to_number(fnd_global.user_id),
4026: last_update_login = to_number(fnd_global.login_id)
4027: where item_group_id = l_itemgroup_det.item_group_id and
4028: object_version_number = l_itemgroup_det.object_version_number;
4029:
4030: -- For the positions with temp_item_group_id = null, such positions are not associated to the forked

Line 4088: x_last_updated_by => fnd_global.user_id,

4084: x_attribute14 => l_itemgroup_det.attribute14,
4085: x_attribute15 => l_itemgroup_det.attribute15,
4086: x_description => l_itemgroup_det.description,
4087: x_last_update_date => sysdate,
4088: x_last_updated_by => fnd_global.user_id,
4089: x_last_update_login => fnd_global.login_id);
4090:
4091: -- SATHAPLI::Bug# 4328454 fix
4092: -- Call to AHL_UTIL_UC_PKG.Invalidate_Instance will not be made in this

Line 4089: x_last_update_login => fnd_global.login_id);

4085: x_attribute15 => l_itemgroup_det.attribute15,
4086: x_description => l_itemgroup_det.description,
4087: x_last_update_date => sysdate,
4088: x_last_updated_by => fnd_global.user_id,
4089: x_last_update_login => fnd_global.login_id);
4090:
4091: -- SATHAPLI::Bug# 4328454 fix
4092: -- Call to AHL_UTIL_UC_PKG.Invalidate_Instance will not be made in this
4093: -- procedure.The validation of Item group updates for active UCs is now