APPS.PQP_AAD_DEL dependencies on PQP_AAD_SHD

Line 51: Procedure delete_dml(p_rec in pqp_aad_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_aad_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

Line 58: pqp_aad_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_aad_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the pqp_analyzed_alien_data row.
61: --
62: delete from pqp_analyzed_alien_data

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

61: --
62: delete from pqp_analyzed_alien_data
63: where analyzed_data_id = p_rec.analyzed_data_id;
64: --
65: pqp_aad_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_aad_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_aad_shd.g_api_dml := false; -- Unset the api dml status
73: pqp_aad_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status

Line 73: pqp_aad_shd.constraint_error

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

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

72: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status
73: pqp_aad_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: pqp_aad_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_aad_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_aad_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_aad_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_aad_shd.g_rec_type) is
156: --
157: l_proc varchar2(72) := g_package||'post_delete';
158: --
159: Begin

Line 170: ,p_assignment_id_o =>pqp_aad_shd.g_old_rec.assignment_id

166: --
167: pqp_aad_rkd.after_delete
168: (
169: p_analyzed_data_id =>p_rec.analyzed_data_id
170: ,p_assignment_id_o =>pqp_aad_shd.g_old_rec.assignment_id
171: ,p_data_source_o =>pqp_aad_shd.g_old_rec.data_source
172: ,p_tax_year_o =>pqp_aad_shd.g_old_rec.tax_year
173: ,p_current_residency_status_o =>pqp_aad_shd.g_old_rec.current_residency_status
174: ,p_nra_to_ra_date_o =>pqp_aad_shd.g_old_rec.nra_to_ra_date

Line 171: ,p_data_source_o =>pqp_aad_shd.g_old_rec.data_source

167: pqp_aad_rkd.after_delete
168: (
169: p_analyzed_data_id =>p_rec.analyzed_data_id
170: ,p_assignment_id_o =>pqp_aad_shd.g_old_rec.assignment_id
171: ,p_data_source_o =>pqp_aad_shd.g_old_rec.data_source
172: ,p_tax_year_o =>pqp_aad_shd.g_old_rec.tax_year
173: ,p_current_residency_status_o =>pqp_aad_shd.g_old_rec.current_residency_status
174: ,p_nra_to_ra_date_o =>pqp_aad_shd.g_old_rec.nra_to_ra_date
175: ,p_target_departure_date_o =>pqp_aad_shd.g_old_rec.target_departure_date

Line 172: ,p_tax_year_o =>pqp_aad_shd.g_old_rec.tax_year

168: (
169: p_analyzed_data_id =>p_rec.analyzed_data_id
170: ,p_assignment_id_o =>pqp_aad_shd.g_old_rec.assignment_id
171: ,p_data_source_o =>pqp_aad_shd.g_old_rec.data_source
172: ,p_tax_year_o =>pqp_aad_shd.g_old_rec.tax_year
173: ,p_current_residency_status_o =>pqp_aad_shd.g_old_rec.current_residency_status
174: ,p_nra_to_ra_date_o =>pqp_aad_shd.g_old_rec.nra_to_ra_date
175: ,p_target_departure_date_o =>pqp_aad_shd.g_old_rec.target_departure_date
176: ,p_tax_residence_country_code_o =>pqp_aad_shd.g_old_rec.tax_residence_country_code

Line 173: ,p_current_residency_status_o =>pqp_aad_shd.g_old_rec.current_residency_status

169: p_analyzed_data_id =>p_rec.analyzed_data_id
170: ,p_assignment_id_o =>pqp_aad_shd.g_old_rec.assignment_id
171: ,p_data_source_o =>pqp_aad_shd.g_old_rec.data_source
172: ,p_tax_year_o =>pqp_aad_shd.g_old_rec.tax_year
173: ,p_current_residency_status_o =>pqp_aad_shd.g_old_rec.current_residency_status
174: ,p_nra_to_ra_date_o =>pqp_aad_shd.g_old_rec.nra_to_ra_date
175: ,p_target_departure_date_o =>pqp_aad_shd.g_old_rec.target_departure_date
176: ,p_tax_residence_country_code_o =>pqp_aad_shd.g_old_rec.tax_residence_country_code
177: ,p_treaty_info_update_date_o =>pqp_aad_shd.g_old_rec.treaty_info_update_date

Line 174: ,p_nra_to_ra_date_o =>pqp_aad_shd.g_old_rec.nra_to_ra_date

170: ,p_assignment_id_o =>pqp_aad_shd.g_old_rec.assignment_id
171: ,p_data_source_o =>pqp_aad_shd.g_old_rec.data_source
172: ,p_tax_year_o =>pqp_aad_shd.g_old_rec.tax_year
173: ,p_current_residency_status_o =>pqp_aad_shd.g_old_rec.current_residency_status
174: ,p_nra_to_ra_date_o =>pqp_aad_shd.g_old_rec.nra_to_ra_date
175: ,p_target_departure_date_o =>pqp_aad_shd.g_old_rec.target_departure_date
176: ,p_tax_residence_country_code_o =>pqp_aad_shd.g_old_rec.tax_residence_country_code
177: ,p_treaty_info_update_date_o =>pqp_aad_shd.g_old_rec.treaty_info_update_date
178: ,p_number_of_days_in_usa_o =>pqp_aad_shd.g_old_rec.number_of_days_in_usa

Line 175: ,p_target_departure_date_o =>pqp_aad_shd.g_old_rec.target_departure_date

171: ,p_data_source_o =>pqp_aad_shd.g_old_rec.data_source
172: ,p_tax_year_o =>pqp_aad_shd.g_old_rec.tax_year
173: ,p_current_residency_status_o =>pqp_aad_shd.g_old_rec.current_residency_status
174: ,p_nra_to_ra_date_o =>pqp_aad_shd.g_old_rec.nra_to_ra_date
175: ,p_target_departure_date_o =>pqp_aad_shd.g_old_rec.target_departure_date
176: ,p_tax_residence_country_code_o =>pqp_aad_shd.g_old_rec.tax_residence_country_code
177: ,p_treaty_info_update_date_o =>pqp_aad_shd.g_old_rec.treaty_info_update_date
178: ,p_number_of_days_in_usa_o =>pqp_aad_shd.g_old_rec.number_of_days_in_usa
179: ,p_withldg_allow_eligible_fla_o =>pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag

Line 176: ,p_tax_residence_country_code_o =>pqp_aad_shd.g_old_rec.tax_residence_country_code

172: ,p_tax_year_o =>pqp_aad_shd.g_old_rec.tax_year
173: ,p_current_residency_status_o =>pqp_aad_shd.g_old_rec.current_residency_status
174: ,p_nra_to_ra_date_o =>pqp_aad_shd.g_old_rec.nra_to_ra_date
175: ,p_target_departure_date_o =>pqp_aad_shd.g_old_rec.target_departure_date
176: ,p_tax_residence_country_code_o =>pqp_aad_shd.g_old_rec.tax_residence_country_code
177: ,p_treaty_info_update_date_o =>pqp_aad_shd.g_old_rec.treaty_info_update_date
178: ,p_number_of_days_in_usa_o =>pqp_aad_shd.g_old_rec.number_of_days_in_usa
179: ,p_withldg_allow_eligible_fla_o =>pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag
180: ,p_ra_effective_date_o =>pqp_aad_shd.g_old_rec.ra_effective_date

Line 177: ,p_treaty_info_update_date_o =>pqp_aad_shd.g_old_rec.treaty_info_update_date

173: ,p_current_residency_status_o =>pqp_aad_shd.g_old_rec.current_residency_status
174: ,p_nra_to_ra_date_o =>pqp_aad_shd.g_old_rec.nra_to_ra_date
175: ,p_target_departure_date_o =>pqp_aad_shd.g_old_rec.target_departure_date
176: ,p_tax_residence_country_code_o =>pqp_aad_shd.g_old_rec.tax_residence_country_code
177: ,p_treaty_info_update_date_o =>pqp_aad_shd.g_old_rec.treaty_info_update_date
178: ,p_number_of_days_in_usa_o =>pqp_aad_shd.g_old_rec.number_of_days_in_usa
179: ,p_withldg_allow_eligible_fla_o =>pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag
180: ,p_ra_effective_date_o =>pqp_aad_shd.g_old_rec.ra_effective_date
181: ,p_record_source_o =>pqp_aad_shd.g_old_rec.record_source

Line 178: ,p_number_of_days_in_usa_o =>pqp_aad_shd.g_old_rec.number_of_days_in_usa

174: ,p_nra_to_ra_date_o =>pqp_aad_shd.g_old_rec.nra_to_ra_date
175: ,p_target_departure_date_o =>pqp_aad_shd.g_old_rec.target_departure_date
176: ,p_tax_residence_country_code_o =>pqp_aad_shd.g_old_rec.tax_residence_country_code
177: ,p_treaty_info_update_date_o =>pqp_aad_shd.g_old_rec.treaty_info_update_date
178: ,p_number_of_days_in_usa_o =>pqp_aad_shd.g_old_rec.number_of_days_in_usa
179: ,p_withldg_allow_eligible_fla_o =>pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag
180: ,p_ra_effective_date_o =>pqp_aad_shd.g_old_rec.ra_effective_date
181: ,p_record_source_o =>pqp_aad_shd.g_old_rec.record_source
182: ,p_visa_type_o =>pqp_aad_shd.g_old_rec.visa_type

Line 179: ,p_withldg_allow_eligible_fla_o =>pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag

175: ,p_target_departure_date_o =>pqp_aad_shd.g_old_rec.target_departure_date
176: ,p_tax_residence_country_code_o =>pqp_aad_shd.g_old_rec.tax_residence_country_code
177: ,p_treaty_info_update_date_o =>pqp_aad_shd.g_old_rec.treaty_info_update_date
178: ,p_number_of_days_in_usa_o =>pqp_aad_shd.g_old_rec.number_of_days_in_usa
179: ,p_withldg_allow_eligible_fla_o =>pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag
180: ,p_ra_effective_date_o =>pqp_aad_shd.g_old_rec.ra_effective_date
181: ,p_record_source_o =>pqp_aad_shd.g_old_rec.record_source
182: ,p_visa_type_o =>pqp_aad_shd.g_old_rec.visa_type
183: ,p_j_sub_type_o =>pqp_aad_shd.g_old_rec.j_sub_type

Line 180: ,p_ra_effective_date_o =>pqp_aad_shd.g_old_rec.ra_effective_date

176: ,p_tax_residence_country_code_o =>pqp_aad_shd.g_old_rec.tax_residence_country_code
177: ,p_treaty_info_update_date_o =>pqp_aad_shd.g_old_rec.treaty_info_update_date
178: ,p_number_of_days_in_usa_o =>pqp_aad_shd.g_old_rec.number_of_days_in_usa
179: ,p_withldg_allow_eligible_fla_o =>pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag
180: ,p_ra_effective_date_o =>pqp_aad_shd.g_old_rec.ra_effective_date
181: ,p_record_source_o =>pqp_aad_shd.g_old_rec.record_source
182: ,p_visa_type_o =>pqp_aad_shd.g_old_rec.visa_type
183: ,p_j_sub_type_o =>pqp_aad_shd.g_old_rec.j_sub_type
184: ,p_primary_activity_o =>pqp_aad_shd.g_old_rec.primary_activity

Line 181: ,p_record_source_o =>pqp_aad_shd.g_old_rec.record_source

177: ,p_treaty_info_update_date_o =>pqp_aad_shd.g_old_rec.treaty_info_update_date
178: ,p_number_of_days_in_usa_o =>pqp_aad_shd.g_old_rec.number_of_days_in_usa
179: ,p_withldg_allow_eligible_fla_o =>pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag
180: ,p_ra_effective_date_o =>pqp_aad_shd.g_old_rec.ra_effective_date
181: ,p_record_source_o =>pqp_aad_shd.g_old_rec.record_source
182: ,p_visa_type_o =>pqp_aad_shd.g_old_rec.visa_type
183: ,p_j_sub_type_o =>pqp_aad_shd.g_old_rec.j_sub_type
184: ,p_primary_activity_o =>pqp_aad_shd.g_old_rec.primary_activity
185: ,p_non_us_country_code_o =>pqp_aad_shd.g_old_rec.non_us_country_code

Line 182: ,p_visa_type_o =>pqp_aad_shd.g_old_rec.visa_type

178: ,p_number_of_days_in_usa_o =>pqp_aad_shd.g_old_rec.number_of_days_in_usa
179: ,p_withldg_allow_eligible_fla_o =>pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag
180: ,p_ra_effective_date_o =>pqp_aad_shd.g_old_rec.ra_effective_date
181: ,p_record_source_o =>pqp_aad_shd.g_old_rec.record_source
182: ,p_visa_type_o =>pqp_aad_shd.g_old_rec.visa_type
183: ,p_j_sub_type_o =>pqp_aad_shd.g_old_rec.j_sub_type
184: ,p_primary_activity_o =>pqp_aad_shd.g_old_rec.primary_activity
185: ,p_non_us_country_code_o =>pqp_aad_shd.g_old_rec.non_us_country_code
186: ,p_citizenship_country_code_o =>pqp_aad_shd.g_old_rec.citizenship_country_code

Line 183: ,p_j_sub_type_o =>pqp_aad_shd.g_old_rec.j_sub_type

179: ,p_withldg_allow_eligible_fla_o =>pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag
180: ,p_ra_effective_date_o =>pqp_aad_shd.g_old_rec.ra_effective_date
181: ,p_record_source_o =>pqp_aad_shd.g_old_rec.record_source
182: ,p_visa_type_o =>pqp_aad_shd.g_old_rec.visa_type
183: ,p_j_sub_type_o =>pqp_aad_shd.g_old_rec.j_sub_type
184: ,p_primary_activity_o =>pqp_aad_shd.g_old_rec.primary_activity
185: ,p_non_us_country_code_o =>pqp_aad_shd.g_old_rec.non_us_country_code
186: ,p_citizenship_country_code_o =>pqp_aad_shd.g_old_rec.citizenship_country_code
187: ,p_object_version_number_o =>pqp_aad_shd.g_old_rec.object_version_number

Line 184: ,p_primary_activity_o =>pqp_aad_shd.g_old_rec.primary_activity

180: ,p_ra_effective_date_o =>pqp_aad_shd.g_old_rec.ra_effective_date
181: ,p_record_source_o =>pqp_aad_shd.g_old_rec.record_source
182: ,p_visa_type_o =>pqp_aad_shd.g_old_rec.visa_type
183: ,p_j_sub_type_o =>pqp_aad_shd.g_old_rec.j_sub_type
184: ,p_primary_activity_o =>pqp_aad_shd.g_old_rec.primary_activity
185: ,p_non_us_country_code_o =>pqp_aad_shd.g_old_rec.non_us_country_code
186: ,p_citizenship_country_code_o =>pqp_aad_shd.g_old_rec.citizenship_country_code
187: ,p_object_version_number_o =>pqp_aad_shd.g_old_rec.object_version_number
188: ,p_date_8233_signed_o =>pqp_aad_shd.g_old_rec.date_8233_signed

Line 185: ,p_non_us_country_code_o =>pqp_aad_shd.g_old_rec.non_us_country_code

181: ,p_record_source_o =>pqp_aad_shd.g_old_rec.record_source
182: ,p_visa_type_o =>pqp_aad_shd.g_old_rec.visa_type
183: ,p_j_sub_type_o =>pqp_aad_shd.g_old_rec.j_sub_type
184: ,p_primary_activity_o =>pqp_aad_shd.g_old_rec.primary_activity
185: ,p_non_us_country_code_o =>pqp_aad_shd.g_old_rec.non_us_country_code
186: ,p_citizenship_country_code_o =>pqp_aad_shd.g_old_rec.citizenship_country_code
187: ,p_object_version_number_o =>pqp_aad_shd.g_old_rec.object_version_number
188: ,p_date_8233_signed_o =>pqp_aad_shd.g_old_rec.date_8233_signed
189: ,p_date_w4_signed_o =>pqp_aad_shd.g_old_rec.date_w4_signed

Line 186: ,p_citizenship_country_code_o =>pqp_aad_shd.g_old_rec.citizenship_country_code

182: ,p_visa_type_o =>pqp_aad_shd.g_old_rec.visa_type
183: ,p_j_sub_type_o =>pqp_aad_shd.g_old_rec.j_sub_type
184: ,p_primary_activity_o =>pqp_aad_shd.g_old_rec.primary_activity
185: ,p_non_us_country_code_o =>pqp_aad_shd.g_old_rec.non_us_country_code
186: ,p_citizenship_country_code_o =>pqp_aad_shd.g_old_rec.citizenship_country_code
187: ,p_object_version_number_o =>pqp_aad_shd.g_old_rec.object_version_number
188: ,p_date_8233_signed_o =>pqp_aad_shd.g_old_rec.date_8233_signed
189: ,p_date_w4_signed_o =>pqp_aad_shd.g_old_rec.date_w4_signed
190: );

Line 187: ,p_object_version_number_o =>pqp_aad_shd.g_old_rec.object_version_number

183: ,p_j_sub_type_o =>pqp_aad_shd.g_old_rec.j_sub_type
184: ,p_primary_activity_o =>pqp_aad_shd.g_old_rec.primary_activity
185: ,p_non_us_country_code_o =>pqp_aad_shd.g_old_rec.non_us_country_code
186: ,p_citizenship_country_code_o =>pqp_aad_shd.g_old_rec.citizenship_country_code
187: ,p_object_version_number_o =>pqp_aad_shd.g_old_rec.object_version_number
188: ,p_date_8233_signed_o =>pqp_aad_shd.g_old_rec.date_8233_signed
189: ,p_date_w4_signed_o =>pqp_aad_shd.g_old_rec.date_w4_signed
190: );
191: --

Line 188: ,p_date_8233_signed_o =>pqp_aad_shd.g_old_rec.date_8233_signed

184: ,p_primary_activity_o =>pqp_aad_shd.g_old_rec.primary_activity
185: ,p_non_us_country_code_o =>pqp_aad_shd.g_old_rec.non_us_country_code
186: ,p_citizenship_country_code_o =>pqp_aad_shd.g_old_rec.citizenship_country_code
187: ,p_object_version_number_o =>pqp_aad_shd.g_old_rec.object_version_number
188: ,p_date_8233_signed_o =>pqp_aad_shd.g_old_rec.date_8233_signed
189: ,p_date_w4_signed_o =>pqp_aad_shd.g_old_rec.date_w4_signed
190: );
191: --
192: exception

