APPS.PQP_AAD_UPD dependencies on PQP_AAD_SHD

Line 54: Procedure update_dml(p_rec in out nocopy pqp_aad_shd.g_rec_type) is

50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy pqp_aad_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: pqp_aad_shd.g_api_dml := true; -- Set the api dml status

61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: pqp_aad_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the pqp_analyzed_alien_data Row
68: --
69: update pqp_analyzed_alien_data

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

90: date_8233_signed = p_rec.date_8233_signed,
91: date_w4_signed = p_rec.date_w4_signed
92: where analyzed_data_id = p_rec.analyzed_data_id;
93: --
94: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status
95: --
96: hr_utility.set_location(' Leaving:'||l_proc, 10);
97: --
98: Exception

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

97: --
98: Exception
99: When hr_api.check_integrity_violated Then
100: -- A check constraint has been violated
101: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status
102: pqp_aad_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.parent_integrity_violated Then
105: -- Parent integrity has been violated

Line 102: pqp_aad_shd.constraint_error

98: Exception
99: When hr_api.check_integrity_violated Then
100: -- A check constraint has been violated
101: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status
102: pqp_aad_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.parent_integrity_violated Then
105: -- Parent integrity has been violated
106: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status

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

102: pqp_aad_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.parent_integrity_violated Then
105: -- Parent integrity has been violated
106: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status
107: pqp_aad_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.unique_integrity_violated Then
110: -- Unique integrity has been violated

Line 107: pqp_aad_shd.constraint_error

103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.parent_integrity_violated Then
105: -- Parent integrity has been violated
106: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status
107: pqp_aad_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.unique_integrity_violated Then
110: -- Unique integrity has been violated
111: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status

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

107: pqp_aad_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.unique_integrity_violated Then
110: -- Unique integrity has been violated
111: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status
112: pqp_aad_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When Others Then
115: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status

Line 112: pqp_aad_shd.constraint_error

108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.unique_integrity_violated Then
110: -- Unique integrity has been violated
111: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status
112: pqp_aad_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When Others Then
115: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status
116: Raise;

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

111: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status
112: pqp_aad_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When Others Then
115: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status
116: Raise;
117: End update_dml;
118: --
119: -- ----------------------------------------------------------------------------

Line 151: Procedure pre_update(p_rec in pqp_aad_shd.g_rec_type) is

147: -- Internal Row Handler Use Only.
148: --
149: -- {End Of Comments}
150: -- ----------------------------------------------------------------------------
151: Procedure pre_update(p_rec in pqp_aad_shd.g_rec_type) is
152: --
153: l_proc varchar2(72) := g_package||'pre_update';
154: --
155: Begin

Line 194: p_effective_date in date,p_rec in pqp_aad_shd.g_rec_type) is

190: --
191: -- {End Of Comments}
192: -- ----------------------------------------------------------------------------
193: Procedure post_update(
194: p_effective_date in date,p_rec in pqp_aad_shd.g_rec_type) is
195: --
196: l_proc varchar2(72) := g_package||'post_update';
197: --
198: Begin

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

226: ,p_object_version_number =>p_rec.object_version_number
227: ,p_effective_date =>p_effective_date
228: ,p_date_8233_signed =>p_rec.date_8233_signed
229: ,p_date_w4_signed =>p_rec.date_w4_signed
230: ,p_assignment_id_o =>pqp_aad_shd.g_old_rec.assignment_id
231: ,p_data_source_o =>pqp_aad_shd.g_old_rec.data_source
232: ,p_tax_year_o =>pqp_aad_shd.g_old_rec.tax_year
233: ,p_current_residency_status_o =>pqp_aad_shd.g_old_rec.current_residency_status
234: ,p_nra_to_ra_date_o =>pqp_aad_shd.g_old_rec.nra_to_ra_date

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

