DBA Data[Home] [Help]

APPS.PA_MULTI_CURRENCY_BILLING dependencies on PA_PLSQL_DATATYPES

Line 547: p_from_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,

543: | x_status_tab OUT Return status of each conversion |
544: | ================================================================================== |
545: +----------------------------------------------------------------------------------------*/
546: PROCEDURE convert_amount_bulk (
547: p_from_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,
548: p_to_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,
549: p_conversion_date_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp ,
550: p_conversion_type_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
551: p_amount_tab IN PA_PLSQL_DATATYPES.NumTabTyp,

Line 548: p_to_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,

544: | ================================================================================== |
545: +----------------------------------------------------------------------------------------*/
546: PROCEDURE convert_amount_bulk (
547: p_from_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,
548: p_to_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,
549: p_conversion_date_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp ,
550: p_conversion_type_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
551: p_amount_tab IN PA_PLSQL_DATATYPES.NumTabTyp,
552: p_user_validate_flag_tab IN PA_PLSQL_DATATYPES.Char30TabTyp ,

Line 549: p_conversion_date_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp ,

545: +----------------------------------------------------------------------------------------*/
546: PROCEDURE convert_amount_bulk (
547: p_from_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,
548: p_to_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,
549: p_conversion_date_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp ,
550: p_conversion_type_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
551: p_amount_tab IN PA_PLSQL_DATATYPES.NumTabTyp,
552: p_user_validate_flag_tab IN PA_PLSQL_DATATYPES.Char30TabTyp ,
553: p_converted_amount_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,

Line 550: p_conversion_type_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

546: PROCEDURE convert_amount_bulk (
547: p_from_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,
548: p_to_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,
549: p_conversion_date_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp ,
550: p_conversion_type_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
551: p_amount_tab IN PA_PLSQL_DATATYPES.NumTabTyp,
552: p_user_validate_flag_tab IN PA_PLSQL_DATATYPES.Char30TabTyp ,
553: p_converted_amount_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
554: p_denominator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,

Line 551: p_amount_tab IN PA_PLSQL_DATATYPES.NumTabTyp,

547: p_from_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,
548: p_to_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,
549: p_conversion_date_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp ,
550: p_conversion_type_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
551: p_amount_tab IN PA_PLSQL_DATATYPES.NumTabTyp,
552: p_user_validate_flag_tab IN PA_PLSQL_DATATYPES.Char30TabTyp ,
553: p_converted_amount_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
554: p_denominator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
555: p_numerator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,

Line 552: p_user_validate_flag_tab IN PA_PLSQL_DATATYPES.Char30TabTyp ,

548: p_to_currency_tab IN PA_PLSQL_DATATYPES.Char30TabTyp,
549: p_conversion_date_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp ,
550: p_conversion_type_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
551: p_amount_tab IN PA_PLSQL_DATATYPES.NumTabTyp,
552: p_user_validate_flag_tab IN PA_PLSQL_DATATYPES.Char30TabTyp ,
553: p_converted_amount_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
554: p_denominator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
555: p_numerator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
556: p_rate_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,

Line 553: p_converted_amount_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,

549: p_conversion_date_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp ,
550: p_conversion_type_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
551: p_amount_tab IN PA_PLSQL_DATATYPES.NumTabTyp,
552: p_user_validate_flag_tab IN PA_PLSQL_DATATYPES.Char30TabTyp ,
553: p_converted_amount_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
554: p_denominator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
555: p_numerator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
556: p_rate_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
557: p_conversion_between IN VARCHAR2,

Line 554: p_denominator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,

550: p_conversion_type_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
551: p_amount_tab IN PA_PLSQL_DATATYPES.NumTabTyp,
552: p_user_validate_flag_tab IN PA_PLSQL_DATATYPES.Char30TabTyp ,
553: p_converted_amount_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
554: p_denominator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
555: p_numerator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
556: p_rate_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
557: p_conversion_between IN VARCHAR2,
558: p_cache_flag IN VARCHAR2,

Line 555: p_numerator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,

551: p_amount_tab IN PA_PLSQL_DATATYPES.NumTabTyp,
552: p_user_validate_flag_tab IN PA_PLSQL_DATATYPES.Char30TabTyp ,
553: p_converted_amount_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
554: p_denominator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
555: p_numerator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
556: p_rate_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
557: p_conversion_between IN VARCHAR2,
558: p_cache_flag IN VARCHAR2,
559: x_status_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp) IS

Line 556: p_rate_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,

552: p_user_validate_flag_tab IN PA_PLSQL_DATATYPES.Char30TabTyp ,
553: p_converted_amount_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
554: p_denominator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
555: p_numerator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
556: p_rate_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
557: p_conversion_between IN VARCHAR2,
558: p_cache_flag IN VARCHAR2,
559: x_status_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp) IS
560:

Line 559: x_status_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp) IS

555: p_numerator_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
556: p_rate_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp,
557: p_conversion_between IN VARCHAR2,
558: p_cache_flag IN VARCHAR2,
559: x_status_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp) IS
560:
561: l_allow_user_rate_type VARCHAR2(1) ;
562: l_converted_amount NUMBER ;
563: l_numerator NUMBER ;

Line 820: l_CurrCodeTab PA_PLSQL_DATATYPES.Char30TabTyp;

816:
817:
818: l_prectab_count NUMBER;
819:
820: l_CurrCodeTab PA_PLSQL_DATATYPES.Char30TabTyp;
821: l_MauTab PA_PLSQL_DATATYPES.NumTabTyp;
822: l_SpTab PA_PLSQL_DATATYPES.NumTabTyp;
823: l_EpTab PA_PLSQL_DATATYPES.NumTabTyp;
824:

Line 821: l_MauTab PA_PLSQL_DATATYPES.NumTabTyp;

817:
818: l_prectab_count NUMBER;
819:
820: l_CurrCodeTab PA_PLSQL_DATATYPES.Char30TabTyp;
821: l_MauTab PA_PLSQL_DATATYPES.NumTabTyp;
822: l_SpTab PA_PLSQL_DATATYPES.NumTabTyp;
823: l_EpTab PA_PLSQL_DATATYPES.NumTabTyp;
824:
825: lv_found_flag VARCHAR2(1);

Line 822: l_SpTab PA_PLSQL_DATATYPES.NumTabTyp;

818: l_prectab_count NUMBER;
819:
820: l_CurrCodeTab PA_PLSQL_DATATYPES.Char30TabTyp;
821: l_MauTab PA_PLSQL_DATATYPES.NumTabTyp;
822: l_SpTab PA_PLSQL_DATATYPES.NumTabTyp;
823: l_EpTab PA_PLSQL_DATATYPES.NumTabTyp;
824:
825: lv_found_flag VARCHAR2(1);
826:

Line 823: l_EpTab PA_PLSQL_DATATYPES.NumTabTyp;

819:
820: l_CurrCodeTab PA_PLSQL_DATATYPES.Char30TabTyp;
821: l_MauTab PA_PLSQL_DATATYPES.NumTabTyp;
822: l_SpTab PA_PLSQL_DATATYPES.NumTabTyp;
823: l_EpTab PA_PLSQL_DATATYPES.NumTabTyp;
824:
825: lv_found_flag VARCHAR2(1);
826:
827: cursor prec_info is