1 PACKAGE HXC_ALIAS_TRANSLATOR AS
2 /* $Header: hxcalttlr.pkh 120.1.12010000.2 2008/08/05 11:59:28 ubhat ship $ */
3
4
5 g_attribute_id NUMBER := -1;
6
7
8 -- Bug No : 6943339
9 -- Created the below associative array to hold the value set formats across
10 -- the alias translation procedures. Used an associative array because
11 -- we need to use this only if Alt name is based on value set - none
12 -- and we need it to be indexed with the reference object's ( the flex_
13 -- _value_set ) id.
14 -- Used VARCHAR2 as the type because an INTEGER index would give only
15 -- upto 10 digits while the reference object id could be as big as 15.
16
17 TYPE assoc_array IS TABLE OF VARCHAR2(5) INDEX BY VARCHAR2(20);
18 g_vset_fmt assoc_array;
19
20
21 PROCEDURE do_deposit_translation
22 (p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE--hxc_self_service_time_deposit.building_block_attribute_info);
23 ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE);
24
25 PROCEDURE do_retrieval_translation
26 (p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE--hxc_self_service_time_deposit.building_block_attribute_info
27 ,p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE--hxc_self_service_time_deposit.timecard_info
28 ,p_start_time IN DATE DEFAULT sysdate
29 ,p_stop_time IN DATE DEFAULT hr_general.end_of_time
30 ,p_resource_id IN NUMBER -- timekeeper or resource
31 ,p_processing_mode IN VARCHAR2 DEFAULT hxc_alias_utility.c_ss_processing
32 ,p_add_alias_display_value IN BOOLEAN DEFAULT FALSE
33 ,p_add_alias_ref_object IN BOOLEAN DEFAULT FALSE
34 ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
35 );
36
37 END HXC_ALIAS_TRANSLATOR;