APPS.PQH_ACC_DEL dependencies on PQH_ACC_SHD

Line 54: (p_rec in out nocopy pqh_acc_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy pqh_acc_shd.g_rec_type
55: ,p_effective_date in date
56: ,p_datetrack_mode in varchar2
57: ,p_validation_start_date in date
58: ,p_validation_end_date in date

Line 97: (p_rec in out nocopy pqh_acc_shd.g_rec_type

93: -- ----------------------------------------------------------------------------
94: -- |------------------------------< delete_dml >------------------------------|
95: -- ----------------------------------------------------------------------------
96: Procedure delete_dml
97: (p_rec in out nocopy pqh_acc_shd.g_rec_type
98: ,p_effective_date in date
99: ,p_datetrack_mode in varchar2
100: ,p_validation_start_date in date
101: ,p_validation_end_date in date

Line 154: (p_rec in out nocopy pqh_acc_shd.g_rec_type

150: --
151: -- {End Of Comments}
152: -- ----------------------------------------------------------------------------
153: Procedure dt_pre_delete
154: (p_rec in out nocopy pqh_acc_shd.g_rec_type
155: ,p_effective_date in date
156: ,p_datetrack_mode in varchar2
157: ,p_validation_start_date in date
158: ,p_validation_end_date in date

Line 169: := pqh_acc_shd.g_old_rec.effective_start_date;

165: --
166: If (p_datetrack_mode <> hr_api.g_zap) then
167: --
168: p_rec.effective_start_date
169: := pqh_acc_shd.g_old_rec.effective_start_date;
170: --
171: If (p_datetrack_mode = hr_api.g_delete) then
172: p_rec.effective_end_date := p_validation_start_date - 1;
173: Else

Line 179: pqh_acc_shd.upd_effective_end_date

175: End If;
176: --
177: -- Update the current effective end date record
178: --
179: pqh_acc_shd.upd_effective_end_date
180: (p_effective_date => p_effective_date
181: ,p_base_key_value => p_rec.accommodation_id
182: ,p_new_effective_end_date => p_rec.effective_end_date
183: ,p_validation_start_date => p_validation_start_date

Line 228: (p_rec in out nocopy pqh_acc_shd.g_rec_type

224: --
225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure pre_delete
228: (p_rec in out nocopy pqh_acc_shd.g_rec_type
229: ,p_effective_date in date
230: ,p_datetrack_mode in varchar2
231: ,p_validation_start_date in date
232: ,p_validation_end_date in date

Line 288: (p_rec in pqh_acc_shd.g_rec_type

284: --
285: -- {End Of Comments}
286: -- ----------------------------------------------------------------------------
287: Procedure post_delete
288: (p_rec in pqh_acc_shd.g_rec_type
289: ,p_effective_date in date
290: ,p_datetrack_mode in varchar2
291: ,p_validation_start_date in date
292: ,p_validation_end_date in date

Line 317: => pqh_acc_shd.g_old_rec.accommodation_name

313: => p_rec.effective_start_date
314: ,p_effective_end_date
315: => p_rec.effective_end_date
316: ,p_accommodation_name_o
317: => pqh_acc_shd.g_old_rec.accommodation_name
318: ,p_effective_start_date_o
319: => pqh_acc_shd.g_old_rec.effective_start_date
320: ,p_effective_end_date_o
321: => pqh_acc_shd.g_old_rec.effective_end_date

Line 319: => pqh_acc_shd.g_old_rec.effective_start_date

315: => p_rec.effective_end_date
316: ,p_accommodation_name_o
317: => pqh_acc_shd.g_old_rec.accommodation_name
318: ,p_effective_start_date_o
319: => pqh_acc_shd.g_old_rec.effective_start_date
320: ,p_effective_end_date_o
321: => pqh_acc_shd.g_old_rec.effective_end_date
322: ,p_business_group_id_o
323: => pqh_acc_shd.g_old_rec.business_group_id

Line 321: => pqh_acc_shd.g_old_rec.effective_end_date

317: => pqh_acc_shd.g_old_rec.accommodation_name
318: ,p_effective_start_date_o
319: => pqh_acc_shd.g_old_rec.effective_start_date
320: ,p_effective_end_date_o
321: => pqh_acc_shd.g_old_rec.effective_end_date
322: ,p_business_group_id_o
323: => pqh_acc_shd.g_old_rec.business_group_id
324: ,p_location_id_o
325: => pqh_acc_shd.g_old_rec.location_id

Line 323: => pqh_acc_shd.g_old_rec.business_group_id

319: => pqh_acc_shd.g_old_rec.effective_start_date
320: ,p_effective_end_date_o
321: => pqh_acc_shd.g_old_rec.effective_end_date
322: ,p_business_group_id_o
323: => pqh_acc_shd.g_old_rec.business_group_id
324: ,p_location_id_o
325: => pqh_acc_shd.g_old_rec.location_id
326: ,p_accommodation_desc_o
327: => pqh_acc_shd.g_old_rec.accommodation_desc

Line 325: => pqh_acc_shd.g_old_rec.location_id

321: => pqh_acc_shd.g_old_rec.effective_end_date
322: ,p_business_group_id_o
323: => pqh_acc_shd.g_old_rec.business_group_id
324: ,p_location_id_o
325: => pqh_acc_shd.g_old_rec.location_id
326: ,p_accommodation_desc_o
327: => pqh_acc_shd.g_old_rec.accommodation_desc
328: ,p_accommodation_type_o
329: => pqh_acc_shd.g_old_rec.accommodation_type

Line 327: => pqh_acc_shd.g_old_rec.accommodation_desc

323: => pqh_acc_shd.g_old_rec.business_group_id
324: ,p_location_id_o
325: => pqh_acc_shd.g_old_rec.location_id
326: ,p_accommodation_desc_o
327: => pqh_acc_shd.g_old_rec.accommodation_desc
328: ,p_accommodation_type_o
329: => pqh_acc_shd.g_old_rec.accommodation_type
330: ,p_style_o
331: => pqh_acc_shd.g_old_rec.style

Line 329: => pqh_acc_shd.g_old_rec.accommodation_type

325: => pqh_acc_shd.g_old_rec.location_id
326: ,p_accommodation_desc_o
327: => pqh_acc_shd.g_old_rec.accommodation_desc
328: ,p_accommodation_type_o
329: => pqh_acc_shd.g_old_rec.accommodation_type
330: ,p_style_o
331: => pqh_acc_shd.g_old_rec.style
332: ,p_address_line_1_o
333: => pqh_acc_shd.g_old_rec.address_line_1

Line 331: => pqh_acc_shd.g_old_rec.style

327: => pqh_acc_shd.g_old_rec.accommodation_desc
328: ,p_accommodation_type_o
329: => pqh_acc_shd.g_old_rec.accommodation_type
330: ,p_style_o
331: => pqh_acc_shd.g_old_rec.style
332: ,p_address_line_1_o
333: => pqh_acc_shd.g_old_rec.address_line_1
334: ,p_address_line_2_o
335: => pqh_acc_shd.g_old_rec.address_line_2

Line 333: => pqh_acc_shd.g_old_rec.address_line_1

329: => pqh_acc_shd.g_old_rec.accommodation_type
330: ,p_style_o
331: => pqh_acc_shd.g_old_rec.style
332: ,p_address_line_1_o
333: => pqh_acc_shd.g_old_rec.address_line_1
334: ,p_address_line_2_o
335: => pqh_acc_shd.g_old_rec.address_line_2
336: ,p_address_line_3_o
337: => pqh_acc_shd.g_old_rec.address_line_3

Line 335: => pqh_acc_shd.g_old_rec.address_line_2

331: => pqh_acc_shd.g_old_rec.style
332: ,p_address_line_1_o
333: => pqh_acc_shd.g_old_rec.address_line_1
334: ,p_address_line_2_o
335: => pqh_acc_shd.g_old_rec.address_line_2
336: ,p_address_line_3_o
337: => pqh_acc_shd.g_old_rec.address_line_3
338: ,p_town_or_city_o
339: => pqh_acc_shd.g_old_rec.town_or_city

Line 337: => pqh_acc_shd.g_old_rec.address_line_3

333: => pqh_acc_shd.g_old_rec.address_line_1
334: ,p_address_line_2_o
335: => pqh_acc_shd.g_old_rec.address_line_2
336: ,p_address_line_3_o
337: => pqh_acc_shd.g_old_rec.address_line_3
338: ,p_town_or_city_o
339: => pqh_acc_shd.g_old_rec.town_or_city
340: ,p_country_o
341: => pqh_acc_shd.g_old_rec.country

Line 339: => pqh_acc_shd.g_old_rec.town_or_city

335: => pqh_acc_shd.g_old_rec.address_line_2
336: ,p_address_line_3_o
337: => pqh_acc_shd.g_old_rec.address_line_3
338: ,p_town_or_city_o
339: => pqh_acc_shd.g_old_rec.town_or_city
340: ,p_country_o
341: => pqh_acc_shd.g_old_rec.country
342: ,p_postal_code_o
343: => pqh_acc_shd.g_old_rec.postal_code

Line 341: => pqh_acc_shd.g_old_rec.country

337: => pqh_acc_shd.g_old_rec.address_line_3
338: ,p_town_or_city_o
339: => pqh_acc_shd.g_old_rec.town_or_city
340: ,p_country_o
341: => pqh_acc_shd.g_old_rec.country
342: ,p_postal_code_o
343: => pqh_acc_shd.g_old_rec.postal_code
344: ,p_region_1_o
345: => pqh_acc_shd.g_old_rec.region_1

Line 343: => pqh_acc_shd.g_old_rec.postal_code

339: => pqh_acc_shd.g_old_rec.town_or_city
340: ,p_country_o
341: => pqh_acc_shd.g_old_rec.country
342: ,p_postal_code_o
343: => pqh_acc_shd.g_old_rec.postal_code
344: ,p_region_1_o
345: => pqh_acc_shd.g_old_rec.region_1
346: ,p_region_2_o
347: => pqh_acc_shd.g_old_rec.region_2

Line 345: => pqh_acc_shd.g_old_rec.region_1

341: => pqh_acc_shd.g_old_rec.country
342: ,p_postal_code_o
343: => pqh_acc_shd.g_old_rec.postal_code
344: ,p_region_1_o
345: => pqh_acc_shd.g_old_rec.region_1
346: ,p_region_2_o
347: => pqh_acc_shd.g_old_rec.region_2
348: ,p_region_3_o
349: => pqh_acc_shd.g_old_rec.region_3

Line 347: => pqh_acc_shd.g_old_rec.region_2

343: => pqh_acc_shd.g_old_rec.postal_code
344: ,p_region_1_o
345: => pqh_acc_shd.g_old_rec.region_1
346: ,p_region_2_o
347: => pqh_acc_shd.g_old_rec.region_2
348: ,p_region_3_o
349: => pqh_acc_shd.g_old_rec.region_3
350: ,p_telephone_number_1_o
351: => pqh_acc_shd.g_old_rec.telephone_number_1

Line 349: => pqh_acc_shd.g_old_rec.region_3

345: => pqh_acc_shd.g_old_rec.region_1
346: ,p_region_2_o
347: => pqh_acc_shd.g_old_rec.region_2
348: ,p_region_3_o
349: => pqh_acc_shd.g_old_rec.region_3
350: ,p_telephone_number_1_o
351: => pqh_acc_shd.g_old_rec.telephone_number_1
352: ,p_telephone_number_2_o
353: => pqh_acc_shd.g_old_rec.telephone_number_2

Line 351: => pqh_acc_shd.g_old_rec.telephone_number_1

347: => pqh_acc_shd.g_old_rec.region_2
348: ,p_region_3_o
349: => pqh_acc_shd.g_old_rec.region_3
350: ,p_telephone_number_1_o
351: => pqh_acc_shd.g_old_rec.telephone_number_1
352: ,p_telephone_number_2_o
353: => pqh_acc_shd.g_old_rec.telephone_number_2
354: ,p_telephone_number_3_o
355: => pqh_acc_shd.g_old_rec.telephone_number_3

Line 353: => pqh_acc_shd.g_old_rec.telephone_number_2

349: => pqh_acc_shd.g_old_rec.region_3
350: ,p_telephone_number_1_o
351: => pqh_acc_shd.g_old_rec.telephone_number_1
352: ,p_telephone_number_2_o
353: => pqh_acc_shd.g_old_rec.telephone_number_2
354: ,p_telephone_number_3_o
355: => pqh_acc_shd.g_old_rec.telephone_number_3
356: ,p_floor_number_o
357: => pqh_acc_shd.g_old_rec.floor_number

Line 355: => pqh_acc_shd.g_old_rec.telephone_number_3

351: => pqh_acc_shd.g_old_rec.telephone_number_1
352: ,p_telephone_number_2_o
353: => pqh_acc_shd.g_old_rec.telephone_number_2
354: ,p_telephone_number_3_o
355: => pqh_acc_shd.g_old_rec.telephone_number_3
356: ,p_floor_number_o
357: => pqh_acc_shd.g_old_rec.floor_number
358: ,p_floor_area_o
359: => pqh_acc_shd.g_old_rec.floor_area

Line 357: => pqh_acc_shd.g_old_rec.floor_number

353: => pqh_acc_shd.g_old_rec.telephone_number_2
354: ,p_telephone_number_3_o
355: => pqh_acc_shd.g_old_rec.telephone_number_3
356: ,p_floor_number_o
357: => pqh_acc_shd.g_old_rec.floor_number
358: ,p_floor_area_o
359: => pqh_acc_shd.g_old_rec.floor_area
360: ,p_floor_area_measure_unit_o
361: => pqh_acc_shd.g_old_rec.floor_area_measure_unit

Line 359: => pqh_acc_shd.g_old_rec.floor_area

355: => pqh_acc_shd.g_old_rec.telephone_number_3
356: ,p_floor_number_o
357: => pqh_acc_shd.g_old_rec.floor_number
358: ,p_floor_area_o
359: => pqh_acc_shd.g_old_rec.floor_area
360: ,p_floor_area_measure_unit_o
361: => pqh_acc_shd.g_old_rec.floor_area_measure_unit
362: ,p_main_rooms_o
363: => pqh_acc_shd.g_old_rec.main_rooms

Line 361: => pqh_acc_shd.g_old_rec.floor_area_measure_unit

357: => pqh_acc_shd.g_old_rec.floor_number
358: ,p_floor_area_o
359: => pqh_acc_shd.g_old_rec.floor_area
360: ,p_floor_area_measure_unit_o
361: => pqh_acc_shd.g_old_rec.floor_area_measure_unit
362: ,p_main_rooms_o
363: => pqh_acc_shd.g_old_rec.main_rooms
364: ,p_family_size_o
365: => pqh_acc_shd.g_old_rec.family_size

Line 363: => pqh_acc_shd.g_old_rec.main_rooms

359: => pqh_acc_shd.g_old_rec.floor_area
360: ,p_floor_area_measure_unit_o
361: => pqh_acc_shd.g_old_rec.floor_area_measure_unit
362: ,p_main_rooms_o
363: => pqh_acc_shd.g_old_rec.main_rooms
364: ,p_family_size_o
365: => pqh_acc_shd.g_old_rec.family_size
366: ,p_suitability_disabled_o
367: => pqh_acc_shd.g_old_rec.suitability_disabled

Line 365: => pqh_acc_shd.g_old_rec.family_size

361: => pqh_acc_shd.g_old_rec.floor_area_measure_unit
362: ,p_main_rooms_o
363: => pqh_acc_shd.g_old_rec.main_rooms
364: ,p_family_size_o
365: => pqh_acc_shd.g_old_rec.family_size
366: ,p_suitability_disabled_o
367: => pqh_acc_shd.g_old_rec.suitability_disabled
368: ,p_rental_value_o
369: => pqh_acc_shd.g_old_rec.rental_value

Line 367: => pqh_acc_shd.g_old_rec.suitability_disabled

363: => pqh_acc_shd.g_old_rec.main_rooms
364: ,p_family_size_o
365: => pqh_acc_shd.g_old_rec.family_size
366: ,p_suitability_disabled_o
367: => pqh_acc_shd.g_old_rec.suitability_disabled
368: ,p_rental_value_o
369: => pqh_acc_shd.g_old_rec.rental_value
370: ,p_rental_value_currency_o
371: => pqh_acc_shd.g_old_rec.rental_value_currency

Line 369: => pqh_acc_shd.g_old_rec.rental_value

365: => pqh_acc_shd.g_old_rec.family_size
366: ,p_suitability_disabled_o
367: => pqh_acc_shd.g_old_rec.suitability_disabled
368: ,p_rental_value_o
369: => pqh_acc_shd.g_old_rec.rental_value
370: ,p_rental_value_currency_o
371: => pqh_acc_shd.g_old_rec.rental_value_currency
372: ,p_owner_o
373: => pqh_acc_shd.g_old_rec.owner

Line 371: => pqh_acc_shd.g_old_rec.rental_value_currency

367: => pqh_acc_shd.g_old_rec.suitability_disabled
368: ,p_rental_value_o
369: => pqh_acc_shd.g_old_rec.rental_value
370: ,p_rental_value_currency_o
371: => pqh_acc_shd.g_old_rec.rental_value_currency
372: ,p_owner_o
373: => pqh_acc_shd.g_old_rec.owner
374: ,p_comments_o
375: => pqh_acc_shd.g_old_rec.comments

Line 373: => pqh_acc_shd.g_old_rec.owner

369: => pqh_acc_shd.g_old_rec.rental_value
370: ,p_rental_value_currency_o
371: => pqh_acc_shd.g_old_rec.rental_value_currency
372: ,p_owner_o
373: => pqh_acc_shd.g_old_rec.owner
374: ,p_comments_o
375: => pqh_acc_shd.g_old_rec.comments
376: ,p_information_category_o
377: => pqh_acc_shd.g_old_rec.information_category

Line 375: => pqh_acc_shd.g_old_rec.comments

371: => pqh_acc_shd.g_old_rec.rental_value_currency
372: ,p_owner_o
373: => pqh_acc_shd.g_old_rec.owner
374: ,p_comments_o
375: => pqh_acc_shd.g_old_rec.comments
376: ,p_information_category_o
377: => pqh_acc_shd.g_old_rec.information_category
378: ,p_information1_o
379: => pqh_acc_shd.g_old_rec.information1

Line 377: => pqh_acc_shd.g_old_rec.information_category

373: => pqh_acc_shd.g_old_rec.owner
374: ,p_comments_o
375: => pqh_acc_shd.g_old_rec.comments
376: ,p_information_category_o
377: => pqh_acc_shd.g_old_rec.information_category
378: ,p_information1_o
379: => pqh_acc_shd.g_old_rec.information1
380: ,p_information2_o
381: => pqh_acc_shd.g_old_rec.information2

Line 379: => pqh_acc_shd.g_old_rec.information1

375: => pqh_acc_shd.g_old_rec.comments
376: ,p_information_category_o
377: => pqh_acc_shd.g_old_rec.information_category
378: ,p_information1_o
379: => pqh_acc_shd.g_old_rec.information1
380: ,p_information2_o
381: => pqh_acc_shd.g_old_rec.information2
382: ,p_information3_o
383: => pqh_acc_shd.g_old_rec.information3

Line 381: => pqh_acc_shd.g_old_rec.information2

377: => pqh_acc_shd.g_old_rec.information_category
378: ,p_information1_o
379: => pqh_acc_shd.g_old_rec.information1
380: ,p_information2_o
381: => pqh_acc_shd.g_old_rec.information2
382: ,p_information3_o
383: => pqh_acc_shd.g_old_rec.information3
384: ,p_information4_o
385: => pqh_acc_shd.g_old_rec.information4

Line 383: => pqh_acc_shd.g_old_rec.information3

379: => pqh_acc_shd.g_old_rec.information1
380: ,p_information2_o
381: => pqh_acc_shd.g_old_rec.information2
382: ,p_information3_o
383: => pqh_acc_shd.g_old_rec.information3
384: ,p_information4_o
385: => pqh_acc_shd.g_old_rec.information4
386: ,p_information5_o
387: => pqh_acc_shd.g_old_rec.information5

Line 385: => pqh_acc_shd.g_old_rec.information4

381: => pqh_acc_shd.g_old_rec.information2
382: ,p_information3_o
383: => pqh_acc_shd.g_old_rec.information3
384: ,p_information4_o
385: => pqh_acc_shd.g_old_rec.information4
386: ,p_information5_o
387: => pqh_acc_shd.g_old_rec.information5
388: ,p_information6_o
389: => pqh_acc_shd.g_old_rec.information6

Line 387: => pqh_acc_shd.g_old_rec.information5

383: => pqh_acc_shd.g_old_rec.information3
384: ,p_information4_o
385: => pqh_acc_shd.g_old_rec.information4
386: ,p_information5_o
387: => pqh_acc_shd.g_old_rec.information5
388: ,p_information6_o
389: => pqh_acc_shd.g_old_rec.information6
390: ,p_information7_o
391: => pqh_acc_shd.g_old_rec.information7

Line 389: => pqh_acc_shd.g_old_rec.information6

385: => pqh_acc_shd.g_old_rec.information4
386: ,p_information5_o
387: => pqh_acc_shd.g_old_rec.information5
388: ,p_information6_o
389: => pqh_acc_shd.g_old_rec.information6
390: ,p_information7_o
391: => pqh_acc_shd.g_old_rec.information7
392: ,p_information8_o
393: => pqh_acc_shd.g_old_rec.information8

Line 391: => pqh_acc_shd.g_old_rec.information7

387: => pqh_acc_shd.g_old_rec.information5
388: ,p_information6_o
389: => pqh_acc_shd.g_old_rec.information6
390: ,p_information7_o
391: => pqh_acc_shd.g_old_rec.information7
392: ,p_information8_o
393: => pqh_acc_shd.g_old_rec.information8
394: ,p_information9_o
395: => pqh_acc_shd.g_old_rec.information9

Line 393: => pqh_acc_shd.g_old_rec.information8

389: => pqh_acc_shd.g_old_rec.information6
390: ,p_information7_o
391: => pqh_acc_shd.g_old_rec.information7
392: ,p_information8_o
393: => pqh_acc_shd.g_old_rec.information8
394: ,p_information9_o
395: => pqh_acc_shd.g_old_rec.information9
396: ,p_information10_o
397: => pqh_acc_shd.g_old_rec.information10

Line 395: => pqh_acc_shd.g_old_rec.information9

391: => pqh_acc_shd.g_old_rec.information7
392: ,p_information8_o
393: => pqh_acc_shd.g_old_rec.information8
394: ,p_information9_o
395: => pqh_acc_shd.g_old_rec.information9
396: ,p_information10_o
397: => pqh_acc_shd.g_old_rec.information10
398: ,p_information11_o
399: => pqh_acc_shd.g_old_rec.information11

Line 397: => pqh_acc_shd.g_old_rec.information10

393: => pqh_acc_shd.g_old_rec.information8
394: ,p_information9_o
395: => pqh_acc_shd.g_old_rec.information9
396: ,p_information10_o
397: => pqh_acc_shd.g_old_rec.information10
398: ,p_information11_o
399: => pqh_acc_shd.g_old_rec.information11
400: ,p_information12_o
401: => pqh_acc_shd.g_old_rec.information12

Line 399: => pqh_acc_shd.g_old_rec.information11

395: => pqh_acc_shd.g_old_rec.information9
396: ,p_information10_o
397: => pqh_acc_shd.g_old_rec.information10
398: ,p_information11_o
399: => pqh_acc_shd.g_old_rec.information11
400: ,p_information12_o
401: => pqh_acc_shd.g_old_rec.information12
402: ,p_information13_o
403: => pqh_acc_shd.g_old_rec.information13

Line 401: => pqh_acc_shd.g_old_rec.information12

397: => pqh_acc_shd.g_old_rec.information10
398: ,p_information11_o
399: => pqh_acc_shd.g_old_rec.information11
400: ,p_information12_o
401: => pqh_acc_shd.g_old_rec.information12
402: ,p_information13_o
403: => pqh_acc_shd.g_old_rec.information13
404: ,p_information14_o
405: => pqh_acc_shd.g_old_rec.information14

Line 403: => pqh_acc_shd.g_old_rec.information13

399: => pqh_acc_shd.g_old_rec.information11
400: ,p_information12_o
401: => pqh_acc_shd.g_old_rec.information12
402: ,p_information13_o
403: => pqh_acc_shd.g_old_rec.information13
404: ,p_information14_o
405: => pqh_acc_shd.g_old_rec.information14
406: ,p_information15_o
407: => pqh_acc_shd.g_old_rec.information15

Line 405: => pqh_acc_shd.g_old_rec.information14

401: => pqh_acc_shd.g_old_rec.information12
402: ,p_information13_o
403: => pqh_acc_shd.g_old_rec.information13
404: ,p_information14_o
405: => pqh_acc_shd.g_old_rec.information14
406: ,p_information15_o
407: => pqh_acc_shd.g_old_rec.information15
408: ,p_information16_o
409: => pqh_acc_shd.g_old_rec.information16

Line 407: => pqh_acc_shd.g_old_rec.information15

403: => pqh_acc_shd.g_old_rec.information13
404: ,p_information14_o
405: => pqh_acc_shd.g_old_rec.information14
406: ,p_information15_o
407: => pqh_acc_shd.g_old_rec.information15
408: ,p_information16_o
409: => pqh_acc_shd.g_old_rec.information16
410: ,p_information17_o
411: => pqh_acc_shd.g_old_rec.information17

Line 409: => pqh_acc_shd.g_old_rec.information16

405: => pqh_acc_shd.g_old_rec.information14
406: ,p_information15_o
407: => pqh_acc_shd.g_old_rec.information15
408: ,p_information16_o
409: => pqh_acc_shd.g_old_rec.information16
410: ,p_information17_o
411: => pqh_acc_shd.g_old_rec.information17
412: ,p_information18_o
413: => pqh_acc_shd.g_old_rec.information18

Line 411: => pqh_acc_shd.g_old_rec.information17

407: => pqh_acc_shd.g_old_rec.information15
408: ,p_information16_o
409: => pqh_acc_shd.g_old_rec.information16
410: ,p_information17_o
411: => pqh_acc_shd.g_old_rec.information17
412: ,p_information18_o
413: => pqh_acc_shd.g_old_rec.information18
414: ,p_information19_o
415: => pqh_acc_shd.g_old_rec.information19

Line 413: => pqh_acc_shd.g_old_rec.information18

409: => pqh_acc_shd.g_old_rec.information16
410: ,p_information17_o
411: => pqh_acc_shd.g_old_rec.information17
412: ,p_information18_o
413: => pqh_acc_shd.g_old_rec.information18
414: ,p_information19_o
415: => pqh_acc_shd.g_old_rec.information19
416: ,p_information20_o
417: => pqh_acc_shd.g_old_rec.information20

Line 415: => pqh_acc_shd.g_old_rec.information19

411: => pqh_acc_shd.g_old_rec.information17
412: ,p_information18_o
413: => pqh_acc_shd.g_old_rec.information18
414: ,p_information19_o
415: => pqh_acc_shd.g_old_rec.information19
416: ,p_information20_o
417: => pqh_acc_shd.g_old_rec.information20
418: ,p_information21_o
419: => pqh_acc_shd.g_old_rec.information21

Line 417: => pqh_acc_shd.g_old_rec.information20

413: => pqh_acc_shd.g_old_rec.information18
414: ,p_information19_o
415: => pqh_acc_shd.g_old_rec.information19
416: ,p_information20_o
417: => pqh_acc_shd.g_old_rec.information20
418: ,p_information21_o
419: => pqh_acc_shd.g_old_rec.information21
420: ,p_information22_o
421: => pqh_acc_shd.g_old_rec.information22

Line 419: => pqh_acc_shd.g_old_rec.information21

415: => pqh_acc_shd.g_old_rec.information19
416: ,p_information20_o
417: => pqh_acc_shd.g_old_rec.information20
418: ,p_information21_o
419: => pqh_acc_shd.g_old_rec.information21
420: ,p_information22_o
421: => pqh_acc_shd.g_old_rec.information22
422: ,p_information23_o
423: => pqh_acc_shd.g_old_rec.information23

Line 421: => pqh_acc_shd.g_old_rec.information22

417: => pqh_acc_shd.g_old_rec.information20
418: ,p_information21_o
419: => pqh_acc_shd.g_old_rec.information21
420: ,p_information22_o
421: => pqh_acc_shd.g_old_rec.information22
422: ,p_information23_o
423: => pqh_acc_shd.g_old_rec.information23
424: ,p_information24_o
425: => pqh_acc_shd.g_old_rec.information24

Line 423: => pqh_acc_shd.g_old_rec.information23

419: => pqh_acc_shd.g_old_rec.information21
420: ,p_information22_o
421: => pqh_acc_shd.g_old_rec.information22
422: ,p_information23_o
423: => pqh_acc_shd.g_old_rec.information23
424: ,p_information24_o
425: => pqh_acc_shd.g_old_rec.information24
426: ,p_information25_o
427: => pqh_acc_shd.g_old_rec.information25

Line 425: => pqh_acc_shd.g_old_rec.information24

421: => pqh_acc_shd.g_old_rec.information22
422: ,p_information23_o
423: => pqh_acc_shd.g_old_rec.information23
424: ,p_information24_o
425: => pqh_acc_shd.g_old_rec.information24
426: ,p_information25_o
427: => pqh_acc_shd.g_old_rec.information25
428: ,p_information26_o
429: => pqh_acc_shd.g_old_rec.information26

Line 427: => pqh_acc_shd.g_old_rec.information25

423: => pqh_acc_shd.g_old_rec.information23
424: ,p_information24_o
425: => pqh_acc_shd.g_old_rec.information24
426: ,p_information25_o
427: => pqh_acc_shd.g_old_rec.information25
428: ,p_information26_o
429: => pqh_acc_shd.g_old_rec.information26
430: ,p_information27_o
431: => pqh_acc_shd.g_old_rec.information27

Line 429: => pqh_acc_shd.g_old_rec.information26

425: => pqh_acc_shd.g_old_rec.information24
426: ,p_information25_o
427: => pqh_acc_shd.g_old_rec.information25
428: ,p_information26_o
429: => pqh_acc_shd.g_old_rec.information26
430: ,p_information27_o
431: => pqh_acc_shd.g_old_rec.information27
432: ,p_information28_o
433: => pqh_acc_shd.g_old_rec.information28

Line 431: => pqh_acc_shd.g_old_rec.information27

427: => pqh_acc_shd.g_old_rec.information25
428: ,p_information26_o
429: => pqh_acc_shd.g_old_rec.information26
430: ,p_information27_o
431: => pqh_acc_shd.g_old_rec.information27
432: ,p_information28_o
433: => pqh_acc_shd.g_old_rec.information28
434: ,p_information29_o
435: => pqh_acc_shd.g_old_rec.information29

Line 433: => pqh_acc_shd.g_old_rec.information28

429: => pqh_acc_shd.g_old_rec.information26
430: ,p_information27_o
431: => pqh_acc_shd.g_old_rec.information27
432: ,p_information28_o
433: => pqh_acc_shd.g_old_rec.information28
434: ,p_information29_o
435: => pqh_acc_shd.g_old_rec.information29
436: ,p_information30_o
437: => pqh_acc_shd.g_old_rec.information30

Line 435: => pqh_acc_shd.g_old_rec.information29

431: => pqh_acc_shd.g_old_rec.information27
432: ,p_information28_o
433: => pqh_acc_shd.g_old_rec.information28
434: ,p_information29_o
435: => pqh_acc_shd.g_old_rec.information29
436: ,p_information30_o
437: => pqh_acc_shd.g_old_rec.information30
438: ,p_attribute_category_o
439: => pqh_acc_shd.g_old_rec.attribute_category

Line 437: => pqh_acc_shd.g_old_rec.information30

433: => pqh_acc_shd.g_old_rec.information28
434: ,p_information29_o
435: => pqh_acc_shd.g_old_rec.information29
436: ,p_information30_o
437: => pqh_acc_shd.g_old_rec.information30
438: ,p_attribute_category_o
439: => pqh_acc_shd.g_old_rec.attribute_category
440: ,p_attribute1_o
441: => pqh_acc_shd.g_old_rec.attribute1

Line 439: => pqh_acc_shd.g_old_rec.attribute_category

435: => pqh_acc_shd.g_old_rec.information29
436: ,p_information30_o
437: => pqh_acc_shd.g_old_rec.information30
438: ,p_attribute_category_o
439: => pqh_acc_shd.g_old_rec.attribute_category
440: ,p_attribute1_o
441: => pqh_acc_shd.g_old_rec.attribute1
442: ,p_attribute2_o
443: => pqh_acc_shd.g_old_rec.attribute2

Line 441: => pqh_acc_shd.g_old_rec.attribute1

437: => pqh_acc_shd.g_old_rec.information30
438: ,p_attribute_category_o
439: => pqh_acc_shd.g_old_rec.attribute_category
440: ,p_attribute1_o
441: => pqh_acc_shd.g_old_rec.attribute1
442: ,p_attribute2_o
443: => pqh_acc_shd.g_old_rec.attribute2
444: ,p_attribute3_o
445: => pqh_acc_shd.g_old_rec.attribute3

Line 443: => pqh_acc_shd.g_old_rec.attribute2

439: => pqh_acc_shd.g_old_rec.attribute_category
440: ,p_attribute1_o
441: => pqh_acc_shd.g_old_rec.attribute1
442: ,p_attribute2_o
443: => pqh_acc_shd.g_old_rec.attribute2
444: ,p_attribute3_o
445: => pqh_acc_shd.g_old_rec.attribute3
446: ,p_attribute4_o
447: => pqh_acc_shd.g_old_rec.attribute4

Line 445: => pqh_acc_shd.g_old_rec.attribute3

441: => pqh_acc_shd.g_old_rec.attribute1
442: ,p_attribute2_o
443: => pqh_acc_shd.g_old_rec.attribute2
444: ,p_attribute3_o
445: => pqh_acc_shd.g_old_rec.attribute3
446: ,p_attribute4_o
447: => pqh_acc_shd.g_old_rec.attribute4
448: ,p_attribute5_o
449: => pqh_acc_shd.g_old_rec.attribute5

Line 447: => pqh_acc_shd.g_old_rec.attribute4

443: => pqh_acc_shd.g_old_rec.attribute2
444: ,p_attribute3_o
445: => pqh_acc_shd.g_old_rec.attribute3
446: ,p_attribute4_o
447: => pqh_acc_shd.g_old_rec.attribute4
448: ,p_attribute5_o
449: => pqh_acc_shd.g_old_rec.attribute5
450: ,p_attribute6_o
451: => pqh_acc_shd.g_old_rec.attribute6

Line 449: => pqh_acc_shd.g_old_rec.attribute5

445: => pqh_acc_shd.g_old_rec.attribute3
446: ,p_attribute4_o
447: => pqh_acc_shd.g_old_rec.attribute4
448: ,p_attribute5_o
449: => pqh_acc_shd.g_old_rec.attribute5
450: ,p_attribute6_o
451: => pqh_acc_shd.g_old_rec.attribute6
452: ,p_attribute7_o
453: => pqh_acc_shd.g_old_rec.attribute7

Line 451: => pqh_acc_shd.g_old_rec.attribute6

447: => pqh_acc_shd.g_old_rec.attribute4
448: ,p_attribute5_o
449: => pqh_acc_shd.g_old_rec.attribute5
450: ,p_attribute6_o
451: => pqh_acc_shd.g_old_rec.attribute6
452: ,p_attribute7_o
453: => pqh_acc_shd.g_old_rec.attribute7
454: ,p_attribute8_o
455: => pqh_acc_shd.g_old_rec.attribute8

Line 453: => pqh_acc_shd.g_old_rec.attribute7

449: => pqh_acc_shd.g_old_rec.attribute5
450: ,p_attribute6_o
451: => pqh_acc_shd.g_old_rec.attribute6
452: ,p_attribute7_o
453: => pqh_acc_shd.g_old_rec.attribute7
454: ,p_attribute8_o
455: => pqh_acc_shd.g_old_rec.attribute8
456: ,p_attribute9_o
457: => pqh_acc_shd.g_old_rec.attribute9

Line 455: => pqh_acc_shd.g_old_rec.attribute8

451: => pqh_acc_shd.g_old_rec.attribute6
452: ,p_attribute7_o
453: => pqh_acc_shd.g_old_rec.attribute7
454: ,p_attribute8_o
455: => pqh_acc_shd.g_old_rec.attribute8
456: ,p_attribute9_o
457: => pqh_acc_shd.g_old_rec.attribute9
458: ,p_attribute10_o
459: => pqh_acc_shd.g_old_rec.attribute10

Line 457: => pqh_acc_shd.g_old_rec.attribute9

453: => pqh_acc_shd.g_old_rec.attribute7
454: ,p_attribute8_o
455: => pqh_acc_shd.g_old_rec.attribute8
456: ,p_attribute9_o
457: => pqh_acc_shd.g_old_rec.attribute9
458: ,p_attribute10_o
459: => pqh_acc_shd.g_old_rec.attribute10
460: ,p_attribute11_o
461: => pqh_acc_shd.g_old_rec.attribute11

Line 459: => pqh_acc_shd.g_old_rec.attribute10

455: => pqh_acc_shd.g_old_rec.attribute8
456: ,p_attribute9_o
457: => pqh_acc_shd.g_old_rec.attribute9
458: ,p_attribute10_o
459: => pqh_acc_shd.g_old_rec.attribute10
460: ,p_attribute11_o
461: => pqh_acc_shd.g_old_rec.attribute11
462: ,p_attribute12_o
463: => pqh_acc_shd.g_old_rec.attribute12

Line 461: => pqh_acc_shd.g_old_rec.attribute11

457: => pqh_acc_shd.g_old_rec.attribute9
458: ,p_attribute10_o
459: => pqh_acc_shd.g_old_rec.attribute10
460: ,p_attribute11_o
461: => pqh_acc_shd.g_old_rec.attribute11
462: ,p_attribute12_o
463: => pqh_acc_shd.g_old_rec.attribute12
464: ,p_attribute13_o
465: => pqh_acc_shd.g_old_rec.attribute13

Line 463: => pqh_acc_shd.g_old_rec.attribute12

459: => pqh_acc_shd.g_old_rec.attribute10
460: ,p_attribute11_o
461: => pqh_acc_shd.g_old_rec.attribute11
462: ,p_attribute12_o
463: => pqh_acc_shd.g_old_rec.attribute12
464: ,p_attribute13_o
465: => pqh_acc_shd.g_old_rec.attribute13
466: ,p_attribute14_o
467: => pqh_acc_shd.g_old_rec.attribute14

Line 465: => pqh_acc_shd.g_old_rec.attribute13

461: => pqh_acc_shd.g_old_rec.attribute11
462: ,p_attribute12_o
463: => pqh_acc_shd.g_old_rec.attribute12
464: ,p_attribute13_o
465: => pqh_acc_shd.g_old_rec.attribute13
466: ,p_attribute14_o
467: => pqh_acc_shd.g_old_rec.attribute14
468: ,p_attribute15_o
469: => pqh_acc_shd.g_old_rec.attribute15

Line 467: => pqh_acc_shd.g_old_rec.attribute14

463: => pqh_acc_shd.g_old_rec.attribute12
464: ,p_attribute13_o
465: => pqh_acc_shd.g_old_rec.attribute13
466: ,p_attribute14_o
467: => pqh_acc_shd.g_old_rec.attribute14
468: ,p_attribute15_o
469: => pqh_acc_shd.g_old_rec.attribute15
470: ,p_attribute16_o
471: => pqh_acc_shd.g_old_rec.attribute16

Line 469: => pqh_acc_shd.g_old_rec.attribute15

465: => pqh_acc_shd.g_old_rec.attribute13
466: ,p_attribute14_o
467: => pqh_acc_shd.g_old_rec.attribute14
468: ,p_attribute15_o
469: => pqh_acc_shd.g_old_rec.attribute15
470: ,p_attribute16_o
471: => pqh_acc_shd.g_old_rec.attribute16
472: ,p_attribute17_o
473: => pqh_acc_shd.g_old_rec.attribute17

Line 471: => pqh_acc_shd.g_old_rec.attribute16

467: => pqh_acc_shd.g_old_rec.attribute14
468: ,p_attribute15_o
469: => pqh_acc_shd.g_old_rec.attribute15
470: ,p_attribute16_o
471: => pqh_acc_shd.g_old_rec.attribute16
472: ,p_attribute17_o
473: => pqh_acc_shd.g_old_rec.attribute17
474: ,p_attribute18_o
475: => pqh_acc_shd.g_old_rec.attribute18

Line 473: => pqh_acc_shd.g_old_rec.attribute17

469: => pqh_acc_shd.g_old_rec.attribute15
470: ,p_attribute16_o
471: => pqh_acc_shd.g_old_rec.attribute16
472: ,p_attribute17_o
473: => pqh_acc_shd.g_old_rec.attribute17
474: ,p_attribute18_o
475: => pqh_acc_shd.g_old_rec.attribute18
476: ,p_attribute19_o
477: => pqh_acc_shd.g_old_rec.attribute19

Line 475: => pqh_acc_shd.g_old_rec.attribute18

471: => pqh_acc_shd.g_old_rec.attribute16
472: ,p_attribute17_o
473: => pqh_acc_shd.g_old_rec.attribute17
474: ,p_attribute18_o
475: => pqh_acc_shd.g_old_rec.attribute18
476: ,p_attribute19_o
477: => pqh_acc_shd.g_old_rec.attribute19
478: ,p_attribute20_o
479: => pqh_acc_shd.g_old_rec.attribute20

Line 477: => pqh_acc_shd.g_old_rec.attribute19

473: => pqh_acc_shd.g_old_rec.attribute17
474: ,p_attribute18_o
475: => pqh_acc_shd.g_old_rec.attribute18
476: ,p_attribute19_o
477: => pqh_acc_shd.g_old_rec.attribute19
478: ,p_attribute20_o
479: => pqh_acc_shd.g_old_rec.attribute20
480: ,p_attribute21_o
481: => pqh_acc_shd.g_old_rec.attribute21

Line 479: => pqh_acc_shd.g_old_rec.attribute20

475: => pqh_acc_shd.g_old_rec.attribute18
476: ,p_attribute19_o
477: => pqh_acc_shd.g_old_rec.attribute19
478: ,p_attribute20_o
479: => pqh_acc_shd.g_old_rec.attribute20
480: ,p_attribute21_o
481: => pqh_acc_shd.g_old_rec.attribute21
482: ,p_attribute22_o
483: => pqh_acc_shd.g_old_rec.attribute22

Line 481: => pqh_acc_shd.g_old_rec.attribute21

477: => pqh_acc_shd.g_old_rec.attribute19
478: ,p_attribute20_o
479: => pqh_acc_shd.g_old_rec.attribute20
480: ,p_attribute21_o
481: => pqh_acc_shd.g_old_rec.attribute21
482: ,p_attribute22_o
483: => pqh_acc_shd.g_old_rec.attribute22
484: ,p_attribute23_o
485: => pqh_acc_shd.g_old_rec.attribute23

Line 483: => pqh_acc_shd.g_old_rec.attribute22

479: => pqh_acc_shd.g_old_rec.attribute20
480: ,p_attribute21_o
481: => pqh_acc_shd.g_old_rec.attribute21
482: ,p_attribute22_o
483: => pqh_acc_shd.g_old_rec.attribute22
484: ,p_attribute23_o
485: => pqh_acc_shd.g_old_rec.attribute23
486: ,p_attribute24_o
487: => pqh_acc_shd.g_old_rec.attribute24

Line 485: => pqh_acc_shd.g_old_rec.attribute23

481: => pqh_acc_shd.g_old_rec.attribute21
482: ,p_attribute22_o
483: => pqh_acc_shd.g_old_rec.attribute22
484: ,p_attribute23_o
485: => pqh_acc_shd.g_old_rec.attribute23
486: ,p_attribute24_o
487: => pqh_acc_shd.g_old_rec.attribute24
488: ,p_attribute25_o
489: => pqh_acc_shd.g_old_rec.attribute25

Line 487: => pqh_acc_shd.g_old_rec.attribute24

483: => pqh_acc_shd.g_old_rec.attribute22
484: ,p_attribute23_o
485: => pqh_acc_shd.g_old_rec.attribute23
486: ,p_attribute24_o
487: => pqh_acc_shd.g_old_rec.attribute24
488: ,p_attribute25_o
489: => pqh_acc_shd.g_old_rec.attribute25
490: ,p_attribute26_o
491: => pqh_acc_shd.g_old_rec.attribute26

Line 489: => pqh_acc_shd.g_old_rec.attribute25

485: => pqh_acc_shd.g_old_rec.attribute23
486: ,p_attribute24_o
487: => pqh_acc_shd.g_old_rec.attribute24
488: ,p_attribute25_o
489: => pqh_acc_shd.g_old_rec.attribute25
490: ,p_attribute26_o
491: => pqh_acc_shd.g_old_rec.attribute26
492: ,p_attribute27_o
493: => pqh_acc_shd.g_old_rec.attribute27

Line 491: => pqh_acc_shd.g_old_rec.attribute26

487: => pqh_acc_shd.g_old_rec.attribute24
488: ,p_attribute25_o
489: => pqh_acc_shd.g_old_rec.attribute25
490: ,p_attribute26_o
491: => pqh_acc_shd.g_old_rec.attribute26
492: ,p_attribute27_o
493: => pqh_acc_shd.g_old_rec.attribute27
494: ,p_attribute28_o
495: => pqh_acc_shd.g_old_rec.attribute28

Line 493: => pqh_acc_shd.g_old_rec.attribute27

489: => pqh_acc_shd.g_old_rec.attribute25
490: ,p_attribute26_o
491: => pqh_acc_shd.g_old_rec.attribute26
492: ,p_attribute27_o
493: => pqh_acc_shd.g_old_rec.attribute27
494: ,p_attribute28_o
495: => pqh_acc_shd.g_old_rec.attribute28
496: ,p_attribute29_o
497: => pqh_acc_shd.g_old_rec.attribute29

Line 495: => pqh_acc_shd.g_old_rec.attribute28

491: => pqh_acc_shd.g_old_rec.attribute26
492: ,p_attribute27_o
493: => pqh_acc_shd.g_old_rec.attribute27
494: ,p_attribute28_o
495: => pqh_acc_shd.g_old_rec.attribute28
496: ,p_attribute29_o
497: => pqh_acc_shd.g_old_rec.attribute29
498: ,p_attribute30_o
499: => pqh_acc_shd.g_old_rec.attribute30

Line 497: => pqh_acc_shd.g_old_rec.attribute29

493: => pqh_acc_shd.g_old_rec.attribute27
494: ,p_attribute28_o
495: => pqh_acc_shd.g_old_rec.attribute28
496: ,p_attribute29_o
497: => pqh_acc_shd.g_old_rec.attribute29
498: ,p_attribute30_o
499: => pqh_acc_shd.g_old_rec.attribute30
500: ,p_object_version_number_o
501: => pqh_acc_shd.g_old_rec.object_version_number

Line 499: => pqh_acc_shd.g_old_rec.attribute30

495: => pqh_acc_shd.g_old_rec.attribute28
496: ,p_attribute29_o
497: => pqh_acc_shd.g_old_rec.attribute29
498: ,p_attribute30_o
499: => pqh_acc_shd.g_old_rec.attribute30
500: ,p_object_version_number_o
501: => pqh_acc_shd.g_old_rec.object_version_number
502: );
503: --

Line 501: => pqh_acc_shd.g_old_rec.object_version_number

497: => pqh_acc_shd.g_old_rec.attribute29
498: ,p_attribute30_o
499: => pqh_acc_shd.g_old_rec.attribute30
500: ,p_object_version_number_o
501: => pqh_acc_shd.g_old_rec.object_version_number
502: );
503: --
504: exception
505: --

Line 523: ,p_rec in out nocopy pqh_acc_shd.g_rec_type

519: -- ----------------------------------------------------------------------------
520: Procedure del
521: (p_effective_date in date
522: ,p_datetrack_mode in varchar2
523: ,p_rec in out nocopy pqh_acc_shd.g_rec_type
524: ) is
525: --
526: l_proc varchar2(72) := g_package||'del';
527: l_validation_start_date date;

Line 539: pqh_acc_shd.lck

535: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
536: --
537: -- We must lock the row which we need to delete.
538: --
539: pqh_acc_shd.lck
540: (p_effective_date => p_effective_date
541: ,p_datetrack_mode => p_datetrack_mode
542: ,p_accommodation_id => p_rec.accommodation_id
543: ,p_object_version_number => p_rec.object_version_number

Line 608: l_rec pqh_acc_shd.g_rec_type;

604: ,p_effective_start_date out nocopy date
605: ,p_effective_end_date out nocopy date
606: ) is
607: --
608: l_rec pqh_acc_shd.g_rec_type;
609: l_proc varchar2(72) := g_package||'del';
610: --
611: Begin
612: hr_utility.set_location('Entering:'||l_proc, 5);