eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_VLD_UPD dependencies on HR_API

Line 97: When hr_api.check_integrity_violated Then

93: --
94: hr_utility.set_location(' Leaving:'||l_proc, 10);
95: --
96: Exception
97: When hr_api.check_integrity_violated Then
98: -- A check constraint has been violated
99: --
100: pqh_vld_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

97: When hr_api.check_integrity_violated Then
98: -- A check constraint has been violated
99: --
100: pqh_vld_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.parent_integrity_violated Then
103: -- Parent integrity has been violated
104: --
105: pqh_vld_shd.constraint_error

Line 102: When hr_api.parent_integrity_violated Then

98: -- A check constraint has been violated
99: --
100: pqh_vld_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.parent_integrity_violated Then
103: -- Parent integrity has been violated
104: --
105: pqh_vld_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

102: When hr_api.parent_integrity_violated Then
103: -- Parent integrity has been violated
104: --
105: pqh_vld_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: --
110: pqh_vld_shd.constraint_error

Line 107: When hr_api.unique_integrity_violated Then

103: -- Parent integrity has been violated
104: --
105: pqh_vld_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: --
110: pqh_vld_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: --
110: pqh_vld_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When Others Then
113: --
114: Raise;
115: End update_dml;

Line 280: when hr_api.cannot_find_prog_unit then

276: );
277: --
278: exception
279: --
280: when hr_api.cannot_find_prog_unit then
281: --
282: hr_api.cannot_find_prog_unit_error
283: (p_module_name => 'PQH_FR_VALIDATIONS'
284: ,p_hook_type => 'AU');

Line 282: hr_api.cannot_find_prog_unit_error

278: exception
279: --
280: when hr_api.cannot_find_prog_unit then
281: --
282: hr_api.cannot_find_prog_unit_error
283: (p_module_name => 'PQH_FR_VALIDATIONS'
284: ,p_hook_type => 'AU');
285: --
286: end;

Line 345: If (p_rec.pension_fund_type_code = hr_api.g_varchar2) then

341: -- p_rec plsql record structure
342: -- to see if a system default is being used. If a system default
343: -- is being used then we must set to the 'current' argument value.
344: --
345: If (p_rec.pension_fund_type_code = hr_api.g_varchar2) then
346: p_rec.pension_fund_type_code :=
347: pqh_vld_shd.g_old_rec.pension_fund_type_code;
348: End If;
349: If (p_rec.pension_fund_id = hr_api.g_number) then

Line 349: If (p_rec.pension_fund_id = hr_api.g_number) then

345: If (p_rec.pension_fund_type_code = hr_api.g_varchar2) then
346: p_rec.pension_fund_type_code :=
347: pqh_vld_shd.g_old_rec.pension_fund_type_code;
348: End If;
349: If (p_rec.pension_fund_id = hr_api.g_number) then
350: p_rec.pension_fund_id :=
351: pqh_vld_shd.g_old_rec.pension_fund_id;
352: End If;
353: If (p_rec.business_group_id = hr_api.g_number) then

Line 353: If (p_rec.business_group_id = hr_api.g_number) then

349: If (p_rec.pension_fund_id = hr_api.g_number) then
350: p_rec.pension_fund_id :=
351: pqh_vld_shd.g_old_rec.pension_fund_id;
352: End If;
353: If (p_rec.business_group_id = hr_api.g_number) then
354: p_rec.business_group_id :=
355: pqh_vld_shd.g_old_rec.business_group_id;
356: End If;
357: If (p_rec.person_id = hr_api.g_number) then

Line 357: If (p_rec.person_id = hr_api.g_number) then

353: If (p_rec.business_group_id = hr_api.g_number) then
354: p_rec.business_group_id :=
355: pqh_vld_shd.g_old_rec.business_group_id;
356: End If;
357: If (p_rec.person_id = hr_api.g_number) then
358: p_rec.person_id :=
359: pqh_vld_shd.g_old_rec.person_id;
360: End If;
361: If (p_rec.request_date = hr_api.g_date) then

Line 361: If (p_rec.request_date = hr_api.g_date) then

