[Home] [Help]
151: ----------------------------------------------------------------------------
152: Procedure save_timecard
153: (p_blocks in out nocopy HXC_BLOCK_TABLE_TYPE
154: ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
155: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
156: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type
157: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type
158: ,p_timekeeper_id in hxc_time_building_blocks.resource_id%type DEFAULT NULL
159: ,p_tk_audit_enabled in VARCHAR2 DEFAULT NULL
202: l_tc_start DATE;
203: l_tc_stop DATE;
204: l_approval_status VARCHAR2(20);
205:
206: l_abs_ret_messages HXC_MESSAGE_TABLE_TYPE;
207:
208: Begin
209:
210: --
222: -- Timecard Preparation
223: ----------------------------------------------------------------------------
224: hxc_timecard_message_helper.initializeerrors;
225:
226: p_messages := hxc_message_table_type ();
227:
228: -- create savepoint
229: savepoint TK_SAVE_SAVEPOINT;
230:
1254: IF g_debug THEN
1255: hr_utility.trace('ABS:Initiated Online Retrieval from HXC_TIMEKEEPER.SAVE_TIMECARD');
1256: END IF;
1257:
1258: l_abs_ret_messages:= HXC_MESSAGE_TABLE_TYPE();
1259:
1260: l_resource_id := p_blocks(l_timecard_index).resource_id;
1261: l_tc_start := fnd_date.canonical_to_date(p_blocks(l_timecard_index).start_time);
1262: l_tc_stop := fnd_date.canonical_to_date(p_blocks(l_timecard_index).stop_time);
1311:
1312: Procedure submit_timecard
1313: (p_blocks in out nocopy HXC_BLOCK_TABLE_TYPE
1314: ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
1315: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
1316: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type
1317: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type
1318: ,p_timekeeper_id in hxc_time_building_blocks.resource_id%type DEFAULT NULL
1319: ,p_tk_audit_enabled in VARCHAR2 DEFAULT NULL
1357: l_tc_start DATE;
1358: l_tc_stop DATE;
1359: l_approval_status VARCHAR2(20);
1360:
1361: l_abs_ret_messages HXC_MESSAGE_TABLE_TYPE;
1362:
1363: BEGIN
1364:
1365: --
1376: hxc_timecard_block_utils.initialize_timecard_index;
1377:
1378: hxc_timecard_message_helper.initializeerrors;
1379:
1380: p_messages := hxc_message_table_type ();
1381:
1382: -- set savepoint
1383: savepoint TK_SUB_SAVEPOINT;
1384: --
2442: -- Modified code to rollback in case on online retrieval errors (Bug 8888138)
2443: IF (nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y') THEN
2444: IF (p_timecard_id > 0 and hxc_timecard_message_helper.noerrors ) THEN
2445:
2446: l_abs_ret_messages:= HXC_MESSAGE_TABLE_TYPE();
2447:
2448: IF g_debug THEN
2449: hr_utility.trace('ABS:Initiated Online Retrieval from HXC_TIMEKEEPER.SUBMIT_TIMECARD');
2450: END IF;
2492: -- This procedure....
2493: ----------------------------------------------------------------------------
2494: Procedure delete_timecard
2495: (p_timecard_id in out nocopy hxc_time_building_blocks.time_building_block_id%type
2496: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
2497: ) is
2498:
2499: /*
2500: hxc_timecard_deposit_common.delete_timecard
2532: AND t.status = 'SUCCESS' );
2533:
2534: l_blocks hxc_block_table_type := hxc_block_table_type();
2535: l_attributes hxc_attribute_table_type := hxc_attribute_table_type();
2536: l_messages hxc_message_table_type := hxc_message_table_type();
2537:
2538: l_timecard_blocks hxc_timecard.block_list;
2539: l_day_blocks hxc_timecard.block_list;
2540: l_detail_blocks hxc_timecard.block_list;
2561: l_tc_start DATE;
2562: l_tc_stop DATE;
2563: l_approval_status VARCHAR2(20);
2564:
2565: l_abs_ret_messages HXC_MESSAGE_TABLE_TYPE;
2566:
2567: Begin
2568:
2569: g_debug:= hr_utility.debug_enabled;
2788: IF g_debug THEN
2789: hr_utility.trace('ABS:Initiated Online Retrieval from HXC_TIMEKEEPER.DELETE_TIMECARD');
2790: END IF;
2791:
2792: l_abs_ret_messages:= HXC_MESSAGE_TABLE_TYPE();
2793:
2794: l_resource_id := l_blocks(l_timecard_index).resource_id;
2795: l_tc_start := fnd_date.canonical_to_date(l_blocks(l_timecard_index).start_time);
2796: l_tc_stop := fnd_date.canonical_to_date(l_blocks(l_timecard_index).stop_time);