79: FUNCTION get_invoice_processing_cur ( p_project_id IN NUMBER)
80: RETURN VARCHAR2;
81:
82: PROCEDURE convert_amount_bulk (
83: p_from_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,
84: p_to_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,
85: p_conversion_date_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp ,
86: p_conversion_type_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
87: p_amount_tab IN PA_PLSQL_DATATYPES.NumTabTyp,
80: RETURN VARCHAR2;
81:
82: PROCEDURE convert_amount_bulk (
83: p_from_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,
84: p_to_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,
85: p_conversion_date_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp ,
86: p_conversion_type_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
87: p_amount_tab IN PA_PLSQL_DATATYPES.NumTabTyp,
88: p_user_validate_flag_tab IN PA_PLSQL_DATATYPES.Char30TabTyp ,
81:
82: PROCEDURE convert_amount_bulk (
83: p_from_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,
84: p_to_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,
85: p_conversion_date_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp ,
86: p_conversion_type_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
87: p_amount_tab IN PA_PLSQL_DATATYPES.NumTabTyp,
88: p_user_validate_flag_tab IN PA_PLSQL_DATATYPES.Char30TabTyp ,
89: p_converted_amount_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
82: PROCEDURE convert_amount_bulk (
83: p_from_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,
84: p_to_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,
85: p_conversion_date_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp ,
86: p_conversion_type_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
87: p_amount_tab IN PA_PLSQL_DATATYPES.NumTabTyp,
88: p_user_validate_flag_tab IN PA_PLSQL_DATATYPES.Char30TabTyp ,
89: p_converted_amount_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
90: p_denominator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
83: p_from_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,
84: p_to_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,
85: p_conversion_date_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp ,
86: p_conversion_type_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
87: p_amount_tab IN PA_PLSQL_DATATYPES.NumTabTyp,
88: p_user_validate_flag_tab IN PA_PLSQL_DATATYPES.Char30TabTyp ,
89: p_converted_amount_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
90: p_denominator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
91: p_numerator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
84: p_to_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,
85: p_conversion_date_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp ,
86: p_conversion_type_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
87: p_amount_tab IN PA_PLSQL_DATATYPES.NumTabTyp,
88: p_user_validate_flag_tab IN PA_PLSQL_DATATYPES.Char30TabTyp ,
89: p_converted_amount_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
90: p_denominator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
91: p_numerator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
92: p_rate_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
85: p_conversion_date_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp ,
86: p_conversion_type_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
87: p_amount_tab IN PA_PLSQL_DATATYPES.NumTabTyp,
88: p_user_validate_flag_tab IN PA_PLSQL_DATATYPES.Char30TabTyp ,
89: p_converted_amount_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
90: p_denominator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
91: p_numerator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
92: p_rate_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
93: p_conversion_between IN VARCHAR2,
86: p_conversion_type_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
87: p_amount_tab IN PA_PLSQL_DATATYPES.NumTabTyp,
88: p_user_validate_flag_tab IN PA_PLSQL_DATATYPES.Char30TabTyp ,
89: p_converted_amount_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
90: p_denominator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
91: p_numerator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
92: p_rate_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
93: p_conversion_between IN VARCHAR2,
94: p_cache_flag IN VARCHAR2,
87: p_amount_tab IN PA_PLSQL_DATATYPES.NumTabTyp,
88: p_user_validate_flag_tab IN PA_PLSQL_DATATYPES.Char30TabTyp ,
89: p_converted_amount_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
90: p_denominator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
91: p_numerator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
92: p_rate_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
93: p_conversion_between IN VARCHAR2,
94: p_cache_flag IN VARCHAR2,
95: x_status_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp);
88: p_user_validate_flag_tab IN PA_PLSQL_DATATYPES.Char30TabTyp ,
89: p_converted_amount_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
90: p_denominator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
91: p_numerator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
92: p_rate_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
93: p_conversion_between IN VARCHAR2,
94: p_cache_flag IN VARCHAR2,
95: x_status_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp);
96:
91: p_numerator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
92: p_rate_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
93: p_conversion_between IN VARCHAR2,
94: p_cache_flag IN VARCHAR2,
95: x_status_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp);
96:
97:
98: PROCEDURE init_cache (p_project_id IN NUMBER);
99: