DBA Data[Home] [Help]

PACKAGE: APPS.HR_HELPDESK_UTIL_SS

Source


1 Package  HR_HELPDESK_UTIL_SS As
2 /* $Header: hrhdutilss.pkh 120.2.12010000.5 2008/12/12 13:38:42 tkghosh ship $ */
3 --
4 --
5   FUNCTION get_person_id
6      ( emp_id IN per_all_people_f.employee_number%type,
7        bg_id IN per_all_people_f.business_group_id%type,
8        cwk_id IN per_all_people_f.npw_number%type)
9      RETURN  varchar2;
10 
11     FUNCTION get_assgn_id
12      ( pers_id IN per_all_people_f.person_id%type)
13      RETURN  varchar2;
14 
15      FUNCTION get_person_status
16      ( person_id IN per_all_people_f.person_id%type)
17      RETURN  varchar2;
18 
19     FUNCTION get_assign_status
20      ( assig_id IN per_all_assignments_f.assignment_id%type)
21      RETURN  varchar2;
22 
23    FUNCTION validate_function
24      RETURN varchar2;
25 
26    FUNCTION get_function_type
27   (func_name IN VARCHAR2)
28    return varchar2;
29 
30   FUNCTION get_resp_name
31    (resp_id IN fnd_responsibility.RESPONSIBILITY_ID%type)
32    RETURN VARCHAR2;
33 
34    FUNCTION get_secgrp_key
35    (sec_grp_id IN fnd_security_groups.SECURITY_GROUP_KEY%type)
36    RETURN VARCHAR2;
37 
38 END;