[Home] [Help]
PACKAGE: APPS.HXC_INTEGRATION_LAYER_V1_GRP
Source
1 PACKAGE HXC_INTEGRATION_LAYER_V1_GRP AUTHID CURRENT_USER AS
2 /* $Header: hxcintegrationv1.pkh 115.6 2004/06/23 14:03:38 jdupont noship $ */
3
4
5 --
6 -- HXC_SELF_SERVICE_TIME_DEPOSIT
7 --
8 -- ----------------------------------------------------------------------------
9 -- |---------------------------< get_app_hook_params >----------------------|
10 -- ----------------------------------------------------------------------------
11 procedure get_app_hook_params(
12 p_building_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.timecard_info
13 ,p_app_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info
14 ,p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table);
15
16 -- ----------------------------------------------------------------------------
17 -- |---------------------------< set_app_hook_params >----------------------|
18 -- ----------------------------------------------------------------------------
19 procedure set_app_hook_params(
20 p_building_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.timecard_info
21 ,p_app_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info
22 ,p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table);
23
24 --
25 -- HXC_GENERIC_RETRIEVAL_PKG
26 --
27 -- ----------------------------------------------------------------------------
28 -- |---------------------------< execute_retrieval_process >-------------------|
29 -- ----------------------------------------------------------------------------
30 PROCEDURE execute_retrieval_process (
31 p_process in hxc_retrieval_processes.name%TYPE
32 ,p_transaction_code in VARCHAR2
33 ,p_start_date in DATE default null
34 ,p_end_date in DATE default null
35 ,p_incremental in VARCHAR2 default 'Y'
36 ,p_rerun_flag in VARCHAR2 default 'N'
37 ,p_where_clause in VARCHAR2
38 ,p_scope in VARCHAR2 default 'DAY'
39 ,p_clusive in VARCHAR2 default 'EX'
40 ,p_unique_params in VARCHAR2 default null);
41
42
43 -- ----------------------------------------------------------------------------
44 -- |---------------------------< Update_Transaction_Status >-------------------|
45 -- ----------------------------------------------------------------------------
46 Procedure Update_Transaction_Status (
47 p_process hxc_retrieval_processes.name%TYPE
48 ,p_status hxc_transactions.status%TYPE
49 ,p_exception_description hxc_transactions.exception_description%TYPE
50 ,p_rollback BOOLEAN DEFAULT FALSE );
51
52 --
53 -- HXC_GENERIC_RETRIEVAL_UTILS
54 --
55 -- ----------------------------------------------------------------------------
56 -- |---------------------------< set_parent_statuses >------------------------|
57 -- ----------------------------------------------------------------------------
58 PROCEDURE set_parent_statuses;
59
60 -- ----------------------------------------------------------------------------
61 -- |---------------------------< time_bld_blk_changed >------------------------|
62 -- ----------------------------------------------------------------------------
63
64 FUNCTION time_bld_blk_changed ( p_bb_id NUMBER
65 , p_bb_ovn NUMBER )RETURN BOOLEAN;
66
67
68 --
69 -- HXC_TIME_ENTRY_RULES_UTILS_PKG
70 --
71 -- ----------------------------------------------------------------------------
72 -- |---------------------------< add_error_to_table >------------------------|
73 -- ----------------------------------------------------------------------------
74 PROCEDURE add_error_to_table (
75 p_message_table in out nocopy HXC_USER_TYPE_DEFINITION_GRP.MESSAGE_TABLE
76 , p_message_name in FND_NEW_MESSAGES.MESSAGE_NAME%TYPE
77 , p_message_token in VARCHAR2
78 , p_message_level in VARCHAR2
79 , p_message_field in VARCHAR2
80 , p_application_short_name IN VARCHAR2 default 'HXC'
81 , p_timecard_bb_id in NUMBER
82 , p_time_attribute_id in NUMBER
83 , p_timecard_bb_ovn in NUMBER default null
84 , p_time_attribute_ovn in NUMBER default null
85 , p_message_extent in VARCHAR2 default null);
86
87
88 --
89 -- HXC_MAPPING_UTILITIES
90 --
91 -- ----------------------------------------------------------------------------
92 -- |---------------------------< get_mappingvalue_sum >------------------------|
93 -- ----------------------------------------------------------------------------
94 FUNCTION get_mappingvalue_sum ( p_bld_blk_info_type VARCHAR2
95 , p_field_name1 VARCHAR2
96 , p_field_name2 VARCHAR2
97 , p_field_value2 VARCHAR2
98 , p_status VARCHAR2
99 , p_resource_id VARCHAR2
100 ) RETURN NUMBER;
101
102 -- ----------------------------------------------------------------------------
103 -- |---------------------------< chk_mapping_exists >------------------------|
104 -- ----------------------------------------------------------------------------
105 FUNCTION chk_mapping_exists ( p_bld_blk_info_type VARCHAR2
106 , p_field_name VARCHAR2
107 , p_field_value VARCHAR2
108 , p_scope VARCHAR2
109 , p_retrieval_process_name VARCHAR2 DEFAULT 'None'
110 , p_status VARCHAR2 DEFAULT 'None'
111 , p_end_date DATE DEFAULT null) RETURN BOOLEAN;
112
113
114 --
115 -- HXC_DEPOSIT_WRAPPER_UTILITIES
116 --
117 -- ----------------------------------------------------------------------------
118 -- |---------------------------< messages_to_string >------------------------|
119 -- ----------------------------------------------------------------------------
120 FUNCTION messages_to_string
121 (p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)
122 RETURN VARCHAR2;
123
124 -- ----------------------------------------------------------------------------
125 -- |---------------------------< attributes_to_string >------------------------|
126 -- ----------------------------------------------------------------------------
127 FUNCTION attributes_to_string(
128 p_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info)
129 RETURN VARCHAR2;
130
131 -- ----------------------------------------------------------------------------
132 -- |---------------------------< blocks_to_string >------------------------|
133 -- ----------------------------------------------------------------------------
134 FUNCTION blocks_to_string
135 (p_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.timecard_info)
136 RETURN VARCHAR2;
137
138
139 --
140 -- HXC_PERIOD_EVALUATION
141 --
142 -- ----------------------------------------------------------------------------
143 -- |---------------------------< period_start_stop >------------------------|
144 -- ----------------------------------------------------------------------------
145 procedure period_start_stop(p_current_date date,
146 p_rec_period_start_date date,
147 l_period_start in out nocopy date,
148 l_period_end in out nocopy date,
149 l_base_period_type varchar2);
150
151 --
152 -- HXC_APPROVAL_WF_PKG
153 --
154 -- ----------------------------------------------------------------------------
155 -- |-----------------< get_wf_G_Time_Building_Blocks >------------------------|
156 -- ----------------------------------------------------------------------------
157 FUNCTION get_wf_g_time_building_blocks
158 RETURN HXC_USER_TYPE_DEFINITION_GRP.timecard_info;
159 -- ----------------------------------------------------------------------------
160 -- |-----------------< get_wf_G_Time_App_Attributes >------------------------|
161 -- ----------------------------------------------------------------------------
162 FUNCTION get_wf_g_time_app_attributes
163 RETURN HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info;
164
165
166 --
167 -- HXC_TIMECARD_INFO
168 --
169 -- ----------------------------------------------------------------------------
170 -- |-----------------< get_timecard_approval_status >------------------------|
171 -- ----------------------------------------------------------------------------
172 FUNCTION get_timecard_approval_status
173 (p_timecard_id in hxc_timecard_summary.timecard_id%type)
174 RETURN hxc_timecard_summary.approval_status%type;
175
176 -- ----------------------------------------------------------------------------
177 -- |-----------------< get_timecard_approval_status 2>------------------------|
178 -- ----------------------------------------------------------------------------
179 FUNCTION get_timecard_approval_status
180 (p_resource_id in hxc_timecard_summary.resource_id%type
181 ,p_start_time in hxc_timecard_summary.start_time%type
182 ,p_stop_time in hxc_timecard_summary.stop_time%type)
183 RETURN hxc_timecard_summary.approval_status%type;
184
185 -- ----------------------------------------------------------------------------
186 -- |-----------------< get_timecard_submission_date 2>------------------------|
187 -- ----------------------------------------------------------------------------
188 FUNCTION get_timecard_submission_date
189 (p_timecard_id in hxc_timecard_summary.timecard_id%type)
190 RETURN hxc_timecard_summary.submission_date%type;
191
192 -- ----------------------------------------------------------------------------
193 -- |-----------------< get_timecard_submission_date 2>------------------------|
194 -- ----------------------------------------------------------------------------
195 FUNCTION get_timecard_submission_date
196 (p_resource_id in hxc_timecard_summary.resource_id%type
197 ,p_start_time in hxc_timecard_summary.start_time%type
198 ,p_stop_time in hxc_timecard_summary.stop_time%type)
199 RETURN hxc_timecard_summary.submission_date%type;
200
201
202 -- ----------------------------------------------------------------------------
203 -- |-----------------< get_timecard_approval_date >------------------------|
204 -- ----------------------------------------------------------------------------
205 FUNCTION get_timecard_approval_date
206 (p_timecard_id in hxc_timecard_summary.timecard_id%type)
207 RETURN hxc_timecard_summary.submission_date%type;
208
209 -- ----------------------------------------------------------------------------
210 -- |-----------------< get_timecard_approval_date 2 >------------------------|
211 -- ----------------------------------------------------------------------------
212
213 FUNCTION get_timecard_approval_date
214 (p_resource_id in hxc_timecard_summary.resource_id%type
215 ,p_start_time in hxc_timecard_summary.start_time%type
216 ,p_stop_time in hxc_timecard_summary.stop_time%type)
217 RETURN hxc_timecard_summary.submission_date%type;
218
219 --
220 -- Straight Interface
221 --
222 -- ----------------------------------------------------------------------------
223 -- |-----------------------------------< build_block >------------------------|
224 -- ----------------------------------------------------------------------------
225 FUNCTION build_block
226 (p_time_building_block_id IN HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
227 ,p_time_building_block_ovn IN HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
228 ) RETURN HXC_USER_TYPE_DEFINITION_GRP.building_block_info;
229
230 -- ----------------------------------------------------------------------------
231 -- |-------------------------------< build_attribute >------------------------|
232 -- ----------------------------------------------------------------------------
233 FUNCTION build_attribute
234 (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
235 ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type
236 ,p_attribute_category in hxc_time_attributes.attribute_category%type
237 ) return HXC_USER_TYPE_DEFINITION_GRP.building_block_attribute_info;
238
239 END HXC_INTEGRATION_LAYER_V1_GRP;