DBA Data[Home] [Help]

APPS.HXC_TIMECARD_AUDIT dependencies on HXC_TIMECARD

Line 1: PACKAGE BODY hxc_timecard_audit AS

1: PACKAGE BODY hxc_timecard_audit AS
2: /* $Header: hxctcaudit.pkb 120.2 2005/09/23 09:02:16 nissharm noship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:

Line 7: (p_transaction_info in hxc_timecard.transaction_info

3:
4: g_debug boolean := hr_utility.debug_enabled;
5:
6: Function find_overall_status
7: (p_transaction_info in hxc_timecard.transaction_info
8: ) return varchar2 is
9:
10: l_index NUMBER;
11: l_status varchar2(20);

Line 22: (l_status <> hxc_timecard.c_trans_success)

18: EXIT WHEN
19: (
20: (NOT p_transaction_info.exists(l_index))
21: OR
22: (l_status <> hxc_timecard.c_trans_success)
23: );
24:
25: l_status := p_transaction_info(l_index).status;
26:

Line 37: ,p_transaction_info in hxc_timecard.transaction_info

33: End find_overall_status;
34:
35: Procedure insert_audit_header
36: (p_overall_status in varchar2
37: ,p_transaction_info in hxc_timecard.transaction_info
38: ,p_messages in out nocopy hxc_message_table_type
39: ,p_transaction_id out nocopy hxc_transactions.transaction_id%type
40: ) is
41:

Line 98: (p_transaction_info in out nocopy hxc_timecard.transaction_info

94:
95: End insert_audit_header;
96:
97: Procedure insert_audit_details
98: (p_transaction_info in out nocopy hxc_timecard.transaction_info
99: ,p_messages in out nocopy hxc_message_table_type
100: ,p_transaction_id in hxc_transactions.transaction_id%type
101: ) is
102:

Line 158: (p_transaction_info in out nocopy hxc_timecard.transaction_info

154:
155: End insert_audit_details;
156:
157: Procedure audit_deposit
158: (p_transaction_info in out nocopy hxc_timecard.transaction_info
159: ,p_messages in out nocopy hxc_message_table_type
160: ) is
161:
162: PRAGMA AUTONOMOUS_TRANSACTION;

Line 189: l_timecard_blocks hxc_timecard.block_list;

185: Procedure maintain_latest_details
186: (p_blocks in hxc_block_table_type
187: ) IS
188:
189: l_timecard_blocks hxc_timecard.block_list;
190: l_day_blocks hxc_timecard.block_list;
191: l_detail_blocks hxc_timecard.block_list;
192:
193: l_detail_ind PLS_INTEGER;

Line 190: l_day_blocks hxc_timecard.block_list;

186: (p_blocks in hxc_block_table_type
187: ) IS
188:
189: l_timecard_blocks hxc_timecard.block_list;
190: l_day_blocks hxc_timecard.block_list;
191: l_detail_blocks hxc_timecard.block_list;
192:
193: l_detail_ind PLS_INTEGER;
194:

Line 191: l_detail_blocks hxc_timecard.block_list;

187: ) IS
188:
189: l_timecard_blocks hxc_timecard.block_list;
190: l_day_blocks hxc_timecard.block_list;
191: l_detail_blocks hxc_timecard.block_list;
192:
193: l_detail_ind PLS_INTEGER;
194:
195: l_blk_ind PLS_INTEGER;

Line 207: hxc_timecard_block_utils.sort_blocks

203: if g_debug then
204: hr_utility.trace('GAZ in maintain details 1');
205: end if;
206:
207: hxc_timecard_block_utils.sort_blocks
208: (p_blocks => p_blocks
209: ,p_timecard_blocks => l_timecard_blocks
210: ,p_day_blocks => l_day_blocks
211: ,p_detail_blocks => l_detail_blocks

Line 268: hxc_timecard_block_utils.date_value(

264: p_blocks(l_blk_ind).resource_id,
265: p_blocks(l_blk_ind).time_building_block_id,
266: p_blocks(l_blk_ind).object_version_number,
267: l_status,
268: hxc_timecard_block_utils.date_value(
269: p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).start_time),
270: hxc_timecard_block_utils.date_value(
271: p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).stop_time),
272: p_blocks(l_blk_ind).application_set_id,

Line 270: hxc_timecard_block_utils.date_value(

266: p_blocks(l_blk_ind).object_version_number,
267: l_status,
268: hxc_timecard_block_utils.date_value(
269: p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).start_time),
270: hxc_timecard_block_utils.date_value(
271: p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).stop_time),
272: p_blocks(l_blk_ind).application_set_id,
273: sysdate,
274: p_blocks(l_blk_ind).comment_text,

Line 315: hxc_timecard_block_utils.date_value(

311: p_blocks(l_blk_ind).resource_id,
312: p_blocks(l_blk_ind).time_building_block_id,
313: p_blocks(l_blk_ind).object_version_number,
314: l_status,
315: hxc_timecard_block_utils.date_value(
316: p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).start_time),
317: hxc_timecard_block_utils.date_value(
318: p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).stop_time),
319: p_blocks(l_blk_ind).application_set_id,

Line 317: hxc_timecard_block_utils.date_value(

313: p_blocks(l_blk_ind).object_version_number,
314: l_status,
315: hxc_timecard_block_utils.date_value(
316: p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).start_time),
317: hxc_timecard_block_utils.date_value(
318: p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).stop_time),
319: p_blocks(l_blk_ind).application_set_id,
320: sysdate,
321: p_blocks(l_blk_ind).comment_text,

Line 343: End hxc_timecard_audit;

339:
340: END maintain_latest_details;
341:
342:
343: End hxc_timecard_audit;