DBA Data[Home] [Help]

APPS.PA_MULTI_CURRENCY_BILLING dependencies on PA_PLSQL_DATATYPES

Line 83: p_from_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,

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,

Line 84: p_to_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,

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 ,

Line 85: p_conversion_date_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp ,

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,

Line 86: p_conversion_type_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

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,

Line 87: p_amount_tab IN 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,

Line 88: p_user_validate_flag_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,
92: p_rate_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,

Line 89: p_converted_amount_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,

Line 90: p_denominator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,

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,

Line 91: p_numerator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,

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

Line 92: p_rate_tab IN OUT NOCOPY 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);
96:

Line 95: x_status_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp);

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: