DBA Data[Home] [Help]

APPS.PO_CORE_S2 dependencies on PO_TBL_NUMBER

Line 36: , p_unique_id_tbl IN PO_TBL_NUMBER --bug 4878973

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

Line 37: , p_amount_in_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

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

Line 39: , p_from_currency_precision_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

Line 40: , p_from_currency_mau_tbl IN PO_TBL_NUMBER

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

Line 41: , p_to_currency_precision_tbl IN 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: );

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

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