227: ,p_effective_date =>p_effective_date
228: ,p_date_8233_signed =>p_rec.date_8233_signed
229: ,p_date_w4_signed =>p_rec.date_w4_signed
230: ,p_assignment_id_o =>pqp_aad_shd.g_old_rec.assignment_id
231: ,p_data_source_o =>pqp_aad_shd.g_old_rec.data_source
232: ,p_tax_year_o =>pqp_aad_shd.g_old_rec.tax_year
233: ,p_current_residency_status_o =>pqp_aad_shd.g_old_rec.current_residency_status
234: ,p_nra_to_ra_date_o =>pqp_aad_shd.g_old_rec.nra_to_ra_date
235: ,p_target_departure_date_o =>pqp_aad_shd.g_old_rec.target_departure_date

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

228: ,p_date_8233_signed =>p_rec.date_8233_signed
229: ,p_date_w4_signed =>p_rec.date_w4_signed
230: ,p_assignment_id_o =>pqp_aad_shd.g_old_rec.assignment_id
231: ,p_data_source_o =>pqp_aad_shd.g_old_rec.data_source
232: ,p_tax_year_o =>pqp_aad_shd.g_old_rec.tax_year
233: ,p_current_residency_status_o =>pqp_aad_shd.g_old_rec.current_residency_status
234: ,p_nra_to_ra_date_o =>pqp_aad_shd.g_old_rec.nra_to_ra_date
235: ,p_target_departure_date_o =>pqp_aad_shd.g_old_rec.target_departure_date
236: ,p_tax_residence_country_code_o =>pqp_aad_shd.g_old_rec.tax_residence_country_code

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

229: ,p_date_w4_signed =>p_rec.date_w4_signed
230: ,p_assignment_id_o =>pqp_aad_shd.g_old_rec.assignment_id
231: ,p_data_source_o =>pqp_aad_shd.g_old_rec.data_source
232: ,p_tax_year_o =>pqp_aad_shd.g_old_rec.tax_year
233: ,p_current_residency_status_o =>pqp_aad_shd.g_old_rec.current_residency_status
234: ,p_nra_to_ra_date_o =>pqp_aad_shd.g_old_rec.nra_to_ra_date
235: ,p_target_departure_date_o =>pqp_aad_shd.g_old_rec.target_departure_date
236: ,p_tax_residence_country_code_o =>pqp_aad_shd.g_old_rec.tax_residence_country_code
237: ,p_treaty_info_update_date_o =>pqp_aad_shd.g_old_rec.treaty_info_update_date

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

230: ,p_assignment_id_o =>pqp_aad_shd.g_old_rec.assignment_id
231: ,p_data_source_o =>pqp_aad_shd.g_old_rec.data_source
232: ,p_tax_year_o =>pqp_aad_shd.g_old_rec.tax_year
233: ,p_current_residency_status_o =>pqp_aad_shd.g_old_rec.current_residency_status
234: ,p_nra_to_ra_date_o =>pqp_aad_shd.g_old_rec.nra_to_ra_date
235: ,p_target_departure_date_o =>pqp_aad_shd.g_old_rec.target_departure_date
236: ,p_tax_residence_country_code_o =>pqp_aad_shd.g_old_rec.tax_residence_country_code
237: ,p_treaty_info_update_date_o =>pqp_aad_shd.g_old_rec.treaty_info_update_date
238: ,p_number_of_days_in_usa_o =>pqp_aad_shd.g_old_rec.number_of_days_in_usa

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

231: ,p_data_source_o =>pqp_aad_shd.g_old_rec.data_source
232: ,p_tax_year_o =>pqp_aad_shd.g_old_rec.tax_year
233: ,p_current_residency_status_o =>pqp_aad_shd.g_old_rec.current_residency_status
234: ,p_nra_to_ra_date_o =>pqp_aad_shd.g_old_rec.nra_to_ra_date
235: ,p_target_departure_date_o =>pqp_aad_shd.g_old_rec.target_departure_date
236: ,p_tax_residence_country_code_o =>pqp_aad_shd.g_old_rec.tax_residence_country_code
237: ,p_treaty_info_update_date_o =>pqp_aad_shd.g_old_rec.treaty_info_update_date
238: ,p_number_of_days_in_usa_o =>pqp_aad_shd.g_old_rec.number_of_days_in_usa
239: ,p_withldg_allow_eligible_fla_o =>pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag

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