357: If (p_rec.person_id = hr_api.g_number) then
358: p_rec.person_id :=
359: pqh_vld_shd.g_old_rec.person_id;
360: End If;
361: If (p_rec.request_date = hr_api.g_date) then
362: p_rec.request_date :=
363: pqh_vld_shd.g_old_rec.request_date;
364: End If;
365: If (p_rec.completion_date = hr_api.g_date) then

Line 365: If (p_rec.completion_date = hr_api.g_date) then

361: If (p_rec.request_date = hr_api.g_date) then
362: p_rec.request_date :=
363: pqh_vld_shd.g_old_rec.request_date;
364: End If;
365: If (p_rec.completion_date = hr_api.g_date) then
366: p_rec.completion_date :=
367: pqh_vld_shd.g_old_rec.completion_date;
368: End If;
369: If (p_rec.previous_employer_id = hr_api.g_number) then

Line 369: If (p_rec.previous_employer_id = hr_api.g_number) then

365: If (p_rec.completion_date = hr_api.g_date) then
366: p_rec.completion_date :=
367: pqh_vld_shd.g_old_rec.completion_date;
368: End If;
369: If (p_rec.previous_employer_id = hr_api.g_number) then
370: p_rec.previous_employer_id :=
371: pqh_vld_shd.g_old_rec.previous_employer_id;
372: End If;
373: If (p_rec.previously_validated_flag = hr_api.g_varchar2) then

Line 373: If (p_rec.previously_validated_flag = hr_api.g_varchar2) then

369: If (p_rec.previous_employer_id = hr_api.g_number) then
370: p_rec.previous_employer_id :=
371: pqh_vld_shd.g_old_rec.previous_employer_id;
372: End If;
373: If (p_rec.previously_validated_flag = hr_api.g_varchar2) then
374: p_rec.previously_validated_flag :=
375: pqh_vld_shd.g_old_rec.previously_validated_flag;
376: End If;
377: If (p_rec.status = hr_api.g_varchar2) then

Line 377: If (p_rec.status = hr_api.g_varchar2) then

373: If (p_rec.previously_validated_flag = hr_api.g_varchar2) then
374: p_rec.previously_validated_flag :=
375: pqh_vld_shd.g_old_rec.previously_validated_flag;
376: End If;
377: If (p_rec.status = hr_api.g_varchar2) then
378: p_rec.status :=
379: pqh_vld_shd.g_old_rec.status;
380: End If;
381: If (p_rec.employer_amount = hr_api.g_number) then

Line 381: If (p_rec.employer_amount = hr_api.g_number) then

377: If (p_rec.status = hr_api.g_varchar2) then
378: p_rec.status :=
379: pqh_vld_shd.g_old_rec.status;
380: End If;
381: If (p_rec.employer_amount = hr_api.g_number) then
382: p_rec.employer_amount :=
383: pqh_vld_shd.g_old_rec.employer_amount;
384: End If;
385: If (p_rec.employer_currency_code = hr_api.g_varchar2) then

Line 385: If (p_rec.employer_currency_code = hr_api.g_varchar2) then

381: If (p_rec.employer_amount = hr_api.g_number) then
382: p_rec.employer_amount :=
383: pqh_vld_shd.g_old_rec.employer_amount;
384: End If;
385: If (p_rec.employer_currency_code = hr_api.g_varchar2) then
386: p_rec.employer_currency_code :=
387: pqh_vld_shd.g_old_rec.employer_currency_code;
388: End If;
389: If (p_rec.employee_amount = hr_api.g_number) then

Line 389: If (p_rec.employee_amount = hr_api.g_number) then

385: If (p_rec.employer_currency_code = hr_api.g_varchar2) then
386: p_rec.employer_currency_code :=
387: pqh_vld_shd.g_old_rec.employer_currency_code;
388: End If;
389: If (p_rec.employee_amount = hr_api.g_number) then
390: p_rec.employee_amount :=
391: pqh_vld_shd.g_old_rec.employee_amount;
392: End If;
393: If (p_rec.employee_currency_code = hr_api.g_varchar2) then

