APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on JAI_CMN_MATCH_RECEIPTS

Line 148: FROM JAI_CMN_MATCH_RECEIPTS

144: AND line_id= nvl(p_line_id, line_id);
145:
146: CURSOR c_qty_app_on_receipt( p_receipt_id IN NUMBER ) IS
147: SELECT SUM(receipt_quantity_applied)
148: FROM JAI_CMN_MATCH_RECEIPTS
149: WHERE receipt_id = p_receipt_id
150: AND ship_status IS NULL; -- cbabu for Bug# 2689425
151:
152: CURSOR c_qty_matched(p_delivery_detail_id IN NUMBER) IS

Line 154: FROM JAI_CMN_MATCH_RECEIPTS

150: AND ship_status IS NULL; -- cbabu for Bug# 2689425
151:
152: CURSOR c_qty_matched(p_delivery_detail_id IN NUMBER) IS
153: SELECT SUM(quantity_applied)
154: FROM JAI_CMN_MATCH_RECEIPTS
155: WHERE ref_line_id = p_delivery_detail_id
156: and order_invoice = 'O';
157:
158: -- this is commented in this cursor because, the subquery is taken care programmatically and if included in this cursor

Line 173: FROM JAI_CMN_MATCH_RECEIPTS

169:
170: v_exist NUMBER;
171: CURSOR c_duplicate_record(p_register_id IN NUMBER, p_delivery_detail_id IN NUMBER) IS
172: SELECT count(receipt_id)
173: FROM JAI_CMN_MATCH_RECEIPTS
174: WHERE receipt_id = p_register_id
175: AND ref_line_id = p_delivery_detail_id
176: AND order_invoice = 'O';
177:

Line 268: INSERT INTO JAI_CMN_MATCH_RECEIPTS (

264: Fetch c_duplicate_record Into v_exist;
265: Close c_duplicate_record;
266: --fnd_file.put_line(fnd_file.log, '2 v_QtyToMatch = '||v_QtyToMatch||', v_RctQtyAvailableInIssueUOM = '||v_RctQtyAvailableInIssueUOM);
267: IF NVL(v_exist,0) <> 1 Then
268: INSERT INTO JAI_CMN_MATCH_RECEIPTS (
269: receipt_id, ref_line_id,
270: subinventory, quantity_applied,
271: issue_uom, receipt_quantity_applied, receipt_quantity_uom,
272: order_invoice, ship_status,

Line 281: UPDATE JAI_CMN_MATCH_RECEIPTS

277: match_detail.requested_quantity_uom, v_QtyAppliedInRcptUom, rg23d_entry.primary_uom_code
278: , 'O', null,
279: sysdate, p_created_by, sysdate, p_last_update_login, p_created_by);
280: ELSE
281: UPDATE JAI_CMN_MATCH_RECEIPTS
282: SET quantity_applied = v_QtyApplied,
283: receipt_quantity_applied = v_QtyAppliedInRcptUom,
284: last_update_login = p_last_update_login,
285: last_update_date = sysdate