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_LINKS

Line 836: SELECT el.* FROM hr_h2pi_element_links el,

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

Line 847: FROM hr_h2pi_element_links_v

843: AND et.client_id = p_from_client_id;
844:
845: CURSOR csr_pay_element_link IS
846: SELECT element_link_id
847: FROM hr_h2pi_element_links_v
848: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
849:
850: CURSOR csr_hr_data_removed (p_element_link_id NUMBER) IS
851: SELECT element_link_id

Line 852: FROM hr_h2pi_element_links_v ele

848: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
849:
850: CURSOR csr_hr_data_removed (p_element_link_id NUMBER) IS
851: SELECT element_link_id
852: FROM hr_h2pi_element_links_v ele
853: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_Id
854: AND ele.element_link_id = p_element_link_id
855: AND NOT EXISTS (SELECT 'X'
856: FROM hr_h2pi_id_mapping him,

Line 857: hr_h2pi_element_links ele1

853: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_Id
854: AND ele.element_link_id = p_element_link_id
855: AND NOT EXISTS (SELECT 'X'
856: FROM hr_h2pi_id_mapping him,
857: hr_h2pi_element_links ele1
858: WHERE him.to_id = ele.element_link_id
859: AND ele1.element_link_id = him.from_id
860: AND him.table_name = 'PAY_ELEMENT_LINKS_F'
861: AND him.to_business_group_id = ele.business_group_id);

Line 865: FROM hr_h2pi_element_links_v ele

861: AND him.to_business_group_id = ele.business_group_id);
862:
863: CURSOR csr_payroll_data_added(p_element_link_id NUMBER) IS
864: SELECT element_link_id
865: FROM hr_h2pi_element_links_v ele
866: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_id
867: AND ele.element_link_id = p_element_link_id
868: AND NOT EXISTS (SELECT 'X'
869: FROM hr_h2pi_id_mapping him

Line 875: l_ed_rec hr_h2pi_element_links_v%ROWTYPE;

871: AND him.table_name = 'PAY_ELEMENT_LINKS_F'
872: AND him.to_business_group_id =
873: hr_h2pi_upload.g_to_business_group_id);
874:
875: l_ed_rec hr_h2pi_element_links_v%ROWTYPE;
876: l_element_link_to_id hr_h2pi_element_links.element_link_id%TYPe;
877: l_counter BINARY_INTEGER ;
878: l_element_link_id hr_h2pi_element_links.element_link_id%TYPE;
879: l_payroll_id hr_h2pi_element_links.payroll_id%TYPE;

Line 876: l_element_link_to_id hr_h2pi_element_links.element_link_id%TYPe;

872: AND him.to_business_group_id =
873: hr_h2pi_upload.g_to_business_group_id);
874:
875: l_ed_rec hr_h2pi_element_links_v%ROWTYPE;
876: l_element_link_to_id hr_h2pi_element_links.element_link_id%TYPe;
877: l_counter BINARY_INTEGER ;
878: l_element_link_id hr_h2pi_element_links.element_link_id%TYPE;
879: l_payroll_id hr_h2pi_element_links.payroll_id%TYPE;
880: l_pay_basis_id hr_h2pi_element_links.pay_basis_id%TYPE;

Line 878: l_element_link_id hr_h2pi_element_links.element_link_id%TYPE;

874:
875: l_ed_rec hr_h2pi_element_links_v%ROWTYPE;
876: l_element_link_to_id hr_h2pi_element_links.element_link_id%TYPe;
877: l_counter BINARY_INTEGER ;
878: l_element_link_id hr_h2pi_element_links.element_link_id%TYPE;
879: l_payroll_id hr_h2pi_element_links.payroll_id%TYPE;
880: l_pay_basis_id hr_h2pi_element_links.pay_basis_id%TYPE;
881: l_organization_id hr_h2pi_element_links.organization_id%TYPE;
882: l_record_ok BOOLEAN;

Line 879: l_payroll_id hr_h2pi_element_links.payroll_id%TYPE;

875: l_ed_rec hr_h2pi_element_links_v%ROWTYPE;
876: l_element_link_to_id hr_h2pi_element_links.element_link_id%TYPe;
877: l_counter BINARY_INTEGER ;
878: l_element_link_id hr_h2pi_element_links.element_link_id%TYPE;
879: l_payroll_id hr_h2pi_element_links.payroll_id%TYPE;
880: l_pay_basis_id hr_h2pi_element_links.pay_basis_id%TYPE;
881: l_organization_id hr_h2pi_element_links.organization_id%TYPE;
882: l_record_ok BOOLEAN;
883:

