APPS.BEN_CWB_PERSON_RATES_API dependencies on HR_API

Line 149: when hr_api.cannot_find_prog_unit then

145: ,p_ws_rt_start_date => p_ws_rt_start_date
146: ,p_currency => p_currency
147: );
148: exception
149: when hr_api.cannot_find_prog_unit then
150: hr_api.cannot_find_prog_unit_error
151: (p_module_name => 'CREATE_PERSON_RATE'
152: ,p_hook_type => 'BP'
153: );

Line 150: hr_api.cannot_find_prog_unit_error

146: ,p_currency => p_currency
147: );
148: exception
149: when hr_api.cannot_find_prog_unit then
150: hr_api.cannot_find_prog_unit_error
151: (p_module_name => 'CREATE_PERSON_RATE'
152: ,p_hook_type => 'BP'
153: );
154: end;

Line 275: when hr_api.cannot_find_prog_unit then

271: ,p_currency => p_currency
272: ,p_object_version_number => l_object_version_number
273: );
274: exception
275: when hr_api.cannot_find_prog_unit then
276: hr_api.cannot_find_prog_unit_error
277: (p_module_name => 'CREATE_PERSON_RATE'
278: ,p_hook_type => 'AP'
279: );

Line 276: hr_api.cannot_find_prog_unit_error

272: ,p_object_version_number => l_object_version_number
273: );
274: exception
275: when hr_api.cannot_find_prog_unit then
276: hr_api.cannot_find_prog_unit_error
277: (p_module_name => 'CREATE_PERSON_RATE'
278: ,p_hook_type => 'AP'
279: );
280: end;

Line 285: raise hr_api.validate_enabled;

281: --
282: -- When in validation only mode raise the Validate_Enabled exception
283: --
284: if p_validate then
285: raise hr_api.validate_enabled;
286: end if;
287: --
288: -- Set all IN OUT and OUT parameters with out values
289: --

Line 297: when hr_api.validate_enabled then

293: if g_debug then
294: hr_utility.set_location(' Leaving:'||l_proc, 70);
295: end if;
296: exception
297: when hr_api.validate_enabled then
298: --
299: -- As the Validate_Enabled exception has been raised
300: -- we must rollback to the savepoint
301: --