232: ,p_tax_year_o =>pqp_aad_shd.g_old_rec.tax_year
233: ,p_current_residency_status_o =>pqp_aad_shd.g_old_rec.current_residency_status
234: ,p_nra_to_ra_date_o =>pqp_aad_shd.g_old_rec.nra_to_ra_date
235: ,p_target_departure_date_o =>pqp_aad_shd.g_old_rec.target_departure_date
236: ,p_tax_residence_country_code_o =>pqp_aad_shd.g_old_rec.tax_residence_country_code
237: ,p_treaty_info_update_date_o =>pqp_aad_shd.g_old_rec.treaty_info_update_date
238: ,p_number_of_days_in_usa_o =>pqp_aad_shd.g_old_rec.number_of_days_in_usa
239: ,p_withldg_allow_eligible_fla_o =>pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag
240: ,p_ra_effective_date_o =>pqp_aad_shd.g_old_rec.ra_effective_date

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

233: ,p_current_residency_status_o =>pqp_aad_shd.g_old_rec.current_residency_status
234: ,p_nra_to_ra_date_o =>pqp_aad_shd.g_old_rec.nra_to_ra_date
235: ,p_target_departure_date_o =>pqp_aad_shd.g_old_rec.target_departure_date
236: ,p_tax_residence_country_code_o =>pqp_aad_shd.g_old_rec.tax_residence_country_code
237: ,p_treaty_info_update_date_o =>pqp_aad_shd.g_old_rec.treaty_info_update_date
238: ,p_number_of_days_in_usa_o =>pqp_aad_shd.g_old_rec.number_of_days_in_usa
239: ,p_withldg_allow_eligible_fla_o =>pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag
240: ,p_ra_effective_date_o =>pqp_aad_shd.g_old_rec.ra_effective_date
241: ,p_record_source_o =>pqp_aad_shd.g_old_rec.record_source

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

234: ,p_nra_to_ra_date_o =>pqp_aad_shd.g_old_rec.nra_to_ra_date
235: ,p_target_departure_date_o =>pqp_aad_shd.g_old_rec.target_departure_date
236: ,p_tax_residence_country_code_o =>pqp_aad_shd.g_old_rec.tax_residence_country_code
237: ,p_treaty_info_update_date_o =>pqp_aad_shd.g_old_rec.treaty_info_update_date
238: ,p_number_of_days_in_usa_o =>pqp_aad_shd.g_old_rec.number_of_days_in_usa
239: ,p_withldg_allow_eligible_fla_o =>pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag
240: ,p_ra_effective_date_o =>pqp_aad_shd.g_old_rec.ra_effective_date
241: ,p_record_source_o =>pqp_aad_shd.g_old_rec.record_source
242: ,p_visa_type_o =>pqp_aad_shd.g_old_rec.visa_type

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

235: ,p_target_departure_date_o =>pqp_aad_shd.g_old_rec.target_departure_date
236: ,p_tax_residence_country_code_o =>pqp_aad_shd.g_old_rec.tax_residence_country_code
237: ,p_treaty_info_update_date_o =>pqp_aad_shd.g_old_rec.treaty_info_update_date
238: ,p_number_of_days_in_usa_o =>pqp_aad_shd.g_old_rec.number_of_days_in_usa
239: ,p_withldg_allow_eligible_fla_o =>pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag
240: ,p_ra_effective_date_o =>pqp_aad_shd.g_old_rec.ra_effective_date
241: ,p_record_source_o =>pqp_aad_shd.g_old_rec.record_source
242: ,p_visa_type_o =>pqp_aad_shd.g_old_rec.visa_type
243: ,p_j_sub_type_o =>pqp_aad_shd.g_old_rec.j_sub_type

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

