DBA Data[Home] [Help]

APPS.HXC_ARRAY_TIME_DEPOSIT dependencies on HXC_SELF_SERVICE_TIME_DEPOSIT

Line 20: l_loc VARCHAR2(70) := 'HXC_SELF_SERVICE_TIME_DEPOSIT.'|| p_procedure;

16: ,p_reference IN NUMBER
17: ,p_text IN VARCHAR2
18: ) IS
19:
20: l_loc VARCHAR2(70) := 'HXC_SELF_SERVICE_TIME_DEPOSIT.'|| p_procedure;
21:
22: BEGIN
23:
24: g_debug_count := g_debug_count + 1;

Line 121: HXC_SELF_SERVICE_TIME_DEPOSIT.CALL_BLOCK_DEPOSIT

117: end if;
118:
119: l_blocks_deposited(p_blocks(l_block_count).time_building_block_id) := p_blocks(l_block_count).date_to;
120:
121: HXC_SELF_SERVICE_TIME_DEPOSIT.CALL_BLOCK_DEPOSIT
122: (P_TIME_BUILDING_BLOCK_ID =>p_blocks(l_block_count).TIME_BUILDING_BLOCK_ID
123: ,P_TYPE =>p_blocks(l_block_count).TYPE
124: ,P_MEASURE =>p_blocks(l_block_count).MEASURE
125: ,P_UNIT_OF_MEASURE =>p_blocks(l_block_count).UNIT_OF_MEASURE

Line 200: l_blocks HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO;

196: function checkBlockDeposited
197: (p_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE)
198: return boolean is
199:
200: l_blocks HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO;
201: i number;
202: l_deposited BOOLEAN := false;
203: l_found_block BOOLEAN := false;
204:

Line 207: l_blocks := hxc_self_service_time_deposit.get_building_blocks;

203: l_found_block BOOLEAN := false;
204:
205: begin
206:
207: l_blocks := hxc_self_service_time_deposit.get_building_blocks;
208:
209: i := l_blocks.first;
210:
211: LOOP

Line 317: HXC_SELF_SERVICE_TIME_DEPOSIT.CALL_ATTRIBUTE_DEPOSIT

313: end if;
314:
315: if((l_deposit_attribute) AND (l_deposit_alias_attribute))then
316:
317: HXC_SELF_SERVICE_TIME_DEPOSIT.CALL_ATTRIBUTE_DEPOSIT
318: (P_TIME_ATTRIBUTE_ID => p_attributes(l_attribute_count).TIME_ATTRIBUTE_ID
319: ,P_BUILDING_BLOCK_ID => p_attributes(l_attribute_count).BUILDING_BLOCK_ID
320: ,P_ATTRIBUTE_CATEGORY=> p_attributes(l_attribute_count).ATTRIBUTE_CATEGORY
321: ,P_ATTRIBUTE1 => p_attributes(l_attribute_count).ATTRIBUTE1

Line 373: (p_old_attributes in HXC_SELF_SERVICE_TIME_DEPOSIT.BUILDING_BLOCK_ATTRIBUTE_INFO

369: */
370: end globalAttributeDeposit;
371:
372: procedure add_layout_attribute
373: (p_old_attributes in HXC_SELF_SERVICE_TIME_DEPOSIT.BUILDING_BLOCK_ATTRIBUTE_INFO
374: ,p_exploded_attributes in out nocopy HXC_SELF_SERVICE_TIME_DEPOSIT.BUILDING_BLOCK_ATTRIBUTE_INFO
375: ) is
376:
377: l_found_attribute boolean := false;

Line 374: ,p_exploded_attributes in out nocopy HXC_SELF_SERVICE_TIME_DEPOSIT.BUILDING_BLOCK_ATTRIBUTE_INFO

370: end globalAttributeDeposit;
371:
372: procedure add_layout_attribute
373: (p_old_attributes in HXC_SELF_SERVICE_TIME_DEPOSIT.BUILDING_BLOCK_ATTRIBUTE_INFO
374: ,p_exploded_attributes in out nocopy HXC_SELF_SERVICE_TIME_DEPOSIT.BUILDING_BLOCK_ATTRIBUTE_INFO
375: ) is
376:
377: l_found_attribute boolean := false;
378: l_next_attribute_index NUMBER;

Line 444: (p_explosion_blocks in HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO

440:
441: end add_layout_attribute;
442:
443: function getValidExplosionBlocks
444: (p_explosion_blocks in HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO
445: ) return HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO is
446:
447: l_valid_blocks HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO;
448: l_block_counter binary_integer;

Line 445: ) return HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO is

441: end add_layout_attribute;
442:
443: function getValidExplosionBlocks
444: (p_explosion_blocks in HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO
445: ) return HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO is
446:
447: l_valid_blocks HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO;
448: l_block_counter binary_integer;
449: l_block_index binary_integer;

Line 447: l_valid_blocks HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO;

443: function getValidExplosionBlocks
444: (p_explosion_blocks in HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO
445: ) return HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO is
446:
447: l_valid_blocks HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO;
448: l_block_counter binary_integer;
449: l_block_index binary_integer;
450:
451: begin

Line 496: ,p_details_blocks in HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO

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;
500: l_index number := 0;

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 595: l_blocks HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO;

591: ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
592: ,p_messages in out nocopy HXC_MESSAGE_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;

Line 596: l_valid_blocks HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO;

592: ,p_messages in out nocopy HXC_MESSAGE_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;

Line 598: l_attributes HXC_SELF_SERVICE_TIME_DEPOSIT.BUILDING_BLOCK_ATTRIBUTE_INFO;

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;
602: l_messages HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE;

Line 599: l_old_attributes HXC_SELF_SERVICE_TIME_DEPOSIT.BUILDING_BLOCK_ATTRIBUTE_INFO;

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;
602: l_messages HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE;
603: l_messages_table HXC_MESSAGE_TABLE_TYPE;

Line 600: l_app_attributes HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_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;
602: l_messages HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE;
603: l_messages_table HXC_MESSAGE_TABLE_TYPE;
604: l_att_count NUMBER;

Line 602: l_messages HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE;

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;
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();

Line 627: hxc_self_service_time_deposit.initialize_globals;

623: --
624: -- Call to initialize the global variables!
625: --
626: p_messages := hxc_message_table_type();
627: hxc_self_service_time_deposit.initialize_globals;
628:
629: -- set up the blocks and attributes
630: -- we don't just pass these because the hours explosion api
631: -- picks up the global variables!

Line 650: l_old_attributes := HXC_SELF_SERVICE_TIME_DEPOSIT.get_block_attributes;

646: globalAttributeDeposit(p_attributes, true, l_blocks_deposited);
647:
648: --Bug 2770487 Sonarasi Over
649:
650: l_old_attributes := HXC_SELF_SERVICE_TIME_DEPOSIT.get_block_attributes;
651:
652: --
653: -- Obtain the application attributes expected by
654: -- the hours explosion API

Line 676: (p_time_building_blocks => hxc_self_service_time_deposit.get_building_blocks

672: -- Call the hours explosion API
673: --
674:
675: hxt_hxc_retrieval_process.otlr_review_details
676: (p_time_building_blocks => hxc_self_service_time_deposit.get_building_blocks
677: ,p_time_attributes => l_app_attributes
678: ,p_messages => l_messages
679: ,p_detail_build_blocks => l_blocks
680: ,p_detail_attributes => l_attributes

Line 773: l_blocks HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO;

769: ,p_validate_session in boolean default TRUE
770: ,p_add_security in boolean default TRUE
771: ) is
772:
773: l_blocks HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO;
774: l_attributes HXC_SELF_SERVICE_TIME_DEPOSIT.BUILDING_BLOCK_ATTRIBUTE_INFO;
775:
776: l_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE;
777: l_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE;

Line 774: l_attributes HXC_SELF_SERVICE_TIME_DEPOSIT.BUILDING_BLOCK_ATTRIBUTE_INFO;

770: ,p_add_security in boolean default TRUE
771: ) is
772:
773: l_blocks HXC_SELF_SERVICE_TIME_DEPOSIT.TIMECARD_INFO;
774: l_attributes HXC_SELF_SERVICE_TIME_DEPOSIT.BUILDING_BLOCK_ATTRIBUTE_INFO;
775:
776: l_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE;
777: l_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE;
778:

Line 790: hxc_self_Service_time_deposit.initialize_globals;

786: --
787: -- Initialize the global variables
788: --
789:
790: hxc_self_Service_time_deposit.initialize_globals;
791:
792:
793: --
794: -- Initialize the workflow globals

Line 797: hxc_self_service_time_deposit.set_workflow_info

793: --
794: -- Initialize the workflow globals
795: --
796:
797: hxc_self_service_time_deposit.set_workflow_info
798: (p_item_type => p_item_type
799: ,p_process_name => p_process_name
800: );
801:

Line 818: hxc_self_service_time_deposit.deposit_blocks

814: -- deposit the timecard information now that the globals
815: -- have been initialized
816: --
817:
818: hxc_self_service_time_deposit.deposit_blocks
819: (p_timecard_id => l_timecard_id
820: ,p_timecard_ovn => l_timecard_ovn
821: ,p_mode => p_mode
822: ,p_deposit_process => p_deposit_process