Line 352: if (p_val is not null and p_val <> hr_api.g_number and

348: if g_debug then
349: hr_utility.set_location(l_proc, 20);
350: end if;
351: --
352: if (p_val is not null and p_val <> hr_api.g_number and
353: p_min_val is not null) then
354: if (p_val < p_min_val) then
355: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
356: fnd_message.set_token('VAL',p_val);

Line 369: if (p_val is not null and p_val <> hr_api.g_number and

365: if g_debug then
366: hr_utility.set_location(l_proc, 30);
367: end if;
368: --
369: if (p_val is not null and p_val <> hr_api.g_number and
370: p_max_val is not null) then
371: if (p_val > p_max_val) then
372: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
373: fnd_message.set_token('VAL',p_val);

Line 385: if (p_val is not null and p_val <> hr_api.g_number and

381: if g_debug then
382: hr_utility.set_location(l_proc, 40);
383: end if;
384: --
385: if (p_val is not null and p_val <> hr_api.g_number and
386: p_incr_val is not null) then
387: if (mod(p_val,p_incr_val) <> 0) then
388: fnd_message.set_name('BEN','BEN_92985_CWB_VAL_NOT_INCRMNT');
389: fnd_message.set_token('VAL',p_val);

Line 1144: ,p_group_pl_id in number default hr_api.g_number

1140: (p_validate in boolean default false
1141: ,p_group_per_in_ler_id in number
1142: ,p_pl_id in number
1143: ,p_oipl_id in number
1144: ,p_group_pl_id in number default hr_api.g_number
1145: ,p_group_oipl_id in number default hr_api.g_number
1146: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
1147: ,p_person_id in number default hr_api.g_number
1148: ,p_assignment_id in number default hr_api.g_number

Line 1145: ,p_group_oipl_id in number default hr_api.g_number

1141: ,p_group_per_in_ler_id in number
1142: ,p_pl_id in number
1143: ,p_oipl_id in number
1144: ,p_group_pl_id in number default hr_api.g_number
1145: ,p_group_oipl_id in number default hr_api.g_number
1146: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
1147: ,p_person_id in number default hr_api.g_number
1148: ,p_assignment_id in number default hr_api.g_number
1149: ,p_elig_flag in varchar2 default hr_api.g_varchar2

Line 1146: ,p_lf_evt_ocrd_dt in date default hr_api.g_date

1142: ,p_pl_id in number
1143: ,p_oipl_id in number
1144: ,p_group_pl_id in number default hr_api.g_number
1145: ,p_group_oipl_id in number default hr_api.g_number
1146: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
1147: ,p_person_id in number default hr_api.g_number
1148: ,p_assignment_id in number default hr_api.g_number
1149: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1150: ,p_ws_val in number default hr_api.g_number

Line 1147: ,p_person_id in number default hr_api.g_number

1143: ,p_oipl_id in number
1144: ,p_group_pl_id in number default hr_api.g_number
1145: ,p_group_oipl_id in number default hr_api.g_number
1146: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
1147: ,p_person_id in number default hr_api.g_number
1148: ,p_assignment_id in number default hr_api.g_number
1149: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1150: ,p_ws_val in number default hr_api.g_number
1151: ,p_ws_mn_val in number default hr_api.g_number

Line 1148: ,p_assignment_id in number default hr_api.g_number

1144: ,p_group_pl_id in number default hr_api.g_number
1145: ,p_group_oipl_id in number default hr_api.g_number
1146: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
1147: ,p_person_id in number default hr_api.g_number
1148: ,p_assignment_id in number default hr_api.g_number
1149: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1150: ,p_ws_val in number default hr_api.g_number
1151: ,p_ws_mn_val in number default hr_api.g_number
1152: ,p_ws_mx_val in number default hr_api.g_number

Line 1149: ,p_elig_flag in varchar2 default hr_api.g_varchar2

1145: ,p_group_oipl_id in number default hr_api.g_number
1146: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
1147: ,p_person_id in number default hr_api.g_number
1148: ,p_assignment_id in number default hr_api.g_number
1149: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1150: ,p_ws_val in number default hr_api.g_number
1151: ,p_ws_mn_val in number default hr_api.g_number
1152: ,p_ws_mx_val in number default hr_api.g_number
1153: ,p_ws_incr_val in number default hr_api.g_number

Line 1150: ,p_ws_val in number default hr_api.g_number

1146: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
1147: ,p_person_id in number default hr_api.g_number
1148: ,p_assignment_id in number default hr_api.g_number
1149: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1150: ,p_ws_val in number default hr_api.g_number
1151: ,p_ws_mn_val in number default hr_api.g_number
1152: ,p_ws_mx_val in number default hr_api.g_number
1153: ,p_ws_incr_val in number default hr_api.g_number
1154: ,p_elig_sal_val in number default hr_api.g_number

Line 1151: ,p_ws_mn_val in number default hr_api.g_number

1147: ,p_person_id in number default hr_api.g_number
1148: ,p_assignment_id in number default hr_api.g_number
1149: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1150: ,p_ws_val in number default hr_api.g_number
1151: ,p_ws_mn_val in number default hr_api.g_number
1152: ,p_ws_mx_val in number default hr_api.g_number
1153: ,p_ws_incr_val in number default hr_api.g_number
1154: ,p_elig_sal_val in number default hr_api.g_number
1155: ,p_stat_sal_val in number default hr_api.g_number

Line 1152: ,p_ws_mx_val in number default hr_api.g_number

1148: ,p_assignment_id in number default hr_api.g_number
1149: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1150: ,p_ws_val in number default hr_api.g_number
1151: ,p_ws_mn_val in number default hr_api.g_number
1152: ,p_ws_mx_val in number default hr_api.g_number
1153: ,p_ws_incr_val in number default hr_api.g_number
1154: ,p_elig_sal_val in number default hr_api.g_number
1155: ,p_stat_sal_val in number default hr_api.g_number
1156: ,p_oth_comp_val in number default hr_api.g_number

Line 1153: ,p_ws_incr_val in number default hr_api.g_number

1149: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1150: ,p_ws_val in number default hr_api.g_number
1151: ,p_ws_mn_val in number default hr_api.g_number
1152: ,p_ws_mx_val in number default hr_api.g_number
1153: ,p_ws_incr_val in number default hr_api.g_number
1154: ,p_elig_sal_val in number default hr_api.g_number
1155: ,p_stat_sal_val in number default hr_api.g_number
1156: ,p_oth_comp_val in number default hr_api.g_number
1157: ,p_tot_comp_val in number default hr_api.g_number

Line 1154: ,p_elig_sal_val in number default hr_api.g_number

1150: ,p_ws_val in number default hr_api.g_number
1151: ,p_ws_mn_val in number default hr_api.g_number
1152: ,p_ws_mx_val in number default hr_api.g_number
1153: ,p_ws_incr_val in number default hr_api.g_number
1154: ,p_elig_sal_val in number default hr_api.g_number
1155: ,p_stat_sal_val in number default hr_api.g_number
1156: ,p_oth_comp_val in number default hr_api.g_number
1157: ,p_tot_comp_val in number default hr_api.g_number
1158: ,p_misc1_val in number default hr_api.g_number

Line 1155: ,p_stat_sal_val in number default hr_api.g_number

1151: ,p_ws_mn_val in number default hr_api.g_number
1152: ,p_ws_mx_val in number default hr_api.g_number
1153: ,p_ws_incr_val in number default hr_api.g_number
1154: ,p_elig_sal_val in number default hr_api.g_number
1155: ,p_stat_sal_val in number default hr_api.g_number
1156: ,p_oth_comp_val in number default hr_api.g_number
1157: ,p_tot_comp_val in number default hr_api.g_number
1158: ,p_misc1_val in number default hr_api.g_number
1159: ,p_misc2_val in number default hr_api.g_number

Line 1156: ,p_oth_comp_val in number default hr_api.g_number

1152: ,p_ws_mx_val in number default hr_api.g_number
1153: ,p_ws_incr_val in number default hr_api.g_number
1154: ,p_elig_sal_val in number default hr_api.g_number
1155: ,p_stat_sal_val in number default hr_api.g_number
1156: ,p_oth_comp_val in number default hr_api.g_number
1157: ,p_tot_comp_val in number default hr_api.g_number
1158: ,p_misc1_val in number default hr_api.g_number
1159: ,p_misc2_val in number default hr_api.g_number
1160: ,p_misc3_val in number default hr_api.g_number

Line 1157: ,p_tot_comp_val in number default hr_api.g_number

1153: ,p_ws_incr_val in number default hr_api.g_number
1154: ,p_elig_sal_val in number default hr_api.g_number
1155: ,p_stat_sal_val in number default hr_api.g_number
1156: ,p_oth_comp_val in number default hr_api.g_number
1157: ,p_tot_comp_val in number default hr_api.g_number
1158: ,p_misc1_val in number default hr_api.g_number
1159: ,p_misc2_val in number default hr_api.g_number
1160: ,p_misc3_val in number default hr_api.g_number
1161: ,p_rec_val in number default hr_api.g_number

Line 1158: ,p_misc1_val in number default hr_api.g_number

1154: ,p_elig_sal_val in number default hr_api.g_number
1155: ,p_stat_sal_val in number default hr_api.g_number
1156: ,p_oth_comp_val in number default hr_api.g_number
1157: ,p_tot_comp_val in number default hr_api.g_number
1158: ,p_misc1_val in number default hr_api.g_number
1159: ,p_misc2_val in number default hr_api.g_number
1160: ,p_misc3_val in number default hr_api.g_number
1161: ,p_rec_val in number default hr_api.g_number
1162: ,p_rec_mn_val in number default hr_api.g_number

Line 1159: ,p_misc2_val in number default hr_api.g_number

1155: ,p_stat_sal_val in number default hr_api.g_number
1156: ,p_oth_comp_val in number default hr_api.g_number
1157: ,p_tot_comp_val in number default hr_api.g_number
1158: ,p_misc1_val in number default hr_api.g_number
1159: ,p_misc2_val in number default hr_api.g_number
1160: ,p_misc3_val in number default hr_api.g_number
1161: ,p_rec_val in number default hr_api.g_number
1162: ,p_rec_mn_val in number default hr_api.g_number
1163: ,p_rec_mx_val in number default hr_api.g_number

Line 1160: ,p_misc3_val in number default hr_api.g_number

1156: ,p_oth_comp_val in number default hr_api.g_number
1157: ,p_tot_comp_val in number default hr_api.g_number
1158: ,p_misc1_val in number default hr_api.g_number
1159: ,p_misc2_val in number default hr_api.g_number
1160: ,p_misc3_val in number default hr_api.g_number
1161: ,p_rec_val in number default hr_api.g_number
1162: ,p_rec_mn_val in number default hr_api.g_number
1163: ,p_rec_mx_val in number default hr_api.g_number
1164: ,p_rec_incr_val in number default hr_api.g_number

Line 1161: ,p_rec_val in number default hr_api.g_number

1157: ,p_tot_comp_val in number default hr_api.g_number
1158: ,p_misc1_val in number default hr_api.g_number
1159: ,p_misc2_val in number default hr_api.g_number
1160: ,p_misc3_val in number default hr_api.g_number
1161: ,p_rec_val in number default hr_api.g_number
1162: ,p_rec_mn_val in number default hr_api.g_number
1163: ,p_rec_mx_val in number default hr_api.g_number
1164: ,p_rec_incr_val in number default hr_api.g_number
1165: ,p_ws_val_last_upd_date in date default hr_api.g_date

Line 1162: ,p_rec_mn_val in number default hr_api.g_number

1158: ,p_misc1_val in number default hr_api.g_number
1159: ,p_misc2_val in number default hr_api.g_number
1160: ,p_misc3_val in number default hr_api.g_number
1161: ,p_rec_val in number default hr_api.g_number
1162: ,p_rec_mn_val in number default hr_api.g_number
1163: ,p_rec_mx_val in number default hr_api.g_number
1164: ,p_rec_incr_val in number default hr_api.g_number
1165: ,p_ws_val_last_upd_date in date default hr_api.g_date
1166: ,p_ws_val_last_upd_by in number default hr_api.g_number

Line 1163: ,p_rec_mx_val in number default hr_api.g_number

1159: ,p_misc2_val in number default hr_api.g_number
1160: ,p_misc3_val in number default hr_api.g_number
1161: ,p_rec_val in number default hr_api.g_number
1162: ,p_rec_mn_val in number default hr_api.g_number
1163: ,p_rec_mx_val in number default hr_api.g_number
1164: ,p_rec_incr_val in number default hr_api.g_number
1165: ,p_ws_val_last_upd_date in date default hr_api.g_date
1166: ,p_ws_val_last_upd_by in number default hr_api.g_number
1167: ,p_pay_proposal_id in number default hr_api.g_number

Line 1164: ,p_rec_incr_val in number default hr_api.g_number

1160: ,p_misc3_val in number default hr_api.g_number
1161: ,p_rec_val in number default hr_api.g_number
1162: ,p_rec_mn_val in number default hr_api.g_number
1163: ,p_rec_mx_val in number default hr_api.g_number
1164: ,p_rec_incr_val in number default hr_api.g_number
1165: ,p_ws_val_last_upd_date in date default hr_api.g_date
1166: ,p_ws_val_last_upd_by in number default hr_api.g_number
1167: ,p_pay_proposal_id in number default hr_api.g_number
1168: ,p_element_entry_value_id in number default hr_api.g_number

Line 1165: ,p_ws_val_last_upd_date in date default hr_api.g_date

1161: ,p_rec_val in number default hr_api.g_number
1162: ,p_rec_mn_val in number default hr_api.g_number
1163: ,p_rec_mx_val in number default hr_api.g_number
1164: ,p_rec_incr_val in number default hr_api.g_number
1165: ,p_ws_val_last_upd_date in date default hr_api.g_date
1166: ,p_ws_val_last_upd_by in number default hr_api.g_number
1167: ,p_pay_proposal_id in number default hr_api.g_number
1168: ,p_element_entry_value_id in number default hr_api.g_number
1169: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2

Line 1166: ,p_ws_val_last_upd_by in number default hr_api.g_number

1162: ,p_rec_mn_val in number default hr_api.g_number
1163: ,p_rec_mx_val in number default hr_api.g_number
1164: ,p_rec_incr_val in number default hr_api.g_number
1165: ,p_ws_val_last_upd_date in date default hr_api.g_date
1166: ,p_ws_val_last_upd_by in number default hr_api.g_number
1167: ,p_pay_proposal_id in number default hr_api.g_number
1168: ,p_element_entry_value_id in number default hr_api.g_number
1169: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1170: ,p_elig_ovrid_dt in date default hr_api.g_date

Line 1167: ,p_pay_proposal_id in number default hr_api.g_number

1163: ,p_rec_mx_val in number default hr_api.g_number
1164: ,p_rec_incr_val in number default hr_api.g_number
1165: ,p_ws_val_last_upd_date in date default hr_api.g_date
1166: ,p_ws_val_last_upd_by in number default hr_api.g_number
1167: ,p_pay_proposal_id in number default hr_api.g_number
1168: ,p_element_entry_value_id in number default hr_api.g_number
1169: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1170: ,p_elig_ovrid_dt in date default hr_api.g_date
1171: ,p_elig_ovrid_person_id in number default hr_api.g_number

Line 1168: ,p_element_entry_value_id in number default hr_api.g_number

1164: ,p_rec_incr_val in number default hr_api.g_number
1165: ,p_ws_val_last_upd_date in date default hr_api.g_date
1166: ,p_ws_val_last_upd_by in number default hr_api.g_number
1167: ,p_pay_proposal_id in number default hr_api.g_number
1168: ,p_element_entry_value_id in number default hr_api.g_number
1169: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1170: ,p_elig_ovrid_dt in date default hr_api.g_date
1171: ,p_elig_ovrid_person_id in number default hr_api.g_number
1172: ,p_copy_dist_bdgt_val in number default hr_api.g_number

Line 1169: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2

1165: ,p_ws_val_last_upd_date in date default hr_api.g_date
1166: ,p_ws_val_last_upd_by in number default hr_api.g_number
1167: ,p_pay_proposal_id in number default hr_api.g_number
1168: ,p_element_entry_value_id in number default hr_api.g_number
1169: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1170: ,p_elig_ovrid_dt in date default hr_api.g_date
1171: ,p_elig_ovrid_person_id in number default hr_api.g_number
1172: ,p_copy_dist_bdgt_val in number default hr_api.g_number
1173: ,p_copy_ws_bdgt_val in number default hr_api.g_number

Line 1170: ,p_elig_ovrid_dt in date default hr_api.g_date

1166: ,p_ws_val_last_upd_by in number default hr_api.g_number
1167: ,p_pay_proposal_id in number default hr_api.g_number
1168: ,p_element_entry_value_id in number default hr_api.g_number
1169: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1170: ,p_elig_ovrid_dt in date default hr_api.g_date
1171: ,p_elig_ovrid_person_id in number default hr_api.g_number
1172: ,p_copy_dist_bdgt_val in number default hr_api.g_number
1173: ,p_copy_ws_bdgt_val in number default hr_api.g_number
1174: ,p_copy_rsrv_val in number default hr_api.g_number

Line 1171: ,p_elig_ovrid_person_id in number default hr_api.g_number

1167: ,p_pay_proposal_id in number default hr_api.g_number
1168: ,p_element_entry_value_id in number default hr_api.g_number
1169: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1170: ,p_elig_ovrid_dt in date default hr_api.g_date
1171: ,p_elig_ovrid_person_id in number default hr_api.g_number
1172: ,p_copy_dist_bdgt_val in number default hr_api.g_number
1173: ,p_copy_ws_bdgt_val in number default hr_api.g_number
1174: ,p_copy_rsrv_val in number default hr_api.g_number
1175: ,p_copy_dist_bdgt_mn_val in number default hr_api.g_number

Line 1172: ,p_copy_dist_bdgt_val in number default hr_api.g_number

1168: ,p_element_entry_value_id in number default hr_api.g_number
1169: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1170: ,p_elig_ovrid_dt in date default hr_api.g_date
1171: ,p_elig_ovrid_person_id in number default hr_api.g_number
1172: ,p_copy_dist_bdgt_val in number default hr_api.g_number
1173: ,p_copy_ws_bdgt_val in number default hr_api.g_number
1174: ,p_copy_rsrv_val in number default hr_api.g_number
1175: ,p_copy_dist_bdgt_mn_val in number default hr_api.g_number
1176: ,p_copy_dist_bdgt_mx_val in number default hr_api.g_number

Line 1173: ,p_copy_ws_bdgt_val in number default hr_api.g_number

1169: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1170: ,p_elig_ovrid_dt in date default hr_api.g_date
1171: ,p_elig_ovrid_person_id in number default hr_api.g_number
1172: ,p_copy_dist_bdgt_val in number default hr_api.g_number
1173: ,p_copy_ws_bdgt_val in number default hr_api.g_number
1174: ,p_copy_rsrv_val in number default hr_api.g_number
1175: ,p_copy_dist_bdgt_mn_val in number default hr_api.g_number
1176: ,p_copy_dist_bdgt_mx_val in number default hr_api.g_number
1177: ,p_copy_dist_bdgt_incr_val in number default hr_api.g_number

Line 1174: ,p_copy_rsrv_val in number default hr_api.g_number

1170: ,p_elig_ovrid_dt in date default hr_api.g_date
1171: ,p_elig_ovrid_person_id in number default hr_api.g_number
1172: ,p_copy_dist_bdgt_val in number default hr_api.g_number
1173: ,p_copy_ws_bdgt_val in number default hr_api.g_number
1174: ,p_copy_rsrv_val in number default hr_api.g_number
1175: ,p_copy_dist_bdgt_mn_val in number default hr_api.g_number
1176: ,p_copy_dist_bdgt_mx_val in number default hr_api.g_number
1177: ,p_copy_dist_bdgt_incr_val in number default hr_api.g_number
1178: ,p_copy_ws_bdgt_mn_val in number default hr_api.g_number

Line 1175: ,p_copy_dist_bdgt_mn_val in number default hr_api.g_number

1171: ,p_elig_ovrid_person_id in number default hr_api.g_number
1172: ,p_copy_dist_bdgt_val in number default hr_api.g_number
1173: ,p_copy_ws_bdgt_val in number default hr_api.g_number
1174: ,p_copy_rsrv_val in number default hr_api.g_number
1175: ,p_copy_dist_bdgt_mn_val in number default hr_api.g_number
1176: ,p_copy_dist_bdgt_mx_val in number default hr_api.g_number
1177: ,p_copy_dist_bdgt_incr_val in number default hr_api.g_number
1178: ,p_copy_ws_bdgt_mn_val in number default hr_api.g_number
1179: ,p_copy_ws_bdgt_mx_val in number default hr_api.g_number

Line 1176: ,p_copy_dist_bdgt_mx_val in number default hr_api.g_number

1172: ,p_copy_dist_bdgt_val in number default hr_api.g_number
1173: ,p_copy_ws_bdgt_val in number default hr_api.g_number
1174: ,p_copy_rsrv_val in number default hr_api.g_number
1175: ,p_copy_dist_bdgt_mn_val in number default hr_api.g_number
1176: ,p_copy_dist_bdgt_mx_val in number default hr_api.g_number
1177: ,p_copy_dist_bdgt_incr_val in number default hr_api.g_number
1178: ,p_copy_ws_bdgt_mn_val in number default hr_api.g_number
1179: ,p_copy_ws_bdgt_mx_val in number default hr_api.g_number
1180: ,p_copy_ws_bdgt_incr_val in number default hr_api.g_number

Line 1177: ,p_copy_dist_bdgt_incr_val in number default hr_api.g_number

1173: ,p_copy_ws_bdgt_val in number default hr_api.g_number
1174: ,p_copy_rsrv_val in number default hr_api.g_number
1175: ,p_copy_dist_bdgt_mn_val in number default hr_api.g_number
1176: ,p_copy_dist_bdgt_mx_val in number default hr_api.g_number
1177: ,p_copy_dist_bdgt_incr_val in number default hr_api.g_number
1178: ,p_copy_ws_bdgt_mn_val in number default hr_api.g_number
1179: ,p_copy_ws_bdgt_mx_val in number default hr_api.g_number
1180: ,p_copy_ws_bdgt_incr_val in number default hr_api.g_number
1181: ,p_copy_rsrv_mn_val in number default hr_api.g_number

Line 1178: ,p_copy_ws_bdgt_mn_val in number default hr_api.g_number

1174: ,p_copy_rsrv_val in number default hr_api.g_number
1175: ,p_copy_dist_bdgt_mn_val in number default hr_api.g_number
1176: ,p_copy_dist_bdgt_mx_val in number default hr_api.g_number
1177: ,p_copy_dist_bdgt_incr_val in number default hr_api.g_number
1178: ,p_copy_ws_bdgt_mn_val in number default hr_api.g_number
1179: ,p_copy_ws_bdgt_mx_val in number default hr_api.g_number
1180: ,p_copy_ws_bdgt_incr_val in number default hr_api.g_number
1181: ,p_copy_rsrv_mn_val in number default hr_api.g_number
1182: ,p_copy_rsrv_mx_val in number default hr_api.g_number

Line 1179: ,p_copy_ws_bdgt_mx_val in number default hr_api.g_number

1175: ,p_copy_dist_bdgt_mn_val in number default hr_api.g_number
1176: ,p_copy_dist_bdgt_mx_val in number default hr_api.g_number
1177: ,p_copy_dist_bdgt_incr_val in number default hr_api.g_number
1178: ,p_copy_ws_bdgt_mn_val in number default hr_api.g_number
1179: ,p_copy_ws_bdgt_mx_val in number default hr_api.g_number
1180: ,p_copy_ws_bdgt_incr_val in number default hr_api.g_number
1181: ,p_copy_rsrv_mn_val in number default hr_api.g_number
1182: ,p_copy_rsrv_mx_val in number default hr_api.g_number
1183: ,p_copy_rsrv_incr_val in number default hr_api.g_number

Line 1180: ,p_copy_ws_bdgt_incr_val in number default hr_api.g_number

1176: ,p_copy_dist_bdgt_mx_val in number default hr_api.g_number
1177: ,p_copy_dist_bdgt_incr_val in number default hr_api.g_number
1178: ,p_copy_ws_bdgt_mn_val in number default hr_api.g_number
1179: ,p_copy_ws_bdgt_mx_val in number default hr_api.g_number
1180: ,p_copy_ws_bdgt_incr_val in number default hr_api.g_number
1181: ,p_copy_rsrv_mn_val in number default hr_api.g_number
1182: ,p_copy_rsrv_mx_val in number default hr_api.g_number
1183: ,p_copy_rsrv_incr_val in number default hr_api.g_number
1184: ,p_copy_dist_bdgt_iss_val in number default hr_api.g_number

Line 1181: ,p_copy_rsrv_mn_val in number default hr_api.g_number

1177: ,p_copy_dist_bdgt_incr_val in number default hr_api.g_number
1178: ,p_copy_ws_bdgt_mn_val in number default hr_api.g_number
1179: ,p_copy_ws_bdgt_mx_val in number default hr_api.g_number
1180: ,p_copy_ws_bdgt_incr_val in number default hr_api.g_number
1181: ,p_copy_rsrv_mn_val in number default hr_api.g_number
1182: ,p_copy_rsrv_mx_val in number default hr_api.g_number
1183: ,p_copy_rsrv_incr_val in number default hr_api.g_number
1184: ,p_copy_dist_bdgt_iss_val in number default hr_api.g_number
1185: ,p_copy_ws_bdgt_iss_val in number default hr_api.g_number

Line 1182: ,p_copy_rsrv_mx_val in number default hr_api.g_number

1178: ,p_copy_ws_bdgt_mn_val in number default hr_api.g_number
1179: ,p_copy_ws_bdgt_mx_val in number default hr_api.g_number
1180: ,p_copy_ws_bdgt_incr_val in number default hr_api.g_number
1181: ,p_copy_rsrv_mn_val in number default hr_api.g_number
1182: ,p_copy_rsrv_mx_val in number default hr_api.g_number
1183: ,p_copy_rsrv_incr_val in number default hr_api.g_number
1184: ,p_copy_dist_bdgt_iss_val in number default hr_api.g_number
1185: ,p_copy_ws_bdgt_iss_val in number default hr_api.g_number
1186: ,p_copy_dist_bdgt_iss_date in date default hr_api.g_date

Line 1183: ,p_copy_rsrv_incr_val in number default hr_api.g_number

1179: ,p_copy_ws_bdgt_mx_val in number default hr_api.g_number
1180: ,p_copy_ws_bdgt_incr_val in number default hr_api.g_number
1181: ,p_copy_rsrv_mn_val in number default hr_api.g_number
1182: ,p_copy_rsrv_mx_val in number default hr_api.g_number
1183: ,p_copy_rsrv_incr_val in number default hr_api.g_number
1184: ,p_copy_dist_bdgt_iss_val in number default hr_api.g_number
1185: ,p_copy_ws_bdgt_iss_val in number default hr_api.g_number
1186: ,p_copy_dist_bdgt_iss_date in date default hr_api.g_date
1187: ,p_copy_ws_bdgt_iss_date in date default hr_api.g_date

Line 1184: ,p_copy_dist_bdgt_iss_val in number default hr_api.g_number

1180: ,p_copy_ws_bdgt_incr_val in number default hr_api.g_number
1181: ,p_copy_rsrv_mn_val in number default hr_api.g_number
1182: ,p_copy_rsrv_mx_val in number default hr_api.g_number
1183: ,p_copy_rsrv_incr_val in number default hr_api.g_number
1184: ,p_copy_dist_bdgt_iss_val in number default hr_api.g_number
1185: ,p_copy_ws_bdgt_iss_val in number default hr_api.g_number
1186: ,p_copy_dist_bdgt_iss_date in date default hr_api.g_date
1187: ,p_copy_ws_bdgt_iss_date in date default hr_api.g_date
1188: ,p_comp_posting_date in date default hr_api.g_date

Line 1185: ,p_copy_ws_bdgt_iss_val in number default hr_api.g_number

1181: ,p_copy_rsrv_mn_val in number default hr_api.g_number
1182: ,p_copy_rsrv_mx_val in number default hr_api.g_number
1183: ,p_copy_rsrv_incr_val in number default hr_api.g_number
1184: ,p_copy_dist_bdgt_iss_val in number default hr_api.g_number
1185: ,p_copy_ws_bdgt_iss_val in number default hr_api.g_number
1186: ,p_copy_dist_bdgt_iss_date in date default hr_api.g_date
1187: ,p_copy_ws_bdgt_iss_date in date default hr_api.g_date
1188: ,p_comp_posting_date in date default hr_api.g_date
1189: ,p_ws_rt_start_date in date default hr_api.g_date

Line 1186: ,p_copy_dist_bdgt_iss_date in date default hr_api.g_date

1182: ,p_copy_rsrv_mx_val in number default hr_api.g_number
1183: ,p_copy_rsrv_incr_val in number default hr_api.g_number
1184: ,p_copy_dist_bdgt_iss_val in number default hr_api.g_number
1185: ,p_copy_ws_bdgt_iss_val in number default hr_api.g_number
1186: ,p_copy_dist_bdgt_iss_date in date default hr_api.g_date
1187: ,p_copy_ws_bdgt_iss_date in date default hr_api.g_date
1188: ,p_comp_posting_date in date default hr_api.g_date
1189: ,p_ws_rt_start_date in date default hr_api.g_date
1190: ,p_currency in varchar2 default hr_api.g_varchar2

Line 1187: ,p_copy_ws_bdgt_iss_date in date default hr_api.g_date

1183: ,p_copy_rsrv_incr_val in number default hr_api.g_number
1184: ,p_copy_dist_bdgt_iss_val in number default hr_api.g_number
1185: ,p_copy_ws_bdgt_iss_val in number default hr_api.g_number
1186: ,p_copy_dist_bdgt_iss_date in date default hr_api.g_date
1187: ,p_copy_ws_bdgt_iss_date in date default hr_api.g_date
1188: ,p_comp_posting_date in date default hr_api.g_date
1189: ,p_ws_rt_start_date in date default hr_api.g_date
1190: ,p_currency in varchar2 default hr_api.g_varchar2
1191: ,p_perf_min_max_edit in varchar2 default 'Y'

Line 1188: ,p_comp_posting_date in date default hr_api.g_date

1184: ,p_copy_dist_bdgt_iss_val in number default hr_api.g_number
1185: ,p_copy_ws_bdgt_iss_val in number default hr_api.g_number
1186: ,p_copy_dist_bdgt_iss_date in date default hr_api.g_date
1187: ,p_copy_ws_bdgt_iss_date in date default hr_api.g_date
1188: ,p_comp_posting_date in date default hr_api.g_date
1189: ,p_ws_rt_start_date in date default hr_api.g_date
1190: ,p_currency in varchar2 default hr_api.g_varchar2
1191: ,p_perf_min_max_edit in varchar2 default 'Y'
1192: ,p_object_version_number in out nocopy number

Line 1189: ,p_ws_rt_start_date in date default hr_api.g_date

1185: ,p_copy_ws_bdgt_iss_val in number default hr_api.g_number
1186: ,p_copy_dist_bdgt_iss_date in date default hr_api.g_date
1187: ,p_copy_ws_bdgt_iss_date in date default hr_api.g_date
1188: ,p_comp_posting_date in date default hr_api.g_date
1189: ,p_ws_rt_start_date in date default hr_api.g_date
1190: ,p_currency in varchar2 default hr_api.g_varchar2
1191: ,p_perf_min_max_edit in varchar2 default 'Y'
1192: ,p_object_version_number in out nocopy number
1193: ) is

Line 1190: ,p_currency in varchar2 default hr_api.g_varchar2

1186: ,p_copy_dist_bdgt_iss_date in date default hr_api.g_date
1187: ,p_copy_ws_bdgt_iss_date in date default hr_api.g_date
1188: ,p_comp_posting_date in date default hr_api.g_date
1189: ,p_ws_rt_start_date in date default hr_api.g_date
1190: ,p_currency in varchar2 default hr_api.g_varchar2
1191: ,p_perf_min_max_edit in varchar2 default 'Y'
1192: ,p_object_version_number in out nocopy number
1193: ) is
1194: --

Line 1291: when hr_api.cannot_find_prog_unit then

1287: ,p_currency => p_currency
1288: ,p_object_version_number => l_object_version_number
1289: );
1290: exception
1291: when hr_api.cannot_find_prog_unit then
1292: hr_api.cannot_find_prog_unit_error
1293: (p_module_name => 'UPDATE_PERSON_RATE'
1294: ,p_hook_type => 'BP'
1295: );

Line 1292: hr_api.cannot_find_prog_unit_error

1288: ,p_object_version_number => l_object_version_number
1289: );
1290: exception
1291: when hr_api.cannot_find_prog_unit then
1292: hr_api.cannot_find_prog_unit_error
1293: (p_module_name => 'UPDATE_PERSON_RATE'
1294: ,p_hook_type => 'BP'
1295: );
1296: end;

