PACKAGE: APPS.CS_CSXSRSUM_XMLP_PKG

Source

1 PACKAGE CS_CSXSRSUM_XMLP_PKG AS
2 /* $Header: CSXSRSUMS.pls 120.0 2008/01/24 13:35:37 dwkrishn noship $ */
3 
4   P_CONC_REQUEST_ID NUMBER;
5 
6   P_SOB_ID NUMBER;
7 
8   P_ORGANIZATION_ID NUMBER;
9 
10   P_CUSTOMER_NUM_LOW VARCHAR2(30);
11 
12   P_CUSTOMER_NUM_HIGH VARCHAR2(30);
13 
14   P_ITEM_LOW VARCHAR2(30);
15 
16   P_ITEM_HIGH VARCHAR2(30);
17 
18   P_REQUEST_LOW VARCHAR2(30);
19 
20   P_REQUEST_HIGH VARCHAR2(30);
21 
22   P_TYPE VARCHAR2(30);
23 
24   P_INSTALL_LOCATION VARCHAR2(30);
25 
26   P_LOGGED_BY VARCHAR2(30);
27 
28   P_OWNER VARCHAR2(30);
29 
30   P_CLOSED_DATE DATE;
31 
32   P_SEVERITY VARCHAR2(30);
33 
34   P_URGENCY VARCHAR2(30);
35 
36   P_STATUS VARCHAR2(30);
37 
38   P_PROBLEM_CODE VARCHAR2(32767);
39 
40   P_RESOLUTION_CODE VARCHAR2(30);
41 
42   P_CLOSED_FLAG VARCHAR2(30);
43 
44   P_RETURN VARCHAR2(30);
45 
46   P_ACTIVE_WORKFLOW VARCHAR2(30);
47 
48   P_ITEM_STRUCT_NUM VARCHAR2(30);
49 
50   LP_CUSTOMER_NUMBER VARCHAR2(200);
51 
52   LP_ITEM_NUMBER VARCHAR2(200);
53 
54   LP_REQUEST_NUMBER VARCHAR2(200);
55 
56   LP_TYPE VARCHAR2(200);
57 
58   LP_INSTALL_LOCATION VARCHAR2(200);
59 
60   LP_SEVERITY VARCHAR2(200);
61 
62   LP_URGENCY VARCHAR2(200);
63 
64   LP_PROBLEM_CODE VARCHAR2(200);
65 
66   LP_RESOLUTION_CODE VARCHAR2(200);
67 
68   LP_CLOSED_FLAG VARCHAR2(200);
69 
70   LP_RETURN VARCHAR2(200);
71 
72   LP_LOGGEDBY VARCHAR2(200);
73 
74   LP_ACTIVE_WORKFLOW VARCHAR2(200);
75 
76   LP_STATUS VARCHAR2(200);
77 
78   LP_CLOSEDDATE VARCHAR2(200);
79 
80   LP_OWNER VARCHAR2(200);
81 
82   P_ITEM_WHERE VARCHAR2(600);
83 
84   P_FLEX_ITEM_CODE VARCHAR2(600);
85 
86   P_ORGANIZATION VARCHAR2(40);
87 
88   RP_REPORT_NAME VARCHAR2(80) := 'Service Request Summary Report';
89 
90   RP_COMPANY_NAME VARCHAR2(50);
91 
92   FUNCTION BEFOREREPORT RETURN BOOLEAN;
93 
94   FUNCTION AFTERREPORT RETURN BOOLEAN;
95 
96   FUNCTION AFTERPFORM RETURN BOOLEAN;
97 
98   FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
99 
100   FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
101 
102   PROCEDURE PUT(NAME IN VARCHAR2
103                ,VAL IN VARCHAR2);
104 
105   FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN;
106 
107   PROCEDURE GET(NAME IN VARCHAR2
108                ,VAL OUT NOCOPY VARCHAR2);
109 
110   FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2;
111 
112   FUNCTION VALUE_WNPS(NAME IN VARCHAR2) RETURN VARCHAR2;
113 
114   FUNCTION SAVE_USER(X_NAME IN VARCHAR2
115                     ,X_VALUE IN VARCHAR2) RETURN BOOLEAN;
116 
117   FUNCTION SAVE(X_NAME IN VARCHAR2
118                ,X_VALUE IN VARCHAR2
119                ,X_LEVEL_NAME IN VARCHAR2
120                ,X_LEVEL_VALUE IN VARCHAR2
121                ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN;
122 
123   PROCEDURE GET_SPECIFIC(NAME_Z IN VARCHAR2
124                         ,USER_ID_Z IN NUMBER
125                         ,RESPONSIBILITY_ID_Z IN NUMBER
126                         ,APPLICATION_ID_Z IN NUMBER
127                         ,VAL_Z OUT NOCOPY VARCHAR2
128                         ,DEFINED_Z OUT NOCOPY BOOLEAN);
129 
130   FUNCTION VALUE_SPECIFIC(NAME IN VARCHAR2
131                          ,USER_ID IN NUMBER
132                          ,RESPONSIBILITY_ID IN NUMBER
133                          ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2;
134 
135   PROCEDURE INITIALIZE(USER_ID_Z IN NUMBER
136                       ,RESPONSIBILITY_ID_Z IN NUMBER
137                       ,APPLICATION_ID_Z IN NUMBER
138                       ,SITE_ID_Z IN NUMBER);
139 
140   PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
141                        ,VALS IN VARCHAR2
142                        ,NUM IN NUMBER);
143 
144   PROCEDURE CS_GET_COMPANY_NAME(RP_COMPANY_NAME IN OUT NOCOPY VARCHAR2
145                                ,P_SOB_ID IN NUMBER);
146 
147   PROCEDURE CS_GET_REPORT_NAME(RP_REPORT_NAME IN OUT NOCOPY VARCHAR2
148                               ,P_CONC_REQUEST_ID IN NUMBER
149                               ,P_REPORT_NAME IN VARCHAR2);
150 
151   PROCEDURE GET_P_STRUCT_NUM(P_ITEM_STRUCT_NUM IN OUT NOCOPY VARCHAR2
152                             ,RETURN_VALUE IN OUT NOCOPY NUMBER);
153 
154 END CS_CSXSRSUM_XMLP_PKG;
155