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

464: Select AHL_ITEM_COMPOSITIONS_S.NEXTVAL
465: INTO l_item_composition_id
466: FROM DUAL;
467:
468: l_user_id := to_number(fnd_global.USER_ID);
469:
470: INSERT INTO AHL_ITEM_COMPOSITIONS(
471: ITEM_COMPOSITION_ID ,
472: INVENTORY_ITEM_ID ,

Line 515: to_number(fnd_global.LOGIN_ID) ,

511: sysdate,
512: l_user_id,
513: sysdate,
514: l_user_id ,
515: to_number(fnd_global.LOGIN_ID) ,
516: 1 ,
517: NULL,
518: p_x_ic_header_rec.ATTRIBUTE_CATEGORY,
519: p_x_ic_header_rec.ATTRIBUTE1,

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

776: UPDATE AHL_ITEM_COMPOSITIONS
777: SET
778: APPROVAL_STATUS_CODE = l_item_composition_rec.approval_status_code ,
779: LAST_UPDATE_DATE = sysdate,
780: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
781: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID) ,
782: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
783: SECURITY_GROUP_ID =NULL,
784: ATTRIBUTE_CATEGORY = p_x_ic_header_rec.ATTRIBUTE_CATEGORY,

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

777: SET
778: APPROVAL_STATUS_CODE = l_item_composition_rec.approval_status_code ,
779: LAST_UPDATE_DATE = sysdate,
780: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
781: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID) ,
782: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
783: SECURITY_GROUP_ID =NULL,
784: ATTRIBUTE_CATEGORY = p_x_ic_header_rec.ATTRIBUTE_CATEGORY,
785: ATTRIBUTE1 = p_x_ic_header_rec.ATTRIBUTE1,

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

1093:
1094: UPDATE AHL_ITEM_COMPOSITIONS
1095: SET
1096: LAST_UPDATE_DATE = sysdate,
1097: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
1098: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID) ,
1099: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
1100: SECURITY_GROUP_ID =NULL,
1101: EFFECTIVE_END_DATE = sysdate -1

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

1094: UPDATE AHL_ITEM_COMPOSITIONS
1095: SET
1096: LAST_UPDATE_DATE = sysdate,
1097: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
1098: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID) ,
1099: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
1100: SECURITY_GROUP_ID =NULL,
1101: EFFECTIVE_END_DATE = sysdate -1
1102: WHERE ITEM_COMPOSITION_ID = p_item_composition_ID

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

1334:
1335: UPDATE AHL_ITEM_COMPOSITIONS
1336: SET
1337: LAST_UPDATE_DATE = sysdate,
1338: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
1339: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID) ,
1340: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
1341: SECURITY_GROUP_ID =NULL,
1342: EFFECTIVE_END_DATE = null

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

1335: UPDATE AHL_ITEM_COMPOSITIONS
1336: SET
1337: LAST_UPDATE_DATE = sysdate,
1338: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
1339: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID) ,
1340: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
1341: SECURITY_GROUP_ID =NULL,
1342: EFFECTIVE_END_DATE = null
1343: WHERE ITEM_COMPOSITION_ID = p_item_composition_ID

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

1417: SELECT AHL_ITEM_COMP_DETAILS_S.NEXTVAL
1418: INTO l_item_comp_detail_id
1419: FROM DUAL;
1420:
1421: l_user_id := to_number(fnd_global.USER_ID);
1422:
1423: IF p_item_composition_id IS NOT NULL THEN
1424:
1425: INSERT INTO AHL_ITEM_COMP_DETAILS(

Line 1474: to_number(fnd_global.LOGIN_ID),

1470: sysdate,
1471: l_user_id ,
1472: sysdate,
1473: l_user_id,
1474: to_number(fnd_global.LOGIN_ID),
1475: 1,
1476: NULL,
1477: p_x_comp_det_rec.ATTRIBUTE_CATEGORY ,
1478: p_x_comp_det_rec.ATTRIBUTE1 ,

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

1520: INVENTORY_MASTER_ORG_ID = p_x_comp_det_rec.INVENTORY_MASTER_ORG_ID,
1521: UOM_CODE =p_x_comp_det_rec.UOM_CODE ,
1522: QUANTITY =p_x_comp_det_rec.QUANTITY,
1523: LAST_UPDATE_DATE =sysdate,
1524: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
1525: LAST_UPDATE_LOGIN = to_number(fnd_global.LOGIN_ID),
1526: OBJECT_VERSION_NUMBER =object_version_number+1,
1527: SECURITY_GROUP_ID =NULL,
1528: ATTRIBUTE_CATEGORY =p_x_comp_det_rec.ATTRIBUTE_CATEGORY,

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

1521: UOM_CODE =p_x_comp_det_rec.UOM_CODE ,
1522: QUANTITY =p_x_comp_det_rec.QUANTITY,
1523: LAST_UPDATE_DATE =sysdate,
1524: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
1525: LAST_UPDATE_LOGIN = to_number(fnd_global.LOGIN_ID),
1526: OBJECT_VERSION_NUMBER =object_version_number+1,
1527: SECURITY_GROUP_ID =NULL,
1528: ATTRIBUTE_CATEGORY =p_x_comp_det_rec.ATTRIBUTE_CATEGORY,
1529: ATTRIBUTE1 =p_x_comp_det_rec.ATTRIBUTE1,

Line 1785: P_REQUESTER_USERID =>fnd_global.user_id,

1781: P_OBJECT_VERSION_NUMBER =>l_object_version_number+1,
1782: P_ORIG_STATUS_CODE =>'ACTIVE',
1783: P_NEW_STATUS_CODE =>'APPROVED',
1784: P_REJECT_STATUS_CODE =>'REJECTED',
1785: P_REQUESTER_USERID =>fnd_global.user_id,
1786: P_NOTES_FROM_REQUESTER =>NULL,
1787: P_WORKFLOWPROCESS =>'AHL_GEN_APPROVAL',
1788: P_ITEM_TYPE =>'AHLGAPP');
1789: ELSE

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

