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_GENERIC_RETRIEVAL_PKG

Line 454: -- HXC_GENERIC_RETRIEVAL_PKG TRANSFER UTILITY PROCEDURE

450: END set_app_hook_params;
451:
452:
453: --
454: -- HXC_GENERIC_RETRIEVAL_PKG TRANSFER UTILITY PROCEDURE
455: --
456: -- ----------------------------------------------------------------------------
457: -- |---------------------< otl_to_int_gb_tx_detail_status >-------------------|
458: -- ----------------------------------------------------------------------------

Line 468: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_status.first;

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
471: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_status.exists(l_index));
472:

Line 471: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_status.exists(l_index));

467:
468: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_status.first;
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:

Line 474: HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_status(l_index);

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);
478:

Line 477: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_status.next(l_index);

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);
478:
479: END LOOP;
480:
481: END otl_to_int_gb_tx_detail_status;

Line 494: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_exception.first;

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
497: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_exception.exists(l_index));
498:

Line 497: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_exception.exists(l_index));

493:
494: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_exception.first;
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:

Line 500: HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_exception(l_index);

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);
504:

Line 503: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_exception.next(l_index);

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);
504:
505: END LOOP;
506:
507: END otl_to_int_gb_tx_detail_except;

Line 521: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks.first;

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
524: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks.exists(l_index));
525:

Line 524: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks.exists(l_index));

520:
521: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks.first;
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 :=

Line 527: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).bb_id;

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 :=
531: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).measure;

Line 529: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).type;

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 :=
533: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).start_time;

Line 531: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).measure;

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 :=
535: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).stop_time;

Line 533: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).start_time;

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 :=
537: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).parent_bb_id;

Line 535: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).stop_time;

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 :=
539: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).scope;

Line 537: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).parent_bb_id;

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 :=
541: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).resource_id;

Line 539: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).scope;

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 :=
543: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).resource_type;

Line 541: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).resource_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 :=
545: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).comment_text;

Line 543: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).resource_type;

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 :=
547: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).uom;

Line 545: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).comment_text;

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 :=
549: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).ovn;

Line 547: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).uom;

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 :=
551: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).changed;

Line 549: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).ovn;

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 :=
553: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).deleted;

Line 551: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).changed;

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 :=
555: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).timecard_bb_id;

Line 553: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).deleted;

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 :=
557: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).timecard_ovn;

Line 555: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).timecard_bb_id;

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:
559:

Line 557: HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks(l_index).timecard_ovn;

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);
561:

Line 560: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_detail_bld_blks.next(l_index);

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);
561:
562: END LOOP;
563:
564: END otl_to_int_gb_detail_bld_blks;

Line 578: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks.first;

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
581: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks.exists(l_index));
582:

Line 581: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks.exists(l_index));

577:
578: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks.first;
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 :=

Line 584: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).bb_id;

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 :=
588: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).measure;

Line 586: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).type;

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 :=
590: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).start_time;

Line 588: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).measure;

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 :=
592: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).stop_time;

Line 590: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).start_time;

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 :=
594: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).parent_bb_id;

Line 592: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).stop_time;

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 :=
596: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).scope;

Line 594: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).parent_bb_id;

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 :=
598: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).resource_id;

Line 596: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).scope;

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 :=
600: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).resource_type;

Line 598: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).resource_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 :=
602: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).comment_text;

Line 600: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).resource_type;

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 :=
604: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).uom;

Line 602: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).comment_text;

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 :=
606: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).ovn;

Line 604: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).uom;

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 :=
608: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).changed;

Line 606: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).ovn;

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 :=
610: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).deleted;

Line 608: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).changed;

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 :=
612: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).timecard_bb_id;

Line 610: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).deleted;

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 :=
614: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).timecard_ovn;

Line 612: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).timecard_bb_id;

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:
616:

Line 614: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks(l_index).timecard_ovn;

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);
618:

Line 617: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_bld_blks.next(l_index);

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);
618:
619: END LOOP;
620:
621: END otl_to_int_gb_old_det_bld_blks;

Line 635: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes.first;

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
638: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes.exists(l_index));
639:

Line 638: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes.exists(l_index));

