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.PER_ZA_USER_HOOK_PKG dependencies on PER_ALL_PEOPLE_F

Line 58: ( p_check_column1 => 'PER_ALL_PEOPLE_F.PER_INFORMATION4'

54: -- of APL, EMP and CWK
55: --
56: IF l_system_person_type IN ('APL','EMP','CWK') THEN
57: IF hr_multi_message.no_exclusive_error
58: ( p_check_column1 => 'PER_ALL_PEOPLE_F.PER_INFORMATION4'
59: )
60: THEN
61: IF p_race_code IS NULL OR
62: p_race_code = 'N' OR

Line 71: (p_associated_column1 => 'PER_ALL_PEOPLE_F.PER_INFORMATION4'

67: )
68: THEN
69: fnd_message.set_name('PER', 'HR_ZA_MAND_SEG_RACE');
70: hr_multi_message.add
71: (p_associated_column1 => 'PER_ALL_PEOPLE_F.PER_INFORMATION4'
72: );
73: END IF;
74: END IF;
75: END IF;

Line 82: in per_all_people_f.business_group_id%type default null

78: -- validate_applicant
79: -------------------------------------------------------------------------------
80: PROCEDURE validate_applicant
81: ( p_business_group_id
82: in per_all_people_f.business_group_id%type default null
83: , p_date_received
84: in date
85: , p_person_type_id
86: in per_all_people_f.person_type_id%type default null

Line 86: in per_all_people_f.person_type_id%type default null

82: in per_all_people_f.business_group_id%type default null
83: , p_date_received
84: in date
85: , p_person_type_id
86: in per_all_people_f.person_type_id%type default null
87: , p_per_information_category
88: in per_all_people_f.per_information_category%type default null
89: , p_per_information4
90: in per_all_people_f.per_information4%type default null

Line 88: in per_all_people_f.per_information_category%type default null

84: in date
85: , p_person_type_id
86: in per_all_people_f.person_type_id%type default null
87: , p_per_information_category
88: in per_all_people_f.per_information_category%type default null
89: , p_per_information4
90: in per_all_people_f.per_information4%type default null
91: )
92: AS

Line 90: in per_all_people_f.per_information4%type default null

86: in per_all_people_f.person_type_id%type default null
87: , p_per_information_category
88: in per_all_people_f.per_information_category%type default null
89: , p_per_information4
90: in per_all_people_f.per_information4%type default null
91: )
92: AS
93: ------------
94: -- Variables

Line 97: l_person_type_id per_all_people_f.person_type_id%type;

93: ------------
94: -- Variables
95: ------------
96: l_proc varchar2(40) := g_package||'validate_applicant';
97: l_person_type_id per_all_people_f.person_type_id%type;
98:
99: BEGIN
100: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
101: hr_utility.set_location(l_proc,1);

Line 129: in per_all_people_f.business_group_id%type default null

125: -- validate_employee
126: -------------------------------------------------------------------------------
127: PROCEDURE validate_employee
128: ( p_business_group_id
129: in per_all_people_f.business_group_id%type default null
130: , p_hire_date
131: in date
132: , p_person_type_id
133: in per_all_people_f.person_type_id%type default null

Line 133: in per_all_people_f.person_type_id%type default null

129: in per_all_people_f.business_group_id%type default null
130: , p_hire_date
131: in date
132: , p_person_type_id
133: in per_all_people_f.person_type_id%type default null
134: , p_per_information_category
135: in per_all_people_f.per_information_category%type default null
136: , p_per_information4
137: in per_all_people_f.per_information4%type default null

Line 135: in per_all_people_f.per_information_category%type default null

131: in date
132: , p_person_type_id
133: in per_all_people_f.person_type_id%type default null
134: , p_per_information_category
135: in per_all_people_f.per_information_category%type default null
136: , p_per_information4
137: in per_all_people_f.per_information4%type default null
138: )
139: AS

Line 137: in per_all_people_f.per_information4%type default null

133: in per_all_people_f.person_type_id%type default null
134: , p_per_information_category
135: in per_all_people_f.per_information_category%type default null
136: , p_per_information4
137: in per_all_people_f.per_information4%type default null
138: )
139: AS
140: ------------
141: -- Variables

Line 144: l_person_type_id per_all_people_f.person_type_id%type;

140: ------------
141: -- Variables
142: ------------
143: l_proc varchar2(40) := g_package||'validate_employee';
144: l_person_type_id per_all_people_f.person_type_id%type;
145:
146: BEGIN
147: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
148: hr_utility.set_location(l_proc,1);

