PACKAGE: APPS.PJM_PJMRPWSE_XMLP_PKG

Source

1 PACKAGE PJM_PJMRPWSE_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PJMRPWSES.pls 120.0 2007/12/24 12:30:20 nchinnam noship $ */
3   P_ORDER_BY NUMBER;
4 
5   P_PROJECT_NUMBER_FROM VARCHAR2(40);
6 
7   P_PROJECT_NUMBER_TO VARCHAR2(40);
8 
9   P_ASSEMBLY_FROM VARCHAR2(240);
10 
11   P_ASSEMBLY_TO VARCHAR2(240);
12 
13   P_ORDER_BY_DISP VARCHAR2(80);
14 
15   P_CONC_REQUEST_ID NUMBER;
16 
17   P_DATE_FROM VARCHAR2(40);
18 
19   P_DATE_TO VARCHAR2(40);
20 
21   D_DATE_FROM DATE;
22 
23   D_DATE_TO DATE;
24 
25   D_DATE_FROM_DISP VARCHAR2(40);
26 
27   D_DATE_TO_DISP VARCHAR2(40);
28 
29   P_ITEM_WHERE VARCHAR2(1000);
30 
31   P_PROJECT_WHERE VARCHAR2(240):='1 = 1';
32 
33   P_DATE_WHERE VARCHAR2(240):='IS NOT NULL';
34 
35   FUNCTION AFTERREPORT RETURN BOOLEAN;
36 
37   FUNCTION BEFOREREPORT RETURN BOOLEAN;
38 
39 END PJM_PJMRPWSE_XMLP_PKG;
40