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_ITEM_COMP_PVT dependencies on FND_GLOBAL

Line 459: l_user_id := to_number(fnd_global.USER_ID);

455: Select AHL_ITEM_COMPOSITIONS_S.NEXTVAL
456: INTO l_item_composition_id
457: FROM DUAL;
458:
459: l_user_id := to_number(fnd_global.USER_ID);
460:
461: INSERT INTO AHL_ITEM_COMPOSITIONS(
462: ITEM_COMPOSITION_ID ,
463: INVENTORY_ITEM_ID ,

Line 506: to_number(fnd_global.LOGIN_ID) ,

502: sysdate,
503: l_user_id,
504: sysdate,
505: l_user_id ,
506: to_number(fnd_global.LOGIN_ID) ,
507: 1 ,
508: NULL,
509: p_x_ic_header_rec.ATTRIBUTE_CATEGORY,
510: p_x_ic_header_rec.ATTRIBUTE1,

Line 764: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),

760: UPDATE AHL_ITEM_COMPOSITIONS
761: SET
762: APPROVAL_STATUS_CODE = l_item_composition_rec.approval_status_code ,
763: LAST_UPDATE_DATE = sysdate,
764: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
765: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID) ,
766: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
767: SECURITY_GROUP_ID =NULL,
768: ATTRIBUTE_CATEGORY = p_x_ic_header_rec.ATTRIBUTE_CATEGORY,

Line 765: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID) ,

761: SET
762: APPROVAL_STATUS_CODE = l_item_composition_rec.approval_status_code ,
763: LAST_UPDATE_DATE = sysdate,
764: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
765: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID) ,
766: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
767: SECURITY_GROUP_ID =NULL,
768: ATTRIBUTE_CATEGORY = p_x_ic_header_rec.ATTRIBUTE_CATEGORY,
769: ATTRIBUTE1 = p_x_ic_header_rec.ATTRIBUTE1,

Line 1081: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),

1077:
1078: UPDATE AHL_ITEM_COMPOSITIONS
1079: SET
1080: LAST_UPDATE_DATE = sysdate,
1081: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
1082: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID) ,
1083: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
1084: SECURITY_GROUP_ID =NULL,
1085: EFFECTIVE_END_DATE = sysdate -1

Line 1082: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID) ,

1078: UPDATE AHL_ITEM_COMPOSITIONS
1079: SET
1080: LAST_UPDATE_DATE = sysdate,
1081: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
1082: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID) ,
1083: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
1084: SECURITY_GROUP_ID =NULL,
1085: EFFECTIVE_END_DATE = sysdate -1
1086: WHERE ITEM_COMPOSITION_ID = p_item_composition_ID

Line 1322: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),

1318:
1319: UPDATE AHL_ITEM_COMPOSITIONS
1320: SET
1321: LAST_UPDATE_DATE = sysdate,
1322: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
1323: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID) ,
1324: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
1325: SECURITY_GROUP_ID =NULL,
1326: EFFECTIVE_END_DATE = null

Line 1323: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID) ,

1319: UPDATE AHL_ITEM_COMPOSITIONS
1320: SET
1321: LAST_UPDATE_DATE = sysdate,
1322: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
1323: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID) ,
1324: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
1325: SECURITY_GROUP_ID =NULL,
1326: EFFECTIVE_END_DATE = null
1327: WHERE ITEM_COMPOSITION_ID = p_item_composition_ID

Line 1405: l_user_id := to_number(fnd_global.USER_ID);

1401: SELECT AHL_ITEM_COMP_DETAILS_S.NEXTVAL
1402: INTO l_item_comp_detail_id
1403: FROM DUAL;
1404:
1405: l_user_id := to_number(fnd_global.USER_ID);
1406:
1407: IF p_item_composition_id IS NOT NULL THEN
1408:
1409: INSERT INTO AHL_ITEM_COMP_DETAILS(

Line 1458: to_number(fnd_global.LOGIN_ID),

1454: sysdate,
1455: l_user_id ,
1456: sysdate,
1457: l_user_id,
1458: to_number(fnd_global.LOGIN_ID),
1459: 1,
1460: NULL,
1461: p_x_comp_det_rec.ATTRIBUTE_CATEGORY ,
1462: p_x_comp_det_rec.ATTRIBUTE1 ,

Line 1508: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),

