APPS.HR_HELPDESK_UTIL_SS dependencies on PER_ALL_PEOPLE_F

Line 8: ( emp_id IN per_all_people_f.employee_number%type,

4: -- Package variables
5: --
6:
7: FUNCTION get_person_id
8: ( emp_id IN per_all_people_f.employee_number%type,
9: bg_id IN per_all_people_f.business_group_id%type,
10: cwk_id IN per_all_people_f.npw_number%type)
11: RETURN varchar2
12: IS

Line 9: bg_id IN per_all_people_f.business_group_id%type,

5: --
6:
7: FUNCTION get_person_id
8: ( emp_id IN per_all_people_f.employee_number%type,
9: bg_id IN per_all_people_f.business_group_id%type,
10: cwk_id IN per_all_people_f.npw_number%type)
11: RETURN varchar2
12: IS
13: pers_id varchar2(10);

Line 10: cwk_id IN per_all_people_f.npw_number%type)

6:
7: FUNCTION get_person_id
8: ( emp_id IN per_all_people_f.employee_number%type,
9: bg_id IN per_all_people_f.business_group_id%type,
10: cwk_id IN per_all_people_f.npw_number%type)
11: RETURN varchar2
12: IS
13: pers_id varchar2(10);
14: BEGIN

Line 19: from per_all_people_f

15:
16: if (trim(cwk_id) is not null or trim(cwk_id) <> 0) then
17:
18: select distinct person_id into pers_id
19: from per_all_people_f
20: where npw_number = cwk_id and
21: business_group_id = bg_id and
22: current_npw_flag='Y' and
23: sysdate between effective_start_date and

Line 29: from per_all_people_f

25:
26: else
27:
28: select distinct person_id into pers_id
29: from per_all_people_f
30: where employee_number = emp_id and
31: business_group_id = bg_id and
32: current_employee_flag='Y' and
33: sysdate between effective_start_date and

Line 48: (pers_id per_all_people_f.person_id%type )

44: END get_person_id;
45:
46:
47: FUNCTION get_assgn_id
48: (pers_id per_all_people_f.person_id%type )
49: RETURN varchar2 is
50: --pers_id varchar2(10);
51: ass_id varchar2(10);
52: BEGIN

Line 74: ( person_id IN per_all_people_f.person_id%type)

70: END get_assgn_id;
71:
72:
73: FUNCTION get_person_status
74: ( person_id IN per_all_people_f.person_id%type)
75: RETURN varchar2 is
76: per_sts number;
77: BEGIN
78: select count(*) into per_sts from per_people_f

Line 121: bus_grp_id per_all_people_f.business_group_id%type)

117:
118:
119: FUNCTION validate_function
120: (func_name fnd_form_functions.function_name%type,
121: bus_grp_id per_all_people_f.business_group_id%type)
122: RETURN varchar2 is
123: l_count number;
124: p_count number;
125:

Line 219: bus_grp_id per_all_people_f.business_group_id%type)

215: END get_function_type;
216:
217:
218: FUNCTION get_resp_name(func_name fnd_form_functions.function_name%type,
219: bus_grp_id per_all_people_f.business_group_id%type)
220: RETURN VARCHAR2 IS
221:
222: l_resp_name fnd_responsibility.RESPONSIBILITY_KEY%type;
223:

Line 279: (p_person_id IN per_all_people_f.person_id%type,

275:
276: END get_secgrp_key;
277:
278: FUNCTION get_person_type_status
279: (p_person_id IN per_all_people_f.person_id%type,
280: eff_date IN varchar2,
281: p_fn_name IN varchar2)
282: RETURN VARCHAR2 IS
283: