32: --
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
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
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
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
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
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: );
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: --
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: --
47: --
48: FUNCTION get_base_currency(p_org_id po_system_parameters_all.org_id%TYPE)