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.4 2008/01/21 11:27:09 ssumaith noship $*/
3: /*------------------------------------------------------------------------------------------------------------
4: CHANGE HISTORY
5: ------------------------------------------------------------------------------------------------------------

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

20: --------------------------------------------------------------------------------------------------------------*/
21: /*----------------------------------------- PRIVATE MEMBERS DECLRATION -------------------------------------*/
22:
23: /** Package level variables used in debug package*/
24: lv_object_name jai_cmn_debug_contexts.log_context%type := 'JAI_PA_COSTING_PKG';
25: lv_member_name jai_cmn_debug_contexts.log_context%type;
26: lv_context jai_cmn_debug_contexts.log_context%type;
27: --
28: -- Global variables used throught the package

Line 169: if pv_transaction_source = JAI_PA_COSTING_PKG.gv_src_oracle_purchasing then

165: /* this should consider currency, recoverable percentage and apportion factor when calculating the tax */
166:
167: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'pv_line_type='||pv_line_type || ', pv_transaction_source='||pv_transaction_source);
168:
169: if pv_transaction_source = JAI_PA_COSTING_PKG.gv_src_oracle_purchasing then
170:
171: /* 1 - REQUISITONS */
172: if pv_line_type = JAI_PA_COSTING_PKG.gv_line_type_requisition then
173:

Line 172: if pv_line_type = JAI_PA_COSTING_PKG.gv_line_type_requisition then

168:
169: if pv_transaction_source = JAI_PA_COSTING_PKG.gv_src_oracle_purchasing then
170:
171: /* 1 - REQUISITONS */
172: if pv_line_type = JAI_PA_COSTING_PKG.gv_line_type_requisition then
173:
174: open c_get_reqn_dist_dtl(pn_transaction_dist_id);
175: fetch c_get_reqn_dist_dtl into r_get_reqn_dist_dtl;
176: close c_get_reqn_dist_dtl;

Line 260: elsif pv_line_type = JAI_PA_COSTING_PKG.gv_line_type_purchasing then

256: 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
257:
258:
259: /* 2 - PURCHASE ORDERS */
260: elsif pv_line_type = JAI_PA_COSTING_PKG.gv_line_type_purchasing then
261:
262: open c_get_po_dist_dtl(pn_transaction_dist_id);
263: fetch c_get_po_dist_dtl into r_get_po_dist_dtl;
264: close c_get_po_dist_dtl;

Line 347: elsif pv_line_type = JAI_PA_COSTING_PKG.gv_line_type_po_receipt then

343: 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
344: 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
345:
346: /* 3 - PURCHASE RECEIPTS */
347: elsif pv_line_type = JAI_PA_COSTING_PKG.gv_line_type_po_receipt then
348:
349:
350: open c_ja_in_rcv_trx(pn_transaction_dist_id);
351: fetch c_ja_in_rcv_trx into r_ja_in_deliver_trx;

Line 525: elsif pv_transaction_source = JAI_PA_COSTING_PKG.gv_src_oracle_payables

521:
522: end if;
523:
524: /* 4 - PAYABLE INVOICES */
525: elsif pv_transaction_source = JAI_PA_COSTING_PKG.gv_src_oracle_payables
526: and pv_line_type = JAI_PA_COSTING_PKG.gv_line_type_invoice
527: then
528:
529: select

Line 526: and pv_line_type = JAI_PA_COSTING_PKG.gv_line_type_invoice

522: end if;
523:
524: /* 4 - PAYABLE INVOICES */
525: elsif pv_transaction_source = JAI_PA_COSTING_PKG.gv_src_oracle_payables
526: and pv_line_type = JAI_PA_COSTING_PKG.gv_line_type_invoice
527: then
528:
529: select
530: nvl(sum(a.base_amount),0) functional_tax_amount,

Line 581: or pv_currency_of_return_tax_amt = JAI_PA_COSTING_PKG.gv_transaction_currency

