eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_INTEGRATION_LAYER_V1_GRP dependencies on HXC_USER_TYPE_DEFINITION_GRP

Line 14: ,p_building_blocks_int IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.timecard_info)

10: -- |-------------------------< int_to_otl_timecard_info>----------------------|
11: -- ----------------------------------------------------------------------------
12: PROCEDURE int_to_otl_timecard_info(
13: p_building_blocks_otl IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
14: ,p_building_blocks_int IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.timecard_info)
15: IS
16:
17: l_index NUMBER;
18:

Line 84: ,p_building_blocks_int IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.timecard_info)

80: -- |-------------------------< otl_to_int_timecard_info>----------------------|
81: -- ----------------------------------------------------------------------------
82: PROCEDURE otl_to_int_timecard_info(
83: p_building_blocks_otl IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
84: ,p_building_blocks_int IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.timecard_info)
85: IS
86: l_index NUMBER;
87:
88: BEGIN

Line 155: ,p_app_attributes_int IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info)

151: -- |--------------------< int_to_otl_app_attributes_info>----------------------|
152: -- ----------------------------------------------------------------------------
153: PROCEDURE int_to_otl_app_attributes_info(
154: p_app_attributes_otl IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
155: ,p_app_attributes_int IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info)
156: IS
157:
158: l_index NUMBER;
159:

Line 203: ,p_app_attributes_int IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info)

199: -- |-------------------< otl_to_int_app_attributes_info>----------------------|
200: -- ----------------------------------------------------------------------------
201: PROCEDURE otl_to_int_app_attributes_info(
202: p_app_attributes_otl IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
203: ,p_app_attributes_int IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info)
204: IS
205:
206: l_index NUMBER;
207:

Line 255: ,p_messages_int IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)

251: -- |-------------------------< int_to_otl_message_table>----------------------|
252: -- ----------------------------------------------------------------------------
253: PROCEDURE int_to_otl_message_table(
254: p_messages_otl IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.message_table
255: ,p_messages_int IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)
256: IS
257:
258: l_index NUMBER;
259:

Line 304: ,p_messages_int IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)

300: -- |-------------------------< otl_to_int_message_table>----------------------|
301: -- ----------------------------------------------------------------------------
302: PROCEDURE otl_to_int_message_table(
303: p_messages_otl IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.message_table
304: ,p_messages_int IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)
305: IS
306:
307: l_index NUMBER;
308:

Line 355: p_building_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.timecard_info

351: -- ----------------------------------------------------------------------------
352: -- |---------------------------< get_app_hook_params >----------------------|
353: -- ----------------------------------------------------------------------------
354: procedure get_app_hook_params(
355: p_building_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.timecard_info
356: ,p_app_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info
357: ,p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)
358: IS
359:

Line 356: ,p_app_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info

352: -- |---------------------------< get_app_hook_params >----------------------|
353: -- ----------------------------------------------------------------------------
354: procedure get_app_hook_params(
355: p_building_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.timecard_info
356: ,p_app_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info
357: ,p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)
358: IS
359:
360: l_building_blocks_otl HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info;

Line 357: ,p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)

353: -- ----------------------------------------------------------------------------
354: procedure get_app_hook_params(
355: p_building_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.timecard_info
356: ,p_app_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info
357: ,p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)
358: IS
359:
360: l_building_blocks_otl HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info;
361: l_app_attributes_otl HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info;

Line 398: p_building_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.timecard_info

394: -- ----------------------------------------------------------------------------
395: -- |---------------------------< set_app_hook_params >----------------------|
396: -- ----------------------------------------------------------------------------
397: procedure set_app_hook_params(
398: p_building_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.timecard_info
399: ,p_app_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info
400: ,p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)
401: IS
402:

Line 399: ,p_app_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info

395: -- |---------------------------< set_app_hook_params >----------------------|
396: -- ----------------------------------------------------------------------------
397: procedure set_app_hook_params(
398: p_building_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.timecard_info
399: ,p_app_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info
400: ,p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)
401: IS
402:
403:

