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.HR_H2PI_VALIDATE dependencies on HR_H2PI_ELEMENT_TYPES

Line 513: SELECT * FROM hr_h2pi_element_types

509:
510: element_type_tab element_type_tab_type;
511:
512: CURSOR csr_element_type IS
513: SELECT * FROM hr_h2pi_element_types
514: WHERE client_id = p_from_client_id
515: AND legislation_code IS NULL;
516:
517: CURSOR csr_pay_element_type IS

Line 519: FROM hr_h2pi_element_types_v

515: AND legislation_code IS NULL;
516:
517: CURSOR csr_pay_element_type IS
518: SELECT element_type_id
519: FROM hr_h2pi_element_types_v
520: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
521:
522: CURSOR csr_hr_data_removed (p_element_type_id NUMBER) IS
523: SELECT element_type_id

Line 524: FROM hr_h2pi_element_types_v ele

520: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
521:
522: CURSOR csr_hr_data_removed (p_element_type_id NUMBER) IS
523: SELECT element_type_id
524: FROM hr_h2pi_element_types_v ele
525: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_Id
526: AND ele.element_type_id = p_element_type_id
527: AND NOT EXISTS (SELECT 'X'
528: FROM hr_h2pi_id_mapping him,

Line 529: hr_h2pi_element_types ele1

525: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_Id
526: AND ele.element_type_id = p_element_type_id
527: AND NOT EXISTS (SELECT 'X'
528: FROM hr_h2pi_id_mapping him,
529: hr_h2pi_element_types ele1
530: WHERE him.to_id = ele.element_type_id
531: AND ele1.element_type_id = him.from_id
532: AND him.table_name = 'PAY_ELEMENT_TYPES_F'
533: AND him.to_business_group_id = ele.business_group_id);

Line 537: FROM hr_h2pi_element_types_v ele

533: AND him.to_business_group_id = ele.business_group_id);
534:
535: CURSOR csr_payroll_data_added(p_element_type_id NUMBER) IS
536: SELECT element_type_id
537: FROM hr_h2pi_element_types_v ele
538: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_id
539: AND ele.element_type_id = p_element_type_id
540: AND NOT EXISTS (SELECT 'X'
541: FROM hr_h2pi_id_mapping him

Line 547: l_ed_rec hr_h2pi_element_types_v%ROWTYPE;

543: AND him.table_name = 'PAY_ELEMENT_TYPES_F'
544: AND him.to_business_group_id =
545: hr_h2pi_upload.g_to_business_group_id);
546:
547: l_ed_rec hr_h2pi_element_types_v%ROWTYPE;
548: l_element_type_to_id hr_h2pi_element_types.element_type_id%TYPe;
549: l_counter BINARY_INTEGER ;
550: l_element_type_id hr_h2pi_element_types.element_type_id%TYPE;
551: l_record_ok BOOLEAN;

Line 548: l_element_type_to_id hr_h2pi_element_types.element_type_id%TYPe;

544: AND him.to_business_group_id =
545: hr_h2pi_upload.g_to_business_group_id);
546:
547: l_ed_rec hr_h2pi_element_types_v%ROWTYPE;
548: l_element_type_to_id hr_h2pi_element_types.element_type_id%TYPe;
549: l_counter BINARY_INTEGER ;
550: l_element_type_id hr_h2pi_element_types.element_type_id%TYPE;
551: l_record_ok BOOLEAN;
552:

Line 550: l_element_type_id hr_h2pi_element_types.element_type_id%TYPE;

546:
547: l_ed_rec hr_h2pi_element_types_v%ROWTYPE;
548: l_element_type_to_id hr_h2pi_element_types.element_type_id%TYPe;
549: l_counter BINARY_INTEGER ;
550: l_element_type_id hr_h2pi_element_types.element_type_id%TYPE;
551: l_record_ok BOOLEAN;
552:
553: l_proc VARCHAR2(72) := g_package||'validate_element_type';
554:

Line 570: p_table_name => 'HR_H2PI_ELEMENT_TYPES',

566:
567: IF l_element_type_to_id = -1 THEN
568: hr_utility.set_location(l_proc, 30);
569: hr_h2pi_error.data_error(p_from_id => v_ud_rec.element_type_id,
570: p_table_name => 'HR_H2PI_ELEMENT_TYPES',
571: p_message_level => 'FATAL',
572: p_message_name => 'HR_289260_UD_DATA_ADDED');
573: ELSE
574: BEGIN

Line 578: FROM hr_h2pi_element_types_v

574: BEGIN
575: hr_utility.set_location(l_proc, 40);
576: SELECT *
577: INTO l_ed_rec
578: FROM hr_h2pi_element_types_v
579: WHERE element_type_id = l_element_type_to_id
580: AND effective_start_date = v_ud_rec.effective_start_date
581: AND effective_end_date = v_ud_rec.effective_end_date;
582:

Line 592: p_table_name => 'HR_H2PI_ELEMENT_TYPES',

588: l_ed_rec.effective_start_date <> v_ud_rec.effective_start_date OR
589: l_ed_rec.effective_end_date <> v_ud_rec.effective_end_date THEN
590: hr_utility.set_location(l_proc, 50);
591: hr_h2pi_error.data_error(p_from_id => v_ud_rec.element_type_id,
592: p_table_name => 'HR_H2PI_ELEMENT_TYPES',
593: p_message_level => 'FATAL',
594: p_message_name => 'HR_289237_DATA_MISMATCH');
595: END IF;
596:

Line 601: p_table_name => 'HR_H2PI_ELEMENT_TYPES',

597: EXCEPTION
598: WHEN NO_DATA_FOUND THEN
599: hr_utility.set_location(l_proc, 60);
600: hr_h2pi_error.data_error(p_from_id => v_ud_rec.element_type_id,
601: p_table_name => 'HR_H2PI_ELEMENT_TYPES',
602: p_message_level=> 'FATAL',
603: p_message_name => 'HR_289235_ED_DATA_REMOVED');
604: WHEN MAPPING_ID_MISSING THEN
605: hr_utility.set_location(l_proc, 70);

Line 632: p_table_name => 'HR_H2PI_ELEMENT_TYPES',

628: IF csr_payroll_data_added%FOUND then
629:
630: hr_utility.set_location(l_proc, 100);
631: hr_h2pi_error.data_error(p_from_id => l_element_type_id,
632: p_table_name => 'HR_H2PI_ELEMENT_TYPES',
633: p_message_level => 'FATAL',
634: p_message_name => 'HR_289259_ED_DATA_ADDED');
635: CLOSE csr_payroll_data_added;
636:

Line 648: p_table_name => 'HR_H2PI_ELEMENT_TYPES',

644: IF csr_hr_data_removed%FOUND then
645: hr_utility.set_location(l_proc, 130);
646: --HR Data removed
647: hr_h2pi_error.data_error(p_from_id => l_element_type_id,
648: p_table_name => 'HR_H2PI_ELEMENT_TYPES',
649: p_message_level => 'FATAL',
650: p_message_name => 'HR_289236_UD_DATA_REMOVED');
651: END IF;
652: CLOSE csr_hr_data_removed;

Line 837: hr_h2pi_element_types et

833: element_link_tab element_link_tab_type;
834:
835: CURSOR csr_element_link IS
836: SELECT el.* FROM hr_h2pi_element_links el,
837: hr_h2pi_element_types et
838: WHERE el.client_id = p_from_client_id
839: AND el.element_type_id = et.element_type_id
840: AND el.effective_start_date BETWEEN et.effective_start_date
841: AND et.effective_end_date