APPS.HR_TPP_DEL dependencies on HR_TPP_SHD

Line 52: (p_rec in hr_tpp_shd.g_rec_type

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

Line 95: hr_tpp_shd.constraint_error

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

Line 134: Procedure pre_delete(p_rec in hr_tpp_shd.g_rec_type) is

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

Line 176: Procedure post_delete(p_rec in hr_tpp_shd.g_rec_type) is

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

Line 188: => hr_tpp_shd.g_old_rec.object_version_number

184: hr_tpp_rkd.after_delete
185: (p_tab_page_property_id
186: => p_rec.tab_page_property_id
187: ,p_object_version_number_o
188: => hr_tpp_shd.g_old_rec.object_version_number
189: ,p_form_tab_page_id_o
190: => hr_tpp_shd.g_old_rec.form_tab_page_id
191: ,p_template_tab_page_id_o
192: => hr_tpp_shd.g_old_rec.template_tab_page_id

Line 190: => hr_tpp_shd.g_old_rec.form_tab_page_id

186: => p_rec.tab_page_property_id
187: ,p_object_version_number_o
188: => hr_tpp_shd.g_old_rec.object_version_number
189: ,p_form_tab_page_id_o
190: => hr_tpp_shd.g_old_rec.form_tab_page_id
191: ,p_template_tab_page_id_o
192: => hr_tpp_shd.g_old_rec.template_tab_page_id
193: ,p_navigation_direction_o
194: => hr_tpp_shd.g_old_rec.navigation_direction

Line 192: => hr_tpp_shd.g_old_rec.template_tab_page_id

188: => hr_tpp_shd.g_old_rec.object_version_number
189: ,p_form_tab_page_id_o
190: => hr_tpp_shd.g_old_rec.form_tab_page_id
191: ,p_template_tab_page_id_o
192: => hr_tpp_shd.g_old_rec.template_tab_page_id
193: ,p_navigation_direction_o
194: => hr_tpp_shd.g_old_rec.navigation_direction
195: ,p_visible_o
196: => hr_tpp_shd.g_old_rec.visible

Line 194: => hr_tpp_shd.g_old_rec.navigation_direction

190: => hr_tpp_shd.g_old_rec.form_tab_page_id
191: ,p_template_tab_page_id_o
192: => hr_tpp_shd.g_old_rec.template_tab_page_id
193: ,p_navigation_direction_o
194: => hr_tpp_shd.g_old_rec.navigation_direction
195: ,p_visible_o
196: => hr_tpp_shd.g_old_rec.visible
197: ,p_information_category_o
198: => hr_tpp_shd.g_old_rec.information_category

Line 196: => hr_tpp_shd.g_old_rec.visible

192: => hr_tpp_shd.g_old_rec.template_tab_page_id
193: ,p_navigation_direction_o
194: => hr_tpp_shd.g_old_rec.navigation_direction
195: ,p_visible_o
196: => hr_tpp_shd.g_old_rec.visible
197: ,p_information_category_o
198: => hr_tpp_shd.g_old_rec.information_category
199: ,p_information1_o
200: => hr_tpp_shd.g_old_rec.information1

Line 198: => hr_tpp_shd.g_old_rec.information_category

194: => hr_tpp_shd.g_old_rec.navigation_direction
195: ,p_visible_o
196: => hr_tpp_shd.g_old_rec.visible
197: ,p_information_category_o
198: => hr_tpp_shd.g_old_rec.information_category
199: ,p_information1_o
200: => hr_tpp_shd.g_old_rec.information1
201: ,p_information2_o
202: => hr_tpp_shd.g_old_rec.information2

Line 200: => hr_tpp_shd.g_old_rec.information1

196: => hr_tpp_shd.g_old_rec.visible
197: ,p_information_category_o
198: => hr_tpp_shd.g_old_rec.information_category
199: ,p_information1_o
200: => hr_tpp_shd.g_old_rec.information1
201: ,p_information2_o
202: => hr_tpp_shd.g_old_rec.information2
203: ,p_information3_o
204: => hr_tpp_shd.g_old_rec.information3

Line 202: => hr_tpp_shd.g_old_rec.information2

198: => hr_tpp_shd.g_old_rec.information_category
199: ,p_information1_o
200: => hr_tpp_shd.g_old_rec.information1
201: ,p_information2_o
202: => hr_tpp_shd.g_old_rec.information2
203: ,p_information3_o
204: => hr_tpp_shd.g_old_rec.information3
205: ,p_information4_o
206: => hr_tpp_shd.g_old_rec.information4

Line 204: => hr_tpp_shd.g_old_rec.information3

200: => hr_tpp_shd.g_old_rec.information1
201: ,p_information2_o
202: => hr_tpp_shd.g_old_rec.information2
203: ,p_information3_o
204: => hr_tpp_shd.g_old_rec.information3
205: ,p_information4_o
206: => hr_tpp_shd.g_old_rec.information4
207: ,p_information5_o
208: => hr_tpp_shd.g_old_rec.information5

Line 206: => hr_tpp_shd.g_old_rec.information4

202: => hr_tpp_shd.g_old_rec.information2
203: ,p_information3_o
204: => hr_tpp_shd.g_old_rec.information3
205: ,p_information4_o
206: => hr_tpp_shd.g_old_rec.information4
207: ,p_information5_o
208: => hr_tpp_shd.g_old_rec.information5
209: ,p_information6_o
210: => hr_tpp_shd.g_old_rec.information6

Line 208: => hr_tpp_shd.g_old_rec.information5

204: => hr_tpp_shd.g_old_rec.information3
205: ,p_information4_o
206: => hr_tpp_shd.g_old_rec.information4
207: ,p_information5_o
208: => hr_tpp_shd.g_old_rec.information5
209: ,p_information6_o
210: => hr_tpp_shd.g_old_rec.information6
211: ,p_information7_o
212: => hr_tpp_shd.g_old_rec.information7

Line 210: => hr_tpp_shd.g_old_rec.information6

206: => hr_tpp_shd.g_old_rec.information4
207: ,p_information5_o
208: => hr_tpp_shd.g_old_rec.information5
209: ,p_information6_o
210: => hr_tpp_shd.g_old_rec.information6
211: ,p_information7_o
212: => hr_tpp_shd.g_old_rec.information7
213: ,p_information8_o
214: => hr_tpp_shd.g_old_rec.information8

Line 212: => hr_tpp_shd.g_old_rec.information7

208: => hr_tpp_shd.g_old_rec.information5
209: ,p_information6_o
210: => hr_tpp_shd.g_old_rec.information6
211: ,p_information7_o
212: => hr_tpp_shd.g_old_rec.information7
213: ,p_information8_o
214: => hr_tpp_shd.g_old_rec.information8
215: ,p_information9_o
216: => hr_tpp_shd.g_old_rec.information9

Line 214: => hr_tpp_shd.g_old_rec.information8

210: => hr_tpp_shd.g_old_rec.information6
211: ,p_information7_o
212: => hr_tpp_shd.g_old_rec.information7
213: ,p_information8_o
214: => hr_tpp_shd.g_old_rec.information8
215: ,p_information9_o
216: => hr_tpp_shd.g_old_rec.information9
217: ,p_information10_o
218: => hr_tpp_shd.g_old_rec.information10

Line 216: => hr_tpp_shd.g_old_rec.information9

212: => hr_tpp_shd.g_old_rec.information7
213: ,p_information8_o
214: => hr_tpp_shd.g_old_rec.information8
215: ,p_information9_o
216: => hr_tpp_shd.g_old_rec.information9
217: ,p_information10_o
218: => hr_tpp_shd.g_old_rec.information10
219: ,p_information11_o
220: => hr_tpp_shd.g_old_rec.information11

Line 218: => hr_tpp_shd.g_old_rec.information10

214: => hr_tpp_shd.g_old_rec.information8
215: ,p_information9_o
216: => hr_tpp_shd.g_old_rec.information9
217: ,p_information10_o
218: => hr_tpp_shd.g_old_rec.information10
219: ,p_information11_o
220: => hr_tpp_shd.g_old_rec.information11
221: ,p_information12_o
222: => hr_tpp_shd.g_old_rec.information12

Line 220: => hr_tpp_shd.g_old_rec.information11

216: => hr_tpp_shd.g_old_rec.information9
217: ,p_information10_o
218: => hr_tpp_shd.g_old_rec.information10
219: ,p_information11_o
220: => hr_tpp_shd.g_old_rec.information11
221: ,p_information12_o
222: => hr_tpp_shd.g_old_rec.information12
223: ,p_information13_o
224: => hr_tpp_shd.g_old_rec.information13

Line 222: => hr_tpp_shd.g_old_rec.information12

218: => hr_tpp_shd.g_old_rec.information10
219: ,p_information11_o
220: => hr_tpp_shd.g_old_rec.information11
221: ,p_information12_o
222: => hr_tpp_shd.g_old_rec.information12
223: ,p_information13_o
224: => hr_tpp_shd.g_old_rec.information13
225: ,p_information14_o
226: => hr_tpp_shd.g_old_rec.information14

Line 224: => hr_tpp_shd.g_old_rec.information13

220: => hr_tpp_shd.g_old_rec.information11
221: ,p_information12_o
222: => hr_tpp_shd.g_old_rec.information12
223: ,p_information13_o
224: => hr_tpp_shd.g_old_rec.information13
225: ,p_information14_o
226: => hr_tpp_shd.g_old_rec.information14
227: ,p_information15_o
228: => hr_tpp_shd.g_old_rec.information15

Line 226: => hr_tpp_shd.g_old_rec.information14

222: => hr_tpp_shd.g_old_rec.information12
223: ,p_information13_o
224: => hr_tpp_shd.g_old_rec.information13
225: ,p_information14_o
226: => hr_tpp_shd.g_old_rec.information14
227: ,p_information15_o
228: => hr_tpp_shd.g_old_rec.information15
229: ,p_information16_o
230: => hr_tpp_shd.g_old_rec.information16

Line 228: => hr_tpp_shd.g_old_rec.information15

224: => hr_tpp_shd.g_old_rec.information13
225: ,p_information14_o
226: => hr_tpp_shd.g_old_rec.information14
227: ,p_information15_o
228: => hr_tpp_shd.g_old_rec.information15
229: ,p_information16_o
230: => hr_tpp_shd.g_old_rec.information16
231: ,p_information17_o
232: => hr_tpp_shd.g_old_rec.information17

Line 230: => hr_tpp_shd.g_old_rec.information16

226: => hr_tpp_shd.g_old_rec.information14
227: ,p_information15_o
228: => hr_tpp_shd.g_old_rec.information15
229: ,p_information16_o
230: => hr_tpp_shd.g_old_rec.information16
231: ,p_information17_o
232: => hr_tpp_shd.g_old_rec.information17
233: ,p_information18_o
234: => hr_tpp_shd.g_old_rec.information18

Line 232: => hr_tpp_shd.g_old_rec.information17

228: => hr_tpp_shd.g_old_rec.information15
229: ,p_information16_o
230: => hr_tpp_shd.g_old_rec.information16
231: ,p_information17_o
232: => hr_tpp_shd.g_old_rec.information17
233: ,p_information18_o
234: => hr_tpp_shd.g_old_rec.information18
235: ,p_information19_o
236: => hr_tpp_shd.g_old_rec.information19

Line 234: => hr_tpp_shd.g_old_rec.information18

230: => hr_tpp_shd.g_old_rec.information16
231: ,p_information17_o
232: => hr_tpp_shd.g_old_rec.information17
233: ,p_information18_o
234: => hr_tpp_shd.g_old_rec.information18
235: ,p_information19_o
236: => hr_tpp_shd.g_old_rec.information19
237: ,p_information20_o
238: => hr_tpp_shd.g_old_rec.information20

Line 236: => hr_tpp_shd.g_old_rec.information19

232: => hr_tpp_shd.g_old_rec.information17
233: ,p_information18_o
234: => hr_tpp_shd.g_old_rec.information18
235: ,p_information19_o
236: => hr_tpp_shd.g_old_rec.information19
237: ,p_information20_o
238: => hr_tpp_shd.g_old_rec.information20
239: ,p_information21_o
240: => hr_tpp_shd.g_old_rec.information21

Line 238: => hr_tpp_shd.g_old_rec.information20

234: => hr_tpp_shd.g_old_rec.information18
235: ,p_information19_o
236: => hr_tpp_shd.g_old_rec.information19
237: ,p_information20_o
238: => hr_tpp_shd.g_old_rec.information20
239: ,p_information21_o
240: => hr_tpp_shd.g_old_rec.information21
241: ,p_information22_o
242: => hr_tpp_shd.g_old_rec.information22

Line 240: => hr_tpp_shd.g_old_rec.information21

236: => hr_tpp_shd.g_old_rec.information19
237: ,p_information20_o
238: => hr_tpp_shd.g_old_rec.information20
239: ,p_information21_o
240: => hr_tpp_shd.g_old_rec.information21
241: ,p_information22_o
242: => hr_tpp_shd.g_old_rec.information22
243: ,p_information23_o
244: => hr_tpp_shd.g_old_rec.information23

Line 242: => hr_tpp_shd.g_old_rec.information22

238: => hr_tpp_shd.g_old_rec.information20
239: ,p_information21_o
240: => hr_tpp_shd.g_old_rec.information21
241: ,p_information22_o
242: => hr_tpp_shd.g_old_rec.information22
243: ,p_information23_o
244: => hr_tpp_shd.g_old_rec.information23
245: ,p_information24_o
246: => hr_tpp_shd.g_old_rec.information24

Line 244: => hr_tpp_shd.g_old_rec.information23

240: => hr_tpp_shd.g_old_rec.information21
241: ,p_information22_o
242: => hr_tpp_shd.g_old_rec.information22
243: ,p_information23_o
244: => hr_tpp_shd.g_old_rec.information23
245: ,p_information24_o
246: => hr_tpp_shd.g_old_rec.information24
247: ,p_information25_o
248: => hr_tpp_shd.g_old_rec.information25

Line 246: => hr_tpp_shd.g_old_rec.information24

242: => hr_tpp_shd.g_old_rec.information22
243: ,p_information23_o
244: => hr_tpp_shd.g_old_rec.information23
245: ,p_information24_o
246: => hr_tpp_shd.g_old_rec.information24
247: ,p_information25_o
248: => hr_tpp_shd.g_old_rec.information25
249: ,p_information26_o
250: => hr_tpp_shd.g_old_rec.information26

Line 248: => hr_tpp_shd.g_old_rec.information25

244: => hr_tpp_shd.g_old_rec.information23
245: ,p_information24_o
246: => hr_tpp_shd.g_old_rec.information24
247: ,p_information25_o
248: => hr_tpp_shd.g_old_rec.information25
249: ,p_information26_o
250: => hr_tpp_shd.g_old_rec.information26
251: ,p_information27_o
252: => hr_tpp_shd.g_old_rec.information27

Line 250: => hr_tpp_shd.g_old_rec.information26

246: => hr_tpp_shd.g_old_rec.information24
247: ,p_information25_o
248: => hr_tpp_shd.g_old_rec.information25
249: ,p_information26_o
250: => hr_tpp_shd.g_old_rec.information26
251: ,p_information27_o
252: => hr_tpp_shd.g_old_rec.information27
253: ,p_information28_o
254: => hr_tpp_shd.g_old_rec.information28

Line 252: => hr_tpp_shd.g_old_rec.information27

248: => hr_tpp_shd.g_old_rec.information25
249: ,p_information26_o
250: => hr_tpp_shd.g_old_rec.information26
251: ,p_information27_o
252: => hr_tpp_shd.g_old_rec.information27
253: ,p_information28_o
254: => hr_tpp_shd.g_old_rec.information28
255: ,p_information29_o
256: => hr_tpp_shd.g_old_rec.information29

Line 254: => hr_tpp_shd.g_old_rec.information28

250: => hr_tpp_shd.g_old_rec.information26
251: ,p_information27_o
252: => hr_tpp_shd.g_old_rec.information27
253: ,p_information28_o
254: => hr_tpp_shd.g_old_rec.information28
255: ,p_information29_o
256: => hr_tpp_shd.g_old_rec.information29
257: ,p_information30_o
258: => hr_tpp_shd.g_old_rec.information30

Line 256: => hr_tpp_shd.g_old_rec.information29

252: => hr_tpp_shd.g_old_rec.information27
253: ,p_information28_o
254: => hr_tpp_shd.g_old_rec.information28
255: ,p_information29_o
256: => hr_tpp_shd.g_old_rec.information29
257: ,p_information30_o
258: => hr_tpp_shd.g_old_rec.information30
259: );
260: --

Line 258: => hr_tpp_shd.g_old_rec.information30

254: => hr_tpp_shd.g_old_rec.information28
255: ,p_information29_o
256: => hr_tpp_shd.g_old_rec.information29
257: ,p_information30_o
258: => hr_tpp_shd.g_old_rec.information30
259: );
260: --
261: exception
262: --

Line 278: (p_rec in hr_tpp_shd.g_rec_type

274: -- ----------------------------------------------------------------------------
275: -- |---------------------------------< del >----------------------------------|
276: -- ----------------------------------------------------------------------------
277: Procedure del
278: (p_rec in hr_tpp_shd.g_rec_type
279: ) is
280: --
281: l_proc varchar2(72) := g_package||'del';
282: --

Line 288: hr_tpp_shd.lck

284: hr_utility.set_location('Entering:'||l_proc, 5);
285: --
286: -- We must lock the row which we need to delete.
287: --
288: hr_tpp_shd.lck
289: (p_rec.tab_page_property_id
290: ,p_rec.object_version_number
291: );
292: --

Line 319: l_rec hr_tpp_shd.g_rec_type;

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