Line 400: ,p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)

396: -- ----------------------------------------------------------------------------
397: procedure set_app_hook_params(
398: p_building_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.timecard_info
399: ,p_app_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info
400: ,p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)
401: IS
402:
403:
404: l_building_blocks_otl HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info;

Line 466: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status.delete;

462:
463: BEGIN
464:
465: -- delete the integration global pl/sql first
466: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status.delete;
467:
468: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_status.first;
469:
470: LOOP

Line 473: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_index) :=

469:
470: LOOP
471: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_status.exists(l_index));
472:
473: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_index) :=
474: HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_status(l_index);
475:
476:
477: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_status.next(l_index);

Line 492: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception.delete;

488:
489: BEGIN
490:
491: -- delete the integration global pl/sql first
492: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception.delete;
493:
494: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_exception.first;
495:
496: LOOP

Line 499: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_index) :=

495:
496: LOOP
497: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_exception.exists(l_index));
498:
499: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_index) :=
500: HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_exception(l_index);
501:
502:
503: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_exception.next(l_index);

Line 519: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.delete;

515:
516: BEGIN
517:
518: -- delete the integration global pl/sql first
519: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.delete;
520:
521: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks.first;
522:
523: LOOP

Line 526: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).bb_id :=

522:
523: LOOP
524: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks.exists(l_index));
525:
526: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).bb_id :=
527: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).bb_id;
528: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).type :=
529: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).type;
530: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).measure :=

Line 528: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).type :=

524: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks.exists(l_index));
525:
526: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).bb_id :=
527: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).bb_id;
528: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).type :=
529: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).type;
530: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).measure :=
531: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).measure;
532: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).start_time :=

Line 530: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).measure :=

526: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).bb_id :=
527: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).bb_id;
528: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).type :=
529: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).type;
530: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).measure :=
531: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).measure;
532: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).start_time :=
533: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).start_time;
534: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).stop_time :=

Line 532: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).start_time :=

528: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).type :=
529: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).type;
530: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).measure :=
531: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).measure;
532: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).start_time :=
533: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).start_time;
534: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).stop_time :=
535: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).stop_time;
536: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).parent_bb_id :=

Line 534: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).stop_time :=

530: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).measure :=
531: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).measure;
532: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).start_time :=
533: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).start_time;
534: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).stop_time :=
535: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).stop_time;
536: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).parent_bb_id :=
537: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).parent_bb_id;
538: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).scope :=

Line 536: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).parent_bb_id :=

532: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).start_time :=
533: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).start_time;
534: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).stop_time :=
535: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).stop_time;
536: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).parent_bb_id :=
537: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).parent_bb_id;
538: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).scope :=
539: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).scope;
540: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).resource_id :=

Line 538: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).scope :=

534: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).stop_time :=
535: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).stop_time;
536: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).parent_bb_id :=
537: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).parent_bb_id;
538: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).scope :=
539: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).scope;
540: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).resource_id :=
541: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).resource_id;
542: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).resource_type :=

Line 540: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).resource_id :=

536: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).parent_bb_id :=
537: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).parent_bb_id;
538: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).scope :=
539: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).scope;
540: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).resource_id :=
541: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).resource_id;
542: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).resource_type :=
543: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).resource_type;
544: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).comment_text :=

Line 542: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).resource_type :=

538: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).scope :=
539: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).scope;
540: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).resource_id :=
541: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).resource_id;
542: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).resource_type :=
543: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).resource_type;
544: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).comment_text :=
545: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).comment_text;
546: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).uom :=

Line 544: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).comment_text :=

540: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).resource_id :=
541: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).resource_id;
542: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).resource_type :=
543: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).resource_type;
544: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).comment_text :=
545: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).comment_text;
546: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).uom :=
547: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).uom;
548: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).ovn :=

Line 546: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).uom :=

542: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).resource_type :=
543: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).resource_type;
544: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).comment_text :=
545: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).comment_text;
546: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).uom :=
547: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).uom;
548: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).ovn :=
549: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).ovn;
550: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).changed :=

