50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy pqp_atd_shd.g_rec_type) is
55:
56: l_proc varchar2(72) := g_package||'update_dml';
57:
58: Begin
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: pqp_atd_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the pqp_alien_transaction_data Row
68: --
69: update pqp_alien_transaction_data
121: current_analysis = p_rec.current_analysis,
122: forecast_income_code = p_rec.forecast_income_code
123: where alien_transaction_id = p_rec.alien_transaction_id;
124: --
125: pqp_atd_shd.g_api_dml := false; -- Unset the api dml status
126: --
127: hr_utility.set_location(' Leaving:'||l_proc, 10);
128:
129: Exception
128:
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: pqp_atd_shd.g_api_dml := false; -- Unset the api dml status
133: pqp_atd_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: pqp_atd_shd.g_api_dml := false; -- Unset the api dml status
133: pqp_atd_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: pqp_atd_shd.g_api_dml := false; -- Unset the api dml status
133: pqp_atd_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: pqp_atd_shd.g_api_dml := false; -- Unset the api dml status
138: pqp_atd_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: pqp_atd_shd.g_api_dml := false; -- Unset the api dml status
138: pqp_atd_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: pqp_atd_shd.g_api_dml := false; -- Unset the api dml status
138: pqp_atd_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: pqp_atd_shd.g_api_dml := false; -- Unset the api dml status
143: pqp_atd_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others Then
146: pqp_atd_shd.g_api_dml := false; -- Unset the api dml status
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: pqp_atd_shd.g_api_dml := false; -- Unset the api dml status
143: pqp_atd_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others Then
146: pqp_atd_shd.g_api_dml := false; -- Unset the api dml status
147: Raise;
142: pqp_atd_shd.g_api_dml := false; -- Unset the api dml status
143: pqp_atd_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others Then
146: pqp_atd_shd.g_api_dml := false; -- Unset the api dml status
147: Raise;
148: End update_dml;
149:
150: ----------------------------------------------------------------------------
178: -- Internal Row Handler Use Only.
179: --
180: -- {End Of Comments}
181: ----------------------------------------------------------------------------
182: Procedure pre_update(p_rec in pqp_atd_shd.g_rec_type) is
183:
184: l_proc varchar2(72) := g_package||'pre_update';
185:
186: Begin
221: --
222: -- {End Of Comments}
223: ----------------------------------------------------------------------------
224: Procedure post_update(
225: p_effective_date in date,p_rec in pqp_atd_shd.g_rec_type) is
226:
227: l_proc varchar2(72) := g_package||'post_update';
228:
229: Begin
288: ,p_object_version_number =>p_rec.object_version_number
289: ,p_effective_date =>p_effective_date
290: ,p_current_analysis =>p_rec.current_analysis
291: ,p_forecast_income_code =>p_rec.forecast_income_code
292: ,p_person_id_o =>pqp_atd_shd.g_old_rec.person_id
293: ,p_data_source_type_o =>pqp_atd_shd.g_old_rec.data_source_type
294: ,p_tax_year_o =>pqp_atd_shd.g_old_rec.tax_year
295: ,p_income_code_o =>pqp_atd_shd.g_old_rec.income_code
296: ,p_withholding_rate_o =>pqp_atd_shd.g_old_rec.withholding_rate
289: ,p_effective_date =>p_effective_date
290: ,p_current_analysis =>p_rec.current_analysis
291: ,p_forecast_income_code =>p_rec.forecast_income_code
292: ,p_person_id_o =>pqp_atd_shd.g_old_rec.person_id
293: ,p_data_source_type_o =>pqp_atd_shd.g_old_rec.data_source_type
294: ,p_tax_year_o =>pqp_atd_shd.g_old_rec.tax_year
295: ,p_income_code_o =>pqp_atd_shd.g_old_rec.income_code
296: ,p_withholding_rate_o =>pqp_atd_shd.g_old_rec.withholding_rate
297: ,p_income_code_sub_type_o =>pqp_atd_shd.g_old_rec.income_code_sub_type
290: ,p_current_analysis =>p_rec.current_analysis
291: ,p_forecast_income_code =>p_rec.forecast_income_code
292: ,p_person_id_o =>pqp_atd_shd.g_old_rec.person_id
293: ,p_data_source_type_o =>pqp_atd_shd.g_old_rec.data_source_type
294: ,p_tax_year_o =>pqp_atd_shd.g_old_rec.tax_year
295: ,p_income_code_o =>pqp_atd_shd.g_old_rec.income_code
296: ,p_withholding_rate_o =>pqp_atd_shd.g_old_rec.withholding_rate
297: ,p_income_code_sub_type_o =>pqp_atd_shd.g_old_rec.income_code_sub_type
298: ,p_exemption_code_o =>pqp_atd_shd.g_old_rec.exemption_code
291: ,p_forecast_income_code =>p_rec.forecast_income_code
292: ,p_person_id_o =>pqp_atd_shd.g_old_rec.person_id
293: ,p_data_source_type_o =>pqp_atd_shd.g_old_rec.data_source_type
294: ,p_tax_year_o =>pqp_atd_shd.g_old_rec.tax_year
295: ,p_income_code_o =>pqp_atd_shd.g_old_rec.income_code
296: ,p_withholding_rate_o =>pqp_atd_shd.g_old_rec.withholding_rate
297: ,p_income_code_sub_type_o =>pqp_atd_shd.g_old_rec.income_code_sub_type
298: ,p_exemption_code_o =>pqp_atd_shd.g_old_rec.exemption_code
299: ,p_maximum_benefit_amount_o =>pqp_atd_shd.g_old_rec.maximum_benefit_amount
292: ,p_person_id_o =>pqp_atd_shd.g_old_rec.person_id
293: ,p_data_source_type_o =>pqp_atd_shd.g_old_rec.data_source_type
294: ,p_tax_year_o =>pqp_atd_shd.g_old_rec.tax_year
295: ,p_income_code_o =>pqp_atd_shd.g_old_rec.income_code
296: ,p_withholding_rate_o =>pqp_atd_shd.g_old_rec.withholding_rate
297: ,p_income_code_sub_type_o =>pqp_atd_shd.g_old_rec.income_code_sub_type
298: ,p_exemption_code_o =>pqp_atd_shd.g_old_rec.exemption_code
299: ,p_maximum_benefit_amount_o =>pqp_atd_shd.g_old_rec.maximum_benefit_amount
300: ,p_retro_lose_ben_amt_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag
293: ,p_data_source_type_o =>pqp_atd_shd.g_old_rec.data_source_type
294: ,p_tax_year_o =>pqp_atd_shd.g_old_rec.tax_year
295: ,p_income_code_o =>pqp_atd_shd.g_old_rec.income_code
296: ,p_withholding_rate_o =>pqp_atd_shd.g_old_rec.withholding_rate
297: ,p_income_code_sub_type_o =>pqp_atd_shd.g_old_rec.income_code_sub_type
298: ,p_exemption_code_o =>pqp_atd_shd.g_old_rec.exemption_code
299: ,p_maximum_benefit_amount_o =>pqp_atd_shd.g_old_rec.maximum_benefit_amount
300: ,p_retro_lose_ben_amt_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag
301: ,p_date_benefit_ends_o =>pqp_atd_shd.g_old_rec.date_benefit_ends
294: ,p_tax_year_o =>pqp_atd_shd.g_old_rec.tax_year
295: ,p_income_code_o =>pqp_atd_shd.g_old_rec.income_code
296: ,p_withholding_rate_o =>pqp_atd_shd.g_old_rec.withholding_rate
297: ,p_income_code_sub_type_o =>pqp_atd_shd.g_old_rec.income_code_sub_type
298: ,p_exemption_code_o =>pqp_atd_shd.g_old_rec.exemption_code
299: ,p_maximum_benefit_amount_o =>pqp_atd_shd.g_old_rec.maximum_benefit_amount
300: ,p_retro_lose_ben_amt_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag
301: ,p_date_benefit_ends_o =>pqp_atd_shd.g_old_rec.date_benefit_ends
302: ,p_retro_lose_ben_date_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag
295: ,p_income_code_o =>pqp_atd_shd.g_old_rec.income_code
296: ,p_withholding_rate_o =>pqp_atd_shd.g_old_rec.withholding_rate
297: ,p_income_code_sub_type_o =>pqp_atd_shd.g_old_rec.income_code_sub_type
298: ,p_exemption_code_o =>pqp_atd_shd.g_old_rec.exemption_code
299: ,p_maximum_benefit_amount_o =>pqp_atd_shd.g_old_rec.maximum_benefit_amount
300: ,p_retro_lose_ben_amt_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag
301: ,p_date_benefit_ends_o =>pqp_atd_shd.g_old_rec.date_benefit_ends
302: ,p_retro_lose_ben_date_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag
303: ,p_current_residency_status_o =>pqp_atd_shd.g_old_rec.current_residency_status
296: ,p_withholding_rate_o =>pqp_atd_shd.g_old_rec.withholding_rate
297: ,p_income_code_sub_type_o =>pqp_atd_shd.g_old_rec.income_code_sub_type
298: ,p_exemption_code_o =>pqp_atd_shd.g_old_rec.exemption_code
299: ,p_maximum_benefit_amount_o =>pqp_atd_shd.g_old_rec.maximum_benefit_amount
300: ,p_retro_lose_ben_amt_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag
301: ,p_date_benefit_ends_o =>pqp_atd_shd.g_old_rec.date_benefit_ends
302: ,p_retro_lose_ben_date_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag
303: ,p_current_residency_status_o =>pqp_atd_shd.g_old_rec.current_residency_status
304: ,p_nra_to_ra_date_o =>pqp_atd_shd.g_old_rec.nra_to_ra_date
297: ,p_income_code_sub_type_o =>pqp_atd_shd.g_old_rec.income_code_sub_type
298: ,p_exemption_code_o =>pqp_atd_shd.g_old_rec.exemption_code
299: ,p_maximum_benefit_amount_o =>pqp_atd_shd.g_old_rec.maximum_benefit_amount
300: ,p_retro_lose_ben_amt_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag
301: ,p_date_benefit_ends_o =>pqp_atd_shd.g_old_rec.date_benefit_ends
302: ,p_retro_lose_ben_date_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag
303: ,p_current_residency_status_o =>pqp_atd_shd.g_old_rec.current_residency_status
304: ,p_nra_to_ra_date_o =>pqp_atd_shd.g_old_rec.nra_to_ra_date
305: ,p_target_departure_date_o =>pqp_atd_shd.g_old_rec.target_departure_date
298: ,p_exemption_code_o =>pqp_atd_shd.g_old_rec.exemption_code
299: ,p_maximum_benefit_amount_o =>pqp_atd_shd.g_old_rec.maximum_benefit_amount
300: ,p_retro_lose_ben_amt_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag
301: ,p_date_benefit_ends_o =>pqp_atd_shd.g_old_rec.date_benefit_ends
302: ,p_retro_lose_ben_date_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag
303: ,p_current_residency_status_o =>pqp_atd_shd.g_old_rec.current_residency_status
304: ,p_nra_to_ra_date_o =>pqp_atd_shd.g_old_rec.nra_to_ra_date
305: ,p_target_departure_date_o =>pqp_atd_shd.g_old_rec.target_departure_date
306: ,p_tax_residence_country_code_o =>pqp_atd_shd.g_old_rec.tax_residence_country_code
299: ,p_maximum_benefit_amount_o =>pqp_atd_shd.g_old_rec.maximum_benefit_amount
300: ,p_retro_lose_ben_amt_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag
301: ,p_date_benefit_ends_o =>pqp_atd_shd.g_old_rec.date_benefit_ends
302: ,p_retro_lose_ben_date_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag
303: ,p_current_residency_status_o =>pqp_atd_shd.g_old_rec.current_residency_status
304: ,p_nra_to_ra_date_o =>pqp_atd_shd.g_old_rec.nra_to_ra_date
305: ,p_target_departure_date_o =>pqp_atd_shd.g_old_rec.target_departure_date
306: ,p_tax_residence_country_code_o =>pqp_atd_shd.g_old_rec.tax_residence_country_code
307: ,p_treaty_info_update_date_o =>pqp_atd_shd.g_old_rec.treaty_info_update_date
300: ,p_retro_lose_ben_amt_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag
301: ,p_date_benefit_ends_o =>pqp_atd_shd.g_old_rec.date_benefit_ends
302: ,p_retro_lose_ben_date_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag
303: ,p_current_residency_status_o =>pqp_atd_shd.g_old_rec.current_residency_status
304: ,p_nra_to_ra_date_o =>pqp_atd_shd.g_old_rec.nra_to_ra_date
305: ,p_target_departure_date_o =>pqp_atd_shd.g_old_rec.target_departure_date
306: ,p_tax_residence_country_code_o =>pqp_atd_shd.g_old_rec.tax_residence_country_code
307: ,p_treaty_info_update_date_o =>pqp_atd_shd.g_old_rec.treaty_info_update_date
308: ,p_nra_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.nra_exempt_from_fica
301: ,p_date_benefit_ends_o =>pqp_atd_shd.g_old_rec.date_benefit_ends
302: ,p_retro_lose_ben_date_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag
303: ,p_current_residency_status_o =>pqp_atd_shd.g_old_rec.current_residency_status
304: ,p_nra_to_ra_date_o =>pqp_atd_shd.g_old_rec.nra_to_ra_date
305: ,p_target_departure_date_o =>pqp_atd_shd.g_old_rec.target_departure_date
306: ,p_tax_residence_country_code_o =>pqp_atd_shd.g_old_rec.tax_residence_country_code
307: ,p_treaty_info_update_date_o =>pqp_atd_shd.g_old_rec.treaty_info_update_date
308: ,p_nra_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.nra_exempt_from_fica
309: ,p_student_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.student_exempt_from_fica
302: ,p_retro_lose_ben_date_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag
303: ,p_current_residency_status_o =>pqp_atd_shd.g_old_rec.current_residency_status
304: ,p_nra_to_ra_date_o =>pqp_atd_shd.g_old_rec.nra_to_ra_date
305: ,p_target_departure_date_o =>pqp_atd_shd.g_old_rec.target_departure_date
306: ,p_tax_residence_country_code_o =>pqp_atd_shd.g_old_rec.tax_residence_country_code
307: ,p_treaty_info_update_date_o =>pqp_atd_shd.g_old_rec.treaty_info_update_date
308: ,p_nra_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.nra_exempt_from_fica
309: ,p_student_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.student_exempt_from_fica
310: ,p_addl_withholding_flag_o =>pqp_atd_shd.g_old_rec.addl_withholding_flag
303: ,p_current_residency_status_o =>pqp_atd_shd.g_old_rec.current_residency_status
304: ,p_nra_to_ra_date_o =>pqp_atd_shd.g_old_rec.nra_to_ra_date
305: ,p_target_departure_date_o =>pqp_atd_shd.g_old_rec.target_departure_date
306: ,p_tax_residence_country_code_o =>pqp_atd_shd.g_old_rec.tax_residence_country_code
307: ,p_treaty_info_update_date_o =>pqp_atd_shd.g_old_rec.treaty_info_update_date
308: ,p_nra_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.nra_exempt_from_fica
309: ,p_student_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.student_exempt_from_fica
310: ,p_addl_withholding_flag_o =>pqp_atd_shd.g_old_rec.addl_withholding_flag
311: ,p_addl_withholding_amt_o =>pqp_atd_shd.g_old_rec.addl_withholding_amt
304: ,p_nra_to_ra_date_o =>pqp_atd_shd.g_old_rec.nra_to_ra_date
305: ,p_target_departure_date_o =>pqp_atd_shd.g_old_rec.target_departure_date
306: ,p_tax_residence_country_code_o =>pqp_atd_shd.g_old_rec.tax_residence_country_code
307: ,p_treaty_info_update_date_o =>pqp_atd_shd.g_old_rec.treaty_info_update_date
308: ,p_nra_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.nra_exempt_from_fica
309: ,p_student_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.student_exempt_from_fica
310: ,p_addl_withholding_flag_o =>pqp_atd_shd.g_old_rec.addl_withholding_flag
311: ,p_addl_withholding_amt_o =>pqp_atd_shd.g_old_rec.addl_withholding_amt
312: ,p_addl_wthldng_amt_period_ty_o=>pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type
305: ,p_target_departure_date_o =>pqp_atd_shd.g_old_rec.target_departure_date
306: ,p_tax_residence_country_code_o =>pqp_atd_shd.g_old_rec.tax_residence_country_code
307: ,p_treaty_info_update_date_o =>pqp_atd_shd.g_old_rec.treaty_info_update_date
308: ,p_nra_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.nra_exempt_from_fica
309: ,p_student_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.student_exempt_from_fica
310: ,p_addl_withholding_flag_o =>pqp_atd_shd.g_old_rec.addl_withholding_flag
311: ,p_addl_withholding_amt_o =>pqp_atd_shd.g_old_rec.addl_withholding_amt
312: ,p_addl_wthldng_amt_period_ty_o=>pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type
313: ,p_personal_exemption_o =>pqp_atd_shd.g_old_rec.personal_exemption
306: ,p_tax_residence_country_code_o =>pqp_atd_shd.g_old_rec.tax_residence_country_code
307: ,p_treaty_info_update_date_o =>pqp_atd_shd.g_old_rec.treaty_info_update_date
308: ,p_nra_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.nra_exempt_from_fica
309: ,p_student_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.student_exempt_from_fica
310: ,p_addl_withholding_flag_o =>pqp_atd_shd.g_old_rec.addl_withholding_flag
311: ,p_addl_withholding_amt_o =>pqp_atd_shd.g_old_rec.addl_withholding_amt
312: ,p_addl_wthldng_amt_period_ty_o=>pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type
313: ,p_personal_exemption_o =>pqp_atd_shd.g_old_rec.personal_exemption
314: ,p_addl_exemption_allowed_o =>pqp_atd_shd.g_old_rec.addl_exemption_allowed
307: ,p_treaty_info_update_date_o =>pqp_atd_shd.g_old_rec.treaty_info_update_date
308: ,p_nra_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.nra_exempt_from_fica
309: ,p_student_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.student_exempt_from_fica
310: ,p_addl_withholding_flag_o =>pqp_atd_shd.g_old_rec.addl_withholding_flag
311: ,p_addl_withholding_amt_o =>pqp_atd_shd.g_old_rec.addl_withholding_amt
312: ,p_addl_wthldng_amt_period_ty_o=>pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type
313: ,p_personal_exemption_o =>pqp_atd_shd.g_old_rec.personal_exemption
314: ,p_addl_exemption_allowed_o =>pqp_atd_shd.g_old_rec.addl_exemption_allowed
315: ,p_number_of_days_in_usa_o =>pqp_atd_shd.g_old_rec.number_of_days_in_usa
308: ,p_nra_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.nra_exempt_from_fica
309: ,p_student_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.student_exempt_from_fica
310: ,p_addl_withholding_flag_o =>pqp_atd_shd.g_old_rec.addl_withholding_flag
311: ,p_addl_withholding_amt_o =>pqp_atd_shd.g_old_rec.addl_withholding_amt
312: ,p_addl_wthldng_amt_period_ty_o=>pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type
313: ,p_personal_exemption_o =>pqp_atd_shd.g_old_rec.personal_exemption
314: ,p_addl_exemption_allowed_o =>pqp_atd_shd.g_old_rec.addl_exemption_allowed
315: ,p_number_of_days_in_usa_o =>pqp_atd_shd.g_old_rec.number_of_days_in_usa
316: ,p_wthldg_allow_eligible_flag_o =>pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag
309: ,p_student_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.student_exempt_from_fica
310: ,p_addl_withholding_flag_o =>pqp_atd_shd.g_old_rec.addl_withholding_flag
311: ,p_addl_withholding_amt_o =>pqp_atd_shd.g_old_rec.addl_withholding_amt
312: ,p_addl_wthldng_amt_period_ty_o=>pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type
313: ,p_personal_exemption_o =>pqp_atd_shd.g_old_rec.personal_exemption
314: ,p_addl_exemption_allowed_o =>pqp_atd_shd.g_old_rec.addl_exemption_allowed
315: ,p_number_of_days_in_usa_o =>pqp_atd_shd.g_old_rec.number_of_days_in_usa
316: ,p_wthldg_allow_eligible_flag_o =>pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag
317: ,p_treaty_ben_allowed_flag_o =>pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag
310: ,p_addl_withholding_flag_o =>pqp_atd_shd.g_old_rec.addl_withholding_flag
311: ,p_addl_withholding_amt_o =>pqp_atd_shd.g_old_rec.addl_withholding_amt
312: ,p_addl_wthldng_amt_period_ty_o=>pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type
313: ,p_personal_exemption_o =>pqp_atd_shd.g_old_rec.personal_exemption
314: ,p_addl_exemption_allowed_o =>pqp_atd_shd.g_old_rec.addl_exemption_allowed
315: ,p_number_of_days_in_usa_o =>pqp_atd_shd.g_old_rec.number_of_days_in_usa
316: ,p_wthldg_allow_eligible_flag_o =>pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag
317: ,p_treaty_ben_allowed_flag_o =>pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag
318: ,p_treaty_benefits_start_date_o =>pqp_atd_shd.g_old_rec.treaty_benefits_start_date
311: ,p_addl_withholding_amt_o =>pqp_atd_shd.g_old_rec.addl_withholding_amt
312: ,p_addl_wthldng_amt_period_ty_o=>pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type
313: ,p_personal_exemption_o =>pqp_atd_shd.g_old_rec.personal_exemption
314: ,p_addl_exemption_allowed_o =>pqp_atd_shd.g_old_rec.addl_exemption_allowed
315: ,p_number_of_days_in_usa_o =>pqp_atd_shd.g_old_rec.number_of_days_in_usa
316: ,p_wthldg_allow_eligible_flag_o =>pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag
317: ,p_treaty_ben_allowed_flag_o =>pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag
318: ,p_treaty_benefits_start_date_o =>pqp_atd_shd.g_old_rec.treaty_benefits_start_date
319: ,p_ra_effective_date_o =>pqp_atd_shd.g_old_rec.ra_effective_date
312: ,p_addl_wthldng_amt_period_ty_o=>pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type
313: ,p_personal_exemption_o =>pqp_atd_shd.g_old_rec.personal_exemption
314: ,p_addl_exemption_allowed_o =>pqp_atd_shd.g_old_rec.addl_exemption_allowed
315: ,p_number_of_days_in_usa_o =>pqp_atd_shd.g_old_rec.number_of_days_in_usa
316: ,p_wthldg_allow_eligible_flag_o =>pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag
317: ,p_treaty_ben_allowed_flag_o =>pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag
318: ,p_treaty_benefits_start_date_o =>pqp_atd_shd.g_old_rec.treaty_benefits_start_date
319: ,p_ra_effective_date_o =>pqp_atd_shd.g_old_rec.ra_effective_date
320: ,p_state_code_o =>pqp_atd_shd.g_old_rec.state_code
313: ,p_personal_exemption_o =>pqp_atd_shd.g_old_rec.personal_exemption
314: ,p_addl_exemption_allowed_o =>pqp_atd_shd.g_old_rec.addl_exemption_allowed
315: ,p_number_of_days_in_usa_o =>pqp_atd_shd.g_old_rec.number_of_days_in_usa
316: ,p_wthldg_allow_eligible_flag_o =>pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag
317: ,p_treaty_ben_allowed_flag_o =>pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag
318: ,p_treaty_benefits_start_date_o =>pqp_atd_shd.g_old_rec.treaty_benefits_start_date
319: ,p_ra_effective_date_o =>pqp_atd_shd.g_old_rec.ra_effective_date
320: ,p_state_code_o =>pqp_atd_shd.g_old_rec.state_code
321: ,p_state_honors_treaty_flag_o =>pqp_atd_shd.g_old_rec.state_honors_treaty_flag
314: ,p_addl_exemption_allowed_o =>pqp_atd_shd.g_old_rec.addl_exemption_allowed
315: ,p_number_of_days_in_usa_o =>pqp_atd_shd.g_old_rec.number_of_days_in_usa
316: ,p_wthldg_allow_eligible_flag_o =>pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag
317: ,p_treaty_ben_allowed_flag_o =>pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag
318: ,p_treaty_benefits_start_date_o =>pqp_atd_shd.g_old_rec.treaty_benefits_start_date
319: ,p_ra_effective_date_o =>pqp_atd_shd.g_old_rec.ra_effective_date
320: ,p_state_code_o =>pqp_atd_shd.g_old_rec.state_code
321: ,p_state_honors_treaty_flag_o =>pqp_atd_shd.g_old_rec.state_honors_treaty_flag
322: ,p_ytd_payments_o =>pqp_atd_shd.g_old_rec.ytd_payments
315: ,p_number_of_days_in_usa_o =>pqp_atd_shd.g_old_rec.number_of_days_in_usa
316: ,p_wthldg_allow_eligible_flag_o =>pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag
317: ,p_treaty_ben_allowed_flag_o =>pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag
318: ,p_treaty_benefits_start_date_o =>pqp_atd_shd.g_old_rec.treaty_benefits_start_date
319: ,p_ra_effective_date_o =>pqp_atd_shd.g_old_rec.ra_effective_date
320: ,p_state_code_o =>pqp_atd_shd.g_old_rec.state_code
321: ,p_state_honors_treaty_flag_o =>pqp_atd_shd.g_old_rec.state_honors_treaty_flag
322: ,p_ytd_payments_o =>pqp_atd_shd.g_old_rec.ytd_payments
323: ,p_ytd_w2_payments_o =>pqp_atd_shd.g_old_rec.ytd_w2_payments
316: ,p_wthldg_allow_eligible_flag_o =>pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag
317: ,p_treaty_ben_allowed_flag_o =>pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag
318: ,p_treaty_benefits_start_date_o =>pqp_atd_shd.g_old_rec.treaty_benefits_start_date
319: ,p_ra_effective_date_o =>pqp_atd_shd.g_old_rec.ra_effective_date
320: ,p_state_code_o =>pqp_atd_shd.g_old_rec.state_code
321: ,p_state_honors_treaty_flag_o =>pqp_atd_shd.g_old_rec.state_honors_treaty_flag
322: ,p_ytd_payments_o =>pqp_atd_shd.g_old_rec.ytd_payments
323: ,p_ytd_w2_payments_o =>pqp_atd_shd.g_old_rec.ytd_w2_payments
324: ,p_ytd_w2_withholding_o =>pqp_atd_shd.g_old_rec.ytd_w2_withholding
317: ,p_treaty_ben_allowed_flag_o =>pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag
318: ,p_treaty_benefits_start_date_o =>pqp_atd_shd.g_old_rec.treaty_benefits_start_date
319: ,p_ra_effective_date_o =>pqp_atd_shd.g_old_rec.ra_effective_date
320: ,p_state_code_o =>pqp_atd_shd.g_old_rec.state_code
321: ,p_state_honors_treaty_flag_o =>pqp_atd_shd.g_old_rec.state_honors_treaty_flag
322: ,p_ytd_payments_o =>pqp_atd_shd.g_old_rec.ytd_payments
323: ,p_ytd_w2_payments_o =>pqp_atd_shd.g_old_rec.ytd_w2_payments
324: ,p_ytd_w2_withholding_o =>pqp_atd_shd.g_old_rec.ytd_w2_withholding
325: ,p_ytd_withholding_allowance_o =>pqp_atd_shd.g_old_rec.ytd_withholding_allowance
318: ,p_treaty_benefits_start_date_o =>pqp_atd_shd.g_old_rec.treaty_benefits_start_date
319: ,p_ra_effective_date_o =>pqp_atd_shd.g_old_rec.ra_effective_date
320: ,p_state_code_o =>pqp_atd_shd.g_old_rec.state_code
321: ,p_state_honors_treaty_flag_o =>pqp_atd_shd.g_old_rec.state_honors_treaty_flag
322: ,p_ytd_payments_o =>pqp_atd_shd.g_old_rec.ytd_payments
323: ,p_ytd_w2_payments_o =>pqp_atd_shd.g_old_rec.ytd_w2_payments
324: ,p_ytd_w2_withholding_o =>pqp_atd_shd.g_old_rec.ytd_w2_withholding
325: ,p_ytd_withholding_allowance_o =>pqp_atd_shd.g_old_rec.ytd_withholding_allowance
326: ,p_ytd_treaty_payments_o =>pqp_atd_shd.g_old_rec.ytd_treaty_payments
319: ,p_ra_effective_date_o =>pqp_atd_shd.g_old_rec.ra_effective_date
320: ,p_state_code_o =>pqp_atd_shd.g_old_rec.state_code
321: ,p_state_honors_treaty_flag_o =>pqp_atd_shd.g_old_rec.state_honors_treaty_flag
322: ,p_ytd_payments_o =>pqp_atd_shd.g_old_rec.ytd_payments
323: ,p_ytd_w2_payments_o =>pqp_atd_shd.g_old_rec.ytd_w2_payments
324: ,p_ytd_w2_withholding_o =>pqp_atd_shd.g_old_rec.ytd_w2_withholding
325: ,p_ytd_withholding_allowance_o =>pqp_atd_shd.g_old_rec.ytd_withholding_allowance
326: ,p_ytd_treaty_payments_o =>pqp_atd_shd.g_old_rec.ytd_treaty_payments
327: ,p_ytd_treaty_withheld_amt_o =>pqp_atd_shd.g_old_rec.ytd_treaty_withheld_amt
320: ,p_state_code_o =>pqp_atd_shd.g_old_rec.state_code
321: ,p_state_honors_treaty_flag_o =>pqp_atd_shd.g_old_rec.state_honors_treaty_flag
322: ,p_ytd_payments_o =>pqp_atd_shd.g_old_rec.ytd_payments
323: ,p_ytd_w2_payments_o =>pqp_atd_shd.g_old_rec.ytd_w2_payments
324: ,p_ytd_w2_withholding_o =>pqp_atd_shd.g_old_rec.ytd_w2_withholding
325: ,p_ytd_withholding_allowance_o =>pqp_atd_shd.g_old_rec.ytd_withholding_allowance
326: ,p_ytd_treaty_payments_o =>pqp_atd_shd.g_old_rec.ytd_treaty_payments
327: ,p_ytd_treaty_withheld_amt_o =>pqp_atd_shd.g_old_rec.ytd_treaty_withheld_amt
328: ,p_record_source_o =>pqp_atd_shd.g_old_rec.record_source
321: ,p_state_honors_treaty_flag_o =>pqp_atd_shd.g_old_rec.state_honors_treaty_flag
322: ,p_ytd_payments_o =>pqp_atd_shd.g_old_rec.ytd_payments
323: ,p_ytd_w2_payments_o =>pqp_atd_shd.g_old_rec.ytd_w2_payments
324: ,p_ytd_w2_withholding_o =>pqp_atd_shd.g_old_rec.ytd_w2_withholding
325: ,p_ytd_withholding_allowance_o =>pqp_atd_shd.g_old_rec.ytd_withholding_allowance
326: ,p_ytd_treaty_payments_o =>pqp_atd_shd.g_old_rec.ytd_treaty_payments
327: ,p_ytd_treaty_withheld_amt_o =>pqp_atd_shd.g_old_rec.ytd_treaty_withheld_amt
328: ,p_record_source_o =>pqp_atd_shd.g_old_rec.record_source
329: ,p_visa_type_o =>pqp_atd_shd.g_old_rec.visa_type
322: ,p_ytd_payments_o =>pqp_atd_shd.g_old_rec.ytd_payments
323: ,p_ytd_w2_payments_o =>pqp_atd_shd.g_old_rec.ytd_w2_payments
324: ,p_ytd_w2_withholding_o =>pqp_atd_shd.g_old_rec.ytd_w2_withholding
325: ,p_ytd_withholding_allowance_o =>pqp_atd_shd.g_old_rec.ytd_withholding_allowance
326: ,p_ytd_treaty_payments_o =>pqp_atd_shd.g_old_rec.ytd_treaty_payments
327: ,p_ytd_treaty_withheld_amt_o =>pqp_atd_shd.g_old_rec.ytd_treaty_withheld_amt
328: ,p_record_source_o =>pqp_atd_shd.g_old_rec.record_source
329: ,p_visa_type_o =>pqp_atd_shd.g_old_rec.visa_type
330: ,p_j_sub_type_o =>pqp_atd_shd.g_old_rec.j_sub_type
323: ,p_ytd_w2_payments_o =>pqp_atd_shd.g_old_rec.ytd_w2_payments
324: ,p_ytd_w2_withholding_o =>pqp_atd_shd.g_old_rec.ytd_w2_withholding
325: ,p_ytd_withholding_allowance_o =>pqp_atd_shd.g_old_rec.ytd_withholding_allowance
326: ,p_ytd_treaty_payments_o =>pqp_atd_shd.g_old_rec.ytd_treaty_payments
327: ,p_ytd_treaty_withheld_amt_o =>pqp_atd_shd.g_old_rec.ytd_treaty_withheld_amt
328: ,p_record_source_o =>pqp_atd_shd.g_old_rec.record_source
329: ,p_visa_type_o =>pqp_atd_shd.g_old_rec.visa_type
330: ,p_j_sub_type_o =>pqp_atd_shd.g_old_rec.j_sub_type
331: ,p_primary_activity_o =>pqp_atd_shd.g_old_rec.primary_activity
324: ,p_ytd_w2_withholding_o =>pqp_atd_shd.g_old_rec.ytd_w2_withholding
325: ,p_ytd_withholding_allowance_o =>pqp_atd_shd.g_old_rec.ytd_withholding_allowance
326: ,p_ytd_treaty_payments_o =>pqp_atd_shd.g_old_rec.ytd_treaty_payments
327: ,p_ytd_treaty_withheld_amt_o =>pqp_atd_shd.g_old_rec.ytd_treaty_withheld_amt
328: ,p_record_source_o =>pqp_atd_shd.g_old_rec.record_source
329: ,p_visa_type_o =>pqp_atd_shd.g_old_rec.visa_type
330: ,p_j_sub_type_o =>pqp_atd_shd.g_old_rec.j_sub_type
331: ,p_primary_activity_o =>pqp_atd_shd.g_old_rec.primary_activity
332: ,p_non_us_country_code_o =>pqp_atd_shd.g_old_rec.non_us_country_code
325: ,p_ytd_withholding_allowance_o =>pqp_atd_shd.g_old_rec.ytd_withholding_allowance
326: ,p_ytd_treaty_payments_o =>pqp_atd_shd.g_old_rec.ytd_treaty_payments
327: ,p_ytd_treaty_withheld_amt_o =>pqp_atd_shd.g_old_rec.ytd_treaty_withheld_amt
328: ,p_record_source_o =>pqp_atd_shd.g_old_rec.record_source
329: ,p_visa_type_o =>pqp_atd_shd.g_old_rec.visa_type
330: ,p_j_sub_type_o =>pqp_atd_shd.g_old_rec.j_sub_type
331: ,p_primary_activity_o =>pqp_atd_shd.g_old_rec.primary_activity
332: ,p_non_us_country_code_o =>pqp_atd_shd.g_old_rec.non_us_country_code
333: ,p_citizenship_country_code_o =>pqp_atd_shd.g_old_rec.citizenship_country_code
326: ,p_ytd_treaty_payments_o =>pqp_atd_shd.g_old_rec.ytd_treaty_payments
327: ,p_ytd_treaty_withheld_amt_o =>pqp_atd_shd.g_old_rec.ytd_treaty_withheld_amt
328: ,p_record_source_o =>pqp_atd_shd.g_old_rec.record_source
329: ,p_visa_type_o =>pqp_atd_shd.g_old_rec.visa_type
330: ,p_j_sub_type_o =>pqp_atd_shd.g_old_rec.j_sub_type
331: ,p_primary_activity_o =>pqp_atd_shd.g_old_rec.primary_activity
332: ,p_non_us_country_code_o =>pqp_atd_shd.g_old_rec.non_us_country_code
333: ,p_citizenship_country_code_o =>pqp_atd_shd.g_old_rec.citizenship_country_code
334: ,p_constant_addl_tax_o =>pqp_atd_shd.g_old_rec.constant_addl_tax
327: ,p_ytd_treaty_withheld_amt_o =>pqp_atd_shd.g_old_rec.ytd_treaty_withheld_amt
328: ,p_record_source_o =>pqp_atd_shd.g_old_rec.record_source
329: ,p_visa_type_o =>pqp_atd_shd.g_old_rec.visa_type
330: ,p_j_sub_type_o =>pqp_atd_shd.g_old_rec.j_sub_type
331: ,p_primary_activity_o =>pqp_atd_shd.g_old_rec.primary_activity
332: ,p_non_us_country_code_o =>pqp_atd_shd.g_old_rec.non_us_country_code
333: ,p_citizenship_country_code_o =>pqp_atd_shd.g_old_rec.citizenship_country_code
334: ,p_constant_addl_tax_o =>pqp_atd_shd.g_old_rec.constant_addl_tax
335: ,p_date_8233_signed_o =>pqp_atd_shd.g_old_rec.date_8233_signed
328: ,p_record_source_o =>pqp_atd_shd.g_old_rec.record_source
329: ,p_visa_type_o =>pqp_atd_shd.g_old_rec.visa_type
330: ,p_j_sub_type_o =>pqp_atd_shd.g_old_rec.j_sub_type
331: ,p_primary_activity_o =>pqp_atd_shd.g_old_rec.primary_activity
332: ,p_non_us_country_code_o =>pqp_atd_shd.g_old_rec.non_us_country_code
333: ,p_citizenship_country_code_o =>pqp_atd_shd.g_old_rec.citizenship_country_code
334: ,p_constant_addl_tax_o =>pqp_atd_shd.g_old_rec.constant_addl_tax
335: ,p_date_8233_signed_o =>pqp_atd_shd.g_old_rec.date_8233_signed
336: ,p_date_w4_signed_o =>pqp_atd_shd.g_old_rec.date_w4_signed
329: ,p_visa_type_o =>pqp_atd_shd.g_old_rec.visa_type
330: ,p_j_sub_type_o =>pqp_atd_shd.g_old_rec.j_sub_type
331: ,p_primary_activity_o =>pqp_atd_shd.g_old_rec.primary_activity
332: ,p_non_us_country_code_o =>pqp_atd_shd.g_old_rec.non_us_country_code
333: ,p_citizenship_country_code_o =>pqp_atd_shd.g_old_rec.citizenship_country_code
334: ,p_constant_addl_tax_o =>pqp_atd_shd.g_old_rec.constant_addl_tax
335: ,p_date_8233_signed_o =>pqp_atd_shd.g_old_rec.date_8233_signed
336: ,p_date_w4_signed_o =>pqp_atd_shd.g_old_rec.date_w4_signed
337: ,p_error_indicator_o =>pqp_atd_shd.g_old_rec.error_indicator
330: ,p_j_sub_type_o =>pqp_atd_shd.g_old_rec.j_sub_type
331: ,p_primary_activity_o =>pqp_atd_shd.g_old_rec.primary_activity
332: ,p_non_us_country_code_o =>pqp_atd_shd.g_old_rec.non_us_country_code
333: ,p_citizenship_country_code_o =>pqp_atd_shd.g_old_rec.citizenship_country_code
334: ,p_constant_addl_tax_o =>pqp_atd_shd.g_old_rec.constant_addl_tax
335: ,p_date_8233_signed_o =>pqp_atd_shd.g_old_rec.date_8233_signed
336: ,p_date_w4_signed_o =>pqp_atd_shd.g_old_rec.date_w4_signed
337: ,p_error_indicator_o =>pqp_atd_shd.g_old_rec.error_indicator
338: ,p_prev_er_treaty_benefit_amt_o =>pqp_atd_shd.g_old_rec.prev_er_treaty_benefit_amt
331: ,p_primary_activity_o =>pqp_atd_shd.g_old_rec.primary_activity
332: ,p_non_us_country_code_o =>pqp_atd_shd.g_old_rec.non_us_country_code
333: ,p_citizenship_country_code_o =>pqp_atd_shd.g_old_rec.citizenship_country_code
334: ,p_constant_addl_tax_o =>pqp_atd_shd.g_old_rec.constant_addl_tax
335: ,p_date_8233_signed_o =>pqp_atd_shd.g_old_rec.date_8233_signed
336: ,p_date_w4_signed_o =>pqp_atd_shd.g_old_rec.date_w4_signed
337: ,p_error_indicator_o =>pqp_atd_shd.g_old_rec.error_indicator
338: ,p_prev_er_treaty_benefit_amt_o =>pqp_atd_shd.g_old_rec.prev_er_treaty_benefit_amt
339: ,p_error_text_o =>pqp_atd_shd.g_old_rec.error_text
332: ,p_non_us_country_code_o =>pqp_atd_shd.g_old_rec.non_us_country_code
333: ,p_citizenship_country_code_o =>pqp_atd_shd.g_old_rec.citizenship_country_code
334: ,p_constant_addl_tax_o =>pqp_atd_shd.g_old_rec.constant_addl_tax
335: ,p_date_8233_signed_o =>pqp_atd_shd.g_old_rec.date_8233_signed
336: ,p_date_w4_signed_o =>pqp_atd_shd.g_old_rec.date_w4_signed
337: ,p_error_indicator_o =>pqp_atd_shd.g_old_rec.error_indicator
338: ,p_prev_er_treaty_benefit_amt_o =>pqp_atd_shd.g_old_rec.prev_er_treaty_benefit_amt
339: ,p_error_text_o =>pqp_atd_shd.g_old_rec.error_text
340: ,p_object_version_number_o =>pqp_atd_shd.g_old_rec.object_version_number
333: ,p_citizenship_country_code_o =>pqp_atd_shd.g_old_rec.citizenship_country_code
334: ,p_constant_addl_tax_o =>pqp_atd_shd.g_old_rec.constant_addl_tax
335: ,p_date_8233_signed_o =>pqp_atd_shd.g_old_rec.date_8233_signed
336: ,p_date_w4_signed_o =>pqp_atd_shd.g_old_rec.date_w4_signed
337: ,p_error_indicator_o =>pqp_atd_shd.g_old_rec.error_indicator
338: ,p_prev_er_treaty_benefit_amt_o =>pqp_atd_shd.g_old_rec.prev_er_treaty_benefit_amt
339: ,p_error_text_o =>pqp_atd_shd.g_old_rec.error_text
340: ,p_object_version_number_o =>pqp_atd_shd.g_old_rec.object_version_number
341: ,p_current_analysis_o =>pqp_atd_shd.g_old_rec.current_analysis
334: ,p_constant_addl_tax_o =>pqp_atd_shd.g_old_rec.constant_addl_tax
335: ,p_date_8233_signed_o =>pqp_atd_shd.g_old_rec.date_8233_signed
336: ,p_date_w4_signed_o =>pqp_atd_shd.g_old_rec.date_w4_signed
337: ,p_error_indicator_o =>pqp_atd_shd.g_old_rec.error_indicator
338: ,p_prev_er_treaty_benefit_amt_o =>pqp_atd_shd.g_old_rec.prev_er_treaty_benefit_amt
339: ,p_error_text_o =>pqp_atd_shd.g_old_rec.error_text
340: ,p_object_version_number_o =>pqp_atd_shd.g_old_rec.object_version_number
341: ,p_current_analysis_o =>pqp_atd_shd.g_old_rec.current_analysis
342: ,p_forecast_income_code_o =>pqp_atd_shd.g_old_rec.forecast_income_code
335: ,p_date_8233_signed_o =>pqp_atd_shd.g_old_rec.date_8233_signed
336: ,p_date_w4_signed_o =>pqp_atd_shd.g_old_rec.date_w4_signed
337: ,p_error_indicator_o =>pqp_atd_shd.g_old_rec.error_indicator
338: ,p_prev_er_treaty_benefit_amt_o =>pqp_atd_shd.g_old_rec.prev_er_treaty_benefit_amt
339: ,p_error_text_o =>pqp_atd_shd.g_old_rec.error_text
340: ,p_object_version_number_o =>pqp_atd_shd.g_old_rec.object_version_number
341: ,p_current_analysis_o =>pqp_atd_shd.g_old_rec.current_analysis
342: ,p_forecast_income_code_o =>pqp_atd_shd.g_old_rec.forecast_income_code
343: );
336: ,p_date_w4_signed_o =>pqp_atd_shd.g_old_rec.date_w4_signed
337: ,p_error_indicator_o =>pqp_atd_shd.g_old_rec.error_indicator
338: ,p_prev_er_treaty_benefit_amt_o =>pqp_atd_shd.g_old_rec.prev_er_treaty_benefit_amt
339: ,p_error_text_o =>pqp_atd_shd.g_old_rec.error_text
340: ,p_object_version_number_o =>pqp_atd_shd.g_old_rec.object_version_number
341: ,p_current_analysis_o =>pqp_atd_shd.g_old_rec.current_analysis
342: ,p_forecast_income_code_o =>pqp_atd_shd.g_old_rec.forecast_income_code
343: );
344: --
337: ,p_error_indicator_o =>pqp_atd_shd.g_old_rec.error_indicator
338: ,p_prev_er_treaty_benefit_amt_o =>pqp_atd_shd.g_old_rec.prev_er_treaty_benefit_amt
339: ,p_error_text_o =>pqp_atd_shd.g_old_rec.error_text
340: ,p_object_version_number_o =>pqp_atd_shd.g_old_rec.object_version_number
341: ,p_current_analysis_o =>pqp_atd_shd.g_old_rec.current_analysis
342: ,p_forecast_income_code_o =>pqp_atd_shd.g_old_rec.forecast_income_code
343: );
344: --
345: exception
338: ,p_prev_er_treaty_benefit_amt_o =>pqp_atd_shd.g_old_rec.prev_er_treaty_benefit_amt
339: ,p_error_text_o =>pqp_atd_shd.g_old_rec.error_text
340: ,p_object_version_number_o =>pqp_atd_shd.g_old_rec.object_version_number
341: ,p_current_analysis_o =>pqp_atd_shd.g_old_rec.current_analysis
342: ,p_forecast_income_code_o =>pqp_atd_shd.g_old_rec.forecast_income_code
343: );
344: --
345: exception
346: --
400: -- Internal Row Handler Use Only.
401: --
402: -- {End Of Comments}
403: ----------------------------------------------------------------------------
404: Procedure convert_defs(p_rec in out nocopy pqp_atd_shd.g_rec_type) is
405:
406: l_proc varchar2(72) := g_package||'convert_defs';
407:
408: Begin
415: -- is being used then we must set to the 'current' argument value.
416: --
417: If (p_rec.person_id = hr_api.g_number) then
418: p_rec.person_id :=
419: pqp_atd_shd.g_old_rec.person_id;
420: End If;
421: If (p_rec.data_source_type = hr_api.g_varchar2) then
422: p_rec.data_source_type :=
423: pqp_atd_shd.g_old_rec.data_source_type;
419: pqp_atd_shd.g_old_rec.person_id;
420: End If;
421: If (p_rec.data_source_type = hr_api.g_varchar2) then
422: p_rec.data_source_type :=
423: pqp_atd_shd.g_old_rec.data_source_type;
424: End If;
425: If (p_rec.tax_year = hr_api.g_number) then
426: p_rec.tax_year :=
427: pqp_atd_shd.g_old_rec.tax_year;
423: pqp_atd_shd.g_old_rec.data_source_type;
424: End If;
425: If (p_rec.tax_year = hr_api.g_number) then
426: p_rec.tax_year :=
427: pqp_atd_shd.g_old_rec.tax_year;
428: End If;
429: If (p_rec.income_code = hr_api.g_varchar2) then
430: p_rec.income_code :=
431: pqp_atd_shd.g_old_rec.income_code;
427: pqp_atd_shd.g_old_rec.tax_year;
428: End If;
429: If (p_rec.income_code = hr_api.g_varchar2) then
430: p_rec.income_code :=
431: pqp_atd_shd.g_old_rec.income_code;
432: End If;
433: If (p_rec.withholding_rate = hr_api.g_number) then
434: p_rec.withholding_rate :=
435: pqp_atd_shd.g_old_rec.withholding_rate;
431: pqp_atd_shd.g_old_rec.income_code;
432: End If;
433: If (p_rec.withholding_rate = hr_api.g_number) then
434: p_rec.withholding_rate :=
435: pqp_atd_shd.g_old_rec.withholding_rate;
436: End If;
437: If (p_rec.income_code_sub_type = hr_api.g_varchar2) then
438: p_rec.income_code_sub_type :=
439: pqp_atd_shd.g_old_rec.income_code_sub_type;
435: pqp_atd_shd.g_old_rec.withholding_rate;
436: End If;
437: If (p_rec.income_code_sub_type = hr_api.g_varchar2) then
438: p_rec.income_code_sub_type :=
439: pqp_atd_shd.g_old_rec.income_code_sub_type;
440: End If;
441: If (p_rec.exemption_code = hr_api.g_varchar2) then
442: p_rec.exemption_code :=
443: pqp_atd_shd.g_old_rec.exemption_code;
439: pqp_atd_shd.g_old_rec.income_code_sub_type;
440: End If;
441: If (p_rec.exemption_code = hr_api.g_varchar2) then
442: p_rec.exemption_code :=
443: pqp_atd_shd.g_old_rec.exemption_code;
444: End If;
445: If (p_rec.maximum_benefit_amount = hr_api.g_number) then
446: p_rec.maximum_benefit_amount :=
447: pqp_atd_shd.g_old_rec.maximum_benefit_amount;
443: pqp_atd_shd.g_old_rec.exemption_code;
444: End If;
445: If (p_rec.maximum_benefit_amount = hr_api.g_number) then
446: p_rec.maximum_benefit_amount :=
447: pqp_atd_shd.g_old_rec.maximum_benefit_amount;
448: End If;
449: If (p_rec.retro_lose_ben_amt_flag = hr_api.g_varchar2) then
450: p_rec.retro_lose_ben_amt_flag :=
451: pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag;
447: pqp_atd_shd.g_old_rec.maximum_benefit_amount;
448: End If;
449: If (p_rec.retro_lose_ben_amt_flag = hr_api.g_varchar2) then
450: p_rec.retro_lose_ben_amt_flag :=
451: pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag;
452: End If;
453: If (p_rec.date_benefit_ends = hr_api.g_date) then
454: p_rec.date_benefit_ends :=
455: pqp_atd_shd.g_old_rec.date_benefit_ends;
451: pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag;
452: End If;
453: If (p_rec.date_benefit_ends = hr_api.g_date) then
454: p_rec.date_benefit_ends :=
455: pqp_atd_shd.g_old_rec.date_benefit_ends;
456: End If;
457: If (p_rec.retro_lose_ben_date_flag = hr_api.g_varchar2) then
458: p_rec.retro_lose_ben_date_flag :=
459: pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag;
455: pqp_atd_shd.g_old_rec.date_benefit_ends;
456: End If;
457: If (p_rec.retro_lose_ben_date_flag = hr_api.g_varchar2) then
458: p_rec.retro_lose_ben_date_flag :=
459: pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag;
460: End If;
461: If (p_rec.current_residency_status = hr_api.g_varchar2) then
462: p_rec.current_residency_status :=
463: pqp_atd_shd.g_old_rec.current_residency_status;
459: pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag;
460: End If;
461: If (p_rec.current_residency_status = hr_api.g_varchar2) then
462: p_rec.current_residency_status :=
463: pqp_atd_shd.g_old_rec.current_residency_status;
464: End If;
465: If (p_rec.nra_to_ra_date = hr_api.g_date) then
466: p_rec.nra_to_ra_date :=
467: pqp_atd_shd.g_old_rec.nra_to_ra_date;
463: pqp_atd_shd.g_old_rec.current_residency_status;
464: End If;
465: If (p_rec.nra_to_ra_date = hr_api.g_date) then
466: p_rec.nra_to_ra_date :=
467: pqp_atd_shd.g_old_rec.nra_to_ra_date;
468: End If;
469: If (p_rec.target_departure_date = hr_api.g_date) then
470: p_rec.target_departure_date :=
471: pqp_atd_shd.g_old_rec.target_departure_date;
467: pqp_atd_shd.g_old_rec.nra_to_ra_date;
468: End If;
469: If (p_rec.target_departure_date = hr_api.g_date) then
470: p_rec.target_departure_date :=
471: pqp_atd_shd.g_old_rec.target_departure_date;
472: End If;
473: If (p_rec.tax_residence_country_code = hr_api.g_varchar2) then
474: p_rec.tax_residence_country_code :=
475: pqp_atd_shd.g_old_rec.tax_residence_country_code;
471: pqp_atd_shd.g_old_rec.target_departure_date;
472: End If;
473: If (p_rec.tax_residence_country_code = hr_api.g_varchar2) then
474: p_rec.tax_residence_country_code :=
475: pqp_atd_shd.g_old_rec.tax_residence_country_code;
476: End If;
477: If (p_rec.treaty_info_update_date = hr_api.g_date) then
478: p_rec.treaty_info_update_date :=
479: pqp_atd_shd.g_old_rec.treaty_info_update_date;
475: pqp_atd_shd.g_old_rec.tax_residence_country_code;
476: End If;
477: If (p_rec.treaty_info_update_date = hr_api.g_date) then
478: p_rec.treaty_info_update_date :=
479: pqp_atd_shd.g_old_rec.treaty_info_update_date;
480: End If;
481: If (p_rec.nra_exempt_from_fica = hr_api.g_varchar2) then
482: p_rec.nra_exempt_from_fica :=
483: pqp_atd_shd.g_old_rec.nra_exempt_from_fica;
479: pqp_atd_shd.g_old_rec.treaty_info_update_date;
480: End If;
481: If (p_rec.nra_exempt_from_fica = hr_api.g_varchar2) then
482: p_rec.nra_exempt_from_fica :=
483: pqp_atd_shd.g_old_rec.nra_exempt_from_fica;
484: End If;
485: If (p_rec.student_exempt_from_fica = hr_api.g_varchar2) then
486: p_rec.student_exempt_from_fica :=
487: pqp_atd_shd.g_old_rec.student_exempt_from_fica;
483: pqp_atd_shd.g_old_rec.nra_exempt_from_fica;
484: End If;
485: If (p_rec.student_exempt_from_fica = hr_api.g_varchar2) then
486: p_rec.student_exempt_from_fica :=
487: pqp_atd_shd.g_old_rec.student_exempt_from_fica;
488: End If;
489: If (p_rec.addl_withholding_flag = hr_api.g_varchar2) then
490: p_rec.addl_withholding_flag :=
491: pqp_atd_shd.g_old_rec.addl_withholding_flag;
487: pqp_atd_shd.g_old_rec.student_exempt_from_fica;
488: End If;
489: If (p_rec.addl_withholding_flag = hr_api.g_varchar2) then
490: p_rec.addl_withholding_flag :=
491: pqp_atd_shd.g_old_rec.addl_withholding_flag;
492: End If;
493: If (p_rec.addl_withholding_amt = hr_api.g_number) then
494: p_rec.addl_withholding_amt :=
495: pqp_atd_shd.g_old_rec.addl_withholding_amt;
491: pqp_atd_shd.g_old_rec.addl_withholding_flag;
492: End If;
493: If (p_rec.addl_withholding_amt = hr_api.g_number) then
494: p_rec.addl_withholding_amt :=
495: pqp_atd_shd.g_old_rec.addl_withholding_amt;
496: End If;
497: If (p_rec.addl_wthldng_amt_period_type = hr_api.g_varchar2) then
498: p_rec.addl_wthldng_amt_period_type :=
499: pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type;
495: pqp_atd_shd.g_old_rec.addl_withholding_amt;
496: End If;
497: If (p_rec.addl_wthldng_amt_period_type = hr_api.g_varchar2) then
498: p_rec.addl_wthldng_amt_period_type :=
499: pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type;
500: End If;
501: If (p_rec.personal_exemption = hr_api.g_number) then
502: p_rec.personal_exemption :=
503: pqp_atd_shd.g_old_rec.personal_exemption;
499: pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type;
500: End If;
501: If (p_rec.personal_exemption = hr_api.g_number) then
502: p_rec.personal_exemption :=
503: pqp_atd_shd.g_old_rec.personal_exemption;
504: End If;
505: If (p_rec.addl_exemption_allowed = hr_api.g_number) then
506: p_rec.addl_exemption_allowed :=
507: pqp_atd_shd.g_old_rec.addl_exemption_allowed;
503: pqp_atd_shd.g_old_rec.personal_exemption;
504: End If;
505: If (p_rec.addl_exemption_allowed = hr_api.g_number) then
506: p_rec.addl_exemption_allowed :=
507: pqp_atd_shd.g_old_rec.addl_exemption_allowed;
508: End If;
509: If (p_rec.number_of_days_in_usa = hr_api.g_number) then
510: p_rec.number_of_days_in_usa :=
511: pqp_atd_shd.g_old_rec.number_of_days_in_usa;
507: pqp_atd_shd.g_old_rec.addl_exemption_allowed;
508: End If;
509: If (p_rec.number_of_days_in_usa = hr_api.g_number) then
510: p_rec.number_of_days_in_usa :=
511: pqp_atd_shd.g_old_rec.number_of_days_in_usa;
512: End If;
513: If (p_rec.wthldg_allow_eligible_flag = hr_api.g_varchar2) then
514: p_rec.wthldg_allow_eligible_flag :=
515: pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag;
511: pqp_atd_shd.g_old_rec.number_of_days_in_usa;
512: End If;
513: If (p_rec.wthldg_allow_eligible_flag = hr_api.g_varchar2) then
514: p_rec.wthldg_allow_eligible_flag :=
515: pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag;
516: End If;
517: If (p_rec.treaty_ben_allowed_flag = hr_api.g_varchar2) then
518: p_rec.treaty_ben_allowed_flag :=
519: pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag;
515: pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag;
516: End If;
517: If (p_rec.treaty_ben_allowed_flag = hr_api.g_varchar2) then
518: p_rec.treaty_ben_allowed_flag :=
519: pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag;
520: End If;
521: If (p_rec.treaty_benefits_start_date = hr_api.g_date) then
522: p_rec.treaty_benefits_start_date :=
523: pqp_atd_shd.g_old_rec.treaty_benefits_start_date;
519: pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag;
520: End If;
521: If (p_rec.treaty_benefits_start_date = hr_api.g_date) then
522: p_rec.treaty_benefits_start_date :=
523: pqp_atd_shd.g_old_rec.treaty_benefits_start_date;
524: End If;
525: If (p_rec.ra_effective_date = hr_api.g_date) then
526: p_rec.ra_effective_date :=
527: pqp_atd_shd.g_old_rec.ra_effective_date;
523: pqp_atd_shd.g_old_rec.treaty_benefits_start_date;
524: End If;
525: If (p_rec.ra_effective_date = hr_api.g_date) then
526: p_rec.ra_effective_date :=
527: pqp_atd_shd.g_old_rec.ra_effective_date;
528: End If;
529: If (p_rec.state_code = hr_api.g_varchar2) then
530: p_rec.state_code :=
531: pqp_atd_shd.g_old_rec.state_code;
527: pqp_atd_shd.g_old_rec.ra_effective_date;
528: End If;
529: If (p_rec.state_code = hr_api.g_varchar2) then
530: p_rec.state_code :=
531: pqp_atd_shd.g_old_rec.state_code;
532: End If;
533: If (p_rec.state_honors_treaty_flag = hr_api.g_varchar2) then
534: p_rec.state_honors_treaty_flag :=
535: pqp_atd_shd.g_old_rec.state_honors_treaty_flag;
531: pqp_atd_shd.g_old_rec.state_code;
532: End If;
533: If (p_rec.state_honors_treaty_flag = hr_api.g_varchar2) then
534: p_rec.state_honors_treaty_flag :=
535: pqp_atd_shd.g_old_rec.state_honors_treaty_flag;
536: End If;
537: If (p_rec.ytd_payments = hr_api.g_number) then
538: p_rec.ytd_payments :=
539: pqp_atd_shd.g_old_rec.ytd_payments;
535: pqp_atd_shd.g_old_rec.state_honors_treaty_flag;
536: End If;
537: If (p_rec.ytd_payments = hr_api.g_number) then
538: p_rec.ytd_payments :=
539: pqp_atd_shd.g_old_rec.ytd_payments;
540: End If;
541: If (p_rec.ytd_w2_payments = hr_api.g_number) then
542: p_rec.ytd_w2_payments :=
543: pqp_atd_shd.g_old_rec.ytd_w2_payments;
539: pqp_atd_shd.g_old_rec.ytd_payments;
540: End If;
541: If (p_rec.ytd_w2_payments = hr_api.g_number) then
542: p_rec.ytd_w2_payments :=
543: pqp_atd_shd.g_old_rec.ytd_w2_payments;
544: End If;
545: If (p_rec.ytd_w2_withholding = hr_api.g_number) then
546: p_rec.ytd_w2_withholding :=
547: pqp_atd_shd.g_old_rec.ytd_w2_withholding;
543: pqp_atd_shd.g_old_rec.ytd_w2_payments;
544: End If;
545: If (p_rec.ytd_w2_withholding = hr_api.g_number) then
546: p_rec.ytd_w2_withholding :=
547: pqp_atd_shd.g_old_rec.ytd_w2_withholding;
548: End If;
549: If (p_rec.ytd_withholding_allowance = hr_api.g_number) then
550: p_rec.ytd_withholding_allowance :=
551: pqp_atd_shd.g_old_rec.ytd_withholding_allowance;
547: pqp_atd_shd.g_old_rec.ytd_w2_withholding;
548: End If;
549: If (p_rec.ytd_withholding_allowance = hr_api.g_number) then
550: p_rec.ytd_withholding_allowance :=
551: pqp_atd_shd.g_old_rec.ytd_withholding_allowance;
552: End If;
553: If (p_rec.ytd_treaty_payments = hr_api.g_number) then
554: p_rec.ytd_treaty_payments :=
555: pqp_atd_shd.g_old_rec.ytd_treaty_payments;
551: pqp_atd_shd.g_old_rec.ytd_withholding_allowance;
552: End If;
553: If (p_rec.ytd_treaty_payments = hr_api.g_number) then
554: p_rec.ytd_treaty_payments :=
555: pqp_atd_shd.g_old_rec.ytd_treaty_payments;
556: End If;
557: If (p_rec.ytd_treaty_withheld_amt = hr_api.g_number) then
558: p_rec.ytd_treaty_withheld_amt :=
559: pqp_atd_shd.g_old_rec.ytd_treaty_withheld_amt;
555: pqp_atd_shd.g_old_rec.ytd_treaty_payments;
556: End If;
557: If (p_rec.ytd_treaty_withheld_amt = hr_api.g_number) then
558: p_rec.ytd_treaty_withheld_amt :=
559: pqp_atd_shd.g_old_rec.ytd_treaty_withheld_amt;
560: End If;
561: If (p_rec.record_source = hr_api.g_varchar2) then
562: p_rec.record_source :=
563: pqp_atd_shd.g_old_rec.record_source;
559: pqp_atd_shd.g_old_rec.ytd_treaty_withheld_amt;
560: End If;
561: If (p_rec.record_source = hr_api.g_varchar2) then
562: p_rec.record_source :=
563: pqp_atd_shd.g_old_rec.record_source;
564: End If;
565: If (p_rec.visa_type = hr_api.g_varchar2) then
566: p_rec.visa_type :=
567: pqp_atd_shd.g_old_rec.visa_type;
563: pqp_atd_shd.g_old_rec.record_source;
564: End If;
565: If (p_rec.visa_type = hr_api.g_varchar2) then
566: p_rec.visa_type :=
567: pqp_atd_shd.g_old_rec.visa_type;
568: End If;
569: If (p_rec.j_sub_type = hr_api.g_varchar2) then
570: p_rec.j_sub_type :=
571: pqp_atd_shd.g_old_rec.j_sub_type;
567: pqp_atd_shd.g_old_rec.visa_type;
568: End If;
569: If (p_rec.j_sub_type = hr_api.g_varchar2) then
570: p_rec.j_sub_type :=
571: pqp_atd_shd.g_old_rec.j_sub_type;
572: End If;
573: If (p_rec.primary_activity = hr_api.g_varchar2) then
574: p_rec.primary_activity :=
575: pqp_atd_shd.g_old_rec.primary_activity;
571: pqp_atd_shd.g_old_rec.j_sub_type;
572: End If;
573: If (p_rec.primary_activity = hr_api.g_varchar2) then
574: p_rec.primary_activity :=
575: pqp_atd_shd.g_old_rec.primary_activity;
576: End If;
577: If (p_rec.non_us_country_code = hr_api.g_varchar2) then
578: p_rec.non_us_country_code :=
579: pqp_atd_shd.g_old_rec.non_us_country_code;
575: pqp_atd_shd.g_old_rec.primary_activity;
576: End If;
577: If (p_rec.non_us_country_code = hr_api.g_varchar2) then
578: p_rec.non_us_country_code :=
579: pqp_atd_shd.g_old_rec.non_us_country_code;
580: End If;
581: If (p_rec.citizenship_country_code = hr_api.g_varchar2) then
582: p_rec.citizenship_country_code :=
583: pqp_atd_shd.g_old_rec.citizenship_country_code;
579: pqp_atd_shd.g_old_rec.non_us_country_code;
580: End If;
581: If (p_rec.citizenship_country_code = hr_api.g_varchar2) then
582: p_rec.citizenship_country_code :=
583: pqp_atd_shd.g_old_rec.citizenship_country_code;
584: End If;
585: If (p_rec.constant_addl_tax = hr_api.g_number) then
586: p_rec.constant_addl_tax :=
587: pqp_atd_shd.g_old_rec.constant_addl_tax;
583: pqp_atd_shd.g_old_rec.citizenship_country_code;
584: End If;
585: If (p_rec.constant_addl_tax = hr_api.g_number) then
586: p_rec.constant_addl_tax :=
587: pqp_atd_shd.g_old_rec.constant_addl_tax;
588: End If;
589: If (p_rec.date_8233_signed = hr_api.g_date) then
590: p_rec.date_8233_signed :=
591: pqp_atd_shd.g_old_rec.date_8233_signed;
587: pqp_atd_shd.g_old_rec.constant_addl_tax;
588: End If;
589: If (p_rec.date_8233_signed = hr_api.g_date) then
590: p_rec.date_8233_signed :=
591: pqp_atd_shd.g_old_rec.date_8233_signed;
592: End If;
593: If (p_rec.date_w4_signed = hr_api.g_date) then
594: p_rec.date_w4_signed :=
595: pqp_atd_shd.g_old_rec.date_w4_signed;
591: pqp_atd_shd.g_old_rec.date_8233_signed;
592: End If;
593: If (p_rec.date_w4_signed = hr_api.g_date) then
594: p_rec.date_w4_signed :=
595: pqp_atd_shd.g_old_rec.date_w4_signed;
596: End If;
597: If (p_rec.error_indicator = hr_api.g_varchar2) then
598: p_rec.error_indicator :=
599: pqp_atd_shd.g_old_rec.error_indicator;
595: pqp_atd_shd.g_old_rec.date_w4_signed;
596: End If;
597: If (p_rec.error_indicator = hr_api.g_varchar2) then
598: p_rec.error_indicator :=
599: pqp_atd_shd.g_old_rec.error_indicator;
600: End If;
601: If (p_rec.prev_er_treaty_benefit_amt = hr_api.g_number) then
602: p_rec.prev_er_treaty_benefit_amt :=
603: pqp_atd_shd.g_old_rec.prev_er_treaty_benefit_amt;
599: pqp_atd_shd.g_old_rec.error_indicator;
600: End If;
601: If (p_rec.prev_er_treaty_benefit_amt = hr_api.g_number) then
602: p_rec.prev_er_treaty_benefit_amt :=
603: pqp_atd_shd.g_old_rec.prev_er_treaty_benefit_amt;
604: End If;
605: If (p_rec.error_text = hr_api.g_varchar2) then
606: p_rec.error_text :=
607: pqp_atd_shd.g_old_rec.error_text;
603: pqp_atd_shd.g_old_rec.prev_er_treaty_benefit_amt;
604: End If;
605: If (p_rec.error_text = hr_api.g_varchar2) then
606: p_rec.error_text :=
607: pqp_atd_shd.g_old_rec.error_text;
608: End If;
609: If (p_rec.current_analysis= hr_api.g_varchar2) then
610: p_rec.current_analysis :=
611: pqp_atd_shd.g_old_rec.current_analysis;
607: pqp_atd_shd.g_old_rec.error_text;
608: End If;
609: If (p_rec.current_analysis= hr_api.g_varchar2) then
610: p_rec.current_analysis :=
611: pqp_atd_shd.g_old_rec.current_analysis;
612: End If;
613: If (p_rec.forecast_income_code = hr_api.g_varchar2) then
614: p_rec.forecast_income_code :=
615: pqp_atd_shd.g_old_rec.forecast_income_code;
611: pqp_atd_shd.g_old_rec.current_analysis;
612: End If;
613: If (p_rec.forecast_income_code = hr_api.g_varchar2) then
614: p_rec.forecast_income_code :=
615: pqp_atd_shd.g_old_rec.forecast_income_code;
616: End If;
617:
618: --
619: hr_utility.set_location(' Leaving:'||l_proc, 10);
625: ----------------------------------------------------------------------------
626: Procedure upd
627: (
628: p_effective_date in date,
629: p_rec in out nocopy pqp_atd_shd.g_rec_type
630: ) is
631:
632: l_proc varchar2(72) := g_package||'upd';
633:
635: hr_utility.set_location('Entering:'||l_proc, 5);
636: --
637: -- We must lock the row which we need to update.
638: --
639: pqp_atd_shd.lck
640: (
641: p_rec.alien_transaction_id,
642: p_rec.object_version_number
643: );
725: p_current_analysis in varchar2 default hr_api.g_varchar2,
726: p_forecast_income_code in varchar2 default hr_api.g_varchar2
727: ) is
728:
729: l_rec pqp_atd_shd.g_rec_type;
730: l_proc varchar2(72) := g_package||'upd';
731:
732: Begin
733: hr_utility.set_location('Entering:'||l_proc, 5);
735: -- Call conversion function to turn arguments into the
736: -- l_rec structure.
737: --
738: l_rec :=
739: pqp_atd_shd.convert_args
740: (
741: p_alien_transaction_id,
742: p_person_id,
743: p_data_source_type,