eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_ATD_DEL dependencies on PQP_ATD_SHD

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

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

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

61: --
62: delete from pqp_alien_transaction_data
63: where alien_transaction_id = p_rec.alien_transaction_id;
64: --
65: pqp_atd_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_atd_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_atd_shd.g_api_dml := false; -- Unset the api dml status
73: pqp_atd_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: pqp_atd_shd.g_api_dml := false; -- Unset the api dml status

Line 73: pqp_atd_shd.constraint_error

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

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

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

Line 170: ,p_person_id_o =>pqp_atd_shd.g_old_rec.person_id

166: --
167: pqp_atd_rkd.after_delete
168: (
169: p_alien_transaction_id =>p_rec.alien_transaction_id
170: ,p_person_id_o =>pqp_atd_shd.g_old_rec.person_id
171: ,p_data_source_type_o =>pqp_atd_shd.g_old_rec.data_source_type
172: ,p_tax_year_o =>pqp_atd_shd.g_old_rec.tax_year
173: ,p_income_code_o =>pqp_atd_shd.g_old_rec.income_code
174: ,p_withholding_rate_o =>pqp_atd_shd.g_old_rec.withholding_rate

Line 171: ,p_data_source_type_o =>pqp_atd_shd.g_old_rec.data_source_type

167: pqp_atd_rkd.after_delete
168: (
169: p_alien_transaction_id =>p_rec.alien_transaction_id
170: ,p_person_id_o =>pqp_atd_shd.g_old_rec.person_id
171: ,p_data_source_type_o =>pqp_atd_shd.g_old_rec.data_source_type
172: ,p_tax_year_o =>pqp_atd_shd.g_old_rec.tax_year
173: ,p_income_code_o =>pqp_atd_shd.g_old_rec.income_code
174: ,p_withholding_rate_o =>pqp_atd_shd.g_old_rec.withholding_rate
175: ,p_income_code_sub_type_o =>pqp_atd_shd.g_old_rec.income_code_sub_type

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

168: (
169: p_alien_transaction_id =>p_rec.alien_transaction_id
170: ,p_person_id_o =>pqp_atd_shd.g_old_rec.person_id
171: ,p_data_source_type_o =>pqp_atd_shd.g_old_rec.data_source_type
172: ,p_tax_year_o =>pqp_atd_shd.g_old_rec.tax_year
173: ,p_income_code_o =>pqp_atd_shd.g_old_rec.income_code
174: ,p_withholding_rate_o =>pqp_atd_shd.g_old_rec.withholding_rate
175: ,p_income_code_sub_type_o =>pqp_atd_shd.g_old_rec.income_code_sub_type
176: ,p_exemption_code_o =>pqp_atd_shd.g_old_rec.exemption_code

Line 173: ,p_income_code_o =>pqp_atd_shd.g_old_rec.income_code

169: p_alien_transaction_id =>p_rec.alien_transaction_id
170: ,p_person_id_o =>pqp_atd_shd.g_old_rec.person_id
171: ,p_data_source_type_o =>pqp_atd_shd.g_old_rec.data_source_type
172: ,p_tax_year_o =>pqp_atd_shd.g_old_rec.tax_year
173: ,p_income_code_o =>pqp_atd_shd.g_old_rec.income_code
174: ,p_withholding_rate_o =>pqp_atd_shd.g_old_rec.withholding_rate
175: ,p_income_code_sub_type_o =>pqp_atd_shd.g_old_rec.income_code_sub_type
176: ,p_exemption_code_o =>pqp_atd_shd.g_old_rec.exemption_code
177: ,p_maximum_benefit_amount_o =>pqp_atd_shd.g_old_rec.maximum_benefit_amount

Line 174: ,p_withholding_rate_o =>pqp_atd_shd.g_old_rec.withholding_rate

170: ,p_person_id_o =>pqp_atd_shd.g_old_rec.person_id
171: ,p_data_source_type_o =>pqp_atd_shd.g_old_rec.data_source_type
172: ,p_tax_year_o =>pqp_atd_shd.g_old_rec.tax_year
173: ,p_income_code_o =>pqp_atd_shd.g_old_rec.income_code
174: ,p_withholding_rate_o =>pqp_atd_shd.g_old_rec.withholding_rate
175: ,p_income_code_sub_type_o =>pqp_atd_shd.g_old_rec.income_code_sub_type
176: ,p_exemption_code_o =>pqp_atd_shd.g_old_rec.exemption_code
177: ,p_maximum_benefit_amount_o =>pqp_atd_shd.g_old_rec.maximum_benefit_amount
178: ,p_retro_lose_ben_amt_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag

Line 175: ,p_income_code_sub_type_o =>pqp_atd_shd.g_old_rec.income_code_sub_type

171: ,p_data_source_type_o =>pqp_atd_shd.g_old_rec.data_source_type
172: ,p_tax_year_o =>pqp_atd_shd.g_old_rec.tax_year
173: ,p_income_code_o =>pqp_atd_shd.g_old_rec.income_code
174: ,p_withholding_rate_o =>pqp_atd_shd.g_old_rec.withholding_rate
175: ,p_income_code_sub_type_o =>pqp_atd_shd.g_old_rec.income_code_sub_type
176: ,p_exemption_code_o =>pqp_atd_shd.g_old_rec.exemption_code
177: ,p_maximum_benefit_amount_o =>pqp_atd_shd.g_old_rec.maximum_benefit_amount
178: ,p_retro_lose_ben_amt_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag
179: ,p_date_benefit_ends_o =>pqp_atd_shd.g_old_rec.date_benefit_ends

Line 176: ,p_exemption_code_o =>pqp_atd_shd.g_old_rec.exemption_code

172: ,p_tax_year_o =>pqp_atd_shd.g_old_rec.tax_year
173: ,p_income_code_o =>pqp_atd_shd.g_old_rec.income_code
174: ,p_withholding_rate_o =>pqp_atd_shd.g_old_rec.withholding_rate
175: ,p_income_code_sub_type_o =>pqp_atd_shd.g_old_rec.income_code_sub_type
176: ,p_exemption_code_o =>pqp_atd_shd.g_old_rec.exemption_code
177: ,p_maximum_benefit_amount_o =>pqp_atd_shd.g_old_rec.maximum_benefit_amount
178: ,p_retro_lose_ben_amt_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag
179: ,p_date_benefit_ends_o =>pqp_atd_shd.g_old_rec.date_benefit_ends
180: ,p_retro_lose_ben_date_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag

Line 177: ,p_maximum_benefit_amount_o =>pqp_atd_shd.g_old_rec.maximum_benefit_amount

173: ,p_income_code_o =>pqp_atd_shd.g_old_rec.income_code
174: ,p_withholding_rate_o =>pqp_atd_shd.g_old_rec.withholding_rate
175: ,p_income_code_sub_type_o =>pqp_atd_shd.g_old_rec.income_code_sub_type
176: ,p_exemption_code_o =>pqp_atd_shd.g_old_rec.exemption_code
177: ,p_maximum_benefit_amount_o =>pqp_atd_shd.g_old_rec.maximum_benefit_amount
178: ,p_retro_lose_ben_amt_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag
179: ,p_date_benefit_ends_o =>pqp_atd_shd.g_old_rec.date_benefit_ends
180: ,p_retro_lose_ben_date_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag
181: ,p_current_residency_status_o =>pqp_atd_shd.g_old_rec.current_residency_status

Line 178: ,p_retro_lose_ben_amt_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag

174: ,p_withholding_rate_o =>pqp_atd_shd.g_old_rec.withholding_rate
175: ,p_income_code_sub_type_o =>pqp_atd_shd.g_old_rec.income_code_sub_type
176: ,p_exemption_code_o =>pqp_atd_shd.g_old_rec.exemption_code
177: ,p_maximum_benefit_amount_o =>pqp_atd_shd.g_old_rec.maximum_benefit_amount
178: ,p_retro_lose_ben_amt_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag
179: ,p_date_benefit_ends_o =>pqp_atd_shd.g_old_rec.date_benefit_ends
180: ,p_retro_lose_ben_date_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag
181: ,p_current_residency_status_o =>pqp_atd_shd.g_old_rec.current_residency_status
182: ,p_nra_to_ra_date_o =>pqp_atd_shd.g_old_rec.nra_to_ra_date

Line 179: ,p_date_benefit_ends_o =>pqp_atd_shd.g_old_rec.date_benefit_ends

175: ,p_income_code_sub_type_o =>pqp_atd_shd.g_old_rec.income_code_sub_type
176: ,p_exemption_code_o =>pqp_atd_shd.g_old_rec.exemption_code
177: ,p_maximum_benefit_amount_o =>pqp_atd_shd.g_old_rec.maximum_benefit_amount
178: ,p_retro_lose_ben_amt_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag
179: ,p_date_benefit_ends_o =>pqp_atd_shd.g_old_rec.date_benefit_ends
180: ,p_retro_lose_ben_date_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag
181: ,p_current_residency_status_o =>pqp_atd_shd.g_old_rec.current_residency_status
182: ,p_nra_to_ra_date_o =>pqp_atd_shd.g_old_rec.nra_to_ra_date
183: ,p_target_departure_date_o =>pqp_atd_shd.g_old_rec.target_departure_date

Line 180: ,p_retro_lose_ben_date_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag

176: ,p_exemption_code_o =>pqp_atd_shd.g_old_rec.exemption_code
177: ,p_maximum_benefit_amount_o =>pqp_atd_shd.g_old_rec.maximum_benefit_amount
178: ,p_retro_lose_ben_amt_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag
179: ,p_date_benefit_ends_o =>pqp_atd_shd.g_old_rec.date_benefit_ends
180: ,p_retro_lose_ben_date_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag
181: ,p_current_residency_status_o =>pqp_atd_shd.g_old_rec.current_residency_status
182: ,p_nra_to_ra_date_o =>pqp_atd_shd.g_old_rec.nra_to_ra_date
183: ,p_target_departure_date_o =>pqp_atd_shd.g_old_rec.target_departure_date
184: ,p_tax_residence_country_code_o =>pqp_atd_shd.g_old_rec.tax_residence_country_code

Line 181: ,p_current_residency_status_o =>pqp_atd_shd.g_old_rec.current_residency_status

177: ,p_maximum_benefit_amount_o =>pqp_atd_shd.g_old_rec.maximum_benefit_amount
178: ,p_retro_lose_ben_amt_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag
179: ,p_date_benefit_ends_o =>pqp_atd_shd.g_old_rec.date_benefit_ends
180: ,p_retro_lose_ben_date_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag
181: ,p_current_residency_status_o =>pqp_atd_shd.g_old_rec.current_residency_status
182: ,p_nra_to_ra_date_o =>pqp_atd_shd.g_old_rec.nra_to_ra_date
183: ,p_target_departure_date_o =>pqp_atd_shd.g_old_rec.target_departure_date
184: ,p_tax_residence_country_code_o =>pqp_atd_shd.g_old_rec.tax_residence_country_code
185: ,p_treaty_info_update_date_o =>pqp_atd_shd.g_old_rec.treaty_info_update_date

Line 182: ,p_nra_to_ra_date_o =>pqp_atd_shd.g_old_rec.nra_to_ra_date

178: ,p_retro_lose_ben_amt_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag
179: ,p_date_benefit_ends_o =>pqp_atd_shd.g_old_rec.date_benefit_ends
180: ,p_retro_lose_ben_date_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag
181: ,p_current_residency_status_o =>pqp_atd_shd.g_old_rec.current_residency_status
182: ,p_nra_to_ra_date_o =>pqp_atd_shd.g_old_rec.nra_to_ra_date
183: ,p_target_departure_date_o =>pqp_atd_shd.g_old_rec.target_departure_date
184: ,p_tax_residence_country_code_o =>pqp_atd_shd.g_old_rec.tax_residence_country_code
185: ,p_treaty_info_update_date_o =>pqp_atd_shd.g_old_rec.treaty_info_update_date
186: ,p_nra_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.nra_exempt_from_fica

Line 183: ,p_target_departure_date_o =>pqp_atd_shd.g_old_rec.target_departure_date

179: ,p_date_benefit_ends_o =>pqp_atd_shd.g_old_rec.date_benefit_ends
180: ,p_retro_lose_ben_date_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag
181: ,p_current_residency_status_o =>pqp_atd_shd.g_old_rec.current_residency_status
182: ,p_nra_to_ra_date_o =>pqp_atd_shd.g_old_rec.nra_to_ra_date
183: ,p_target_departure_date_o =>pqp_atd_shd.g_old_rec.target_departure_date
184: ,p_tax_residence_country_code_o =>pqp_atd_shd.g_old_rec.tax_residence_country_code
185: ,p_treaty_info_update_date_o =>pqp_atd_shd.g_old_rec.treaty_info_update_date
186: ,p_nra_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.nra_exempt_from_fica
187: ,p_student_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.student_exempt_from_fica

Line 184: ,p_tax_residence_country_code_o =>pqp_atd_shd.g_old_rec.tax_residence_country_code

180: ,p_retro_lose_ben_date_flag_o =>pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag
181: ,p_current_residency_status_o =>pqp_atd_shd.g_old_rec.current_residency_status
182: ,p_nra_to_ra_date_o =>pqp_atd_shd.g_old_rec.nra_to_ra_date
183: ,p_target_departure_date_o =>pqp_atd_shd.g_old_rec.target_departure_date
184: ,p_tax_residence_country_code_o =>pqp_atd_shd.g_old_rec.tax_residence_country_code
185: ,p_treaty_info_update_date_o =>pqp_atd_shd.g_old_rec.treaty_info_update_date
186: ,p_nra_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.nra_exempt_from_fica
187: ,p_student_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.student_exempt_from_fica
188: ,p_addl_withholding_flag_o =>pqp_atd_shd.g_old_rec.addl_withholding_flag

Line 185: ,p_treaty_info_update_date_o =>pqp_atd_shd.g_old_rec.treaty_info_update_date

181: ,p_current_residency_status_o =>pqp_atd_shd.g_old_rec.current_residency_status
182: ,p_nra_to_ra_date_o =>pqp_atd_shd.g_old_rec.nra_to_ra_date
183: ,p_target_departure_date_o =>pqp_atd_shd.g_old_rec.target_departure_date
184: ,p_tax_residence_country_code_o =>pqp_atd_shd.g_old_rec.tax_residence_country_code
185: ,p_treaty_info_update_date_o =>pqp_atd_shd.g_old_rec.treaty_info_update_date
186: ,p_nra_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.nra_exempt_from_fica
187: ,p_student_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.student_exempt_from_fica
188: ,p_addl_withholding_flag_o =>pqp_atd_shd.g_old_rec.addl_withholding_flag
189: ,p_addl_withholding_amt_o =>pqp_atd_shd.g_old_rec.addl_withholding_amt

Line 186: ,p_nra_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.nra_exempt_from_fica

182: ,p_nra_to_ra_date_o =>pqp_atd_shd.g_old_rec.nra_to_ra_date
183: ,p_target_departure_date_o =>pqp_atd_shd.g_old_rec.target_departure_date
184: ,p_tax_residence_country_code_o =>pqp_atd_shd.g_old_rec.tax_residence_country_code
185: ,p_treaty_info_update_date_o =>pqp_atd_shd.g_old_rec.treaty_info_update_date
186: ,p_nra_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.nra_exempt_from_fica
187: ,p_student_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.student_exempt_from_fica
188: ,p_addl_withholding_flag_o =>pqp_atd_shd.g_old_rec.addl_withholding_flag
189: ,p_addl_withholding_amt_o =>pqp_atd_shd.g_old_rec.addl_withholding_amt
190: ,p_addl_wthldng_amt_period_ty_o=>pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type

Line 187: ,p_student_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.student_exempt_from_fica

183: ,p_target_departure_date_o =>pqp_atd_shd.g_old_rec.target_departure_date
184: ,p_tax_residence_country_code_o =>pqp_atd_shd.g_old_rec.tax_residence_country_code
185: ,p_treaty_info_update_date_o =>pqp_atd_shd.g_old_rec.treaty_info_update_date
186: ,p_nra_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.nra_exempt_from_fica
187: ,p_student_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.student_exempt_from_fica
188: ,p_addl_withholding_flag_o =>pqp_atd_shd.g_old_rec.addl_withholding_flag
189: ,p_addl_withholding_amt_o =>pqp_atd_shd.g_old_rec.addl_withholding_amt
190: ,p_addl_wthldng_amt_period_ty_o=>pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type
191: ,p_personal_exemption_o =>pqp_atd_shd.g_old_rec.personal_exemption

Line 188: ,p_addl_withholding_flag_o =>pqp_atd_shd.g_old_rec.addl_withholding_flag

184: ,p_tax_residence_country_code_o =>pqp_atd_shd.g_old_rec.tax_residence_country_code
185: ,p_treaty_info_update_date_o =>pqp_atd_shd.g_old_rec.treaty_info_update_date
186: ,p_nra_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.nra_exempt_from_fica
187: ,p_student_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.student_exempt_from_fica
188: ,p_addl_withholding_flag_o =>pqp_atd_shd.g_old_rec.addl_withholding_flag
189: ,p_addl_withholding_amt_o =>pqp_atd_shd.g_old_rec.addl_withholding_amt
190: ,p_addl_wthldng_amt_period_ty_o=>pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type
191: ,p_personal_exemption_o =>pqp_atd_shd.g_old_rec.personal_exemption
192: ,p_addl_exemption_allowed_o =>pqp_atd_shd.g_old_rec.addl_exemption_allowed

Line 189: ,p_addl_withholding_amt_o =>pqp_atd_shd.g_old_rec.addl_withholding_amt

185: ,p_treaty_info_update_date_o =>pqp_atd_shd.g_old_rec.treaty_info_update_date
186: ,p_nra_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.nra_exempt_from_fica
187: ,p_student_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.student_exempt_from_fica
188: ,p_addl_withholding_flag_o =>pqp_atd_shd.g_old_rec.addl_withholding_flag
189: ,p_addl_withholding_amt_o =>pqp_atd_shd.g_old_rec.addl_withholding_amt
190: ,p_addl_wthldng_amt_period_ty_o=>pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type
191: ,p_personal_exemption_o =>pqp_atd_shd.g_old_rec.personal_exemption
192: ,p_addl_exemption_allowed_o =>pqp_atd_shd.g_old_rec.addl_exemption_allowed
193: ,p_number_of_days_in_usa_o =>pqp_atd_shd.g_old_rec.number_of_days_in_usa

Line 190: ,p_addl_wthldng_amt_period_ty_o=>pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type

186: ,p_nra_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.nra_exempt_from_fica
187: ,p_student_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.student_exempt_from_fica
188: ,p_addl_withholding_flag_o =>pqp_atd_shd.g_old_rec.addl_withholding_flag
189: ,p_addl_withholding_amt_o =>pqp_atd_shd.g_old_rec.addl_withholding_amt
190: ,p_addl_wthldng_amt_period_ty_o=>pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type
191: ,p_personal_exemption_o =>pqp_atd_shd.g_old_rec.personal_exemption
192: ,p_addl_exemption_allowed_o =>pqp_atd_shd.g_old_rec.addl_exemption_allowed
193: ,p_number_of_days_in_usa_o =>pqp_atd_shd.g_old_rec.number_of_days_in_usa
194: ,p_wthldg_allow_eligible_flag_o =>pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag

Line 191: ,p_personal_exemption_o =>pqp_atd_shd.g_old_rec.personal_exemption

187: ,p_student_exempt_from_fica_o =>pqp_atd_shd.g_old_rec.student_exempt_from_fica
188: ,p_addl_withholding_flag_o =>pqp_atd_shd.g_old_rec.addl_withholding_flag
189: ,p_addl_withholding_amt_o =>pqp_atd_shd.g_old_rec.addl_withholding_amt
190: ,p_addl_wthldng_amt_period_ty_o=>pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type
191: ,p_personal_exemption_o =>pqp_atd_shd.g_old_rec.personal_exemption
192: ,p_addl_exemption_allowed_o =>pqp_atd_shd.g_old_rec.addl_exemption_allowed
193: ,p_number_of_days_in_usa_o =>pqp_atd_shd.g_old_rec.number_of_days_in_usa
194: ,p_wthldg_allow_eligible_flag_o =>pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag
195: ,p_treaty_ben_allowed_flag_o =>pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag

Line 192: ,p_addl_exemption_allowed_o =>pqp_atd_shd.g_old_rec.addl_exemption_allowed

188: ,p_addl_withholding_flag_o =>pqp_atd_shd.g_old_rec.addl_withholding_flag
189: ,p_addl_withholding_amt_o =>pqp_atd_shd.g_old_rec.addl_withholding_amt
190: ,p_addl_wthldng_amt_period_ty_o=>pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type
191: ,p_personal_exemption_o =>pqp_atd_shd.g_old_rec.personal_exemption
192: ,p_addl_exemption_allowed_o =>pqp_atd_shd.g_old_rec.addl_exemption_allowed
193: ,p_number_of_days_in_usa_o =>pqp_atd_shd.g_old_rec.number_of_days_in_usa
194: ,p_wthldg_allow_eligible_flag_o =>pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag
195: ,p_treaty_ben_allowed_flag_o =>pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag
196: ,p_treaty_benefits_start_date_o =>pqp_atd_shd.g_old_rec.treaty_benefits_start_date

Line 193: ,p_number_of_days_in_usa_o =>pqp_atd_shd.g_old_rec.number_of_days_in_usa

189: ,p_addl_withholding_amt_o =>pqp_atd_shd.g_old_rec.addl_withholding_amt
190: ,p_addl_wthldng_amt_period_ty_o=>pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type
191: ,p_personal_exemption_o =>pqp_atd_shd.g_old_rec.personal_exemption
192: ,p_addl_exemption_allowed_o =>pqp_atd_shd.g_old_rec.addl_exemption_allowed
193: ,p_number_of_days_in_usa_o =>pqp_atd_shd.g_old_rec.number_of_days_in_usa
194: ,p_wthldg_allow_eligible_flag_o =>pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag
195: ,p_treaty_ben_allowed_flag_o =>pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag
196: ,p_treaty_benefits_start_date_o =>pqp_atd_shd.g_old_rec.treaty_benefits_start_date
197: ,p_ra_effective_date_o =>pqp_atd_shd.g_old_rec.ra_effective_date

Line 194: ,p_wthldg_allow_eligible_flag_o =>pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag

190: ,p_addl_wthldng_amt_period_ty_o=>pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type
191: ,p_personal_exemption_o =>pqp_atd_shd.g_old_rec.personal_exemption
192: ,p_addl_exemption_allowed_o =>pqp_atd_shd.g_old_rec.addl_exemption_allowed
193: ,p_number_of_days_in_usa_o =>pqp_atd_shd.g_old_rec.number_of_days_in_usa
194: ,p_wthldg_allow_eligible_flag_o =>pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag
195: ,p_treaty_ben_allowed_flag_o =>pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag
196: ,p_treaty_benefits_start_date_o =>pqp_atd_shd.g_old_rec.treaty_benefits_start_date
197: ,p_ra_effective_date_o =>pqp_atd_shd.g_old_rec.ra_effective_date
198: ,p_state_code_o =>pqp_atd_shd.g_old_rec.state_code

Line 195: ,p_treaty_ben_allowed_flag_o =>pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag

191: ,p_personal_exemption_o =>pqp_atd_shd.g_old_rec.personal_exemption
192: ,p_addl_exemption_allowed_o =>pqp_atd_shd.g_old_rec.addl_exemption_allowed
193: ,p_number_of_days_in_usa_o =>pqp_atd_shd.g_old_rec.number_of_days_in_usa
194: ,p_wthldg_allow_eligible_flag_o =>pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag
195: ,p_treaty_ben_allowed_flag_o =>pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag
196: ,p_treaty_benefits_start_date_o =>pqp_atd_shd.g_old_rec.treaty_benefits_start_date
197: ,p_ra_effective_date_o =>pqp_atd_shd.g_old_rec.ra_effective_date
198: ,p_state_code_o =>pqp_atd_shd.g_old_rec.state_code
199: ,p_state_honors_treaty_flag_o =>pqp_atd_shd.g_old_rec.state_honors_treaty_flag

Line 196: ,p_treaty_benefits_start_date_o =>pqp_atd_shd.g_old_rec.treaty_benefits_start_date

192: ,p_addl_exemption_allowed_o =>pqp_atd_shd.g_old_rec.addl_exemption_allowed
193: ,p_number_of_days_in_usa_o =>pqp_atd_shd.g_old_rec.number_of_days_in_usa
194: ,p_wthldg_allow_eligible_flag_o =>pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag
195: ,p_treaty_ben_allowed_flag_o =>pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag
196: ,p_treaty_benefits_start_date_o =>pqp_atd_shd.g_old_rec.treaty_benefits_start_date
197: ,p_ra_effective_date_o =>pqp_atd_shd.g_old_rec.ra_effective_date
198: ,p_state_code_o =>pqp_atd_shd.g_old_rec.state_code
199: ,p_state_honors_treaty_flag_o =>pqp_atd_shd.g_old_rec.state_honors_treaty_flag
200: ,p_ytd_payments_o =>pqp_atd_shd.g_old_rec.ytd_payments

Line 197: ,p_ra_effective_date_o =>pqp_atd_shd.g_old_rec.ra_effective_date

193: ,p_number_of_days_in_usa_o =>pqp_atd_shd.g_old_rec.number_of_days_in_usa
194: ,p_wthldg_allow_eligible_flag_o =>pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag
195: ,p_treaty_ben_allowed_flag_o =>pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag
196: ,p_treaty_benefits_start_date_o =>pqp_atd_shd.g_old_rec.treaty_benefits_start_date
197: ,p_ra_effective_date_o =>pqp_atd_shd.g_old_rec.ra_effective_date
198: ,p_state_code_o =>pqp_atd_shd.g_old_rec.state_code
199: ,p_state_honors_treaty_flag_o =>pqp_atd_shd.g_old_rec.state_honors_treaty_flag
200: ,p_ytd_payments_o =>pqp_atd_shd.g_old_rec.ytd_payments
201: ,p_ytd_w2_payments_o =>pqp_atd_shd.g_old_rec.ytd_w2_payments

Line 198: ,p_state_code_o =>pqp_atd_shd.g_old_rec.state_code

194: ,p_wthldg_allow_eligible_flag_o =>pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag
195: ,p_treaty_ben_allowed_flag_o =>pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag
196: ,p_treaty_benefits_start_date_o =>pqp_atd_shd.g_old_rec.treaty_benefits_start_date
197: ,p_ra_effective_date_o =>pqp_atd_shd.g_old_rec.ra_effective_date
198: ,p_state_code_o =>pqp_atd_shd.g_old_rec.state_code
199: ,p_state_honors_treaty_flag_o =>pqp_atd_shd.g_old_rec.state_honors_treaty_flag
200: ,p_ytd_payments_o =>pqp_atd_shd.g_old_rec.ytd_payments
201: ,p_ytd_w2_payments_o =>pqp_atd_shd.g_old_rec.ytd_w2_payments
202: ,p_ytd_w2_withholding_o =>pqp_atd_shd.g_old_rec.ytd_w2_withholding

Line 199: ,p_state_honors_treaty_flag_o =>pqp_atd_shd.g_old_rec.state_honors_treaty_flag

195: ,p_treaty_ben_allowed_flag_o =>pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag
196: ,p_treaty_benefits_start_date_o =>pqp_atd_shd.g_old_rec.treaty_benefits_start_date
197: ,p_ra_effective_date_o =>pqp_atd_shd.g_old_rec.ra_effective_date
198: ,p_state_code_o =>pqp_atd_shd.g_old_rec.state_code
199: ,p_state_honors_treaty_flag_o =>pqp_atd_shd.g_old_rec.state_honors_treaty_flag
200: ,p_ytd_payments_o =>pqp_atd_shd.g_old_rec.ytd_payments
201: ,p_ytd_w2_payments_o =>pqp_atd_shd.g_old_rec.ytd_w2_payments
202: ,p_ytd_w2_withholding_o =>pqp_atd_shd.g_old_rec.ytd_w2_withholding
203: ,p_ytd_withholding_allowance_o =>pqp_atd_shd.g_old_rec.ytd_withholding_allowance

Line 200: ,p_ytd_payments_o =>pqp_atd_shd.g_old_rec.ytd_payments

196: ,p_treaty_benefits_start_date_o =>pqp_atd_shd.g_old_rec.treaty_benefits_start_date
197: ,p_ra_effective_date_o =>pqp_atd_shd.g_old_rec.ra_effective_date
198: ,p_state_code_o =>pqp_atd_shd.g_old_rec.state_code
199: ,p_state_honors_treaty_flag_o =>pqp_atd_shd.g_old_rec.state_honors_treaty_flag
200: ,p_ytd_payments_o =>pqp_atd_shd.g_old_rec.ytd_payments
201: ,p_ytd_w2_payments_o =>pqp_atd_shd.g_old_rec.ytd_w2_payments
202: ,p_ytd_w2_withholding_o =>pqp_atd_shd.g_old_rec.ytd_w2_withholding
203: ,p_ytd_withholding_allowance_o =>pqp_atd_shd.g_old_rec.ytd_withholding_allowance
204: ,p_ytd_treaty_payments_o =>pqp_atd_shd.g_old_rec.ytd_treaty_payments

Line 201: ,p_ytd_w2_payments_o =>pqp_atd_shd.g_old_rec.ytd_w2_payments

197: ,p_ra_effective_date_o =>pqp_atd_shd.g_old_rec.ra_effective_date
198: ,p_state_code_o =>pqp_atd_shd.g_old_rec.state_code
199: ,p_state_honors_treaty_flag_o =>pqp_atd_shd.g_old_rec.state_honors_treaty_flag
200: ,p_ytd_payments_o =>pqp_atd_shd.g_old_rec.ytd_payments
201: ,p_ytd_w2_payments_o =>pqp_atd_shd.g_old_rec.ytd_w2_payments
202: ,p_ytd_w2_withholding_o =>pqp_atd_shd.g_old_rec.ytd_w2_withholding
203: ,p_ytd_withholding_allowance_o =>pqp_atd_shd.g_old_rec.ytd_withholding_allowance
204: ,p_ytd_treaty_payments_o =>pqp_atd_shd.g_old_rec.ytd_treaty_payments
205: ,p_ytd_treaty_withheld_amt_o =>pqp_atd_shd.g_old_rec.ytd_treaty_withheld_amt

Line 202: ,p_ytd_w2_withholding_o =>pqp_atd_shd.g_old_rec.ytd_w2_withholding

198: ,p_state_code_o =>pqp_atd_shd.g_old_rec.state_code
199: ,p_state_honors_treaty_flag_o =>pqp_atd_shd.g_old_rec.state_honors_treaty_flag
200: ,p_ytd_payments_o =>pqp_atd_shd.g_old_rec.ytd_payments
201: ,p_ytd_w2_payments_o =>pqp_atd_shd.g_old_rec.ytd_w2_payments
202: ,p_ytd_w2_withholding_o =>pqp_atd_shd.g_old_rec.ytd_w2_withholding
203: ,p_ytd_withholding_allowance_o =>pqp_atd_shd.g_old_rec.ytd_withholding_allowance
204: ,p_ytd_treaty_payments_o =>pqp_atd_shd.g_old_rec.ytd_treaty_payments
205: ,p_ytd_treaty_withheld_amt_o =>pqp_atd_shd.g_old_rec.ytd_treaty_withheld_amt
206: ,p_record_source_o =>pqp_atd_shd.g_old_rec.record_source

Line 203: ,p_ytd_withholding_allowance_o =>pqp_atd_shd.g_old_rec.ytd_withholding_allowance

199: ,p_state_honors_treaty_flag_o =>pqp_atd_shd.g_old_rec.state_honors_treaty_flag
200: ,p_ytd_payments_o =>pqp_atd_shd.g_old_rec.ytd_payments
201: ,p_ytd_w2_payments_o =>pqp_atd_shd.g_old_rec.ytd_w2_payments
202: ,p_ytd_w2_withholding_o =>pqp_atd_shd.g_old_rec.ytd_w2_withholding
203: ,p_ytd_withholding_allowance_o =>pqp_atd_shd.g_old_rec.ytd_withholding_allowance
204: ,p_ytd_treaty_payments_o =>pqp_atd_shd.g_old_rec.ytd_treaty_payments
205: ,p_ytd_treaty_withheld_amt_o =>pqp_atd_shd.g_old_rec.ytd_treaty_withheld_amt
206: ,p_record_source_o =>pqp_atd_shd.g_old_rec.record_source
207: ,p_visa_type_o =>pqp_atd_shd.g_old_rec.visa_type

Line 204: ,p_ytd_treaty_payments_o =>pqp_atd_shd.g_old_rec.ytd_treaty_payments

200: ,p_ytd_payments_o =>pqp_atd_shd.g_old_rec.ytd_payments
201: ,p_ytd_w2_payments_o =>pqp_atd_shd.g_old_rec.ytd_w2_payments
202: ,p_ytd_w2_withholding_o =>pqp_atd_shd.g_old_rec.ytd_w2_withholding
203: ,p_ytd_withholding_allowance_o =>pqp_atd_shd.g_old_rec.ytd_withholding_allowance
204: ,p_ytd_treaty_payments_o =>pqp_atd_shd.g_old_rec.ytd_treaty_payments
205: ,p_ytd_treaty_withheld_amt_o =>pqp_atd_shd.g_old_rec.ytd_treaty_withheld_amt
206: ,p_record_source_o =>pqp_atd_shd.g_old_rec.record_source
207: ,p_visa_type_o =>pqp_atd_shd.g_old_rec.visa_type
208: ,p_j_sub_type_o =>pqp_atd_shd.g_old_rec.j_sub_type

Line 205: ,p_ytd_treaty_withheld_amt_o =>pqp_atd_shd.g_old_rec.ytd_treaty_withheld_amt

201: ,p_ytd_w2_payments_o =>pqp_atd_shd.g_old_rec.ytd_w2_payments
202: ,p_ytd_w2_withholding_o =>pqp_atd_shd.g_old_rec.ytd_w2_withholding
203: ,p_ytd_withholding_allowance_o =>pqp_atd_shd.g_old_rec.ytd_withholding_allowance
204: ,p_ytd_treaty_payments_o =>pqp_atd_shd.g_old_rec.ytd_treaty_payments
205: ,p_ytd_treaty_withheld_amt_o =>pqp_atd_shd.g_old_rec.ytd_treaty_withheld_amt
206: ,p_record_source_o =>pqp_atd_shd.g_old_rec.record_source
207: ,p_visa_type_o =>pqp_atd_shd.g_old_rec.visa_type
208: ,p_j_sub_type_o =>pqp_atd_shd.g_old_rec.j_sub_type
209: ,p_primary_activity_o =>pqp_atd_shd.g_old_rec.primary_activity

Line 206: ,p_record_source_o =>pqp_atd_shd.g_old_rec.record_source

202: ,p_ytd_w2_withholding_o =>pqp_atd_shd.g_old_rec.ytd_w2_withholding
203: ,p_ytd_withholding_allowance_o =>pqp_atd_shd.g_old_rec.ytd_withholding_allowance
204: ,p_ytd_treaty_payments_o =>pqp_atd_shd.g_old_rec.ytd_treaty_payments
205: ,p_ytd_treaty_withheld_amt_o =>pqp_atd_shd.g_old_rec.ytd_treaty_withheld_amt
206: ,p_record_source_o =>pqp_atd_shd.g_old_rec.record_source
207: ,p_visa_type_o =>pqp_atd_shd.g_old_rec.visa_type
208: ,p_j_sub_type_o =>pqp_atd_shd.g_old_rec.j_sub_type
209: ,p_primary_activity_o =>pqp_atd_shd.g_old_rec.primary_activity
210: ,p_non_us_country_code_o =>pqp_atd_shd.g_old_rec.non_us_country_code

Line 207: ,p_visa_type_o =>pqp_atd_shd.g_old_rec.visa_type

203: ,p_ytd_withholding_allowance_o =>pqp_atd_shd.g_old_rec.ytd_withholding_allowance
204: ,p_ytd_treaty_payments_o =>pqp_atd_shd.g_old_rec.ytd_treaty_payments
205: ,p_ytd_treaty_withheld_amt_o =>pqp_atd_shd.g_old_rec.ytd_treaty_withheld_amt
206: ,p_record_source_o =>pqp_atd_shd.g_old_rec.record_source
207: ,p_visa_type_o =>pqp_atd_shd.g_old_rec.visa_type
208: ,p_j_sub_type_o =>pqp_atd_shd.g_old_rec.j_sub_type
209: ,p_primary_activity_o =>pqp_atd_shd.g_old_rec.primary_activity
210: ,p_non_us_country_code_o =>pqp_atd_shd.g_old_rec.non_us_country_code
211: ,p_citizenship_country_code_o =>pqp_atd_shd.g_old_rec.citizenship_country_code

Line 208: ,p_j_sub_type_o =>pqp_atd_shd.g_old_rec.j_sub_type

204: ,p_ytd_treaty_payments_o =>pqp_atd_shd.g_old_rec.ytd_treaty_payments
205: ,p_ytd_treaty_withheld_amt_o =>pqp_atd_shd.g_old_rec.ytd_treaty_withheld_amt
206: ,p_record_source_o =>pqp_atd_shd.g_old_rec.record_source
207: ,p_visa_type_o =>pqp_atd_shd.g_old_rec.visa_type
208: ,p_j_sub_type_o =>pqp_atd_shd.g_old_rec.j_sub_type
209: ,p_primary_activity_o =>pqp_atd_shd.g_old_rec.primary_activity
210: ,p_non_us_country_code_o =>pqp_atd_shd.g_old_rec.non_us_country_code
211: ,p_citizenship_country_code_o =>pqp_atd_shd.g_old_rec.citizenship_country_code
212: ,p_constant_addl_tax_o =>pqp_atd_shd.g_old_rec.constant_addl_tax

Line 209: ,p_primary_activity_o =>pqp_atd_shd.g_old_rec.primary_activity

205: ,p_ytd_treaty_withheld_amt_o =>pqp_atd_shd.g_old_rec.ytd_treaty_withheld_amt
206: ,p_record_source_o =>pqp_atd_shd.g_old_rec.record_source
207: ,p_visa_type_o =>pqp_atd_shd.g_old_rec.visa_type
208: ,p_j_sub_type_o =>pqp_atd_shd.g_old_rec.j_sub_type
209: ,p_primary_activity_o =>pqp_atd_shd.g_old_rec.primary_activity
210: ,p_non_us_country_code_o =>pqp_atd_shd.g_old_rec.non_us_country_code
211: ,p_citizenship_country_code_o =>pqp_atd_shd.g_old_rec.citizenship_country_code
212: ,p_constant_addl_tax_o =>pqp_atd_shd.g_old_rec.constant_addl_tax
213: ,p_date_8233_signed_o =>pqp_atd_shd.g_old_rec.date_8233_signed

Line 210: ,p_non_us_country_code_o =>pqp_atd_shd.g_old_rec.non_us_country_code

206: ,p_record_source_o =>pqp_atd_shd.g_old_rec.record_source
207: ,p_visa_type_o =>pqp_atd_shd.g_old_rec.visa_type
208: ,p_j_sub_type_o =>pqp_atd_shd.g_old_rec.j_sub_type
209: ,p_primary_activity_o =>pqp_atd_shd.g_old_rec.primary_activity
210: ,p_non_us_country_code_o =>pqp_atd_shd.g_old_rec.non_us_country_code
211: ,p_citizenship_country_code_o =>pqp_atd_shd.g_old_rec.citizenship_country_code
212: ,p_constant_addl_tax_o =>pqp_atd_shd.g_old_rec.constant_addl_tax
213: ,p_date_8233_signed_o =>pqp_atd_shd.g_old_rec.date_8233_signed
214: ,p_date_w4_signed_o =>pqp_atd_shd.g_old_rec.date_w4_signed

Line 211: ,p_citizenship_country_code_o =>pqp_atd_shd.g_old_rec.citizenship_country_code

207: ,p_visa_type_o =>pqp_atd_shd.g_old_rec.visa_type
208: ,p_j_sub_type_o =>pqp_atd_shd.g_old_rec.j_sub_type
209: ,p_primary_activity_o =>pqp_atd_shd.g_old_rec.primary_activity
210: ,p_non_us_country_code_o =>pqp_atd_shd.g_old_rec.non_us_country_code
211: ,p_citizenship_country_code_o =>pqp_atd_shd.g_old_rec.citizenship_country_code
212: ,p_constant_addl_tax_o =>pqp_atd_shd.g_old_rec.constant_addl_tax
213: ,p_date_8233_signed_o =>pqp_atd_shd.g_old_rec.date_8233_signed
214: ,p_date_w4_signed_o =>pqp_atd_shd.g_old_rec.date_w4_signed
215: ,p_error_indicator_o =>pqp_atd_shd.g_old_rec.error_indicator

Line 212: ,p_constant_addl_tax_o =>pqp_atd_shd.g_old_rec.constant_addl_tax

208: ,p_j_sub_type_o =>pqp_atd_shd.g_old_rec.j_sub_type
209: ,p_primary_activity_o =>pqp_atd_shd.g_old_rec.primary_activity
210: ,p_non_us_country_code_o =>pqp_atd_shd.g_old_rec.non_us_country_code
211: ,p_citizenship_country_code_o =>pqp_atd_shd.g_old_rec.citizenship_country_code
212: ,p_constant_addl_tax_o =>pqp_atd_shd.g_old_rec.constant_addl_tax
213: ,p_date_8233_signed_o =>pqp_atd_shd.g_old_rec.date_8233_signed
214: ,p_date_w4_signed_o =>pqp_atd_shd.g_old_rec.date_w4_signed
215: ,p_error_indicator_o =>pqp_atd_shd.g_old_rec.error_indicator
216: ,p_prev_er_treaty_benefit_amt_o =>pqp_atd_shd.g_old_rec.prev_er_treaty_benefit_amt

Line 213: ,p_date_8233_signed_o =>pqp_atd_shd.g_old_rec.date_8233_signed

209: ,p_primary_activity_o =>pqp_atd_shd.g_old_rec.primary_activity
210: ,p_non_us_country_code_o =>pqp_atd_shd.g_old_rec.non_us_country_code
211: ,p_citizenship_country_code_o =>pqp_atd_shd.g_old_rec.citizenship_country_code
212: ,p_constant_addl_tax_o =>pqp_atd_shd.g_old_rec.constant_addl_tax
213: ,p_date_8233_signed_o =>pqp_atd_shd.g_old_rec.date_8233_signed
214: ,p_date_w4_signed_o =>pqp_atd_shd.g_old_rec.date_w4_signed
215: ,p_error_indicator_o =>pqp_atd_shd.g_old_rec.error_indicator
216: ,p_prev_er_treaty_benefit_amt_o =>pqp_atd_shd.g_old_rec.prev_er_treaty_benefit_amt
217: ,p_error_text_o =>pqp_atd_shd.g_old_rec.error_text

Line 214: ,p_date_w4_signed_o =>pqp_atd_shd.g_old_rec.date_w4_signed

210: ,p_non_us_country_code_o =>pqp_atd_shd.g_old_rec.non_us_country_code
211: ,p_citizenship_country_code_o =>pqp_atd_shd.g_old_rec.citizenship_country_code
212: ,p_constant_addl_tax_o =>pqp_atd_shd.g_old_rec.constant_addl_tax
213: ,p_date_8233_signed_o =>pqp_atd_shd.g_old_rec.date_8233_signed
214: ,p_date_w4_signed_o =>pqp_atd_shd.g_old_rec.date_w4_signed
215: ,p_error_indicator_o =>pqp_atd_shd.g_old_rec.error_indicator
216: ,p_prev_er_treaty_benefit_amt_o =>pqp_atd_shd.g_old_rec.prev_er_treaty_benefit_amt
217: ,p_error_text_o =>pqp_atd_shd.g_old_rec.error_text
218: ,p_object_version_number_o =>pqp_atd_shd.g_old_rec.object_version_number

Line 215: ,p_error_indicator_o =>pqp_atd_shd.g_old_rec.error_indicator

211: ,p_citizenship_country_code_o =>pqp_atd_shd.g_old_rec.citizenship_country_code
212: ,p_constant_addl_tax_o =>pqp_atd_shd.g_old_rec.constant_addl_tax
213: ,p_date_8233_signed_o =>pqp_atd_shd.g_old_rec.date_8233_signed
214: ,p_date_w4_signed_o =>pqp_atd_shd.g_old_rec.date_w4_signed
215: ,p_error_indicator_o =>pqp_atd_shd.g_old_rec.error_indicator
216: ,p_prev_er_treaty_benefit_amt_o =>pqp_atd_shd.g_old_rec.prev_er_treaty_benefit_amt
217: ,p_error_text_o =>pqp_atd_shd.g_old_rec.error_text
218: ,p_object_version_number_o =>pqp_atd_shd.g_old_rec.object_version_number
219: ,p_current_analysis_o =>pqp_atd_shd.g_old_rec.current_analysis

Line 216: ,p_prev_er_treaty_benefit_amt_o =>pqp_atd_shd.g_old_rec.prev_er_treaty_benefit_amt

212: ,p_constant_addl_tax_o =>pqp_atd_shd.g_old_rec.constant_addl_tax
213: ,p_date_8233_signed_o =>pqp_atd_shd.g_old_rec.date_8233_signed
214: ,p_date_w4_signed_o =>pqp_atd_shd.g_old_rec.date_w4_signed
215: ,p_error_indicator_o =>pqp_atd_shd.g_old_rec.error_indicator
216: ,p_prev_er_treaty_benefit_amt_o =>pqp_atd_shd.g_old_rec.prev_er_treaty_benefit_amt
217: ,p_error_text_o =>pqp_atd_shd.g_old_rec.error_text
218: ,p_object_version_number_o =>pqp_atd_shd.g_old_rec.object_version_number
219: ,p_current_analysis_o =>pqp_atd_shd.g_old_rec.current_analysis
220: ,p_forecast_income_code_o =>pqp_atd_shd.g_old_rec.forecast_income_code

Line 217: ,p_error_text_o =>pqp_atd_shd.g_old_rec.error_text

213: ,p_date_8233_signed_o =>pqp_atd_shd.g_old_rec.date_8233_signed
214: ,p_date_w4_signed_o =>pqp_atd_shd.g_old_rec.date_w4_signed
215: ,p_error_indicator_o =>pqp_atd_shd.g_old_rec.error_indicator
216: ,p_prev_er_treaty_benefit_amt_o =>pqp_atd_shd.g_old_rec.prev_er_treaty_benefit_amt
217: ,p_error_text_o =>pqp_atd_shd.g_old_rec.error_text
218: ,p_object_version_number_o =>pqp_atd_shd.g_old_rec.object_version_number
219: ,p_current_analysis_o =>pqp_atd_shd.g_old_rec.current_analysis
220: ,p_forecast_income_code_o =>pqp_atd_shd.g_old_rec.forecast_income_code
221: );

Line 218: ,p_object_version_number_o =>pqp_atd_shd.g_old_rec.object_version_number

214: ,p_date_w4_signed_o =>pqp_atd_shd.g_old_rec.date_w4_signed
215: ,p_error_indicator_o =>pqp_atd_shd.g_old_rec.error_indicator
216: ,p_prev_er_treaty_benefit_amt_o =>pqp_atd_shd.g_old_rec.prev_er_treaty_benefit_amt
217: ,p_error_text_o =>pqp_atd_shd.g_old_rec.error_text
218: ,p_object_version_number_o =>pqp_atd_shd.g_old_rec.object_version_number
219: ,p_current_analysis_o =>pqp_atd_shd.g_old_rec.current_analysis
220: ,p_forecast_income_code_o =>pqp_atd_shd.g_old_rec.forecast_income_code
221: );
222: --

Line 219: ,p_current_analysis_o =>pqp_atd_shd.g_old_rec.current_analysis

215: ,p_error_indicator_o =>pqp_atd_shd.g_old_rec.error_indicator
216: ,p_prev_er_treaty_benefit_amt_o =>pqp_atd_shd.g_old_rec.prev_er_treaty_benefit_amt
217: ,p_error_text_o =>pqp_atd_shd.g_old_rec.error_text
218: ,p_object_version_number_o =>pqp_atd_shd.g_old_rec.object_version_number
219: ,p_current_analysis_o =>pqp_atd_shd.g_old_rec.current_analysis
220: ,p_forecast_income_code_o =>pqp_atd_shd.g_old_rec.forecast_income_code
221: );
222: --
223: exception

