eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.HXC_SELF_SERVICE_TIME_DEPOSIT

Source


1 PACKAGE hxc_self_service_time_deposit AS
2 /* $Header: hxctcdpwr.pkh 120.2 2005/12/05 14:18:50 arundell noship $ */
3 
4    TYPE translate_bb_ids_rec IS RECORD (
5       actual_bb_id                  hxc_time_building_blocks.time_building_block_id%TYPE);
6 
7    TYPE translate_bb_ids_tab IS TABLE OF translate_bb_ids_rec
8       INDEX BY BINARY_INTEGER;
9 
10    TYPE translate_ta_ids_rec IS RECORD (
11       actual_ta_id                  hxc_time_attributes.time_attribute_id%TYPE);
12 
13    TYPE translate_ta_ids_tab IS TABLE OF translate_ta_ids_rec
14       INDEX BY BINARY_INTEGER;
15 
16    TYPE workflow_info IS RECORD (
17       item_type                     wf_items.item_type%TYPE,
18       process_name                  wf_activities.NAME%TYPE);
19 
20    TYPE message_info IS RECORD (
21       message_name                  fnd_new_messages.message_name%TYPE,
22       message_level                 VARCHAR2 (30),
23       message_field                 VARCHAR2(2000),
24       message_tokens                VARCHAR2 (4000), -- Bug 3036930
25       application_short_name        fnd_application.application_short_name%TYPE,
26       time_building_block_id        hxc_time_building_blocks.time_building_block_id%TYPE,
27       time_building_block_ovn       hxc_time_building_blocks.object_version_number%TYPE,
28       time_attribute_id             hxc_time_attributes.time_attribute_id%TYPE,
29       time_attribute_ovn            hxc_time_attributes.object_version_number%TYPE,
30       on_oa_msg_stack               BOOLEAN := FALSE, --AI5
31       message_extent                VARCHAR2 (20)		--Bug#2873563
32                        );
33 
34    TYPE message_table IS TABLE OF message_info
35       INDEX BY BINARY_INTEGER;
36 
37    TYPE attribute_info IS RECORD (
38       time_attribute_id             hxc_time_attributes.time_attribute_id%TYPE,
39       building_block_id             hxc_time_building_blocks.time_building_block_id%TYPE,
40       bld_blk_info_type             hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
41       attribute_category            hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
42       attribute1                    hxc_time_attributes.attribute1%TYPE,
43       attribute2                    hxc_time_attributes.attribute2%TYPE,
44       attribute3                    hxc_time_attributes.attribute3%TYPE,
45       attribute4                    hxc_time_attributes.attribute4%TYPE,
46       attribute5                    hxc_time_attributes.attribute5%TYPE,
47       attribute6                    hxc_time_attributes.attribute6%TYPE,
48       attribute7                    hxc_time_attributes.attribute7%TYPE,
49       attribute8                    hxc_time_attributes.attribute8%TYPE,
50       attribute9                    hxc_time_attributes.attribute9%TYPE,
51       attribute10                   hxc_time_attributes.attribute10%TYPE,
52       attribute11                   hxc_time_attributes.attribute11%TYPE,
53       attribute12                   hxc_time_attributes.attribute12%TYPE,
54       attribute13                   hxc_time_attributes.attribute13%TYPE,
55       attribute14                   hxc_time_attributes.attribute14%TYPE,
56       attribute15                   hxc_time_attributes.attribute15%TYPE,
57       attribute16                   hxc_time_attributes.attribute16%TYPE,
58       attribute17                   hxc_time_attributes.attribute17%TYPE,
59       attribute18                   hxc_time_attributes.attribute18%TYPE,
60       attribute19                   hxc_time_attributes.attribute19%TYPE,
61       attribute20                   hxc_time_attributes.attribute20%TYPE,
62       attribute21                   hxc_time_attributes.attribute21%TYPE,
63       attribute22                   hxc_time_attributes.attribute22%TYPE,
64       attribute23                   hxc_time_attributes.attribute23%TYPE,
65       attribute24                   hxc_time_attributes.attribute24%TYPE,
66       attribute25                   hxc_time_attributes.attribute25%TYPE,
67       attribute26                   hxc_time_attributes.attribute26%TYPE,
68       attribute27                   hxc_time_attributes.attribute27%TYPE,
69       attribute28                   hxc_time_attributes.attribute28%TYPE,
70       attribute29                   hxc_time_attributes.attribute29%TYPE,
71       attribute30                   hxc_time_attributes.attribute30%TYPE,
72       bld_blk_info_type_id          hxc_time_attributes.bld_blk_info_type_id%TYPE,
73       object_version_number         hxc_time_attributes.object_version_number%TYPE,
74       NEW                           VARCHAR2 (30),
75       changed                       VARCHAR2 (30),
76       process                       VARCHAR2 (30));
77 
78    TYPE building_block_attribute_info IS TABLE OF attribute_info
79       INDEX BY BINARY_INTEGER;
80 
81    TYPE app_attributes IS RECORD (
82       time_attribute_id             hxc_time_attributes.time_attribute_id%TYPE,
83       building_block_id             hxc_time_building_blocks.time_building_block_id%TYPE,
84       attribute_name                hxc_mapping_components.field_name%TYPE,
85       attribute_value               hxc_time_attributes.attribute1%TYPE,
86       attribute_index               number,
87       segment                       hxc_mapping_components.segment%type,
88       bld_blk_info_type             hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
89       CATEGORY                      hxc_bld_blk_info_type_usages.building_block_category%TYPE,
90       updated                       VARCHAR2 (30),
91       changed                       VARCHAR2 (30),
92       process                       VARCHAR2 (30)); --SHIV
93 
94    TYPE app_attributes_info IS TABLE OF app_attributes
95       INDEX BY BINARY_INTEGER;
96 
97    TYPE building_block_info IS RECORD (
98       time_building_block_id        hxc_time_building_blocks.time_building_block_id%TYPE,
99       TYPE                          hxc_time_building_blocks.TYPE%TYPE,
100       measure                       hxc_time_building_blocks.measure%TYPE,
101       unit_of_measure               hxc_time_building_blocks.unit_of_measure%TYPE,
102       start_time                    hxc_time_building_blocks.start_time%TYPE,
103       stop_time                     hxc_time_building_blocks.stop_time%TYPE,
104       parent_building_block_id      hxc_time_building_blocks.parent_building_block_id%TYPE,
105       parent_is_new                 VARCHAR2 (1),
106       SCOPE                         hxc_time_building_blocks.SCOPE%TYPE,
107       object_version_number         hxc_time_building_blocks.object_version_number%TYPE,
108       approval_status               hxc_time_building_blocks.approval_status%TYPE,
109       resource_id                   hxc_time_building_blocks.resource_id%TYPE,
110       resource_type                 hxc_time_building_blocks.resource_type%TYPE,
111       approval_style_id             hxc_time_building_blocks.approval_style_id%TYPE,
112       date_from                     hxc_time_building_blocks.date_from%TYPE,
113       date_to                       hxc_time_building_blocks.date_to%TYPE,
114       comment_text                  hxc_time_building_blocks.comment_text%TYPE,
115       parent_building_block_ovn     hxc_time_building_blocks.parent_building_block_ovn%TYPE,
116       NEW                           VARCHAR2 (30),
117       changed                       VARCHAR2 (30),
118       process                       varchar2 (30),
119       application_set_id            hxc_time_building_blocks.application_set_id%type,
120       translation_display_key       hxc_time_building_blocks.translation_display_key%type);
121 
122    TYPE timecard_info IS TABLE OF building_block_info
123       INDEX BY BINARY_INTEGER;
124 
125    PROCEDURE set_workflow_info (
126       p_item_type      IN   wf_items.item_type%TYPE,
127       p_process_name   IN   wf_activities.NAME%TYPE
128    );
129 
130    PROCEDURE initialize_globals;
131 
132    PROCEDURE show_errors (p_messages IN OUT NOCOPY message_table);
133 
134    FUNCTION build_application_attributes (
135       p_retrieval_process_id   IN   NUMBER,
136       p_deposit_process_id     IN   NUMBER --AI3
137                                           ,
138       p_for_time_attributes    IN   BOOLEAN
139    )
140       RETURN app_attributes_info;
141 
142    PROCEDURE deposit_attribute_info (
143       p_time_attribute_id       IN   NUMBER,
144       p_building_block_id       IN   NUMBER,
145       p_bld_blk_info_type       IN   VARCHAR2,
146       p_attribute_category      IN   VARCHAR2,
147       p_attribute1              IN   VARCHAR2,
148       p_attribute2              IN   VARCHAR2,
149       p_attribute3              IN   VARCHAR2,
150       p_attribute4              IN   VARCHAR2,
151       p_attribute5              IN   VARCHAR2,
152       p_attribute6              IN   VARCHAR2,
153       p_attribute7              IN   VARCHAR2,
154       p_attribute8              IN   VARCHAR2,
155       p_attribute9              IN   VARCHAR2,
156       p_attribute10             IN   VARCHAR2,
157       p_attribute11             IN   VARCHAR2,
158       p_attribute12             IN   VARCHAR2,
159       p_attribute13             IN   VARCHAR2,
160       p_attribute14             IN   VARCHAR2,
161       p_attribute15             IN   VARCHAR2,
162       p_attribute16             IN   VARCHAR2,
163       p_attribute17             IN   VARCHAR2,
164       p_attribute18             IN   VARCHAR2,
165       p_attribute19             IN   VARCHAR2,
166       p_attribute20             IN   VARCHAR2,
167       p_attribute21             IN   VARCHAR2,
168       p_attribute22             IN   VARCHAR2,
169       p_attribute23             IN   VARCHAR2,
170       p_attribute24             IN   VARCHAR2,
171       p_attribute25             IN   VARCHAR2,
172       p_attribute26             IN   VARCHAR2,
173       p_attribute27             IN   VARCHAR2,
174       p_attribute28             IN   VARCHAR2,
175       p_attribute29             IN   VARCHAR2,
176       p_attribute30             IN   VARCHAR2,
177       p_bld_blk_info_type_id    IN   NUMBER,
178       p_object_version_number   IN   NUMBER,
179       p_new                     IN   VARCHAR2,
180       p_changed                 IN   VARCHAR2
181    );
182 
183    PROCEDURE call_attribute_deposit (
184       p_time_attribute_id       IN   VARCHAR2,
185       p_building_block_id       IN   VARCHAR2,
186       p_bld_blk_info_type       IN   VARCHAR2,
187       p_attribute_category      IN   VARCHAR2,
188       p_attribute1              IN   VARCHAR2,
189       p_attribute2              IN   VARCHAR2,
190       p_attribute3              IN   VARCHAR2,
191       p_attribute4              IN   VARCHAR2,
192       p_attribute5              IN   VARCHAR2,
193       p_attribute6              IN   VARCHAR2,
194       p_attribute7              IN   VARCHAR2,
195       p_attribute8              IN   VARCHAR2,
196       p_attribute9              IN   VARCHAR2,
197       p_attribute10             IN   VARCHAR2,
198       p_attribute11             IN   VARCHAR2,
199       p_attribute12             IN   VARCHAR2,
200       p_attribute13             IN   VARCHAR2,
201       p_attribute14             IN   VARCHAR2,
202       p_attribute15             IN   VARCHAR2,
203       p_attribute16             IN   VARCHAR2,
204       p_attribute17             IN   VARCHAR2,
205       p_attribute18             IN   VARCHAR2,
206       p_attribute19             IN   VARCHAR2,
207       p_attribute20             IN   VARCHAR2,
208       p_attribute21             IN   VARCHAR2,
209       p_attribute22             IN   VARCHAR2,
210       p_attribute23             IN   VARCHAR2,
211       p_attribute24             IN   VARCHAR2,
212       p_attribute25             IN   VARCHAR2,
213       p_attribute26             IN   VARCHAR2,
214       p_attribute27             IN   VARCHAR2,
215       p_attribute28             IN   VARCHAR2,
216       p_attribute29             IN   VARCHAR2,
217       p_attribute30             IN   VARCHAR2,
218       p_bld_blk_info_type_id    IN   VARCHAR2,
219       p_object_version_number   IN   VARCHAR2,
220       p_new                     IN   VARCHAR2,
221       p_changed                 IN   VARCHAR2
222    );
223 
224    PROCEDURE call_block_deposit (
225       p_time_building_block_id      IN   VARCHAR2,
226       p_type                        IN   VARCHAR2,
227       p_measure                     IN   VARCHAR2,
228       p_unit_of_measure             IN   VARCHAR2,
229       p_start_time                  IN   VARCHAR2,
230       p_stop_time                   IN   VARCHAR2,
231       p_parent_building_block_id    IN   VARCHAR2,
232       p_parent_is_new               IN   VARCHAR2,
233       p_scope                       IN   VARCHAR2,
234       p_object_version_number       IN   VARCHAR2,
235       p_approval_status             IN   VARCHAR2,
236       p_resource_id                 IN   VARCHAR2,
237       p_resource_type               IN   VARCHAR2,
238       p_approval_style_id           IN   VARCHAR2,
239       p_date_from                   IN   VARCHAR2,
240       p_date_to                     IN   VARCHAR2,
241       p_comment_text                IN   VARCHAR2,
242       p_parent_building_block_ovn   IN   VARCHAR2,
243       p_new                         IN   VARCHAR2,
244       p_changed                     IN   VARCHAR2
245    );
246 
247    PROCEDURE deposit_block_info (
248       p_time_building_block_id      IN   NUMBER,
249       p_type                        IN   VARCHAR2,
250       p_measure                     IN   NUMBER,
251       p_unit_of_measure             IN   VARCHAR2,
252       p_start_time                  IN   DATE,
253       p_stop_time                   IN   DATE,
254       p_parent_building_block_id    IN   NUMBER,
255       p_parent_is_new               IN   VARCHAR2,
256       p_scope                       IN   VARCHAR2,
257       p_object_version_number       IN   NUMBER,
258       p_approval_status             IN   VARCHAR2,
259       p_resource_id                 IN   NUMBER,
260       p_resource_type               IN   VARCHAR2,
261       p_approval_style_id           IN   NUMBER,
262       p_date_from                   IN   DATE,
263       p_date_to                     IN   DATE,
264       p_comment_text                IN   VARCHAR2,
265       p_parent_building_block_ovn   IN   NUMBER,
266       p_new                         IN   VARCHAR2,
267       p_changed                     IN   VARCHAR2
268    );
269 
270    PROCEDURE alias_translation;
271 
272    PROCEDURE deposit_blocks (
273       p_timecard_id         OUT NOCOPY   hxc_time_building_blocks.time_building_block_id%TYPE,
274       p_timecard_ovn        OUT NOCOPY   hxc_time_building_blocks.object_version_number%TYPE,
275       p_mode                      VARCHAR2,
276       p_deposit_process           VARCHAR2,
277       p_retrieval_process         VARCHAR2 DEFAULT NULL,
278       p_validate_session          BOOLEAN DEFAULT TRUE,
279       p_add_security              BOOLEAN DEFAULT TRUE,
280       p_allow_error_tc            BOOLEAN DEFAULT FALSE
281    );
282 
283    PROCEDURE delete_timecard (
284       p_time_building_block_id   IN   NUMBER,
285       p_effective_date           IN   DATE,
286       p_mode                          VARCHAR2,
287       p_deposit_process               VARCHAR2,
288       p_retrieval_process             VARCHAR2
289    );
290 
291    FUNCTION get_building_blocks
292       RETURN timecard_info;
293 
294    FUNCTION get_block_attributes
295       RETURN building_block_attribute_info;
296 
297    FUNCTION get_app_attributes
298       RETURN app_attributes_info;
299 
300    FUNCTION get_messages
301       RETURN message_table;
302 
303    PROCEDURE get_app_hook_params (
304       p_building_blocks   OUT NOCOPY   timecard_info,
305       p_app_attributes    OUT NOCOPY   app_attributes_info,
306       p_messages          OUT NOCOPY   message_table
307    );
308 
309    PROCEDURE set_app_hook_params (
310       p_building_blocks   IN   timecard_info,
311       p_app_attributes    IN   app_attributes_info,
312       p_messages          IN   message_table
313    );
314 
315    PROCEDURE set_global_table (
316       p_building_blocks   IN   timecard_info,
317       p_attributes        IN   building_block_attribute_info
318    );
319 
320    PROCEDURE set_update_phase (p_mode IN BOOLEAN); --AI2.5
321 
322    --
323    -- Given a Timecard scope BB ID and OVN, get the whole timecard
324    -- structure in the usual table structure.
325    -- Overloaded version of next procedure
326    PROCEDURE get_timecard_tables (
327       p_timecard_id               IN       NUMBER,
328       p_timecard_ovn              IN       NUMBER,
329       p_timecard_blocks           OUT NOCOPY      hxc_self_service_time_deposit.timecard_info,
330       p_timecard_app_attributes   OUT NOCOPY      hxc_self_service_time_deposit.app_attributes_info,
331       p_time_recipient_id         IN       NUMBER
332    );
333 
334    PROCEDURE get_timecard_tables (
335       p_timecard_id               IN       NUMBER,
336       p_timecard_ovn              IN       NUMBER,
337       p_timecard_blocks           OUT NOCOPY      hxc_self_service_time_deposit.timecard_info,
338       p_timecard_app_attributes   OUT NOCOPY      hxc_self_service_time_deposit.app_attributes_info,
339       p_deposit_process_id        IN       NUMBER,
340       p_retrieval_process_id      IN       NUMBER
341    );
342 
343    PROCEDURE update_deposit_globals (
344       p_retrieval_process_id   IN   NUMBER DEFAULT NULL,
345       p_deposit_process_id     IN   NUMBER DEFAULT NULL
346    );
347 
348    FUNCTION get_new_attribute_id
349       RETURN NUMBER;
350 
351    FUNCTION attribute_check (
352       p_to_check                 IN   VARCHAR2,
353       p_time_building_block_id   IN   hxc_time_building_blocks.time_building_block_id%TYPE
354    )
355       RETURN BOOLEAN;
356 
357    FUNCTION get_bld_blk_type_id (p_type IN VARCHAR2)
358       RETURN NUMBER;
359 
360    PROCEDURE set_g_attributes ( p_attributes building_block_attribute_info );
361 
362 END hxc_self_service_time_deposit;