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