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_ORG_PAYMENT_METHODS

Line 672: SELECT * FROM hr_h2pi_org_payment_methods

668:
669: org_payment_method_tab org_payment_method_tab_type;
670:
671: CURSOR csr_org_payment_method IS
672: SELECT * FROM hr_h2pi_org_payment_methods
673: WHERE client_id = p_from_client_id;
674:
675: CURSOR csr_pay_org_payment_method IS
676: SELECT org_payment_method_id

Line 677: FROM hr_h2pi_org_payment_methods_v

673: WHERE client_id = p_from_client_id;
674:
675: CURSOR csr_pay_org_payment_method IS
676: SELECT org_payment_method_id
677: FROM hr_h2pi_org_payment_methods_v
678: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
679:
680: CURSOR csr_hr_data_removed (p_org_payment_method_id NUMBER) IS
681: SELECT org_payment_method_id

Line 682: FROM hr_h2pi_org_payment_methods_v ele

678: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
679:
680: CURSOR csr_hr_data_removed (p_org_payment_method_id NUMBER) IS
681: SELECT org_payment_method_id
682: FROM hr_h2pi_org_payment_methods_v ele
683: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_Id
684: AND ele.org_payment_method_id = p_org_payment_method_id
685: AND NOT EXISTS (SELECT 'X'
686: FROM hr_h2pi_id_mapping him,

Line 687: hr_h2pi_org_payment_methods ele1

683: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_Id
684: AND ele.org_payment_method_id = p_org_payment_method_id
685: AND NOT EXISTS (SELECT 'X'
686: FROM hr_h2pi_id_mapping him,
687: hr_h2pi_org_payment_methods ele1
688: WHERE him.to_id = ele.org_payment_method_id
689: AND ele1.org_payment_method_id = him.from_id
690: AND him.table_name = 'PAY_ORG_PAYMENT_METHODS_F'
691: AND him.to_business_group_id = ele.business_group_id);

Line 695: FROM hr_h2pi_org_payment_methods_v ele

691: AND him.to_business_group_id = ele.business_group_id);
692:
693: CURSOR csr_payroll_data_added(p_org_payment_method_id NUMBER) IS
694: SELECT org_payment_method_id
695: FROM hr_h2pi_org_payment_methods_v ele
696: WHERE ele.business_group_id = hr_h2pi_upload.g_to_business_group_id
697: AND ele.org_payment_method_id = p_org_payment_method_id
698: AND NOT EXISTS (SELECT 'X'
699: FROM hr_h2pi_id_mapping him

Line 705: l_ed_rec hr_h2pi_org_payment_methods_v%ROWTYPE;

701: AND him.table_name = 'PAY_ORG_PAYMENT_METHODS_F'
702: AND him.to_business_group_id =
703: hr_h2pi_upload.g_to_business_group_id);
704:
705: l_ed_rec hr_h2pi_org_payment_methods_v%ROWTYPE;
706: l_org_payment_method_to_id
707: hr_h2pi_org_payment_methods.org_payment_method_id%TYPe;
708: l_counter BINARY_INTEGER ;
709: l_org_payment_method_id

Line 707: hr_h2pi_org_payment_methods.org_payment_method_id%TYPe;

703: hr_h2pi_upload.g_to_business_group_id);
704:
705: l_ed_rec hr_h2pi_org_payment_methods_v%ROWTYPE;
706: l_org_payment_method_to_id
707: hr_h2pi_org_payment_methods.org_payment_method_id%TYPe;
708: l_counter BINARY_INTEGER ;
709: l_org_payment_method_id
710: hr_h2pi_org_payment_methods.org_payment_method_id%TYPE;
711: l_record_ok BOOLEAN;

Line 710: hr_h2pi_org_payment_methods.org_payment_method_id%TYPE;

706: l_org_payment_method_to_id
707: hr_h2pi_org_payment_methods.org_payment_method_id%TYPe;
708: l_counter BINARY_INTEGER ;
709: l_org_payment_method_id
710: hr_h2pi_org_payment_methods.org_payment_method_id%TYPE;
711: l_record_ok BOOLEAN;
712:
713: l_proc VARCHAR2(72) := g_package||'validate_org_payment_methods';
714:

Line 730: p_table_name => 'HR_H2PI_ORG_PAYMENT_METHODS',

726:
727: IF l_org_payment_method_to_id = -1 THEN
728: hr_utility.set_location(l_proc, 30);
729: hr_h2pi_error.data_error(p_from_id => v_ud_rec.org_payment_method_id,
730: p_table_name => 'HR_H2PI_ORG_PAYMENT_METHODS',
731: p_message_level => 'FATAL',
732: p_message_name => 'HR_289260_UD_DATA_ADDED');
733: ELSE
734: hr_utility.set_location(l_proc, 40);

Line 738: FROM hr_h2pi_org_payment_methods_v

734: hr_utility.set_location(l_proc, 40);
735: BEGIN
736: SELECT *
737: INTO l_ed_rec
738: FROM hr_h2pi_org_payment_methods_v
739: WHERE org_payment_method_id = l_org_payment_method_to_id
740: AND effective_start_date = v_ud_rec.effective_start_date
741: AND effective_end_date = v_ud_rec.effective_end_date;
742:

Line 755: p_table_name => 'HR_H2PI_ORG_PAYMENT_METHODS',

751: l_ed_rec.payment_type_name <> v_ud_rec.payment_type_name OR
752: l_ed_rec.territory_code <> v_ud_rec.territory_code THEN
753: hr_utility.set_location(l_proc, 50);
754: hr_h2pi_error.data_error(p_from_id => v_ud_rec.org_payment_method_id,
755: p_table_name => 'HR_H2PI_ORG_PAYMENT_METHODS',
756: p_message_level => 'FATAL',
757: p_message_name => 'HR_289237_DATA_MISMATCH');
758: END IF;
759:

Line 764: p_table_name => 'HR_H2PI_ORG_PAYMENT_METHODS',

760: EXCEPTION
761: WHEN NO_DATA_FOUND THEN
762: hr_utility.set_location(l_proc, 60);
763: hr_h2pi_error.data_error(p_from_id => v_ud_rec.org_payment_method_id,
764: p_table_name => 'HR_H2PI_ORG_PAYMENT_METHODS',
765: p_message_level =>'FATAL',
766: p_message_name =>'HR_289235_ED_DATA_REMOVED');
767: WHEN MAPPING_ID_MISSING THEN
768: hr_utility.set_location(l_proc, 70);

Line 795: p_table_name => 'HR_H2PI_ORG_PAYMENT_METHODS',

791: IF csr_payroll_data_added%FOUND then
792: hr_utility.set_location(l_proc, 100);
793:
794: hr_h2pi_error.data_error(p_from_id => l_org_payment_method_id,
795: p_table_name => 'HR_H2PI_ORG_PAYMENT_METHODS',
796: p_message_level => 'FATAL',
797: p_message_name => 'HR_289259_ED_DATA_ADDED');
798: CLOSE csr_payroll_data_added;
799:

Line 811: p_table_name => 'HR_H2PI_ORG_PAYMENT_METHODS',

807: hr_utility.set_location(l_proc, 120);
808: IF csr_hr_data_removed%FOUND then
809: --HR Data removed
810: hr_h2pi_error.data_error(p_from_id => l_org_payment_method_id,
811: p_table_name => 'HR_H2PI_ORG_PAYMENT_METHODS',
812: p_message_level => 'FATAL',
813: p_message_name => 'HR_289236_UD_DATA_REMOVED');
814: END IF;
815: CLOSE csr_hr_data_removed;