DBA Data[Home] [Help]

PACKAGE: APPS.EAM_EAMWSREP_XMLP_PKG

Source


1 PACKAGE EAM_EAMWSREP_XMLP_PKG AS
2 /* $Header: EAMWSREPS.pls 120.0 2007/12/25 07:59:45 krreddy noship $ */
3   P_WEEK_START_DATE DATE;
4 
5   P_AREA VARCHAR2(30);
6 
7   P_REBUILD_ITEM NUMBER;
8 
9   P_RESOURCE VARCHAR2(32767);
10 
11   P_INSTANCE VARCHAR2(32767);
12 
13   P_WEEK_STARTING DATE;
14 
15   P_SHUTDOWN_TYPE VARCHAR2(32767);
16 
17   P_ASSET VARCHAR2(30);
18 
19   P_OWNING_DEPARTMENT VARCHAR2(32767);
20 
21   P_ASSIGNED_DEPT VARCHAR2(32767);
22 
23   P_SORT_BY NUMBER;
24 
25   P_ORG_NAME VARCHAR2(240);
26 
27   P_DIS_RBITEM VARCHAR2(240);
28 
29   P_DIS_START_DATE DATE;
30 
31   P_DIS_SORT_BY VARCHAR2(50);
32 
33   P_ORG_ID NUMBER;
34 
35   P_CONC_REQUEST_ID NUMBER;
36 
37   CP_1 NUMBER;
38 
39   CP_2 NUMBER;
40 
41   CP_3 NUMBER;
42 
43   CP_4 NUMBER;
44 
45   CP_5 NUMBER;
46 
47   CP_6 NUMBER;
48 
49   CP_7 NUMBER;
50 
51   CP_8 NUMBER;
52 
53   CP_13 VARCHAR2(32767);
54 
55   CP_14 VARCHAR2(32767);
56 
57   CP_15 VARCHAR2(32767);
58 
59   CP_16 VARCHAR2(32767);
60 
61   CP_17 VARCHAR2(32767);
62 
63   CP_11 VARCHAR2(32767);
64 
65   CP_12 VARCHAR2(32767);
66 
67   FUNCTION CF_AREA RETURN VARCHAR2;
68 
69   FUNCTION CF_ASSET RETURN CHAR;
70 
71   FUNCTION CF_REBUILD_ITEM RETURN CHAR;
72 
73   FUNCTION CF_ASSIGNED_DEPT RETURN CHAR;
74 
75   FUNCTION CF_INSTANCE RETURN VARCHAR2;
76 
77   FUNCTION CF_OWNING_DEPARTMENT RETURN varchar2;
78 
79   FUNCTION CF_REPORT_HEADER RETURN CHAR;
80 
81   FUNCTION CF_RESOURCE RETURN VARCHAR2;
82 
83   FUNCTION CF_SHUTDOWN_TYPE RETURN CHAR;
84 
85   FUNCTION CF_SORT_BY RETURN CHAR;
86 
87   FUNCTION DAYS(RES_START_DATE IN DATE
88                ,RES_COMPLETION_DATE IN DATE) RETURN VARCHAR2;
89 
90   FUNCTION AFTERPFORM RETURN BOOLEAN;
91 
92   FUNCTION BEFOREREPORT RETURN BOOLEAN;
93 
94   FUNCTION AFTERREPORT RETURN BOOLEAN;
95 
96   FUNCTION CP_1_P RETURN NUMBER;
97 
98   FUNCTION CP_2_P RETURN NUMBER;
99 
100   FUNCTION CP_3_P RETURN NUMBER;
101 
102   FUNCTION CP_4_P RETURN NUMBER;
103 
104   FUNCTION CP_5_P RETURN NUMBER;
105 
106   FUNCTION CP_6_P RETURN NUMBER;
107 
108   FUNCTION CP_7_P RETURN NUMBER;
109 
110   FUNCTION CP_8_P RETURN NUMBER;
111 
112   FUNCTION CP_13_P RETURN VARCHAR2;
113 
114   FUNCTION CP_14_P RETURN VARCHAR2;
115 
116   FUNCTION CP_15_P RETURN VARCHAR2;
117 
118   FUNCTION CP_16_P RETURN VARCHAR2;
119 
120   FUNCTION CP_17_P RETURN VARCHAR2;
121 
122   FUNCTION CP_11_P RETURN VARCHAR2;
123 
124   FUNCTION CP_12_P RETURN VARCHAR2;
125 
126 END EAM_EAMWSREP_XMLP_PKG;
127 
128