Line 548: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).ovn :=

544: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).comment_text :=
545: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).comment_text;
546: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).uom :=
547: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).uom;
548: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).ovn :=
549: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).ovn;
550: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).changed :=
551: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).changed;
552: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).deleted :=

Line 550: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).changed :=

546: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).uom :=
547: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).uom;
548: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).ovn :=
549: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).ovn;
550: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).changed :=
551: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).changed;
552: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).deleted :=
553: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).deleted;
554: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).timecard_bb_id :=

Line 552: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).deleted :=

548: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).ovn :=
549: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).ovn;
550: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).changed :=
551: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).changed;
552: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).deleted :=
553: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).deleted;
554: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).timecard_bb_id :=
555: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).timecard_bb_id;
556: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).timecard_ovn :=

Line 554: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).timecard_bb_id :=

550: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).changed :=
551: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).changed;
552: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).deleted :=
553: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).deleted;
554: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).timecard_bb_id :=
555: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).timecard_bb_id;
556: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).timecard_ovn :=
557: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).timecard_ovn;
558:

Line 556: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).timecard_ovn :=

552: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).deleted :=
553: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).deleted;
554: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).timecard_bb_id :=
555: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).timecard_bb_id;
556: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_index).timecard_ovn :=
557: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).timecard_ovn;
558:
559:
560: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks.next(l_index);

Line 576: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks.delete;

572:
573: BEGIN
574:
575: -- delete the integration global pl/sql first
576: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks.delete;
577:
578: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks.first;
579:
580: LOOP

Line 583: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).bb_id :=

579:
580: LOOP
581: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks.exists(l_index));
582:
583: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).bb_id :=
584: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).bb_id;
585: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).type :=
586: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).type;
587: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).measure :=

Line 585: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).type :=

581: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks.exists(l_index));
582:
583: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).bb_id :=
584: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).bb_id;
585: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).type :=
586: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).type;
587: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).measure :=
588: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).measure;
589: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).start_time :=

Line 587: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).measure :=

583: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).bb_id :=
584: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).bb_id;
585: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).type :=
586: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).type;
587: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).measure :=
588: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).measure;
589: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).start_time :=
590: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).start_time;
591: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).stop_time :=

Line 589: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).start_time :=

585: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).type :=
586: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).type;
587: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).measure :=
588: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).measure;
589: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).start_time :=
590: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).start_time;
591: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).stop_time :=
592: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).stop_time;
593: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).parent_bb_id :=

Line 591: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).stop_time :=

587: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).measure :=
588: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).measure;
589: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).start_time :=
590: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).start_time;
591: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).stop_time :=
592: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).stop_time;
593: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).parent_bb_id :=
594: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).parent_bb_id;
595: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).scope :=

Line 593: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).parent_bb_id :=

589: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).start_time :=
590: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).start_time;
591: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).stop_time :=
592: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).stop_time;
593: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).parent_bb_id :=
594: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).parent_bb_id;
595: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).scope :=
596: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).scope;
597: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).resource_id :=

Line 595: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).scope :=

591: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).stop_time :=
592: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).stop_time;
593: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).parent_bb_id :=
594: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).parent_bb_id;
595: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).scope :=
596: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).scope;
597: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).resource_id :=
598: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).resource_id;
599: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).resource_type :=

Line 597: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).resource_id :=

593: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).parent_bb_id :=
594: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).parent_bb_id;
595: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).scope :=
596: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).scope;
597: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).resource_id :=
598: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).resource_id;
599: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).resource_type :=
600: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).resource_type;
601: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).comment_text :=

Line 599: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).resource_type :=

595: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).scope :=
596: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).scope;
597: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).resource_id :=
598: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).resource_id;
599: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).resource_type :=
600: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).resource_type;
601: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).comment_text :=
602: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).comment_text;
603: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).uom :=

Line 601: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).comment_text :=

