[Home] [Help]
867: CURSOR c_base_trx(cp_transaction_id IN NUMBER) IS
868: SELECT shipment_header_id, shipment_line_id, transaction_type, organization_id, location_id,
869: quantity, unit_of_measure, subinventory, vendor_id, vendor_site_id,
870: source_document_code, po_header_id, po_line_id, po_line_location_id, po_release_id
871: FROM rcv_transactions
872: WHERE transaction_id = cp_transaction_id;
873:
874: r_base_trx c_base_trx%ROWTYPE;
875:
1242: p_shipment_line_id NUMBER,
1243: p_to_organization_id NUMBER,
1244: p_ship_to_location_id NUMBER,
1245: p_item_id NUMBER,
1246: p_tran_type RCV_TRANSACTIONS.transaction_type%TYPE,
1247: p_rcv_tran_qty RCV_TRANSACTIONS.quantity%TYPE,
1248: p_new_primary_unit_of_measure RCV_SHIPMENT_LINES.primary_unit_of_measure%TYPE,
1249: p_old_primary_unit_of_measure RCV_SHIPMENT_LINES.primary_unit_of_measure%TYPE,
1250: p_unit_of_measure RCV_SHIPMENT_LINES.unit_of_measure%TYPE,
1243: p_to_organization_id NUMBER,
1244: p_ship_to_location_id NUMBER,
1245: p_item_id NUMBER,
1246: p_tran_type RCV_TRANSACTIONS.transaction_type%TYPE,
1247: p_rcv_tran_qty RCV_TRANSACTIONS.quantity%TYPE,
1248: p_new_primary_unit_of_measure RCV_SHIPMENT_LINES.primary_unit_of_measure%TYPE,
1249: p_old_primary_unit_of_measure RCV_SHIPMENT_LINES.primary_unit_of_measure%TYPE,
1250: p_unit_of_measure RCV_SHIPMENT_LINES.unit_of_measure%TYPE,
1251: p_po_header_id NUMBER,
1304: AND location_id = p_ship_to_location_id
1305: -- AND (source = 'PURCHASE ORDER' OR source = 'PO RELEASE' OR source = 'RETURN TO VENDOR')
1306: AND NVL(primary_flag,'N') = 'Y'; --added on 06-jan-2000 gaurav.
1307:
1308: --**********FETCHING VALUES FROM RCV_TRANSACTIONS**********
1309: CURSOR c_get_rcv_trans IS
1310: SELECT wip_entity_id
1311: FROM po_distributions_all
1312: WHERE line_location_id = p_po_line_location_id
1968:
1969: v_bal_qty := v_comp_balance_qty;
1970: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','21.4 v_received_qty ' ||v_received_qty||' v_bal_qty : '||v_bal_qty);
1971:
1972: IF v_match_type = 1 THEN -- this handles +ve quantity RECEIVE / CORRECTed through RCV_TRANSACTIONS base form
1973:
1974: IF v_bal_qty >= v_received_qty THEN
1975: --temp qty which is assigned to return qty value is assigned with the return qty value after converion to return qty uom
1976: v_temp_qty := v_received_qty * v_comp_qty_pa;
1990:
1991: END IF;
1992:
1993: -- 2746952
1994: -- this handles -ve quantity CORRECTed through RCV_TRANSACTIONS base form
1995: ELSIF v_match_type = -1 THEN
1996:
1997: -- v_bal_qty is +ve and v_received_qty is -ve if code enters this path
1998: -- v_bal_qty is assigned with return_qty in this case