[Home] [Help]
PACKAGE: APPS.CSD_REPAIR_HISTORY_PKG
Source
1 PACKAGE CSD_REPAIR_HISTORY_PKG AUTHID CURRENT_USER as
2 /* $Header: csdtdrhs.pls 115.4 2002/11/08 20:20:36 swai ship $ */
3 -- Start of Comments
4 -- Package name : CSD_REPAIR_HISTORY_PKG
5 -- Purpose :
6 -- History :
7 -- 02/05/02 travi Added Object Version Number Column
8 -- NOTE :
9 -- End of Comments
10
11 PROCEDURE Insert_Row(
12 px_REPAIR_HISTORY_ID IN OUT NOCOPY NUMBER,
13 p_OBJECT_VERSION_NUMBER NUMBER,
14 p_REQUEST_ID NUMBER,
15 p_PROGRAM_ID NUMBER,
16 p_PROGRAM_APPLICATION_ID NUMBER,
17 p_PROGRAM_UPDATE_DATE DATE,
18 p_CREATED_BY NUMBER,
19 p_CREATION_DATE DATE,
20 p_LAST_UPDATED_BY NUMBER,
21 p_LAST_UPDATE_DATE DATE,
22 p_REPAIR_LINE_ID NUMBER,
23 p_EVENT_CODE VARCHAR2,
24 p_EVENT_DATE DATE,
25 p_QUANTITY NUMBER,
26 p_PARAMN1 NUMBER,
27 p_PARAMN2 NUMBER,
28 p_PARAMN3 NUMBER,
29 p_PARAMN4 NUMBER,
30 p_PARAMN5 NUMBER,
31 p_PARAMN6 NUMBER,
32 p_PARAMN7 NUMBER,
33 p_PARAMN8 NUMBER,
34 p_PARAMN9 NUMBER,
35 p_PARAMN10 NUMBER,
36 p_PARAMC1 VARCHAR2,
37 p_PARAMC2 VARCHAR2,
38 p_PARAMC3 VARCHAR2,
39 p_PARAMC4 VARCHAR2,
40 p_PARAMC5 VARCHAR2,
41 p_PARAMC6 VARCHAR2,
42 p_PARAMC7 VARCHAR2,
43 p_PARAMC8 VARCHAR2,
44 p_PARAMC9 VARCHAR2,
45 p_PARAMC10 VARCHAR2,
46 p_PARAMD1 DATE,
47 p_PARAMD2 DATE,
48 p_PARAMD3 DATE,
49 p_PARAMD4 DATE,
50 p_PARAMD5 DATE,
51 p_PARAMD6 DATE,
52 p_PARAMD7 DATE,
53 p_PARAMD8 DATE,
54 p_PARAMD9 DATE,
55 p_PARAMD10 DATE,
56 p_ATTRIBUTE_CATEGORY VARCHAR2,
57 p_ATTRIBUTE1 VARCHAR2,
58 p_ATTRIBUTE2 VARCHAR2,
59 p_ATTRIBUTE3 VARCHAR2,
60 p_ATTRIBUTE4 VARCHAR2,
61 p_ATTRIBUTE5 VARCHAR2,
62 p_ATTRIBUTE6 VARCHAR2,
63 p_ATTRIBUTE7 VARCHAR2,
64 p_ATTRIBUTE8 VARCHAR2,
65 p_ATTRIBUTE9 VARCHAR2,
66 p_ATTRIBUTE10 VARCHAR2,
67 p_ATTRIBUTE11 VARCHAR2,
68 p_ATTRIBUTE12 VARCHAR2,
69 p_ATTRIBUTE13 VARCHAR2,
70 p_ATTRIBUTE14 VARCHAR2,
71 p_ATTRIBUTE15 VARCHAR2,
72 p_LAST_UPDATE_LOGIN NUMBER);
73
74 PROCEDURE Update_Row(
75 p_REPAIR_HISTORY_ID NUMBER,
76 p_OBJECT_VERSION_NUMBER NUMBER,
77 p_REQUEST_ID NUMBER,
78 p_PROGRAM_ID NUMBER,
79 p_PROGRAM_APPLICATION_ID NUMBER,
80 p_PROGRAM_UPDATE_DATE DATE,
81 p_CREATED_BY NUMBER,
82 p_CREATION_DATE DATE,
83 p_LAST_UPDATED_BY NUMBER,
84 p_LAST_UPDATE_DATE DATE,
85 p_REPAIR_LINE_ID NUMBER,
86 p_EVENT_CODE VARCHAR2,
87 p_EVENT_DATE DATE,
88 p_QUANTITY NUMBER,
89 p_PARAMN1 NUMBER,
90 p_PARAMN2 NUMBER,
91 p_PARAMN3 NUMBER,
92 p_PARAMN4 NUMBER,
93 p_PARAMN5 NUMBER,
94 p_PARAMN6 NUMBER,
95 p_PARAMN7 NUMBER,
96 p_PARAMN8 NUMBER,
97 p_PARAMN9 NUMBER,
98 p_PARAMN10 NUMBER,
99 p_PARAMC1 VARCHAR2,
100 p_PARAMC2 VARCHAR2,
101 p_PARAMC3 VARCHAR2,
102 p_PARAMC4 VARCHAR2,
103 p_PARAMC5 VARCHAR2,
104 p_PARAMC6 VARCHAR2,
105 p_PARAMC7 VARCHAR2,
106 p_PARAMC8 VARCHAR2,
107 p_PARAMC9 VARCHAR2,
108 p_PARAMC10 VARCHAR2,
109 p_PARAMD1 DATE,
110 p_PARAMD2 DATE,
111 p_PARAMD3 DATE,
112 p_PARAMD4 DATE,
113 p_PARAMD5 DATE,
114 p_PARAMD6 DATE,
115 p_PARAMD7 DATE,
116 p_PARAMD8 DATE,
117 p_PARAMD9 DATE,
118 p_PARAMD10 DATE,
119 p_ATTRIBUTE_CATEGORY VARCHAR2,
120 p_ATTRIBUTE1 VARCHAR2,
121 p_ATTRIBUTE2 VARCHAR2,
122 p_ATTRIBUTE3 VARCHAR2,
123 p_ATTRIBUTE4 VARCHAR2,
124 p_ATTRIBUTE5 VARCHAR2,
125 p_ATTRIBUTE6 VARCHAR2,
126 p_ATTRIBUTE7 VARCHAR2,
127 p_ATTRIBUTE8 VARCHAR2,
128 p_ATTRIBUTE9 VARCHAR2,
129 p_ATTRIBUTE10 VARCHAR2,
130 p_ATTRIBUTE11 VARCHAR2,
131 p_ATTRIBUTE12 VARCHAR2,
132 p_ATTRIBUTE13 VARCHAR2,
133 p_ATTRIBUTE14 VARCHAR2,
134 p_ATTRIBUTE15 VARCHAR2,
135 p_LAST_UPDATE_LOGIN NUMBER);
136
137 PROCEDURE Lock_Row(
138 p_REPAIR_HISTORY_ID NUMBER,
139 p_OBJECT_VERSION_NUMBER NUMBER,
140 p_REQUEST_ID NUMBER,
141 p_PROGRAM_ID NUMBER,
142 p_PROGRAM_APPLICATION_ID NUMBER,
143 p_PROGRAM_UPDATE_DATE DATE,
144 p_CREATED_BY NUMBER,
145 p_CREATION_DATE DATE,
146 p_LAST_UPDATED_BY NUMBER,
147 p_LAST_UPDATE_DATE DATE,
148 p_REPAIR_LINE_ID NUMBER,
149 p_EVENT_CODE VARCHAR2,
150 p_EVENT_DATE DATE,
151 p_QUANTITY NUMBER,
152 p_PARAMN1 NUMBER,
153 p_PARAMN2 NUMBER,
154 p_PARAMN3 NUMBER,
155 p_PARAMN4 NUMBER,
156 p_PARAMN5 NUMBER,
157 p_PARAMN6 NUMBER,
158 p_PARAMN7 NUMBER,
159 p_PARAMN8 NUMBER,
160 p_PARAMN9 NUMBER,
161 p_PARAMN10 NUMBER,
162 p_PARAMC1 VARCHAR2,
163 p_PARAMC2 VARCHAR2,
164 p_PARAMC3 VARCHAR2,
165 p_PARAMC4 VARCHAR2,
166 p_PARAMC5 VARCHAR2,
167 p_PARAMC6 VARCHAR2,
168 p_PARAMC7 VARCHAR2,
169 p_PARAMC8 VARCHAR2,
170 p_PARAMC9 VARCHAR2,
171 p_PARAMC10 VARCHAR2,
172 p_PARAMD1 DATE,
173 p_PARAMD2 DATE,
174 p_PARAMD3 DATE,
175 p_PARAMD4 DATE,
176 p_PARAMD5 DATE,
177 p_PARAMD6 DATE,
178 p_PARAMD7 DATE,
179 p_PARAMD8 DATE,
180 p_PARAMD9 DATE,
181 p_PARAMD10 DATE,
182 p_ATTRIBUTE_CATEGORY VARCHAR2,
183 p_ATTRIBUTE1 VARCHAR2,
184 p_ATTRIBUTE2 VARCHAR2,
185 p_ATTRIBUTE3 VARCHAR2,
186 p_ATTRIBUTE4 VARCHAR2,
187 p_ATTRIBUTE5 VARCHAR2,
188 p_ATTRIBUTE6 VARCHAR2,
189 p_ATTRIBUTE7 VARCHAR2,
190 p_ATTRIBUTE8 VARCHAR2,
191 p_ATTRIBUTE9 VARCHAR2,
192 p_ATTRIBUTE10 VARCHAR2,
193 p_ATTRIBUTE11 VARCHAR2,
194 p_ATTRIBUTE12 VARCHAR2,
195 p_ATTRIBUTE13 VARCHAR2,
196 p_ATTRIBUTE14 VARCHAR2,
197 p_ATTRIBUTE15 VARCHAR2,
198 p_LAST_UPDATE_LOGIN NUMBER);
199
200 PROCEDURE Delete_Row(
201 p_REPAIR_HISTORY_ID NUMBER,
202 p_OBJECT_VERSION_NUMBER NUMBER);
203 End CSD_REPAIR_HISTORY_PKG;