597: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).resource_id :=
598: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).resource_id;
599: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).resource_type :=
600: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).resource_type;
601: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).comment_text :=
602: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).comment_text;
603: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).uom :=
604: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).uom;
605: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).ovn :=

Line 603: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).uom :=

599: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).resource_type :=
600: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).resource_type;
601: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).comment_text :=
602: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).comment_text;
603: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).uom :=
604: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).uom;
605: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).ovn :=
606: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).ovn;
607: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).changed :=

Line 605: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).ovn :=

601: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).comment_text :=
602: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).comment_text;
603: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).uom :=
604: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).uom;
605: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).ovn :=
606: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).ovn;
607: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).changed :=
608: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).changed;
609: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).deleted :=

Line 607: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).changed :=

603: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).uom :=
604: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).uom;
605: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).ovn :=
606: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).ovn;
607: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).changed :=
608: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).changed;
609: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).deleted :=
610: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).deleted;
611: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).timecard_bb_id :=

Line 609: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).deleted :=

605: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).ovn :=
606: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).ovn;
607: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).changed :=
608: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).changed;
609: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).deleted :=
610: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).deleted;
611: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).timecard_bb_id :=
612: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).timecard_bb_id;
613: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).timecard_ovn :=

Line 611: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).timecard_bb_id :=

607: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).changed :=
608: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).changed;
609: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).deleted :=
610: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).deleted;
611: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).timecard_bb_id :=
612: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).timecard_bb_id;
613: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).timecard_ovn :=
614: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).timecard_ovn;
615:

Line 613: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).timecard_ovn :=

609: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).deleted :=
610: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).deleted;
611: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).timecard_bb_id :=
612: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).timecard_bb_id;
613: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_index).timecard_ovn :=
614: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).timecard_ovn;
615:
616:
617: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks.next(l_index);

Line 633: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes.delete;

629:
630: BEGIN
631:
632: -- delete the integration global pl/sql first
633: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes.delete;
634:
635: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes.first;
636:
637: LOOP

Line 640: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes(l_index).bb_id :=

636:
637: LOOP
638: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes.exists(l_index));
639:
640: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes(l_index).bb_id :=
641: HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes(l_index).bb_id;
642: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes(l_index).field_name :=
643: HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes(l_index).field_name;
644: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes(l_index).value :=

Line 642: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes(l_index).field_name :=

638: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes.exists(l_index));
639:
640: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes(l_index).bb_id :=
641: HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes(l_index).bb_id;
642: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes(l_index).field_name :=
643: HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes(l_index).field_name;
644: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes(l_index).value :=
645: HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes(l_index).value;
646: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes(l_index).context :=

Line 644: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes(l_index).value :=

640: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes(l_index).bb_id :=
641: HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes(l_index).bb_id;
642: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes(l_index).field_name :=
643: HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes(l_index).field_name;
644: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes(l_index).value :=
645: HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes(l_index).value;
646: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes(l_index).context :=
647: HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes(l_index).context;
648: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes(l_index).category :=

Line 646: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes(l_index).context :=

642: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes(l_index).field_name :=
643: HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes(l_index).field_name;
644: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes(l_index).value :=
645: HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes(l_index).value;
646: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes(l_index).context :=
647: HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes(l_index).context;
648: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes(l_index).category :=
649: HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes(l_index).category;
650:

Line 648: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes(l_index).category :=

644: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes(l_index).value :=
645: HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes(l_index).value;
646: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes(l_index).context :=
647: HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes(l_index).context;
648: HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes(l_index).category :=
649: HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes(l_index).category;
650:
651:
652: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes.next(l_index);

Line 667: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes.delete;

663:
664: BEGIN
665:
666: -- delete the integration global pl/sql first
667: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes.delete;
668:
669: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes.first;
670:
671: LOOP

Line 674: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes(l_index).bb_id :=

670:
671: LOOP
672: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes.exists(l_index));
673:
674: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes(l_index).bb_id :=
675: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes(l_index).bb_id;
676: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes(l_index).field_name :=
677: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes(l_index).field_name;
678: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes(l_index).value :=

