[Home] [Help]
23: 6. 09-Jul-2009 mbremkum 8660365 Appropriation factor was calculated using quantity from Base
24: Project Line. In R12 Projects populates amounts into Quantity.
25: Hence replaced it with the Delivered Quantity.
26:
27: 7. 15-Apr-2010 Bo Li 9305067 Replace the old attribute_category columns for JAI_RCV_TRANSACTIONS
28: with new meaningful one
29:
30: 8. 06-Jul-2010 Jia 7242428 Forward ported to R12.2 from R11i bug#7145704
31: Added the function get_comtmnt_amt
130: r_get_po_line_loc_dtl c_get_po_line_loc_dtl%rowtype;
131:
132: cursor c_ja_in_rcv_trx(cp_transaction_id in number) is
133: select *
134: from JAI_RCV_TRANSACTIONS
135: where transaction_id = cp_transaction_id;
136: r_ja_in_receive_trx c_ja_in_rcv_trx%rowtype;
137: r_ja_in_deliver_trx c_ja_in_rcv_trx%rowtype;
138:
879: and a.transaction_id = cp_tax_transaction_id;
880:
881: cursor c_ja_in_rcv_trx(cp_transaction_id in number) is
882: select *
883: from jai_rcv_transactions
884: where transaction_id = cp_transaction_id;
885: r_ja_in_receive_trx c_ja_in_rcv_trx%rowtype;
886: r_ja_in_deliver_trx c_ja_in_rcv_trx%rowtype;
887: ln_apportion_factor number;
957: , pv_line_type => JAI_PA_COSTING_PKG.GV_LINE_TYPE_PO_RECEIPT
958: , pn_transaction_header_id => null -- ''
959: , pn_transaction_dist_id => r_po_rcpt.cdl_system_reference4 --> rcv_transaction_id
960: , pv_currency_of_return_tax_amt => JAI_PA_COSTING_PKG.gv_functional_currency
961: , pv_transaction_uom => r_po_rcpt.unit_of_measure -- this value is not being populated by costing. so we need to fetch from JAI_RCV_TRANSACTIONS
962: , pn_transaction_qty => r_po_rcpt.quantity
963: , pn_currency_conv_rate => r_po_rcpt.receipt_exchange_rate
964: );
965:
1804: SELECT a.transaction_id,
1805: a.shipment_header_id,
1806: a.quantity,
1807: b.currency_conversion_rate
1808: FROM jai_rcv_transactions a, rcv_transactions b
1809: WHERE b.po_distribution_id = cp_po_distribution_id
1810: AND ((b.destination_type_code = 'EXPENSE' ) OR
1811: (b.destination_type_code = 'RECEIVING' AND
1812: b.transaction_type in ('RETURN TO RECEIVING' , 'RETURN TO VENDOR')))
1884: ln_apportioned_func_tax_amt NUMBER;
1885: ln_apportioned_trx_tax_amt NUMBER;
1886: ln_trx_tax_amount NUMBER;
1887: ln_func_tax_amount NUMBER;
1888: rec_get_deliver_trx jai_rcv_transactions%rowtype;
1889: lv_cenvat_rg_flag VARCHAR2(1);
1890: lv_cenvat_rg_message jai_rcv_transactions.cenvat_rg_message%TYPE;
1891:
1892: CURSOR Rcv_Receipts_Cur (cp_transaction_id IN rcv_transactions.transaction_id%TYPE)
1886: ln_trx_tax_amount NUMBER;
1887: ln_func_tax_amount NUMBER;
1888: rec_get_deliver_trx jai_rcv_transactions%rowtype;
1889: lv_cenvat_rg_flag VARCHAR2(1);
1890: lv_cenvat_rg_message jai_rcv_transactions.cenvat_rg_message%TYPE;
1891:
1892: CURSOR Rcv_Receipts_Cur (cp_transaction_id IN rcv_transactions.transaction_id%TYPE)
1893: IS
1894: SELECT rcv_txn.transaction_id rcv_transaction_id,
1989:
1990: CURSOR cur_get_deliver_trx (cp_transaction_id IN rcv_transactions.transaction_id%TYPE)
1991: IS
1992: SELECT *
1993: FROM jai_rcv_transactions
1994: WHERE transaction_type = 'DELIVER'
1995: AND parent_transaction_id = cp_transaction_id;
1996:
1997: CURSOR cur_get_process_flag (cp_transaction_id IN rcv_transactions.transaction_id%TYPE)
2002:
2003: CURSOR cur_get_cenvat_dtls (cp_transaction_id IN rcv_transactions.transaction_id%TYPE)
2004: IS
2005: SELECT cenvat_rg_status, cenvat_rg_message
2006: FROM jai_rcv_transactions
2007: WHERE transaction_id = cp_transaction_id;
2008:
2009: -- Added by Jia for FP Bug#9863751, Begin
2010: ---------------------------------------------------------------------------