[Home] [Help]
431: -- Processing continues.
432: --
433: -- Post Failure:
434: -- If a row exists by determining the returning Boolean value from the
435: -- generic dt_api.rows_exist function then we must supply an error via
436: -- the use of the local exception handler l_rows_exist.
437: --
438: -- Developer Implementation Notes:
439: -- This procedure should not need maintenance unless the HR Schema model
489: (p_api_name => l_proc,
490: p_argument => 'assignment_id',
491: p_argument_value => p_assignment_id);
492: --
493: If (dt_api.rows_exist
494: (p_base_table_name => 'pay_cost_allocations_f',
495: p_base_key_column => 'assignment_id',
496: p_base_key_value => p_assignment_id,
497: p_from_date => p_validation_start_date,
498: p_to_date => p_validation_end_date)) Then
499: l_table_name := 'cost allocations';
500: Raise l_rows_exist;
501: End If;
502: If (dt_api.rows_exist
503: (p_base_table_name => 'pay_assignment_link_usages_f',
504: p_base_key_column => 'assignment_id',
505: p_base_key_value => p_assignment_id,
506: p_from_date => p_validation_start_date,
508: l_table_name := 'assignment link usages';
509: Raise l_rows_exist;
510: End If;
511: --
512: If (dt_api.rows_exist
513: (p_base_table_name => 'pay_personal_payment_methods_f',
514: p_base_key_column => 'assignment_id',
515: p_base_key_value => p_assignment_id,
516: p_from_date => p_validation_start_date,
518: l_table_name := 'personal payment methods';
519: Raise l_rows_exist;
520: End If;
521: --
522: If (dt_api.rows_exist
523: (p_base_table_name => 'per_spinal_point_placements_f',
524: p_base_key_column => 'assignment_id',
525: p_base_key_value => p_assignment_id,
526: p_from_date => p_validation_start_date,
528: l_table_name := 'spinal point placements';
529: Raise l_rows_exist;
530: End If;
531: --
532: If (dt_api.rows_exist
533: (p_base_table_name => 'pay_element_entries_f',
534: p_base_key_column => 'assignment_id',
535: p_base_key_value => p_assignment_id,
536: p_from_date => p_validation_start_date,
538: l_table_name := 'element entries';
539: Raise l_rows_exist;
540: End If;
541: --
542: If (dt_api.rows_exist
543: (p_base_table_name => 'pay_us_emp_fed_tax_rules_f',
544: p_base_key_column => 'assignment_id',
545: p_base_key_value => p_assignment_id,
546: p_from_date => p_validation_start_date,
548: l_table_name := 'us emp fed tax rules';
549: Raise l_rows_exist;
550: End If;
551: --
552: If (dt_api.rows_exist
553: (p_base_table_name => 'pay_us_emp_county_tax_rules_f',
554: p_base_key_column => 'assignment_id',
555: p_base_key_value => p_assignment_id,
556: p_from_date => p_validation_start_date,
558: l_table_name := 'us emp county tax rules';
559: Raise l_rows_exist;
560: End If;
561: --
562: If (dt_api.rows_exist
563: (p_base_table_name => 'pay_us_emp_state_tax_rules_f',
564: p_base_key_column => 'assignment_id',
565: p_base_key_value => p_assignment_id,
566: p_from_date => p_validation_start_date,
568: l_table_name := 'us emp state tax rules';
569: Raise l_rows_exist;
570: End If;
571: --
572: If (dt_api.rows_exist
573: (p_base_table_name => 'pay_us_emp_city_tax_rules_f',
574: p_base_key_column => 'assignment_id',
575: p_base_key_value => p_assignment_id,
576: p_from_date => p_validation_start_date,
666: --
667: -- Start of fix 2535030
668: /*
669: If ((nvl(p_payroll_id, hr_api.g_number) <> hr_api.g_number) and
670: NOT (dt_api.check_min_max_dates
671: (p_base_table_name => 'pay_all_payrolls_f', -- bug fix 2679167
672: p_base_key_column => 'payroll_id',
673: p_base_key_value => p_payroll_id,
674: p_from_date => p_validation_start_date,
679: */
680: -- End of fix 2535030
681:
682: If ((nvl(p_person_id, hr_api.g_number) <> hr_api.g_number) and
683: NOT (dt_api.check_min_max_dates
684: (p_base_table_name => 'per_all_people_f',
685: p_base_key_column => 'person_id',
686: p_base_key_value => p_person_id,
687: p_from_date => p_validation_start_date,