1 PACKAGE GL_GLXCLVAL_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: GLXCLVALS.pls 120.0 2007/12/27 14:50:53 vijranga noship $ */
3 P_PERIOD_SET varchar2(15);
4 P_PERIOD_TYPE varchar2(15);
5 P_START_YEAR number;
6 P_END_YEAR number;
7 P_CONC_REQUEST_ID number;
8 user_period_type varchar2(30);
9 PREV_PS varchar2(15);
10 PREV_PT varchar2(15);
11 TOTAL_VIOLATIONS number;
12 function first_period_numformula(periodset in varchar2, periodtype in varchar2, first_period_year in number) return number ;
13 --function max_num_periodformula(periodtype in varchar2) return number ;
14 function max_num_periodformula(periodtype1 in varchar2) return number ;
15 function last_cal_yearformula(periodset in varchar2, periodtype in varchar2) return number ;
16 function date_lowformula(periodset in varchar2, periodtype in varchar2) return varchar2 ;
17 function date_highformula(periodset in varchar2, periodtype in varchar2) return varchar2 ;
18 function first_period_yearformula(periodset in varchar2, periodtype in varchar2, first_period_date in varchar2) return number ;
19 function min_quarter2formula(first_period_year in number, periodset in varchar2, periodtype in varchar2, period_year_qg in number) return number ;
20 function max_quarter2formula(periodset in varchar2, periodtype in varchar2, period_year_qg in number) return number ;
21 function BeforeReport return boolean ;
22 function AfterReport return boolean ;
23 function count_violation_qgformula(Num_Miss_Quarter_qg in number, max_quarter_qg in number) return number ;
24 function user_period_typeFormula return VARCHAR2 ;
25 --procedure gl_increment_violation_count (num number) ;
26 procedure gl_increment_violation_count (num number , periodset varchar2) ;
27 Function user_period_type_p return varchar2;
28 Function PREV_PS_p return varchar2;
29 Function PREV_PT_p return varchar2;
30 Function TOTAL_VIOLATIONS_p return number;
31 END GL_GLXCLVAL_XMLP_PKG;
32