1 PACKAGE PSB_HR_EXTRACT_DATA_PVT AUTHID CURRENT_USER AS
2 /* $Header: PSBVHRXS.pls 115.9 2003/07/18 12:56:16 vbellur ship $ */
3
4 g_block_str varchar2(2500);
5 g_ldcursor number;
6 g_psb_num_dist number;
7
8 TYPE g_ldcostmap_rec_type IS RECORD
9 (gl_code_combination_id NUMBER,
10 project_id NUMBER,
11 task_id NUMBER,
12 award_id NUMBER,
13 expenditure_organization_id NUMBER,
14 expenditure_type VARCHAR2(30),
15 percent NUMBER(5,2),
16 effective_start_date DATE,
17 effective_end_date DATE,
18 --UTF8 changes for Bug No : 2615261
19 description psb_cost_distributions_i.description%TYPE
20 );
21
22 TYPE g_ldcostmap_tbl_type is TABLE OF g_ldcostmap_rec_type
23 INDEX BY BINARY_INTEGER;
24
25 g_psb_rec g_ldcostmap_tbl_type;
26
27 Cursor G_Employee_Details(p_person_id in number) is
28 Select first_name , last_name
29 from per_all_people
30 where person_id = p_person_id;
31
32 Cursor G_Position_Details(p_position_id in number) is
33 Select name
34 from per_all_positions
35 where position_id = p_position_id;
36
37 PROCEDURE Init(p_date in OUT NOCOPY date);
38
39 PROCEDURE Get_Position_Information
40 ( p_api_version IN NUMBER,
41 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
42 p_commit IN VARCHAR2 := FND_API.G_FALSE,
43 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44 p_return_status OUT NOCOPY VARCHAR2,
45 p_msg_count OUT NOCOPY NUMBER,
46 p_msg_data OUT NOCOPY VARCHAR2,
47 p_data_extract_id IN NUMBER,
48 -- de by org
49 p_extract_by_org IN VARCHAR2,
50 p_extract_method IN VARCHAR2,
51 p_id_flex_num IN NUMBER,
52 p_date IN DATE,
53 p_business_group_id IN NUMBER,
54 p_set_of_books_id IN NUMBER
55
56 );
57
58 PROCEDURE Get_Employee_Information
59 ( p_api_version IN NUMBER,
60 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61 p_commit IN VARCHAR2 := FND_API.G_FALSE,
62 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63 p_return_status OUT NOCOPY VARCHAR2,
64 p_msg_count OUT NOCOPY NUMBER,
65 p_msg_data OUT NOCOPY VARCHAR2,
66 p_data_extract_id IN NUMBER,
67 -- de by org
68 p_extract_by_org IN VARCHAR2,
69 p_extract_method IN VARCHAR2,
70 p_date IN DATE,
71 p_business_group_id IN NUMBER,
72 p_set_of_books_id IN NUMBER,
73 p_copy_defaults_flag IN VARCHAR2,
74 p_copy_salary_flag IN VARCHAR2
75 );
76
77 PROCEDURE Get_Salary_Information
78 ( p_api_version IN NUMBER,
79 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
80 p_commit IN VARCHAR2 := FND_API.G_FALSE,
81 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82 p_return_status OUT NOCOPY VARCHAR2,
83 p_msg_count OUT NOCOPY NUMBER,
84 p_msg_data OUT NOCOPY VARCHAR2,
85 p_data_extract_id IN NUMBER,
86 p_extract_method IN VARCHAR2,
87 p_business_group_id IN NUMBER
88 );
89
90 PROCEDURE Get_Costing_Information
91 ( p_api_version IN NUMBER,
92 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
93 p_commit IN VARCHAR2 := FND_API.G_FALSE,
94 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95 p_return_status OUT NOCOPY VARCHAR2,
96 p_msg_count OUT NOCOPY NUMBER,
97 p_msg_data OUT NOCOPY VARCHAR2,
98 p_data_extract_id IN NUMBER,
99 -- de by org
100 p_extract_by_org IN VARCHAR2,
101 p_extract_method IN VARCHAR2,
102 p_date IN DATE,
103 p_business_group_id IN NUMBER,
104 p_set_of_books_id IN NUMBER
105 );
106
107
108 PROCEDURE Get_Attributes
109 ( p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
111 p_commit IN VARCHAR2 := FND_API.G_FALSE,
112 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
113 p_return_status OUT NOCOPY VARCHAR2,
114 p_msg_count OUT NOCOPY NUMBER,
115 p_msg_data OUT NOCOPY VARCHAR2,
116 p_data_extract_id IN NUMBER,
117 p_extract_method IN VARCHAR2,
118 p_business_group_id IN NUMBER
119 );
120
121 PROCEDURE Get_Employee_Attributes
122 ( p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
124 p_commit IN VARCHAR2 := FND_API.G_FALSE,
125 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
126 p_return_status OUT NOCOPY VARCHAR2,
127 p_msg_count OUT NOCOPY NUMBER,
128 p_msg_data OUT NOCOPY VARCHAR2,
129 p_data_extract_id IN NUMBER,
130 -- de by org
131 p_extract_by_org IN VARCHAR2,
132 p_extract_method IN VARCHAR2,
133 p_date IN DATE,
134 p_business_group_id IN NUMBER,
135 p_set_of_books_id IN NUMBER
136 );
137
138 PROCEDURE Update_Reentry
139 ( p_api_version IN NUMBER,
140 p_return_status OUT NOCOPY VARCHAR2,
141 p_msg_count OUT NOCOPY NUMBER,
142 p_msg_data OUT NOCOPY VARCHAR2,
143 p_data_extract_id IN NUMBER,
144 p_extract_method IN VARCHAR2,
145 p_process IN VARCHAR2,
146 p_restart_id IN NUMBER
147 ) ;
148
149 PROCEDURE Check_Reentry
150 ( p_api_version IN NUMBER,
151 p_return_status OUT NOCOPY VARCHAR2,
152 p_msg_count OUT NOCOPY NUMBER,
153 p_msg_data OUT NOCOPY VARCHAR2,
154 p_data_extract_id IN NUMBER,
155 p_process IN VARCHAR2,
156 p_status OUT NOCOPY VARCHAR2,
157 p_restart_id OUT NOCOPY NUMBER
158 ) ;
159
160 PROCEDURE Reentrant_Process
161 ( p_api_version IN NUMBER,
162 p_return_status OUT NOCOPY VARCHAR2,
163 p_msg_count OUT NOCOPY NUMBER,
164 p_msg_data OUT NOCOPY VARCHAR2,
165 p_data_extract_id IN NUMBER,
166 p_extract_method IN VARCHAR2,
167 p_process IN VARCHAR2
168 );
169
170 PROCEDURE Final_Process;
171
172 PROCEDURE Get_LD_Schedule
173 ( p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
175 p_commit IN VARCHAR2 := FND_API.G_FALSE,
176 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177 p_return_status OUT NOCOPY VARCHAR2,
178 p_msg_count OUT NOCOPY NUMBER,
179 p_msg_data OUT NOCOPY VARCHAR2,
180 p_assignment_id IN NUMBER,
181 p_date IN DATE,
182 p_effective_start_date IN DATE,
183 p_effective_end_date IN DATE,
184 p_chart_of_accounts_id IN NUMBER,
185 p_data_extract_id IN NUMBER,
186 p_business_group_id IN NUMBER,
187 p_set_of_books_id IN NUMBER,
188 p_mode IN VARCHAR2 := 'D');
189
190 PROCEDURE Validate_Attribute_Mapping
191 ( p_api_version IN NUMBER,
192 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
193 p_commit IN VARCHAR2 := FND_API.G_FALSE,
194 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
195 p_return_status OUT NOCOPY VARCHAR2,
196 p_msg_count OUT NOCOPY NUMBER,
197 p_msg_data OUT NOCOPY VARCHAR2,
198 p_business_group_id IN NUMBER,
199 p_attribute_type_id IN NUMBER,
200 p_definition_structure IN VARCHAR2 ,
201 p_definition_table IN VARCHAR2 ,
202 p_definition_column IN VARCHAR2
203 );
204
205 FUNCTION get_debug RETURN VARCHAR2;
206 FUNCTION get_segment_val (pseg_num varchar2,
207 pcost_allocation_keyflex_id number)
208 RETURN VARCHAR2;
209
210 FUNCTION Is_LD_Enabled
211 ( p_business_group_id IN NUMBER
212 ) RETURN BOOLEAN;
213
214 END PSB_HR_EXTRACT_DATA_PVT;
[Home] [Help]