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_RU_PEOPLE_LEG_HOOK dependencies on HR_API

Line 9: IF (param <> hr_api.g_varchar2) OR (param IS NULL)

5: FUNCTION param_or_db (param VARCHAR2, db_item VARCHAR2)
6: RETURN VARCHAR2
7: IS
8: BEGIN
9: IF (param <> hr_api.g_varchar2) OR (param IS NULL)
10: THEN
11: RETURN param;
12: ELSE
13: RETURN db_item;

Line 71: IF p_per_information13 <> hr_api.g_varchar2

67:
68: l_effective_date := TRUNC (p_effective_date);
69:
70: --Validate Pension fund number
71: IF p_per_information13 <> hr_api.g_varchar2
72: AND p_per_information13 IS NOT NULL
73: THEN
74: l_err :=
75: hr_ru_utility.validate_spifn (p_per_information13,

Line 97: IF (p_per_information5 <> hr_api.g_varchar2)

93: END IF;
94: END IF;
95:
96: --Check for Invalid Combination of military document and other military details
97: IF (p_per_information5 <> hr_api.g_varchar2)
98: OR (p_per_information5 IS NULL)
99: OR (p_per_information6 <> hr_api.g_varchar2)
100: OR (p_per_information6 IS NULL)
101: OR (p_per_information7 <> hr_api.g_varchar2)

Line 99: OR (p_per_information6 <> hr_api.g_varchar2)

95:
96: --Check for Invalid Combination of military document and other military details
97: IF (p_per_information5 <> hr_api.g_varchar2)
98: OR (p_per_information5 IS NULL)
99: OR (p_per_information6 <> hr_api.g_varchar2)
100: OR (p_per_information6 IS NULL)
101: OR (p_per_information7 <> hr_api.g_varchar2)
102: OR (p_per_information7 IS NULL)
103: OR (p_per_information8 <> hr_api.g_varchar2)

Line 101: OR (p_per_information7 <> hr_api.g_varchar2)

97: IF (p_per_information5 <> hr_api.g_varchar2)
98: OR (p_per_information5 IS NULL)
99: OR (p_per_information6 <> hr_api.g_varchar2)
100: OR (p_per_information6 IS NULL)
101: OR (p_per_information7 <> hr_api.g_varchar2)
102: OR (p_per_information7 IS NULL)
103: OR (p_per_information8 <> hr_api.g_varchar2)
104: OR (p_per_information8 IS NULL)
105: OR (p_per_information9 <> hr_api.g_varchar2)

Line 103: OR (p_per_information8 <> hr_api.g_varchar2)

99: OR (p_per_information6 <> hr_api.g_varchar2)
100: OR (p_per_information6 IS NULL)
101: OR (p_per_information7 <> hr_api.g_varchar2)
102: OR (p_per_information7 IS NULL)
103: OR (p_per_information8 <> hr_api.g_varchar2)
104: OR (p_per_information8 IS NULL)
105: OR (p_per_information9 <> hr_api.g_varchar2)
106: OR (p_per_information9 IS NULL)
107: OR (p_per_information10 <> hr_api.g_varchar2)

Line 105: OR (p_per_information9 <> hr_api.g_varchar2)

101: OR (p_per_information7 <> hr_api.g_varchar2)
102: OR (p_per_information7 IS NULL)
103: OR (p_per_information8 <> hr_api.g_varchar2)
104: OR (p_per_information8 IS NULL)
105: OR (p_per_information9 <> hr_api.g_varchar2)
106: OR (p_per_information9 IS NULL)
107: OR (p_per_information10 <> hr_api.g_varchar2)
108: OR (p_per_information10 IS NULL)
109: OR (p_per_information11 <> hr_api.g_varchar2)

Line 107: OR (p_per_information10 <> hr_api.g_varchar2)

103: OR (p_per_information8 <> hr_api.g_varchar2)
104: OR (p_per_information8 IS NULL)
105: OR (p_per_information9 <> hr_api.g_varchar2)
106: OR (p_per_information9 IS NULL)
107: OR (p_per_information10 <> hr_api.g_varchar2)
108: OR (p_per_information10 IS NULL)
109: OR (p_per_information11 <> hr_api.g_varchar2)
110: OR (p_per_information11 IS NULL)
111: OR (p_per_information12 <> hr_api.g_varchar2)

Line 109: OR (p_per_information11 <> hr_api.g_varchar2)

105: OR (p_per_information9 <> hr_api.g_varchar2)
106: OR (p_per_information9 IS NULL)
107: OR (p_per_information10 <> hr_api.g_varchar2)
108: OR (p_per_information10 IS NULL)
109: OR (p_per_information11 <> hr_api.g_varchar2)
110: OR (p_per_information11 IS NULL)
111: OR (p_per_information12 <> hr_api.g_varchar2)
112: OR (p_per_information12 IS NULL)
113: OR (p_per_information14 <> hr_api.g_varchar2)

Line 111: OR (p_per_information12 <> hr_api.g_varchar2)

107: OR (p_per_information10 <> hr_api.g_varchar2)
108: OR (p_per_information10 IS NULL)
109: OR (p_per_information11 <> hr_api.g_varchar2)
110: OR (p_per_information11 IS NULL)
111: OR (p_per_information12 <> hr_api.g_varchar2)
112: OR (p_per_information12 IS NULL)
113: OR (p_per_information14 <> hr_api.g_varchar2)
114: OR (p_per_information14 IS NULL)
115: OR (p_per_information15 <> hr_api.g_varchar2)

Line 113: OR (p_per_information14 <> hr_api.g_varchar2)

109: OR (p_per_information11 <> hr_api.g_varchar2)
110: OR (p_per_information11 IS NULL)
111: OR (p_per_information12 <> hr_api.g_varchar2)
112: OR (p_per_information12 IS NULL)
113: OR (p_per_information14 <> hr_api.g_varchar2)
114: OR (p_per_information14 IS NULL)
115: OR (p_per_information15 <> hr_api.g_varchar2)
116: OR (p_per_information15 IS NULL)
117: OR (p_per_information18 <> hr_api.g_varchar2)

Line 115: OR (p_per_information15 <> hr_api.g_varchar2)

111: OR (p_per_information12 <> hr_api.g_varchar2)
112: OR (p_per_information12 IS NULL)
113: OR (p_per_information14 <> hr_api.g_varchar2)
114: OR (p_per_information14 IS NULL)
115: OR (p_per_information15 <> hr_api.g_varchar2)
116: OR (p_per_information15 IS NULL)
117: OR (p_per_information18 <> hr_api.g_varchar2)
118: OR (p_per_information18 IS NULL)
119: THEN

Line 117: OR (p_per_information18 <> hr_api.g_varchar2)

113: OR (p_per_information14 <> hr_api.g_varchar2)
114: OR (p_per_information14 IS NULL)
115: OR (p_per_information15 <> hr_api.g_varchar2)
116: OR (p_per_information15 IS NULL)
117: OR (p_per_information18 <> hr_api.g_varchar2)
118: OR (p_per_information18 IS NULL)
119: THEN
120: OPEN csr_get_mil_info (p_person_id);
121:

Line 167: hr_api.mandatory_arg_error

163: p_argument_value => l_per_information5,
164: p_lookup_type => 'RU_MILITARY_DOC_TYPE',
165: p_effective_date => p_effective_date
166: );
167: hr_api.mandatory_arg_error
168: (p_api_name => l_proc,
169: p_argument => hr_general.decode_lookup
170: ('RU_FORM_LABELS',
171: 'MIL_SERVICE_READINESS'

Line 366: hr_api.mandatory_arg_error

362: p_argument_value => p_per_information5,
363: p_lookup_type => 'RU_MILITARY_DOC_TYPE',
364: p_effective_date => p_effective_date
365: );
366: hr_api.mandatory_arg_error
367: (p_api_name => l_proc,
368: p_argument => hr_general.decode_lookup
369: ('RU_FORM_LABELS',
370: 'MIL_SERVICE_READINESS'

Line 525: hr_api.mandatory_arg_error

521: --
522: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
523: --
524: -- Check for Citizenship
525: hr_api.mandatory_arg_error
526: (p_api_name => l_proc,
527: p_argument => hr_general.decode_lookup
528: ('RU_FORM_LABELS',
529: 'CITIZENSHIP'

Line 543: hr_api.mandatory_arg_error

539: p_lookup_type => 'RU_CITIZENSHIP',
540: p_effective_date => p_hire_date
541: );
542: -- Check for first name
543: hr_api.mandatory_arg_error
544: (p_api_name => l_proc,
545: p_argument => hr_general.decode_lookup
546: ('RU_FORM_LABELS',
547: 'FIRST_NAME'

Line 615: hr_api.mandatory_arg_error

611: --
612: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
613: --
614: -- Check for Citizenship
615: hr_api.mandatory_arg_error
616: (p_api_name => l_proc,
617: p_argument => hr_general.decode_lookup
618: ('RU_FORM_LABELS',
619: 'CITIZENSHIP'

Line 725: hr_api.mandatory_arg_error

721: --
722: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
723: --
724: -- Check for Citizenship
725: hr_api.mandatory_arg_error
726: (p_api_name => l_proc,
727: p_argument => hr_general.decode_lookup
728: ('RU_FORM_LABELS',
729: 'CITIZENSHIP'

Line 821: IF (p_person_type_id <> hr_api.g_number

817: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
818: --
819: l_effective_date := TRUNC (p_effective_date);
820:
821: IF (p_person_type_id <> hr_api.g_number
822: ) -- If person type has changed , get new type
823: THEN
824: OPEN csr_val_person_type (p_person_type_id);
825:

Line 839: IF (p_per_information1 <> hr_api.g_varchar2)

835:
836: CLOSE csr_ptu_type;
837: END IF;
838: -- Check Place of Birth takes valid OKATO lookup value
839: IF (p_per_information1 <> hr_api.g_varchar2)
840: THEN
841: hr_ru_utility.check_lookup_value
842: (p_argument => hr_general.decode_lookup
843: ('RU_FORM_LABELS',

Line 855: hr_api.mandatory_arg_error

851: --
852: IF l_seeded_person_type_key <> 'CONTACT'
853: THEN
854: -- Check for Citizenship
855: hr_api.mandatory_arg_error
856: (p_api_name => l_proc,
857: p_argument => hr_general.decode_lookup
858: ('RU_FORM_LABELS',
859: 'CITIZENSHIP'

Line 864: IF (p_per_information4 <> hr_api.g_varchar2)

860: ),
861: p_argument_value => p_per_information4
862: );
863:
864: IF (p_per_information4 <> hr_api.g_varchar2)
865: THEN
866: hr_ru_utility.check_lookup_value
867: (p_argument => hr_general.decode_lookup
868: ('RU_FORM_LABELS',

Line 882: IF (p_first_name <> hr_api.g_varchar2) OR (p_first_name IS NULL)

878: -- Check if Military Document is provided for male employees between 17 and 65
879: IF l_system_person_type LIKE 'EMP%'
880: THEN
881: -- Check for first name
882: IF (p_first_name <> hr_api.g_varchar2) OR (p_first_name IS NULL)
883: THEN
884: hr_api.mandatory_arg_error
885: (p_api_name => l_proc,
886: p_argument => hr_general.decode_lookup

Line 884: hr_api.mandatory_arg_error

880: THEN
881: -- Check for first name
882: IF (p_first_name <> hr_api.g_varchar2) OR (p_first_name IS NULL)
883: THEN
884: hr_api.mandatory_arg_error
885: (p_api_name => l_proc,
886: p_argument => hr_general.decode_lookup
887: ('RU_FORM_LABELS',
888: 'FIRST_NAME'

Line 894: IF (p_date_of_birth <> hr_api.g_date)

890: p_argument_value => p_first_name
891: );
892: END IF;
893:
894: IF (p_date_of_birth <> hr_api.g_date)
895: OR (p_sex <> hr_api.g_varchar2)
896: OR ( p_per_information5 <> hr_api.g_varchar2
897: OR p_per_information5 IS NULL
898: )

Line 895: OR (p_sex <> hr_api.g_varchar2)

891: );
892: END IF;
893:
894: IF (p_date_of_birth <> hr_api.g_date)
895: OR (p_sex <> hr_api.g_varchar2)
896: OR ( p_per_information5 <> hr_api.g_varchar2
897: OR p_per_information5 IS NULL
898: )
899: THEN

Line 896: OR ( p_per_information5 <> hr_api.g_varchar2

892: END IF;
893:
894: IF (p_date_of_birth <> hr_api.g_date)
895: OR (p_sex <> hr_api.g_varchar2)
896: OR ( p_per_information5 <> hr_api.g_varchar2
897: OR p_per_information5 IS NULL
898: )
899: THEN
900: OPEN csr_get_person_info (p_person_id);