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