100: --
101: hr_utility.set_location(' Leaving:'||l_proc, 10);
102: --
103: Exception
104: When hr_api.check_integrity_violated Then
105: -- A check constraint has been violated
106: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
107: pqp_det_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.check_integrity_violated Then
105: -- A check constraint has been violated
106: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
107: pqp_det_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
112: pqp_det_shd.constraint_error
105: -- A check constraint has been violated
106: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
107: pqp_det_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
112: pqp_det_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
112: pqp_det_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
117: pqp_det_shd.constraint_error
110: -- Parent integrity has been violated
111: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
112: pqp_det_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
117: pqp_det_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
117: pqp_det_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When Others Then
120: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
121: Raise;
122: End update_dml;
265: );
266: --
267: exception
268: --
269: when hr_api.cannot_find_prog_unit then
270: --
271: hr_api.cannot_find_prog_unit_error
272: (p_module_name => 'PQP_ANALYZED_ALIEN_DET'
273: ,p_hook_type => 'AU');
267: exception
268: --
269: when hr_api.cannot_find_prog_unit then
270: --
271: hr_api.cannot_find_prog_unit_error
272: (p_module_name => 'PQP_ANALYZED_ALIEN_DET'
273: ,p_hook_type => 'AU');
274: --
275: end;
335: -- p_rec plsql record structure
336: -- to see if a system default is being used. If a system default
337: -- is being used then we must set to the 'current' argument value.
338: --
339: If (p_rec.analyzed_data_id = hr_api.g_number) then
340: p_rec.analyzed_data_id :=
341: pqp_det_shd.g_old_rec.analyzed_data_id;
342: End If;
343: If (p_rec.income_code = hr_api.g_varchar2) then
339: If (p_rec.analyzed_data_id = hr_api.g_number) then
340: p_rec.analyzed_data_id :=
341: pqp_det_shd.g_old_rec.analyzed_data_id;
342: End If;
343: If (p_rec.income_code = hr_api.g_varchar2) then
344: p_rec.income_code :=
345: pqp_det_shd.g_old_rec.income_code;
346: End If;
347: If (p_rec.withholding_rate = hr_api.g_number) then
343: If (p_rec.income_code = hr_api.g_varchar2) then
344: p_rec.income_code :=
345: pqp_det_shd.g_old_rec.income_code;
346: End If;
347: If (p_rec.withholding_rate = hr_api.g_number) then
348: p_rec.withholding_rate :=
349: pqp_det_shd.g_old_rec.withholding_rate;
350: End If;
351: If (p_rec.income_code_sub_type = hr_api.g_varchar2) then
347: If (p_rec.withholding_rate = hr_api.g_number) then
348: p_rec.withholding_rate :=
349: pqp_det_shd.g_old_rec.withholding_rate;
350: End If;
351: If (p_rec.income_code_sub_type = hr_api.g_varchar2) then
352: p_rec.income_code_sub_type :=
353: pqp_det_shd.g_old_rec.income_code_sub_type;
354: End If;
355: If (p_rec.exemption_code = hr_api.g_varchar2) then
351: If (p_rec.income_code_sub_type = hr_api.g_varchar2) then
352: p_rec.income_code_sub_type :=
353: pqp_det_shd.g_old_rec.income_code_sub_type;
354: End If;
355: If (p_rec.exemption_code = hr_api.g_varchar2) then
356: p_rec.exemption_code :=
357: pqp_det_shd.g_old_rec.exemption_code;
358: End If;
359: If (p_rec.maximum_benefit_amount = hr_api.g_number) then
355: If (p_rec.exemption_code = hr_api.g_varchar2) then
356: p_rec.exemption_code :=
357: pqp_det_shd.g_old_rec.exemption_code;
358: End If;
359: If (p_rec.maximum_benefit_amount = hr_api.g_number) then
360: p_rec.maximum_benefit_amount :=
361: pqp_det_shd.g_old_rec.maximum_benefit_amount;
362: End If;
363: If (p_rec.retro_lose_ben_amt_flag = hr_api.g_varchar2) then
359: If (p_rec.maximum_benefit_amount = hr_api.g_number) then
360: p_rec.maximum_benefit_amount :=
361: pqp_det_shd.g_old_rec.maximum_benefit_amount;
362: End If;
363: If (p_rec.retro_lose_ben_amt_flag = hr_api.g_varchar2) then
364: p_rec.retro_lose_ben_amt_flag :=
365: pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag;
366: End If;
367: If (p_rec.date_benefit_ends = hr_api.g_date) then
363: If (p_rec.retro_lose_ben_amt_flag = hr_api.g_varchar2) then
364: p_rec.retro_lose_ben_amt_flag :=
365: pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag;
366: End If;
367: If (p_rec.date_benefit_ends = hr_api.g_date) then
368: p_rec.date_benefit_ends :=
369: pqp_det_shd.g_old_rec.date_benefit_ends;
370: End If;
371: If (p_rec.retro_lose_ben_date_flag = hr_api.g_varchar2) then
367: If (p_rec.date_benefit_ends = hr_api.g_date) then
368: p_rec.date_benefit_ends :=
369: pqp_det_shd.g_old_rec.date_benefit_ends;
370: End If;
371: If (p_rec.retro_lose_ben_date_flag = hr_api.g_varchar2) then
372: p_rec.retro_lose_ben_date_flag :=
373: pqp_det_shd.g_old_rec.retro_lose_ben_date_flag;
374: End If;
375: If (p_rec.nra_exempt_from_ss = hr_api.g_varchar2) then
371: If (p_rec.retro_lose_ben_date_flag = hr_api.g_varchar2) then
372: p_rec.retro_lose_ben_date_flag :=
373: pqp_det_shd.g_old_rec.retro_lose_ben_date_flag;
374: End If;
375: If (p_rec.nra_exempt_from_ss = hr_api.g_varchar2) then
376: p_rec.nra_exempt_from_ss :=
377: pqp_det_shd.g_old_rec.nra_exempt_from_ss;
378: End If;
379: If (p_rec.nra_exempt_from_medicare = hr_api.g_varchar2) then
375: If (p_rec.nra_exempt_from_ss = hr_api.g_varchar2) then
376: p_rec.nra_exempt_from_ss :=
377: pqp_det_shd.g_old_rec.nra_exempt_from_ss;
378: End If;
379: If (p_rec.nra_exempt_from_medicare = hr_api.g_varchar2) then
380: p_rec.nra_exempt_from_medicare :=
381: pqp_det_shd.g_old_rec.nra_exempt_from_medicare;
382: End If;
383: If (p_rec.student_exempt_from_ss = hr_api.g_varchar2) then
379: If (p_rec.nra_exempt_from_medicare = hr_api.g_varchar2) then
380: p_rec.nra_exempt_from_medicare :=
381: pqp_det_shd.g_old_rec.nra_exempt_from_medicare;
382: End If;
383: If (p_rec.student_exempt_from_ss = hr_api.g_varchar2) then
384: p_rec.student_exempt_from_ss :=
385: pqp_det_shd.g_old_rec.student_exempt_from_ss;
386: End If;
387: If (p_rec.student_exempt_from_medicare = hr_api.g_varchar2) then
383: If (p_rec.student_exempt_from_ss = hr_api.g_varchar2) then
384: p_rec.student_exempt_from_ss :=
385: pqp_det_shd.g_old_rec.student_exempt_from_ss;
386: End If;
387: If (p_rec.student_exempt_from_medicare = hr_api.g_varchar2) then
388: p_rec.student_exempt_from_medicare :=
389: pqp_det_shd.g_old_rec.student_exempt_from_medicare;
390: End If;
391: If (p_rec.addl_withholding_flag = hr_api.g_varchar2) then
387: If (p_rec.student_exempt_from_medicare = hr_api.g_varchar2) then
388: p_rec.student_exempt_from_medicare :=
389: pqp_det_shd.g_old_rec.student_exempt_from_medicare;
390: End If;
391: If (p_rec.addl_withholding_flag = hr_api.g_varchar2) then
392: p_rec.addl_withholding_flag :=
393: pqp_det_shd.g_old_rec.addl_withholding_flag;
394: End If;
395: If (p_rec.constant_addl_tax = hr_api.g_number) then
391: If (p_rec.addl_withholding_flag = hr_api.g_varchar2) then
392: p_rec.addl_withholding_flag :=
393: pqp_det_shd.g_old_rec.addl_withholding_flag;
394: End If;
395: If (p_rec.constant_addl_tax = hr_api.g_number) then
396: p_rec.constant_addl_tax :=
397: pqp_det_shd.g_old_rec.constant_addl_tax;
398: End If;
399: If (p_rec.addl_withholding_amt = hr_api.g_number) then
395: If (p_rec.constant_addl_tax = hr_api.g_number) then
396: p_rec.constant_addl_tax :=
397: pqp_det_shd.g_old_rec.constant_addl_tax;
398: End If;
399: If (p_rec.addl_withholding_amt = hr_api.g_number) then
400: p_rec.addl_withholding_amt :=
401: pqp_det_shd.g_old_rec.addl_withholding_amt;
402: End If;
403: If (p_rec.addl_wthldng_amt_period_type = hr_api.g_varchar2) then
399: If (p_rec.addl_withholding_amt = hr_api.g_number) then
400: p_rec.addl_withholding_amt :=
401: pqp_det_shd.g_old_rec.addl_withholding_amt;
402: End If;
403: If (p_rec.addl_wthldng_amt_period_type = hr_api.g_varchar2) then
404: p_rec.addl_wthldng_amt_period_type :=
405: pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type;
406: End If;
407: If (p_rec.personal_exemption = hr_api.g_number) then
403: If (p_rec.addl_wthldng_amt_period_type = hr_api.g_varchar2) then
404: p_rec.addl_wthldng_amt_period_type :=
405: pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type;
406: End If;
407: If (p_rec.personal_exemption = hr_api.g_number) then
408: p_rec.personal_exemption :=
409: pqp_det_shd.g_old_rec.personal_exemption;
410: End If;
411: If (p_rec.addl_exemption_allowed = hr_api.g_number) then
407: If (p_rec.personal_exemption = hr_api.g_number) then
408: p_rec.personal_exemption :=
409: pqp_det_shd.g_old_rec.personal_exemption;
410: End If;
411: If (p_rec.addl_exemption_allowed = hr_api.g_number) then
412: p_rec.addl_exemption_allowed :=
413: pqp_det_shd.g_old_rec.addl_exemption_allowed;
414: End If;
415: If (p_rec.treaty_ben_allowed_flag = hr_api.g_varchar2) then
411: If (p_rec.addl_exemption_allowed = hr_api.g_number) then
412: p_rec.addl_exemption_allowed :=
413: pqp_det_shd.g_old_rec.addl_exemption_allowed;
414: End If;
415: If (p_rec.treaty_ben_allowed_flag = hr_api.g_varchar2) then
416: p_rec.treaty_ben_allowed_flag :=
417: pqp_det_shd.g_old_rec.treaty_ben_allowed_flag;
418: End If;
419: If (p_rec.treaty_benefits_start_date = hr_api.g_date) then
415: If (p_rec.treaty_ben_allowed_flag = hr_api.g_varchar2) then
416: p_rec.treaty_ben_allowed_flag :=
417: pqp_det_shd.g_old_rec.treaty_ben_allowed_flag;
418: End If;
419: If (p_rec.treaty_benefits_start_date = hr_api.g_date) then
420: p_rec.treaty_benefits_start_date :=
421: pqp_det_shd.g_old_rec.treaty_benefits_start_date;
422: End If;
423: If (p_rec.retro_loss_notification_sent = hr_api.g_varchar2) then
419: If (p_rec.treaty_benefits_start_date = hr_api.g_date) then
420: p_rec.treaty_benefits_start_date :=
421: pqp_det_shd.g_old_rec.treaty_benefits_start_date;
422: End If;
423: If (p_rec.retro_loss_notification_sent = hr_api.g_varchar2) then
424: p_rec.retro_loss_notification_sent :=
425: pqp_det_shd.g_old_rec.retro_loss_notification_sent;
426: End If;
427: If (p_rec.current_analysis = hr_api.g_varchar2) then
423: If (p_rec.retro_loss_notification_sent = hr_api.g_varchar2) then
424: p_rec.retro_loss_notification_sent :=
425: pqp_det_shd.g_old_rec.retro_loss_notification_sent;
426: End If;
427: If (p_rec.current_analysis = hr_api.g_varchar2) then
428: p_rec.current_analysis :=
429: pqp_det_shd.g_old_rec.current_analysis;
430: End If;
431: If (p_rec.forecast_income_code = hr_api.g_varchar2) then
427: If (p_rec.current_analysis = hr_api.g_varchar2) then
428: p_rec.current_analysis :=
429: pqp_det_shd.g_old_rec.current_analysis;
430: End If;
431: If (p_rec.forecast_income_code = hr_api.g_varchar2) then
432: p_rec.forecast_income_code :=
433: pqp_det_shd.g_old_rec.forecast_income_code;
434: End If;
435:
490: Procedure upd
491: (
492: p_effective_date in date,
493: p_analyzed_data_details_id in number,
494: p_analyzed_data_id in number default hr_api.g_number,
495: p_income_code in varchar2 default hr_api.g_varchar2,
496: p_withholding_rate in number default hr_api.g_number,
497: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,
498: p_exemption_code in varchar2 default hr_api.g_varchar2,
491: (
492: p_effective_date in date,
493: p_analyzed_data_details_id in number,
494: p_analyzed_data_id in number default hr_api.g_number,
495: p_income_code in varchar2 default hr_api.g_varchar2,
496: p_withholding_rate in number default hr_api.g_number,
497: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,
498: p_exemption_code in varchar2 default hr_api.g_varchar2,
499: p_maximum_benefit_amount in number default hr_api.g_number,
492: p_effective_date in date,
493: p_analyzed_data_details_id in number,
494: p_analyzed_data_id in number default hr_api.g_number,
495: p_income_code in varchar2 default hr_api.g_varchar2,
496: p_withholding_rate in number default hr_api.g_number,
497: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,
498: p_exemption_code in varchar2 default hr_api.g_varchar2,
499: p_maximum_benefit_amount in number default hr_api.g_number,
500: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
493: p_analyzed_data_details_id in number,
494: p_analyzed_data_id in number default hr_api.g_number,
495: p_income_code in varchar2 default hr_api.g_varchar2,
496: p_withholding_rate in number default hr_api.g_number,
497: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,
498: p_exemption_code in varchar2 default hr_api.g_varchar2,
499: p_maximum_benefit_amount in number default hr_api.g_number,
500: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
501: p_date_benefit_ends in date default hr_api.g_date,
494: p_analyzed_data_id in number default hr_api.g_number,
495: p_income_code in varchar2 default hr_api.g_varchar2,
496: p_withholding_rate in number default hr_api.g_number,
497: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,
498: p_exemption_code in varchar2 default hr_api.g_varchar2,
499: p_maximum_benefit_amount in number default hr_api.g_number,
500: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
501: p_date_benefit_ends in date default hr_api.g_date,
502: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
495: p_income_code in varchar2 default hr_api.g_varchar2,
496: p_withholding_rate in number default hr_api.g_number,
497: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,
498: p_exemption_code in varchar2 default hr_api.g_varchar2,
499: p_maximum_benefit_amount in number default hr_api.g_number,
500: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
501: p_date_benefit_ends in date default hr_api.g_date,
502: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
503: p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2,
496: p_withholding_rate in number default hr_api.g_number,
497: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,
498: p_exemption_code in varchar2 default hr_api.g_varchar2,
499: p_maximum_benefit_amount in number default hr_api.g_number,
500: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
501: p_date_benefit_ends in date default hr_api.g_date,
502: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
503: p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2,
504: p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2,
497: p_income_code_sub_type in varchar2 default hr_api.g_varchar2,
498: p_exemption_code in varchar2 default hr_api.g_varchar2,
499: p_maximum_benefit_amount in number default hr_api.g_number,
500: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
501: p_date_benefit_ends in date default hr_api.g_date,
502: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
503: p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2,
504: p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2,
505: p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2,
498: p_exemption_code in varchar2 default hr_api.g_varchar2,
499: p_maximum_benefit_amount in number default hr_api.g_number,
500: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
501: p_date_benefit_ends in date default hr_api.g_date,
502: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
503: p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2,
504: p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2,
505: p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2,
506: p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2,
499: p_maximum_benefit_amount in number default hr_api.g_number,
500: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
501: p_date_benefit_ends in date default hr_api.g_date,
502: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
503: p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2,
504: p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2,
505: p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2,
506: p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2,
507: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
500: p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2,
501: p_date_benefit_ends in date default hr_api.g_date,
502: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
503: p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2,
504: p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2,
505: p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2,
506: p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2,
507: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
508: p_constant_addl_tax in number default hr_api.g_number,
501: p_date_benefit_ends in date default hr_api.g_date,
502: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
503: p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2,
504: p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2,
505: p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2,
506: p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2,
507: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
508: p_constant_addl_tax in number default hr_api.g_number,
509: p_addl_withholding_amt in number default hr_api.g_number,
502: p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2,
503: p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2,
504: p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2,
505: p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2,
506: p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2,
507: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
508: p_constant_addl_tax in number default hr_api.g_number,
509: p_addl_withholding_amt in number default hr_api.g_number,
510: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
503: p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2,
504: p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2,
505: p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2,
506: p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2,
507: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
508: p_constant_addl_tax in number default hr_api.g_number,
509: p_addl_withholding_amt in number default hr_api.g_number,
510: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
511: p_personal_exemption in number default hr_api.g_number,
504: p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2,
505: p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2,
506: p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2,
507: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
508: p_constant_addl_tax in number default hr_api.g_number,
509: p_addl_withholding_amt in number default hr_api.g_number,
510: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
511: p_personal_exemption in number default hr_api.g_number,
512: p_addl_exemption_allowed in number default hr_api.g_number,
505: p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2,
506: p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2,
507: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
508: p_constant_addl_tax in number default hr_api.g_number,
509: p_addl_withholding_amt in number default hr_api.g_number,
510: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
511: p_personal_exemption in number default hr_api.g_number,
512: p_addl_exemption_allowed in number default hr_api.g_number,
513: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,
506: p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2,
507: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
508: p_constant_addl_tax in number default hr_api.g_number,
509: p_addl_withholding_amt in number default hr_api.g_number,
510: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
511: p_personal_exemption in number default hr_api.g_number,
512: p_addl_exemption_allowed in number default hr_api.g_number,
513: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,
514: p_treaty_benefits_start_date in date default hr_api.g_date,
507: p_addl_withholding_flag in varchar2 default hr_api.g_varchar2,
508: p_constant_addl_tax in number default hr_api.g_number,
509: p_addl_withholding_amt in number default hr_api.g_number,
510: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
511: p_personal_exemption in number default hr_api.g_number,
512: p_addl_exemption_allowed in number default hr_api.g_number,
513: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,
514: p_treaty_benefits_start_date in date default hr_api.g_date,
515: p_object_version_number in out nocopy number ,
508: p_constant_addl_tax in number default hr_api.g_number,
509: p_addl_withholding_amt in number default hr_api.g_number,
510: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
511: p_personal_exemption in number default hr_api.g_number,
512: p_addl_exemption_allowed in number default hr_api.g_number,
513: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,
514: p_treaty_benefits_start_date in date default hr_api.g_date,
515: p_object_version_number in out nocopy number ,
516: p_retro_loss_notification_sent in varchar2 default hr_api.g_varchar2,
509: p_addl_withholding_amt in number default hr_api.g_number,
510: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
511: p_personal_exemption in number default hr_api.g_number,
512: p_addl_exemption_allowed in number default hr_api.g_number,
513: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,
514: p_treaty_benefits_start_date in date default hr_api.g_date,
515: p_object_version_number in out nocopy number ,
516: p_retro_loss_notification_sent in varchar2 default hr_api.g_varchar2,
517: p_current_analysis in varchar2 default hr_api.g_varchar2,
510: p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2,
511: p_personal_exemption in number default hr_api.g_number,
512: p_addl_exemption_allowed in number default hr_api.g_number,
513: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,
514: p_treaty_benefits_start_date in date default hr_api.g_date,
515: p_object_version_number in out nocopy number ,
516: p_retro_loss_notification_sent in varchar2 default hr_api.g_varchar2,
517: p_current_analysis in varchar2 default hr_api.g_varchar2,
518: p_forecast_income_code in varchar2 default hr_api.g_varchar2
512: p_addl_exemption_allowed in number default hr_api.g_number,
513: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,
514: p_treaty_benefits_start_date in date default hr_api.g_date,
515: p_object_version_number in out nocopy number ,
516: p_retro_loss_notification_sent in varchar2 default hr_api.g_varchar2,
517: p_current_analysis in varchar2 default hr_api.g_varchar2,
518: p_forecast_income_code in varchar2 default hr_api.g_varchar2
519: ) is
520: --
513: p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2,
514: p_treaty_benefits_start_date in date default hr_api.g_date,
515: p_object_version_number in out nocopy number ,
516: p_retro_loss_notification_sent in varchar2 default hr_api.g_varchar2,
517: p_current_analysis in varchar2 default hr_api.g_varchar2,
518: p_forecast_income_code in varchar2 default hr_api.g_varchar2
519: ) is
520: --
521: l_rec pqp_det_shd.g_rec_type;
514: p_treaty_benefits_start_date in date default hr_api.g_date,
515: p_object_version_number in out nocopy number ,
516: p_retro_loss_notification_sent in varchar2 default hr_api.g_varchar2,
517: p_current_analysis in varchar2 default hr_api.g_varchar2,
518: p_forecast_income_code in varchar2 default hr_api.g_varchar2
519: ) is
520: --
521: l_rec pqp_det_shd.g_rec_type;
522: l_proc varchar2(72) := g_package||'upd';