Line 393: If (p_rec.employee_currency_code = hr_api.g_varchar2) then

389: If (p_rec.employee_amount = hr_api.g_number) then
390: p_rec.employee_amount :=
391: pqh_vld_shd.g_old_rec.employee_amount;
392: End If;
393: If (p_rec.employee_currency_code = hr_api.g_varchar2) then
394: p_rec.employee_currency_code :=
395: pqh_vld_shd.g_old_rec.employee_currency_code;
396: End If;
397: If (p_rec.deduction_per_period = hr_api.g_number) then

Line 397: If (p_rec.deduction_per_period = hr_api.g_number) then

393: If (p_rec.employee_currency_code = hr_api.g_varchar2) then
394: p_rec.employee_currency_code :=
395: pqh_vld_shd.g_old_rec.employee_currency_code;
396: End If;
397: If (p_rec.deduction_per_period = hr_api.g_number) then
398: p_rec.deduction_per_period :=
399: pqh_vld_shd.g_old_rec.deduction_per_period;
400: End If;
401: If (p_rec.deduction_currency_code = hr_api.g_varchar2) then

Line 401: If (p_rec.deduction_currency_code = hr_api.g_varchar2) then

397: If (p_rec.deduction_per_period = hr_api.g_number) then
398: p_rec.deduction_per_period :=
399: pqh_vld_shd.g_old_rec.deduction_per_period;
400: End If;
401: If (p_rec.deduction_currency_code = hr_api.g_varchar2) then
402: p_rec.deduction_currency_code :=
403: pqh_vld_shd.g_old_rec.deduction_currency_code;
404: End If;
405: If (p_rec.percent_of_salary = hr_api.g_number) then

Line 405: If (p_rec.percent_of_salary = hr_api.g_number) then

401: If (p_rec.deduction_currency_code = hr_api.g_varchar2) then
402: p_rec.deduction_currency_code :=
403: pqh_vld_shd.g_old_rec.deduction_currency_code;
404: End If;
405: If (p_rec.percent_of_salary = hr_api.g_number) then
406: p_rec.percent_of_salary :=
407: pqh_vld_shd.g_old_rec.percent_of_salary;
408: End If;
409: --

Line 473: ,p_pension_fund_type_code in varchar2 default hr_api.g_varchar2

