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.FV_SLA_UTL_PROCESSING_PKG dependencies on FV_TREASURY_SYMBOLS

Line 655: p_treasury_symbols_rec OUT NOCOPY fv_treasury_symbols%ROWTYPE,

651: (
652: p_ledger_id IN NUMBER,
653: p_fund_value IN VARCHAR2,
654: p_fund_parameter_rec OUT NOCOPY fv_fund_parameters%ROWTYPE,
655: p_treasury_symbols_rec OUT NOCOPY fv_treasury_symbols%ROWTYPE,
656: p_error_code OUT NOCOPY NUMBER,
657: p_error_desc OUT NOCOPY VARCHAR2
658: )
659: IS

Line 690: FROM fv_treasury_symbols

686: IF (p_error_code = c_SUCCESS) THEN
687: trace(C_STATE_LEVEL, l_procedure_name, 'treasury_symbol_id='||p_fund_parameter_rec.treasury_symbol_id);
688: SELECT *
689: INTO p_treasury_symbols_rec
690: FROM fv_treasury_symbols
691: WHERE treasury_symbol_id = p_fund_parameter_rec.treasury_symbol_id;
692: NULL;
693: END IF;
694: trace(C_PROC_LEVEL, l_procedure_name, 'END');

Line 727: l_treasury_symbols_rec fv_treasury_symbols%ROWTYPE;

723: l_fund_value fv_fund_parameters.fund_value%TYPE;
724: l_account_value VARCHAR2(30);
725: l_bfy_value VARCHAR2(30);
726: l_fund_parameter_rec fv_fund_parameters%ROWTYPE;
727: l_treasury_symbols_rec fv_treasury_symbols%ROWTYPE;
728: BEGIN
729: p_error_code := c_SUCCESS;
730: p_error_desc := NULL;
731:

Line 815: p_fund_time_frame OUT NOCOPY fv_treasury_symbols.time_frame%TYPE,

811: p_gl_date IN DATE,
812: p_appor_category OUT NOCOPY fv_fund_parameters.fund_category%TYPE,
813: p_direct_or_reimb OUT NOCOPY fv_fund_parameters.fund_category%TYPE,
814: p_fund_status OUT NOCOPY VARCHAR2,
815: p_fund_time_frame OUT NOCOPY fv_treasury_symbols.time_frame%TYPE,
816: p_treasury_symbol_id OUT NOCOPY fv_fund_parameters.treasury_symbol_id%TYPE,
817: p_treasury_symbol OUT NOCOPY fv_treasury_symbols.treasury_symbol%TYPE,
818: p_no_pya_acct_flag OUT NOCOPY fv_treasury_symbols.no_pya_acct_flag%TYPE,
819: p_fund_type OUT NOCOPY fv_treasury_symbols.fund_type%TYPE,

Line 817: p_treasury_symbol OUT NOCOPY fv_treasury_symbols.treasury_symbol%TYPE,

813: p_direct_or_reimb OUT NOCOPY fv_fund_parameters.fund_category%TYPE,
814: p_fund_status OUT NOCOPY VARCHAR2,
815: p_fund_time_frame OUT NOCOPY fv_treasury_symbols.time_frame%TYPE,
816: p_treasury_symbol_id OUT NOCOPY fv_fund_parameters.treasury_symbol_id%TYPE,
817: p_treasury_symbol OUT NOCOPY fv_treasury_symbols.treasury_symbol%TYPE,
818: p_no_pya_acct_flag OUT NOCOPY fv_treasury_symbols.no_pya_acct_flag%TYPE,
819: p_fund_type OUT NOCOPY fv_treasury_symbols.fund_type%TYPE,
820: p_error_code OUT NOCOPY NUMBER,
821: p_error_desc OUT NOCOPY VARCHAR2

Line 818: p_no_pya_acct_flag OUT NOCOPY fv_treasury_symbols.no_pya_acct_flag%TYPE,

814: p_fund_status OUT NOCOPY VARCHAR2,
815: p_fund_time_frame OUT NOCOPY fv_treasury_symbols.time_frame%TYPE,
816: p_treasury_symbol_id OUT NOCOPY fv_fund_parameters.treasury_symbol_id%TYPE,
817: p_treasury_symbol OUT NOCOPY fv_treasury_symbols.treasury_symbol%TYPE,
818: p_no_pya_acct_flag OUT NOCOPY fv_treasury_symbols.no_pya_acct_flag%TYPE,
819: p_fund_type OUT NOCOPY fv_treasury_symbols.fund_type%TYPE,
820: p_error_code OUT NOCOPY NUMBER,
821: p_error_desc OUT NOCOPY VARCHAR2
822: )

Line 819: p_fund_type OUT NOCOPY fv_treasury_symbols.fund_type%TYPE,

