APPS.HR_WNP_DEL dependencies on HR_WNP_SHD

Line 52: (p_rec in hr_wnp_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in hr_wnp_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 96: hr_wnp_shd.constraint_error

92: Exception
93: When hr_api.child_integrity_violated then
94: -- Child integrity has been violated
95: --
96: hr_wnp_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When Others Then
99: --
100: Raise;

Line 135: Procedure pre_delete(p_rec in hr_wnp_shd.g_rec_type) is

131: -- Internal Row Handler Use Only.
132: --
133: -- {End Of Comments}
134: -- ----------------------------------------------------------------------------
135: Procedure pre_delete(p_rec in hr_wnp_shd.g_rec_type) is
136: --
137: l_proc varchar2(72) := g_package||'pre_delete';
138: --
139: Begin

Line 177: Procedure post_delete(p_rec in hr_wnp_shd.g_rec_type) is

173: -- Internal Row Handler Use Only.
174: --
175: -- {End Of Comments}
176: -- -----------------------------------------------------------------------------
177: Procedure post_delete(p_rec in hr_wnp_shd.g_rec_type) is
178: --
179: l_proc varchar2(72) := g_package||'post_delete';
180: --
181: Begin

Line 189: => hr_wnp_shd.g_old_rec.form_window_id

185: hr_wnp_rkd.after_delete
186: (p_window_property_id
187: => p_rec.window_property_id
188: ,p_form_window_id_o
189: => hr_wnp_shd.g_old_rec.form_window_id
190: ,p_template_window_id_o
191: => hr_wnp_shd.g_old_rec.template_window_id
192: ,p_height_o
193: => hr_wnp_shd.g_old_rec.height

Line 191: => hr_wnp_shd.g_old_rec.template_window_id

187: => p_rec.window_property_id
188: ,p_form_window_id_o
189: => hr_wnp_shd.g_old_rec.form_window_id
190: ,p_template_window_id_o
191: => hr_wnp_shd.g_old_rec.template_window_id
192: ,p_height_o
193: => hr_wnp_shd.g_old_rec.height
194: ,p_width_o
195: => hr_wnp_shd.g_old_rec.width

Line 193: => hr_wnp_shd.g_old_rec.height

189: => hr_wnp_shd.g_old_rec.form_window_id
190: ,p_template_window_id_o
191: => hr_wnp_shd.g_old_rec.template_window_id
192: ,p_height_o
193: => hr_wnp_shd.g_old_rec.height
194: ,p_width_o
195: => hr_wnp_shd.g_old_rec.width
196: ,p_x_position_o
197: => hr_wnp_shd.g_old_rec.x_position

Line 195: => hr_wnp_shd.g_old_rec.width

191: => hr_wnp_shd.g_old_rec.template_window_id
192: ,p_height_o
193: => hr_wnp_shd.g_old_rec.height
194: ,p_width_o
195: => hr_wnp_shd.g_old_rec.width
196: ,p_x_position_o
197: => hr_wnp_shd.g_old_rec.x_position
198: ,p_y_position_o
199: => hr_wnp_shd.g_old_rec.y_position

Line 197: => hr_wnp_shd.g_old_rec.x_position

193: => hr_wnp_shd.g_old_rec.height
194: ,p_width_o
195: => hr_wnp_shd.g_old_rec.width
196: ,p_x_position_o
197: => hr_wnp_shd.g_old_rec.x_position
198: ,p_y_position_o
199: => hr_wnp_shd.g_old_rec.y_position
200: ,p_information_category_o
201: => hr_wnp_shd.g_old_rec.information_category

Line 199: => hr_wnp_shd.g_old_rec.y_position

195: => hr_wnp_shd.g_old_rec.width
196: ,p_x_position_o
197: => hr_wnp_shd.g_old_rec.x_position
198: ,p_y_position_o
199: => hr_wnp_shd.g_old_rec.y_position
200: ,p_information_category_o
201: => hr_wnp_shd.g_old_rec.information_category
202: ,p_information1_o
203: => hr_wnp_shd.g_old_rec.information1

Line 201: => hr_wnp_shd.g_old_rec.information_category

197: => hr_wnp_shd.g_old_rec.x_position
198: ,p_y_position_o
199: => hr_wnp_shd.g_old_rec.y_position
200: ,p_information_category_o
201: => hr_wnp_shd.g_old_rec.information_category
202: ,p_information1_o
203: => hr_wnp_shd.g_old_rec.information1
204: ,p_information2_o
205: => hr_wnp_shd.g_old_rec.information2

Line 203: => hr_wnp_shd.g_old_rec.information1

199: => hr_wnp_shd.g_old_rec.y_position
200: ,p_information_category_o
201: => hr_wnp_shd.g_old_rec.information_category
202: ,p_information1_o
203: => hr_wnp_shd.g_old_rec.information1
204: ,p_information2_o
205: => hr_wnp_shd.g_old_rec.information2
206: ,p_information3_o
207: => hr_wnp_shd.g_old_rec.information3

Line 205: => hr_wnp_shd.g_old_rec.information2

201: => hr_wnp_shd.g_old_rec.information_category
202: ,p_information1_o
203: => hr_wnp_shd.g_old_rec.information1
204: ,p_information2_o
205: => hr_wnp_shd.g_old_rec.information2
206: ,p_information3_o
207: => hr_wnp_shd.g_old_rec.information3
208: ,p_information4_o
209: => hr_wnp_shd.g_old_rec.information4

Line 207: => hr_wnp_shd.g_old_rec.information3

203: => hr_wnp_shd.g_old_rec.information1
204: ,p_information2_o
205: => hr_wnp_shd.g_old_rec.information2
206: ,p_information3_o
207: => hr_wnp_shd.g_old_rec.information3
208: ,p_information4_o
209: => hr_wnp_shd.g_old_rec.information4
210: ,p_information5_o
211: => hr_wnp_shd.g_old_rec.information5

Line 209: => hr_wnp_shd.g_old_rec.information4

205: => hr_wnp_shd.g_old_rec.information2
206: ,p_information3_o
207: => hr_wnp_shd.g_old_rec.information3
208: ,p_information4_o
209: => hr_wnp_shd.g_old_rec.information4
210: ,p_information5_o
211: => hr_wnp_shd.g_old_rec.information5
212: ,p_information6_o
213: => hr_wnp_shd.g_old_rec.information6

Line 211: => hr_wnp_shd.g_old_rec.information5

207: => hr_wnp_shd.g_old_rec.information3
208: ,p_information4_o
209: => hr_wnp_shd.g_old_rec.information4
210: ,p_information5_o
211: => hr_wnp_shd.g_old_rec.information5
212: ,p_information6_o
213: => hr_wnp_shd.g_old_rec.information6
214: ,p_information7_o
215: => hr_wnp_shd.g_old_rec.information7

Line 213: => hr_wnp_shd.g_old_rec.information6

209: => hr_wnp_shd.g_old_rec.information4
210: ,p_information5_o
211: => hr_wnp_shd.g_old_rec.information5
212: ,p_information6_o
213: => hr_wnp_shd.g_old_rec.information6
214: ,p_information7_o
215: => hr_wnp_shd.g_old_rec.information7
216: ,p_information8_o
217: => hr_wnp_shd.g_old_rec.information8

Line 215: => hr_wnp_shd.g_old_rec.information7

211: => hr_wnp_shd.g_old_rec.information5
212: ,p_information6_o
213: => hr_wnp_shd.g_old_rec.information6
214: ,p_information7_o
215: => hr_wnp_shd.g_old_rec.information7
216: ,p_information8_o
217: => hr_wnp_shd.g_old_rec.information8
218: ,p_information9_o
219: => hr_wnp_shd.g_old_rec.information9

Line 217: => hr_wnp_shd.g_old_rec.information8

213: => hr_wnp_shd.g_old_rec.information6
214: ,p_information7_o
215: => hr_wnp_shd.g_old_rec.information7
216: ,p_information8_o
217: => hr_wnp_shd.g_old_rec.information8
218: ,p_information9_o
219: => hr_wnp_shd.g_old_rec.information9
220: ,p_information10_o
221: => hr_wnp_shd.g_old_rec.information10

Line 219: => hr_wnp_shd.g_old_rec.information9

215: => hr_wnp_shd.g_old_rec.information7
216: ,p_information8_o
217: => hr_wnp_shd.g_old_rec.information8
218: ,p_information9_o
219: => hr_wnp_shd.g_old_rec.information9
220: ,p_information10_o
221: => hr_wnp_shd.g_old_rec.information10
222: ,p_information11_o
223: => hr_wnp_shd.g_old_rec.information11

Line 221: => hr_wnp_shd.g_old_rec.information10

217: => hr_wnp_shd.g_old_rec.information8
218: ,p_information9_o
219: => hr_wnp_shd.g_old_rec.information9
220: ,p_information10_o
221: => hr_wnp_shd.g_old_rec.information10
222: ,p_information11_o
223: => hr_wnp_shd.g_old_rec.information11
224: ,p_information12_o
225: => hr_wnp_shd.g_old_rec.information12

Line 223: => hr_wnp_shd.g_old_rec.information11

219: => hr_wnp_shd.g_old_rec.information9
220: ,p_information10_o
221: => hr_wnp_shd.g_old_rec.information10
222: ,p_information11_o
223: => hr_wnp_shd.g_old_rec.information11
224: ,p_information12_o
225: => hr_wnp_shd.g_old_rec.information12
226: ,p_information13_o
227: => hr_wnp_shd.g_old_rec.information13

Line 225: => hr_wnp_shd.g_old_rec.information12

221: => hr_wnp_shd.g_old_rec.information10
222: ,p_information11_o
223: => hr_wnp_shd.g_old_rec.information11
224: ,p_information12_o
225: => hr_wnp_shd.g_old_rec.information12
226: ,p_information13_o
227: => hr_wnp_shd.g_old_rec.information13
228: ,p_information14_o
229: => hr_wnp_shd.g_old_rec.information14

Line 227: => hr_wnp_shd.g_old_rec.information13

223: => hr_wnp_shd.g_old_rec.information11
224: ,p_information12_o
225: => hr_wnp_shd.g_old_rec.information12
226: ,p_information13_o
227: => hr_wnp_shd.g_old_rec.information13
228: ,p_information14_o
229: => hr_wnp_shd.g_old_rec.information14
230: ,p_information15_o
231: => hr_wnp_shd.g_old_rec.information15

Line 229: => hr_wnp_shd.g_old_rec.information14

225: => hr_wnp_shd.g_old_rec.information12
226: ,p_information13_o
227: => hr_wnp_shd.g_old_rec.information13
228: ,p_information14_o
229: => hr_wnp_shd.g_old_rec.information14
230: ,p_information15_o
231: => hr_wnp_shd.g_old_rec.information15
232: ,p_information16_o
233: => hr_wnp_shd.g_old_rec.information16

Line 231: => hr_wnp_shd.g_old_rec.information15

227: => hr_wnp_shd.g_old_rec.information13
228: ,p_information14_o
229: => hr_wnp_shd.g_old_rec.information14
230: ,p_information15_o
231: => hr_wnp_shd.g_old_rec.information15
232: ,p_information16_o
233: => hr_wnp_shd.g_old_rec.information16
234: ,p_information17_o
235: => hr_wnp_shd.g_old_rec.information17

Line 233: => hr_wnp_shd.g_old_rec.information16

229: => hr_wnp_shd.g_old_rec.information14
230: ,p_information15_o
231: => hr_wnp_shd.g_old_rec.information15
232: ,p_information16_o
233: => hr_wnp_shd.g_old_rec.information16
234: ,p_information17_o
235: => hr_wnp_shd.g_old_rec.information17
236: ,p_information18_o
237: => hr_wnp_shd.g_old_rec.information18

Line 235: => hr_wnp_shd.g_old_rec.information17

231: => hr_wnp_shd.g_old_rec.information15
232: ,p_information16_o
233: => hr_wnp_shd.g_old_rec.information16
234: ,p_information17_o
235: => hr_wnp_shd.g_old_rec.information17
236: ,p_information18_o
237: => hr_wnp_shd.g_old_rec.information18
238: ,p_information19_o
239: => hr_wnp_shd.g_old_rec.information19

Line 237: => hr_wnp_shd.g_old_rec.information18

233: => hr_wnp_shd.g_old_rec.information16
234: ,p_information17_o
235: => hr_wnp_shd.g_old_rec.information17
236: ,p_information18_o
237: => hr_wnp_shd.g_old_rec.information18
238: ,p_information19_o
239: => hr_wnp_shd.g_old_rec.information19
240: ,p_information20_o
241: => hr_wnp_shd.g_old_rec.information20

Line 239: => hr_wnp_shd.g_old_rec.information19

235: => hr_wnp_shd.g_old_rec.information17
236: ,p_information18_o
237: => hr_wnp_shd.g_old_rec.information18
238: ,p_information19_o
239: => hr_wnp_shd.g_old_rec.information19
240: ,p_information20_o
241: => hr_wnp_shd.g_old_rec.information20
242: ,p_information21_o
243: => hr_wnp_shd.g_old_rec.information21

Line 241: => hr_wnp_shd.g_old_rec.information20

237: => hr_wnp_shd.g_old_rec.information18
238: ,p_information19_o
239: => hr_wnp_shd.g_old_rec.information19
240: ,p_information20_o
241: => hr_wnp_shd.g_old_rec.information20
242: ,p_information21_o
243: => hr_wnp_shd.g_old_rec.information21
244: ,p_information22_o
245: => hr_wnp_shd.g_old_rec.information22

Line 243: => hr_wnp_shd.g_old_rec.information21

239: => hr_wnp_shd.g_old_rec.information19
240: ,p_information20_o
241: => hr_wnp_shd.g_old_rec.information20
242: ,p_information21_o
243: => hr_wnp_shd.g_old_rec.information21
244: ,p_information22_o
245: => hr_wnp_shd.g_old_rec.information22
246: ,p_information23_o
247: => hr_wnp_shd.g_old_rec.information23

Line 245: => hr_wnp_shd.g_old_rec.information22

241: => hr_wnp_shd.g_old_rec.information20
242: ,p_information21_o
243: => hr_wnp_shd.g_old_rec.information21
244: ,p_information22_o
245: => hr_wnp_shd.g_old_rec.information22
246: ,p_information23_o
247: => hr_wnp_shd.g_old_rec.information23
248: ,p_information24_o
249: => hr_wnp_shd.g_old_rec.information24

Line 247: => hr_wnp_shd.g_old_rec.information23

243: => hr_wnp_shd.g_old_rec.information21
244: ,p_information22_o
245: => hr_wnp_shd.g_old_rec.information22
246: ,p_information23_o
247: => hr_wnp_shd.g_old_rec.information23
248: ,p_information24_o
249: => hr_wnp_shd.g_old_rec.information24
250: ,p_information25_o
251: => hr_wnp_shd.g_old_rec.information25

Line 249: => hr_wnp_shd.g_old_rec.information24

245: => hr_wnp_shd.g_old_rec.information22
246: ,p_information23_o
247: => hr_wnp_shd.g_old_rec.information23
248: ,p_information24_o
249: => hr_wnp_shd.g_old_rec.information24
250: ,p_information25_o
251: => hr_wnp_shd.g_old_rec.information25
252: ,p_information26_o
253: => hr_wnp_shd.g_old_rec.information26

Line 251: => hr_wnp_shd.g_old_rec.information25

247: => hr_wnp_shd.g_old_rec.information23
248: ,p_information24_o
249: => hr_wnp_shd.g_old_rec.information24
250: ,p_information25_o
251: => hr_wnp_shd.g_old_rec.information25
252: ,p_information26_o
253: => hr_wnp_shd.g_old_rec.information26
254: ,p_information27_o
255: => hr_wnp_shd.g_old_rec.information27

Line 253: => hr_wnp_shd.g_old_rec.information26

249: => hr_wnp_shd.g_old_rec.information24
250: ,p_information25_o
251: => hr_wnp_shd.g_old_rec.information25
252: ,p_information26_o
253: => hr_wnp_shd.g_old_rec.information26
254: ,p_information27_o
255: => hr_wnp_shd.g_old_rec.information27
256: ,p_information28_o
257: => hr_wnp_shd.g_old_rec.information28

Line 255: => hr_wnp_shd.g_old_rec.information27

251: => hr_wnp_shd.g_old_rec.information25
252: ,p_information26_o
253: => hr_wnp_shd.g_old_rec.information26
254: ,p_information27_o
255: => hr_wnp_shd.g_old_rec.information27
256: ,p_information28_o
257: => hr_wnp_shd.g_old_rec.information28
258: ,p_information29_o
259: => hr_wnp_shd.g_old_rec.information29

Line 257: => hr_wnp_shd.g_old_rec.information28

253: => hr_wnp_shd.g_old_rec.information26
254: ,p_information27_o
255: => hr_wnp_shd.g_old_rec.information27
256: ,p_information28_o
257: => hr_wnp_shd.g_old_rec.information28
258: ,p_information29_o
259: => hr_wnp_shd.g_old_rec.information29
260: ,p_information30_o
261: => hr_wnp_shd.g_old_rec.information30

Line 259: => hr_wnp_shd.g_old_rec.information29

255: => hr_wnp_shd.g_old_rec.information27
256: ,p_information28_o
257: => hr_wnp_shd.g_old_rec.information28
258: ,p_information29_o
259: => hr_wnp_shd.g_old_rec.information29
260: ,p_information30_o
261: => hr_wnp_shd.g_old_rec.information30
262: );
263: --

Line 261: => hr_wnp_shd.g_old_rec.information30

257: => hr_wnp_shd.g_old_rec.information28
258: ,p_information29_o
259: => hr_wnp_shd.g_old_rec.information29
260: ,p_information30_o
261: => hr_wnp_shd.g_old_rec.information30
262: );
263: --
264: exception
265: --

Line 281: (p_rec in hr_wnp_shd.g_rec_type

277: -- ----------------------------------------------------------------------------
278: -- |---------------------------------< del >----------------------------------|
279: -- ----------------------------------------------------------------------------
280: Procedure del
281: (p_rec in hr_wnp_shd.g_rec_type
282: ) is
283: --
284: l_proc varchar2(72) := g_package||'del';
285: --

Line 291: hr_wnp_shd.lck

287: hr_utility.set_location('Entering:'||l_proc, 5);
288: --
289: -- We must lock the row which we need to delete.
290: --
291: hr_wnp_shd.lck
292: (p_rec.window_property_id
293: );
294: --
295: -- Call the supporting delete validate operation

Line 320: l_rec hr_wnp_shd.g_rec_type;

316: Procedure del
317: (p_window_property_id in number
318: ) is
319: --
320: l_rec hr_wnp_shd.g_rec_type;
321: l_proc varchar2(72) := g_package||'del';
322: --
323: Begin
324: hr_utility.set_location('Entering:'||l_proc, 5);