APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_PRD_DISP_MTL_TXN_PVT

Line 2043: l_assoc_quantity := AHL_PRD_DISP_MTL_TXN_PVT.Calculate_Txned_Qty(p_x_disposition_rec.disposition_id);

2039: FND_MSG_PUB.ADD;
2040: END IF;
2041: */
2042:
2043: l_assoc_quantity := AHL_PRD_DISP_MTL_TXN_PVT.Calculate_Txned_Qty(p_x_disposition_rec.disposition_id);
2044: IF (p_x_disposition_rec.quantity < l_assoc_quantity) THEN
2045: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_PRD_DIS_LESS_THAN_ASSC_QTY'); -- Quantity cannot be less then material transaction associated quantity
2046: FND_MESSAGE.Set_Token('QUANTITY', p_x_disposition_rec.quantity );
2047: FND_MESSAGE.Set_Token('ASSC_QTY', l_assoc_quantity );

Line 4622: AHL_PRD_DISP_MTL_TXN_PVT.calculate_txned_qty(disp.disposition_id) mtl_txn_qty

4618: /*
4619: SELECT disp.status_code, disp.trackable_flag,
4620: pc.return_mtl_txn_id mtl_txn_id,
4621: pc.installed_part_change_id install_pc_id,
4622: AHL_PRD_DISP_MTL_TXN_PVT.calculate_txned_qty(disp.disposition_id) mtl_txn_qty
4623: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_PART_CHANGES_V pc
4624: WHERE disp.disposition_id = p_disposition_id
4625: AND disp.part_change_id = pc.part_change_id (+);
4626: */

Line 4633: AHL_PRD_DISP_MTL_TXN_PVT.calculate_txned_qty(disp.disposition_id) mtl_txn_qty

4629: decode(disp.instance_id, null, decode(disp.path_position_id, null, 'N', 'Y'), 'Y') trackable_flag ,
4630: pc.return_mtl_txn_id mtl_txn_id,
4631: pc.installed_part_change_id install_pc_id,
4632: pc.part_change_type,
4633: AHL_PRD_DISP_MTL_TXN_PVT.calculate_txned_qty(disp.disposition_id) mtl_txn_qty
4634: FROM AHL_PRD_DISPOSITIONS_B disp,
4635: AHL_PART_CHANGES_V pc
4636: WHERE disp.disposition_id = p_disposition_id
4637: AND disp.part_change_id = pc.part_change_id (+);

Line 5165: -- update_disposition is called by AHL_PRD_DISP_MTL_TXN_PVT.Process_Disp_Mtl_Txn

5161: FETCH workorder_status_csr INTO l_status_code;
5162: CLOSE workorder_status_csr;
5163: -- Change made by jaramana on August 8, 2007 for bug 6326065 (FP of 6061600)
5164: -- Need to allow Disp Txn association for Complete workorders (code 4)
5165: -- update_disposition is called by AHL_PRD_DISP_MTL_TXN_PVT.Process_Disp_Mtl_Txn
5166: -- when the Transaction Qty is updated. So allow the Complete status as updateable.
5167: -- But note that from the Disposition UI, it will still not be possible to create or
5168: -- update the Disposition when the work order is in status Complete
5169: -- IF (l_status_code IN ('12', '4', '5', '7'))THEN --CLOSED, COMPLETE, COMPLETE NO CHARGE, CANCELLED