Newer
Older
FTI / 003.Cashflow Report / report_parameters.txt
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);