1 package jai_pa_costing_pkg AUTHID CURRENT_USER as
2 /*$Header: jai_pa_costing.pls 120.1 2011/04/08 11:13:46 erma ship $*/
3 /*------------------------------------------------------------------------------------------------------------
4 CHANGE HISTORY
5 ------------------------------------------------------------------------------------------------------------
6 Sl.No. Date Developer BugNo Version Remarks
7 ------------------------------------------------------------------------------------------------------------
8 1. 17/JAN/2007 brathod 5765161 115.0 Created the initial version
9
10 1. 24-APR-2007 cbabu 6012567 120.0 Forward ported to R12 from R11i taking 115.0 version
11
12 2. 06-Jul-2010 Jia 7242428 Forward ported to R12.2 from R11i bug#7145704
13 Added the function get_comtmnt_amt
14
15 3. 06-Jul-2010 Jia 8805693 Forward ported to R12.2 from R11i bug#8702421 and bug#8438564
16 Added the procedure update_interface_cost_tax
17
18 4. 06-Jul-2010 Jia 9863751 Forward ported to R12.2 from R11i bug#9188112
19 Added Post_process procedure
20 --------------------------------------------------------------------------------------------------------------*/
21
22 gv_src_oracle_purchasing constant varchar2(30) := 'ORACLE_PURCHASING';
23 gv_line_type_requisition constant varchar2(30) := 'R';
24 gv_line_type_purchasing constant varchar2(30) := 'P';
25 gv_line_type_po_receipt constant varchar2(30) := 'PO_RECEIPT';
26
27 gv_src_oracle_payables constant varchar2(30) := 'ORACLE_PAYABLES';
28 gv_line_type_invoice constant varchar2(30) := 'I';
29 gv_functional_currency constant varchar2(30) := 'FUNCTIONAL_CURR';
30 gv_transaction_currency constant varchar2(30) := 'TRANSACTION_CURR';
31
32
33 function get_func_curr_indicator return varchar2;
34 function get_trx_curr_indicator return varchar2;
35
36 function get_nonrec_tax_amount(
37 pv_transaction_source in varchar2,
38 pv_line_type in varchar2,
39 pn_transaction_header_id in number,
40 pn_transaction_dist_id in number, /* One of PO_REQ_DISTRIBUTIONS_ALL.distribution_id, PO_DISTRIBUTIONS_ALL.po_distribution_id, RCV_TRANSACTIONS.transaction_id, AP_INVOICE_DISTRIBUTIONS_ALL.invoice_distribution_id */
41 pv_currency_of_return_tax_amt in varchar2 default null, /* no value is passed, then tax amount in transaction currency is returned */
42 pv_transaction_uom in varchar2 default null, /* if not given, then conversion of UOM w.r.to main transaction will not be performed */
43 pn_transaction_qty in number default null,
44 pn_currency_conv_rate in number default null
45
46 ) return number;
47
48 procedure pre_process
49 ( p_transaction_source in varchar2,
50 p_batch in varchar2,
51 p_xface_id in number,
52 p_user_id in number
53 );
54
55 -- Added by Jia for FP Bug#9863751, Begin
56 --------------------------------------------------------
57 procedure post_process
58 ( p_transaction_source in varchar2,
59 p_batch in varchar2,
60 p_xface_id in number,
61 p_user_id in number
62 );
63 --------------------------------------------------------
64 -- Added by Jia for FP Bug#9863751, End
65
66 procedure update_interface_costs
67 ( p_transaction_source in varchar2
68 , p_batch in varchar2
69 , p_xface_id in varchar2
70 , p_process_flag out nocopy varchar2
71 , p_process_message out nocopy varchar2
72 );
73
74 -- Added by Jia for FP Bug#7242428, Begin
75 --------------------------------------------------------
76 FUNCTION get_comtmnt_amt (p_invoice_id IN NUMBER,
77 p_project_id IN NUMBER,
78 p_dist_line_number IN NUMBER,
79 p_amount IN NUMBER)
80 RETURN NUMBER;
81 --------------------------------------------------------
82 -- Added by Jia for FP Bug#7242428, End
83
84
85 -- Added by Jia for FP Bug#8805693, Begin
86 --------------------------------------------------------
87 PROCEDURE update_interface_cost_tax( p_transaction_id IN NUMBER
88 , p_tax_type IN VARCHAR2 DEFAULT 'VAT'
89 , p_process_flag out nocopy varchar2
90 , p_process_message out nocopy varchar2);
91 --------------------------------------------------------
92 -- Added by Jia for FP Bug#8805693, End
93
94 end JAI_PA_COSTING_PKG;