236: ,p_tax_residence_country_code_o =>pqp_aad_shd.g_old_rec.tax_residence_country_code
237: ,p_treaty_info_update_date_o =>pqp_aad_shd.g_old_rec.treaty_info_update_date
238: ,p_number_of_days_in_usa_o =>pqp_aad_shd.g_old_rec.number_of_days_in_usa
239: ,p_withldg_allow_eligible_fla_o =>pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag
240: ,p_ra_effective_date_o =>pqp_aad_shd.g_old_rec.ra_effective_date
241: ,p_record_source_o =>pqp_aad_shd.g_old_rec.record_source
242: ,p_visa_type_o =>pqp_aad_shd.g_old_rec.visa_type
243: ,p_j_sub_type_o =>pqp_aad_shd.g_old_rec.j_sub_type
244: ,p_primary_activity_o =>pqp_aad_shd.g_old_rec.primary_activity

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

237: ,p_treaty_info_update_date_o =>pqp_aad_shd.g_old_rec.treaty_info_update_date
238: ,p_number_of_days_in_usa_o =>pqp_aad_shd.g_old_rec.number_of_days_in_usa
239: ,p_withldg_allow_eligible_fla_o =>pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag
240: ,p_ra_effective_date_o =>pqp_aad_shd.g_old_rec.ra_effective_date
241: ,p_record_source_o =>pqp_aad_shd.g_old_rec.record_source
242: ,p_visa_type_o =>pqp_aad_shd.g_old_rec.visa_type
243: ,p_j_sub_type_o =>pqp_aad_shd.g_old_rec.j_sub_type
244: ,p_primary_activity_o =>pqp_aad_shd.g_old_rec.primary_activity
245: ,p_non_us_country_code_o =>pqp_aad_shd.g_old_rec.non_us_country_code

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

238: ,p_number_of_days_in_usa_o =>pqp_aad_shd.g_old_rec.number_of_days_in_usa
239: ,p_withldg_allow_eligible_fla_o =>pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag
240: ,p_ra_effective_date_o =>pqp_aad_shd.g_old_rec.ra_effective_date
241: ,p_record_source_o =>pqp_aad_shd.g_old_rec.record_source
242: ,p_visa_type_o =>pqp_aad_shd.g_old_rec.visa_type
243: ,p_j_sub_type_o =>pqp_aad_shd.g_old_rec.j_sub_type
244: ,p_primary_activity_o =>pqp_aad_shd.g_old_rec.primary_activity
245: ,p_non_us_country_code_o =>pqp_aad_shd.g_old_rec.non_us_country_code
246: ,p_citizenship_country_code_o =>pqp_aad_shd.g_old_rec.citizenship_country_code

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

239: ,p_withldg_allow_eligible_fla_o =>pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag
240: ,p_ra_effective_date_o =>pqp_aad_shd.g_old_rec.ra_effective_date
241: ,p_record_source_o =>pqp_aad_shd.g_old_rec.record_source
242: ,p_visa_type_o =>pqp_aad_shd.g_old_rec.visa_type
243: ,p_j_sub_type_o =>pqp_aad_shd.g_old_rec.j_sub_type
244: ,p_primary_activity_o =>pqp_aad_shd.g_old_rec.primary_activity
245: ,p_non_us_country_code_o =>pqp_aad_shd.g_old_rec.non_us_country_code
246: ,p_citizenship_country_code_o =>pqp_aad_shd.g_old_rec.citizenship_country_code
247: ,p_object_version_number_o =>pqp_aad_shd.g_old_rec.object_version_number

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

240: ,p_ra_effective_date_o =>pqp_aad_shd.g_old_rec.ra_effective_date
241: ,p_record_source_o =>pqp_aad_shd.g_old_rec.record_source
242: ,p_visa_type_o =>pqp_aad_shd.g_old_rec.visa_type
243: ,p_j_sub_type_o =>pqp_aad_shd.g_old_rec.j_sub_type
244: ,p_primary_activity_o =>pqp_aad_shd.g_old_rec.primary_activity
245: ,p_non_us_country_code_o =>pqp_aad_shd.g_old_rec.non_us_country_code
246: ,p_citizenship_country_code_o =>pqp_aad_shd.g_old_rec.citizenship_country_code
247: ,p_object_version_number_o =>pqp_aad_shd.g_old_rec.object_version_number
248: ,p_date_8233_signed_o =>pqp_aad_shd.g_old_rec.date_8233_signed

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