634:
635: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes.first;
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 :=

Line 641: HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes(l_index).bb_id;

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 :=
645: HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes(l_index).value;

Line 643: HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes(l_index).field_name;

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 :=
647: HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes(l_index).context;

Line 645: HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes(l_index).value;

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 :=
649: HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes(l_index).category;

Line 647: HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes(l_index).context;

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:
651:

Line 649: HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes(l_index).category;

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);
653:

Line 652: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_detail_attributes.next(l_index);

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);
653:
654: END LOOP;
655:
656: END otl_to_int_gb_detail_att;

Line 669: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes.first;

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
672: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes.exists(l_index));
673:

Line 672: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes.exists(l_index));

668:
669: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes.first;
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 :=

Line 675: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes(l_index).bb_id;

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 :=
679: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes(l_index).value;

Line 677: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes(l_index).field_name;

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 :=
681: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes(l_index).context;

Line 679: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes(l_index).value;

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 :=
683: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes(l_index).category;

Line 681: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes(l_index).context;

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:
685:

Line 683: HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes(l_index).category;

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);
687:

Line 686: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_old_detail_attributes.next(l_index);

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);
687:
688: END LOOP;
689:
690: END otl_to_int_gb_old_detail_att;

Line 703: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_bb_id.first;

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
706: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_bb_id.exists(l_index));
707:

Line 706: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_bb_id.exists(l_index));

702:
703: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_bb_id.first;
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:

Line 709: HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_bb_id(l_index);

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);
713:

Line 712: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_bb_id.next(l_index);

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);
713:
714: END LOOP;
715:
716: END otl_to_int_gb_tx_detail_bb_id;

Line 730: HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_status(l_index) :=

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:
733:
734: l_index := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status.next(l_index);

Line 754: HXC_GENERIC_RETRIEVAL_PKG.t_tx_detail_exception(l_index) :=

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:
757:
758: l_index := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception.next(l_index);

Line 777: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_time_bld_blks.first;

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
780: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_time_bld_blks.exists(l_index));
781:

Line 780: EXIT WHEN (NOT HXC_GENERIC_RETRIEVAL_PKG.t_time_bld_blks.exists(l_index));

776:
777: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_time_bld_blks.first;
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 :=

Line 783: HXC_GENERIC_RETRIEVAL_PKG.t_time_bld_blks(l_index).start_time;

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 :=
787: HXC_GENERIC_RETRIEVAL_PKG.t_time_bld_blks(l_index).comment_text;

Line 785: HXC_GENERIC_RETRIEVAL_PKG.t_time_bld_blks(l_index).stop_time;

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:
789:

Line 787: HXC_GENERIC_RETRIEVAL_PKG.t_time_bld_blks(l_index).comment_text;

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);
791:

Line 790: l_index := HXC_GENERIC_RETRIEVAL_PKG.t_time_bld_blks.next(l_index);

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);
791:
792: END LOOP;
793:
794: END otl_to_int_gb_time_bld_blks;

Line 798: -- HXC_GENERIC_RETRIEVAL_PKG

794: END otl_to_int_gb_time_bld_blks;
795:
796:
797: --
798: -- HXC_GENERIC_RETRIEVAL_PKG
799: --
800: -- ----------------------------------------------------------------------------
801: -- |---------------------------< execute_retrieval_process >-------------------|
802: -- ----------------------------------------------------------------------------

Line 822: HXC_GENERIC_RETRIEVAL_PKG.execute_retrieval_process

818:
819: --
820: -- call of the OTL API
821: --
822: HXC_GENERIC_RETRIEVAL_PKG.execute_retrieval_process
823: (p_process => p_process
824: ,p_transaction_code => p_transaction_code
825: ,p_start_date => p_start_date
826: ,p_end_date => p_end_date

Line 875: HXC_GENERIC_RETRIEVAL_PKG.Update_Transaction_Status(

871:
872: --
873: -- call of the OTL API
874: --
875: HXC_GENERIC_RETRIEVAL_PKG.Update_Transaction_Status(
876: p_process => p_process
877: ,p_status => p_status
878: ,p_exception_description => p_exception_description
879: ,p_rollback => p_rollback);