eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_PA_COSTING_PKG dependencies on JAI_PA_COSTING_PKG

Line 1: package body jai_pa_costing_pkg as

1: package body jai_pa_costing_pkg as
2: /* $Header: jai_pa_costing.plb 120.11.12020000.2 2012/07/14 09:54:19 nkodakan ship $*/
3: /*------------------------------------------------------------------------------------------------------------
4: CHANGE HISTORY
5: ------------------------------------------------------------------------------------------------------------

Line 47: lv_object_name jai_cmn_debug_contexts.log_context%type := 'JAI_PA_COSTING_PKG';

43: --------------------------------------------------------------------------------------------------------------*/
44: /*----------------------------------------- PRIVATE MEMBERS DECLRATION -------------------------------------*/
45:
46: /** Package level variables used in debug package*/
47: lv_object_name jai_cmn_debug_contexts.log_context%type := 'JAI_PA_COSTING_PKG';
48: lv_member_name jai_cmn_debug_contexts.log_context%type;
49: lv_context jai_cmn_debug_contexts.log_context%type;
50: --
51: -- Global variables used throught the package

Line 192: if pv_transaction_source = JAI_PA_COSTING_PKG.gv_src_oracle_purchasing then

188: /* this should consider currency, recoverable percentage and apportion factor when calculating the tax */
189:
190: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'pv_line_type='||pv_line_type || ', pv_transaction_source='||pv_transaction_source);
191:
192: if pv_transaction_source = JAI_PA_COSTING_PKG.gv_src_oracle_purchasing then
193:
194: /* 1 - REQUISITONS */
195: if pv_line_type = JAI_PA_COSTING_PKG.gv_line_type_requisition then
196:

Line 195: if pv_line_type = JAI_PA_COSTING_PKG.gv_line_type_requisition then

191:
192: if pv_transaction_source = JAI_PA_COSTING_PKG.gv_src_oracle_purchasing then
193:
194: /* 1 - REQUISITONS */
195: if pv_line_type = JAI_PA_COSTING_PKG.gv_line_type_requisition then
196:
197: open c_get_reqn_dist_dtl(pn_transaction_dist_id);
198: fetch c_get_reqn_dist_dtl into r_get_reqn_dist_dtl;
199: close c_get_reqn_dist_dtl;

Line 283: elsif pv_line_type = JAI_PA_COSTING_PKG.gv_line_type_purchasing then

279: ln_trx_inclu_reco_tax_amt := ln_trx_inclu_reco_tax_amt * ln_apportion_factor; -- Added by Jia Li for Tax inclusive Computations on 2007/11/27
280:
281:
282: /* 2 - PURCHASE ORDERS */
283: elsif pv_line_type = JAI_PA_COSTING_PKG.gv_line_type_purchasing then
284:
285: open c_get_po_dist_dtl(pn_transaction_dist_id);
286: fetch c_get_po_dist_dtl into r_get_po_dist_dtl;
287: close c_get_po_dist_dtl;

Line 370: elsif pv_line_type = JAI_PA_COSTING_PKG.gv_line_type_po_receipt then

366: ln_func_inclu_reco_tax_amt := ln_func_inclu_reco_tax_amt * ln_apportion_factor; -- Added by Jia Li for Tax inclusive Computations on 2007/11/27
367: ln_trx_inclu_reco_tax_amt := ln_trx_inclu_reco_tax_amt * ln_apportion_factor; -- Added by Jia Li for Tax inclusive Computations on 2007/11/27
368:
369: /* 3 - PURCHASE RECEIPTS */
370: elsif pv_line_type = JAI_PA_COSTING_PKG.gv_line_type_po_receipt then
371:
372:
373: open c_ja_in_rcv_trx(pn_transaction_dist_id);
374: fetch c_ja_in_rcv_trx into r_ja_in_deliver_trx;

Line 548: elsif pv_transaction_source = JAI_PA_COSTING_PKG.gv_src_oracle_payables