241: ,p_record_source_o =>pqp_aad_shd.g_old_rec.record_source
242: ,p_visa_type_o =>pqp_aad_shd.g_old_rec.visa_type
243: ,p_j_sub_type_o =>pqp_aad_shd.g_old_rec.j_sub_type
244: ,p_primary_activity_o =>pqp_aad_shd.g_old_rec.primary_activity
245: ,p_non_us_country_code_o =>pqp_aad_shd.g_old_rec.non_us_country_code
246: ,p_citizenship_country_code_o =>pqp_aad_shd.g_old_rec.citizenship_country_code
247: ,p_object_version_number_o =>pqp_aad_shd.g_old_rec.object_version_number
248: ,p_date_8233_signed_o =>pqp_aad_shd.g_old_rec.date_8233_signed
249: ,p_date_w4_signed_o =>pqp_aad_shd.g_old_rec.date_w4_signed

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

242: ,p_visa_type_o =>pqp_aad_shd.g_old_rec.visa_type
243: ,p_j_sub_type_o =>pqp_aad_shd.g_old_rec.j_sub_type
244: ,p_primary_activity_o =>pqp_aad_shd.g_old_rec.primary_activity
245: ,p_non_us_country_code_o =>pqp_aad_shd.g_old_rec.non_us_country_code
246: ,p_citizenship_country_code_o =>pqp_aad_shd.g_old_rec.citizenship_country_code
247: ,p_object_version_number_o =>pqp_aad_shd.g_old_rec.object_version_number
248: ,p_date_8233_signed_o =>pqp_aad_shd.g_old_rec.date_8233_signed
249: ,p_date_w4_signed_o =>pqp_aad_shd.g_old_rec.date_w4_signed
250: );

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

243: ,p_j_sub_type_o =>pqp_aad_shd.g_old_rec.j_sub_type
244: ,p_primary_activity_o =>pqp_aad_shd.g_old_rec.primary_activity
245: ,p_non_us_country_code_o =>pqp_aad_shd.g_old_rec.non_us_country_code
246: ,p_citizenship_country_code_o =>pqp_aad_shd.g_old_rec.citizenship_country_code
247: ,p_object_version_number_o =>pqp_aad_shd.g_old_rec.object_version_number
248: ,p_date_8233_signed_o =>pqp_aad_shd.g_old_rec.date_8233_signed
249: ,p_date_w4_signed_o =>pqp_aad_shd.g_old_rec.date_w4_signed
250: );
251: --

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

244: ,p_primary_activity_o =>pqp_aad_shd.g_old_rec.primary_activity
245: ,p_non_us_country_code_o =>pqp_aad_shd.g_old_rec.non_us_country_code
246: ,p_citizenship_country_code_o =>pqp_aad_shd.g_old_rec.citizenship_country_code
247: ,p_object_version_number_o =>pqp_aad_shd.g_old_rec.object_version_number
248: ,p_date_8233_signed_o =>pqp_aad_shd.g_old_rec.date_8233_signed
249: ,p_date_w4_signed_o =>pqp_aad_shd.g_old_rec.date_w4_signed
250: );
251: --
252: exception

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

245: ,p_non_us_country_code_o =>pqp_aad_shd.g_old_rec.non_us_country_code
246: ,p_citizenship_country_code_o =>pqp_aad_shd.g_old_rec.citizenship_country_code
247: ,p_object_version_number_o =>pqp_aad_shd.g_old_rec.object_version_number
248: ,p_date_8233_signed_o =>pqp_aad_shd.g_old_rec.date_8233_signed
249: ,p_date_w4_signed_o =>pqp_aad_shd.g_old_rec.date_w4_signed
250: );
251: --
252: exception
253: --

