[Home] [Help]
PACKAGE: APPS.JAI_PA_COSTING_PKG
Source
1 package jai_pa_costing_pkg as
2 /*$Header: jai_pa_costing.pls 120.0.12000000.1 2007/10/24 18:20:30 rallamse noship $*/
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 --------------------------------------------------------------------------------------------------------------*/
13
14 gv_src_oracle_purchasing constant varchar2(30) := 'ORACLE_PURCHASING';
15 gv_line_type_requisition constant varchar2(30) := 'R';
16 gv_line_type_purchasing constant varchar2(30) := 'P';
17 gv_line_type_po_receipt constant varchar2(30) := 'PO_RECEIPT';
18
19 gv_src_oracle_payables constant varchar2(30) := 'ORACLE_PAYABLES';
20 gv_line_type_invoice constant varchar2(30) := 'I';
21 gv_functional_currency constant varchar2(30) := 'FUNCTIONAL_CURR';
22 gv_transaction_currency constant varchar2(30) := 'TRANSACTION_CURR';
23
24
25 function get_func_curr_indicator return varchar2;
26 function get_trx_curr_indicator return varchar2;
27
28 function get_nonrec_tax_amount(
29 pv_transaction_source in varchar2,
30 pv_line_type in varchar2,
31 pn_transaction_header_id in number,
32 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 */
33 pv_currency_of_return_tax_amt in varchar2 default null, /* no value is passed, then tax amount in transaction currency is returned */
34 pv_transaction_uom in varchar2 default null, /* if not given, then conversion of UOM w.r.to main transaction will not be performed */
35 pn_transaction_qty in number default null,
36 pn_currency_conv_rate in number default null
37
38 ) return number;
39
40 procedure pre_process
41 ( p_transaction_source in varchar2,
42 p_batch in varchar2,
43 p_xface_id in number,
44 p_user_id in number
45 );
46
47 procedure update_interface_costs
48 ( p_transaction_source in varchar2
49 , p_batch in varchar2
50 , p_xface_id in varchar2
51 , p_process_flag out nocopy varchar2
52 , p_process_message out nocopy varchar2
53 );
54
55 end JAI_PA_COSTING_PKG;