544:
545: end if;
546:
547: /* 4 - PAYABLE INVOICES */
548: elsif pv_transaction_source = JAI_PA_COSTING_PKG.gv_src_oracle_payables
549: and pv_line_type = JAI_PA_COSTING_PKG.gv_line_type_invoice
550: then
551:
552: select

Line 549: and pv_line_type = JAI_PA_COSTING_PKG.gv_line_type_invoice

545: end if;
546:
547: /* 4 - PAYABLE INVOICES */
548: elsif pv_transaction_source = JAI_PA_COSTING_PKG.gv_src_oracle_payables
549: and pv_line_type = JAI_PA_COSTING_PKG.gv_line_type_invoice
550: then
551:
552: select
553: nvl(sum(a.base_amount),0) functional_tax_amount,

Line 604: or pv_currency_of_return_tax_amt = JAI_PA_COSTING_PKG.gv_transaction_currency

600:
601: <>
602:
603: if pv_currency_of_return_tax_amt is null
604: or pv_currency_of_return_tax_amt = JAI_PA_COSTING_PKG.gv_transaction_currency
605: then
606: return (ln_trx_nonreco_tax_amt);
607: else
608: return (ln_func_nonreco_tax_amt);

Line 944: ln_apportioned_txn_tax_amt := JAI_PA_COSTING_PKG.get_nonrec_tax_amount

