APPS.AHL_PRD_MTLTXN_PVT dependencies on AHL_PP_MATERIALS_PVT

Line 3296: Material_Tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type ;

3292: x_msg_count OUT NOCOPY NUMBER,
3293: x_msg_data OUT NOCOPY VARCHAR2,
3294: x_ahl_sch_mtl_id OUT NOCOPY NUMBER)
3295: IS
3296: Material_Tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type ;
3297: x_tmp VARCHAR2(10);
3298: l_project_id NUMBER;
3299: l_project_Task_id NUMBER ;
3300: l_Visit_Id NUMBER;

Line 3409: AHL_DEBUG_PUB.debug('Calling AHL_PP_MATERIALS_PVT.Create_Material_Reqst...');

3405: --Material_Tbl(0).Req_Material_Rec_Type :=
3406:
3407:
3408: IF G_DEBUG='Y' THEN
3409: AHL_DEBUG_PUB.debug('Calling AHL_PP_MATERIALS_PVT.Create_Material_Reqst...');
3410:
3411: END IF;
3412: AHL_PP_MATERIALS_PVT.Create_Material_Reqst(p_api_version => 1.0,
3413: p_x_req_material_tbl => Material_Tbl,

Line 3412: AHL_PP_MATERIALS_PVT.Create_Material_Reqst(p_api_version => 1.0,

3408: IF G_DEBUG='Y' THEN
3409: AHL_DEBUG_PUB.debug('Calling AHL_PP_MATERIALS_PVT.Create_Material_Reqst...');
3410:
3411: END IF;
3412: AHL_PP_MATERIALS_PVT.Create_Material_Reqst(p_api_version => 1.0,
3413: p_x_req_material_tbl => Material_Tbl,
3414: --p_interface_flag => 'N',
3415: p_interface_flag => NULL,
3416: x_job_return_status => x_tmp,

Line 3421: AHL_DEBUG_PUB.debug('after the call AHL_PP_MATERIALS_PVT.Create_Material_Reqst');

3417: x_return_status => x_return_status,
3418: x_msg_count => x_msg_count,
3419: x_msg_data => x_msg_data);
3420: IF G_DEBUG='Y' THEN
3421: AHL_DEBUG_PUB.debug('after the call AHL_PP_MATERIALS_PVT.Create_Material_Reqst');
3422:
3423: END IF;
3424: IF G_DEBUG='Y' THEN
3425: AHL_DEBUG_PUB.debug('x_return_status['||x_return_status||']');

Line 4653: AHL_PP_MATERIALS_PVT.GET_NET_QTY(TXNS.ORGANIZATION_ID, TXNS.INVENTORY_ITEM_ID,TXNS.WORKORDER_OPERATION_ID) Net_Total_Qty,

4649: MTL.DESCRIPTION,
4650: TXNS.SERIAL_NUMBER ,
4651: AHL_PRD_MTLTXN_PVT.GET_ISSUED_QTY(TXNS.ORGANIZATION_ID, TXNS.INVENTORY_ITEM_ID,TXNS.WORKORDER_OPERATION_ID) ISSUEQTY,
4652: -- JKJAIN FP ER # 6436303 - start
4653: AHL_PP_MATERIALS_PVT.GET_NET_QTY(TXNS.ORGANIZATION_ID, TXNS.INVENTORY_ITEM_ID,TXNS.WORKORDER_OPERATION_ID) Net_Total_Qty,
4654: -- JKJAIN FP ER # 6436303 - end
4655: TXNS.UOM,
4656: UOM.UNIT_OF_MEASURE,
4657: TXNS.RECEPIENT_ID,