APPS.PQP_DET_DEL dependencies on PQP_DET_SHD

Line 51: Procedure delete_dml(p_rec in pqp_det_shd.g_rec_type) is

47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in pqp_det_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

Line 58: pqp_det_shd.g_api_dml := true; -- Set the api dml status

54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: pqp_det_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the pqp_analyzed_alien_details row.
61: --
62: delete from pqp_analyzed_alien_details

Line 65: pqp_det_shd.g_api_dml := false; -- Unset the api dml status

61: --
62: delete from pqp_analyzed_alien_details
63: where analyzed_data_details_id = p_rec.analyzed_data_details_id;
64: --
65: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: Exception

Line 72: pqp_det_shd.g_api_dml := false; -- Unset the api dml status

68: --
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
73: pqp_det_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: pqp_det_shd.g_api_dml := false; -- Unset the api dml status

Line 73: pqp_det_shd.constraint_error

69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
73: pqp_det_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;

Line 76: pqp_det_shd.g_api_dml := false; -- Unset the api dml status

72: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
73: pqp_det_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
79: --
80: -- ----------------------------------------------------------------------------

Line 112: Procedure pre_delete(p_rec in pqp_det_shd.g_rec_type) is

108: -- Internal Row Handler Use Only.
109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: Procedure pre_delete(p_rec in pqp_det_shd.g_rec_type) is
113: --
114: l_proc varchar2(72) := g_package||'pre_delete';
115: --
116: Begin

Line 155: p_effective_date in date,p_rec in pqp_det_shd.g_rec_type) is

151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure post_delete(
155: p_effective_date in date,p_rec in pqp_det_shd.g_rec_type) is
156: --
157: l_proc varchar2(72) := g_package||'post_delete';
158: --
159: Begin

Line 170: ,p_analyzed_data_id_o =>pqp_det_shd.g_old_rec.analyzed_data_id

