﻿FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	100	 	 	   (?_O_DATA?IN  CHAR                                      
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	200	O	-	   (8)                                                     
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	300	 	 	   ,?_O_DATA?ADD INT)                                      
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	400	 	 	?_FUNC_RETURNS?                                            
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	500	 	 	   CHAR                                                    
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	600	O	-	   (8)                                                     
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	700	 	 	?_FUNC_BEGIN?                                              
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	800	M	+	   CONVERT(CHAR(8),DATEADD(DAY,?_O_DATA?ADD                
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	900	M	+	      ,CONVERT(DATETIME,?_O_DATA?IN)),112)                 
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	1000	I	+	   SUBSTR(REPLACE(CHAR(TIMESTAMP(CAST                      
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	1100	I	+	      (?_O_DATA?IN AS CHAR(8))||'000000')                  
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	1200	I	+	      +?_O_DATA?ADD DAYS),'-',''),1,8)                     
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	1300	O	+	   ?_O_DATA?OUT CHAR(8); BEGIN                             
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	1400	O	+	      SELECT TO_CHAR(TO_DATE(SUBSTR(?_O_DATA?IN            
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	1500	O	+	      ,1,8),'YYYYMMDD')+?_O_DATA?ADD,'YYYYMMDD')           
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	1600	O	+	      INTO ?_O_DATA?OUT FROM DUAL;                         
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	1700	O	+	      RETURN (?_O_DATA?OUT);END;                           
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	1800	P	+	   SELECT TO_CHAR(TO_DATE(CAST($1 AS CHAR(8))              
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	1900	P	+	      ,'YYYYMMDD') + $2,'YYYYMMDD');                       
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	2000	L	+	   SELECT LEFT(REPLACE(ADDDATE(CONCAT                      
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	2100	L	+	      (SUBSTRING(?_O_DATA?IN,1,4),'-'                      
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	2200	L	+	      ,SUBSTRING(?_O_DATA?IN,5,2),'-'                      
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	2300	L	+	      ,SUBSTRING(?_O_DATA?IN,7,2))                         
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	2400	L	+	      ,?_O_DATA?ADD),'-',''),8)                            
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	2500	H	+	   REPLACE(CAST(CAST(SUBSTR(?_O_DATA?IN                    
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	2600	H	+	      ,1,4)||'-'||SUBSTR(?_O_DATA?IN,5,2)                  
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	2700	H	+	      ||'-'||SUBSTR(?_O_DATA?IN,7,2) AS DATE)              
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	2800	H	+	      +?_O_DATA?ADD DAYS AS CHAR(10)),'-','');             
FUNC 	ZZZZZZ_DAY_CHAR_FUNC          	2900	 	 	?_FUNC_END?                                                
FUNC 	ZZZZZZ_DAY_DATE_FUNC          	100	 	 	   (?_O_DATA?IN  DATE                                      
FUNC 	ZZZZZZ_DAY_DATE_FUNC          	200	 	 	   ,?_O_DATA?ADD INT)                                      
FUNC 	ZZZZZZ_DAY_DATE_FUNC          	300	 	 	?_FUNC_RETURNS?                                            
FUNC 	ZZZZZZ_DAY_DATE_FUNC          	400	 	 	   CHAR                                                    
FUNC 	ZZZZZZ_DAY_DATE_FUNC          	500	O	-	   (8)                                                     
FUNC 	ZZZZZZ_DAY_DATE_FUNC          	600	 	 	?_FUNC_BEGIN?                                              
FUNC 	ZZZZZZ_DAY_DATE_FUNC          	700	M	+	   CONVERT(CHAR(8),DATEADD(DAY,?_O_DATA?ADD,?_O_DATA?IN)   
FUNC 	ZZZZZZ_DAY_DATE_FUNC          	800	M	+	      ,112)                                                
FUNC 	ZZZZZZ_DAY_DATE_FUNC          	900	I	+	   SUBSTR(REPLACE(CHAR(?_O_DATA?IN+?_O_DATA?ADD DAYS),'-'  
FUNC 	ZZZZZZ_DAY_DATE_FUNC          	1000	I	+	      ,''),1,8)                                            
FUNC 	ZZZZZZ_DAY_DATE_FUNC          	1100	O	+	   ?_O_DATA?OUT CHAR(8); BEGIN                             
FUNC 	ZZZZZZ_DAY_DATE_FUNC          	1200	O	+	      SELECT TO_CHAR(?_O_DATA?IN+?_O_DATA?ADD,'YYYYMMDD')  
FUNC 	ZZZZZZ_DAY_DATE_FUNC          	1300	O	+	      INTO ?_O_DATA?OUT FROM DUAL;                         
FUNC 	ZZZZZZ_DAY_DATE_FUNC          	1400	O	+	      RETURN (?_O_DATA?OUT);END;                           
FUNC 	ZZZZZZ_DAY_DATE_FUNC          	1600	P	+	   SELECT TO_CHAR($1+$2,'YYYYMMDD');                       
FUNC 	ZZZZZZ_DAY_DATE_FUNC          	1700	L	+	   SELECT LEFT(REPLACE(ADDDATE(?_O_DATA?IN,?_O_DATA?ADD)   
FUNC 	ZZZZZZ_DAY_DATE_FUNC          	1800	L	+	   ,'-',''),8)                                             
FUNC 	ZZZZZZ_DAY_DATE_FUNC          	1900	H	+	   REPLACE(CAST(?_O_DATA?IN+?_O_DATA?ADD                   
FUNC 	ZZZZZZ_DAY_DATE_FUNC          	2000	H	+	      DAYS AS CHAR(10)),'-','');                           
FUNC 	ZZZZZZ_DAY_DATE_FUNC          	2100	 	 	?_FUNC_END?                                                
FUNC 	ZZZZZZ_WEEK_CHAR_FUNC         	100	 	 	   (?_O_DATA?IN  CHAR                                      
FUNC 	ZZZZZZ_WEEK_CHAR_FUNC         	200	O	-	   (8)                                                     
FUNC 	ZZZZZZ_WEEK_CHAR_FUNC         	300	 	 	   )                                                       
FUNC 	ZZZZZZ_WEEK_CHAR_FUNC         	400	 	 	?_FUNC_RETURNS?                                            
FUNC 	ZZZZZZ_WEEK_CHAR_FUNC         	500	 	 	   INT                                                     
FUNC 	ZZZZZZ_WEEK_CHAR_FUNC         	600	 	 	?_FUNC_BEGIN?                                              
FUNC 	ZZZZZZ_WEEK_CHAR_FUNC         	700	M	+	   DATEPART(DW,CONVERT(DATETIME,?_O_DATA?IN))              
FUNC 	ZZZZZZ_WEEK_CHAR_FUNC         	800	I	+	   DAYOFWEEK(TIMESTAMP(CAST                                
FUNC 	ZZZZZZ_WEEK_CHAR_FUNC         	900	I	+	      (?_O_DATA?IN AS CHAR(8))||'000000'))                 
FUNC 	ZZZZZZ_WEEK_CHAR_FUNC         	1000	O	+	   ?_O_DATA?OUT INT; BEGIN                                 
FUNC 	ZZZZZZ_WEEK_CHAR_FUNC         	1100	O	+	      SELECT TO_CHAR(TO_DATE(SUBSTR(?_O_DATA?IN            
FUNC 	ZZZZZZ_WEEK_CHAR_FUNC         	1200	O	+	      ,1,8),'YYYYMMDD'),'D')                               
FUNC 	ZZZZZZ_WEEK_CHAR_FUNC         	1300	O	+	      INTO ?_O_DATA?OUT FROM DUAL;                         
FUNC 	ZZZZZZ_WEEK_CHAR_FUNC         	1400	O	+	      RETURN (?_O_DATA?OUT);END;                           
FUNC 	ZZZZZZ_WEEK_CHAR_FUNC         	1500	P	+	   SELECT CAST(EXTRACT(DOW FROM TO_DATE(CAST($1 AS CHAR(8))
FUNC 	ZZZZZZ_WEEK_CHAR_FUNC         	1600	P	+	      ,'YYYYMMDD'))+1 AS INT);                             
FUNC 	ZZZZZZ_WEEK_CHAR_FUNC         	1700	L	+	   SELECT DAYOFWEEK(CONCAT                                 
FUNC 	ZZZZZZ_WEEK_CHAR_FUNC         	1800	L	+	      (SUBSTRING(?_O_DATA?IN,1,4),'-'                      
FUNC 	ZZZZZZ_WEEK_CHAR_FUNC         	1900	L	+	      ,SUBSTRING(?_O_DATA?IN,5,2),'-'                      
FUNC 	ZZZZZZ_WEEK_CHAR_FUNC         	2000	L	+	      ,SUBSTRING(?_O_DATA?IN,7,2)))                        
FUNC 	ZZZZZZ_WEEK_CHAR_FUNC         	2100	H	+	   DAYOFWEEK(CAST(SUBSTR(?_O_DATA?IN                       
FUNC 	ZZZZZZ_WEEK_CHAR_FUNC         	2200	H	+	      ,1,4)||'-'||SUBSTR(?_O_DATA?IN,5,2)                  
FUNC 	ZZZZZZ_WEEK_CHAR_FUNC         	2300	H	+	      ||'-'||SUBSTR(?_O_DATA?IN,7,2) AS DATE));            
FUNC 	ZZZZZZ_WEEK_CHAR_FUNC         	2400	 	 	?_FUNC_END?                                                
FUNC 	ZZZZZZ_WEEK_DATE_FUNC         	100	 	 	   (?_O_DATA?IN  DATE)                                     
FUNC 	ZZZZZZ_WEEK_DATE_FUNC         	200	 	 	?_FUNC_RETURNS?                                            
FUNC 	ZZZZZZ_WEEK_DATE_FUNC         	300	 	 	   INT                                                     
FUNC 	ZZZZZZ_WEEK_DATE_FUNC         	400	 	 	?_FUNC_BEGIN?                                              
FUNC 	ZZZZZZ_WEEK_DATE_FUNC         	500	M	+	   DATEPART(DW,?_O_DATA?IN)                                
FUNC 	ZZZZZZ_WEEK_DATE_FUNC         	600	I	+	   DAYOFWEEK(?_O_DATA?IN)                                  
FUNC 	ZZZZZZ_WEEK_DATE_FUNC         	700	O	+	   ?_O_DATA?OUT INT; BEGIN                                 
FUNC 	ZZZZZZ_WEEK_DATE_FUNC         	800	O	+	      SELECT TO_CHAR(?_O_DATA?IN,'D')                      
FUNC 	ZZZZZZ_WEEK_DATE_FUNC         	900	O	+	      INTO ?_O_DATA?OUT FROM DUAL;                         
FUNC 	ZZZZZZ_WEEK_DATE_FUNC         	1000	O	+	      RETURN (?_O_DATA?OUT);END;                           
FUNC 	ZZZZZZ_WEEK_DATE_FUNC         	1100	P	+	   SELECT CAST(EXTRACT(DOW FROM $1)+1 AS INT);             
FUNC 	ZZZZZZ_WEEK_DATE_FUNC         	1200	L	+	   SELECT DAYOFWEEK(?_O_DATA?IN)                           
FUNC 	ZZZZZZ_WEEK_DATE_FUNC         	1300	H	+	   DAYOFWEEK(?_O_DATA?IN);                                 
FUNC 	ZZZZZZ_WEEK_DATE_FUNC         	1400	 	 	?_FUNC_END?                                                
