[Home] [Help]
PACKAGE: APPS.HR_PERSON_TYPE_USAGE_INFO
Source
1 PACKAGE hr_person_type_usage_info AUTHID CURRENT_USER AS
2 /* $Header: hrptuinf.pkh 115.8 2003/11/04 09:29:32 irgonzal noship $ */
3 --
4 -- g_actions type to store a list of available actions for a particular
5 -- person
6 --
7 TYPE g_actions_r IS RECORD
8 (action per_form_functions.restriction_code%TYPE
9 ,meaning per_form_functions.restriction_value%TYPE);
10
11 TYPE g_actions_t IS TABLE OF g_actions_r index by binary_integer;
12
13 --
14 -- Character(s) used to separate the distinct components of the concatenated
15 -- user person type.
16 --
17 g_user_person_type_separator VARCHAR2(1) := '.';
18
19 --
20 -- ------------------------------------------------------------------------------
21 -- |---------------------< get_user_person_type_separator >---------------------|
22 -- ------------------------------------------------------------------------------
23 FUNCTION get_user_person_type_separator
24 RETURN g_user_person_type_separator%TYPE;
25 --
26 -- ------------------------------------------------------------------------------
27 -- |-----------------------< get_default_person_type_id >-----------------------|
28 -- ------------------------------------------------------------------------------
29 FUNCTION get_default_person_type_id
30 (p_person_type_id IN NUMBER
31 )
32 RETURN NUMBER;
33 --
34 -- ------------------------------------------------------------------------------
35 -- |-----------------------< get_default_person_type_id >-----------------------|
36 -- ------------------------------------------------------------------------------
37 FUNCTION get_default_person_type_id
38 (p_business_group_id IN NUMBER
39 ,p_system_person_type IN VARCHAR2
40 )
41 RETURN NUMBER;
42 --
43 -- ------------------------------------------------------------------------------
44 -- |--------------------------< get_user_person_type >--------------------------|
45 -- ------------------------------------------------------------------------------
46 FUNCTION get_user_person_type
47 (p_effective_date IN DATE
48 ,p_person_id IN NUMBER
49 )
50 RETURN VARCHAR2;
51 --
52 -- -----------------------------------------------------------------------------
53 -- |----------------------< get_worker_user_person_type >----------------------|
54 -- -----------------------------------------------------------------------------
55 FUNCTION get_worker_user_person_type
56 (p_effective_date IN DATE
57 ,p_person_id IN NUMBER
58 )
59 RETURN VARCHAR2;
60 --
61 -- -----------------------------------------------------------------------------
62 -- |----------------------< get_worker_number >--------------------------------|
63 -- -----------------------------------------------------------------------------
64 FUNCTION get_worker_number
65 (p_effective_date IN DATE
66 ,p_person_id IN NUMBER
67 )
68 RETURN VARCHAR2;
69 --
70 -- ---------------------------------------------------------------------------
71 -- |--------------------< get_apl_user_person_type >--------------------------|
72 -- ---------------------------------------------------------------------------
73 FUNCTION get_apl_user_person_type
74 (p_effective_date IN DATE
75 ,p_person_id IN NUMBER
76 )
77 RETURN VARCHAR2;
78 --
79 -- ------------------------------------------------------------------------------
80 -- |--------------------------< get_emp_user_person_type >--------------------------|
81 -- ------------------------------------------------------------------------------
82 FUNCTION get_emp_user_person_type
83 (p_effective_date IN DATE
84 ,p_person_id IN NUMBER
85 )
86 RETURN VARCHAR2;
87 -- ------------------------------------------------------------------------------
88 -- |--------------------------< GetSystemPersonType >--------------------------|
89 -- ------------------------------------------------------------------------------
90 FUNCTION GetSystemPersonType
91 (p_person_type_id IN NUMBER)
92 RETURN VARCHAR2;
93 --
94 -- ------------------------------------------------------------------------------
95 -- |--------------------------< IsNonCoreHRPersonType >--------------------------|
96 -- ------------------------------------------------------------------------------
97 FUNCTION IsNonCoreHRPersonType
98 (p_person_type_usage_id IN NUMBER,
99 p_effective_date IN DATE)
100 RETURN BOOLEAN;
101 --
102 -- ------------------------------------------------------------------------------
103 -- |--------------------------< FutSysPerTypeChgExists >--------------------------|
104 -- ------------------------------------------------------------------------------
105 FUNCTION FutSysPerTypeChgExists
106 (p_person_type_usage_id IN NUMBER,
107 p_effective_date IN DATE)
108 RETURN BOOLEAN;
109
110 FUNCTION FutSysPerTypeChgExists
111 (p_person_type_usage_id IN NUMBER,
112 p_effective_date IN DATE
113 ,p_person_id IN NUMBER)
114 RETURN BOOLEAN;
115
116 --
117 -- ------------------------------------------------------------------------------
118 -- |--------------------------< is_person_of_type >-----------------------------|
119 -- ------------------------------------------------------------------------------
120 FUNCTION is_person_of_type
121 (p_effective_date IN DATE
122 ,p_person_id IN NUMBER
123 ,p_system_person_type IN VARCHAR2
124 )
125 RETURN BOOLEAN;
126 --
127 -- ------------------------------------------------------------------------------
128 -- |-------------------------< is_person_a_worker >-----------------------------|
129 -- ------------------------------------------------------------------------------
130 --
131 FUNCTION is_person_a_worker
132 (p_effective_date IN DATE
133 ,p_person_id IN per_all_people_f.person_id%TYPE) RETURN BOOLEAN;
134 --
135 -- ------------------------------------------------------------------------------
136 -- |--------------------------< get_person_actions >----------------------------|
137 -- ------------------------------------------------------------------------------
138 --
139 FUNCTION get_person_actions
140 (p_person_id IN NUMBER
141 ,p_effective_date IN DATE
142 ,p_customized_restriction_id IN NUMBER DEFAULT NULL)
143 RETURN g_actions_t;
144 --
145 END hr_person_type_usage_info;