1504: INVENTORY_MASTER_ORG_ID = p_x_comp_det_rec.INVENTORY_MASTER_ORG_ID,
1505: UOM_CODE =p_x_comp_det_rec.UOM_CODE ,
1506: QUANTITY =p_x_comp_det_rec.QUANTITY,
1507: LAST_UPDATE_DATE =sysdate,
1508: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
1509: LAST_UPDATE_LOGIN = to_number(fnd_global.LOGIN_ID),
1510: OBJECT_VERSION_NUMBER =object_version_number+1,
1511: SECURITY_GROUP_ID =NULL,
1512: ATTRIBUTE_CATEGORY =p_x_comp_det_rec.ATTRIBUTE_CATEGORY,

Line 1509: LAST_UPDATE_LOGIN = to_number(fnd_global.LOGIN_ID),

1505: UOM_CODE =p_x_comp_det_rec.UOM_CODE ,
1506: QUANTITY =p_x_comp_det_rec.QUANTITY,
1507: LAST_UPDATE_DATE =sysdate,
1508: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
1509: LAST_UPDATE_LOGIN = to_number(fnd_global.LOGIN_ID),
1510: OBJECT_VERSION_NUMBER =object_version_number+1,
1511: SECURITY_GROUP_ID =NULL,
1512: ATTRIBUTE_CATEGORY =p_x_comp_det_rec.ATTRIBUTE_CATEGORY,
1513: ATTRIBUTE1 =p_x_comp_det_rec.ATTRIBUTE1,

Line 1769: P_REQUESTER_USERID =>fnd_global.user_id,

1765: P_OBJECT_VERSION_NUMBER =>l_object_version_number+1,
1766: P_ORIG_STATUS_CODE =>'ACTIVE',
1767: P_NEW_STATUS_CODE =>'APPROVED',
1768: P_REJECT_STATUS_CODE =>'REJECTED',
1769: P_REQUESTER_USERID =>fnd_global.user_id,
1770: P_NOTES_FROM_REQUESTER =>NULL,
1771: P_WORKFLOWPROCESS =>'AHL_GEN_APPROVAL',
1772: P_ITEM_TYPE =>'AHLGAPP');
1773: ELSE

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

2010:
2011: -- Sequence Number for the New Revision.
2012:
2013:
2014: l_last_updated_by := to_number(fnd_global.USER_ID);
2015: l_last_update_login := to_number(fnd_global.LOGIN_ID);
2016: l_created_by := to_number(fnd_global.user_id);
2017:
2018:

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

2011: -- Sequence Number for the New Revision.
2012:
2013:
2014: l_last_updated_by := to_number(fnd_global.USER_ID);
2015: l_last_update_login := to_number(fnd_global.LOGIN_ID);
2016: l_created_by := to_number(fnd_global.user_id);
2017:
2018:
2019: Select AHL_ITEM_COMPOSITIONS_S.NEXTVAL

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

2012:
2013:
2014: l_last_updated_by := to_number(fnd_global.USER_ID);
2015: l_last_update_login := to_number(fnd_global.LOGIN_ID);
2016: l_created_by := to_number(fnd_global.user_id);
2017:
2018:
2019: Select AHL_ITEM_COMPOSITIONS_S.NEXTVAL
2020: INTO l_item_composition_id

Line 2175: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),

2171:
2172: UPDATE ahl_item_compositions
2173: SET DRAFT_FLAG = 'Y',
2174: LAST_UPDATE_DATE = sysdate,
2175: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
2176: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID),
2177: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
2178: SECURITY_GROUP_ID =NULL
2179: WHERE item_composition_id = p_Item_comp_id

Line 2176: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID),