Line 1311: if (p_ws_mx_val <> hr_api.g_number) then

1307: --
1308: if (p_ws_mx_val is null) then
1309: l_mn_mx_vals.ws_mx_val := null;
1310: end if;
1311: if (p_ws_mx_val <> hr_api.g_number) then
1312: l_mn_mx_vals.ws_mx_val := p_ws_mx_val;
1313: end if;
1314: --
1315: if (p_ws_mn_val is null) then

Line 1318: if (p_ws_mn_val <> hr_api.g_number) then

1314: --
1315: if (p_ws_mn_val is null) then
1316: l_mn_mx_vals.ws_mn_val := null;
1317: end if;
1318: if (p_ws_mn_val <> hr_api.g_number) then
1319: l_mn_mx_vals.ws_mn_val := p_ws_mn_val;
1320: end if;
1321: --
1322: if (p_ws_incr_val is null) then

Line 1325: if (p_ws_incr_val <> hr_api.g_number) then

1321: --
1322: if (p_ws_incr_val is null) then
1323: l_mn_mx_vals.ws_incr_val := null;
1324: end if;
1325: if (p_ws_incr_val <> hr_api.g_number) then
1326: l_mn_mx_vals.ws_incr_val := p_ws_incr_val;
1327: end if;
1328: --
1329: --

