APPS.JMF_SHIKYU_PO_PVT dependencies on JMF_SUBCONTRACT_ORDERS

Line 38: --| JMF_SUBCONTRACT_ORDERS table. |

34: --| handle changes of the need by date of |
35: --| the Subcontract PO, since Reconciliation|
36: --| conc prg would consider the old date if |
37: --| taking the need_by_date from the |
38: --| JMF_SUBCONTRACT_ORDERS table. |
39: --| 12/27/2005 vchu Added a COMMIT statement after calling |
40: --| FND_REQUEST.submit_request in the |
41: --| Process_Replenishment_PO procedure in |
42: --| order for the child request to start |

Line 135: l_subcontract_orders_rec JMF_SUBCONTRACT_ORDERS%ROWTYPE;

131: , x_po_line_location_id OUT NOCOPY NUMBER
132: , x_return_status OUT NOCOPY VARCHAR2
133: )
134: IS
135: l_subcontract_orders_rec JMF_SUBCONTRACT_ORDERS%ROWTYPE;
136: l_quantity NUMBER;
137: l_interface_header_id NUMBER;
138: l_interface_line_id NUMBER;
139: l_document_number NUMBER;

Line 170: FROM jmf_subcontract_orders

166: l_status_flag BOOLEAN;
167:
168: CURSOR c_rec IS
169: SELECT *
170: FROM jmf_subcontract_orders
171: WHERE subcontract_po_shipment_id = p_subcontract_po_shipment_id;
172:
173: -- Bug fix for 4997572
174: -- Changed the query to get the line_location_id of the Replenishment PO Shipment