DBA Data[Home] [Help]

APPS.PO_CORE_S2 dependencies on PO_TBL_NUMBER

Line 32: , p_unique_id_tbl IN PO_TBL_NUMBER --bug 4878973

28: --
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

Line 33: , p_amount_in_tbl IN PO_TBL_NUMBER

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

Line 34: , p_exchange_rate_tbl IN PO_TBL_NUMBER

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

Line 35: , p_from_currency_precision_tbl IN PO_TBL_NUMBER

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

Line 36: , p_from_currency_mau_tbl IN PO_TBL_NUMBER

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

Line 37: , p_to_currency_precision_tbl IN PO_TBL_NUMBER

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: );

Line 38: , p_to_currency_mau_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: --

Line 40: , x_amount_out_tbl OUT NOCOPY 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: --
43: --
44: FUNCTION get_base_currency(p_org_id po_system_parameters_all.org_id%TYPE)