99: Procedure upd
100: (
101: p_effective_date in date,
102: p_analyzed_data_id in number,
103: p_assignment_id in number default hr_api.g_number,
104: p_data_source in varchar2 default hr_api.g_varchar2,
105: p_tax_year in number default hr_api.g_number,
106: p_current_residency_status in varchar2 default hr_api.g_varchar2,
107: p_nra_to_ra_date in date default hr_api.g_date,
100: (
101: p_effective_date in date,
102: p_analyzed_data_id in number,
103: p_assignment_id in number default hr_api.g_number,
104: p_data_source in varchar2 default hr_api.g_varchar2,
105: p_tax_year in number default hr_api.g_number,
106: p_current_residency_status in varchar2 default hr_api.g_varchar2,
107: p_nra_to_ra_date in date default hr_api.g_date,
108: p_target_departure_date in date default hr_api.g_date,
101: p_effective_date in date,
102: p_analyzed_data_id in number,
103: p_assignment_id in number default hr_api.g_number,
104: p_data_source in varchar2 default hr_api.g_varchar2,
105: p_tax_year in number default hr_api.g_number,
106: p_current_residency_status in varchar2 default hr_api.g_varchar2,
107: p_nra_to_ra_date in date default hr_api.g_date,
108: p_target_departure_date in date default hr_api.g_date,
109: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,
102: p_analyzed_data_id in number,
103: p_assignment_id in number default hr_api.g_number,
104: p_data_source in varchar2 default hr_api.g_varchar2,
105: p_tax_year in number default hr_api.g_number,
106: p_current_residency_status in varchar2 default hr_api.g_varchar2,
107: p_nra_to_ra_date in date default hr_api.g_date,
108: p_target_departure_date in date default hr_api.g_date,
109: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,
110: p_treaty_info_update_date in date default hr_api.g_date,
103: p_assignment_id in number default hr_api.g_number,
104: p_data_source in varchar2 default hr_api.g_varchar2,
105: p_tax_year in number default hr_api.g_number,
106: p_current_residency_status in varchar2 default hr_api.g_varchar2,
107: p_nra_to_ra_date in date default hr_api.g_date,
108: p_target_departure_date in date default hr_api.g_date,
109: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,
110: p_treaty_info_update_date in date default hr_api.g_date,
111: p_number_of_days_in_usa in number default hr_api.g_number,
104: p_data_source in varchar2 default hr_api.g_varchar2,
105: p_tax_year in number default hr_api.g_number,
106: p_current_residency_status in varchar2 default hr_api.g_varchar2,
107: p_nra_to_ra_date in date default hr_api.g_date,
108: p_target_departure_date in date default hr_api.g_date,
109: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,
110: p_treaty_info_update_date in date default hr_api.g_date,
111: p_number_of_days_in_usa in number default hr_api.g_number,
112: p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,
105: p_tax_year in number default hr_api.g_number,
106: p_current_residency_status in varchar2 default hr_api.g_varchar2,
107: p_nra_to_ra_date in date default hr_api.g_date,
108: p_target_departure_date in date default hr_api.g_date,
109: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,
110: p_treaty_info_update_date in date default hr_api.g_date,
111: p_number_of_days_in_usa in number default hr_api.g_number,
112: p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,
113: p_ra_effective_date in date default hr_api.g_date,
106: p_current_residency_status in varchar2 default hr_api.g_varchar2,
107: p_nra_to_ra_date in date default hr_api.g_date,
108: p_target_departure_date in date default hr_api.g_date,
109: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,
110: p_treaty_info_update_date in date default hr_api.g_date,
111: p_number_of_days_in_usa in number default hr_api.g_number,
112: p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,
113: p_ra_effective_date in date default hr_api.g_date,
114: p_record_source in varchar2 default hr_api.g_varchar2,
107: p_nra_to_ra_date in date default hr_api.g_date,
108: p_target_departure_date in date default hr_api.g_date,
109: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,
110: p_treaty_info_update_date in date default hr_api.g_date,
111: p_number_of_days_in_usa in number default hr_api.g_number,
112: p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,
113: p_ra_effective_date in date default hr_api.g_date,
114: p_record_source in varchar2 default hr_api.g_varchar2,
115: p_visa_type in varchar2 default hr_api.g_varchar2,
108: p_target_departure_date in date default hr_api.g_date,
109: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,
110: p_treaty_info_update_date in date default hr_api.g_date,
111: p_number_of_days_in_usa in number default hr_api.g_number,
112: p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,
113: p_ra_effective_date in date default hr_api.g_date,
114: p_record_source in varchar2 default hr_api.g_varchar2,
115: p_visa_type in varchar2 default hr_api.g_varchar2,
116: p_j_sub_type in varchar2 default hr_api.g_varchar2,
109: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,
110: p_treaty_info_update_date in date default hr_api.g_date,
111: p_number_of_days_in_usa in number default hr_api.g_number,
112: p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,
113: p_ra_effective_date in date default hr_api.g_date,
114: p_record_source in varchar2 default hr_api.g_varchar2,
115: p_visa_type in varchar2 default hr_api.g_varchar2,
116: p_j_sub_type in varchar2 default hr_api.g_varchar2,
117: p_primary_activity in varchar2 default hr_api.g_varchar2,
110: p_treaty_info_update_date in date default hr_api.g_date,
111: p_number_of_days_in_usa in number default hr_api.g_number,
112: p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,
113: p_ra_effective_date in date default hr_api.g_date,
114: p_record_source in varchar2 default hr_api.g_varchar2,
115: p_visa_type in varchar2 default hr_api.g_varchar2,
116: p_j_sub_type in varchar2 default hr_api.g_varchar2,
117: p_primary_activity in varchar2 default hr_api.g_varchar2,
118: p_non_us_country_code in varchar2 default hr_api.g_varchar2,
111: p_number_of_days_in_usa in number default hr_api.g_number,
112: p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,
113: p_ra_effective_date in date default hr_api.g_date,
114: p_record_source in varchar2 default hr_api.g_varchar2,
115: p_visa_type in varchar2 default hr_api.g_varchar2,
116: p_j_sub_type in varchar2 default hr_api.g_varchar2,
117: p_primary_activity in varchar2 default hr_api.g_varchar2,
118: p_non_us_country_code in varchar2 default hr_api.g_varchar2,
119: p_citizenship_country_code in varchar2 default hr_api.g_varchar2,
112: p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,
113: p_ra_effective_date in date default hr_api.g_date,
114: p_record_source in varchar2 default hr_api.g_varchar2,
115: p_visa_type in varchar2 default hr_api.g_varchar2,
116: p_j_sub_type in varchar2 default hr_api.g_varchar2,
117: p_primary_activity in varchar2 default hr_api.g_varchar2,
118: p_non_us_country_code in varchar2 default hr_api.g_varchar2,
119: p_citizenship_country_code in varchar2 default hr_api.g_varchar2,
120: p_object_version_number in out nocopy number
113: p_ra_effective_date in date default hr_api.g_date,
114: p_record_source in varchar2 default hr_api.g_varchar2,
115: p_visa_type in varchar2 default hr_api.g_varchar2,
116: p_j_sub_type in varchar2 default hr_api.g_varchar2,
117: p_primary_activity in varchar2 default hr_api.g_varchar2,
118: p_non_us_country_code in varchar2 default hr_api.g_varchar2,
119: p_citizenship_country_code in varchar2 default hr_api.g_varchar2,
120: p_object_version_number in out nocopy number
121: ,p_date_8233_signed in date default hr_api.g_date
114: p_record_source in varchar2 default hr_api.g_varchar2,
115: p_visa_type in varchar2 default hr_api.g_varchar2,
116: p_j_sub_type in varchar2 default hr_api.g_varchar2,
117: p_primary_activity in varchar2 default hr_api.g_varchar2,
118: p_non_us_country_code in varchar2 default hr_api.g_varchar2,
119: p_citizenship_country_code in varchar2 default hr_api.g_varchar2,
120: p_object_version_number in out nocopy number
121: ,p_date_8233_signed in date default hr_api.g_date
122: ,p_date_w4_signed in date default hr_api.g_date
115: p_visa_type in varchar2 default hr_api.g_varchar2,
116: p_j_sub_type in varchar2 default hr_api.g_varchar2,
117: p_primary_activity in varchar2 default hr_api.g_varchar2,
118: p_non_us_country_code in varchar2 default hr_api.g_varchar2,
119: p_citizenship_country_code in varchar2 default hr_api.g_varchar2,
120: p_object_version_number in out nocopy number
121: ,p_date_8233_signed in date default hr_api.g_date
122: ,p_date_w4_signed in date default hr_api.g_date
123: );
117: p_primary_activity in varchar2 default hr_api.g_varchar2,
118: p_non_us_country_code in varchar2 default hr_api.g_varchar2,
119: p_citizenship_country_code in varchar2 default hr_api.g_varchar2,
120: p_object_version_number in out nocopy number
121: ,p_date_8233_signed in date default hr_api.g_date
122: ,p_date_w4_signed in date default hr_api.g_date
123: );
124: --
125: end pqp_aad_upd;
118: p_non_us_country_code in varchar2 default hr_api.g_varchar2,
119: p_citizenship_country_code in varchar2 default hr_api.g_varchar2,
120: p_object_version_number in out nocopy number
121: ,p_date_8233_signed in date default hr_api.g_date
122: ,p_date_w4_signed in date default hr_api.g_date
123: );
124: --
125: end pqp_aad_upd;