Line 1337: if (p_rec_mx_val <> hr_api.g_number) then

1333: --
1334: if (p_rec_mx_val is null) then
1335: l_mn_mx_vals.rec_mx_val := null;
1336: end if;
1337: if (p_rec_mx_val <> hr_api.g_number) then
1338: l_mn_mx_vals.rec_mx_val := p_rec_mx_val;
1339: end if;
1340: --
1341: if (p_rec_mn_val is null) then

Line 1344: if (p_rec_mn_val <> hr_api.g_number) then

1340: --
1341: if (p_rec_mn_val is null) then
1342: l_mn_mx_vals.rec_mn_val := null;
1343: end if;
1344: if (p_rec_mn_val <> hr_api.g_number) then
1345: l_mn_mx_vals.rec_mn_val := p_rec_mn_val;
1346: end if;
1347: --
1348: if (p_rec_incr_val is null) then

Line 1351: if (p_rec_incr_val <> hr_api.g_number) then

1347: --
1348: if (p_rec_incr_val is null) then
1349: l_mn_mx_vals.rec_incr_val := null;
1350: end if;
1351: if (p_rec_incr_val <> hr_api.g_number) then
1352: l_mn_mx_vals.rec_incr_val := p_rec_incr_val;
1353: end if;
1354: --
1355: if g_debug then

