[Home] [Help]
PACKAGE: APPS.PO_CORE_S2
Source
1 PACKAGE PO_CORE_S2 AUTHID CURRENT_USER AS
2 /* $Header: POXCOC2S.pls 120.4.12020000.2 2013/03/26 06:32:52 xueche ship $*/
3
4 PROCEDURE GET_REQ_CURRENCY (x_object_id IN NUMBER,
5 x_base_currency OUT NOCOPY VARCHAR2,
6 p_org_id IN NUMBER);--bug#5092574
7
8
9 PROCEDURE GET_CURRENCY_INFO (x_currency_code IN VARCHAR2,
10 x_precision OUT NOCOPY NUMBER,
11 x_min_unit OUT NOCOPY NUMBER );
12
13 /* Bug# 14376121: Added to include default values for precision and extended precision */
14 PROCEDURE GET_CURRENCY_INFO_DETAILS (p_currency_code IN VARCHAR2,
15 x_precision OUT NOCOPY NUMBER,
16 x_ext_precision OUT NOCOPY NUMBER,
17 x_min_unit OUT NOCOPY NUMBER );
18
19 PROCEDURE GET_PO_CURRENCY (x_object_id IN NUMBER,
20 x_base_currency OUT NOCOPY VARCHAR2,
21 x_po_currency OUT NOCOPY VARCHAR2);
22
23
24 FUNCTION get_base_currency return VARCHAR2;
25
26 PROCEDURE GET_PO_CURRENCY_INFO (p_po_header_id IN NUMBER,
27 x_currency_code OUT NOCOPY VARCHAR2,
28 x_curr_rate_type OUT NOCOPY VARCHAR2,
29 x_curr_rate_date OUT NOCOPY DATE,
30 x_currency_rate OUT NOCOPY NUMBER);
31
32 --<ENCUMBRANCE FPJ START>
33 --Added a centralized, bulk routine for currency conversion and rounding
34 PROCEDURE round_and_convert_currency(
35 x_return_status OUT NOCOPY VARCHAR2
36 , p_unique_id_tbl IN PO_TBL_NUMBER --bug 4878973
37 , p_amount_in_tbl IN PO_TBL_NUMBER
38 , p_exchange_rate_tbl IN PO_TBL_NUMBER
39 , p_from_currency_precision_tbl IN PO_TBL_NUMBER
40 , p_from_currency_mau_tbl IN PO_TBL_NUMBER
41 , p_to_currency_precision_tbl IN PO_TBL_NUMBER
42 , p_to_currency_mau_tbl IN PO_TBL_NUMBER
43 , p_round_only_flag_tbl IN PO_TBL_VARCHAR1 --bug 3568671
44 , x_amount_out_tbl OUT NOCOPY PO_TBL_NUMBER
45 );
46 --<ENCUMBRANCE FPJ END>
47 --<R12 MOAC START>
48 FUNCTION get_base_currency(p_org_id po_system_parameters_all.org_id%TYPE)
49 RETURN VARCHAR2;
50 --<R12 MOAC END>
51
52
53 END PO_CORE_S2;