DBA Data[Home] [Help]

PACKAGE: APPS.PQH_PQIPED9_XMLP_PKG

Source


1 PACKAGE PQH_PQIPED9_XMLP_PKG AS
2 /* $Header: PQIPED9S.pls 120.2 2007/12/21 17:28:43 vjaganat noship $ */
3   P_CONC_REQUEST_ID VARCHAR2(40);
4 
5   P_BUSINESS_GROUP_ID VARCHAR2(40);
6 
7   P_REPORT_DATE DATE;
8 
9   P_REPORT_DATE_T VARCHAR2(40);
10 
11   LINE_NUM NUMBER := 100;
12 
13   LAST_LINENO NUMBER := 110;
14 
15   TOTREPORTTITLE VARCHAR2(75) := 'Total (sum of lines 100-109)';
16 
17   CP_FR VARCHAR2(2000);
18 
19   CP_FT VARCHAR2(2000);
20 
21   CP_PR VARCHAR2(2000);
22 
23   CP_PT VARCHAR2(2000);
24 
25   CP_HIRE_DATE DATE := to_date('01-07-2002','DD-MM-YYYY');
26 
27   LP_HIRE_DATE varchar2(20);
28 
29   FUNCTION LINEFORMULA RETURN NUMBER;
30 
31   FUNCTION BEFOREREPORT RETURN BOOLEAN;
32 
33   FUNCTION AFTERREPORT RETURN BOOLEAN;
34 
35   FUNCTION LINE_NUM_P RETURN NUMBER;
36 
37   FUNCTION LAST_LINENO_P RETURN NUMBER;
38 
39   FUNCTION TOTREPORTTITLE_P RETURN VARCHAR2;
40 
41   FUNCTION CP_FR_P RETURN VARCHAR2;
42 
43   FUNCTION CP_FT_P RETURN VARCHAR2;
44 
45   FUNCTION CP_PR_P RETURN VARCHAR2;
46 
47   FUNCTION CP_PT_P RETURN VARCHAR2;
48 
49   FUNCTION CP_HIRE_DATE_P RETURN DATE;
50 
51 END PQH_PQIPED9_XMLP_PKG;