Line 311: Procedure convert_defs(p_rec in out nocopy pqp_aad_shd.g_rec_type) is

307: -- Internal Row Handler Use Only.
308: --
309: -- {End Of Comments}
310: -- ----------------------------------------------------------------------------
311: Procedure convert_defs(p_rec in out nocopy pqp_aad_shd.g_rec_type) is
312: --
313: l_proc varchar2(72) := g_package||'convert_defs';
314: --
315: Begin

Line 326: pqp_aad_shd.g_old_rec.assignment_id;

322: -- is being used then we must set to the 'current' argument value.
323: --
324: If (p_rec.assignment_id = hr_api.g_number) then
325: p_rec.assignment_id :=
326: pqp_aad_shd.g_old_rec.assignment_id;
327: End If;
328: If (p_rec.data_source = hr_api.g_varchar2) then
329: p_rec.data_source :=
330: pqp_aad_shd.g_old_rec.data_source;

Line 330: pqp_aad_shd.g_old_rec.data_source;

326: pqp_aad_shd.g_old_rec.assignment_id;
327: End If;
328: If (p_rec.data_source = hr_api.g_varchar2) then
329: p_rec.data_source :=
330: pqp_aad_shd.g_old_rec.data_source;
331: End If;
332: If (p_rec.tax_year = hr_api.g_number) then
333: p_rec.tax_year :=
334: pqp_aad_shd.g_old_rec.tax_year;

Line 334: pqp_aad_shd.g_old_rec.tax_year;

330: pqp_aad_shd.g_old_rec.data_source;
331: End If;
332: If (p_rec.tax_year = hr_api.g_number) then
333: p_rec.tax_year :=
334: pqp_aad_shd.g_old_rec.tax_year;
335: End If;
336: If (p_rec.current_residency_status = hr_api.g_varchar2) then
337: p_rec.current_residency_status :=
338: pqp_aad_shd.g_old_rec.current_residency_status;

Line 338: pqp_aad_shd.g_old_rec.current_residency_status;

334: pqp_aad_shd.g_old_rec.tax_year;
335: End If;
336: If (p_rec.current_residency_status = hr_api.g_varchar2) then
337: p_rec.current_residency_status :=
338: pqp_aad_shd.g_old_rec.current_residency_status;
339: End If;
340: If (p_rec.nra_to_ra_date = hr_api.g_date) then
341: p_rec.nra_to_ra_date :=
342: pqp_aad_shd.g_old_rec.nra_to_ra_date;

Line 342: pqp_aad_shd.g_old_rec.nra_to_ra_date;

338: pqp_aad_shd.g_old_rec.current_residency_status;
339: End If;
340: If (p_rec.nra_to_ra_date = hr_api.g_date) then
341: p_rec.nra_to_ra_date :=
342: pqp_aad_shd.g_old_rec.nra_to_ra_date;
343: End If;
344: If (p_rec.target_departure_date = hr_api.g_date) then
345: p_rec.target_departure_date :=
346: pqp_aad_shd.g_old_rec.target_departure_date;

Line 346: pqp_aad_shd.g_old_rec.target_departure_date;

342: pqp_aad_shd.g_old_rec.nra_to_ra_date;
343: End If;
344: If (p_rec.target_departure_date = hr_api.g_date) then
345: p_rec.target_departure_date :=
346: pqp_aad_shd.g_old_rec.target_departure_date;
347: End If;
348: If (p_rec.tax_residence_country_code = hr_api.g_varchar2) then
349: p_rec.tax_residence_country_code :=
350: pqp_aad_shd.g_old_rec.tax_residence_country_code;

Line 350: pqp_aad_shd.g_old_rec.tax_residence_country_code;