577:
578: <>
579:
580: if pv_currency_of_return_tax_amt is null
581: or pv_currency_of_return_tax_amt = JAI_PA_COSTING_PKG.gv_transaction_currency
582: then
583: return (ln_trx_nonreco_tax_amt);
584: else
585: return (ln_func_nonreco_tax_amt);

Line 689: ln_apportioned_txn_tax_amt := JAI_PA_COSTING_PKG.get_nonrec_tax_amount

685: 'r_po_rcpt.unit_of_measure='||r_po_rcpt.unit_of_measure|| fnd_global.local_chr(10) ||
686: 'r_po_rcpt.quantity='||r_po_rcpt.quantity || fnd_global.local_chr(10) ||
687: 'r_po_rcpt.txn_interface_id='||r_po_rcpt.txn_interface_id
688: );
689: ln_apportioned_txn_tax_amt := JAI_PA_COSTING_PKG.get_nonrec_tax_amount
690: ( pv_transaction_source => JAI_PA_COSTING_PKG.GV_SRC_ORACLE_PURCHASING
691: , pv_line_type => JAI_PA_COSTING_PKG.GV_LINE_TYPE_PO_RECEIPT
692: , pn_transaction_header_id => null -- ''
693: , pn_transaction_dist_id => r_po_rcpt.cdl_system_reference4 --> rcv_transaction_id

Line 690: ( pv_transaction_source => JAI_PA_COSTING_PKG.GV_SRC_ORACLE_PURCHASING

686: 'r_po_rcpt.quantity='||r_po_rcpt.quantity || fnd_global.local_chr(10) ||
687: 'r_po_rcpt.txn_interface_id='||r_po_rcpt.txn_interface_id
688: );
689: ln_apportioned_txn_tax_amt := JAI_PA_COSTING_PKG.get_nonrec_tax_amount
690: ( pv_transaction_source => JAI_PA_COSTING_PKG.GV_SRC_ORACLE_PURCHASING
691: , pv_line_type => JAI_PA_COSTING_PKG.GV_LINE_TYPE_PO_RECEIPT
692: , pn_transaction_header_id => null -- ''
693: , pn_transaction_dist_id => r_po_rcpt.cdl_system_reference4 --> rcv_transaction_id
694: , pv_currency_of_return_tax_amt => JAI_PA_COSTING_PKG.gv_transaction_currency

Line 691: , pv_line_type => JAI_PA_COSTING_PKG.GV_LINE_TYPE_PO_RECEIPT

687: 'r_po_rcpt.txn_interface_id='||r_po_rcpt.txn_interface_id
688: );
689: ln_apportioned_txn_tax_amt := JAI_PA_COSTING_PKG.get_nonrec_tax_amount
690: ( pv_transaction_source => JAI_PA_COSTING_PKG.GV_SRC_ORACLE_PURCHASING
691: , pv_line_type => JAI_PA_COSTING_PKG.GV_LINE_TYPE_PO_RECEIPT
692: , pn_transaction_header_id => null -- ''
693: , pn_transaction_dist_id => r_po_rcpt.cdl_system_reference4 --> rcv_transaction_id
694: , pv_currency_of_return_tax_amt => JAI_PA_COSTING_PKG.gv_transaction_currency
695: , pv_transaction_uom => r_po_rcpt.unit_of_measure

Line 694: , pv_currency_of_return_tax_amt => JAI_PA_COSTING_PKG.gv_transaction_currency

690: ( pv_transaction_source => JAI_PA_COSTING_PKG.GV_SRC_ORACLE_PURCHASING
691: , pv_line_type => JAI_PA_COSTING_PKG.GV_LINE_TYPE_PO_RECEIPT
692: , pn_transaction_header_id => null -- ''
693: , pn_transaction_dist_id => r_po_rcpt.cdl_system_reference4 --> rcv_transaction_id
694: , pv_currency_of_return_tax_amt => JAI_PA_COSTING_PKG.gv_transaction_currency
695: , pv_transaction_uom => r_po_rcpt.unit_of_measure
696: , pn_transaction_qty => r_po_rcpt.quantity
697: , pn_currency_conv_rate => r_po_rcpt.receipt_exchange_rate
698: );

Line 700: ln_apportioned_func_tax_amt := JAI_PA_COSTING_PKG.get_nonrec_tax_amount

696: , pn_transaction_qty => r_po_rcpt.quantity
697: , pn_currency_conv_rate => r_po_rcpt.receipt_exchange_rate
698: );
699:
700: ln_apportioned_func_tax_amt := JAI_PA_COSTING_PKG.get_nonrec_tax_amount
701: ( pv_transaction_source => JAI_PA_COSTING_PKG.GV_SRC_ORACLE_PURCHASING
702: , pv_line_type => JAI_PA_COSTING_PKG.GV_LINE_TYPE_PO_RECEIPT
703: , pn_transaction_header_id => null -- ''
704: , pn_transaction_dist_id => r_po_rcpt.cdl_system_reference4 --> rcv_transaction_id

Line 701: ( pv_transaction_source => JAI_PA_COSTING_PKG.GV_SRC_ORACLE_PURCHASING

697: , pn_currency_conv_rate => r_po_rcpt.receipt_exchange_rate
698: );
699:
700: ln_apportioned_func_tax_amt := JAI_PA_COSTING_PKG.get_nonrec_tax_amount
701: ( pv_transaction_source => JAI_PA_COSTING_PKG.GV_SRC_ORACLE_PURCHASING
702: , pv_line_type => JAI_PA_COSTING_PKG.GV_LINE_TYPE_PO_RECEIPT
703: , pn_transaction_header_id => null -- ''
704: , pn_transaction_dist_id => r_po_rcpt.cdl_system_reference4 --> rcv_transaction_id
705: , pv_currency_of_return_tax_amt => JAI_PA_COSTING_PKG.gv_functional_currency

Line 702: , pv_line_type => JAI_PA_COSTING_PKG.GV_LINE_TYPE_PO_RECEIPT

698: );
699:
700: ln_apportioned_func_tax_amt := JAI_PA_COSTING_PKG.get_nonrec_tax_amount
701: ( pv_transaction_source => JAI_PA_COSTING_PKG.GV_SRC_ORACLE_PURCHASING
702: , pv_line_type => JAI_PA_COSTING_PKG.GV_LINE_TYPE_PO_RECEIPT
703: , pn_transaction_header_id => null -- ''
704: , pn_transaction_dist_id => r_po_rcpt.cdl_system_reference4 --> rcv_transaction_id
705: , pv_currency_of_return_tax_amt => JAI_PA_COSTING_PKG.gv_functional_currency
706: , 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 705: , pv_currency_of_return_tax_amt => JAI_PA_COSTING_PKG.gv_functional_currency

701: ( pv_transaction_source => JAI_PA_COSTING_PKG.GV_SRC_ORACLE_PURCHASING
702: , pv_line_type => JAI_PA_COSTING_PKG.GV_LINE_TYPE_PO_RECEIPT
703: , pn_transaction_header_id => null -- ''
704: , pn_transaction_dist_id => r_po_rcpt.cdl_system_reference4 --> rcv_transaction_id
705: , pv_currency_of_return_tax_amt => JAI_PA_COSTING_PKG.gv_functional_currency
706: , 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 */
707: , pn_transaction_qty => r_po_rcpt.quantity
708: , pn_currency_conv_rate => r_po_rcpt.receipt_exchange_rate
709: );

Line 950: end jai_pa_costing_pkg;

946: jai_cmn_debug_contexts_pkg.print_stack;
947:
948: end update_interface_costs;
949:
950: end jai_pa_costing_pkg;