Line 176: in per_all_people_f.business_group_id%type default null

172: -- validate_cwk
173: -------------------------------------------------------------------------------
174: PROCEDURE validate_cwk
175: ( p_business_group_id
176: in per_all_people_f.business_group_id%type default null
177: , p_start_date
178: in date
179: , p_person_type_id
180: in per_all_people_f.person_type_id%type default null

Line 180: in per_all_people_f.person_type_id%type default null

176: in per_all_people_f.business_group_id%type default null
177: , p_start_date
178: in date
179: , p_person_type_id
180: in per_all_people_f.person_type_id%type default null
181: , p_per_information_category
182: in per_all_people_f.per_information_category%type default null
183: , p_per_information4
184: in per_all_people_f.per_information4%type default null

Line 182: in per_all_people_f.per_information_category%type default null

178: in date
179: , p_person_type_id
180: in per_all_people_f.person_type_id%type default null
181: , p_per_information_category
182: in per_all_people_f.per_information_category%type default null
183: , p_per_information4
184: in per_all_people_f.per_information4%type default null
185: )
186: AS

Line 184: in per_all_people_f.per_information4%type default null

180: in per_all_people_f.person_type_id%type default null
181: , p_per_information_category
182: in per_all_people_f.per_information_category%type default null
183: , p_per_information4
184: in per_all_people_f.per_information4%type default null
185: )
186: AS
187: ------------
188: -- Variables

Line 191: l_person_type_id per_all_people_f.person_type_id%type;

187: ------------
188: -- Variables
189: ------------
190: l_proc varchar2(40) := g_package||'validate_cwk';
191: l_person_type_id per_all_people_f.person_type_id%type;
192:
193: BEGIN
194: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
195: hr_utility.set_location(l_proc,1);

Line 223: in per_all_people_f.person_id%type

219: -- validate_person
220: -------------------------------------------------------------------------------
221: PROCEDURE validate_person
222: ( p_person_id
223: in per_all_people_f.person_id%type
224: , p_effective_date
225: in date
226: , p_person_type_id
227: in per_all_people_f.person_type_id%type

Line 227: in per_all_people_f.person_type_id%type

223: in per_all_people_f.person_id%type
224: , p_effective_date
225: in date
226: , p_person_type_id
227: in per_all_people_f.person_type_id%type
228: , p_per_information_category
229: in per_all_people_f.per_information_category%type
230: , p_per_information4
231: in per_all_people_f.per_information4%type

Line 229: in per_all_people_f.per_information_category%type

225: in date
226: , p_person_type_id
227: in per_all_people_f.person_type_id%type
228: , p_per_information_category
229: in per_all_people_f.per_information_category%type
230: , p_per_information4
231: in per_all_people_f.per_information4%type
232: )
233: AS

Line 231: in per_all_people_f.per_information4%type

227: in per_all_people_f.person_type_id%type
228: , p_per_information_category
229: in per_all_people_f.per_information_category%type
230: , p_per_information4
231: in per_all_people_f.per_information4%type
232: )
233: AS
234: ---------
235: -- Cursor

Line 240: FROM per_all_people_f

236: ---------
237: CURSOR c_person_person_type
238: IS
239: SELECT person_type_id
240: FROM per_all_people_f
241: WHERE person_id = p_person_id
242: AND p_effective_date BETWEEN effective_start_date
243: AND effective_end_date;
244: CURSOR c_person_race

Line 247: FROM per_all_people_f

243: AND effective_end_date;
244: CURSOR c_person_race
245: IS
246: SELECT per_information4
247: FROM per_all_people_f
248: WHERE person_id = p_person_id
249: AND p_effective_date BETWEEN effective_start_date
250: AND effective_end_date;
251: ------------

Line 255: l_person_type_id per_all_people_f.person_type_id%type;

251: ------------
252: -- Variables
253: ------------
254: l_proc varchar2(40) := g_package||'validate_person';
255: l_person_type_id per_all_people_f.person_type_id%type;
256: l_person_race per_all_people_f.per_information4%type;
257:
258: BEGIN
259: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN

Line 256: l_person_race per_all_people_f.per_information4%type;

252: -- Variables
253: ------------
254: l_proc varchar2(40) := g_package||'validate_person';
255: l_person_type_id per_all_people_f.person_type_id%type;
256: l_person_race per_all_people_f.per_information4%type;
257:
258: BEGIN
259: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
260: hr_utility.set_location(l_proc,1);