346: pqp_aad_shd.g_old_rec.target_departure_date;
347: End If;
348: If (p_rec.tax_residence_country_code = hr_api.g_varchar2) then
349: p_rec.tax_residence_country_code :=
350: pqp_aad_shd.g_old_rec.tax_residence_country_code;
351: End If;
352: If (p_rec.treaty_info_update_date = hr_api.g_date) then
353: p_rec.treaty_info_update_date :=
354: pqp_aad_shd.g_old_rec.treaty_info_update_date;

Line 354: pqp_aad_shd.g_old_rec.treaty_info_update_date;

350: pqp_aad_shd.g_old_rec.tax_residence_country_code;
351: End If;
352: If (p_rec.treaty_info_update_date = hr_api.g_date) then
353: p_rec.treaty_info_update_date :=
354: pqp_aad_shd.g_old_rec.treaty_info_update_date;
355: End If;
356: If (p_rec.number_of_days_in_usa = hr_api.g_number) then
357: p_rec.number_of_days_in_usa :=
358: pqp_aad_shd.g_old_rec.number_of_days_in_usa;

Line 358: pqp_aad_shd.g_old_rec.number_of_days_in_usa;

354: pqp_aad_shd.g_old_rec.treaty_info_update_date;
355: End If;
356: If (p_rec.number_of_days_in_usa = hr_api.g_number) then
357: p_rec.number_of_days_in_usa :=
358: pqp_aad_shd.g_old_rec.number_of_days_in_usa;
359: End If;
360: If (p_rec.withldg_allow_eligible_flag = hr_api.g_varchar2) then
361: p_rec.withldg_allow_eligible_flag :=
362: pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag;

Line 362: pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag;

358: pqp_aad_shd.g_old_rec.number_of_days_in_usa;
359: End If;
360: If (p_rec.withldg_allow_eligible_flag = hr_api.g_varchar2) then
361: p_rec.withldg_allow_eligible_flag :=
362: pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag;
363: End If;
364: If (p_rec.ra_effective_date = hr_api.g_date) then
365: p_rec.ra_effective_date :=
366: pqp_aad_shd.g_old_rec.ra_effective_date;

Line 366: pqp_aad_shd.g_old_rec.ra_effective_date;

362: pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag;
363: End If;
364: If (p_rec.ra_effective_date = hr_api.g_date) then
365: p_rec.ra_effective_date :=
366: pqp_aad_shd.g_old_rec.ra_effective_date;
367: End If;
368: If (p_rec.record_source = hr_api.g_varchar2) then
369: p_rec.record_source :=
370: pqp_aad_shd.g_old_rec.record_source;

Line 370: pqp_aad_shd.g_old_rec.record_source;

366: pqp_aad_shd.g_old_rec.ra_effective_date;
367: End If;
368: If (p_rec.record_source = hr_api.g_varchar2) then
369: p_rec.record_source :=
370: pqp_aad_shd.g_old_rec.record_source;
371: End If;
372: If (p_rec.visa_type = hr_api.g_varchar2) then
373: p_rec.visa_type :=
374: pqp_aad_shd.g_old_rec.visa_type;

Line 374: pqp_aad_shd.g_old_rec.visa_type;

370: pqp_aad_shd.g_old_rec.record_source;
371: End If;
372: If (p_rec.visa_type = hr_api.g_varchar2) then
373: p_rec.visa_type :=
374: pqp_aad_shd.g_old_rec.visa_type;
375: End If;
376: If (p_rec.j_sub_type = hr_api.g_varchar2) then
377: p_rec.j_sub_type :=
378: pqp_aad_shd.g_old_rec.j_sub_type;

Line 378: pqp_aad_shd.g_old_rec.j_sub_type;

374: pqp_aad_shd.g_old_rec.visa_type;
375: End If;
376: If (p_rec.j_sub_type = hr_api.g_varchar2) then
377: p_rec.j_sub_type :=
378: pqp_aad_shd.g_old_rec.j_sub_type;
379: End If;
380: If (p_rec.primary_activity = hr_api.g_varchar2) then
381: p_rec.primary_activity :=
382: pqp_aad_shd.g_old_rec.primary_activity;