Line 880: l_pay_basis_id hr_h2pi_element_links.pay_basis_id%TYPE;

876: l_element_link_to_id hr_h2pi_element_links.element_link_id%TYPe;
877: l_counter BINARY_INTEGER ;
878: l_element_link_id hr_h2pi_element_links.element_link_id%TYPE;
879: l_payroll_id hr_h2pi_element_links.payroll_id%TYPE;
880: l_pay_basis_id hr_h2pi_element_links.pay_basis_id%TYPE;
881: l_organization_id hr_h2pi_element_links.organization_id%TYPE;
882: l_record_ok BOOLEAN;
883:
884: l_proc VARCHAR2(72) := g_package||'validate_element_link';

Line 881: l_organization_id hr_h2pi_element_links.organization_id%TYPE;

877: l_counter BINARY_INTEGER ;
878: l_element_link_id hr_h2pi_element_links.element_link_id%TYPE;
879: l_payroll_id hr_h2pi_element_links.payroll_id%TYPE;
880: l_pay_basis_id hr_h2pi_element_links.pay_basis_id%TYPE;
881: l_organization_id hr_h2pi_element_links.organization_id%TYPE;
882: l_record_ok BOOLEAN;
883:
884: l_proc VARCHAR2(72) := g_package||'validate_element_link';
885:

Line 901: p_table_name => 'HR_H2PI_ELEMENT_LINKS',

897:
898: IF l_element_link_to_id = -1 THEN
899: hr_utility.set_location(l_proc, 30);
900: hr_h2pi_error.data_error(p_from_id => v_ud_rec.element_link_id,
901: p_table_name => 'HR_H2PI_ELEMENT_LINKS',
902: p_message_level => 'FATAL',
903: p_message_name => 'HR_289260_UD_DATA_ADDED');
904: ELSE
905: BEGIN

Line 909: FROM hr_h2pi_element_links_v

905: BEGIN
906: hr_utility.set_location(l_proc, 40);
907: SELECT *
908: INTO l_ed_rec
909: FROM hr_h2pi_element_links_v
910: WHERE element_link_id = l_element_link_to_id
911: AND effective_start_date = v_ud_rec.effective_start_date
912: AND effective_end_date = v_ud_rec.effective_end_date;
913:

Line 941: p_table_name => 'HR_H2PI_ELEMENT_LINKS',

937: l_ed_rec.link_to_all_payrolls_flag
938: <> v_ud_rec.link_to_all_payrolls_flag THEN
939: hr_utility.set_location(l_proc, 50);
940: hr_h2pi_error.data_error(p_from_id => v_ud_rec.element_link_id,
941: p_table_name => 'HR_H2PI_ELEMENT_LINKS',
942: p_message_level => 'FATAL',
943: p_message_name => 'HR_289237_DATA_MISMATCH');
944: END IF;
945:

Line 950: p_table_name => 'HR_H2PI_ELEMENT_LINKS',

946: EXCEPTION
947: WHEN NO_DATA_FOUND THEN
948: hr_utility.set_location(l_proc, 60);
949: hr_h2pi_error.data_error(p_from_id => v_ud_rec.element_link_id,
950: p_table_name => 'HR_H2PI_ELEMENT_LINKS',
951: p_message_level=> 'FATAL',
952: p_message_name => 'HR_289235_ED_DATA_REMOVED');
953: WHEN MAPPING_ID_MISSING THEN
954: hr_utility.set_location(l_proc, 70);

Line 981: p_table_name => 'HR_H2PI_ELEMENT_LINKS',

977: IF csr_payroll_data_added%FOUND then
978: hr_utility.set_location(l_proc, 100);
979:
980: hr_h2pi_error.data_error(p_from_id => l_element_link_id,
981: p_table_name => 'HR_H2PI_ELEMENT_LINKS',
982: p_message_level => 'FATAL',
983: p_message_name => 'HR_289259_ED_DATA_ADDED');
984: CLOSE csr_payroll_data_added;
985:

Line 997: p_table_name => 'HR_H2PI_ELEMENT_LINKS',

993: IF csr_hr_data_removed%FOUND then
994: --HR Data removed
995: hr_utility.set_location(l_proc, 120);
996: hr_h2pi_error.data_error(p_from_id => l_element_link_id,
997: p_table_name => 'HR_H2PI_ELEMENT_LINKS',
998: p_message_level => 'FATAL',
999: p_message_name => 'HR_289236_UD_DATA_REMOVED');
1000: END IF;
1001: CLOSE csr_hr_data_removed;