469: Procedure upd
470: (p_effective_date in date
471: ,p_validation_id in number
472: ,p_object_version_number in out nocopy number
473: ,p_pension_fund_type_code in varchar2 default hr_api.g_varchar2
474: ,p_pension_fund_id in number default hr_api.g_number
475: ,p_business_group_id in number default hr_api.g_number
476: ,p_person_id in number default hr_api.g_number
477: ,p_previously_validated_flag in varchar2 default hr_api.g_varchar2

Line 474: ,p_pension_fund_id in number default hr_api.g_number

470: (p_effective_date in date
471: ,p_validation_id in number
472: ,p_object_version_number in out nocopy number
473: ,p_pension_fund_type_code in varchar2 default hr_api.g_varchar2
474: ,p_pension_fund_id in number default hr_api.g_number
475: ,p_business_group_id in number default hr_api.g_number
476: ,p_person_id in number default hr_api.g_number
477: ,p_previously_validated_flag in varchar2 default hr_api.g_varchar2
478: ,p_request_date in date default hr_api.g_date

Line 475: ,p_business_group_id in number default hr_api.g_number

471: ,p_validation_id in number
472: ,p_object_version_number in out nocopy number
473: ,p_pension_fund_type_code in varchar2 default hr_api.g_varchar2
474: ,p_pension_fund_id in number default hr_api.g_number
475: ,p_business_group_id in number default hr_api.g_number
476: ,p_person_id in number default hr_api.g_number
477: ,p_previously_validated_flag in varchar2 default hr_api.g_varchar2
478: ,p_request_date in date default hr_api.g_date
479: ,p_completion_date in date default hr_api.g_date

Line 476: ,p_person_id in number default hr_api.g_number

472: ,p_object_version_number in out nocopy number
473: ,p_pension_fund_type_code in varchar2 default hr_api.g_varchar2
474: ,p_pension_fund_id in number default hr_api.g_number
475: ,p_business_group_id in number default hr_api.g_number
476: ,p_person_id in number default hr_api.g_number
477: ,p_previously_validated_flag in varchar2 default hr_api.g_varchar2
478: ,p_request_date in date default hr_api.g_date
479: ,p_completion_date in date default hr_api.g_date
480: ,p_previous_employer_id in number default hr_api.g_number

Line 477: ,p_previously_validated_flag in varchar2 default hr_api.g_varchar2

473: ,p_pension_fund_type_code in varchar2 default hr_api.g_varchar2
474: ,p_pension_fund_id in number default hr_api.g_number
475: ,p_business_group_id in number default hr_api.g_number
476: ,p_person_id in number default hr_api.g_number
477: ,p_previously_validated_flag in varchar2 default hr_api.g_varchar2
478: ,p_request_date in date default hr_api.g_date
479: ,p_completion_date in date default hr_api.g_date
480: ,p_previous_employer_id in number default hr_api.g_number
481: ,p_status in varchar2 default hr_api.g_varchar2

Line 478: ,p_request_date in date default hr_api.g_date

474: ,p_pension_fund_id in number default hr_api.g_number
475: ,p_business_group_id in number default hr_api.g_number
476: ,p_person_id in number default hr_api.g_number
477: ,p_previously_validated_flag in varchar2 default hr_api.g_varchar2
478: ,p_request_date in date default hr_api.g_date
479: ,p_completion_date in date default hr_api.g_date
480: ,p_previous_employer_id in number default hr_api.g_number
481: ,p_status in varchar2 default hr_api.g_varchar2
482: ,p_employer_amount in number default hr_api.g_number

Line 479: ,p_completion_date in date default hr_api.g_date

475: ,p_business_group_id in number default hr_api.g_number
476: ,p_person_id in number default hr_api.g_number
477: ,p_previously_validated_flag in varchar2 default hr_api.g_varchar2
478: ,p_request_date in date default hr_api.g_date
479: ,p_completion_date in date default hr_api.g_date
480: ,p_previous_employer_id in number default hr_api.g_number
481: ,p_status in varchar2 default hr_api.g_varchar2
482: ,p_employer_amount in number default hr_api.g_number
483: ,p_employer_currency_code in varchar2 default hr_api.g_varchar2

Line 480: ,p_previous_employer_id in number default hr_api.g_number

476: ,p_person_id in number default hr_api.g_number
477: ,p_previously_validated_flag in varchar2 default hr_api.g_varchar2
478: ,p_request_date in date default hr_api.g_date
479: ,p_completion_date in date default hr_api.g_date
480: ,p_previous_employer_id in number default hr_api.g_number
481: ,p_status in varchar2 default hr_api.g_varchar2
482: ,p_employer_amount in number default hr_api.g_number
483: ,p_employer_currency_code in varchar2 default hr_api.g_varchar2
484: ,p_employee_amount in number default hr_api.g_number

Line 481: ,p_status in varchar2 default hr_api.g_varchar2

477: ,p_previously_validated_flag in varchar2 default hr_api.g_varchar2
478: ,p_request_date in date default hr_api.g_date
479: ,p_completion_date in date default hr_api.g_date
480: ,p_previous_employer_id in number default hr_api.g_number
481: ,p_status in varchar2 default hr_api.g_varchar2
482: ,p_employer_amount in number default hr_api.g_number
483: ,p_employer_currency_code in varchar2 default hr_api.g_varchar2
484: ,p_employee_amount in number default hr_api.g_number
485: ,p_employee_currency_code in varchar2 default hr_api.g_varchar2

Line 482: ,p_employer_amount in number default hr_api.g_number

478: ,p_request_date in date default hr_api.g_date
479: ,p_completion_date in date default hr_api.g_date
480: ,p_previous_employer_id in number default hr_api.g_number
481: ,p_status in varchar2 default hr_api.g_varchar2
482: ,p_employer_amount in number default hr_api.g_number
483: ,p_employer_currency_code in varchar2 default hr_api.g_varchar2
484: ,p_employee_amount in number default hr_api.g_number
485: ,p_employee_currency_code in varchar2 default hr_api.g_varchar2
486: ,p_deduction_per_period in number default hr_api.g_number

Line 483: ,p_employer_currency_code in varchar2 default hr_api.g_varchar2

479: ,p_completion_date in date default hr_api.g_date
480: ,p_previous_employer_id in number default hr_api.g_number
481: ,p_status in varchar2 default hr_api.g_varchar2
482: ,p_employer_amount in number default hr_api.g_number
483: ,p_employer_currency_code in varchar2 default hr_api.g_varchar2
484: ,p_employee_amount in number default hr_api.g_number
485: ,p_employee_currency_code in varchar2 default hr_api.g_varchar2
486: ,p_deduction_per_period in number default hr_api.g_number
487: ,p_deduction_currency_code in varchar2 default hr_api.g_varchar2

Line 484: ,p_employee_amount in number default hr_api.g_number

480: ,p_previous_employer_id in number default hr_api.g_number
481: ,p_status in varchar2 default hr_api.g_varchar2
482: ,p_employer_amount in number default hr_api.g_number
483: ,p_employer_currency_code in varchar2 default hr_api.g_varchar2
484: ,p_employee_amount in number default hr_api.g_number
485: ,p_employee_currency_code in varchar2 default hr_api.g_varchar2
486: ,p_deduction_per_period in number default hr_api.g_number
487: ,p_deduction_currency_code in varchar2 default hr_api.g_varchar2
488: ,p_percent_of_salary in number default hr_api.g_number

Line 485: ,p_employee_currency_code in varchar2 default hr_api.g_varchar2

481: ,p_status in varchar2 default hr_api.g_varchar2
482: ,p_employer_amount in number default hr_api.g_number
483: ,p_employer_currency_code in varchar2 default hr_api.g_varchar2
484: ,p_employee_amount in number default hr_api.g_number
485: ,p_employee_currency_code in varchar2 default hr_api.g_varchar2
486: ,p_deduction_per_period in number default hr_api.g_number
487: ,p_deduction_currency_code in varchar2 default hr_api.g_varchar2
488: ,p_percent_of_salary in number default hr_api.g_number
489: ) is

Line 486: ,p_deduction_per_period in number default hr_api.g_number

482: ,p_employer_amount in number default hr_api.g_number
483: ,p_employer_currency_code in varchar2 default hr_api.g_varchar2
484: ,p_employee_amount in number default hr_api.g_number
485: ,p_employee_currency_code in varchar2 default hr_api.g_varchar2
486: ,p_deduction_per_period in number default hr_api.g_number
487: ,p_deduction_currency_code in varchar2 default hr_api.g_varchar2
488: ,p_percent_of_salary in number default hr_api.g_number
489: ) is
490: --

Line 487: ,p_deduction_currency_code in varchar2 default hr_api.g_varchar2

483: ,p_employer_currency_code in varchar2 default hr_api.g_varchar2
484: ,p_employee_amount in number default hr_api.g_number
485: ,p_employee_currency_code in varchar2 default hr_api.g_varchar2
486: ,p_deduction_per_period in number default hr_api.g_number
487: ,p_deduction_currency_code in varchar2 default hr_api.g_varchar2
488: ,p_percent_of_salary in number default hr_api.g_number
489: ) is
490: --
491: l_rec pqh_vld_shd.g_rec_type;

Line 488: ,p_percent_of_salary in number default hr_api.g_number

484: ,p_employee_amount in number default hr_api.g_number
485: ,p_employee_currency_code in varchar2 default hr_api.g_varchar2
486: ,p_deduction_per_period in number default hr_api.g_number
487: ,p_deduction_currency_code in varchar2 default hr_api.g_varchar2
488: ,p_percent_of_salary in number default hr_api.g_number
489: ) is
490: --
491: l_rec pqh_vld_shd.g_rec_type;
492: l_proc varchar2(72) := g_package||'upd';