Line 220: ,p_forecast_income_code_o =>pqp_atd_shd.g_old_rec.forecast_income_code

216: ,p_prev_er_treaty_benefit_amt_o =>pqp_atd_shd.g_old_rec.prev_er_treaty_benefit_amt
217: ,p_error_text_o =>pqp_atd_shd.g_old_rec.error_text
218: ,p_object_version_number_o =>pqp_atd_shd.g_old_rec.object_version_number
219: ,p_current_analysis_o =>pqp_atd_shd.g_old_rec.current_analysis
220: ,p_forecast_income_code_o =>pqp_atd_shd.g_old_rec.forecast_income_code
221: );
222: --
223: exception
224: --

Line 245: p_rec in pqp_atd_shd.g_rec_type

241: ----------------------------------------------------------------------------
242: Procedure del
243: (
244: p_effective_date in date,
245: p_rec in pqp_atd_shd.g_rec_type
246: ) is
247:
248: l_proc varchar2(72) := g_package||'del';
249:

Line 255: pqp_atd_shd.lck

251: hr_utility.set_location('Entering:'||l_proc, 5);
252: --
253: -- We must lock the row which we need to delete.
254: --
255: pqp_atd_shd.lck
256: (
257: p_rec.alien_transaction_id,
258: p_rec.object_version_number
259: );

Line 290: l_rec pqp_atd_shd.g_rec_type;

286: p_alien_transaction_id in number,
287: p_object_version_number in number
288: ) is
289:
290: l_rec pqp_atd_shd.g_rec_type;
291: l_proc varchar2(72) := g_package||'del';
292:
293: Begin
294: hr_utility.set_location('Entering:'||l_proc, 5);