APPS.AHL_PRD_WO_PUB dependencies on AHL_PP_MATERIALS_PVT

Line 468: nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0) issued_quantity,

464: CURSOR get_wo_mtl_reqmts_csr(p_WorkorderId IN NUMBER, p_WoOperationId IN NUMBER) IS
465: SELECT ASML.operation_sequence, MSIK.concatenated_segments part_number,MSIK.description Part_Desc, MSIK.primary_unit_of_measure part_uom ,
466: WIRO.REQUIRED_QUANTITY required_quantity , WIRO.DATE_REQUIRED required_date,
467: asml.scheduled_quantity schedule_quantity,asml.scheduled_date schedule_date,
468: nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0) issued_quantity,
469: AWOS.workorder_id,
470: asml.inventory_item_id,
471: ASML.organization_id,
472: ASML.scheduled_material_id

Line 1971: l_req_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;

1967: x_msg_count OUT NOCOPY NUMBER,
1968: x_msg_data OUT NOCOPY VARCHAR2
1969: ) IS
1970:
1971: l_req_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
1972: j INTEGER;
1973:
1974: BEGIN
1975: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2008: AHL_PP_MATERIALS_PVT.Process_Material_Request (

2004: j := j+1;
2005: END IF;
2006: END LOOP;
2007: IF(j > 1) THEN
2008: AHL_PP_MATERIALS_PVT.Process_Material_Request (
2009: p_api_version => 1.0 ,
2010: p_init_msg_list => FND_API.G_TRUE,
2011: p_commit => FND_API.G_FALSE,
2012: p_validation_level => fnd_api.g_valid_level_full,