Line 676: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes(l_index).field_name :=

672: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes.exists(l_index));
673:
674: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes(l_index).bb_id :=
675: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes(l_index).bb_id;
676: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes(l_index).field_name :=
677: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes(l_index).field_name;
678: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes(l_index).value :=
679: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes(l_index).value;
680: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes(l_index).context :=

Line 678: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes(l_index).value :=

674: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes(l_index).bb_id :=
675: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes(l_index).bb_id;
676: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes(l_index).field_name :=
677: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes(l_index).field_name;
678: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes(l_index).value :=
679: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes(l_index).value;
680: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes(l_index).context :=
681: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes(l_index).context;
682: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes(l_index).category :=

Line 680: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes(l_index).context :=

676: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes(l_index).field_name :=
677: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes(l_index).field_name;
678: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes(l_index).value :=
679: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes(l_index).value;
680: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes(l_index).context :=
681: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes(l_index).context;
682: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes(l_index).category :=
683: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes(l_index).category;
684:

Line 682: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes(l_index).category :=

678: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes(l_index).value :=
679: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes(l_index).value;
680: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes(l_index).context :=
681: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes(l_index).context;
682: HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes(l_index).category :=
683: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes(l_index).category;
684:
685:
686: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes.next(l_index);

Line 701: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_bb_id.delete;

697:
698: BEGIN
699:
700: -- delete the integration global pl/sql first
701: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_bb_id.delete;
702:
703: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_bb_id.first;
704:
705: LOOP

Line 708: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_bb_id(l_index) :=

704:
705: LOOP
706: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_bb_id.exists(l_index));
707:
708: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_bb_id(l_index) :=
709: HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_bb_id(l_index);
710:
711:
712: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_bb_id.next(l_index);

Line 725: l_index := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status.first;

721: l_index NUMBER;
722:
723: BEGIN
724:
725: l_index := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status.first;
726:
727: LOOP
728: EXIT WHEN (NOT HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status.exists(l_index));
729:

Line 728: EXIT WHEN (NOT HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status.exists(l_index));

724:
725: l_index := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status.first;
726:
727: LOOP
728: EXIT WHEN (NOT HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status.exists(l_index));
729:
730: HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_status(l_index) :=
731: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_index);
732:

Line 731: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_index);

727: LOOP
728: EXIT WHEN (NOT HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status.exists(l_index));
729:
730: HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_status(l_index) :=
731: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_index);
732:
733:
734: l_index := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status.next(l_index);
735:

Line 734: l_index := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status.next(l_index);

730: HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_status(l_index) :=
731: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_index);
732:
733:
734: l_index := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status.next(l_index);
735:
736: END LOOP;
737:
738: END int_to_otl_gb_tx_detail_status;

Line 749: l_index := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception.first;

745: l_index NUMBER;
746:
747: BEGIN
748:
749: l_index := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception.first;
750:
751: LOOP
752: EXIT WHEN (NOT HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception.exists(l_index));
753:

Line 752: EXIT WHEN (NOT HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception.exists(l_index));

748:
749: l_index := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception.first;
750:
751: LOOP
752: EXIT WHEN (NOT HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception.exists(l_index));
753:
754: HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_exception(l_index) :=
755: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_index);
756:

Line 755: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_index);

751: LOOP
752: EXIT WHEN (NOT HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception.exists(l_index));
753:
754: HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_exception(l_index) :=
755: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_index);
756:
757:
758: l_index := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception.next(l_index);
759:

Line 758: l_index := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception.next(l_index);

754: HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_exception(l_index) :=
755: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_index);
756:
757:
758: l_index := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception.next(l_index);
759:
760: END LOOP;
761:
762: END int_to_otl_gb_tx_detail_except;

Line 775: HXC_USER_TYPE_DEFINITION_GRP.t_time_bld_blks.delete;

