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 1259: l_last_updated_by := to_number(fnd_global.USER_ID);

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

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

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

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

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

Line 1414: X_CREATED_BY => fnd_global.USER_ID,

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

Line 1416: X_LAST_UPDATED_BY => fnd_global.USER_ID,

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

Line 1417: X_LAST_UPDATE_LOGIN => fnd_global.LOGIN_ID

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

Line 1669: X_LAST_UPDATED_BY => fnd_global.USER_ID,

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

Line 1670: X_LAST_UPDATE_LOGIN => fnd_global.LOGIN_ID);

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

Line 2293: X_LAST_UPDATED_BY => fnd_global.USER_ID,

2289: X_ATTRIBUTE14 => l_item_group_rec.ATTRIBUTE14,
2290: X_ATTRIBUTE15 => l_item_group_rec.ATTRIBUTE15,
2291: X_DESCRIPTION => l_item_group_rec.DESCRIPTION,
2292: X_LAST_UPDATE_DATE => sysdate,
2293: X_LAST_UPDATED_BY => fnd_global.USER_ID,
2294: X_LAST_UPDATE_LOGIN => fnd_global.LOGIN_ID);
2295:
2296: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 2294: X_LAST_UPDATE_LOGIN => fnd_global.LOGIN_ID);

2290: X_ATTRIBUTE15 => l_item_group_rec.ATTRIBUTE15,
2291: X_DESCRIPTION => l_item_group_rec.DESCRIPTION,
2292: X_LAST_UPDATE_DATE => sysdate,
2293: X_LAST_UPDATED_BY => fnd_global.USER_ID,
2294: X_LAST_UPDATE_LOGIN => fnd_global.LOGIN_ID);
2295:
2296: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2298: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'After Table Handler');

Line 3034: P_REQUESTER_USERID =>fnd_global.user_id,

3030: P_OBJECT_VERSION_NUMBER =>l_object_version_number+1,
3031: P_ORIG_STATUS_CODE =>'ACTIVE',
3032: P_NEW_STATUS_CODE =>'APPROVED',
3033: P_REJECT_STATUS_CODE =>'REJECTED',
3034: P_REQUESTER_USERID =>fnd_global.user_id,
3035: P_NOTES_FROM_REQUESTER =>NULL,
3036: P_WORKFLOWPROCESS =>'AHL_GEN_APPROVAL',
3037: P_ITEM_TYPE =>'AHLGAPP');
3038: ELSE

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

3339: Select AHL_ITEM_GROUPS_B_S.nextval
3340: into l_item_group_id
3341: from dual;
3342:
3343: l_last_updated_by := to_number(fnd_global.USER_ID);
3344: l_last_update_login := to_number(fnd_global.LOGIN_ID);
3345: l_created_by := to_number(fnd_global.user_id);
3346:
3347:

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

3340: into l_item_group_id
3341: from dual;
3342:
3343: l_last_updated_by := to_number(fnd_global.USER_ID);
3344: l_last_update_login := to_number(fnd_global.LOGIN_ID);
3345: l_created_by := to_number(fnd_global.user_id);
3346:
3347:
3348: -- Inserting a new Revision in the Header Table Using table Handler

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

3341: from dual;
3342:
3343: l_last_updated_by := to_number(fnd_global.USER_ID);
3344: l_last_update_login := to_number(fnd_global.LOGIN_ID);
3345: l_created_by := to_number(fnd_global.user_id);
3346:
3347:
3348: -- Inserting a new Revision in the Header Table Using table Handler
3349:

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

3964: update ahl_item_groups_b
3965: set status_code=l_status,
3966: object_version_number = object_version_number+1,
3967: last_update_date = sysdate,
3968: last_updated_by = to_number(fnd_global.user_id),
3969: last_update_login = to_number(fnd_global.login_id)
3970: where item_group_id=l_itemgroup_det.item_group_id
3971: and object_version_number = l_itemgroup_det.object_version_number;
3972:

Line 3969: last_update_login = to_number(fnd_global.login_id)

3965: set status_code=l_status,
3966: object_version_number = object_version_number+1,
3967: last_update_date = sysdate,
3968: last_updated_by = to_number(fnd_global.user_id),
3969: last_update_login = to_number(fnd_global.login_id)
3970: where item_group_id=l_itemgroup_det.item_group_id
3971: and object_version_number = l_itemgroup_det.object_version_number;
3972:
3973: l_action :='C';

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

4003: set status_code = 'COMPLETE',
4004: object_version_number = object_version_number + 1,
4005: source_item_group_id = NULL,
4006: last_update_date = sysdate,
4007: last_updated_by = to_number(fnd_global.user_id),
4008: last_update_login = to_number(fnd_global.login_id)
4009: where item_group_id = l_itemgroup_det.item_group_id and
4010: object_version_number = l_itemgroup_det.object_version_number;
4011:

Line 4008: last_update_login = to_number(fnd_global.login_id)

4004: object_version_number = object_version_number + 1,
4005: source_item_group_id = NULL,
4006: last_update_date = sysdate,
4007: last_updated_by = to_number(fnd_global.user_id),
4008: last_update_login = to_number(fnd_global.login_id)
4009: where item_group_id = l_itemgroup_det.item_group_id and
4010: object_version_number = l_itemgroup_det.object_version_number;
4011:
4012: -- For the positions with temp_item_group_id = null, such positions are not associated to the forked

Line 4062: x_last_updated_by => fnd_global.user_id,

4058: x_attribute14 => l_itemgroup_det.attribute14,
4059: x_attribute15 => l_itemgroup_det.attribute15,
4060: x_description => l_itemgroup_det.description,
4061: x_last_update_date => sysdate,
4062: x_last_updated_by => fnd_global.user_id,
4063: x_last_update_login => fnd_global.login_id);
4064:
4065: -- SATHAPLI::Bug# 4328454 fix
4066: -- Call to AHL_UTIL_UC_PKG.Invalidate_Instance will not be made in this

Line 4063: x_last_update_login => fnd_global.login_id);

4059: x_attribute15 => l_itemgroup_det.attribute15,
4060: x_description => l_itemgroup_det.description,
4061: x_last_update_date => sysdate,
4062: x_last_updated_by => fnd_global.user_id,
4063: x_last_update_login => fnd_global.login_id);
4064:
4065: -- SATHAPLI::Bug# 4328454 fix
4066: -- Call to AHL_UTIL_UC_PKG.Invalidate_Instance will not be made in this
4067: -- procedure.The validation of Item group updates for active UCs is now