Scenario - to be removed Only if deatails conplete - just a flag - to be presented Include Cash Management Flows - to be removed Domestic - to be removed 1. What parameters to include and check in report: -- Report Title - 0 - OK -- Start Date (Inclusive) - 1 - OK -- End Date (Inclusive) - 2 - OK -- Exclude If Contracted After - 3 - OK -- Include Contracts Based On - 4 - OK -- Entity - 5 - OK -- Counterparty - 6 - OK -- Contract Number List - 7 - -- Portfolio Code - 8 - OK -- Portfolio Sub Code - 9 - OK -- Contract Code - 10 - OK + -- Contract Sub Code - 11 - OK + -- Currencies - 12 - OK -- Folder - 13 - OK -- Cash Flow Status - 14 - OK -- Flow Direction - 15 - OK -- Base Currency - 16 - OK -- FX Conversion - 17 - ??? - това не съм сигурен дали е сетнато правилно - за момента не ми трябва !!!! -- Spot FX rates on - 18 - OK -- Exchange Rate Type - 19 - input param in func -- Rounding - 20 - OK -- Include Contingent Liabilities - 21 - OK Параметри: 2. Да премахна параметри. Да създам скрип за Прод за параметрите. - OK 3. Да оправя новото т.е. в OTHER да се слагат 2 нови категории. - тези категории трябва да се отлюспят от куеритата за другите неща v_start_date := star_reporting_pack.get_parameter_value('Start_Date_(Inclusive)_V1', star_exceloutput_pack.GLB_PARAMETERS, star_exceloutput_pack.GLB_NO_PARAMETERS); v_end_date := star_reporting_pack.get_parameter_value('End_Date_(Inclusive)_V1', star_exceloutput_pack.GLB_PARAMETERS, star_exceloutput_pack.GLB_NO_PARAMETERS); v_exclude_if_contr_after := star_reporting_pack.get_parameter_value('Exclude_If_Contracted_After_V1', star_exceloutput_pack.GLB_PARAMETERS, star_exceloutput_pack.GLB_NO_PARAMETERS); v_contingent_liabilities := star_reporting_pack.get_parameter_value('Contingent_Liabilities_V1', star_exceloutput_pack.GLB_PARAMETERS, star_exceloutput_pack.GLB_NO_PARAMETERS); v_details_complete := star_reporting_pack.get_parameter_value('Details_Complete_V1', star_exceloutput_pack.GLB_PARAMETERS, star_exceloutput_pack.GLB_NO_PARAMETERS); v_incl_excl_contr := star_reporting_pack.get_parameter_value('Include_Contracts_Based_On_V1', star_exceloutput_pack.GLB_PARAMETERS, star_exceloutput_pack.GLB_NO_PARAMETERS); v_include_cmf := star_reporting_pack.get_parameter_value('Include_Cash_Management_Flows_V1', star_exceloutput_pack.GLB_PARAMETERS, star_exceloutput_pack.GLB_NO_PARAMETERS); v_fx_type := star_reporting_pack.get_parameter_value('FX_Conversion_V1', star_exceloutput_pack.GLB_PARAMETERS, star_exceloutput_pack.GLB_NO_PARAMETERS); v_domestic := star_reporting_pack.get_parameter_value('Domestic_V1', star_exceloutput_pack.GLB_PARAMETERS, star_exceloutput_pack.GLB_NO_PARAMETERS);