771:
772: BEGIN
773:
774: -- delete the integration global pl/sql first
775: HXC_USER_TYPE_DEFINITION_GRP.t_time_bld_blks.delete;
776:
777: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_time_bld_blks.first;
778:
779: LOOP

Line 782: HXC_USER_TYPE_DEFINITION_GRP.t_time_bld_blks(l_index).start_time :=

778:
779: LOOP
780: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_time_bld_blks.exists(l_index));
781:
782: HXC_USER_TYPE_DEFINITION_GRP.t_time_bld_blks(l_index).start_time :=
783: HXC_GENERIC_RETRIEVAL_PKG.t_time_bld_blks(l_index).start_time;
784: HXC_USER_TYPE_DEFINITION_GRP.t_time_bld_blks(l_index).stop_time :=
785: HXC_GENERIC_RETRIEVAL_PKG.t_time_bld_blks(l_index).stop_time;
786: HXC_USER_TYPE_DEFINITION_GRP.t_time_bld_blks(l_index).comment_text :=

Line 784: HXC_USER_TYPE_DEFINITION_GRP.t_time_bld_blks(l_index).stop_time :=

780: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_time_bld_blks.exists(l_index));
781:
782: HXC_USER_TYPE_DEFINITION_GRP.t_time_bld_blks(l_index).start_time :=
783: HXC_GENERIC_RETRIEVAL_PKG.t_time_bld_blks(l_index).start_time;
784: HXC_USER_TYPE_DEFINITION_GRP.t_time_bld_blks(l_index).stop_time :=
785: HXC_GENERIC_RETRIEVAL_PKG.t_time_bld_blks(l_index).stop_time;
786: HXC_USER_TYPE_DEFINITION_GRP.t_time_bld_blks(l_index).comment_text :=
787: HXC_GENERIC_RETRIEVAL_PKG.t_time_bld_blks(l_index).comment_text;
788:

Line 786: HXC_USER_TYPE_DEFINITION_GRP.t_time_bld_blks(l_index).comment_text :=

782: HXC_USER_TYPE_DEFINITION_GRP.t_time_bld_blks(l_index).start_time :=
783: HXC_GENERIC_RETRIEVAL_PKG.t_time_bld_blks(l_index).start_time;
784: HXC_USER_TYPE_DEFINITION_GRP.t_time_bld_blks(l_index).stop_time :=
785: HXC_GENERIC_RETRIEVAL_PKG.t_time_bld_blks(l_index).stop_time;
786: HXC_USER_TYPE_DEFINITION_GRP.t_time_bld_blks(l_index).comment_text :=
787: HXC_GENERIC_RETRIEVAL_PKG.t_time_bld_blks(l_index).comment_text;
788:
789:
790: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_time_bld_blks.next(l_index);

Line 940: p_message_table in out nocopy HXC_USER_TYPE_DEFINITION_GRP.MESSAGE_TABLE

936: -- ----------------------------------------------------------------------------
937: -- |---------------------------< add_error_to_table >------------------------|
938: -- ----------------------------------------------------------------------------
939: PROCEDURE add_error_to_table (
940: p_message_table in out nocopy HXC_USER_TYPE_DEFINITION_GRP.MESSAGE_TABLE
941: ,p_message_name in FND_NEW_MESSAGES.MESSAGE_NAME%TYPE
942: ,p_message_token in VARCHAR2
943: ,p_message_level in VARCHAR2
944: ,p_message_field in VARCHAR2

Line 1066: (p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)

1062: -- ----------------------------------------------------------------------------
1063: -- |---------------------------< messages_to_string >------------------------|
1064: -- ----------------------------------------------------------------------------
1065: FUNCTION messages_to_string
1066: (p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)
1067: RETURN VARCHAR2
1068: IS
1069:
1070: l_return VARCHAR2(32767);

Line 1103: p_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info)

1099: -- ----------------------------------------------------------------------------
1100: -- |---------------------------< attributes_to_string >------------------------|
1101: -- ----------------------------------------------------------------------------
1102: FUNCTION attributes_to_string(
1103: p_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info)
1104: RETURN VARCHAR2
1105: IS
1106:
1107: l_return VARCHAR2(32767);