815: p_fund_time_frame OUT NOCOPY fv_treasury_symbols.time_frame%TYPE,
816: p_treasury_symbol_id OUT NOCOPY fv_fund_parameters.treasury_symbol_id%TYPE,
817: p_treasury_symbol OUT NOCOPY fv_treasury_symbols.treasury_symbol%TYPE,
818: p_no_pya_acct_flag OUT NOCOPY fv_treasury_symbols.no_pya_acct_flag%TYPE,
819: p_fund_type OUT NOCOPY fv_treasury_symbols.fund_type%TYPE,
820: p_error_code OUT NOCOPY NUMBER,
821: p_error_desc OUT NOCOPY VARCHAR2
822: )
823: IS

Line 826: l_treasury_symbols_rec fv_treasury_symbols%ROWTYPE;

822: )
823: IS
824: l_procedure_name VARCHAR2(100) :='.get_fund_details';
825: l_fund_parameter_rec fv_fund_parameters%ROWTYPE;
826: l_treasury_symbols_rec fv_treasury_symbols%ROWTYPE;
827:
828: BEGIN
829: l_procedure_name := g_path_name || l_procedure_name;
830: p_error_code := c_SUCCESS;

Line 914: p_fund_time_frame OUT NOCOPY fv_treasury_symbols.time_frame%TYPE,

910: p_fund_value IN VARCHAR2,
911: p_gl_date IN DATE,
912: p_fund_category OUT NOCOPY fv_fund_parameters.fund_category%TYPE,
913: p_fund_status OUT NOCOPY VARCHAR2,
914: p_fund_time_frame OUT NOCOPY fv_treasury_symbols.time_frame%TYPE,
915: p_treasury_symbol_id OUT NOCOPY fv_fund_parameters.treasury_symbol_id%TYPE,
916: p_treasury_symbol OUT NOCOPY fv_treasury_symbols.treasury_symbol%TYPE,
917: p_no_pya_acct_flag OUT NOCOPY fv_treasury_symbols.no_pya_acct_flag%TYPE,
918: p_error_code OUT NOCOPY NUMBER,

Line 916: p_treasury_symbol OUT NOCOPY fv_treasury_symbols.treasury_symbol%TYPE,

912: p_fund_category OUT NOCOPY fv_fund_parameters.fund_category%TYPE,
913: p_fund_status OUT NOCOPY VARCHAR2,
914: p_fund_time_frame OUT NOCOPY fv_treasury_symbols.time_frame%TYPE,
915: p_treasury_symbol_id OUT NOCOPY fv_fund_parameters.treasury_symbol_id%TYPE,
916: p_treasury_symbol OUT NOCOPY fv_treasury_symbols.treasury_symbol%TYPE,
917: p_no_pya_acct_flag OUT NOCOPY fv_treasury_symbols.no_pya_acct_flag%TYPE,
918: p_error_code OUT NOCOPY NUMBER,
919: p_error_desc OUT NOCOPY VARCHAR2
920: )

Line 917: p_no_pya_acct_flag OUT NOCOPY fv_treasury_symbols.no_pya_acct_flag%TYPE,

913: p_fund_status OUT NOCOPY VARCHAR2,
914: p_fund_time_frame OUT NOCOPY fv_treasury_symbols.time_frame%TYPE,
915: p_treasury_symbol_id OUT NOCOPY fv_fund_parameters.treasury_symbol_id%TYPE,
916: p_treasury_symbol OUT NOCOPY fv_treasury_symbols.treasury_symbol%TYPE,
917: p_no_pya_acct_flag OUT NOCOPY fv_treasury_symbols.no_pya_acct_flag%TYPE,
918: p_error_code OUT NOCOPY NUMBER,
919: p_error_desc OUT NOCOPY VARCHAR2
920: )
921: IS

Line 924: l_fund_type fv_treasury_symbols.fund_type%TYPE;

920: )
921: IS
922: l_procedure_name VARCHAR2(100) :='.get_fund_details';
923: l_direct_or_reimb VARCHAR2(1);
924: l_fund_type fv_treasury_symbols.fund_type%TYPE;
925: BEGIN
926: l_procedure_name := g_path_name || l_procedure_name;
927: p_error_code := c_SUCCESS;
928: p_error_desc := NULL;

Line 2007: FROM fv_treasury_symbols t

2003: FROM fv_extract_detail_gt g
2004: WHERE g.fund_expired_status = 'Expired'
2005: AND g.prior_year_flag = 'N'
2006: AND NOT EXISTS (SELECT 1 --Bug14593920
2007: FROM fv_treasury_symbols t
2008: WHERE t.treasury_symbol_id = g.treasury_symbol_id
2009: AND NVL(t.no_pya_acct_flag, 'N') = 'Y')) LOOP
2010: g_CurrentEventId := exp_funds_rec.event_id;
2011: p_error_code := c_FAILURE;