DBA Data[Home] [Help]

APPS.HXC_ARRAY_TIME_DEPOSIT dependencies on HXC_BLOCK_TABLE_TYPE

Line 48: (p_blocks in HXC_BLOCK_TABLE_TYPE

44:
45: END debug;
46: */
47: function globalBlockDeposit
48: (p_blocks in HXC_BLOCK_TABLE_TYPE
49: ,p_deleted in BOOLEAN default true) return block_list is
50:
51: l_block_count NUMBER;
52: l_deposit_block BOOLEAN;

Line 495: (p_blocks in HXC_BLOCK_TABLE_TYPE

491:
492: end getValidExplosionBlocks;
493:
494: function get_translation_blocks
495: (p_blocks in HXC_BLOCK_TABLE_TYPE
496: ,p_details_blocks in HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO
497: ) return HXC_BLOCK_TABLE_TYPE IS -- HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO is
498:
499: l_block number;

Line 497: ) return HXC_BLOCK_TABLE_TYPE IS -- HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO is

493:
494: function get_translation_blocks
495: (p_blocks in HXC_BLOCK_TABLE_TYPE
496: ,p_details_blocks in HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO
497: ) return HXC_BLOCK_TABLE_TYPE IS -- HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO is
498:
499: l_block number;
500: l_index number := 0;
501: l_trans_blocks HXC_BLOCK_TABLE_TYPE := HXC_BLOCK_TABLE_TYPE(); --hxc_self_service_time_deposit.timecard_info;

Line 501: l_trans_blocks HXC_BLOCK_TABLE_TYPE := HXC_BLOCK_TABLE_TYPE(); --hxc_self_service_time_deposit.timecard_info;

497: ) return HXC_BLOCK_TABLE_TYPE IS -- HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO is
498:
499: l_block number;
500: l_index number := 0;
501: l_trans_blocks HXC_BLOCK_TABLE_TYPE := HXC_BLOCK_TABLE_TYPE(); --hxc_self_service_time_deposit.timecard_info;
502:
503: begin
504:
505: l_block := p_blocks.first;

Line 590: (p_blocks in out nocopy HXC_BLOCK_TABLE_TYPE

586:
587: End get_translation_blocks;
588:
589: procedure getExplodedHours
590: (p_blocks in out nocopy HXC_BLOCK_TABLE_TYPE
591: ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
592: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
593: ) is
594:

Line 597: l_blocks_for_translation HXC_BLOCK_TABLE_TYPE;

593: ) is
594:
595: l_blocks HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO;
596: l_valid_blocks HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO;
597: l_blocks_for_translation HXC_BLOCK_TABLE_TYPE;
598: l_attributes HXC_SELF_SERVICE_TIME_DEPOSIT.BUILDING_BLOCK_ATTRIBUTE_INFO;
599: l_old_attributes HXC_SELF_SERVICE_TIME_DEPOSIT.BUILDING_BLOCK_ATTRIBUTE_INFO;
600: l_app_attributes HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info;
601: l_deposit_process_id HXC_DEPOSIT_PROCESSES.DEPOSIT_PROCESS_ID%TYPE;

Line 606: l_exploded_details HXC_BLOCK_TABLE_TYPE := HXC_BLOCK_TABLE_TYPE();

602: l_messages HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE;
603: l_messages_table HXC_MESSAGE_TABLE_TYPE;
604: l_att_count NUMBER;
605: l_blocks_deposited block_list;
606: l_exploded_details HXC_BLOCK_TABLE_TYPE := HXC_BLOCK_TABLE_TYPE();
607: l_exploded_attributes HXC_ATTRIBUTE_TABLE_TYPE:= HXC_ATTRIBUTE_TABLE_TYPE();
608:
609: cursor c_dep_prc_id is
610: select deposit_process_id

Line 761: ,p_blocks IN HXC_BLOCK_TABLE_TYPE

757:
758: procedure deposit_blocks
759: (p_timecard_id out nocopy HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
760: ,p_timecard_ovn out nocopy HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
761: ,p_blocks IN HXC_BLOCK_TABLE_TYPE
762: ,p_attributes IN HXC_ATTRIBUTE_TABLE_TYPE
763: ,p_item_type in WF_ITEMS.ITEM_TYPE%TYPE
764: ,p_process_name in WF_ACTIVITIES.NAME%TYPE
765: ,p_mode in varchar2