[Home] [Help]
PACKAGE: APPS.PER_PQH_SHR
Source
1 Package per_pqh_shr AUTHID CURRENT_USER as
2 /* $Header: pepqhshr.pkh 120.5.12020000.2 2013/04/13 04:51:38 pathota ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< position_control_enabled >----------------------|
6 -- ----------------------------------------------------------------------------
7 function position_control_enabled
8 (p_organization_id number default null,
9 p_effective_date date default sysdate,
10 p_assignment_id number default null) return varchar2;
11 --
12 -- ---------------------------------------------------------------------------
13 -- |------------------------< open_status >-----------------------------|
14 -- ---------------------------------------------------------------------------
15 -- Description:
16 -- Retrieves the funded_status of the position.
17 --
18 function open_status
19 (p_position_id in number, p_effective_date in date) return varchar2;
20 --
21 -- ---------------------------------------------------------------------------
22 -- |------------------------< future approved actions >-----------------|
23 -- ---------------------------------------------------------------------------
24 -- Description:
25 -- Retrieves the future approved actions of the position.
26 --
27 function future_approved_actions
28 (p_position_id in number) return varchar2;
29 --
30 -- ---------------------------------------------------------------------------
31 -- |----------------------< per_abv_insert_validate >-------------------|
32 -- ---------------------------------------------------------------------------
33 --
34 PROCEDURE per_abv_insert_validate(
35 p_assignment_id number,
36 p_value number,
37 p_unit varchar2,
38 p_effective_date date);
39 --
40 -- ---------------------------------------------------------------------------
41 -- |----------------------< per_abv_update_validate >-------------------|
42 -- ---------------------------------------------------------------------------
43 --
44 PROCEDURE per_abv_update_validate(
45 p_abv_id number,
46 p_assignment_id number,
47 p_value number,
48 p_unit varchar2,
49 p_effective_date date,
50 p_validation_start_date date,
51 p_validation_end_date date,
52 p_datetrack_mode varchar2);
53 --
54 -- ----------------------------------------------------------------------------
55 -- |----------------------------< hr_psf_bus >--------------------------------|
56 -- ----------------------------------------------------------------------------
57 --
58 Procedure hr_psf_bus(p_event varchar2, p_rec hr_psf_shd.g_rec_type
59 , p_effective_date date
60 , p_validation_start_date date
61 , p_validation_end_date date
62 , p_datetrack_mode varchar2);
63 --
64 --
65 -- ----------------------------------------------------------------------------
66 -- |-----------------------------< per_asg_bus >------------------------------|
67 -- ----------------------------------------------------------------------------
68 --
69 Procedure per_asg_bus(p_event varchar2, p_rec per_asg_shd.g_rec_type
70 ,p_effective_date in date
71 ,p_validation_start_date in date
72 ,p_validation_end_date in date
73 ,p_datetrack_mode in varchar2
74 );
75 --
76 --
77 -- ----------------------------------------------------------------------------
78 -- |-----------------------------< hr_lei_bus >------------------------------|
79 -- ----------------------------------------------------------------------------
80 --
81 Procedure hr_lei_bus(p_event varchar2, p_rec hr_lei_shd.g_rec_type);
82 --
83 --
84 -- ----------------------------------------------------------------------------
85 -- |-----------------------------< hr_loc_bus >------------------------------|
86 -- ----------------------------------------------------------------------------
87 --
88 Procedure hr_loc_bus(p_event varchar2, p_rec hr_loc_shd.g_rec_type);
89 --
90 --
91 -- ----------------------------------------------------------------------------
92 -- |-----------------------------< hr_org_bus >------------------------------|
93 -- ----------------------------------------------------------------------------
94 --
95 -- Procedure hr_oru_bus(p_event varchar2, p_rec hr_oru_shd.g_rec_type);
96 --
97 --
98 -- ----------------------------------------------------------------------------
99 -- |-----------------------------< pe_aei_bus >------------------------------|
100 -- ----------------------------------------------------------------------------
101 --
102 Procedure pe_aei_bus(p_event varchar2, p_rec pe_aei_shd.g_rec_type);
103 --
104 --
105 -- ----------------------------------------------------------------------------
106 -- |-----------------------------< pe_pei_bus >------------------------------|
107 -- ----------------------------------------------------------------------------
108 --
109 Procedure pe_pei_bus(p_event varchar2, p_rec pe_pei_shd.g_rec_type);
110 --
111 --
112 -- ----------------------------------------------------------------------------
113 -- |-----------------------------< pe_per_bus >------------------------------|
114 -- ----------------------------------------------------------------------------
115 --
116 Procedure per_per_bus(p_event varchar2, p_rec per_per_shd.g_rec_type);
117 --
118 --
119 -- ----------------------------------------------------------------------------
120 -- |-----------------------------< per_apl_bus >------------------------------|
121 -- ----------------------------------------------------------------------------
122 --
123 Procedure per_apl_bus(p_event varchar2, p_rec per_apl_shd.g_rec_type);
124 --
125 --
126 -- ----------------------------------------------------------------------------
127 -- |-----------------------------< pe_jei_bus >------------------------------|
128 -- ----------------------------------------------------------------------------
129 --
130 Procedure pe_jei_bus(p_event varchar2, p_rec pe_jei_shd.g_rec_type);
131 --
132 --
133 -- ----------------------------------------------------------------------------
134 -- |-----------------------------< pe_poi_bus >------------------------------|
135 -- ----------------------------------------------------------------------------
136 --
137 Procedure pe_poi_bus(p_event varchar2, p_rec pe_poi_shd.g_rec_type);
138 --
139 --
140 -- ----------------------------------------------------------------------------
141 -- |-----------------------------< per_job_bus >------------------------------|
142 -- ----------------------------------------------------------------------------
143 --
144 Procedure per_job_bus(p_event varchar2, p_rec per_job_shd.g_rec_type);
145 --
146 --
147 -- ----------------------------------------------------------------------------
148 -- |-----------------------------< per_dpf_bus >------------------------------|
149 -- ----------------------------------------------------------------------------
150 --
151 Procedure per_dpf_bus(p_event varchar2, p_rec per_dpf_shd.g_rec_type);
152 --
153 --
154 -- ----------------------------------------------------------------------------
155 -- |-----------------------------< per_pse_bus >------------------------------|
156 -- ----------------------------------------------------------------------------
157 --
158 Procedure per_pse_bus(p_event varchar2, p_rec per_pse_shd.g_rec_type);
159 --
160 --
161 -- ----------------------------------------------------------------------------
162 -- |-----------------------------< per_jbr_bus >------------------------------|
163 -- ----------------------------------------------------------------------------
164 --
165 Procedure per_jbr_bus(p_event varchar2, p_rec per_jbr_shd.g_rec_type);
166 --
167 --
168 -- ----------------------------------------------------------------------------
169 -- |-----------------------------< per_vgr_bus >------------------------------|
170 -- ----------------------------------------------------------------------------
171 --
172 Procedure per_vgr_bus(p_event varchar2, p_rec per_vgr_shd.g_rec_type);
173 --
174 --
175 -- ----------------------------------------------------------------------------
176 -- |-----------------------------< per_ose_bus >------------------------------|
177 -- ----------------------------------------------------------------------------
178 --
179 Procedure per_ose_bus(p_event varchar2, p_rec per_ose_shd.g_rec_type);
180 --
181 --
182 --
183 function POSITION_CONTROL_ENABLED(p_org_structure_version_id number,
184 p_organization_id number,
185 p_business_group_id number
186 ) RETURN VARCHAR2;
187 --
188 -- ----------------------------------------------------------------------------
189 -- |-----------------------------< per_asg_wf_sync >------------------------------|
190 -- ----------------------------------------------------------------------------
191 --
192 Procedure per_asg_wf_sync(p_event varchar2, p_rec per_asg_shd.g_rec_type
193 ,p_old_position_id in number default null
194 ,p_effective_date in date
195 ,p_validation_start_date in date
196 ,p_validation_end_date in date
197 ,p_datetrack_mode in varchar2
198 );
199 -- ----------------------------------------------------------------------------
200 -- |---------------------------< my_synch_routine >---------------------------|
201 -- ----------------------------------------------------------------------------
202 --
203 Procedure my_synch_routine(mykey in varchar2);
204
205 --
206 --
207 procedure mysynch_routine(my_parms in wf_parameter_list_t);
208 --
209 end per_pqh_shr;