166: --
167: pqp_det_rkd.after_delete
168: (
169: p_analyzed_data_details_id =>p_rec.analyzed_data_details_id
170: ,p_analyzed_data_id_o =>pqp_det_shd.g_old_rec.analyzed_data_id
171: ,p_income_code_o =>pqp_det_shd.g_old_rec.income_code
172: ,p_withholding_rate_o =>pqp_det_shd.g_old_rec.withholding_rate
173: ,p_income_code_sub_type_o =>pqp_det_shd.g_old_rec.income_code_sub_type
174: ,p_exemption_code_o =>pqp_det_shd.g_old_rec.exemption_code

Line 171: ,p_income_code_o =>pqp_det_shd.g_old_rec.income_code

167: pqp_det_rkd.after_delete
168: (
169: p_analyzed_data_details_id =>p_rec.analyzed_data_details_id
170: ,p_analyzed_data_id_o =>pqp_det_shd.g_old_rec.analyzed_data_id
171: ,p_income_code_o =>pqp_det_shd.g_old_rec.income_code
172: ,p_withholding_rate_o =>pqp_det_shd.g_old_rec.withholding_rate
173: ,p_income_code_sub_type_o =>pqp_det_shd.g_old_rec.income_code_sub_type
174: ,p_exemption_code_o =>pqp_det_shd.g_old_rec.exemption_code
175: ,p_maximum_benefit_amount_o =>pqp_det_shd.g_old_rec.maximum_benefit_amount

Line 172: ,p_withholding_rate_o =>pqp_det_shd.g_old_rec.withholding_rate

168: (
169: p_analyzed_data_details_id =>p_rec.analyzed_data_details_id
170: ,p_analyzed_data_id_o =>pqp_det_shd.g_old_rec.analyzed_data_id
171: ,p_income_code_o =>pqp_det_shd.g_old_rec.income_code
172: ,p_withholding_rate_o =>pqp_det_shd.g_old_rec.withholding_rate
173: ,p_income_code_sub_type_o =>pqp_det_shd.g_old_rec.income_code_sub_type
174: ,p_exemption_code_o =>pqp_det_shd.g_old_rec.exemption_code
175: ,p_maximum_benefit_amount_o =>pqp_det_shd.g_old_rec.maximum_benefit_amount
176: ,p_retro_lose_ben_amt_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag

Line 173: ,p_income_code_sub_type_o =>pqp_det_shd.g_old_rec.income_code_sub_type

169: p_analyzed_data_details_id =>p_rec.analyzed_data_details_id
170: ,p_analyzed_data_id_o =>pqp_det_shd.g_old_rec.analyzed_data_id
171: ,p_income_code_o =>pqp_det_shd.g_old_rec.income_code
172: ,p_withholding_rate_o =>pqp_det_shd.g_old_rec.withholding_rate
173: ,p_income_code_sub_type_o =>pqp_det_shd.g_old_rec.income_code_sub_type
174: ,p_exemption_code_o =>pqp_det_shd.g_old_rec.exemption_code
175: ,p_maximum_benefit_amount_o =>pqp_det_shd.g_old_rec.maximum_benefit_amount
176: ,p_retro_lose_ben_amt_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag
177: ,p_date_benefit_ends_o =>pqp_det_shd.g_old_rec.date_benefit_ends

Line 174: ,p_exemption_code_o =>pqp_det_shd.g_old_rec.exemption_code

170: ,p_analyzed_data_id_o =>pqp_det_shd.g_old_rec.analyzed_data_id
171: ,p_income_code_o =>pqp_det_shd.g_old_rec.income_code
172: ,p_withholding_rate_o =>pqp_det_shd.g_old_rec.withholding_rate
173: ,p_income_code_sub_type_o =>pqp_det_shd.g_old_rec.income_code_sub_type
174: ,p_exemption_code_o =>pqp_det_shd.g_old_rec.exemption_code
175: ,p_maximum_benefit_amount_o =>pqp_det_shd.g_old_rec.maximum_benefit_amount
176: ,p_retro_lose_ben_amt_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag
177: ,p_date_benefit_ends_o =>pqp_det_shd.g_old_rec.date_benefit_ends
178: ,p_retro_lose_ben_date_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_date_flag

Line 175: ,p_maximum_benefit_amount_o =>pqp_det_shd.g_old_rec.maximum_benefit_amount

171: ,p_income_code_o =>pqp_det_shd.g_old_rec.income_code
172: ,p_withholding_rate_o =>pqp_det_shd.g_old_rec.withholding_rate
173: ,p_income_code_sub_type_o =>pqp_det_shd.g_old_rec.income_code_sub_type
174: ,p_exemption_code_o =>pqp_det_shd.g_old_rec.exemption_code
175: ,p_maximum_benefit_amount_o =>pqp_det_shd.g_old_rec.maximum_benefit_amount
176: ,p_retro_lose_ben_amt_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag
177: ,p_date_benefit_ends_o =>pqp_det_shd.g_old_rec.date_benefit_ends
178: ,p_retro_lose_ben_date_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_date_flag
179: ,p_nra_exempt_from_ss_o =>pqp_det_shd.g_old_rec.nra_exempt_from_ss

Line 176: ,p_retro_lose_ben_amt_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag

172: ,p_withholding_rate_o =>pqp_det_shd.g_old_rec.withholding_rate
173: ,p_income_code_sub_type_o =>pqp_det_shd.g_old_rec.income_code_sub_type
174: ,p_exemption_code_o =>pqp_det_shd.g_old_rec.exemption_code
175: ,p_maximum_benefit_amount_o =>pqp_det_shd.g_old_rec.maximum_benefit_amount
176: ,p_retro_lose_ben_amt_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag
177: ,p_date_benefit_ends_o =>pqp_det_shd.g_old_rec.date_benefit_ends
178: ,p_retro_lose_ben_date_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_date_flag
179: ,p_nra_exempt_from_ss_o =>pqp_det_shd.g_old_rec.nra_exempt_from_ss
180: ,p_nra_exempt_from_medicare_o =>pqp_det_shd.g_old_rec.nra_exempt_from_medicare

Line 177: ,p_date_benefit_ends_o =>pqp_det_shd.g_old_rec.date_benefit_ends

173: ,p_income_code_sub_type_o =>pqp_det_shd.g_old_rec.income_code_sub_type
174: ,p_exemption_code_o =>pqp_det_shd.g_old_rec.exemption_code
175: ,p_maximum_benefit_amount_o =>pqp_det_shd.g_old_rec.maximum_benefit_amount
176: ,p_retro_lose_ben_amt_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag
177: ,p_date_benefit_ends_o =>pqp_det_shd.g_old_rec.date_benefit_ends
178: ,p_retro_lose_ben_date_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_date_flag
179: ,p_nra_exempt_from_ss_o =>pqp_det_shd.g_old_rec.nra_exempt_from_ss
180: ,p_nra_exempt_from_medicare_o =>pqp_det_shd.g_old_rec.nra_exempt_from_medicare
181: ,p_student_exempt_from_ss_o =>pqp_det_shd.g_old_rec.student_exempt_from_ss

Line 178: ,p_retro_lose_ben_date_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_date_flag

174: ,p_exemption_code_o =>pqp_det_shd.g_old_rec.exemption_code
175: ,p_maximum_benefit_amount_o =>pqp_det_shd.g_old_rec.maximum_benefit_amount
176: ,p_retro_lose_ben_amt_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag
177: ,p_date_benefit_ends_o =>pqp_det_shd.g_old_rec.date_benefit_ends
178: ,p_retro_lose_ben_date_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_date_flag
179: ,p_nra_exempt_from_ss_o =>pqp_det_shd.g_old_rec.nra_exempt_from_ss
180: ,p_nra_exempt_from_medicare_o =>pqp_det_shd.g_old_rec.nra_exempt_from_medicare
181: ,p_student_exempt_from_ss_o =>pqp_det_shd.g_old_rec.student_exempt_from_ss
182: ,p_student_exempt_from_medi_o =>pqp_det_shd.g_old_rec.student_exempt_from_medicare

Line 179: ,p_nra_exempt_from_ss_o =>pqp_det_shd.g_old_rec.nra_exempt_from_ss

175: ,p_maximum_benefit_amount_o =>pqp_det_shd.g_old_rec.maximum_benefit_amount
176: ,p_retro_lose_ben_amt_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag
177: ,p_date_benefit_ends_o =>pqp_det_shd.g_old_rec.date_benefit_ends
178: ,p_retro_lose_ben_date_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_date_flag
179: ,p_nra_exempt_from_ss_o =>pqp_det_shd.g_old_rec.nra_exempt_from_ss
180: ,p_nra_exempt_from_medicare_o =>pqp_det_shd.g_old_rec.nra_exempt_from_medicare
181: ,p_student_exempt_from_ss_o =>pqp_det_shd.g_old_rec.student_exempt_from_ss
182: ,p_student_exempt_from_medi_o =>pqp_det_shd.g_old_rec.student_exempt_from_medicare
183: ,p_addl_withholding_flag_o =>pqp_det_shd.g_old_rec.addl_withholding_flag

Line 180: ,p_nra_exempt_from_medicare_o =>pqp_det_shd.g_old_rec.nra_exempt_from_medicare

176: ,p_retro_lose_ben_amt_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag
177: ,p_date_benefit_ends_o =>pqp_det_shd.g_old_rec.date_benefit_ends
178: ,p_retro_lose_ben_date_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_date_flag
179: ,p_nra_exempt_from_ss_o =>pqp_det_shd.g_old_rec.nra_exempt_from_ss
180: ,p_nra_exempt_from_medicare_o =>pqp_det_shd.g_old_rec.nra_exempt_from_medicare
181: ,p_student_exempt_from_ss_o =>pqp_det_shd.g_old_rec.student_exempt_from_ss
182: ,p_student_exempt_from_medi_o =>pqp_det_shd.g_old_rec.student_exempt_from_medicare
183: ,p_addl_withholding_flag_o =>pqp_det_shd.g_old_rec.addl_withholding_flag
184: ,p_constant_addl_tax_o =>pqp_det_shd.g_old_rec.constant_addl_tax

Line 181: ,p_student_exempt_from_ss_o =>pqp_det_shd.g_old_rec.student_exempt_from_ss

177: ,p_date_benefit_ends_o =>pqp_det_shd.g_old_rec.date_benefit_ends
178: ,p_retro_lose_ben_date_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_date_flag
179: ,p_nra_exempt_from_ss_o =>pqp_det_shd.g_old_rec.nra_exempt_from_ss
180: ,p_nra_exempt_from_medicare_o =>pqp_det_shd.g_old_rec.nra_exempt_from_medicare
181: ,p_student_exempt_from_ss_o =>pqp_det_shd.g_old_rec.student_exempt_from_ss
182: ,p_student_exempt_from_medi_o =>pqp_det_shd.g_old_rec.student_exempt_from_medicare
183: ,p_addl_withholding_flag_o =>pqp_det_shd.g_old_rec.addl_withholding_flag
184: ,p_constant_addl_tax_o =>pqp_det_shd.g_old_rec.constant_addl_tax
185: ,p_addl_withholding_amt_o =>pqp_det_shd.g_old_rec.addl_withholding_amt

Line 182: ,p_student_exempt_from_medi_o =>pqp_det_shd.g_old_rec.student_exempt_from_medicare

178: ,p_retro_lose_ben_date_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_date_flag
179: ,p_nra_exempt_from_ss_o =>pqp_det_shd.g_old_rec.nra_exempt_from_ss
180: ,p_nra_exempt_from_medicare_o =>pqp_det_shd.g_old_rec.nra_exempt_from_medicare
181: ,p_student_exempt_from_ss_o =>pqp_det_shd.g_old_rec.student_exempt_from_ss
182: ,p_student_exempt_from_medi_o =>pqp_det_shd.g_old_rec.student_exempt_from_medicare
183: ,p_addl_withholding_flag_o =>pqp_det_shd.g_old_rec.addl_withholding_flag
184: ,p_constant_addl_tax_o =>pqp_det_shd.g_old_rec.constant_addl_tax
185: ,p_addl_withholding_amt_o =>pqp_det_shd.g_old_rec.addl_withholding_amt
186: ,p_addl_wthldng_amt_period_ty_o =>pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type

Line 183: ,p_addl_withholding_flag_o =>pqp_det_shd.g_old_rec.addl_withholding_flag

179: ,p_nra_exempt_from_ss_o =>pqp_det_shd.g_old_rec.nra_exempt_from_ss
180: ,p_nra_exempt_from_medicare_o =>pqp_det_shd.g_old_rec.nra_exempt_from_medicare
181: ,p_student_exempt_from_ss_o =>pqp_det_shd.g_old_rec.student_exempt_from_ss
182: ,p_student_exempt_from_medi_o =>pqp_det_shd.g_old_rec.student_exempt_from_medicare
183: ,p_addl_withholding_flag_o =>pqp_det_shd.g_old_rec.addl_withholding_flag
184: ,p_constant_addl_tax_o =>pqp_det_shd.g_old_rec.constant_addl_tax
185: ,p_addl_withholding_amt_o =>pqp_det_shd.g_old_rec.addl_withholding_amt
186: ,p_addl_wthldng_amt_period_ty_o =>pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type
187: ,p_personal_exemption_o =>pqp_det_shd.g_old_rec.personal_exemption

Line 184: ,p_constant_addl_tax_o =>pqp_det_shd.g_old_rec.constant_addl_tax

180: ,p_nra_exempt_from_medicare_o =>pqp_det_shd.g_old_rec.nra_exempt_from_medicare
181: ,p_student_exempt_from_ss_o =>pqp_det_shd.g_old_rec.student_exempt_from_ss
182: ,p_student_exempt_from_medi_o =>pqp_det_shd.g_old_rec.student_exempt_from_medicare
183: ,p_addl_withholding_flag_o =>pqp_det_shd.g_old_rec.addl_withholding_flag
184: ,p_constant_addl_tax_o =>pqp_det_shd.g_old_rec.constant_addl_tax
185: ,p_addl_withholding_amt_o =>pqp_det_shd.g_old_rec.addl_withholding_amt
186: ,p_addl_wthldng_amt_period_ty_o =>pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type
187: ,p_personal_exemption_o =>pqp_det_shd.g_old_rec.personal_exemption
188: ,p_addl_exemption_allowed_o =>pqp_det_shd.g_old_rec.addl_exemption_allowed

Line 185: ,p_addl_withholding_amt_o =>pqp_det_shd.g_old_rec.addl_withholding_amt

181: ,p_student_exempt_from_ss_o =>pqp_det_shd.g_old_rec.student_exempt_from_ss
182: ,p_student_exempt_from_medi_o =>pqp_det_shd.g_old_rec.student_exempt_from_medicare
183: ,p_addl_withholding_flag_o =>pqp_det_shd.g_old_rec.addl_withholding_flag
184: ,p_constant_addl_tax_o =>pqp_det_shd.g_old_rec.constant_addl_tax
185: ,p_addl_withholding_amt_o =>pqp_det_shd.g_old_rec.addl_withholding_amt
186: ,p_addl_wthldng_amt_period_ty_o =>pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type
187: ,p_personal_exemption_o =>pqp_det_shd.g_old_rec.personal_exemption
188: ,p_addl_exemption_allowed_o =>pqp_det_shd.g_old_rec.addl_exemption_allowed
189: ,p_treaty_ben_allowed_flag_o =>pqp_det_shd.g_old_rec.treaty_ben_allowed_flag

Line 186: ,p_addl_wthldng_amt_period_ty_o =>pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type

182: ,p_student_exempt_from_medi_o =>pqp_det_shd.g_old_rec.student_exempt_from_medicare
183: ,p_addl_withholding_flag_o =>pqp_det_shd.g_old_rec.addl_withholding_flag
184: ,p_constant_addl_tax_o =>pqp_det_shd.g_old_rec.constant_addl_tax
185: ,p_addl_withholding_amt_o =>pqp_det_shd.g_old_rec.addl_withholding_amt
186: ,p_addl_wthldng_amt_period_ty_o =>pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type
187: ,p_personal_exemption_o =>pqp_det_shd.g_old_rec.personal_exemption
188: ,p_addl_exemption_allowed_o =>pqp_det_shd.g_old_rec.addl_exemption_allowed
189: ,p_treaty_ben_allowed_flag_o =>pqp_det_shd.g_old_rec.treaty_ben_allowed_flag
190: ,p_treaty_benefits_start_date_o =>pqp_det_shd.g_old_rec.treaty_benefits_start_date

Line 187: ,p_personal_exemption_o =>pqp_det_shd.g_old_rec.personal_exemption

183: ,p_addl_withholding_flag_o =>pqp_det_shd.g_old_rec.addl_withholding_flag
184: ,p_constant_addl_tax_o =>pqp_det_shd.g_old_rec.constant_addl_tax
185: ,p_addl_withholding_amt_o =>pqp_det_shd.g_old_rec.addl_withholding_amt
186: ,p_addl_wthldng_amt_period_ty_o =>pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type
187: ,p_personal_exemption_o =>pqp_det_shd.g_old_rec.personal_exemption
188: ,p_addl_exemption_allowed_o =>pqp_det_shd.g_old_rec.addl_exemption_allowed
189: ,p_treaty_ben_allowed_flag_o =>pqp_det_shd.g_old_rec.treaty_ben_allowed_flag
190: ,p_treaty_benefits_start_date_o =>pqp_det_shd.g_old_rec.treaty_benefits_start_date
191: ,p_object_version_number_o =>pqp_det_shd.g_old_rec.object_version_number

Line 188: ,p_addl_exemption_allowed_o =>pqp_det_shd.g_old_rec.addl_exemption_allowed

184: ,p_constant_addl_tax_o =>pqp_det_shd.g_old_rec.constant_addl_tax
185: ,p_addl_withholding_amt_o =>pqp_det_shd.g_old_rec.addl_withholding_amt
186: ,p_addl_wthldng_amt_period_ty_o =>pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type
187: ,p_personal_exemption_o =>pqp_det_shd.g_old_rec.personal_exemption
188: ,p_addl_exemption_allowed_o =>pqp_det_shd.g_old_rec.addl_exemption_allowed
189: ,p_treaty_ben_allowed_flag_o =>pqp_det_shd.g_old_rec.treaty_ben_allowed_flag
190: ,p_treaty_benefits_start_date_o =>pqp_det_shd.g_old_rec.treaty_benefits_start_date
191: ,p_object_version_number_o =>pqp_det_shd.g_old_rec.object_version_number
192: ,p_retro_loss_notif_sent_o =>pqp_det_shd.g_old_rec.retro_loss_notification_sent

Line 189: ,p_treaty_ben_allowed_flag_o =>pqp_det_shd.g_old_rec.treaty_ben_allowed_flag

185: ,p_addl_withholding_amt_o =>pqp_det_shd.g_old_rec.addl_withholding_amt
186: ,p_addl_wthldng_amt_period_ty_o =>pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type
187: ,p_personal_exemption_o =>pqp_det_shd.g_old_rec.personal_exemption
188: ,p_addl_exemption_allowed_o =>pqp_det_shd.g_old_rec.addl_exemption_allowed
189: ,p_treaty_ben_allowed_flag_o =>pqp_det_shd.g_old_rec.treaty_ben_allowed_flag
190: ,p_treaty_benefits_start_date_o =>pqp_det_shd.g_old_rec.treaty_benefits_start_date
191: ,p_object_version_number_o =>pqp_det_shd.g_old_rec.object_version_number
192: ,p_retro_loss_notif_sent_o =>pqp_det_shd.g_old_rec.retro_loss_notification_sent
193: ,p_current_analysis_o =>pqp_det_shd.g_old_rec.current_analysis

Line 190: ,p_treaty_benefits_start_date_o =>pqp_det_shd.g_old_rec.treaty_benefits_start_date

186: ,p_addl_wthldng_amt_period_ty_o =>pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type
187: ,p_personal_exemption_o =>pqp_det_shd.g_old_rec.personal_exemption
188: ,p_addl_exemption_allowed_o =>pqp_det_shd.g_old_rec.addl_exemption_allowed
189: ,p_treaty_ben_allowed_flag_o =>pqp_det_shd.g_old_rec.treaty_ben_allowed_flag
190: ,p_treaty_benefits_start_date_o =>pqp_det_shd.g_old_rec.treaty_benefits_start_date
191: ,p_object_version_number_o =>pqp_det_shd.g_old_rec.object_version_number
192: ,p_retro_loss_notif_sent_o =>pqp_det_shd.g_old_rec.retro_loss_notification_sent
193: ,p_current_analysis_o =>pqp_det_shd.g_old_rec.current_analysis
194: ,p_forecast_income_code_o =>pqp_det_shd.g_old_rec.forecast_income_code

Line 191: ,p_object_version_number_o =>pqp_det_shd.g_old_rec.object_version_number

187: ,p_personal_exemption_o =>pqp_det_shd.g_old_rec.personal_exemption
188: ,p_addl_exemption_allowed_o =>pqp_det_shd.g_old_rec.addl_exemption_allowed
189: ,p_treaty_ben_allowed_flag_o =>pqp_det_shd.g_old_rec.treaty_ben_allowed_flag
190: ,p_treaty_benefits_start_date_o =>pqp_det_shd.g_old_rec.treaty_benefits_start_date
191: ,p_object_version_number_o =>pqp_det_shd.g_old_rec.object_version_number
192: ,p_retro_loss_notif_sent_o =>pqp_det_shd.g_old_rec.retro_loss_notification_sent
193: ,p_current_analysis_o =>pqp_det_shd.g_old_rec.current_analysis
194: ,p_forecast_income_code_o =>pqp_det_shd.g_old_rec.forecast_income_code
195: );

Line 192: ,p_retro_loss_notif_sent_o =>pqp_det_shd.g_old_rec.retro_loss_notification_sent

188: ,p_addl_exemption_allowed_o =>pqp_det_shd.g_old_rec.addl_exemption_allowed
189: ,p_treaty_ben_allowed_flag_o =>pqp_det_shd.g_old_rec.treaty_ben_allowed_flag
190: ,p_treaty_benefits_start_date_o =>pqp_det_shd.g_old_rec.treaty_benefits_start_date
191: ,p_object_version_number_o =>pqp_det_shd.g_old_rec.object_version_number
192: ,p_retro_loss_notif_sent_o =>pqp_det_shd.g_old_rec.retro_loss_notification_sent
193: ,p_current_analysis_o =>pqp_det_shd.g_old_rec.current_analysis
194: ,p_forecast_income_code_o =>pqp_det_shd.g_old_rec.forecast_income_code
195: );
196: --

Line 193: ,p_current_analysis_o =>pqp_det_shd.g_old_rec.current_analysis

189: ,p_treaty_ben_allowed_flag_o =>pqp_det_shd.g_old_rec.treaty_ben_allowed_flag
190: ,p_treaty_benefits_start_date_o =>pqp_det_shd.g_old_rec.treaty_benefits_start_date
191: ,p_object_version_number_o =>pqp_det_shd.g_old_rec.object_version_number
192: ,p_retro_loss_notif_sent_o =>pqp_det_shd.g_old_rec.retro_loss_notification_sent
193: ,p_current_analysis_o =>pqp_det_shd.g_old_rec.current_analysis
194: ,p_forecast_income_code_o =>pqp_det_shd.g_old_rec.forecast_income_code
195: );
196: --
197: exception

