[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 120.0.12010000.2 2009/07/07 09:12:22 gpurohit ship $ */
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 FUNCTION get_emp_person_type_id
80 (p_effective_date IN DATE
81 ,p_person_id IN NUMBER
82 )
83 RETURN VARCHAR2;
84 -- ------------------------------------------------------------------------------
85 -- |--------------------------< get_emp_user_person_type >--------------------------|
86 -- ------------------------------------------------------------------------------
87 FUNCTION get_emp_user_person_type
88 (p_effective_date IN DATE
89 ,p_person_id IN NUMBER
90 )
91 RETURN VARCHAR2;
92 -- ------------------------------------------------------------------------------
93 -- |--------------------------< GetSystemPersonType >--------------------------|
94 -- ------------------------------------------------------------------------------
95 FUNCTION GetSystemPersonType
96 (p_person_type_id IN NUMBER)
97 RETURN VARCHAR2;
98 --
99 -- ------------------------------------------------------------------------------
100 -- |--------------------------< IsNonCoreHRPersonType >--------------------------|
101 -- ------------------------------------------------------------------------------
102 FUNCTION IsNonCoreHRPersonType
103 (p_person_type_usage_id IN NUMBER,
104 p_effective_date IN DATE)
105 RETURN BOOLEAN;
106 --
107 -- ------------------------------------------------------------------------------
108 -- |--------------------------< FutSysPerTypeChgExists >--------------------------|
109 -- ------------------------------------------------------------------------------
110 FUNCTION FutSysPerTypeChgExists
111 (p_person_type_usage_id IN NUMBER,
112 p_effective_date IN DATE)
113 RETURN BOOLEAN;
114
115 FUNCTION FutSysPerTypeChgExists
116 (p_person_type_usage_id IN NUMBER,
117 p_effective_date IN DATE
118 ,p_person_id IN NUMBER)
119 RETURN BOOLEAN;
120
121 --
122 -- ------------------------------------------------------------------------------
123 -- |--------------------------< is_person_of_type >-----------------------------|
124 -- ------------------------------------------------------------------------------
125 FUNCTION is_person_of_type
126 (p_effective_date IN DATE
127 ,p_person_id IN NUMBER
128 ,p_system_person_type IN VARCHAR2
129 )
130 RETURN BOOLEAN;
131 --
132 -- ------------------------------------------------------------------------------
133 -- |-------------------------< is_person_a_worker >-----------------------------|
134 -- ------------------------------------------------------------------------------
135 --
136 FUNCTION is_person_a_worker
137 (p_effective_date IN DATE
138 ,p_person_id IN per_all_people_f.person_id%TYPE) RETURN BOOLEAN;
139 --
140 -- ------------------------------------------------------------------------------
141 -- |--------------------------< get_person_actions >----------------------------|
142 -- ------------------------------------------------------------------------------
143 --
144 FUNCTION get_person_actions
145 (p_person_id IN NUMBER
146 ,p_effective_date IN DATE
147 ,p_customized_restriction_id IN NUMBER DEFAULT NULL)
148 RETURN g_actions_t;
149 --
150 END hr_person_type_usage_info;