PACKAGE: APPS.PO_CORE_S2

Source

1 PACKAGE PO_CORE_S2 AS
2 /* $Header: POXCOC2S.pls 120.4 2006/03/14 22:58:13 asista noship $*/
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 
14 
15 PROCEDURE GET_PO_CURRENCY (x_object_id      IN NUMBER,
16                            x_base_currency OUT NOCOPY VARCHAR2,
17                            x_po_currency   OUT NOCOPY VARCHAR2);
18 
19 
20 FUNCTION get_base_currency return VARCHAR2;
21 
22 PROCEDURE GET_PO_CURRENCY_INFO (p_po_header_id      IN NUMBER,
23                                 x_currency_code     OUT NOCOPY VARCHAR2,
24                                 x_curr_rate_type    OUT NOCOPY VARCHAR2,
25                                 x_curr_rate_date    OUT NOCOPY DATE,
26                                 x_currency_rate     OUT NOCOPY NUMBER);
27 
28 --<ENCUMBRANCE FPJ START>
29 --Added a centralized, bulk routine for currency conversion and rounding
30 PROCEDURE round_and_convert_currency(
31    x_return_status                OUT    NOCOPY VARCHAR2
32 ,  p_unique_id_tbl                IN     PO_TBL_NUMBER  --bug 4878973
33 ,  p_amount_in_tbl                IN     PO_TBL_NUMBER
34 ,  p_exchange_rate_tbl            IN     PO_TBL_NUMBER
35 ,  p_from_currency_precision_tbl  IN     PO_TBL_NUMBER
36 ,  p_from_currency_mau_tbl        IN     PO_TBL_NUMBER
37 ,  p_to_currency_precision_tbl    IN     PO_TBL_NUMBER
38 ,  p_to_currency_mau_tbl          IN     PO_TBL_NUMBER
39 ,  p_round_only_flag_tbl          IN     PO_TBL_VARCHAR1  --bug 3568671
40 ,  x_amount_out_tbl               OUT    NOCOPY PO_TBL_NUMBER
41 );
42 --<ENCUMBRANCE FPJ END>
43 --<R12 MOAC START>
44 FUNCTION get_base_currency(p_org_id po_system_parameters_all.org_id%TYPE)
45 RETURN   VARCHAR2;
46 --<R12 MOAC END>
47 
48 
49 END PO_CORE_S2;