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);