Line 194: ,p_forecast_income_code_o =>pqp_det_shd.g_old_rec.forecast_income_code

190: ,p_treaty_benefits_start_date_o =>pqp_det_shd.g_old_rec.treaty_benefits_start_date
191: ,p_object_version_number_o =>pqp_det_shd.g_old_rec.object_version_number
192: ,p_retro_loss_notif_sent_o =>pqp_det_shd.g_old_rec.retro_loss_notification_sent
193: ,p_current_analysis_o =>pqp_det_shd.g_old_rec.current_analysis
194: ,p_forecast_income_code_o =>pqp_det_shd.g_old_rec.forecast_income_code
195: );
196: --
197: exception
198: --

Line 219: p_rec in pqp_det_shd.g_rec_type

215: -- ----------------------------------------------------------------------------
216: Procedure del
217: (
218: p_effective_date in date,
219: p_rec in pqp_det_shd.g_rec_type
220: ) is
221: --
222: l_proc varchar2(72) := g_package||'del';
223: --

Line 229: pqp_det_shd.lck

225: hr_utility.set_location('Entering:'||l_proc, 5);
226: --
227: -- We must lock the row which we need to delete.
228: --
229: pqp_det_shd.lck
230: (
231: p_rec.analyzed_data_details_id,
232: p_rec.object_version_number
233: );

Line 264: l_rec pqp_det_shd.g_rec_type;

260: p_analyzed_data_details_id in number,
261: p_object_version_number in number
262: ) is
263: --
264: l_rec pqp_det_shd.g_rec_type;
265: l_proc varchar2(72) := g_package||'del';
266: --
267: Begin
268: hr_utility.set_location('Entering:'||l_proc, 5);