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_PRD_WORKORDER_PVT dependencies on AHL_LTP_MTL_REQ_PVT

Line 2887: --l_pos_mtl_req_rec AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Rec_Type;

2883: --Local variable declaration added for SB related changes.
2884: l_uc_header_id NUMBER;
2885: l_mc_header_id NUMBER;
2886: l_visit_id NUMBER;
2887: --l_pos_mtl_req_rec AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Rec_Type;
2888: l_msg_count NUMBER;
2889: l_msg_data VARCHAR2(2000);
2890: l_return_status VARCHAR2(1);
2891: --sukhwsin::SB - Control position changes - starts

Line 2892: l_pos_mtl_req_tbl AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;

2888: l_msg_count NUMBER;
2889: l_msg_data VARCHAR2(2000);
2890: l_return_status VARCHAR2(1);
2891: --sukhwsin::SB - Control position changes - starts
2892: l_pos_mtl_req_tbl AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;
2893: l_dummy_index NUMBER := 0;
2894: --sukhwsin::SB - Control position changes - ends
2895: --sukhwsin::SB Effectivity Code changes - ends
2896:

Line 2970: AHL_LTP_MTL_REQ_PVT.Get_Material_Req_For_Pos (

2966: --Populate l_pos_mtl_req_tbl table with position detail.
2967: l_pos_mtl_req_tbl(0).inventory_item_id := null;
2968: l_pos_mtl_req_tbl(0).mc_header_id := l_mc_header_id;
2969: l_pos_mtl_req_tbl(0).position_key := l_material_req_rec.position_key;
2970: AHL_LTP_MTL_REQ_PVT.Get_Material_Req_For_Pos (
2971: p_api_version => 1.0,
2972: p_init_msg_list => FND_API.G_FALSE,
2973: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2974: x_return_status => l_return_status,

Line 5441: l_prim_uom_code := AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(l_material_tbl(k).inventory_item_id, l_material_tbl(k).organization_id);

5437: For position based requirements uom conversion is already done in Get_Material_Req_For_Pos procedure call.
5438: */
5439: l_prim_quantity := null;
5440: l_prim_uom_code := null;
5441: l_prim_uom_code := AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(l_material_tbl(k).inventory_item_id, l_material_tbl(k).organization_id);
5442: l_prim_quantity := AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(l_material_tbl(k).inventory_item_id, l_material_tbl(k).uom_code, l_material_tbl(k).requested_quantity);
5443: -- Required to check the UOM Conversion exists in mtl_units_of_measure
5444: IF l_prim_quantity IS NULL THEN
5445: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_UOM_CONV_NOT_EXIST' );

Line 5442: l_prim_quantity := AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(l_material_tbl(k).inventory_item_id, l_material_tbl(k).uom_code, l_material_tbl(k).requested_quantity);

5438: */
5439: l_prim_quantity := null;
5440: l_prim_uom_code := null;
5441: l_prim_uom_code := AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(l_material_tbl(k).inventory_item_id, l_material_tbl(k).organization_id);
5442: l_prim_quantity := AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(l_material_tbl(k).inventory_item_id, l_material_tbl(k).uom_code, l_material_tbl(k).requested_quantity);
5443: -- Required to check the UOM Conversion exists in mtl_units_of_measure
5444: IF l_prim_quantity IS NULL THEN
5445: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_UOM_CONV_NOT_EXIST' );
5446: FND_MESSAGE.Set_Token('FUOM', l_material_tbl(k).uom_code);