APPS.PQP_DET_UPD dependencies on HR_API

Line 104: When hr_api.check_integrity_violated Then

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));

Line 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

Line 109: When hr_api.parent_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
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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

Line 114: When hr_api.unique_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
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

Line 269: when hr_api.cannot_find_prog_unit then

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');

Line 271: hr_api.cannot_find_prog_unit_error

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;

Line 339: If (p_rec.analyzed_data_id = hr_api.g_number) then

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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:

Line 494: p_analyzed_data_id in number default hr_api.g_number,

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,

Line 495: p_income_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,

Line 496: p_withholding_rate 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,

Line 497: p_income_code_sub_type 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,

Line 498: p_exemption_code in varchar2 default hr_api.g_varchar2,

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,

Line 499: p_maximum_benefit_amount 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,
503: p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2,

Line 500: p_retro_lose_ben_amt_flag 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,

Line 501: p_date_benefit_ends in date default hr_api.g_date,

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,

Line 502: p_retro_lose_ben_date_flag 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,

Line 503: p_nra_exempt_from_ss 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,

Line 504: p_nra_exempt_from_medicare 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,

Line 505: p_student_exempt_from_ss 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,
509: p_addl_withholding_amt in number default hr_api.g_number,

Line 506: p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2,

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,

Line 507: p_addl_withholding_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,
511: p_personal_exemption in number default hr_api.g_number,

Line 508: p_constant_addl_tax 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,

Line 509: p_addl_withholding_amt 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,

Line 510: p_addl_wthldng_amt_period_type 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,

Line 511: p_personal_exemption in number default hr_api.g_number,

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 ,

Line 512: p_addl_exemption_allowed in number default hr_api.g_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,

Line 513: p_treaty_ben_allowed_flag 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,

Line 514: p_treaty_benefits_start_date in date default hr_api.g_date,

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

Line 516: p_retro_loss_notification_sent 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: --

Line 517: p_current_analysis in varchar2 default hr_api.g_varchar2,

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;

Line 518: p_forecast_income_code 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;
522: l_proc varchar2(72) := g_package||'upd';