DBA Data[Home] [Help]

APPS.HXC_TIMECARD dependencies on HXC_BLOCK_TABLE_TYPE

Line 10: g_deposit_blocks hxc_block_table_type;

6: attribute_id_list attribute_list;
7:
8: g_package varchar2(12) := 'HXC_TIMECARD';
9: g_debug boolean := hr_utility.debug_enabled;
10: g_deposit_blocks hxc_block_table_type;
11: g_deposit_attributes hxc_attribute_table_type;
12: g_audit_messages hxc_message_table_type;
13:
14: Procedure alias_translation

Line 15: (p_blocks in HXC_BLOCK_TABLE_TYPE

11: g_deposit_attributes hxc_attribute_table_type;
12: g_audit_messages hxc_message_table_type;
13:
14: Procedure alias_translation
15: (p_blocks in HXC_BLOCK_TABLE_TYPE
16: ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
17: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
18: ) is
19:

Line 136: (p_blocks in out nocopy HXC_BLOCK_TABLE_TYPE

132:
133: END remove_null_attribute_category;
134:
135: Procedure save_timecard
136: (p_blocks in out nocopy HXC_BLOCK_TABLE_TYPE
137: ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
138: ,p_timecard_props in HXC_TIMECARD_PROP_TABLE_TYPE
139: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
140: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type

Line 450: ,p_blocks in HXC_BLOCK_TABLE_TYPE

446: End save_timecard;
447:
448: Procedure deposit_controller
449: (p_validate in varchar2
450: ,p_blocks in HXC_BLOCK_TABLE_TYPE
451: ,p_attributes in HXC_ATTRIBUTE_TABLE_TYPE
452: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
453: ,p_deposit_mode in VARCHAR2
454: ,p_template in VARCHAR2

Line 466: l_blocks hxc_block_table_type;

462: l_timecard_blocks hxc_timecard.block_list;
463: l_day_blocks hxc_timecard.block_list;
464: l_detail_blocks hxc_timecard.block_list;
465: l_attributes hxc_attribute_table_type;
466: l_blocks hxc_block_table_type;
467: l_transaction_info hxc_timecard.transaction_info;
468: l_timecard_props hxc_timecard_prop_table_type;
469: l_proc varchar2(33) := g_package||'.DEPOSIT_CONTROLLER';
470: l_can_deposit boolean := true;

Line 1337: ,p_blocks in hxc_block_table_type

1333: END deposit_controller;
1334:
1335: Procedure create_timecard
1336: (p_validate in varchar2
1337: ,p_blocks in hxc_block_table_type
1338: ,p_attributes in hxc_attribute_table_type
1339: ,p_deposit_mode in varchar2
1340: ,p_template in varchar2
1341: ,p_item_type in wf_items.item_type%type

Line 1672: ) return hxc_block_table_type is

1668: Function load_blocks
1669: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
1670: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
1671: ,p_load_mode in varchar2 default c_nondelete
1672: ) return hxc_block_table_type is
1673:
1674: cursor c_blocks
1675: (p_tc_id in hxc_time_building_blocks.time_building_block_id%type
1676: ) is

Line 1685: l_blocks hxc_block_table_type := hxc_block_table_type();

1681: start with (tbb.time_building_block_id = p_tc_id)
1682: connect by prior tbb.time_building_block_id = tbb.parent_building_block_id
1683: and prior tbb.object_version_number = tbb.parent_building_block_ovn;
1684:
1685: l_blocks hxc_block_table_type := hxc_block_table_type();
1686: l_block_count number := 1;
1687:
1688:
1689: Begin

Line 1712: (p_blocks in hxc_block_table_type)

1708:
1709: End load_blocks;
1710:
1711: Function load_attributes
1712: (p_blocks in hxc_block_table_type)
1713: return hxc_attribute_table_type is
1714:
1715: cursor c_attributes
1716: (p_building_block_id in hxc_time_building_blocks.time_building_block_id%type

Line 1863: l_blocks hxc_block_table_type := hxc_block_table_type();

1859: l_pk1_value fnd_attached_documents.pk1_value%type;
1860: l_pk2_value fnd_attached_documents.pk2_value%type;
1861: l_pk3_value fnd_attached_documents.pk3_value%type;
1862:
1863: l_blocks hxc_block_table_type := hxc_block_table_type();
1864: l_attributes hxc_attribute_table_type := hxc_attribute_table_type();
1865: l_messages hxc_message_table_type := hxc_message_table_type();
1866:
1867: l_timecard_blocks hxc_timecard.block_list;