Line 1140: (p_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.timecard_info)

1136: -- ----------------------------------------------------------------------------
1137: -- |---------------------------< blocks_to_string >------------------------|
1138: -- ----------------------------------------------------------------------------
1139: FUNCTION blocks_to_string
1140: (p_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.timecard_info)
1141: RETURN VARCHAR2
1142: IS
1143:
1144: l_return VARCHAR2(32767);

Line 1208: RETURN HXC_USER_TYPE_DEFINITION_GRP.timecard_info

1204: -- ----------------------------------------------------------------------------
1205: -- |-----------------< get_wf_G_Time_Building_Blocks >------------------------|
1206: -- ----------------------------------------------------------------------------
1207: FUNCTION get_wf_g_time_building_blocks
1208: RETURN HXC_USER_TYPE_DEFINITION_GRP.timecard_info
1209: IS
1210:
1211:
1212: l_building_blocks_otl HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info;

Line 1213: l_building_blocks_int HXC_USER_TYPE_DEFINITION_GRP.timecard_info;

1209: IS
1210:
1211:
1212: l_building_blocks_otl HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info;
1213: l_building_blocks_int HXC_USER_TYPE_DEFINITION_GRP.timecard_info;
1214:
1215: BEGIN
1216:
1217: l_building_blocks_int.delete;

Line 1239: RETURN HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info

1235: -- ----------------------------------------------------------------------------
1236: -- |-----------------< get_wf_G_Time_App_Attributes >------------------------|
1237: -- ----------------------------------------------------------------------------
1238: FUNCTION get_wf_g_time_app_attributes
1239: RETURN HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info
1240: IS
1241:
1242: l_app_attributes_otl HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info;
1243: l_app_attributes_int HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info;

Line 1243: l_app_attributes_int HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info;

1239: RETURN HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info
1240: IS
1241:
1242: l_app_attributes_otl HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info;
1243: l_app_attributes_int HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info;
1244:
1245: BEGIN
1246:
1247: l_app_attributes_int.delete;

Line 1413: ) RETURN HXC_USER_TYPE_DEFINITION_GRP.building_block_info IS

1409: -- ----------------------------------------------------------------------------
1410: FUNCTION build_block
1411: (p_time_building_block_id IN HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
1412: ,p_time_building_block_ovn IN HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
1413: ) RETURN HXC_USER_TYPE_DEFINITION_GRP.building_block_info IS
1414:
1415: cursor c_block
1416: (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
1417: ,p_time_building_block_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

Line 1426: l_new_block HXC_USER_TYPE_DEFINITION_GRP.building_block_info;

1422: and object_version_number = p_time_building_block_ovn;
1423:
1424:
1425: l_block c_block%ROWTYPE;
1426: l_new_block HXC_USER_TYPE_DEFINITION_GRP.building_block_info;
1427: e_no_existing_block exception;
1428:
1429: BEGIN
1430:

Line 1481: ) return HXC_USER_TYPE_DEFINITION_GRP.building_block_attribute_info is

1477: FUNCTION build_attribute
1478: (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
1479: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type
1480: ,p_attribute_category in hxc_time_attributes.attribute_category%type
1481: ) return HXC_USER_TYPE_DEFINITION_GRP.building_block_attribute_info is
1482:
1483: cursor c_attribute is
1484: select a.*
1485: from hxc_time_attributes a,

Line 1493: l_new_attribute HXC_USER_TYPE_DEFINITION_GRP.building_block_attribute_info;

1489: and b.time_building_block_ovn = P_time_building_block_ovn
1490: and a.attribute_category = nvl(p_attribute_category,a.attribute_category);
1491:
1492:
1493: l_new_attribute HXC_USER_TYPE_DEFINITION_GRP.building_block_attribute_info;
1494: l_attribute_row c_attribute%ROWTYPE;
1495: l_index_att NUMBER := 1;
1496:
1497: Begin