APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_PRD_DISP_MTL_TXN_PVT

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

1851: FND_MSG_PUB.ADD;
1852: END IF;
1853: */
1854:
1855: l_assoc_quantity := AHL_PRD_DISP_MTL_TXN_PVT.Calculate_Txned_Qty(p_x_disposition_rec.disposition_id);
1856: IF (p_x_disposition_rec.quantity < l_assoc_quantity) THEN
1857: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_PRD_DIS_LESS_THAN_ASSC_QTY'); -- Quantity cannot be less then material transaction associated quantity
1858: FND_MESSAGE.Set_Token('QUANTITY', p_x_disposition_rec.quantity );
1859: FND_MESSAGE.Set_Token('ASSC_QTY', l_assoc_quantity );

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

4158: /*
4159: SELECT disp.status_code, disp.trackable_flag,
4160: pc.return_mtl_txn_id mtl_txn_id,
4161: pc.installed_part_change_id install_pc_id,
4162: AHL_PRD_DISP_MTL_TXN_PVT.calculate_txned_qty(disp.disposition_id) mtl_txn_qty
4163: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_PART_CHANGES_V pc
4164: WHERE disp.disposition_id = p_disposition_id
4165: AND disp.part_change_id = pc.part_change_id (+);
4166: */

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

4169: decode(disp.instance_id, null, decode(disp.path_position_id, null, 'N', 'Y'), 'Y') trackable_flag ,
4170: pc.return_mtl_txn_id mtl_txn_id,
4171: pc.installed_part_change_id install_pc_id,
4172: pc.part_change_type,
4173: AHL_PRD_DISP_MTL_TXN_PVT.calculate_txned_qty(disp.disposition_id) mtl_txn_qty
4174: FROM AHL_PRD_DISPOSITIONS_B disp,
4175: AHL_PART_CHANGES_V pc
4176: WHERE disp.disposition_id = p_disposition_id
4177: AND disp.part_change_id = pc.part_change_id (+);

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

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