2172: UPDATE ahl_item_compositions
2173: SET DRAFT_FLAG = 'Y',
2174: LAST_UPDATE_DATE = sysdate,
2175: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
2176: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID),
2177: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
2178: SECURITY_GROUP_ID =NULL
2179: WHERE item_composition_id = p_Item_comp_id
2180: AND object_version_number = p_object_version_number;

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

2444: update ahl_item_comp_details set
2445: uom_code =l_uom_code(I),
2446: quantity =l_quantity(I),
2447: last_update_date = sysdate,
2448: last_updated_by = to_number(fnd_global.user_id),
2449: last_update_login = to_number(fnd_global.login_id),
2450: object_version_number =l_object_version_number(I)+1
2451: where ITEM_COMP_DETAIL_ID = l_link_comp_detl_id(I)
2452: and item_composition_id = l_item_comp_det.LINK_COMP_ID

Line 2449: last_update_login = to_number(fnd_global.login_id),

2445: uom_code =l_uom_code(I),
2446: quantity =l_quantity(I),
2447: last_update_date = sysdate,
2448: last_updated_by = to_number(fnd_global.user_id),
2449: last_update_login = to_number(fnd_global.login_id),
2450: object_version_number =l_object_version_number(I)+1
2451: where ITEM_COMP_DETAIL_ID = l_link_comp_detl_id(I)
2452: and item_composition_id = l_item_comp_det.LINK_COMP_ID
2453: and NVL(item_group_id,-3) = NVL(l_item_group_id(I),-3)

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

2458:
2459: Update ahl_item_comp_details
2460: Set effective_end_date = sysdate-1,
2461: last_update_date =sysdate,
2462: last_updated_by = to_number(fnd_global.user_id),
2463: last_update_login = to_number(fnd_global.login_id),
2464: object_version_number =object_version_number+1
2465: Where item_composition_id=l_item_comp_det.link_comp_id
2466: and effective_end_date is null

Line 2463: last_update_login = to_number(fnd_global.login_id),

2459: Update ahl_item_comp_details
2460: Set effective_end_date = sysdate-1,
2461: last_update_date =sysdate,
2462: last_updated_by = to_number(fnd_global.user_id),
2463: last_update_login = to_number(fnd_global.login_id),
2464: object_version_number =object_version_number+1
2465: Where item_composition_id=l_item_comp_det.link_comp_id
2466: and effective_end_date is null
2467: and ITEM_COMP_DETAIL_ID not in (

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

2473:
2474: Update ahl_item_comp_details
2475: Set item_composition_id = l_item_comp_det.link_comp_id,
2476: last_update_date =sysdate,
2477: last_updated_by = to_number(fnd_global.user_id),
2478: last_update_login = to_number(fnd_global.login_id),
2479: object_version_number =object_version_number+1
2480: Where item_composition_id=l_item_comp_det.item_composition_id
2481: and link_comp_detl_id is null;

Line 2478: last_update_login = to_number(fnd_global.login_id),

2474: Update ahl_item_comp_details
2475: Set item_composition_id = l_item_comp_det.link_comp_id,
2476: last_update_date =sysdate,
2477: last_updated_by = to_number(fnd_global.user_id),
2478: last_update_login = to_number(fnd_global.login_id),
2479: object_version_number =object_version_number+1
2480: Where item_composition_id=l_item_comp_det.item_composition_id
2481: and link_comp_detl_id is null;
2482:

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

2482:
2483:
2484: Update ahl_item_compositions
2485: Set last_update_date =sysdate,
2486: last_updated_by = to_number(fnd_global.user_id),
2487: last_update_login = to_number(fnd_global.login_id),
2488: object_version_number =object_version_number+1
2489: Where item_composition_id=l_item_comp_det.link_comp_id;
2490:

Line 2487: last_update_login = to_number(fnd_global.login_id),

2483:
2484: Update ahl_item_compositions
2485: Set last_update_date =sysdate,
2486: last_updated_by = to_number(fnd_global.user_id),
2487: last_update_login = to_number(fnd_global.login_id),
2488: object_version_number =object_version_number+1
2489: Where item_composition_id=l_item_comp_det.link_comp_id;
2490:
2491: Delete from ahl_item_comp_details