APPS.PQP_AAT_DEL dependencies on PQP_AAT_SHD

Line 54: (p_rec in out nocopy pqp_aat_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ---------------------------------------------------------------------------+
53: Procedure dt_delete_dml
54: (p_rec in out nocopy pqp_aat_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 66: pqp_aat_shd.g_api_dml := true; -- Set the api dml status

62: --
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: If (p_datetrack_mode = hr_api.g_delete_next_change) then
66: pqp_aat_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --

Line 75: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status

71: delete from pqp_assignment_attributes_f
72: where assignment_attribute_id = p_rec.assignment_attribute_id
73: and effective_start_date = p_validation_start_date;
74: --
75: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: pqp_aat_shd.g_api_dml := true; -- Set the api dml status
78: --
79: -- Delete the row(s) where the effective start date is greater than

Line 77: pqp_aat_shd.g_api_dml := true; -- Set the api dml status

73: and effective_start_date = p_validation_start_date;
74: --
75: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: pqp_aat_shd.g_api_dml := true; -- Set the api dml status
78: --
79: -- Delete the row(s) where the effective start date is greater than
80: -- or equal to the validation start date.
81: --

Line 86: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status

82: delete from pqp_assignment_attributes_f
83: where assignment_attribute_id = p_rec.assignment_attribute_id
84: and effective_start_date >= p_validation_start_date;
85: --
86: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
87: End If;
88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --

Line 93: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status

89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --
91: Exception
92: When Others Then
93: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
94: Raise;
95: --
96: End dt_delete_dml;
97: --

Line 102: (p_rec in out nocopy pqp_aat_shd.g_rec_type

98: -- ---------------------------------------------------------------------------+
99: -- |------------------------------< delete_dml >------------------------------|
100: -- ---------------------------------------------------------------------------+
101: Procedure delete_dml
102: (p_rec in out nocopy pqp_aat_shd.g_rec_type
103: ,p_effective_date in date
104: ,p_datetrack_mode in varchar2
105: ,p_validation_start_date in date
106: ,p_validation_end_date in date

Line 159: (p_rec in out nocopy pqp_aat_shd.g_rec_type

155: --
156: -- {End Of Comments}
157: -- ---------------------------------------------------------------------------+
158: Procedure dt_pre_delete
159: (p_rec in out nocopy pqp_aat_shd.g_rec_type
160: ,p_effective_date in date
161: ,p_datetrack_mode in varchar2
162: ,p_validation_start_date in date
163: ,p_validation_end_date in date

Line 174: := pqp_aat_shd.g_old_rec.effective_start_date;

170: --
171: If (p_datetrack_mode <> hr_api.g_zap) then
172: --
173: p_rec.effective_start_date
174: := pqp_aat_shd.g_old_rec.effective_start_date;
175: --
176: If (p_datetrack_mode = hr_api.g_delete) then
177: p_rec.effective_end_date := p_validation_start_date - 1;
178: Else

Line 184: pqp_aat_shd.upd_effective_end_date

180: End If;
181: --
182: -- Update the current effective end date record
183: --
184: pqp_aat_shd.upd_effective_end_date
185: (p_effective_date => p_effective_date
186: ,p_base_key_value => p_rec.assignment_attribute_id
187: ,p_new_effective_end_date => p_rec.effective_end_date
188: ,p_validation_start_date => p_validation_start_date

Line 233: (p_rec in out nocopy pqp_aat_shd.g_rec_type

229: --
230: -- {End Of Comments}
231: -- ---------------------------------------------------------------------------+
232: Procedure pre_delete
233: (p_rec in out nocopy pqp_aat_shd.g_rec_type
234: ,p_effective_date in date
235: ,p_datetrack_mode in varchar2
236: ,p_validation_start_date in date
237: ,p_validation_end_date in date

Line 293: (p_rec in pqp_aat_shd.g_rec_type

289: --
290: -- {End Of Comments}
291: -- ---------------------------------------------------------------------------+
292: Procedure post_delete
293: (p_rec in pqp_aat_shd.g_rec_type
294: ,p_effective_date in date
295: ,p_datetrack_mode in varchar2
296: ,p_validation_start_date in date
297: ,p_validation_end_date in date

Line 322: => pqp_aat_shd.g_old_rec.effective_start_date

318: => p_rec.effective_start_date
319: ,p_effective_end_date
320: => p_rec.effective_end_date
321: ,p_effective_start_date_o
322: => pqp_aat_shd.g_old_rec.effective_start_date
323: ,p_effective_end_date_o
324: => pqp_aat_shd.g_old_rec.effective_end_date
325: ,p_business_group_id_o
326: => pqp_aat_shd.g_old_rec.business_group_id

Line 324: => pqp_aat_shd.g_old_rec.effective_end_date

320: => p_rec.effective_end_date
321: ,p_effective_start_date_o
322: => pqp_aat_shd.g_old_rec.effective_start_date
323: ,p_effective_end_date_o
324: => pqp_aat_shd.g_old_rec.effective_end_date
325: ,p_business_group_id_o
326: => pqp_aat_shd.g_old_rec.business_group_id
327: ,p_assignment_id_o
328: => pqp_aat_shd.g_old_rec.assignment_id

Line 326: => pqp_aat_shd.g_old_rec.business_group_id

322: => pqp_aat_shd.g_old_rec.effective_start_date
323: ,p_effective_end_date_o
324: => pqp_aat_shd.g_old_rec.effective_end_date
325: ,p_business_group_id_o
326: => pqp_aat_shd.g_old_rec.business_group_id
327: ,p_assignment_id_o
328: => pqp_aat_shd.g_old_rec.assignment_id
329: ,p_contract_type_o
330: => pqp_aat_shd.g_old_rec.contract_type

Line 328: => pqp_aat_shd.g_old_rec.assignment_id

324: => pqp_aat_shd.g_old_rec.effective_end_date
325: ,p_business_group_id_o
326: => pqp_aat_shd.g_old_rec.business_group_id
327: ,p_assignment_id_o
328: => pqp_aat_shd.g_old_rec.assignment_id
329: ,p_contract_type_o
330: => pqp_aat_shd.g_old_rec.contract_type
331: ,p_work_pattern_o
332: => pqp_aat_shd.g_old_rec.work_pattern

Line 330: => pqp_aat_shd.g_old_rec.contract_type

326: => pqp_aat_shd.g_old_rec.business_group_id
327: ,p_assignment_id_o
328: => pqp_aat_shd.g_old_rec.assignment_id
329: ,p_contract_type_o
330: => pqp_aat_shd.g_old_rec.contract_type
331: ,p_work_pattern_o
332: => pqp_aat_shd.g_old_rec.work_pattern
333: ,p_start_day_o
334: => pqp_aat_shd.g_old_rec.start_day

Line 332: => pqp_aat_shd.g_old_rec.work_pattern

328: => pqp_aat_shd.g_old_rec.assignment_id
329: ,p_contract_type_o
330: => pqp_aat_shd.g_old_rec.contract_type
331: ,p_work_pattern_o
332: => pqp_aat_shd.g_old_rec.work_pattern
333: ,p_start_day_o
334: => pqp_aat_shd.g_old_rec.start_day
335: ,p_object_version_number_o
336: => pqp_aat_shd.g_old_rec.object_version_number

Line 334: => pqp_aat_shd.g_old_rec.start_day

330: => pqp_aat_shd.g_old_rec.contract_type
331: ,p_work_pattern_o
332: => pqp_aat_shd.g_old_rec.work_pattern
333: ,p_start_day_o
334: => pqp_aat_shd.g_old_rec.start_day
335: ,p_object_version_number_o
336: => pqp_aat_shd.g_old_rec.object_version_number
337: ,p_primary_company_car_o
338: => pqp_aat_shd.g_old_rec.primary_company_car

Line 336: => pqp_aat_shd.g_old_rec.object_version_number

332: => pqp_aat_shd.g_old_rec.work_pattern
333: ,p_start_day_o
334: => pqp_aat_shd.g_old_rec.start_day
335: ,p_object_version_number_o
336: => pqp_aat_shd.g_old_rec.object_version_number
337: ,p_primary_company_car_o
338: => pqp_aat_shd.g_old_rec.primary_company_car
339: ,p_primary_car_fuel_benefit_o
340: => pqp_aat_shd.g_old_rec.primary_car_fuel_benefit

Line 338: => pqp_aat_shd.g_old_rec.primary_company_car

334: => pqp_aat_shd.g_old_rec.start_day
335: ,p_object_version_number_o
336: => pqp_aat_shd.g_old_rec.object_version_number
337: ,p_primary_company_car_o
338: => pqp_aat_shd.g_old_rec.primary_company_car
339: ,p_primary_car_fuel_benefit_o
340: => pqp_aat_shd.g_old_rec.primary_car_fuel_benefit
341: ,p_primary_class_1a_o
342: => pqp_aat_shd.g_old_rec.primary_class_1a

Line 340: => pqp_aat_shd.g_old_rec.primary_car_fuel_benefit

336: => pqp_aat_shd.g_old_rec.object_version_number
337: ,p_primary_company_car_o
338: => pqp_aat_shd.g_old_rec.primary_company_car
339: ,p_primary_car_fuel_benefit_o
340: => pqp_aat_shd.g_old_rec.primary_car_fuel_benefit
341: ,p_primary_class_1a_o
342: => pqp_aat_shd.g_old_rec.primary_class_1a
343: ,p_primary_capital_contributi_o
344: => pqp_aat_shd.g_old_rec.primary_capital_contribution

Line 342: => pqp_aat_shd.g_old_rec.primary_class_1a

338: => pqp_aat_shd.g_old_rec.primary_company_car
339: ,p_primary_car_fuel_benefit_o
340: => pqp_aat_shd.g_old_rec.primary_car_fuel_benefit
341: ,p_primary_class_1a_o
342: => pqp_aat_shd.g_old_rec.primary_class_1a
343: ,p_primary_capital_contributi_o
344: => pqp_aat_shd.g_old_rec.primary_capital_contribution
345: ,p_primary_private_contributi_o
346: => pqp_aat_shd.g_old_rec.primary_private_contribution

Line 344: => pqp_aat_shd.g_old_rec.primary_capital_contribution

340: => pqp_aat_shd.g_old_rec.primary_car_fuel_benefit
341: ,p_primary_class_1a_o
342: => pqp_aat_shd.g_old_rec.primary_class_1a
343: ,p_primary_capital_contributi_o
344: => pqp_aat_shd.g_old_rec.primary_capital_contribution
345: ,p_primary_private_contributi_o
346: => pqp_aat_shd.g_old_rec.primary_private_contribution
347: ,p_secondary_company_car_o
348: => pqp_aat_shd.g_old_rec.secondary_company_car

Line 346: => pqp_aat_shd.g_old_rec.primary_private_contribution

342: => pqp_aat_shd.g_old_rec.primary_class_1a
343: ,p_primary_capital_contributi_o
344: => pqp_aat_shd.g_old_rec.primary_capital_contribution
345: ,p_primary_private_contributi_o
346: => pqp_aat_shd.g_old_rec.primary_private_contribution
347: ,p_secondary_company_car_o
348: => pqp_aat_shd.g_old_rec.secondary_company_car
349: ,p_secondary_car_fuel_benefit_o
350: => pqp_aat_shd.g_old_rec.secondary_car_fuel_benefit

Line 348: => pqp_aat_shd.g_old_rec.secondary_company_car

344: => pqp_aat_shd.g_old_rec.primary_capital_contribution
345: ,p_primary_private_contributi_o
346: => pqp_aat_shd.g_old_rec.primary_private_contribution
347: ,p_secondary_company_car_o
348: => pqp_aat_shd.g_old_rec.secondary_company_car
349: ,p_secondary_car_fuel_benefit_o
350: => pqp_aat_shd.g_old_rec.secondary_car_fuel_benefit
351: ,p_secondary_class_1a_o
352: => pqp_aat_shd.g_old_rec.secondary_class_1a

Line 350: => pqp_aat_shd.g_old_rec.secondary_car_fuel_benefit

346: => pqp_aat_shd.g_old_rec.primary_private_contribution
347: ,p_secondary_company_car_o
348: => pqp_aat_shd.g_old_rec.secondary_company_car
349: ,p_secondary_car_fuel_benefit_o
350: => pqp_aat_shd.g_old_rec.secondary_car_fuel_benefit
351: ,p_secondary_class_1a_o
352: => pqp_aat_shd.g_old_rec.secondary_class_1a
353: ,p_secondary_capital_contribu_o
354: => pqp_aat_shd.g_old_rec.secondary_capital_contribution

Line 352: => pqp_aat_shd.g_old_rec.secondary_class_1a

348: => pqp_aat_shd.g_old_rec.secondary_company_car
349: ,p_secondary_car_fuel_benefit_o
350: => pqp_aat_shd.g_old_rec.secondary_car_fuel_benefit
351: ,p_secondary_class_1a_o
352: => pqp_aat_shd.g_old_rec.secondary_class_1a
353: ,p_secondary_capital_contribu_o
354: => pqp_aat_shd.g_old_rec.secondary_capital_contribution
355: ,p_secondary_private_contribu_o
356: => pqp_aat_shd.g_old_rec.secondary_private_contribution

Line 354: => pqp_aat_shd.g_old_rec.secondary_capital_contribution

350: => pqp_aat_shd.g_old_rec.secondary_car_fuel_benefit
351: ,p_secondary_class_1a_o
352: => pqp_aat_shd.g_old_rec.secondary_class_1a
353: ,p_secondary_capital_contribu_o
354: => pqp_aat_shd.g_old_rec.secondary_capital_contribution
355: ,p_secondary_private_contribu_o
356: => pqp_aat_shd.g_old_rec.secondary_private_contribution
357: ,p_company_car_calc_method_o
358: => pqp_aat_shd.g_old_rec.company_car_calc_method

Line 356: => pqp_aat_shd.g_old_rec.secondary_private_contribution

352: => pqp_aat_shd.g_old_rec.secondary_class_1a
353: ,p_secondary_capital_contribu_o
354: => pqp_aat_shd.g_old_rec.secondary_capital_contribution
355: ,p_secondary_private_contribu_o
356: => pqp_aat_shd.g_old_rec.secondary_private_contribution
357: ,p_company_car_calc_method_o
358: => pqp_aat_shd.g_old_rec.company_car_calc_method
359: ,p_company_car_rates_table_id_o
360: => pqp_aat_shd.g_old_rec.company_car_rates_table_id

Line 358: => pqp_aat_shd.g_old_rec.company_car_calc_method

354: => pqp_aat_shd.g_old_rec.secondary_capital_contribution
355: ,p_secondary_private_contribu_o
356: => pqp_aat_shd.g_old_rec.secondary_private_contribution
357: ,p_company_car_calc_method_o
358: => pqp_aat_shd.g_old_rec.company_car_calc_method
359: ,p_company_car_rates_table_id_o
360: => pqp_aat_shd.g_old_rec.company_car_rates_table_id
361: ,p_company_car_secondary_tabl_o
362: => pqp_aat_shd.g_old_rec.company_car_secondary_table_id

Line 360: => pqp_aat_shd.g_old_rec.company_car_rates_table_id

356: => pqp_aat_shd.g_old_rec.secondary_private_contribution
357: ,p_company_car_calc_method_o
358: => pqp_aat_shd.g_old_rec.company_car_calc_method
359: ,p_company_car_rates_table_id_o
360: => pqp_aat_shd.g_old_rec.company_car_rates_table_id
361: ,p_company_car_secondary_tabl_o
362: => pqp_aat_shd.g_old_rec.company_car_secondary_table_id
363: ,p_private_car_o
364: => pqp_aat_shd.g_old_rec.private_car

Line 362: => pqp_aat_shd.g_old_rec.company_car_secondary_table_id

358: => pqp_aat_shd.g_old_rec.company_car_calc_method
359: ,p_company_car_rates_table_id_o
360: => pqp_aat_shd.g_old_rec.company_car_rates_table_id
361: ,p_company_car_secondary_tabl_o
362: => pqp_aat_shd.g_old_rec.company_car_secondary_table_id
363: ,p_private_car_o
364: => pqp_aat_shd.g_old_rec.private_car
365: ,p_private_car_calc_method_o
366: => pqp_aat_shd.g_old_rec.private_car_calc_method

Line 364: => pqp_aat_shd.g_old_rec.private_car

360: => pqp_aat_shd.g_old_rec.company_car_rates_table_id
361: ,p_company_car_secondary_tabl_o
362: => pqp_aat_shd.g_old_rec.company_car_secondary_table_id
363: ,p_private_car_o
364: => pqp_aat_shd.g_old_rec.private_car
365: ,p_private_car_calc_method_o
366: => pqp_aat_shd.g_old_rec.private_car_calc_method
367: ,p_private_car_rates_table_id_o
368: => pqp_aat_shd.g_old_rec.private_car_rates_table_id

Line 366: => pqp_aat_shd.g_old_rec.private_car_calc_method

362: => pqp_aat_shd.g_old_rec.company_car_secondary_table_id
363: ,p_private_car_o
364: => pqp_aat_shd.g_old_rec.private_car
365: ,p_private_car_calc_method_o
366: => pqp_aat_shd.g_old_rec.private_car_calc_method
367: ,p_private_car_rates_table_id_o
368: => pqp_aat_shd.g_old_rec.private_car_rates_table_id
369: ,p_private_car_essential_tabl_o
370: => pqp_aat_shd.g_old_rec.private_car_essential_table_id

Line 368: => pqp_aat_shd.g_old_rec.private_car_rates_table_id

364: => pqp_aat_shd.g_old_rec.private_car
365: ,p_private_car_calc_method_o
366: => pqp_aat_shd.g_old_rec.private_car_calc_method
367: ,p_private_car_rates_table_id_o
368: => pqp_aat_shd.g_old_rec.private_car_rates_table_id
369: ,p_private_car_essential_tabl_o
370: => pqp_aat_shd.g_old_rec.private_car_essential_table_id
371: ,p_tp_is_teacher_o
372: => pqp_aat_shd.g_old_rec.tp_is_teacher

Line 370: => pqp_aat_shd.g_old_rec.private_car_essential_table_id

366: => pqp_aat_shd.g_old_rec.private_car_calc_method
367: ,p_private_car_rates_table_id_o
368: => pqp_aat_shd.g_old_rec.private_car_rates_table_id
369: ,p_private_car_essential_tabl_o
370: => pqp_aat_shd.g_old_rec.private_car_essential_table_id
371: ,p_tp_is_teacher_o
372: => pqp_aat_shd.g_old_rec.tp_is_teacher
373: ,p_tp_headteacher_grp_code_o --added for head Teacher seconded location for salary scale calculation
374: => pqp_aat_shd.g_old_rec.tp_headteacher_grp_code

Line 372: => pqp_aat_shd.g_old_rec.tp_is_teacher

368: => pqp_aat_shd.g_old_rec.private_car_rates_table_id
369: ,p_private_car_essential_tabl_o
370: => pqp_aat_shd.g_old_rec.private_car_essential_table_id
371: ,p_tp_is_teacher_o
372: => pqp_aat_shd.g_old_rec.tp_is_teacher
373: ,p_tp_headteacher_grp_code_o --added for head Teacher seconded location for salary scale calculation
374: => pqp_aat_shd.g_old_rec.tp_headteacher_grp_code
375: ,p_tp_safeguarded_grade_o
376: => pqp_aat_shd.g_old_rec.tp_safeguarded_grade

Line 374: => pqp_aat_shd.g_old_rec.tp_headteacher_grp_code

370: => pqp_aat_shd.g_old_rec.private_car_essential_table_id
371: ,p_tp_is_teacher_o
372: => pqp_aat_shd.g_old_rec.tp_is_teacher
373: ,p_tp_headteacher_grp_code_o --added for head Teacher seconded location for salary scale calculation
374: => pqp_aat_shd.g_old_rec.tp_headteacher_grp_code
375: ,p_tp_safeguarded_grade_o
376: => pqp_aat_shd.g_old_rec.tp_safeguarded_grade
377: ,p_tp_safeguarded_grade_id_o
378: => pqp_aat_shd.g_old_rec.tp_safeguarded_grade_id

Line 376: => pqp_aat_shd.g_old_rec.tp_safeguarded_grade

372: => pqp_aat_shd.g_old_rec.tp_is_teacher
373: ,p_tp_headteacher_grp_code_o --added for head Teacher seconded location for salary scale calculation
374: => pqp_aat_shd.g_old_rec.tp_headteacher_grp_code
375: ,p_tp_safeguarded_grade_o
376: => pqp_aat_shd.g_old_rec.tp_safeguarded_grade
377: ,p_tp_safeguarded_grade_id_o
378: => pqp_aat_shd.g_old_rec.tp_safeguarded_grade_id
379: ,p_tp_safeguarded_rate_type_o
380: => pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type

Line 378: => pqp_aat_shd.g_old_rec.tp_safeguarded_grade_id

374: => pqp_aat_shd.g_old_rec.tp_headteacher_grp_code
375: ,p_tp_safeguarded_grade_o
376: => pqp_aat_shd.g_old_rec.tp_safeguarded_grade
377: ,p_tp_safeguarded_grade_id_o
378: => pqp_aat_shd.g_old_rec.tp_safeguarded_grade_id
379: ,p_tp_safeguarded_rate_type_o
380: => pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type
381: ,p_tp_safeguarded_rate_id_o
382: => pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id

Line 380: => pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type

376: => pqp_aat_shd.g_old_rec.tp_safeguarded_grade
377: ,p_tp_safeguarded_grade_id_o
378: => pqp_aat_shd.g_old_rec.tp_safeguarded_grade_id
379: ,p_tp_safeguarded_rate_type_o
380: => pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type
381: ,p_tp_safeguarded_rate_id_o
382: => pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id
383: ,p_tp_spinal_point_id_o
384: => pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id

Line 382: => pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id

378: => pqp_aat_shd.g_old_rec.tp_safeguarded_grade_id
379: ,p_tp_safeguarded_rate_type_o
380: => pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type
381: ,p_tp_safeguarded_rate_id_o
382: => pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id
383: ,p_tp_spinal_point_id_o
384: => pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id
385: ,p_tp_elected_pension_o
386: => pqp_aat_shd.g_old_rec.tp_elected_pension

Line 384: => pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id

380: => pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type
381: ,p_tp_safeguarded_rate_id_o
382: => pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id
383: ,p_tp_spinal_point_id_o
384: => pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id
385: ,p_tp_elected_pension_o
386: => pqp_aat_shd.g_old_rec.tp_elected_pension
387: ,p_tp_fast_track_o
388: => pqp_aat_shd.g_old_rec.tp_fast_track

Line 386: => pqp_aat_shd.g_old_rec.tp_elected_pension

382: => pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id
383: ,p_tp_spinal_point_id_o
384: => pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id
385: ,p_tp_elected_pension_o
386: => pqp_aat_shd.g_old_rec.tp_elected_pension
387: ,p_tp_fast_track_o
388: => pqp_aat_shd.g_old_rec.tp_fast_track
389: ,p_aat_attribute_category_o
390: => pqp_aat_shd.g_old_rec.aat_attribute_category

Line 388: => pqp_aat_shd.g_old_rec.tp_fast_track

384: => pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id
385: ,p_tp_elected_pension_o
386: => pqp_aat_shd.g_old_rec.tp_elected_pension
387: ,p_tp_fast_track_o
388: => pqp_aat_shd.g_old_rec.tp_fast_track
389: ,p_aat_attribute_category_o
390: => pqp_aat_shd.g_old_rec.aat_attribute_category
391: ,p_aat_attribute1_o
392: => pqp_aat_shd.g_old_rec.aat_attribute1

Line 390: => pqp_aat_shd.g_old_rec.aat_attribute_category

386: => pqp_aat_shd.g_old_rec.tp_elected_pension
387: ,p_tp_fast_track_o
388: => pqp_aat_shd.g_old_rec.tp_fast_track
389: ,p_aat_attribute_category_o
390: => pqp_aat_shd.g_old_rec.aat_attribute_category
391: ,p_aat_attribute1_o
392: => pqp_aat_shd.g_old_rec.aat_attribute1
393: ,p_aat_attribute2_o
394: => pqp_aat_shd.g_old_rec.aat_attribute2

Line 392: => pqp_aat_shd.g_old_rec.aat_attribute1

388: => pqp_aat_shd.g_old_rec.tp_fast_track
389: ,p_aat_attribute_category_o
390: => pqp_aat_shd.g_old_rec.aat_attribute_category
391: ,p_aat_attribute1_o
392: => pqp_aat_shd.g_old_rec.aat_attribute1
393: ,p_aat_attribute2_o
394: => pqp_aat_shd.g_old_rec.aat_attribute2
395: ,p_aat_attribute3_o
396: => pqp_aat_shd.g_old_rec.aat_attribute3

Line 394: => pqp_aat_shd.g_old_rec.aat_attribute2

390: => pqp_aat_shd.g_old_rec.aat_attribute_category
391: ,p_aat_attribute1_o
392: => pqp_aat_shd.g_old_rec.aat_attribute1
393: ,p_aat_attribute2_o
394: => pqp_aat_shd.g_old_rec.aat_attribute2
395: ,p_aat_attribute3_o
396: => pqp_aat_shd.g_old_rec.aat_attribute3
397: ,p_aat_attribute4_o
398: => pqp_aat_shd.g_old_rec.aat_attribute4

Line 396: => pqp_aat_shd.g_old_rec.aat_attribute3

392: => pqp_aat_shd.g_old_rec.aat_attribute1
393: ,p_aat_attribute2_o
394: => pqp_aat_shd.g_old_rec.aat_attribute2
395: ,p_aat_attribute3_o
396: => pqp_aat_shd.g_old_rec.aat_attribute3
397: ,p_aat_attribute4_o
398: => pqp_aat_shd.g_old_rec.aat_attribute4
399: ,p_aat_attribute5_o
400: => pqp_aat_shd.g_old_rec.aat_attribute5

Line 398: => pqp_aat_shd.g_old_rec.aat_attribute4

394: => pqp_aat_shd.g_old_rec.aat_attribute2
395: ,p_aat_attribute3_o
396: => pqp_aat_shd.g_old_rec.aat_attribute3
397: ,p_aat_attribute4_o
398: => pqp_aat_shd.g_old_rec.aat_attribute4
399: ,p_aat_attribute5_o
400: => pqp_aat_shd.g_old_rec.aat_attribute5
401: ,p_aat_attribute6_o
402: => pqp_aat_shd.g_old_rec.aat_attribute6

Line 400: => pqp_aat_shd.g_old_rec.aat_attribute5

396: => pqp_aat_shd.g_old_rec.aat_attribute3
397: ,p_aat_attribute4_o
398: => pqp_aat_shd.g_old_rec.aat_attribute4
399: ,p_aat_attribute5_o
400: => pqp_aat_shd.g_old_rec.aat_attribute5
401: ,p_aat_attribute6_o
402: => pqp_aat_shd.g_old_rec.aat_attribute6
403: ,p_aat_attribute7_o
404: => pqp_aat_shd.g_old_rec.aat_attribute7

Line 402: => pqp_aat_shd.g_old_rec.aat_attribute6

398: => pqp_aat_shd.g_old_rec.aat_attribute4
399: ,p_aat_attribute5_o
400: => pqp_aat_shd.g_old_rec.aat_attribute5
401: ,p_aat_attribute6_o
402: => pqp_aat_shd.g_old_rec.aat_attribute6
403: ,p_aat_attribute7_o
404: => pqp_aat_shd.g_old_rec.aat_attribute7
405: ,p_aat_attribute8_o
406: => pqp_aat_shd.g_old_rec.aat_attribute8

Line 404: => pqp_aat_shd.g_old_rec.aat_attribute7

400: => pqp_aat_shd.g_old_rec.aat_attribute5
401: ,p_aat_attribute6_o
402: => pqp_aat_shd.g_old_rec.aat_attribute6
403: ,p_aat_attribute7_o
404: => pqp_aat_shd.g_old_rec.aat_attribute7
405: ,p_aat_attribute8_o
406: => pqp_aat_shd.g_old_rec.aat_attribute8
407: ,p_aat_attribute9_o
408: => pqp_aat_shd.g_old_rec.aat_attribute9

Line 406: => pqp_aat_shd.g_old_rec.aat_attribute8

402: => pqp_aat_shd.g_old_rec.aat_attribute6
403: ,p_aat_attribute7_o
404: => pqp_aat_shd.g_old_rec.aat_attribute7
405: ,p_aat_attribute8_o
406: => pqp_aat_shd.g_old_rec.aat_attribute8
407: ,p_aat_attribute9_o
408: => pqp_aat_shd.g_old_rec.aat_attribute9
409: ,p_aat_attribute10_o
410: => pqp_aat_shd.g_old_rec.aat_attribute10

Line 408: => pqp_aat_shd.g_old_rec.aat_attribute9

404: => pqp_aat_shd.g_old_rec.aat_attribute7
405: ,p_aat_attribute8_o
406: => pqp_aat_shd.g_old_rec.aat_attribute8
407: ,p_aat_attribute9_o
408: => pqp_aat_shd.g_old_rec.aat_attribute9
409: ,p_aat_attribute10_o
410: => pqp_aat_shd.g_old_rec.aat_attribute10
411: ,p_aat_attribute11_o
412: => pqp_aat_shd.g_old_rec.aat_attribute11

Line 410: => pqp_aat_shd.g_old_rec.aat_attribute10

406: => pqp_aat_shd.g_old_rec.aat_attribute8
407: ,p_aat_attribute9_o
408: => pqp_aat_shd.g_old_rec.aat_attribute9
409: ,p_aat_attribute10_o
410: => pqp_aat_shd.g_old_rec.aat_attribute10
411: ,p_aat_attribute11_o
412: => pqp_aat_shd.g_old_rec.aat_attribute11
413: ,p_aat_attribute12_o
414: => pqp_aat_shd.g_old_rec.aat_attribute12

Line 412: => pqp_aat_shd.g_old_rec.aat_attribute11

408: => pqp_aat_shd.g_old_rec.aat_attribute9
409: ,p_aat_attribute10_o
410: => pqp_aat_shd.g_old_rec.aat_attribute10
411: ,p_aat_attribute11_o
412: => pqp_aat_shd.g_old_rec.aat_attribute11
413: ,p_aat_attribute12_o
414: => pqp_aat_shd.g_old_rec.aat_attribute12
415: ,p_aat_attribute13_o
416: => pqp_aat_shd.g_old_rec.aat_attribute13

Line 414: => pqp_aat_shd.g_old_rec.aat_attribute12

410: => pqp_aat_shd.g_old_rec.aat_attribute10
411: ,p_aat_attribute11_o
412: => pqp_aat_shd.g_old_rec.aat_attribute11
413: ,p_aat_attribute12_o
414: => pqp_aat_shd.g_old_rec.aat_attribute12
415: ,p_aat_attribute13_o
416: => pqp_aat_shd.g_old_rec.aat_attribute13
417: ,p_aat_attribute14_o
418: => pqp_aat_shd.g_old_rec.aat_attribute14

Line 416: => pqp_aat_shd.g_old_rec.aat_attribute13

412: => pqp_aat_shd.g_old_rec.aat_attribute11
413: ,p_aat_attribute12_o
414: => pqp_aat_shd.g_old_rec.aat_attribute12
415: ,p_aat_attribute13_o
416: => pqp_aat_shd.g_old_rec.aat_attribute13
417: ,p_aat_attribute14_o
418: => pqp_aat_shd.g_old_rec.aat_attribute14
419: ,p_aat_attribute15_o
420: => pqp_aat_shd.g_old_rec.aat_attribute15

Line 418: => pqp_aat_shd.g_old_rec.aat_attribute14

414: => pqp_aat_shd.g_old_rec.aat_attribute12
415: ,p_aat_attribute13_o
416: => pqp_aat_shd.g_old_rec.aat_attribute13
417: ,p_aat_attribute14_o
418: => pqp_aat_shd.g_old_rec.aat_attribute14
419: ,p_aat_attribute15_o
420: => pqp_aat_shd.g_old_rec.aat_attribute15
421: ,p_aat_attribute16_o
422: => pqp_aat_shd.g_old_rec.aat_attribute16

Line 420: => pqp_aat_shd.g_old_rec.aat_attribute15

416: => pqp_aat_shd.g_old_rec.aat_attribute13
417: ,p_aat_attribute14_o
418: => pqp_aat_shd.g_old_rec.aat_attribute14
419: ,p_aat_attribute15_o
420: => pqp_aat_shd.g_old_rec.aat_attribute15
421: ,p_aat_attribute16_o
422: => pqp_aat_shd.g_old_rec.aat_attribute16
423: ,p_aat_attribute17_o
424: => pqp_aat_shd.g_old_rec.aat_attribute17

Line 422: => pqp_aat_shd.g_old_rec.aat_attribute16

418: => pqp_aat_shd.g_old_rec.aat_attribute14
419: ,p_aat_attribute15_o
420: => pqp_aat_shd.g_old_rec.aat_attribute15
421: ,p_aat_attribute16_o
422: => pqp_aat_shd.g_old_rec.aat_attribute16
423: ,p_aat_attribute17_o
424: => pqp_aat_shd.g_old_rec.aat_attribute17
425: ,p_aat_attribute18_o
426: => pqp_aat_shd.g_old_rec.aat_attribute18

Line 424: => pqp_aat_shd.g_old_rec.aat_attribute17

420: => pqp_aat_shd.g_old_rec.aat_attribute15
421: ,p_aat_attribute16_o
422: => pqp_aat_shd.g_old_rec.aat_attribute16
423: ,p_aat_attribute17_o
424: => pqp_aat_shd.g_old_rec.aat_attribute17
425: ,p_aat_attribute18_o
426: => pqp_aat_shd.g_old_rec.aat_attribute18
427: ,p_aat_attribute19_o
428: => pqp_aat_shd.g_old_rec.aat_attribute19

Line 426: => pqp_aat_shd.g_old_rec.aat_attribute18

422: => pqp_aat_shd.g_old_rec.aat_attribute16
423: ,p_aat_attribute17_o
424: => pqp_aat_shd.g_old_rec.aat_attribute17
425: ,p_aat_attribute18_o
426: => pqp_aat_shd.g_old_rec.aat_attribute18
427: ,p_aat_attribute19_o
428: => pqp_aat_shd.g_old_rec.aat_attribute19
429: ,p_aat_attribute20_o
430: => pqp_aat_shd.g_old_rec.aat_attribute20

Line 428: => pqp_aat_shd.g_old_rec.aat_attribute19

424: => pqp_aat_shd.g_old_rec.aat_attribute17
425: ,p_aat_attribute18_o
426: => pqp_aat_shd.g_old_rec.aat_attribute18
427: ,p_aat_attribute19_o
428: => pqp_aat_shd.g_old_rec.aat_attribute19
429: ,p_aat_attribute20_o
430: => pqp_aat_shd.g_old_rec.aat_attribute20
431: ,p_aat_information_category_o
432: => pqp_aat_shd.g_old_rec.aat_information_category

Line 430: => pqp_aat_shd.g_old_rec.aat_attribute20

426: => pqp_aat_shd.g_old_rec.aat_attribute18
427: ,p_aat_attribute19_o
428: => pqp_aat_shd.g_old_rec.aat_attribute19
429: ,p_aat_attribute20_o
430: => pqp_aat_shd.g_old_rec.aat_attribute20
431: ,p_aat_information_category_o
432: => pqp_aat_shd.g_old_rec.aat_information_category
433: ,p_aat_information1_o
434: => pqp_aat_shd.g_old_rec.aat_information1

Line 432: => pqp_aat_shd.g_old_rec.aat_information_category

428: => pqp_aat_shd.g_old_rec.aat_attribute19
429: ,p_aat_attribute20_o
430: => pqp_aat_shd.g_old_rec.aat_attribute20
431: ,p_aat_information_category_o
432: => pqp_aat_shd.g_old_rec.aat_information_category
433: ,p_aat_information1_o
434: => pqp_aat_shd.g_old_rec.aat_information1
435: ,p_aat_information2_o
436: => pqp_aat_shd.g_old_rec.aat_information2

Line 434: => pqp_aat_shd.g_old_rec.aat_information1

430: => pqp_aat_shd.g_old_rec.aat_attribute20
431: ,p_aat_information_category_o
432: => pqp_aat_shd.g_old_rec.aat_information_category
433: ,p_aat_information1_o
434: => pqp_aat_shd.g_old_rec.aat_information1
435: ,p_aat_information2_o
436: => pqp_aat_shd.g_old_rec.aat_information2
437: ,p_aat_information3_o
438: => pqp_aat_shd.g_old_rec.aat_information3

Line 436: => pqp_aat_shd.g_old_rec.aat_information2

432: => pqp_aat_shd.g_old_rec.aat_information_category
433: ,p_aat_information1_o
434: => pqp_aat_shd.g_old_rec.aat_information1
435: ,p_aat_information2_o
436: => pqp_aat_shd.g_old_rec.aat_information2
437: ,p_aat_information3_o
438: => pqp_aat_shd.g_old_rec.aat_information3
439: ,p_aat_information4_o
440: => pqp_aat_shd.g_old_rec.aat_information4

Line 438: => pqp_aat_shd.g_old_rec.aat_information3

434: => pqp_aat_shd.g_old_rec.aat_information1
435: ,p_aat_information2_o
436: => pqp_aat_shd.g_old_rec.aat_information2
437: ,p_aat_information3_o
438: => pqp_aat_shd.g_old_rec.aat_information3
439: ,p_aat_information4_o
440: => pqp_aat_shd.g_old_rec.aat_information4
441: ,p_aat_information5_o
442: => pqp_aat_shd.g_old_rec.aat_information5

Line 440: => pqp_aat_shd.g_old_rec.aat_information4

436: => pqp_aat_shd.g_old_rec.aat_information2
437: ,p_aat_information3_o
438: => pqp_aat_shd.g_old_rec.aat_information3
439: ,p_aat_information4_o
440: => pqp_aat_shd.g_old_rec.aat_information4
441: ,p_aat_information5_o
442: => pqp_aat_shd.g_old_rec.aat_information5
443: ,p_aat_information6_o
444: => pqp_aat_shd.g_old_rec.aat_information6

Line 442: => pqp_aat_shd.g_old_rec.aat_information5

438: => pqp_aat_shd.g_old_rec.aat_information3
439: ,p_aat_information4_o
440: => pqp_aat_shd.g_old_rec.aat_information4
441: ,p_aat_information5_o
442: => pqp_aat_shd.g_old_rec.aat_information5
443: ,p_aat_information6_o
444: => pqp_aat_shd.g_old_rec.aat_information6
445: ,p_aat_information7_o
446: => pqp_aat_shd.g_old_rec.aat_information7

Line 444: => pqp_aat_shd.g_old_rec.aat_information6

440: => pqp_aat_shd.g_old_rec.aat_information4
441: ,p_aat_information5_o
442: => pqp_aat_shd.g_old_rec.aat_information5
443: ,p_aat_information6_o
444: => pqp_aat_shd.g_old_rec.aat_information6
445: ,p_aat_information7_o
446: => pqp_aat_shd.g_old_rec.aat_information7
447: ,p_aat_information8_o
448: => pqp_aat_shd.g_old_rec.aat_information8

Line 446: => pqp_aat_shd.g_old_rec.aat_information7

442: => pqp_aat_shd.g_old_rec.aat_information5
443: ,p_aat_information6_o
444: => pqp_aat_shd.g_old_rec.aat_information6
445: ,p_aat_information7_o
446: => pqp_aat_shd.g_old_rec.aat_information7
447: ,p_aat_information8_o
448: => pqp_aat_shd.g_old_rec.aat_information8
449: ,p_aat_information9_o
450: => pqp_aat_shd.g_old_rec.aat_information9

Line 448: => pqp_aat_shd.g_old_rec.aat_information8

444: => pqp_aat_shd.g_old_rec.aat_information6
445: ,p_aat_information7_o
446: => pqp_aat_shd.g_old_rec.aat_information7
447: ,p_aat_information8_o
448: => pqp_aat_shd.g_old_rec.aat_information8
449: ,p_aat_information9_o
450: => pqp_aat_shd.g_old_rec.aat_information9
451: ,p_aat_information10_o
452: => pqp_aat_shd.g_old_rec.aat_information10

Line 450: => pqp_aat_shd.g_old_rec.aat_information9

446: => pqp_aat_shd.g_old_rec.aat_information7
447: ,p_aat_information8_o
448: => pqp_aat_shd.g_old_rec.aat_information8
449: ,p_aat_information9_o
450: => pqp_aat_shd.g_old_rec.aat_information9
451: ,p_aat_information10_o
452: => pqp_aat_shd.g_old_rec.aat_information10
453: ,p_aat_information11_o
454: => pqp_aat_shd.g_old_rec.aat_information11

Line 452: => pqp_aat_shd.g_old_rec.aat_information10

448: => pqp_aat_shd.g_old_rec.aat_information8
449: ,p_aat_information9_o
450: => pqp_aat_shd.g_old_rec.aat_information9
451: ,p_aat_information10_o
452: => pqp_aat_shd.g_old_rec.aat_information10
453: ,p_aat_information11_o
454: => pqp_aat_shd.g_old_rec.aat_information11
455: ,p_aat_information12_o
456: => pqp_aat_shd.g_old_rec.aat_information12

Line 454: => pqp_aat_shd.g_old_rec.aat_information11

450: => pqp_aat_shd.g_old_rec.aat_information9
451: ,p_aat_information10_o
452: => pqp_aat_shd.g_old_rec.aat_information10
453: ,p_aat_information11_o
454: => pqp_aat_shd.g_old_rec.aat_information11
455: ,p_aat_information12_o
456: => pqp_aat_shd.g_old_rec.aat_information12
457: ,p_aat_information13_o
458: => pqp_aat_shd.g_old_rec.aat_information13

Line 456: => pqp_aat_shd.g_old_rec.aat_information12

452: => pqp_aat_shd.g_old_rec.aat_information10
453: ,p_aat_information11_o
454: => pqp_aat_shd.g_old_rec.aat_information11
455: ,p_aat_information12_o
456: => pqp_aat_shd.g_old_rec.aat_information12
457: ,p_aat_information13_o
458: => pqp_aat_shd.g_old_rec.aat_information13
459: ,p_aat_information14_o
460: => pqp_aat_shd.g_old_rec.aat_information14

Line 458: => pqp_aat_shd.g_old_rec.aat_information13

454: => pqp_aat_shd.g_old_rec.aat_information11
455: ,p_aat_information12_o
456: => pqp_aat_shd.g_old_rec.aat_information12
457: ,p_aat_information13_o
458: => pqp_aat_shd.g_old_rec.aat_information13
459: ,p_aat_information14_o
460: => pqp_aat_shd.g_old_rec.aat_information14
461: ,p_aat_information15_o
462: => pqp_aat_shd.g_old_rec.aat_information15

Line 460: => pqp_aat_shd.g_old_rec.aat_information14

456: => pqp_aat_shd.g_old_rec.aat_information12
457: ,p_aat_information13_o
458: => pqp_aat_shd.g_old_rec.aat_information13
459: ,p_aat_information14_o
460: => pqp_aat_shd.g_old_rec.aat_information14
461: ,p_aat_information15_o
462: => pqp_aat_shd.g_old_rec.aat_information15
463: ,p_aat_information16_o
464: => pqp_aat_shd.g_old_rec.aat_information16

Line 462: => pqp_aat_shd.g_old_rec.aat_information15

458: => pqp_aat_shd.g_old_rec.aat_information13
459: ,p_aat_information14_o
460: => pqp_aat_shd.g_old_rec.aat_information14
461: ,p_aat_information15_o
462: => pqp_aat_shd.g_old_rec.aat_information15
463: ,p_aat_information16_o
464: => pqp_aat_shd.g_old_rec.aat_information16
465: ,p_aat_information17_o
466: => pqp_aat_shd.g_old_rec.aat_information17

Line 464: => pqp_aat_shd.g_old_rec.aat_information16

460: => pqp_aat_shd.g_old_rec.aat_information14
461: ,p_aat_information15_o
462: => pqp_aat_shd.g_old_rec.aat_information15
463: ,p_aat_information16_o
464: => pqp_aat_shd.g_old_rec.aat_information16
465: ,p_aat_information17_o
466: => pqp_aat_shd.g_old_rec.aat_information17
467: ,p_aat_information18_o
468: => pqp_aat_shd.g_old_rec.aat_information18

Line 466: => pqp_aat_shd.g_old_rec.aat_information17

462: => pqp_aat_shd.g_old_rec.aat_information15
463: ,p_aat_information16_o
464: => pqp_aat_shd.g_old_rec.aat_information16
465: ,p_aat_information17_o
466: => pqp_aat_shd.g_old_rec.aat_information17
467: ,p_aat_information18_o
468: => pqp_aat_shd.g_old_rec.aat_information18
469: ,p_aat_information19_o
470: => pqp_aat_shd.g_old_rec.aat_information19

Line 468: => pqp_aat_shd.g_old_rec.aat_information18

464: => pqp_aat_shd.g_old_rec.aat_information16
465: ,p_aat_information17_o
466: => pqp_aat_shd.g_old_rec.aat_information17
467: ,p_aat_information18_o
468: => pqp_aat_shd.g_old_rec.aat_information18
469: ,p_aat_information19_o
470: => pqp_aat_shd.g_old_rec.aat_information19
471: ,p_aat_information20_o
472: => pqp_aat_shd.g_old_rec.aat_information20

Line 470: => pqp_aat_shd.g_old_rec.aat_information19

466: => pqp_aat_shd.g_old_rec.aat_information17
467: ,p_aat_information18_o
468: => pqp_aat_shd.g_old_rec.aat_information18
469: ,p_aat_information19_o
470: => pqp_aat_shd.g_old_rec.aat_information19
471: ,p_aat_information20_o
472: => pqp_aat_shd.g_old_rec.aat_information20
473: ,p_lgps_process_flag
474: => pqp_aat_shd.g_old_rec.lgps_process_flag

Line 472: => pqp_aat_shd.g_old_rec.aat_information20

468: => pqp_aat_shd.g_old_rec.aat_information18
469: ,p_aat_information19_o
470: => pqp_aat_shd.g_old_rec.aat_information19
471: ,p_aat_information20_o
472: => pqp_aat_shd.g_old_rec.aat_information20
473: ,p_lgps_process_flag
474: => pqp_aat_shd.g_old_rec.lgps_process_flag
475: ,p_lgps_exclusion_type
476: => pqp_aat_shd.g_old_rec.lgps_exclusion_type

Line 474: => pqp_aat_shd.g_old_rec.lgps_process_flag

470: => pqp_aat_shd.g_old_rec.aat_information19
471: ,p_aat_information20_o
472: => pqp_aat_shd.g_old_rec.aat_information20
473: ,p_lgps_process_flag
474: => pqp_aat_shd.g_old_rec.lgps_process_flag
475: ,p_lgps_exclusion_type
476: => pqp_aat_shd.g_old_rec.lgps_exclusion_type
477: ,p_lgps_pensionable_pay
478: => pqp_aat_shd.g_old_rec.lgps_pensionable_pay

Line 476: => pqp_aat_shd.g_old_rec.lgps_exclusion_type

472: => pqp_aat_shd.g_old_rec.aat_information20
473: ,p_lgps_process_flag
474: => pqp_aat_shd.g_old_rec.lgps_process_flag
475: ,p_lgps_exclusion_type
476: => pqp_aat_shd.g_old_rec.lgps_exclusion_type
477: ,p_lgps_pensionable_pay
478: => pqp_aat_shd.g_old_rec.lgps_pensionable_pay
479: ,p_lgps_trans_arrang_flag
480: => pqp_aat_shd.g_old_rec.lgps_trans_arrang_flag

Line 478: => pqp_aat_shd.g_old_rec.lgps_pensionable_pay

474: => pqp_aat_shd.g_old_rec.lgps_process_flag
475: ,p_lgps_exclusion_type
476: => pqp_aat_shd.g_old_rec.lgps_exclusion_type
477: ,p_lgps_pensionable_pay
478: => pqp_aat_shd.g_old_rec.lgps_pensionable_pay
479: ,p_lgps_trans_arrang_flag
480: => pqp_aat_shd.g_old_rec.lgps_trans_arrang_flag
481: ,p_lgps_membership_number
482: => pqp_aat_shd.g_old_rec.lgps_membership_number

Line 480: => pqp_aat_shd.g_old_rec.lgps_trans_arrang_flag

476: => pqp_aat_shd.g_old_rec.lgps_exclusion_type
477: ,p_lgps_pensionable_pay
478: => pqp_aat_shd.g_old_rec.lgps_pensionable_pay
479: ,p_lgps_trans_arrang_flag
480: => pqp_aat_shd.g_old_rec.lgps_trans_arrang_flag
481: ,p_lgps_membership_number
482: => pqp_aat_shd.g_old_rec.lgps_membership_number
483: );
484: --

Line 482: => pqp_aat_shd.g_old_rec.lgps_membership_number

478: => pqp_aat_shd.g_old_rec.lgps_pensionable_pay
479: ,p_lgps_trans_arrang_flag
480: => pqp_aat_shd.g_old_rec.lgps_trans_arrang_flag
481: ,p_lgps_membership_number
482: => pqp_aat_shd.g_old_rec.lgps_membership_number
483: );
484: --
485: exception
486: --

Line 504: ,p_rec in out nocopy pqp_aat_shd.g_rec_type

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

Line 520: pqp_aat_shd.lck

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

Line 583: l_rec pqp_aat_shd.g_rec_type;

579: ,p_effective_start_date out nocopy date
580: ,p_effective_end_date out nocopy date
581: ) is
582: --
583: l_rec pqp_aat_shd.g_rec_type;
584: l_proc varchar2(72) := g_package||'del';
585: --
586: Begin
587: hr_utility.set_location('Entering:'||l_proc, 5);