Line 1499: when hr_api.cannot_find_prog_unit then

1495: ,p_currency => p_currency
1496: ,p_object_version_number => l_object_version_number
1497: );
1498: exception
1499: when hr_api.cannot_find_prog_unit then
1500: hr_api.cannot_find_prog_unit_error
1501: (p_module_name => 'UPDATE_PERSON_RATE'
1502: ,p_hook_type => 'AP'
1503: );

Line 1500: hr_api.cannot_find_prog_unit_error

1496: ,p_object_version_number => l_object_version_number
1497: );
1498: exception
1499: when hr_api.cannot_find_prog_unit then
1500: hr_api.cannot_find_prog_unit_error
1501: (p_module_name => 'UPDATE_PERSON_RATE'
1502: ,p_hook_type => 'AP'
1503: );
1504: end;

Line 1509: raise hr_api.validate_enabled;

1505: --
1506: -- When in validation only mode raise the Validate_Enabled exception
1507: --
1508: if p_validate then
1509: raise hr_api.validate_enabled;
1510: end if;
1511: --
1512: -- Update is successful. So call the update_rates_summary to process
1513: -- the summary information

Line 1531: when hr_api.validate_enabled then

1527: if g_debug then
1528: hr_utility.set_location(' Leaving:'||l_proc, 70);
1529: end if;
1530: exception
1531: when hr_api.validate_enabled then
1532: --
1533: -- As the Validate_Enabled exception has been raised
1534: -- we must rollback to the savepoint
1535: --