Line 382: pqp_aad_shd.g_old_rec.primary_activity;

378: pqp_aad_shd.g_old_rec.j_sub_type;
379: End If;
380: If (p_rec.primary_activity = hr_api.g_varchar2) then
381: p_rec.primary_activity :=
382: pqp_aad_shd.g_old_rec.primary_activity;
383: End If;
384: If (p_rec.non_us_country_code = hr_api.g_varchar2) then
385: p_rec.non_us_country_code :=
386: pqp_aad_shd.g_old_rec.non_us_country_code;

Line 386: pqp_aad_shd.g_old_rec.non_us_country_code;

382: pqp_aad_shd.g_old_rec.primary_activity;
383: End If;
384: If (p_rec.non_us_country_code = hr_api.g_varchar2) then
385: p_rec.non_us_country_code :=
386: pqp_aad_shd.g_old_rec.non_us_country_code;
387: End If;
388: If (p_rec.citizenship_country_code = hr_api.g_varchar2) then
389: p_rec.citizenship_country_code :=
390: pqp_aad_shd.g_old_rec.citizenship_country_code;

Line 390: pqp_aad_shd.g_old_rec.citizenship_country_code;

386: pqp_aad_shd.g_old_rec.non_us_country_code;
387: End If;
388: If (p_rec.citizenship_country_code = hr_api.g_varchar2) then
389: p_rec.citizenship_country_code :=
390: pqp_aad_shd.g_old_rec.citizenship_country_code;
391: End If;
392: If (p_rec.date_8233_signed = hr_api.g_date) then
393: p_rec.date_8233_signed :=
394: pqp_aad_shd.g_old_rec.date_8233_signed;

Line 394: pqp_aad_shd.g_old_rec.date_8233_signed;

390: pqp_aad_shd.g_old_rec.citizenship_country_code;
391: End If;
392: If (p_rec.date_8233_signed = hr_api.g_date) then
393: p_rec.date_8233_signed :=
394: pqp_aad_shd.g_old_rec.date_8233_signed;
395: End If;
396: If (p_rec.date_w4_signed = hr_api.g_date) then
397: p_rec.date_w4_signed :=
398: pqp_aad_shd.g_old_rec.date_w4_signed;

Line 398: pqp_aad_shd.g_old_rec.date_w4_signed;

394: pqp_aad_shd.g_old_rec.date_8233_signed;
395: End If;
396: If (p_rec.date_w4_signed = hr_api.g_date) then
397: p_rec.date_w4_signed :=
398: pqp_aad_shd.g_old_rec.date_w4_signed;
399: End If;
400:
401: --
402: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 412: p_rec in out nocopy pqp_aad_shd.g_rec_type

408: -- ----------------------------------------------------------------------------
409: Procedure upd
410: (
411: p_effective_date in date,
412: p_rec in out nocopy pqp_aad_shd.g_rec_type
413: ) is
414: --
415: l_proc varchar2(72) := g_package||'upd';
416: --

Line 422: pqp_aad_shd.lck

418: hr_utility.set_location('Entering:'||l_proc, 5);
419: --
420: -- We must lock the row which we need to update.
421: --
422: pqp_aad_shd.lck
423: (
424: p_rec.analyzed_data_id,
425: p_rec.object_version_number
426: );

Line 481: l_rec pqp_aad_shd.g_rec_type;

477: p_date_8233_signed in date default hr_api.g_date ,
478: p_date_w4_signed in date default hr_api.g_date
479: ) is
480: --
481: l_rec pqp_aad_shd.g_rec_type;
482: l_proc varchar2(72) := g_package||'upd';
483: --
484: Begin
485: hr_utility.set_location('Entering:'||l_proc, 5);

Line 491: pqp_aad_shd.convert_args

487: -- Call conversion function to turn arguments into the
488: -- l_rec structure.
489: --
490: l_rec :=
491: pqp_aad_shd.convert_args
492: (
493: p_analyzed_data_id,
494: p_assignment_id,
495: p_data_source,