1 PACKAGE hxc_deposit_wrapper_utilities AS
2 /* $Header: hxcdpwrut.pkh 120.0 2005/05/29 05:28:50 appldev noship $ */
3
4 TYPE t_simple_table
5 IS TABLE OF
6 HXC_TIME_BUILDING_BLOCKS.COMMENT_TEXT%TYPE
7 INDEX BY BINARY_INTEGER;
8
9 TYPE dupdff_code_name_rec IS RECORD(
10 dupDFF_CODE FND_DESCR_FLEX_CONTEXTS_VL.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE,
11 dupDFF_NAME FND_DESCR_FLEX_CONTEXTS_VL.DESCRIPTIVE_FLEX_CONTEXT_NAME%TYPE
12 );
13
14 TYPE dupdff_code_name_TABLE IS TABLE OF dupdff_code_name_rec INDEX BY BINARY_INTEGER;
15
16 g_code_name_tab dupdff_code_name_TABLE;
17
18 TYPE r_transaction IS RECORD (
19 txd_id hxc_transaction_details.transaction_detail_id%TYPE
20 , tbb_id hxc_time_building_blocks.time_building_block_id%TYPE
21 , tbb_ovn hxc_time_building_blocks.object_version_number%TYPE
22 , status hxc_transaction_details.status%TYPE
23 , exception_desc hxc_transaction_details.exception_description%TYPE );
24
25 TYPE t_transaction IS TABLE OF r_transaction INDEX BY BINARY_INTEGER;
26
27 PROCEDURE build_context_string
28 (p_context_codes in varchar2
29 ,p_system_linkage in varchar2
30 ,p_expenditure_type in varchar2
31 ,p_pa_alias_value_id in varchar2
32 ,p_context_string out nocopy varchar2
33 );
34
35 PROCEDURE get_preferences
36 (p_resource_id in number
37 ,p_preference_string in varchar2
38 ,p_include_pp in varchar2
39 ,p_preference_date in varchar2
40 ,p_preference_end_date in varchar2
41 ,p_timecard_id in number
42 ,p_preference_returns out nocopy varchar2
43 );
44
45 FUNCTION blocks_to_string
46 (p_blocks IN hxc_self_service_time_deposit.timecard_info)
47 RETURN VARCHAR2;
48
49 FUNCTION string_to_blocks
50 (p_block_string IN varchar2)
51 RETURN hxc_self_service_time_deposit.timecard_info;
52
53 FUNCTION attributes_to_string
54 (p_attributes IN hxc_self_service_time_deposit.app_attributes_info)
55 RETURN VARCHAR2;
56
57 FUNCTION string_to_attributes
58 (p_attribute_string IN varchar2)
59 RETURN hxc_self_service_time_deposit.app_attributes_info;
60
61 FUNCTION string_to_bld_blk_attributes
62 (p_attribute_string IN varchar2)
63 RETURN hxc_self_service_time_deposit.building_block_attribute_info;
64
65 FUNCTION messages_to_string
66 (p_messages IN hxc_self_service_time_deposit.message_table)
67 RETURN VARCHAR2;
68
69 FUNCTION string_to_messages
70 (p_message_string IN varchar2)
71 RETURN hxc_self_service_time_deposit.message_table;
72
73
74 FUNCTION attributes_to_string(
75 p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
76 )
77 RETURN VARCHAR2;
78
79 PROCEDURE STRING_TO_TABLE(p_separator IN VARCHAR2,
80 p_string IN VARCHAR2,
81 p_table OUT NOCOPY t_simple_table);
82
83 procedure audit_transaction
84 (p_effective_date in date
85 ,p_transaction_type in varchar2
86 ,p_transaction_process_id in number
87 ,p_overall_status in varchar2
88 ,p_transaction_tab in out nocopy t_transaction
89 );
90
91 ----
92 -- Function returning a list of hours types and ids for use on the timecard
93 ----
94
95 function timecard_hours_type_list( p_resource_id in varchar2,
96 p_start_time in varchar2,
97 p_stop_time in varchar2,
98 p_alias_or_element_id in varchar2) return varchar2;
99
100
101
102
103 FUNCTION array_to_attributes(
104 p_attribute_array IN HXC_ATTRIBUTE_TABLE_TYPE
105 )
106 RETURN hxc_self_service_time_deposit.building_block_attribute_info;
107
108 FUNCTION attributes_to_array(
109 p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
110 )
111 RETURN HXC_ATTRIBUTE_TABLE_TYPE;
112
113 FUNCTION array_to_blocks(
114 p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
115 )
116 RETURN hxc_self_service_time_deposit.timecard_info;
117
118 FUNCTION blocks_to_array(
119 p_blocks IN hxc_self_service_time_deposit.timecard_info
120 )
121 RETURN HXC_BLOCK_TABLE_TYPE;
122
123 FUNCTION get_dupdff_code(p_dupdff_name IN VARCHAR2) return varchar2;
124
125 FUNCTION get_dupdff_name(p_dupdff_code IN VARCHAR2) return varchar2;
126
127 function timecard_hours_type_list( p_resource_id in varchar2,
128 p_start_time in varchar2,
129 p_stop_time in varchar2,
130 p_alias_or_element_id in varchar2,
131 p_aliases in VARCHAR2,
132 p_public_template in varchar2) return varchar2;
133
134 procedure replace_resource_id(p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE,
135 p_resource_id IN hxc_time_building_blocks.resource_id%type);
136
137 END hxc_deposit_wrapper_utilities;