APPS.PQP_VAL_DEL dependencies on PQP_VAL_SHD

Line 54: (p_rec in out nocopy pqp_val_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy pqp_val_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 pqp_val_shd.g_rec_type

93: -- ----------------------------------------------------------------------------
94: -- |------------------------------< delete_dml >------------------------------|
95: -- ----------------------------------------------------------------------------
96: Procedure delete_dml
97: (p_rec in out nocopy pqp_val_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 pqp_val_shd.g_rec_type

150: --
151: -- {End Of Comments}
152: -- ----------------------------------------------------------------------------
153: Procedure dt_pre_delete
154: (p_rec in out nocopy pqp_val_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: := pqp_val_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: := pqp_val_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: pqp_val_shd.upd_effective_end_date

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

Line 229: (p_rec in out nocopy pqp_val_shd.g_rec_type

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

Line 258: (pqp_val_shd.g_old_rec.business_group_id);

254: ,p_validation_end_date => p_validation_end_date
255: );
256: --
257: l_legislation_code := pqp_vre_bus.get_legislation_code
258: (pqp_val_shd.g_old_rec.business_group_id);
259: --
260: If l_legislation_code = 'GB' Then
261: Begin
262: pqp_val_bus.del_ni_car_entry

Line 263: (p_business_group_id => pqp_val_shd.g_old_rec.business_group_id

259: --
260: If l_legislation_code = 'GB' Then
261: Begin
262: pqp_val_bus.del_ni_car_entry
263: (p_business_group_id => pqp_val_shd.g_old_rec.business_group_id
264: ,p_assignment_id => pqp_val_shd.g_old_rec.assignment_id
265: ,p_allocation_id => p_rec.vehicle_allocation_id
266: ,p_effective_date => p_effective_date
267: );

Line 264: ,p_assignment_id => pqp_val_shd.g_old_rec.assignment_id

260: If l_legislation_code = 'GB' Then
261: Begin
262: pqp_val_bus.del_ni_car_entry
263: (p_business_group_id => pqp_val_shd.g_old_rec.business_group_id
264: ,p_assignment_id => pqp_val_shd.g_old_rec.assignment_id
265: ,p_allocation_id => p_rec.vehicle_allocation_id
266: ,p_effective_date => p_effective_date
267: );
268: Exception

Line 329: (p_rec in pqp_val_shd.g_rec_type

325: --
326: -- {End Of Comments}
327: -- ----------------------------------------------------------------------------
328: Procedure post_delete
329: (p_rec in pqp_val_shd.g_rec_type
330: ,p_effective_date in date
331: ,p_datetrack_mode in varchar2
332: ,p_validation_start_date in date
333: ,p_validation_end_date in date

Line 359: => pqp_val_shd.g_old_rec.effective_start_date

355: => p_rec.effective_start_date
356: ,p_effective_end_date
357: => p_rec.effective_end_date
358: ,p_effective_start_date_o
359: => pqp_val_shd.g_old_rec.effective_start_date
360: ,p_effective_end_date_o
361: => pqp_val_shd.g_old_rec.effective_end_date
362: ,p_assignment_id_o
363: => pqp_val_shd.g_old_rec.assignment_id

Line 361: => pqp_val_shd.g_old_rec.effective_end_date

357: => p_rec.effective_end_date
358: ,p_effective_start_date_o
359: => pqp_val_shd.g_old_rec.effective_start_date
360: ,p_effective_end_date_o
361: => pqp_val_shd.g_old_rec.effective_end_date
362: ,p_assignment_id_o
363: => pqp_val_shd.g_old_rec.assignment_id
364: ,p_business_group_id_o
365: => pqp_val_shd.g_old_rec.business_group_id

Line 363: => pqp_val_shd.g_old_rec.assignment_id

359: => pqp_val_shd.g_old_rec.effective_start_date
360: ,p_effective_end_date_o
361: => pqp_val_shd.g_old_rec.effective_end_date
362: ,p_assignment_id_o
363: => pqp_val_shd.g_old_rec.assignment_id
364: ,p_business_group_id_o
365: => pqp_val_shd.g_old_rec.business_group_id
366: ,p_across_assignments_o
367: => pqp_val_shd.g_old_rec.across_assignments

Line 365: => pqp_val_shd.g_old_rec.business_group_id

361: => pqp_val_shd.g_old_rec.effective_end_date
362: ,p_assignment_id_o
363: => pqp_val_shd.g_old_rec.assignment_id
364: ,p_business_group_id_o
365: => pqp_val_shd.g_old_rec.business_group_id
366: ,p_across_assignments_o
367: => pqp_val_shd.g_old_rec.across_assignments
368: ,p_vehicle_repository_id_o
369: => pqp_val_shd.g_old_rec.vehicle_repository_id

Line 367: => pqp_val_shd.g_old_rec.across_assignments

363: => pqp_val_shd.g_old_rec.assignment_id
364: ,p_business_group_id_o
365: => pqp_val_shd.g_old_rec.business_group_id
366: ,p_across_assignments_o
367: => pqp_val_shd.g_old_rec.across_assignments
368: ,p_vehicle_repository_id_o
369: => pqp_val_shd.g_old_rec.vehicle_repository_id
370: ,p_usage_type_o
371: => pqp_val_shd.g_old_rec.usage_type

Line 369: => pqp_val_shd.g_old_rec.vehicle_repository_id

365: => pqp_val_shd.g_old_rec.business_group_id
366: ,p_across_assignments_o
367: => pqp_val_shd.g_old_rec.across_assignments
368: ,p_vehicle_repository_id_o
369: => pqp_val_shd.g_old_rec.vehicle_repository_id
370: ,p_usage_type_o
371: => pqp_val_shd.g_old_rec.usage_type
372: ,p_capital_contribution_o
373: => pqp_val_shd.g_old_rec.capital_contribution

Line 371: => pqp_val_shd.g_old_rec.usage_type

367: => pqp_val_shd.g_old_rec.across_assignments
368: ,p_vehicle_repository_id_o
369: => pqp_val_shd.g_old_rec.vehicle_repository_id
370: ,p_usage_type_o
371: => pqp_val_shd.g_old_rec.usage_type
372: ,p_capital_contribution_o
373: => pqp_val_shd.g_old_rec.capital_contribution
374: ,p_private_contribution_o
375: => pqp_val_shd.g_old_rec.private_contribution

Line 373: => pqp_val_shd.g_old_rec.capital_contribution

369: => pqp_val_shd.g_old_rec.vehicle_repository_id
370: ,p_usage_type_o
371: => pqp_val_shd.g_old_rec.usage_type
372: ,p_capital_contribution_o
373: => pqp_val_shd.g_old_rec.capital_contribution
374: ,p_private_contribution_o
375: => pqp_val_shd.g_old_rec.private_contribution
376: ,p_default_vehicle_o
377: => pqp_val_shd.g_old_rec.default_vehicle

Line 375: => pqp_val_shd.g_old_rec.private_contribution

371: => pqp_val_shd.g_old_rec.usage_type
372: ,p_capital_contribution_o
373: => pqp_val_shd.g_old_rec.capital_contribution
374: ,p_private_contribution_o
375: => pqp_val_shd.g_old_rec.private_contribution
376: ,p_default_vehicle_o
377: => pqp_val_shd.g_old_rec.default_vehicle
378: ,p_fuel_card_o
379: => pqp_val_shd.g_old_rec.fuel_card

Line 377: => pqp_val_shd.g_old_rec.default_vehicle

373: => pqp_val_shd.g_old_rec.capital_contribution
374: ,p_private_contribution_o
375: => pqp_val_shd.g_old_rec.private_contribution
376: ,p_default_vehicle_o
377: => pqp_val_shd.g_old_rec.default_vehicle
378: ,p_fuel_card_o
379: => pqp_val_shd.g_old_rec.fuel_card
380: ,p_fuel_card_number_o
381: => pqp_val_shd.g_old_rec.fuel_card_number

Line 379: => pqp_val_shd.g_old_rec.fuel_card

375: => pqp_val_shd.g_old_rec.private_contribution
376: ,p_default_vehicle_o
377: => pqp_val_shd.g_old_rec.default_vehicle
378: ,p_fuel_card_o
379: => pqp_val_shd.g_old_rec.fuel_card
380: ,p_fuel_card_number_o
381: => pqp_val_shd.g_old_rec.fuel_card_number
382: ,p_calculation_method_o
383: => pqp_val_shd.g_old_rec.calculation_method

Line 381: => pqp_val_shd.g_old_rec.fuel_card_number

377: => pqp_val_shd.g_old_rec.default_vehicle
378: ,p_fuel_card_o
379: => pqp_val_shd.g_old_rec.fuel_card
380: ,p_fuel_card_number_o
381: => pqp_val_shd.g_old_rec.fuel_card_number
382: ,p_calculation_method_o
383: => pqp_val_shd.g_old_rec.calculation_method
384: ,p_rates_table_id_o
385: => pqp_val_shd.g_old_rec.rates_table_id

Line 383: => pqp_val_shd.g_old_rec.calculation_method

379: => pqp_val_shd.g_old_rec.fuel_card
380: ,p_fuel_card_number_o
381: => pqp_val_shd.g_old_rec.fuel_card_number
382: ,p_calculation_method_o
383: => pqp_val_shd.g_old_rec.calculation_method
384: ,p_rates_table_id_o
385: => pqp_val_shd.g_old_rec.rates_table_id
386: ,p_element_type_id_o
387: => pqp_val_shd.g_old_rec.element_type_id

Line 385: => pqp_val_shd.g_old_rec.rates_table_id

381: => pqp_val_shd.g_old_rec.fuel_card_number
382: ,p_calculation_method_o
383: => pqp_val_shd.g_old_rec.calculation_method
384: ,p_rates_table_id_o
385: => pqp_val_shd.g_old_rec.rates_table_id
386: ,p_element_type_id_o
387: => pqp_val_shd.g_old_rec.element_type_id
388: ,p_private_use_flag_o
389: => pqp_val_shd.g_old_rec.private_use_flag

Line 387: => pqp_val_shd.g_old_rec.element_type_id

383: => pqp_val_shd.g_old_rec.calculation_method
384: ,p_rates_table_id_o
385: => pqp_val_shd.g_old_rec.rates_table_id
386: ,p_element_type_id_o
387: => pqp_val_shd.g_old_rec.element_type_id
388: ,p_private_use_flag_o
389: => pqp_val_shd.g_old_rec.private_use_flag
390: ,p_insurance_number_o
391: => pqp_val_shd.g_old_rec.insurance_number

Line 389: => pqp_val_shd.g_old_rec.private_use_flag

385: => pqp_val_shd.g_old_rec.rates_table_id
386: ,p_element_type_id_o
387: => pqp_val_shd.g_old_rec.element_type_id
388: ,p_private_use_flag_o
389: => pqp_val_shd.g_old_rec.private_use_flag
390: ,p_insurance_number_o
391: => pqp_val_shd.g_old_rec.insurance_number
392: ,p_insurance_expiry_date_o
393: => pqp_val_shd.g_old_rec.insurance_expiry_date

Line 391: => pqp_val_shd.g_old_rec.insurance_number

387: => pqp_val_shd.g_old_rec.element_type_id
388: ,p_private_use_flag_o
389: => pqp_val_shd.g_old_rec.private_use_flag
390: ,p_insurance_number_o
391: => pqp_val_shd.g_old_rec.insurance_number
392: ,p_insurance_expiry_date_o
393: => pqp_val_shd.g_old_rec.insurance_expiry_date
394: ,p_val_attribute_category_o
395: => pqp_val_shd.g_old_rec.val_attribute_category

Line 393: => pqp_val_shd.g_old_rec.insurance_expiry_date

389: => pqp_val_shd.g_old_rec.private_use_flag
390: ,p_insurance_number_o
391: => pqp_val_shd.g_old_rec.insurance_number
392: ,p_insurance_expiry_date_o
393: => pqp_val_shd.g_old_rec.insurance_expiry_date
394: ,p_val_attribute_category_o
395: => pqp_val_shd.g_old_rec.val_attribute_category
396: ,p_val_attribute1_o
397: => pqp_val_shd.g_old_rec.val_attribute1

Line 395: => pqp_val_shd.g_old_rec.val_attribute_category

391: => pqp_val_shd.g_old_rec.insurance_number
392: ,p_insurance_expiry_date_o
393: => pqp_val_shd.g_old_rec.insurance_expiry_date
394: ,p_val_attribute_category_o
395: => pqp_val_shd.g_old_rec.val_attribute_category
396: ,p_val_attribute1_o
397: => pqp_val_shd.g_old_rec.val_attribute1
398: ,p_val_attribute2_o
399: => pqp_val_shd.g_old_rec.val_attribute2

Line 397: => pqp_val_shd.g_old_rec.val_attribute1

393: => pqp_val_shd.g_old_rec.insurance_expiry_date
394: ,p_val_attribute_category_o
395: => pqp_val_shd.g_old_rec.val_attribute_category
396: ,p_val_attribute1_o
397: => pqp_val_shd.g_old_rec.val_attribute1
398: ,p_val_attribute2_o
399: => pqp_val_shd.g_old_rec.val_attribute2
400: ,p_val_attribute3_o
401: => pqp_val_shd.g_old_rec.val_attribute3

Line 399: => pqp_val_shd.g_old_rec.val_attribute2

395: => pqp_val_shd.g_old_rec.val_attribute_category
396: ,p_val_attribute1_o
397: => pqp_val_shd.g_old_rec.val_attribute1
398: ,p_val_attribute2_o
399: => pqp_val_shd.g_old_rec.val_attribute2
400: ,p_val_attribute3_o
401: => pqp_val_shd.g_old_rec.val_attribute3
402: ,p_val_attribute4_o
403: => pqp_val_shd.g_old_rec.val_attribute4

Line 401: => pqp_val_shd.g_old_rec.val_attribute3

397: => pqp_val_shd.g_old_rec.val_attribute1
398: ,p_val_attribute2_o
399: => pqp_val_shd.g_old_rec.val_attribute2
400: ,p_val_attribute3_o
401: => pqp_val_shd.g_old_rec.val_attribute3
402: ,p_val_attribute4_o
403: => pqp_val_shd.g_old_rec.val_attribute4
404: ,p_val_attribute5_o
405: => pqp_val_shd.g_old_rec.val_attribute5

Line 403: => pqp_val_shd.g_old_rec.val_attribute4

399: => pqp_val_shd.g_old_rec.val_attribute2
400: ,p_val_attribute3_o
401: => pqp_val_shd.g_old_rec.val_attribute3
402: ,p_val_attribute4_o
403: => pqp_val_shd.g_old_rec.val_attribute4
404: ,p_val_attribute5_o
405: => pqp_val_shd.g_old_rec.val_attribute5
406: ,p_val_attribute6_o
407: => pqp_val_shd.g_old_rec.val_attribute6

Line 405: => pqp_val_shd.g_old_rec.val_attribute5

401: => pqp_val_shd.g_old_rec.val_attribute3
402: ,p_val_attribute4_o
403: => pqp_val_shd.g_old_rec.val_attribute4
404: ,p_val_attribute5_o
405: => pqp_val_shd.g_old_rec.val_attribute5
406: ,p_val_attribute6_o
407: => pqp_val_shd.g_old_rec.val_attribute6
408: ,p_val_attribute7_o
409: => pqp_val_shd.g_old_rec.val_attribute7

Line 407: => pqp_val_shd.g_old_rec.val_attribute6

403: => pqp_val_shd.g_old_rec.val_attribute4
404: ,p_val_attribute5_o
405: => pqp_val_shd.g_old_rec.val_attribute5
406: ,p_val_attribute6_o
407: => pqp_val_shd.g_old_rec.val_attribute6
408: ,p_val_attribute7_o
409: => pqp_val_shd.g_old_rec.val_attribute7
410: ,p_val_attribute8_o
411: => pqp_val_shd.g_old_rec.val_attribute8

Line 409: => pqp_val_shd.g_old_rec.val_attribute7

405: => pqp_val_shd.g_old_rec.val_attribute5
406: ,p_val_attribute6_o
407: => pqp_val_shd.g_old_rec.val_attribute6
408: ,p_val_attribute7_o
409: => pqp_val_shd.g_old_rec.val_attribute7
410: ,p_val_attribute8_o
411: => pqp_val_shd.g_old_rec.val_attribute8
412: ,p_val_attribute9_o
413: => pqp_val_shd.g_old_rec.val_attribute9

Line 411: => pqp_val_shd.g_old_rec.val_attribute8

407: => pqp_val_shd.g_old_rec.val_attribute6
408: ,p_val_attribute7_o
409: => pqp_val_shd.g_old_rec.val_attribute7
410: ,p_val_attribute8_o
411: => pqp_val_shd.g_old_rec.val_attribute8
412: ,p_val_attribute9_o
413: => pqp_val_shd.g_old_rec.val_attribute9
414: ,p_val_attribute10_o
415: => pqp_val_shd.g_old_rec.val_attribute10

Line 413: => pqp_val_shd.g_old_rec.val_attribute9

409: => pqp_val_shd.g_old_rec.val_attribute7
410: ,p_val_attribute8_o
411: => pqp_val_shd.g_old_rec.val_attribute8
412: ,p_val_attribute9_o
413: => pqp_val_shd.g_old_rec.val_attribute9
414: ,p_val_attribute10_o
415: => pqp_val_shd.g_old_rec.val_attribute10
416: ,p_val_attribute11_o
417: => pqp_val_shd.g_old_rec.val_attribute11

Line 415: => pqp_val_shd.g_old_rec.val_attribute10

411: => pqp_val_shd.g_old_rec.val_attribute8
412: ,p_val_attribute9_o
413: => pqp_val_shd.g_old_rec.val_attribute9
414: ,p_val_attribute10_o
415: => pqp_val_shd.g_old_rec.val_attribute10
416: ,p_val_attribute11_o
417: => pqp_val_shd.g_old_rec.val_attribute11
418: ,p_val_attribute12_o
419: => pqp_val_shd.g_old_rec.val_attribute12

Line 417: => pqp_val_shd.g_old_rec.val_attribute11

413: => pqp_val_shd.g_old_rec.val_attribute9
414: ,p_val_attribute10_o
415: => pqp_val_shd.g_old_rec.val_attribute10
416: ,p_val_attribute11_o
417: => pqp_val_shd.g_old_rec.val_attribute11
418: ,p_val_attribute12_o
419: => pqp_val_shd.g_old_rec.val_attribute12
420: ,p_val_attribute13_o
421: => pqp_val_shd.g_old_rec.val_attribute13

Line 419: => pqp_val_shd.g_old_rec.val_attribute12

415: => pqp_val_shd.g_old_rec.val_attribute10
416: ,p_val_attribute11_o
417: => pqp_val_shd.g_old_rec.val_attribute11
418: ,p_val_attribute12_o
419: => pqp_val_shd.g_old_rec.val_attribute12
420: ,p_val_attribute13_o
421: => pqp_val_shd.g_old_rec.val_attribute13
422: ,p_val_attribute14_o
423: => pqp_val_shd.g_old_rec.val_attribute14

Line 421: => pqp_val_shd.g_old_rec.val_attribute13

417: => pqp_val_shd.g_old_rec.val_attribute11
418: ,p_val_attribute12_o
419: => pqp_val_shd.g_old_rec.val_attribute12
420: ,p_val_attribute13_o
421: => pqp_val_shd.g_old_rec.val_attribute13
422: ,p_val_attribute14_o
423: => pqp_val_shd.g_old_rec.val_attribute14
424: ,p_val_attribute15_o
425: => pqp_val_shd.g_old_rec.val_attribute15

Line 423: => pqp_val_shd.g_old_rec.val_attribute14

419: => pqp_val_shd.g_old_rec.val_attribute12
420: ,p_val_attribute13_o
421: => pqp_val_shd.g_old_rec.val_attribute13
422: ,p_val_attribute14_o
423: => pqp_val_shd.g_old_rec.val_attribute14
424: ,p_val_attribute15_o
425: => pqp_val_shd.g_old_rec.val_attribute15
426: ,p_val_attribute16_o
427: => pqp_val_shd.g_old_rec.val_attribute16

Line 425: => pqp_val_shd.g_old_rec.val_attribute15

421: => pqp_val_shd.g_old_rec.val_attribute13
422: ,p_val_attribute14_o
423: => pqp_val_shd.g_old_rec.val_attribute14
424: ,p_val_attribute15_o
425: => pqp_val_shd.g_old_rec.val_attribute15
426: ,p_val_attribute16_o
427: => pqp_val_shd.g_old_rec.val_attribute16
428: ,p_val_attribute17_o
429: => pqp_val_shd.g_old_rec.val_attribute17

Line 427: => pqp_val_shd.g_old_rec.val_attribute16

423: => pqp_val_shd.g_old_rec.val_attribute14
424: ,p_val_attribute15_o
425: => pqp_val_shd.g_old_rec.val_attribute15
426: ,p_val_attribute16_o
427: => pqp_val_shd.g_old_rec.val_attribute16
428: ,p_val_attribute17_o
429: => pqp_val_shd.g_old_rec.val_attribute17
430: ,p_val_attribute18_o
431: => pqp_val_shd.g_old_rec.val_attribute18

Line 429: => pqp_val_shd.g_old_rec.val_attribute17

425: => pqp_val_shd.g_old_rec.val_attribute15
426: ,p_val_attribute16_o
427: => pqp_val_shd.g_old_rec.val_attribute16
428: ,p_val_attribute17_o
429: => pqp_val_shd.g_old_rec.val_attribute17
430: ,p_val_attribute18_o
431: => pqp_val_shd.g_old_rec.val_attribute18
432: ,p_val_attribute19_o
433: => pqp_val_shd.g_old_rec.val_attribute19

Line 431: => pqp_val_shd.g_old_rec.val_attribute18

427: => pqp_val_shd.g_old_rec.val_attribute16
428: ,p_val_attribute17_o
429: => pqp_val_shd.g_old_rec.val_attribute17
430: ,p_val_attribute18_o
431: => pqp_val_shd.g_old_rec.val_attribute18
432: ,p_val_attribute19_o
433: => pqp_val_shd.g_old_rec.val_attribute19
434: ,p_val_attribute20_o
435: => pqp_val_shd.g_old_rec.val_attribute20

Line 433: => pqp_val_shd.g_old_rec.val_attribute19

429: => pqp_val_shd.g_old_rec.val_attribute17
430: ,p_val_attribute18_o
431: => pqp_val_shd.g_old_rec.val_attribute18
432: ,p_val_attribute19_o
433: => pqp_val_shd.g_old_rec.val_attribute19
434: ,p_val_attribute20_o
435: => pqp_val_shd.g_old_rec.val_attribute20
436: ,p_val_information_category_o
437: => pqp_val_shd.g_old_rec.val_information_category

Line 435: => pqp_val_shd.g_old_rec.val_attribute20

431: => pqp_val_shd.g_old_rec.val_attribute18
432: ,p_val_attribute19_o
433: => pqp_val_shd.g_old_rec.val_attribute19
434: ,p_val_attribute20_o
435: => pqp_val_shd.g_old_rec.val_attribute20
436: ,p_val_information_category_o
437: => pqp_val_shd.g_old_rec.val_information_category
438: ,p_val_information1_o
439: => pqp_val_shd.g_old_rec.val_information1

Line 437: => pqp_val_shd.g_old_rec.val_information_category

433: => pqp_val_shd.g_old_rec.val_attribute19
434: ,p_val_attribute20_o
435: => pqp_val_shd.g_old_rec.val_attribute20
436: ,p_val_information_category_o
437: => pqp_val_shd.g_old_rec.val_information_category
438: ,p_val_information1_o
439: => pqp_val_shd.g_old_rec.val_information1
440: ,p_val_information2_o
441: => pqp_val_shd.g_old_rec.val_information2

Line 439: => pqp_val_shd.g_old_rec.val_information1

435: => pqp_val_shd.g_old_rec.val_attribute20
436: ,p_val_information_category_o
437: => pqp_val_shd.g_old_rec.val_information_category
438: ,p_val_information1_o
439: => pqp_val_shd.g_old_rec.val_information1
440: ,p_val_information2_o
441: => pqp_val_shd.g_old_rec.val_information2
442: ,p_val_information3_o
443: => pqp_val_shd.g_old_rec.val_information3

Line 441: => pqp_val_shd.g_old_rec.val_information2

437: => pqp_val_shd.g_old_rec.val_information_category
438: ,p_val_information1_o
439: => pqp_val_shd.g_old_rec.val_information1
440: ,p_val_information2_o
441: => pqp_val_shd.g_old_rec.val_information2
442: ,p_val_information3_o
443: => pqp_val_shd.g_old_rec.val_information3
444: ,p_val_information4_o
445: => pqp_val_shd.g_old_rec.val_information4

Line 443: => pqp_val_shd.g_old_rec.val_information3

439: => pqp_val_shd.g_old_rec.val_information1
440: ,p_val_information2_o
441: => pqp_val_shd.g_old_rec.val_information2
442: ,p_val_information3_o
443: => pqp_val_shd.g_old_rec.val_information3
444: ,p_val_information4_o
445: => pqp_val_shd.g_old_rec.val_information4
446: ,p_val_information5_o
447: => pqp_val_shd.g_old_rec.val_information5

Line 445: => pqp_val_shd.g_old_rec.val_information4

441: => pqp_val_shd.g_old_rec.val_information2
442: ,p_val_information3_o
443: => pqp_val_shd.g_old_rec.val_information3
444: ,p_val_information4_o
445: => pqp_val_shd.g_old_rec.val_information4
446: ,p_val_information5_o
447: => pqp_val_shd.g_old_rec.val_information5
448: ,p_val_information6_o
449: => pqp_val_shd.g_old_rec.val_information6

Line 447: => pqp_val_shd.g_old_rec.val_information5

443: => pqp_val_shd.g_old_rec.val_information3
444: ,p_val_information4_o
445: => pqp_val_shd.g_old_rec.val_information4
446: ,p_val_information5_o
447: => pqp_val_shd.g_old_rec.val_information5
448: ,p_val_information6_o
449: => pqp_val_shd.g_old_rec.val_information6
450: ,p_val_information7_o
451: => pqp_val_shd.g_old_rec.val_information7

Line 449: => pqp_val_shd.g_old_rec.val_information6

445: => pqp_val_shd.g_old_rec.val_information4
446: ,p_val_information5_o
447: => pqp_val_shd.g_old_rec.val_information5
448: ,p_val_information6_o
449: => pqp_val_shd.g_old_rec.val_information6
450: ,p_val_information7_o
451: => pqp_val_shd.g_old_rec.val_information7
452: ,p_val_information8_o
453: => pqp_val_shd.g_old_rec.val_information8

Line 451: => pqp_val_shd.g_old_rec.val_information7

447: => pqp_val_shd.g_old_rec.val_information5
448: ,p_val_information6_o
449: => pqp_val_shd.g_old_rec.val_information6
450: ,p_val_information7_o
451: => pqp_val_shd.g_old_rec.val_information7
452: ,p_val_information8_o
453: => pqp_val_shd.g_old_rec.val_information8
454: ,p_val_information9_o
455: => pqp_val_shd.g_old_rec.val_information9

Line 453: => pqp_val_shd.g_old_rec.val_information8

449: => pqp_val_shd.g_old_rec.val_information6
450: ,p_val_information7_o
451: => pqp_val_shd.g_old_rec.val_information7
452: ,p_val_information8_o
453: => pqp_val_shd.g_old_rec.val_information8
454: ,p_val_information9_o
455: => pqp_val_shd.g_old_rec.val_information9
456: ,p_val_information10_o
457: => pqp_val_shd.g_old_rec.val_information10

Line 455: => pqp_val_shd.g_old_rec.val_information9

451: => pqp_val_shd.g_old_rec.val_information7
452: ,p_val_information8_o
453: => pqp_val_shd.g_old_rec.val_information8
454: ,p_val_information9_o
455: => pqp_val_shd.g_old_rec.val_information9
456: ,p_val_information10_o
457: => pqp_val_shd.g_old_rec.val_information10
458: ,p_val_information11_o
459: => pqp_val_shd.g_old_rec.val_information11

Line 457: => pqp_val_shd.g_old_rec.val_information10

453: => pqp_val_shd.g_old_rec.val_information8
454: ,p_val_information9_o
455: => pqp_val_shd.g_old_rec.val_information9
456: ,p_val_information10_o
457: => pqp_val_shd.g_old_rec.val_information10
458: ,p_val_information11_o
459: => pqp_val_shd.g_old_rec.val_information11
460: ,p_val_information12_o
461: => pqp_val_shd.g_old_rec.val_information12

Line 459: => pqp_val_shd.g_old_rec.val_information11

455: => pqp_val_shd.g_old_rec.val_information9
456: ,p_val_information10_o
457: => pqp_val_shd.g_old_rec.val_information10
458: ,p_val_information11_o
459: => pqp_val_shd.g_old_rec.val_information11
460: ,p_val_information12_o
461: => pqp_val_shd.g_old_rec.val_information12
462: ,p_val_information13_o
463: => pqp_val_shd.g_old_rec.val_information13

Line 461: => pqp_val_shd.g_old_rec.val_information12

457: => pqp_val_shd.g_old_rec.val_information10
458: ,p_val_information11_o
459: => pqp_val_shd.g_old_rec.val_information11
460: ,p_val_information12_o
461: => pqp_val_shd.g_old_rec.val_information12
462: ,p_val_information13_o
463: => pqp_val_shd.g_old_rec.val_information13
464: ,p_val_information14_o
465: => pqp_val_shd.g_old_rec.val_information14

Line 463: => pqp_val_shd.g_old_rec.val_information13

459: => pqp_val_shd.g_old_rec.val_information11
460: ,p_val_information12_o
461: => pqp_val_shd.g_old_rec.val_information12
462: ,p_val_information13_o
463: => pqp_val_shd.g_old_rec.val_information13
464: ,p_val_information14_o
465: => pqp_val_shd.g_old_rec.val_information14
466: ,p_val_information15_o
467: => pqp_val_shd.g_old_rec.val_information15

Line 465: => pqp_val_shd.g_old_rec.val_information14

461: => pqp_val_shd.g_old_rec.val_information12
462: ,p_val_information13_o
463: => pqp_val_shd.g_old_rec.val_information13
464: ,p_val_information14_o
465: => pqp_val_shd.g_old_rec.val_information14
466: ,p_val_information15_o
467: => pqp_val_shd.g_old_rec.val_information15
468: ,p_val_information16_o
469: => pqp_val_shd.g_old_rec.val_information16

Line 467: => pqp_val_shd.g_old_rec.val_information15

463: => pqp_val_shd.g_old_rec.val_information13
464: ,p_val_information14_o
465: => pqp_val_shd.g_old_rec.val_information14
466: ,p_val_information15_o
467: => pqp_val_shd.g_old_rec.val_information15
468: ,p_val_information16_o
469: => pqp_val_shd.g_old_rec.val_information16
470: ,p_val_information17_o
471: => pqp_val_shd.g_old_rec.val_information17

Line 469: => pqp_val_shd.g_old_rec.val_information16

465: => pqp_val_shd.g_old_rec.val_information14
466: ,p_val_information15_o
467: => pqp_val_shd.g_old_rec.val_information15
468: ,p_val_information16_o
469: => pqp_val_shd.g_old_rec.val_information16
470: ,p_val_information17_o
471: => pqp_val_shd.g_old_rec.val_information17
472: ,p_val_information18_o
473: => pqp_val_shd.g_old_rec.val_information18

Line 471: => pqp_val_shd.g_old_rec.val_information17

467: => pqp_val_shd.g_old_rec.val_information15
468: ,p_val_information16_o
469: => pqp_val_shd.g_old_rec.val_information16
470: ,p_val_information17_o
471: => pqp_val_shd.g_old_rec.val_information17
472: ,p_val_information18_o
473: => pqp_val_shd.g_old_rec.val_information18
474: ,p_val_information19_o
475: => pqp_val_shd.g_old_rec.val_information19

Line 473: => pqp_val_shd.g_old_rec.val_information18

469: => pqp_val_shd.g_old_rec.val_information16
470: ,p_val_information17_o
471: => pqp_val_shd.g_old_rec.val_information17
472: ,p_val_information18_o
473: => pqp_val_shd.g_old_rec.val_information18
474: ,p_val_information19_o
475: => pqp_val_shd.g_old_rec.val_information19
476: ,p_val_information20_o
477: => pqp_val_shd.g_old_rec.val_information20

Line 475: => pqp_val_shd.g_old_rec.val_information19

471: => pqp_val_shd.g_old_rec.val_information17
472: ,p_val_information18_o
473: => pqp_val_shd.g_old_rec.val_information18
474: ,p_val_information19_o
475: => pqp_val_shd.g_old_rec.val_information19
476: ,p_val_information20_o
477: => pqp_val_shd.g_old_rec.val_information20
478: ,p_object_version_number_o
479: => pqp_val_shd.g_old_rec.object_version_number

Line 477: => pqp_val_shd.g_old_rec.val_information20

473: => pqp_val_shd.g_old_rec.val_information18
474: ,p_val_information19_o
475: => pqp_val_shd.g_old_rec.val_information19
476: ,p_val_information20_o
477: => pqp_val_shd.g_old_rec.val_information20
478: ,p_object_version_number_o
479: => pqp_val_shd.g_old_rec.object_version_number
480: ,p_fuel_benefit_o
481: => pqp_val_shd.g_old_rec.fuel_benefit

Line 479: => pqp_val_shd.g_old_rec.object_version_number

475: => pqp_val_shd.g_old_rec.val_information19
476: ,p_val_information20_o
477: => pqp_val_shd.g_old_rec.val_information20
478: ,p_object_version_number_o
479: => pqp_val_shd.g_old_rec.object_version_number
480: ,p_fuel_benefit_o
481: => pqp_val_shd.g_old_rec.fuel_benefit
482: ,p_sliding_rates_info_o
483: => pqp_val_shd.g_old_rec.sliding_rates_info

Line 481: => pqp_val_shd.g_old_rec.fuel_benefit

477: => pqp_val_shd.g_old_rec.val_information20
478: ,p_object_version_number_o
479: => pqp_val_shd.g_old_rec.object_version_number
480: ,p_fuel_benefit_o
481: => pqp_val_shd.g_old_rec.fuel_benefit
482: ,p_sliding_rates_info_o
483: => pqp_val_shd.g_old_rec.sliding_rates_info
484:
485: );

Line 483: => pqp_val_shd.g_old_rec.sliding_rates_info

479: => pqp_val_shd.g_old_rec.object_version_number
480: ,p_fuel_benefit_o
481: => pqp_val_shd.g_old_rec.fuel_benefit
482: ,p_sliding_rates_info_o
483: => pqp_val_shd.g_old_rec.sliding_rates_info
484:
485: );
486: --
487: exception

Line 505: ,p_rec in out nocopy pqp_val_shd.g_rec_type

501: -- ----------------------------------------------------------------------------
502: Procedure del
503: (p_effective_date in date
504: ,p_datetrack_mode in varchar2
505: ,p_rec in out nocopy pqp_val_shd.g_rec_type
506: ) is
507: --
508: l_proc varchar2(72) := g_package||'del';
509: l_validation_start_date date;

Line 521: pqp_val_shd.lck

517: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
518: --
519: -- We must lock the row which we need to delete.
520: --
521: pqp_val_shd.lck
522: (p_effective_date => p_effective_date
523: ,p_datetrack_mode => p_datetrack_mode
524: ,p_vehicle_allocation_id => p_rec.vehicle_allocation_id
525: ,p_object_version_number => p_rec.object_version_number

Line 605: l_rec pqp_val_shd.g_rec_type;

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