DBA Data[Home] [Help]

APPS.HZ_DNBUI_PVT dependencies on HZ_DNBUI_PVT

Line 1: PACKAGE BODY HZ_DNBUI_PVT AS

1: PACKAGE BODY HZ_DNBUI_PVT AS
2: /*$Header: ARHDNBUB.pls 120.11.12010000.2 2009/11/23 09:47:08 vsegu ship $*/
3:
4: /*======================================================================
5: | FUNCTION

Line 490: DECODE( HZ_DNBUI_PVT.GET_FINANCIAL_NUMBER(p_financial_name, p_financial_report_id),

486: l_financial_symbol_number varchar2(240);
487: BEGIN
488:
489: select
490: DECODE( HZ_DNBUI_PVT.GET_FINANCIAL_NUMBER(p_financial_name, p_financial_report_id),
491: null, null,
492: nvl(HZ_DNBUI_PVT.get_financial_number_currency(p_financial_name, p_financial_report_id), 'USD') || ' ' ||
493: HZ_DNBUI_PVT.GET_FINANCIAL_NUMBER(p_financial_name, p_financial_report_id))
494: into l_financial_symbol_number

Line 492: nvl(HZ_DNBUI_PVT.get_financial_number_currency(p_financial_name, p_financial_report_id), 'USD') || ' ' ||

488:
489: select
490: DECODE( HZ_DNBUI_PVT.GET_FINANCIAL_NUMBER(p_financial_name, p_financial_report_id),
491: null, null,
492: nvl(HZ_DNBUI_PVT.get_financial_number_currency(p_financial_name, p_financial_report_id), 'USD') || ' ' ||
493: HZ_DNBUI_PVT.GET_FINANCIAL_NUMBER(p_financial_name, p_financial_report_id))
494: into l_financial_symbol_number
495: from dual;
496:

Line 493: HZ_DNBUI_PVT.GET_FINANCIAL_NUMBER(p_financial_name, p_financial_report_id))

489: select
490: DECODE( HZ_DNBUI_PVT.GET_FINANCIAL_NUMBER(p_financial_name, p_financial_report_id),
491: null, null,
492: nvl(HZ_DNBUI_PVT.get_financial_number_currency(p_financial_name, p_financial_report_id), 'USD') || ' ' ||
493: HZ_DNBUI_PVT.GET_FINANCIAL_NUMBER(p_financial_name, p_financial_report_id))
494: into l_financial_symbol_number
495: from dual;
496:
497: RETURN l_financial_symbol_number;

Line 757: END HZ_DNBUI_PVT;

753: RETURN null;
754:
755: END get_first_available_report;
756:
757: END HZ_DNBUI_PVT;