eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 813: l_CurrCodeTab PA_PLSQL_DATATYPES.Char30TabTyp;

809:
810:
811: l_prectab_count NUMBER;
812:
813: l_CurrCodeTab PA_PLSQL_DATATYPES.Char30TabTyp;
814: l_MauTab PA_PLSQL_DATATYPES.NumTabTyp;
815: l_SpTab PA_PLSQL_DATATYPES.NumTabTyp;
816: l_EpTab PA_PLSQL_DATATYPES.NumTabTyp;
817:

Line 814: l_MauTab PA_PLSQL_DATATYPES.NumTabTyp;

810:
811: l_prectab_count NUMBER;
812:
813: l_CurrCodeTab PA_PLSQL_DATATYPES.Char30TabTyp;
814: l_MauTab PA_PLSQL_DATATYPES.NumTabTyp;
815: l_SpTab PA_PLSQL_DATATYPES.NumTabTyp;
816: l_EpTab PA_PLSQL_DATATYPES.NumTabTyp;
817:
818: lv_found_flag VARCHAR2(1);

Line 815: l_SpTab PA_PLSQL_DATATYPES.NumTabTyp;

811: l_prectab_count NUMBER;
812:
813: l_CurrCodeTab PA_PLSQL_DATATYPES.Char30TabTyp;
814: l_MauTab PA_PLSQL_DATATYPES.NumTabTyp;
815: l_SpTab PA_PLSQL_DATATYPES.NumTabTyp;
816: l_EpTab PA_PLSQL_DATATYPES.NumTabTyp;
817:
818: lv_found_flag VARCHAR2(1);
819:

Line 816: l_EpTab PA_PLSQL_DATATYPES.NumTabTyp;

812:
813: l_CurrCodeTab PA_PLSQL_DATATYPES.Char30TabTyp;
814: l_MauTab PA_PLSQL_DATATYPES.NumTabTyp;
815: l_SpTab PA_PLSQL_DATATYPES.NumTabTyp;
816: l_EpTab PA_PLSQL_DATATYPES.NumTabTyp;
817:
818: lv_found_flag VARCHAR2(1);
819:
820: cursor prec_info is