940: 'r_po_rcpt.unit_of_measure='||r_po_rcpt.unit_of_measure|| fnd_global.local_chr(10) ||
941: 'r_po_rcpt.quantity='||r_po_rcpt.quantity || fnd_global.local_chr(10) ||
942: 'r_po_rcpt.txn_interface_id='||r_po_rcpt.txn_interface_id
943: );
944: ln_apportioned_txn_tax_amt := JAI_PA_COSTING_PKG.get_nonrec_tax_amount
945: ( pv_transaction_source => JAI_PA_COSTING_PKG.GV_SRC_ORACLE_PURCHASING
946: , pv_line_type => JAI_PA_COSTING_PKG.GV_LINE_TYPE_PO_RECEIPT
947: , pn_transaction_header_id => null -- ''
948: , pn_transaction_dist_id => r_po_rcpt.cdl_system_reference4 --> rcv_transaction_id

Line 945: ( pv_transaction_source => JAI_PA_COSTING_PKG.GV_SRC_ORACLE_PURCHASING

941: 'r_po_rcpt.quantity='||r_po_rcpt.quantity || fnd_global.local_chr(10) ||
942: 'r_po_rcpt.txn_interface_id='||r_po_rcpt.txn_interface_id
943: );
944: ln_apportioned_txn_tax_amt := JAI_PA_COSTING_PKG.get_nonrec_tax_amount
945: ( pv_transaction_source => JAI_PA_COSTING_PKG.GV_SRC_ORACLE_PURCHASING
946: , pv_line_type => JAI_PA_COSTING_PKG.GV_LINE_TYPE_PO_RECEIPT
947: , pn_transaction_header_id => null -- ''
948: , pn_transaction_dist_id => r_po_rcpt.cdl_system_reference4 --> rcv_transaction_id
949: , pv_currency_of_return_tax_amt => JAI_PA_COSTING_PKG.gv_transaction_currency

Line 946: , pv_line_type => JAI_PA_COSTING_PKG.GV_LINE_TYPE_PO_RECEIPT

942: 'r_po_rcpt.txn_interface_id='||r_po_rcpt.txn_interface_id
943: );
944: ln_apportioned_txn_tax_amt := JAI_PA_COSTING_PKG.get_nonrec_tax_amount
945: ( pv_transaction_source => JAI_PA_COSTING_PKG.GV_SRC_ORACLE_PURCHASING
946: , pv_line_type => JAI_PA_COSTING_PKG.GV_LINE_TYPE_PO_RECEIPT
947: , pn_transaction_header_id => null -- ''
948: , pn_transaction_dist_id => r_po_rcpt.cdl_system_reference4 --> rcv_transaction_id
949: , pv_currency_of_return_tax_amt => JAI_PA_COSTING_PKG.gv_transaction_currency
950: , pv_transaction_uom => r_po_rcpt.unit_of_measure

Line 949: , pv_currency_of_return_tax_amt => JAI_PA_COSTING_PKG.gv_transaction_currency

945: ( pv_transaction_source => JAI_PA_COSTING_PKG.GV_SRC_ORACLE_PURCHASING
946: , pv_line_type => JAI_PA_COSTING_PKG.GV_LINE_TYPE_PO_RECEIPT
947: , pn_transaction_header_id => null -- ''
948: , pn_transaction_dist_id => r_po_rcpt.cdl_system_reference4 --> rcv_transaction_id
949: , pv_currency_of_return_tax_amt => JAI_PA_COSTING_PKG.gv_transaction_currency
950: , pv_transaction_uom => r_po_rcpt.unit_of_measure
951: , pn_transaction_qty => r_po_rcpt.quantity
952: , pn_currency_conv_rate => r_po_rcpt.receipt_exchange_rate
953: );

Line 955: ln_apportioned_func_tax_amt := JAI_PA_COSTING_PKG.get_nonrec_tax_amount

951: , pn_transaction_qty => r_po_rcpt.quantity
952: , pn_currency_conv_rate => r_po_rcpt.receipt_exchange_rate
953: );
954:
955: ln_apportioned_func_tax_amt := JAI_PA_COSTING_PKG.get_nonrec_tax_amount
956: ( pv_transaction_source => JAI_PA_COSTING_PKG.GV_SRC_ORACLE_PURCHASING
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

Line 956: ( pv_transaction_source => JAI_PA_COSTING_PKG.GV_SRC_ORACLE_PURCHASING

952: , pn_currency_conv_rate => r_po_rcpt.receipt_exchange_rate
953: );
954:
955: ln_apportioned_func_tax_amt := JAI_PA_COSTING_PKG.get_nonrec_tax_amount
956: ( pv_transaction_source => JAI_PA_COSTING_PKG.GV_SRC_ORACLE_PURCHASING
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

Line 957: , pv_line_type => JAI_PA_COSTING_PKG.GV_LINE_TYPE_PO_RECEIPT

953: );
954:
955: ln_apportioned_func_tax_amt := JAI_PA_COSTING_PKG.get_nonrec_tax_amount
956: ( pv_transaction_source => JAI_PA_COSTING_PKG.GV_SRC_ORACLE_PURCHASING
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

Line 960: , pv_currency_of_return_tax_amt => JAI_PA_COSTING_PKG.gv_functional_currency

956: ( pv_transaction_source => JAI_PA_COSTING_PKG.GV_SRC_ORACLE_PURCHASING
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: );

Line 1837: pv_currency_of_return_tax_amt => JAI_PA_COSTING_PKG.get_trx_curr_indicator,

1833: v_rcpt_tax_amount := get_nonrec_tax_amount( pv_transaction_source => 'ORACLE_PURCHASING',
1834: pv_line_type => 'PO_RECEIPT',
1835: pn_transaction_header_id => rec_get_rcpt_dtls.shipment_header_id,
1836: pn_transaction_dist_id => rec_get_rcpt_dtls.transaction_id,
1837: pv_currency_of_return_tax_amt => JAI_PA_COSTING_PKG.get_trx_curr_indicator,
1838: pn_transaction_qty => rec_get_rcpt_dtls.quantity,
1839: pn_currency_conv_rate => rec_get_rcpt_dtls.currency_conversion_rate);
1840:
1841:

Line 2271: end jai_pa_costing_pkg;

2267: ----------------------------------------------------------------------------------------------------------------
2268: -- Added by Jia for FP Bug#8805693, End
2269:
2270:
2271: end jai_pa_costing_pkg;