APPS.AHL_LTP_REQST_MATRL_PVT dependencies on AHL_LTP_MTL_REQ_PVT

Line 448: l_prim_quantity := AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty

444:
445: END IF;
446:
447: -- yazhou 04Aug2005 Starts
448: l_prim_quantity := AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty
449: (l_inventory_item_id, l_uom_code, l_requested_quantity);
450:
451: -- Required to check the UOM Conversion exists in mtl_units_of_measure
452: IF l_prim_quantity IS NULL THEN

Line 1183: l_route_mtl_req_tbl AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;

1179: l_route_id NUMBER;
1180: l_instance_id NUMBER;
1181: l_requirement_date DATE;
1182: l_visit_tasks_rec Get_visit_tasks_cur%ROWTYPE;
1183: l_route_mtl_req_tbl AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;
1184:
1185: BEGIN
1186:
1187: IF (l_log_procedure >= l_log_current_level)THEN

Line 1305: 'Before calling ahl ltp mtl req pvt.Get Route Mtl Req'

1301: fnd_log.string
1302: (
1303: l_log_procedure,
1304: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1305: 'Before calling ahl ltp mtl req pvt.Get Route Mtl Req'
1306: );
1307:
1308: END IF;
1309:

Line 1310: AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req

1306: );
1307:
1308: END IF;
1309:
1310: AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req
1311: (p_api_version => l_api_version,
1312: p_init_msg_list => p_init_msg_list,
1313: p_validation_level => p_validation_level,
1314: x_return_status => l_return_status,

Line 1330: 'After calling ahl ltp mtl req pvt.Get Route Mtl Req, Return Status : '|| l_return_status

1326: fnd_log.string
1327: (
1328: l_log_procedure,
1329: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
1330: 'After calling ahl ltp mtl req pvt.Get Route Mtl Req, Return Status : '|| l_return_status
1331: );
1332: END IF;
1333: -- Check Error Message stack.
1334: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1571: l_route_mtl_req_tbl AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;

1567: --
1568: l_route_id NUMBER;
1569: l_instance_id NUMBER;
1570: l_visit_tasks_rec Get_visit_tasks_cur%ROWTYPE;
1571: l_route_mtl_req_tbl AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;
1572: l_Planned_Items_Rec Planned_Items_cur%ROWTYPE;
1573: l_requirement_date DATE;
1574:
1575: l_Visit_Task_Route_Tbl Visit_Task_Route_Tbl_Type;

Line 1725: 'Before calling ahl ltp mtl req pvt.Get Route Mtl Req'

1721: fnd_log.string
1722: (
1723: l_log_procedure,
1724: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1725: 'Before calling ahl ltp mtl req pvt.Get Route Mtl Req'
1726: );
1727:
1728: END IF;
1729:

Line 1731: AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req

1727:
1728: END IF;
1729:
1730: --Call to get items
1731: AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req
1732: (p_api_version => l_api_version,
1733: p_init_msg_list => p_init_msg_list,
1734: p_validation_level => p_validation_level,
1735: x_return_status => l_return_status,

Line 1750: 'After calling ahl ltp mtl req pvt.Get Route Mtl Req, Return Status : '|| l_return_status

1746: fnd_log.string
1747: (
1748: l_log_procedure,
1749: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
1750: 'After calling ahl ltp mtl req pvt.Get Route Mtl Req, Return Status : '|| l_return_status
1751: );
1752: END IF;
1753: -- Check Error Message stack.
1754: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN