99: Procedure upd
100: (
101: p_effective_date in date,
102: p_analyzed_data_details_id in number,
103: p_analyzed_data_id in number default hr_api.g_number,
104: p_income_code in varchar2 default hr_api.g_varchar2,
105: p_withholding_rate in number default hr_api.g_number,
106: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,
107: p_exemption_code in varchar2 default hr_api.g_varchar2,
100: (
101: p_effective_date in date,
102: p_analyzed_data_details_id in number,
103: p_analyzed_data_id in number default hr_api.g_number,
104: p_income_code in varchar2 default hr_api.g_varchar2,
105: p_withholding_rate in number default hr_api.g_number,
106: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,
107: p_exemption_code in varchar2 default hr_api.g_varchar2,
108: p_maximum_benefit_amount in number default hr_api.g_number,
101: p_effective_date in date,
102: p_analyzed_data_details_id in number,
103: p_analyzed_data_id in number default hr_api.g_number,
104: p_income_code in varchar2 default hr_api.g_varchar2,
105: p_withholding_rate in number default hr_api.g_number,
106: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,
107: p_exemption_code in varchar2 default hr_api.g_varchar2,
108: p_maximum_benefit_amount in number default hr_api.g_number,
109: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
102: p_analyzed_data_details_id in number,
103: p_analyzed_data_id in number default hr_api.g_number,
104: p_income_code in varchar2 default hr_api.g_varchar2,
105: p_withholding_rate in number default hr_api.g_number,
106: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,
107: p_exemption_code in varchar2 default hr_api.g_varchar2,
108: p_maximum_benefit_amount in number default hr_api.g_number,
109: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
110: p_date_benefit_ends in date default hr_api.g_date,
103: p_analyzed_data_id in number default hr_api.g_number,
104: p_income_code in varchar2 default hr_api.g_varchar2,
105: p_withholding_rate in number default hr_api.g_number,
106: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,
107: p_exemption_code in varchar2 default hr_api.g_varchar2,
108: p_maximum_benefit_amount in number default hr_api.g_number,
109: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
110: p_date_benefit_ends in date default hr_api.g_date,
111: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
104: p_income_code in varchar2 default hr_api.g_varchar2,
105: p_withholding_rate in number default hr_api.g_number,
106: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,
107: p_exemption_code in varchar2 default hr_api.g_varchar2,
108: p_maximum_benefit_amount in number default hr_api.g_number,
109: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
110: p_date_benefit_ends in date default hr_api.g_date,
111: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
112: p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2,
105: p_withholding_rate in number default hr_api.g_number,
106: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,
107: p_exemption_code in varchar2 default hr_api.g_varchar2,
108: p_maximum_benefit_amount in number default hr_api.g_number,
109: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
110: p_date_benefit_ends in date default hr_api.g_date,
111: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
112: p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2,
113: p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2,
106: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,
107: p_exemption_code in varchar2 default hr_api.g_varchar2,
108: p_maximum_benefit_amount in number default hr_api.g_number,
109: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
110: p_date_benefit_ends in date default hr_api.g_date,
111: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
112: p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2,
113: p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2,
114: p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2,
107: p_exemption_code in varchar2 default hr_api.g_varchar2,
108: p_maximum_benefit_amount in number default hr_api.g_number,
109: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
110: p_date_benefit_ends in date default hr_api.g_date,
111: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
112: p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2,
113: p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2,
114: p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2,
115: p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2,
108: p_maximum_benefit_amount in number default hr_api.g_number,
109: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
110: p_date_benefit_ends in date default hr_api.g_date,
111: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
112: p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2,
113: p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2,
114: p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2,
115: p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2,
116: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
109: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
110: p_date_benefit_ends in date default hr_api.g_date,
111: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
112: p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2,
113: p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2,
114: p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2,
115: p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2,
116: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
117: p_constant_addl_tax in number default hr_api.g_number,
110: p_date_benefit_ends in date default hr_api.g_date,
111: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
112: p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2,
113: p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2,
114: p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2,
115: p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2,
116: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
117: p_constant_addl_tax in number default hr_api.g_number,
118: p_addl_withholding_amt in number default hr_api.g_number,
111: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
112: p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2,
113: p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2,
114: p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2,
115: p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2,
116: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
117: p_constant_addl_tax in number default hr_api.g_number,
118: p_addl_withholding_amt in number default hr_api.g_number,
119: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
112: p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2,
113: p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2,
114: p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2,
115: p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2,
116: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
117: p_constant_addl_tax in number default hr_api.g_number,
118: p_addl_withholding_amt in number default hr_api.g_number,
119: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
120: p_personal_exemption in number default hr_api.g_number,
113: p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2,
114: p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2,
115: p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2,
116: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
117: p_constant_addl_tax in number default hr_api.g_number,
118: p_addl_withholding_amt in number default hr_api.g_number,
119: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
120: p_personal_exemption in number default hr_api.g_number,
121: p_addl_exemption_allowed in number default hr_api.g_number,
114: p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2,
115: p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2,
116: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
117: p_constant_addl_tax in number default hr_api.g_number,
118: p_addl_withholding_amt in number default hr_api.g_number,
119: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
120: p_personal_exemption in number default hr_api.g_number,
121: p_addl_exemption_allowed in number default hr_api.g_number,
122: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,
115: p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2,
116: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
117: p_constant_addl_tax in number default hr_api.g_number,
118: p_addl_withholding_amt in number default hr_api.g_number,
119: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
120: p_personal_exemption in number default hr_api.g_number,
121: p_addl_exemption_allowed in number default hr_api.g_number,
122: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,
123: p_treaty_benefits_start_date in date default hr_api.g_date,
116: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
117: p_constant_addl_tax in number default hr_api.g_number,
118: p_addl_withholding_amt in number default hr_api.g_number,
119: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
120: p_personal_exemption in number default hr_api.g_number,
121: p_addl_exemption_allowed in number default hr_api.g_number,
122: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,
123: p_treaty_benefits_start_date in date default hr_api.g_date,
124: p_object_version_number in out nocopy number,
117: p_constant_addl_tax in number default hr_api.g_number,
118: p_addl_withholding_amt in number default hr_api.g_number,
119: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
120: p_personal_exemption in number default hr_api.g_number,
121: p_addl_exemption_allowed in number default hr_api.g_number,
122: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,
123: p_treaty_benefits_start_date in date default hr_api.g_date,
124: p_object_version_number in out nocopy number,
125: p_retro_loss_notification_sent in varchar2 default hr_api.g_varchar2,
118: p_addl_withholding_amt in number default hr_api.g_number,
119: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
120: p_personal_exemption in number default hr_api.g_number,
121: p_addl_exemption_allowed in number default hr_api.g_number,
122: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,
123: p_treaty_benefits_start_date in date default hr_api.g_date,
124: p_object_version_number in out nocopy number,
125: p_retro_loss_notification_sent in varchar2 default hr_api.g_varchar2,
126: p_current_analysis in varchar2 default hr_api.g_varchar2,
119: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
120: p_personal_exemption in number default hr_api.g_number,
121: p_addl_exemption_allowed in number default hr_api.g_number,
122: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,
123: p_treaty_benefits_start_date in date default hr_api.g_date,
124: p_object_version_number in out nocopy number,
125: p_retro_loss_notification_sent in varchar2 default hr_api.g_varchar2,
126: p_current_analysis in varchar2 default hr_api.g_varchar2,
127: p_forecast_income_code in varchar2 default hr_api.g_varchar2
121: p_addl_exemption_allowed in number default hr_api.g_number,
122: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,
123: p_treaty_benefits_start_date in date default hr_api.g_date,
124: p_object_version_number in out nocopy number,
125: p_retro_loss_notification_sent in varchar2 default hr_api.g_varchar2,
126: p_current_analysis in varchar2 default hr_api.g_varchar2,
127: p_forecast_income_code in varchar2 default hr_api.g_varchar2
128: );
129:
122: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,
123: p_treaty_benefits_start_date in date default hr_api.g_date,
124: p_object_version_number in out nocopy number,
125: p_retro_loss_notification_sent in varchar2 default hr_api.g_varchar2,
126: p_current_analysis in varchar2 default hr_api.g_varchar2,
127: p_forecast_income_code in varchar2 default hr_api.g_varchar2
128: );
129:
130: end pqp_det_upd;
123: p_treaty_benefits_start_date in date default hr_api.g_date,
124: p_object_version_number in out nocopy number,
125: p_retro_loss_notification_sent in varchar2 default hr_api.g_varchar2,
126: p_current_analysis in varchar2 default hr_api.g_varchar2,
127: p_forecast_income_code in varchar2 default hr_api.g_varchar2
128: );
129:
130: end pqp_det_upd;