2026:
2027: -- Sequence Number for the New Revision.
2028:
2029:
2030: l_last_updated_by := to_number(fnd_global.USER_ID);
2031: l_last_update_login := to_number(fnd_global.LOGIN_ID);
2032: l_created_by := to_number(fnd_global.user_id);
2033:
2034:

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

2027: -- Sequence Number for the New Revision.
2028:
2029:
2030: l_last_updated_by := to_number(fnd_global.USER_ID);
2031: l_last_update_login := to_number(fnd_global.LOGIN_ID);
2032: l_created_by := to_number(fnd_global.user_id);
2033:
2034:
2035: Select AHL_ITEM_COMPOSITIONS_S.NEXTVAL

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

2028:
2029:
2030: l_last_updated_by := to_number(fnd_global.USER_ID);
2031: l_last_update_login := to_number(fnd_global.LOGIN_ID);
2032: l_created_by := to_number(fnd_global.user_id);
2033:
2034:
2035: Select AHL_ITEM_COMPOSITIONS_S.NEXTVAL
2036: INTO l_item_composition_id

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

2187:
2188: UPDATE ahl_item_compositions
2189: SET DRAFT_FLAG = 'Y',
2190: LAST_UPDATE_DATE = sysdate,
2191: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
2192: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID),
2193: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
2194: SECURITY_GROUP_ID =NULL
2195: WHERE item_composition_id = p_Item_comp_id

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

2188: UPDATE ahl_item_compositions
2189: SET DRAFT_FLAG = 'Y',
2190: LAST_UPDATE_DATE = sysdate,
2191: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
2192: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID),
2193: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
2194: SECURITY_GROUP_ID =NULL
2195: WHERE item_composition_id = p_Item_comp_id
2196: AND object_version_number = p_object_version_number;

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

2539: update ahl_item_comp_details set
2540: uom_code =l_uom_code(I),
2541: quantity =l_quantity(I),
2542: last_update_date = sysdate,
2543: last_updated_by = to_number(fnd_global.user_id),
2544: last_update_login = to_number(fnd_global.login_id),
2545: object_version_number =l_object_version_number(I)+1 ,
2546: -- manisaga added attributes for DFF implementation on 22-Feb-2010 -- Start
2547: attribute_category = l_attribute_category(I),

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

2540: uom_code =l_uom_code(I),
2541: quantity =l_quantity(I),
2542: last_update_date = sysdate,
2543: last_updated_by = to_number(fnd_global.user_id),
2544: last_update_login = to_number(fnd_global.login_id),
2545: object_version_number =l_object_version_number(I)+1 ,
2546: -- manisaga added attributes for DFF implementation on 22-Feb-2010 -- Start
2547: attribute_category = l_attribute_category(I),
2548: attribute1 = l_attribute1(I),

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

2572:
2573: Update ahl_item_comp_details
2574: Set effective_end_date = sysdate-1,
2575: last_update_date =sysdate,
2576: last_updated_by = to_number(fnd_global.user_id),
2577: last_update_login = to_number(fnd_global.login_id),
2578: object_version_number =object_version_number+1
2579: Where item_composition_id=l_item_comp_det.link_comp_id
2580: and effective_end_date is null

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

2573: Update ahl_item_comp_details
2574: Set effective_end_date = sysdate-1,
2575: last_update_date =sysdate,
2576: last_updated_by = to_number(fnd_global.user_id),
2577: last_update_login = to_number(fnd_global.login_id),
2578: object_version_number =object_version_number+1
2579: Where item_composition_id=l_item_comp_det.link_comp_id
2580: and effective_end_date is null
2581: and ITEM_COMP_DETAIL_ID not in (

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

2587:
2588: Update ahl_item_comp_details
2589: Set item_composition_id = l_item_comp_det.link_comp_id,
2590: last_update_date =sysdate,
2591: last_updated_by = to_number(fnd_global.user_id),
2592: last_update_login = to_number(fnd_global.login_id),
2593: object_version_number =object_version_number+1
2594: Where item_composition_id=l_item_comp_det.item_composition_id
2595: and link_comp_detl_id is null;

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

2588: Update ahl_item_comp_details
2589: Set item_composition_id = l_item_comp_det.link_comp_id,
2590: last_update_date =sysdate,
2591: last_updated_by = to_number(fnd_global.user_id),
2592: last_update_login = to_number(fnd_global.login_id),
2593: object_version_number =object_version_number+1
2594: Where item_composition_id=l_item_comp_det.item_composition_id
2595: and link_comp_detl_id is null;
2596:

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

2596:
2597:
2598: Update ahl_item_compositions
2599: Set last_update_date =sysdate,
2600: last_updated_by = to_number(fnd_global.user_id),
2601: last_update_login = to_number(fnd_global.login_id),
2602: object_version_number =object_version_number+1 ,
2603: -- manisaga added attributes for DFF implementation on 22-Feb-2010 -- Start
2604: attribute_category = l_item_comp_det.attribute_category,

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

2597:
2598: Update ahl_item_compositions
2599: Set last_update_date =sysdate,
2600: last_updated_by = to_number(fnd_global.user_id),
2601: last_update_login = to_number(fnd_global.login_id),
2602: object_version_number =object_version_number+1 ,
2603: -- manisaga added attributes for DFF implementation on 22-Feb-2010 -- Start
2604: attribute_category = l_item_comp_det.attribute_category,
2605: attribute1 = l_item_comp_det.attribute1,