Line 1597: when hr_api.cannot_find_prog_unit then

1593: ,p_oipl_id => p_oipl_id
1594: ,p_object_version_number => p_object_version_number
1595: );
1596: exception
1597: when hr_api.cannot_find_prog_unit then
1598: hr_api.cannot_find_prog_unit_error
1599: (p_module_name => 'DELETE_PERSON_RATE'
1600: ,p_hook_type => 'BP'
1601: );

Line 1598: hr_api.cannot_find_prog_unit_error

1594: ,p_object_version_number => p_object_version_number
1595: );
1596: exception
1597: when hr_api.cannot_find_prog_unit then
1598: hr_api.cannot_find_prog_unit_error
1599: (p_module_name => 'DELETE_PERSON_RATE'
1600: ,p_hook_type => 'BP'
1601: );
1602: end;

Line 1627: when hr_api.cannot_find_prog_unit then

1623: ,p_oipl_id => p_oipl_id
1624: ,p_object_version_number => p_object_version_number
1625: );
1626: exception
1627: when hr_api.cannot_find_prog_unit then
1628: hr_api.cannot_find_prog_unit_error
1629: (p_module_name => 'DELETE_PERSON_RATE'
1630: ,p_hook_type => 'AP'
1631: );

Line 1628: hr_api.cannot_find_prog_unit_error

1624: ,p_object_version_number => p_object_version_number
1625: );
1626: exception
1627: when hr_api.cannot_find_prog_unit then
1628: hr_api.cannot_find_prog_unit_error
1629: (p_module_name => 'DELETE_PERSON_RATE'
1630: ,p_hook_type => 'AP'
1631: );
1632: end;

Line 1637: raise hr_api.validate_enabled;

1633: --
1634: -- When in validation only mode raise the Validate_Enabled exception
1635: --
1636: if p_validate then
1637: raise hr_api.validate_enabled;
1638: end if;
1639: --
1640: -- Delete is successful. So call the update_rates_summary to process
1641: -- the summary information

Line 1653: when hr_api.validate_enabled then

1649: if g_debug then
1650: hr_utility.set_location(' Leaving:'||l_proc, 70);
1651: end if;
1652: exception
1653: when hr_api.validate_enabled then
1654: --
1655: -- As the Validate_Enabled exception has been raised
1656: -- we must rollback to the savepoint
1657: --