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_FUND_PARAMETERS

Line 654: p_fund_parameter_rec OUT NOCOPY fv_fund_parameters%ROWTYPE,

650: PROCEDURE get_fund_details
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: )

Line 673: FROM fv_fund_parameters a

669:
670: BEGIN
671: SELECT *
672: INTO p_fund_parameter_rec
673: FROM fv_fund_parameters a
674: WHERE a.set_of_books_id = p_ledger_id
675: AND a.fund_value = p_fund_value;
676: EXCEPTION
677: WHEN NO_DATA_FOUND THEN

Line 723: l_fund_value fv_fund_parameters.fund_value%TYPE;

719: )
720: IS
721: l_procedure_name VARCHAR2(100) :='.get_fund_information';
722: l_ledger_info LedgerRecType;
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;

Line 726: l_fund_parameter_rec fv_fund_parameters%ROWTYPE;

722: l_ledger_info LedgerRecType;
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;

Line 812: p_appor_category OUT NOCOPY fv_fund_parameters.fund_category%TYPE,

808: p_application_id IN NUMBER,
809: p_ledger_id IN NUMBER,
810: p_fund_value IN VARCHAR2,
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,

Line 813: p_direct_or_reimb OUT NOCOPY fv_fund_parameters.fund_category%TYPE,

809: p_ledger_id IN NUMBER,
810: p_fund_value IN VARCHAR2,
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,

Line 816: p_treasury_symbol_id OUT NOCOPY fv_fund_parameters.treasury_symbol_id%TYPE,

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,
820: p_error_code OUT NOCOPY NUMBER,

Line 825: l_fund_parameter_rec fv_fund_parameters%ROWTYPE;

821: p_error_desc OUT NOCOPY VARCHAR2
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;

Line 912: p_fund_category OUT NOCOPY fv_fund_parameters.fund_category%TYPE,

908: p_application_id IN NUMBER,
909: p_ledger_id IN NUMBER,
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,

Line 915: p_treasury_symbol_id OUT NOCOPY fv_fund_parameters.treasury_symbol_id%TYPE,

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,
919: p_error_desc OUT NOCOPY VARCHAR2

Line 1467: ' fv_fund_parameters f'||

1463:
1464: --Build the Select statement for getting the fund values and ccids
1465: l_fund_select := 'SELECT code_combination_id ' ||
1466: ' FROM gl_code_Combinations g, ' ||
1467: ' fv_fund_parameters f'||
1468: ' WHERE g.chart_of_accounts_id = :p_coaid '||
1469: ' AND g.'||l_ledger_info.balancing_seg_name || ' = f.fund_value '||
1470: ' AND f.treasury_symbol_id = :p_treasury_symbol_id '||
1471: ' AND f.set_of_books_id = :p_ledger_id '||