[Home] [Help]
9: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
10: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
11: p_clear_mapping_cache IN BOOLEAN DEFAULT FALSE,
12: p_app_blocks OUT NOCOPY hxc_block_table_type,
13: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
14: )
15: IS
16: BEGIN
17: hxc_timestore_deposit_util.get_timecard_tables (p_building_block_id,
25: PROCEDURE get_timecard_tables (
26: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
27: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
28: p_clear_mapping_cache IN BOOLEAN DEFAULT FALSE,
29: p_app_blocks OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
30: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
31: )
32: IS
33: BEGIN
26: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
27: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
28: p_clear_mapping_cache IN BOOLEAN DEFAULT FALSE,
29: p_app_blocks OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
30: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
31: )
32: IS
33: BEGIN
34: hxc_timestore_deposit_util.get_timecard_tables (p_building_block_id,
195: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
196: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
197: p_new IN VARCHAR2,
198: p_changed IN VARCHAR2,
199: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info
200: )
201: IS
202: l_proc VARCHAR2 (72);
203: l_blocks hxc_block_table_type;
300: hr_utility.set_location ('Entering:' || l_proc, 10);
301: END IF;
302:
303: -- We are starting with a new timecard so clear the global tables
304: hxc_self_service_time_deposit.initialize_globals;
305: -- Also clear the local PL/SQL table
306: hxc_timestore_deposit_util.clear_building_block_table
307: (p_app_blocks => p_app_blocks);
308: l_count_building_block := p_app_blocks.LAST;
400: -- We cannot use approval_style_name because that is not unique.
401: -- if NULL we will get it of the preferences
402: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
403: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
404: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
405: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
406: )
407: IS
408: l_proc VARCHAR2 (72);
540: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
541: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
542: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
543: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
544: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
545: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
546: )
547: IS
548: l_proc VARCHAR2 (72);
627: l_parent_building_block_index PLS_INTEGER;
628: l_parent_is_new VARCHAR2 (1);
629: -- l_timecard_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;
630: -- l_timecard_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
631: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
632: BEGIN
633: g_debug := hr_utility.debug_enabled;
634:
635: IF g_debug
642: IF (p_app_blocks.COUNT = 0)
643: THEN -- No Timecard is loaded yet, lets load it form the TimeStore
644: -- First clear the global tables so no garbage gets loaded with the
645: -- updated TC
646: hxc_self_service_time_deposit.initialize_globals;
647: -- then get the TC and attributes out of the DB into the PL/SQL Tables
648: hxc_timestore_deposit_util.get_timecard_tables
649: (p_building_block_id => p_parent_building_block_id,
650: p_deposit_process => p_deposit_process,
762: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
763: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
764: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
765: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
766: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
767: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
768: )
769: IS
770: l_proc VARCHAR2 (72);
835: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
836: p_day IN hxc_time_building_blocks.start_time%TYPE,
837: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
838: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
839: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
840: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
841: )
842: IS
843: l_proc VARCHAR2 (72);
968: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
969: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
970: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
971: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
972: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
973: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
974: )
975: IS
976: l_proc VARCHAR2 (72);
991: IF (p_app_blocks.COUNT = 0)
992: THEN -- No Timecard is loaded yet, lets load it form the TimeStore
993: -- First clear the global tables so no garbage gets loaded with the
994: -- updated TC
995: hxc_self_service_time_deposit.initialize_globals;
996: -- then get the TC and attributes out of the DB into the PL/SQL Tables
997: hxc_timestore_deposit_util.get_timecard_tables
998: (p_building_block_id => p_parent_building_block_id,
999: p_deposit_process => p_deposit_process,
1122: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1123: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
1124: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1125: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1126: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1127: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1128: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1129: )
1130: IS
1123: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
1124: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1125: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1126: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1127: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1128: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1129: )
1130: IS
1131: l_proc VARCHAR2 (72);
1212: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1213: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1214: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1215: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1216: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1217: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1218: )
1219: IS
1220: l_proc VARCHAR2 (72);
1304: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1305: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1306: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1307: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1308: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1309: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1310: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1311: )
1312: IS
1305: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1306: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1307: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1308: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1309: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1310: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1311: )
1312: IS
1313: l_proc VARCHAR2 (72);
1385: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1386: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1387: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1388: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1389: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1390: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1391: )
1392: IS
1393: l_proc VARCHAR2 (72);
1477: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1478: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1479: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1480: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1481: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1482: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1483: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1484: )
1485: IS
1478: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1479: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1480: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1481: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1482: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1483: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1484: )
1485: IS
1486: l_proc VARCHAR2 (72);
1559: p_attribute_value IN hxc_time_attributes.attribute1%TYPE,
1560: -- p_category IN hxc_bld_blk_info_type_usages.building_block_category%TYPE,
1561: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1562: p_attribute_id IN hxc_time_attributes.time_attribute_id%TYPE,
1563: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1564: )
1565: IS
1566: l_proc VARCHAR2 (72);
1567: l_attribute_count PLS_INTEGER;
1690: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1691: -- p_time_recipient_id IN NUMBER,
1692: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1693: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1694: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1695: )
1696: IS
1697: l_proc VARCHAR2 (72);
1698: l_building_block_index PLS_INTEGER;
1734: IF l_load_new_timecard
1735: THEN
1736: -- First clear the global tables so no garbage gets loaded with the
1737: -- updated TC
1738: hxc_self_service_time_deposit.initialize_globals;
1739: -- then get the TC and attributes out of the DB into the PL/SQL Tables
1740: hxc_timestore_deposit_util.get_timecard_tables
1741: (p_building_block_id => p_building_block_id,
1742: -- p_time_recipient_id=> p_time_recipient_id,
1840: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1841: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1842: -- p_time_recipient_id IN NUMBER,
1843: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1844: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1845: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1846: )
1847: IS
1848: l_proc VARCHAR2 (72);
1841: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1842: -- p_time_recipient_id IN NUMBER,
1843: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1844: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1845: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1846: )
1847: IS
1848: l_proc VARCHAR2 (72);
1849: l_blocks hxc_block_table_type;
1907: -- p_time_recipient_id IN NUMBER,
1908: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1909: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE,
1910: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1911: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1912: )
1913: IS
1914: l_proc VARCHAR2 (72);
1915: l_building_block_index PLS_INTEGER;
1922: hr_utility.set_location ('Entering:' || l_proc, 10);
1923: END IF;
1924:
1925: -- First clear the global tables so no garbage gets loaded with the updated TC
1926: hxc_self_service_time_deposit.initialize_globals;
1927: -- then get the TC and attributes out of the DB into the PL/SQL Tables
1928: hxc_timestore_deposit_util.get_timecard_tables
1929: (p_building_block_id => p_building_block_id,
1930: -- p_time_recipient_id=> p_time_recipient_id,
1975: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1976: -- p_time_recipient_id IN NUMBER,
1977: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1978: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE,
1979: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1980: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1981: )
1982: IS
1983: l_proc VARCHAR2 (72);
1976: -- p_time_recipient_id IN NUMBER,
1977: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1978: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE,
1979: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1980: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1981: )
1982: IS
1983: l_proc VARCHAR2 (72);
1984: l_blocks hxc_block_table_type;
2010: END IF;
2011: END delete_detail_bb;
2012:
2013: -- Use to delete a complete timecard, TBB id passed in has to be a TIMECARD TBB
2014: -- This is just a wrapper for HXC_SELF_SERVICE_TIME_DEPOSIT.delete_timecard
2015: -----------------------------------------------------------------------------
2016: -- Type: Procedure
2017: -- Scope: Public
2018: -- Name: delete_timecard
2029: -- Description: This procedure will allow you to delete a complete timecard.
2030: -- The delete is a soft delete, so the TC is not actually purged
2031: -- from the database, it is just end dated. That is why you
2032: -- have to perform a deposit to get the delete through (this is
2033: -- done automatically by hxc_self_service_time_deposit.delete_timecard
2034: -- in this case).
2035: --
2036: -----------------------------------------------------------------------------
2037: PROCEDURE delete_timecard (
2067: p_timecard_id => p_building_block_id,
2068: p_timecard_ok => l_dummy
2069: );
2070: -- Clear the PL/SQL tables as to similate a delete of the timecard.
2071: hxc_self_service_time_deposit.initialize_globals;
2072: END IF;
2073:
2074: IF g_debug
2075: THEN
2104: -- p_category IN hxc_bld_blk_info_type_usages.building_block_category%TYPE,
2105: -- p_time_recipient_id IN NUMBER,
2106: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
2107: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
2108: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
2109: )
2110: IS
2111: l_proc VARCHAR2 (72);
2112: l_attribute_index PLS_INTEGER;
2109: )
2110: IS
2111: l_proc VARCHAR2 (72);
2112: l_attribute_index PLS_INTEGER;
2113: -- l_app_blocks hxc_self_service_time_deposit.timecard_info;
2114: l_load_new_timecard BOOLEAN;
2115:
2116: CURSOR csr_tbb_id (
2117: v_time_attribute_id hxc_time_attributes.time_attribute_id%TYPE
2160:
2161: IF l_load_new_timecard
2162: THEN
2163: -- First clear the global tables so no garbage gets loaded with the updated TC
2164: hxc_self_service_time_deposit.initialize_globals;
2165:
2166: -- Find the TBB to which this attribute belongs
2167: OPEN csr_tbb_id (p_time_attribute_id);
2168:
2272: p_attribute_value IN hxc_time_attributes.attribute1%TYPE,
2273: -- p_category IN hxc_bld_blk_info_type_usages.building_block_category%TYPE,
2274: -- p_time_recipient_id IN NUMBER,
2275: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
2276: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
2277: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
2278: )
2279: IS
2280: l_proc VARCHAR2 (72);
2273: -- p_category IN hxc_bld_blk_info_type_usages.building_block_category%TYPE,
2274: -- p_time_recipient_id IN NUMBER,
2275: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
2276: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
2277: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
2278: )
2279: IS
2280: l_proc VARCHAR2 (72);
2281: l_blocks hxc_block_table_type;
2334: p_mode IN VARCHAR2,
2335: p_deposit_process IN VARCHAR2,
2336: p_retrieval_process IN VARCHAR2,
2337: -- p_add_security IN BOOLEAN DEFAULT TRUE,
2338: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
2339: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
2340: -- hxc_self_service_time_deposit.timecard_info,
2341: p_messages OUT NOCOPY hxc_message_table_type,
2342: -- hxc_self_service_time_deposit.message_table,
2336: p_retrieval_process IN VARCHAR2,
2337: -- p_add_security IN BOOLEAN DEFAULT TRUE,
2338: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
2339: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
2340: -- hxc_self_service_time_deposit.timecard_info,
2341: p_messages OUT NOCOPY hxc_message_table_type,
2342: -- hxc_self_service_time_deposit.message_table,
2343: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2344: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
2338: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
2339: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
2340: -- hxc_self_service_time_deposit.timecard_info,
2341: p_messages OUT NOCOPY hxc_message_table_type,
2342: -- hxc_self_service_time_deposit.message_table,
2343: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2344: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
2345: p_template IN VARCHAR2,
2346: p_item_type IN wf_items.item_type%TYPE,
2627: p_mode IN VARCHAR2,
2628: p_deposit_process IN VARCHAR2,
2629: p_retrieval_process IN VARCHAR2,
2630: -- p_add_security IN BOOLEAN DEFAULT TRUE,
2631: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
2632: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
2633: p_messages OUT NOCOPY hxc_self_service_time_deposit.message_table,
2634: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2635: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
2628: p_deposit_process IN VARCHAR2,
2629: p_retrieval_process IN VARCHAR2,
2630: -- p_add_security IN BOOLEAN DEFAULT TRUE,
2631: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
2632: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
2633: p_messages OUT NOCOPY hxc_self_service_time_deposit.message_table,
2634: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2635: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
2636: p_template IN VARCHAR2,
2629: p_retrieval_process IN VARCHAR2,
2630: -- p_add_security IN BOOLEAN DEFAULT TRUE,
2631: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
2632: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
2633: p_messages OUT NOCOPY hxc_self_service_time_deposit.message_table,
2634: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2635: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
2636: p_template IN VARCHAR2,
2637: p_item_type IN wf_items.item_type%TYPE,
2692: hxc_timestore_deposit_util.clear_building_block_table (p_app_blocks);
2693: END clear_building_block_table;
2694:
2695: PROCEDURE clear_attribute_table (
2696: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
2697: )
2698: IS
2699: BEGIN
2700: hxc_timestore_deposit_util.clear_attribute_table (p_app_attributes);
2709: END clear_message_table;
2710:
2711: PROCEDURE log_timecard (
2712: p_app_blocks IN hxc_block_table_type,
2713: p_app_attributes IN hxc_self_service_time_deposit.app_attributes_info
2714: )
2715: IS
2716: BEGIN
2717: hxc_timestore_deposit_util.log_timecard (p_app_blocks,
2718: p_app_attributes);
2719: END log_timecard;
2720:
2721: PROCEDURE log_timecard (
2722: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
2723: p_app_attributes IN hxc_self_service_time_deposit.app_attributes_info
2724: )
2725: IS
2726: BEGIN
2719: END log_timecard;
2720:
2721: PROCEDURE log_timecard (
2722: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
2723: p_app_attributes IN hxc_self_service_time_deposit.app_attributes_info
2724: )
2725: IS
2726: BEGIN
2727: hxc_timestore_deposit_util.log_timecard (p_app_blocks,
2734: hxc_timestore_deposit_util.log_messages (p_messages);
2735: END log_messages;
2736:
2737: PROCEDURE log_messages (
2738: p_messages IN hxc_self_service_time_deposit.message_table
2739: )
2740: IS
2741: BEGIN
2742: hxc_timestore_deposit_util.log_messages (p_messages);