[Home] [Help]
PACKAGE: APPS.PAY_PAYUSRRS_XMLP_PKG
Source
1 PACKAGE PAY_PAYUSRRS_XMLP_PKG AS
2 /* $Header: PAYUSRRSS.pls 120.0 2007/12/28 06:47:47 srikrish noship $ */
3 P_BUSINESS_GROUP_ID number;
4 P_SESSION_DATE date;
5 P_REPORT_TITLE varchar2(60);
6 P_CONC_REQUEST_ID number;
7 P_PERSON_ID varchar2(40);
8 P_REPORT_SUBTITLE varchar2(100);
9 P_TAX_UNIT_ID varchar2(40);
10 P_ASSIGNMENT_NUMBER varchar2(40);
11 P_START_DATE date;
12 LP_START_DATE date;
13 P_END_DATE date;
14 LP_END_DATE date;
15 P_CLASSIFICATION_ID varchar2(40);
16 P_where_clause varchar2(2000);
17 P_asg_set_id varchar2(40);
18 P_from_clause varchar2(2000);
19 p_hint_clause varchar2(2000);
20 P_selection_criteria varchar2(32767);
21 C_BUSINESS_GROUP_NAME varchar2(240);
22 C_REPORT_SUBTITLE varchar2(60);
23 C_PERSON_NAME varchar2(240);
24 C_CLASSIFICATION_NAME varchar2(80);
25 CP_GRE_NAME varchar2(240);
26 CP_asg_set_name varchar2(240);
27 function BeforeReport return boolean ;
28 function element_categoryformula(element_information_category in varchar2, element_information1 in varchar2) return varchar2 ;
29 FUNCTION GET_BUSINESS_GROUP_NAME(fp_business_group_id IN NUMBER) RETURN VARCHAR2 ;
30 function gre_nameformula(TAX_UNIT_ID in number) return varchar2 ;
31 function CF_con_dateFormula return VARCHAR2 ;
32 function AfterReport return boolean ;
33 function AfterPForm return boolean ;
34 Function C_BUSINESS_GROUP_NAME_p return varchar2;
35 Function C_REPORT_SUBTITLE_p return varchar2;
36 Function C_PERSON_NAME_p return varchar2;
37 Function C_CLASSIFICATION_NAME_p return varchar2;
38 Function CP_GRE_NAME_p return varchar2;
39 Function CP_asg_set_name_p return varchar2;
40 /*Added as a fix*/
41 function RVALUEFormula(RESULT_VALUE VARCHAR2) return Number;
42 END PAY_PAYUSRRS_XMLP_PKG;