DBA Data[Home] [Help]

APPS.HXC_TIMESTORE_DEPOSIT dependencies on HXC_BLOCK_TABLE_TYPE

Line 12: p_app_blocks OUT NOCOPY hxc_block_table_type,

8: PROCEDURE get_timecard_tables (
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

Line 113: p_app_blocks IN OUT NOCOPY hxc_block_table_type

109: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
110: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
111: p_new IN VARCHAR2,
112: p_changed IN VARCHAR2,
113: p_app_blocks IN OUT NOCOPY hxc_block_table_type
114: )
115: IS
116: l_proc VARCHAR2 (72);
117: l_count_building_block PLS_INTEGER;

Line 203: l_blocks hxc_block_table_type;

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;
204: BEGIN
205: g_debug := hr_utility.debug_enabled;
206:
207: IF g_debug

Line 285: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

281: -- We cannot use approval_style_name because that is not unique.
282: -- if NULL we will get it of the preferences
283: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
284: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
285: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
286: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
287: )
288: IS
289: l_proc VARCHAR2 (72);

Line 409: l_blocks hxc_block_table_type;

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);
409: l_blocks hxc_block_table_type;
410: BEGIN
411: g_debug := hr_utility.debug_enabled;
412:
413: IF g_debug

Line 475: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

471: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
472: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
473: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
474: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
475: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
476: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
477: )
478: IS
479: l_proc VARCHAR2 (72);

Line 549: l_blocks hxc_block_table_type;

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);
549: l_blocks hxc_block_table_type;
550: BEGIN
551: g_debug := hr_utility.debug_enabled;
552:
553: IF g_debug

Line 620: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

616: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
617: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
618: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
619: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
620: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
621: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
622: )
623: IS
624: l_proc VARCHAR2 (72);

Line 771: l_blocks hxc_block_table_type;

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);
771: l_blocks hxc_block_table_type;
772: BEGIN
773: g_debug := hr_utility.debug_enabled;
774:
775: IF g_debug

Line 838: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

834: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
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

Line 971: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

967: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
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

Line 1132: l_blocks hxc_block_table_type;

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);
1132: l_blocks hxc_block_table_type;
1133: BEGIN
1134: g_debug := hr_utility.debug_enabled;
1135:
1136: IF g_debug

Line 1215: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

1211: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
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

Line 1314: l_blocks hxc_block_table_type;

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);
1314: l_blocks hxc_block_table_type;
1315: BEGIN
1316: g_debug := hr_utility.debug_enabled;
1317:
1318: IF g_debug

Line 1388: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

1384: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
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

Line 1487: l_blocks hxc_block_table_type;

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);
1487: l_blocks hxc_block_table_type;
1488: BEGIN
1489: g_debug := hr_utility.debug_enabled;
1490:
1491: IF g_debug

Line 1693: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

1689: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
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);

Line 1849: l_blocks hxc_block_table_type;

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;
1850: BEGIN
1851: g_debug := hr_utility.debug_enabled;
1852:
1853: IF g_debug

Line 1910: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

1906: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%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);

Line 1984: l_blocks hxc_block_table_type;

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;
1985: BEGIN
1986: g_debug := hr_utility.debug_enabled;
1987:
1988: IF g_debug

Line 2107: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

2103: p_attribute_value IN hxc_time_attributes.attribute1%TYPE,
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);

Line 2281: l_blocks hxc_block_table_type;

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;
2282: BEGIN
2283: g_debug := hr_utility.debug_enabled;
2284:
2285: IF g_debug

Line 2339: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

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,
2343: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

Line 2643: l_blocks hxc_block_table_type;

2639: p_process_terminated_employees IN BOOLEAN,
2640: p_approve_term_emps_on_submit IN BOOLEAN
2641: )
2642: IS
2643: l_blocks hxc_block_table_type;
2644: l_messages hxc_message_table_type;
2645: l_proc VARCHAR2 (72);
2646: BEGIN
2647: g_debug := hr_utility.debug_enabled;

Line 2688: p_app_blocks IN OUT NOCOPY hxc_block_table_type

2684: END IF;
2685: END execute_deposit_process;
2686:
2687: PROCEDURE clear_building_block_table (
2688: p_app_blocks IN OUT NOCOPY hxc_block_table_type
2689: )
2690: IS
2691: BEGIN
2692: hxc_timestore_deposit_util.clear_building_block_table (p_app_blocks);

Line 2712: p_app_blocks IN hxc_block_table_type,

2708: hxc_timestore_deposit_util.clear_message_table (p_messages);
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