APPS.PER_ASG_BUS1 dependencies on DT_API

Line 453: -- generic dt_api.rows_exist function then we must supply an error via

449: -- Processing continues.
450: --
451: -- Post Failure:
452: -- If a row exists by determining the returning Boolean value from the
453: -- generic dt_api.rows_exist function then we must supply an error via
454: -- the use of the local exception handler l_rows_exist.
455: --
456: -- Developer Implementation Notes:
457: -- This procedure should not need maintenance unless the HR Schema model

Line 532: If (dt_api.rows_exist

528: p_argument_value => p_assignment_id);
529: --
530: hr_utility.set_location(l_proc,60);
531:
532: If (dt_api.rows_exist
533: (p_base_table_name => 'pay_cost_allocations_f',
534: p_base_key_column => 'assignment_id',
535: p_base_key_value => p_assignment_id,
536: p_from_date => p_validation_start_date,

Line 543: If (dt_api.rows_exist

539: Raise l_rows_exist;
540: End If;
541: hr_utility.set_location(l_proc,70);
542:
543: If (dt_api.rows_exist
544: (p_base_table_name => 'pay_assignment_link_usages_f',
545: p_base_key_column => 'assignment_id',
546: p_base_key_value => p_assignment_id,
547: p_from_date => p_validation_start_date,

Line 555: If (dt_api.rows_exist

551: End If;
552: --
553: hr_utility.set_location(l_proc,80);
554:
555: If (dt_api.rows_exist
556: (p_base_table_name => 'pay_personal_payment_methods_f',
557: p_base_key_column => 'assignment_id',
558: p_base_key_value => p_assignment_id,
559: p_from_date => p_validation_start_date,

Line 567: If (dt_api.rows_exist

563: End If;
564: --
565: hr_utility.set_location(l_proc,90);
566:
567: If (dt_api.rows_exist
568: (p_base_table_name => 'per_spinal_point_placements_f',
569: p_base_key_column => 'assignment_id',
570: p_base_key_value => p_assignment_id,
571: p_from_date => p_validation_start_date,

Line 579: If (dt_api.rows_exist

575: End If;
576: --
577: hr_utility.set_location(l_proc,100);
578:
579: If (dt_api.rows_exist
580: (p_base_table_name => 'pay_element_entries_f',
581: p_base_key_column => 'assignment_id',
582: p_base_key_value => p_assignment_id,
583: p_from_date => p_validation_start_date,

Line 597: If (dt_api.rows_exist

593: hr_utility.set_location(l_proc,120);
594: IF l_legislation_code = 'US' THEN
595: hr_utility.set_location(l_proc,130);
596:
597: If (dt_api.rows_exist
598: (p_base_table_name => 'pay_us_emp_fed_tax_rules_f',
599: p_base_key_column => 'assignment_id',
600: p_base_key_value => p_assignment_id,
601: p_from_date => p_validation_start_date,

Line 609: If (dt_api.rows_exist

605: End If;
606: --
607: hr_utility.set_location(l_proc,140);
608:
609: If (dt_api.rows_exist
610: (p_base_table_name => 'pay_us_emp_county_tax_rules_f',
611: p_base_key_column => 'assignment_id',
612: p_base_key_value => p_assignment_id,
613: p_from_date => p_validation_start_date,

Line 621: If (dt_api.rows_exist

617: End If;
618: --
619: hr_utility.set_location(l_proc,150);
620:
621: If (dt_api.rows_exist
622: (p_base_table_name => 'pay_us_emp_state_tax_rules_f',
623: p_base_key_column => 'assignment_id',
624: p_base_key_value => p_assignment_id,
625: p_from_date => p_validation_start_date,

Line 633: If (dt_api.rows_exist

629: End If;
630: --
631: hr_utility.set_location(l_proc,160);
632:
633: If (dt_api.rows_exist
634: (p_base_table_name => 'pay_us_emp_city_tax_rules_f',
635: p_base_key_column => 'assignment_id',
636: p_base_key_value => p_assignment_id,
637: p_from_date => p_validation_start_date,

Line 743: NOT (dt_api.check_min_max_dates

739: --
740: -- Start of fix 2535030
741: /*
742: If ((nvl(p_payroll_id, hr_api.g_number) <> hr_api.g_number) and
743: NOT (dt_api.check_min_max_dates
744: (p_base_table_name => 'pay_all_payrolls_f', -- bug fix 2679167
745: p_base_key_column => 'payroll_id',
746: p_base_key_value => p_payroll_id,
747: p_from_date => p_validation_start_date,

Line 756: NOT (dt_api.check_min_max_dates

752: */
753: -- End of fix 2535030
754:
755: If ((nvl(p_person_id, hr_api.g_number) <> hr_api.g_number) and
756: NOT (dt_api.check_min_max_dates
757: (p_base_table_name => 'per_all_people_f',
758: p_base_key_column => 'person_id',
759: p_base_key_value => p_person_id,
760: p_from_date => p_validation_start_date,