Line 189: ,p_date_w4_signed_o =>pqp_aad_shd.g_old_rec.date_w4_signed

185: ,p_non_us_country_code_o =>pqp_aad_shd.g_old_rec.non_us_country_code
186: ,p_citizenship_country_code_o =>pqp_aad_shd.g_old_rec.citizenship_country_code
187: ,p_object_version_number_o =>pqp_aad_shd.g_old_rec.object_version_number
188: ,p_date_8233_signed_o =>pqp_aad_shd.g_old_rec.date_8233_signed
189: ,p_date_w4_signed_o =>pqp_aad_shd.g_old_rec.date_w4_signed
190: );
191: --
192: exception
193: --

Line 214: p_rec in pqp_aad_shd.g_rec_type

210: -- ----------------------------------------------------------------------------
211: Procedure del
212: (
213: p_effective_date in date,
214: p_rec in pqp_aad_shd.g_rec_type
215: ) is
216: --
217: l_proc varchar2(72) := g_package||'del';
218: --

Line 224: pqp_aad_shd.lck

220: hr_utility.set_location('Entering:'||l_proc, 5);
221: --
222: -- We must lock the row which we need to delete.
223: --
224: pqp_aad_shd.lck
225: (
226: p_rec.analyzed_data_id,
227: p_rec.object_version_number
228: );

Line 259: l_rec pqp_aad_shd.g_rec_type;

255: p_analyzed_data_id in number,
256: p_object_version_number in number
257: ) is
258: --
259: l_rec pqp_aad_shd.g_rec_type;
260: l_proc varchar2(72) := g_package||'del';
261: --
262: Begin
263: hr_utility.set_location('Entering:'||l_proc, 5);