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.JG_RX_IR_PKG dependencies on DBMS_SQL

Line 585: v_MainCursor :=DBMS_SQL.OPEN_CURSOR;

581: fa_rx_util_pkg.debug('Main SQL:');
582: fa_rx_util_pkg.debug(l_main_sql);
583:
584: /* Open v_MainCursor */
585: v_MainCursor :=DBMS_SQL.OPEN_CURSOR;
586: fa_rx_util_pkg.debug('***** OPEN CURSOR: v_MainCursor *****');
587: fa_rx_util_pkg.debug('v_MainCursor :'||v_MainCursor);
588:
589: /* PARSE v_MainCursor */

Line 590: DBMS_SQL.PARSE (v_MainCursor,l_main_sql,DBMS_SQL.V7);

586: fa_rx_util_pkg.debug('***** OPEN CURSOR: v_MainCursor *****');
587: fa_rx_util_pkg.debug('v_MainCursor :'||v_MainCursor);
588:
589: /* PARSE v_MainCursor */
590: DBMS_SQL.PARSE (v_MainCursor,l_main_sql,DBMS_SQL.V7);
591: fa_rx_util_pkg.debug('***** PARSE: v_MainCursor *****');
592:
593: /* DEFINE COLUMN v_MainCursor */
594: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,1,h_invoice_id);

Line 594: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,1,h_invoice_id);

590: DBMS_SQL.PARSE (v_MainCursor,l_main_sql,DBMS_SQL.V7);
591: fa_rx_util_pkg.debug('***** PARSE: v_MainCursor *****');
592:
593: /* DEFINE COLUMN v_MainCursor */
594: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,1,h_invoice_id);
595: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,2,h_liability_ccid);
596: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,3,h_invoice_type,25);
597: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_inv_dist_id);
598: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_dist_number); -- Originally line_number);

Line 595: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,2,h_liability_ccid);

591: fa_rx_util_pkg.debug('***** PARSE: v_MainCursor *****');
592:
593: /* DEFINE COLUMN v_MainCursor */
594: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,1,h_invoice_id);
595: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,2,h_liability_ccid);
596: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,3,h_invoice_type,25);
597: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_inv_dist_id);
598: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_dist_number); -- Originally line_number);
599: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_dist_type,25); -- Originally line_type,25);

Line 596: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,3,h_invoice_type,25);

592:
593: /* DEFINE COLUMN v_MainCursor */
594: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,1,h_invoice_id);
595: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,2,h_liability_ccid);
596: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,3,h_invoice_type,25);
597: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_inv_dist_id);
598: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_dist_number); -- Originally line_number);
599: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_dist_type,25); -- Originally line_type,25);
600: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_dist_ccid);

Line 597: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_inv_dist_id);

593: /* DEFINE COLUMN v_MainCursor */
594: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,1,h_invoice_id);
595: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,2,h_liability_ccid);
596: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,3,h_invoice_type,25);
597: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_inv_dist_id);
598: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_dist_number); -- Originally line_number);
599: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_dist_type,25); -- Originally line_type,25);
600: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_dist_ccid);
601: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_dist_acct_date); -- Newly Added

Line 598: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_dist_number); -- Originally line_number);

594: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,1,h_invoice_id);
595: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,2,h_liability_ccid);
596: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,3,h_invoice_type,25);
597: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_inv_dist_id);
598: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_dist_number); -- Originally line_number);
599: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_dist_type,25); -- Originally line_type,25);
600: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_dist_ccid);
601: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_dist_acct_date); -- Newly Added
602: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,9,h_line_number); -- Newly Added

Line 599: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_dist_type,25); -- Originally line_type,25);

595: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,2,h_liability_ccid);
596: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,3,h_invoice_type,25);
597: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_inv_dist_id);
598: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_dist_number); -- Originally line_number);
599: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_dist_type,25); -- Originally line_type,25);
600: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_dist_ccid);
601: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_dist_acct_date); -- Newly Added
602: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,9,h_line_number); -- Newly Added
603: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,10,h_line_type,25); -- Newly Added

Line 600: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_dist_ccid);

596: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,3,h_invoice_type,25);
597: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_inv_dist_id);
598: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_dist_number); -- Originally line_number);
599: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_dist_type,25); -- Originally line_type,25);
600: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_dist_ccid);
601: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_dist_acct_date); -- Newly Added
602: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,9,h_line_number); -- Newly Added
603: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,10,h_line_type,25); -- Newly Added
604:

Line 601: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_dist_acct_date); -- Newly Added

597: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_inv_dist_id);
598: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_dist_number); -- Originally line_number);
599: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_dist_type,25); -- Originally line_type,25);
600: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_dist_ccid);
601: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_dist_acct_date); -- Newly Added
602: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,9,h_line_number); -- Newly Added
603: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,10,h_line_type,25); -- Newly Added
604:
605: fa_rx_util_pkg.debug('***** DEFINE COLUMN: v_MainCursor *****');

Line 602: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,9,h_line_number); -- Newly Added

598: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_dist_number); -- Originally line_number);
599: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_dist_type,25); -- Originally line_type,25);
600: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_dist_ccid);
601: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_dist_acct_date); -- Newly Added
602: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,9,h_line_number); -- Newly Added
603: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,10,h_line_type,25); -- Newly Added
604:
605: fa_rx_util_pkg.debug('***** DEFINE COLUMN: v_MainCursor *****');
606:

Line 603: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,10,h_line_type,25); -- Newly Added

599: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_dist_type,25); -- Originally line_type,25);
600: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_dist_ccid);
601: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_dist_acct_date); -- Newly Added
602: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,9,h_line_number); -- Newly Added
603: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,10,h_line_type,25); -- Newly Added
604:
605: fa_rx_util_pkg.debug('***** DEFINE COLUMN: v_MainCursor *****');
606:
607: /* BIND BARIABLE v_MainCursor */

Line 609: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_acct_date_min',p_acct_date_min);

605: fa_rx_util_pkg.debug('***** DEFINE COLUMN: v_MainCursor *****');
606:
607: /* BIND BARIABLE v_MainCursor */
608: if p_acct_date_min is not null then
609: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_acct_date_min',p_acct_date_min);
610: end if;
611:
612: if p_acct_date_max is not null then
613: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_acct_date_max',p_acct_date_max);

Line 613: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_acct_date_max',p_acct_date_max);

609: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_acct_date_min',p_acct_date_min);
610: end if;
611:
612: if p_acct_date_max is not null then
613: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_acct_date_max',p_acct_date_max);
614: end if;
615:
616: if p_entered_date_min is not null then
617: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entered_date_min',p_entered_date_min);

Line 617: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entered_date_min',p_entered_date_min);

613: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_acct_date_max',p_acct_date_max);
614: end if;
615:
616: if p_entered_date_min is not null then
617: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entered_date_min',p_entered_date_min);
618: end if;
619:
620: if p_entered_date_max is not null then
621: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entered_date_max',p_entered_date_max);

Line 621: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entered_date_max',p_entered_date_max);

617: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entered_date_min',p_entered_date_min);
618: end if;
619:
620: if p_entered_date_max is not null then
621: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entered_date_max',p_entered_date_max);
622: end if;
623:
624: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_sort_by_alternate', h_sort_by_alternate);
625:

Line 624: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_sort_by_alternate', h_sort_by_alternate);

620: if p_entered_date_max is not null then
621: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entered_date_max',p_entered_date_max);
622: end if;
623:
624: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_sort_by_alternate', h_sort_by_alternate);
625:
626: /* Entered by */
627: if p_entry_person_id is not null then
628: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entry_person_id', p_entry_person_id);

Line 628: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entry_person_id', p_entry_person_id);

624: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_sort_by_alternate', h_sort_by_alternate);
625:
626: /* Entered by */
627: if p_entry_person_id is not null then
628: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entry_person_id', p_entry_person_id);
629: end if;
630:
631: /*Invoice Type */
632: if p_invoice_type is not null then

Line 633: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_invoice_type', p_invoice_type);

629: end if;
630:
631: /*Invoice Type */
632: if p_invoice_type is not null then
633: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_invoice_type', p_invoice_type);
634: end if;
635:
636: /* Batch ID */
637: if p_batch_id is not null then

Line 638: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_batch_id', p_batch_id);

634: end if;
635:
636: /* Batch ID */
637: if p_batch_id is not null then
638: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_batch_id', p_batch_id);
639: end if;
640:
641: /* Document Sequence Id */
642: if p_doc_sequence_id is not null then

Line 643: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_doc_sequence_id', p_doc_sequence_id);

639: end if;
640:
641: /* Document Sequence Id */
642: if p_doc_sequence_id is not null then
643: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_doc_sequence_id', p_doc_sequence_id);
644: end if;
645:
646: /* Document Sequence value range */
647: if p_doc_sequence_value_min is not null then

Line 648: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_doc_sequence_value_min', p_doc_sequence_value_min);

644: end if;
645:
646: /* Document Sequence value range */
647: if p_doc_sequence_value_min is not null then
648: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_doc_sequence_value_min', p_doc_sequence_value_min);
649: end if;
650:
651: if p_doc_sequence_value_max is not null then
652: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_doc_sequence_value_max', p_doc_sequence_value_max);

Line 652: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_doc_sequence_value_max', p_doc_sequence_value_max);

648: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_doc_sequence_value_min', p_doc_sequence_value_min);
649: end if;
650:
651: if p_doc_sequence_value_max is not null then
652: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_doc_sequence_value_max', p_doc_sequence_value_max);
653: end if;
654:
655: /* Supplier name range */
656: if p_supplier_min is not null then

Line 657: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_supplier_min', p_supplier_min);

653: end if;
654:
655: /* Supplier name range */
656: if p_supplier_min is not null then
657: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_supplier_min', p_supplier_min);
658: end if;
659:
660: if p_supplier_max is not null then
661: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_supplier_max', p_supplier_max);

Line 661: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_supplier_max', p_supplier_max);

657: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_supplier_min', p_supplier_min);
658: end if;
659:
660: if p_supplier_max is not null then
661: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_supplier_max', p_supplier_max);
662: end if;
663:
664: /* Liability account range */
665: if p_liability_min is not null and p_liability_max is not null then

Line 666: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_liability_min', p_liability_min);

662: end if;
663:
664: /* Liability account range */
665: if p_liability_min is not null and p_liability_max is not null then
666: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_liability_min', p_liability_min);
667: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_liability_max', p_liability_max);
668: end if;
669:
670: /* Distribution account range */

Line 667: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_liability_max', p_liability_max);

663:
664: /* Liability account range */
665: if p_liability_min is not null and p_liability_max is not null then
666: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_liability_min', p_liability_min);
667: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_liability_max', p_liability_max);
668: end if;
669:
670: /* Distribution account range */
671: if p_dist_acct_min is not null and p_dist_acct_max is not null then

Line 672: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_dist_acct_min', p_dist_acct_min);

668: end if;
669:
670: /* Distribution account range */
671: if p_dist_acct_min is not null and p_dist_acct_max is not null then
672: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_dist_acct_min', p_dist_acct_min);
673: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_dist_acct_max', p_dist_acct_max);
674: end if;
675:
676: /* Invoice Currency Code */

Line 673: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_dist_acct_max', p_dist_acct_max);

669:
670: /* Distribution account range */
671: if p_dist_acct_min is not null and p_dist_acct_max is not null then
672: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_dist_acct_min', p_dist_acct_min);
673: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_dist_acct_max', p_dist_acct_max);
674: end if;
675:
676: /* Invoice Currency Code */
677: if p_inv_currency_code is not null then

Line 678: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_inv_currency_code', p_inv_currency_code);

674: end if;
675:
676: /* Invoice Currency Code */
677: if p_inv_currency_code is not null then
678: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_inv_currency_code', p_inv_currency_code);
679: end if;
680:
681: /* Distribution mount range */
682: if p_dist_amount_min is not null then

Line 683: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_dist_amount_min', p_dist_amount_min);

679: end if;
680:
681: /* Distribution mount range */
682: if p_dist_amount_min is not null then
683: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_dist_amount_min', p_dist_amount_min);
684: end if;
685:
686: if p_dist_amount_max is not null then
687: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_dist_amount_max', p_dist_amount_max);

Line 687: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_dist_amount_max', p_dist_amount_max);

683: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_dist_amount_min', p_dist_amount_min);
684: end if;
685:
686: if p_dist_amount_max is not null then
687: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_dist_amount_max', p_dist_amount_max);
688: end if;
689:
690: /* Entered date range */
691: if p_entered_date_min is not null then

Line 692: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entered_date_min', p_entered_date_min);

688: end if;
689:
690: /* Entered date range */
691: if p_entered_date_min is not null then
692: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entered_date_min', p_entered_date_min);
693: end if;
694:
695: if p_entered_date_max is not null then
696: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entered_date_max', p_entered_date_max);

Line 696: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entered_date_max', p_entered_date_max);

692: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entered_date_min', p_entered_date_min);
693: end if;
694:
695: if p_entered_date_max is not null then
696: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entered_date_max', p_entered_date_max);
697: end if;
698:
699: /* MOAC Change - bind p_reporting_entity_id */
700: if p_reporting_level = '3000' then

Line 701: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_reporting_entity_id', h_reporting_entity_id);

697: end if;
698:
699: /* MOAC Change - bind p_reporting_entity_id */
700: if p_reporting_level = '3000' then
701: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_reporting_entity_id', h_reporting_entity_id);
702: fa_rx_util_pkg.debug('h_reporting_entity_id :'||h_reporting_entity_id);
703: end if;
704:
705: fa_rx_util_pkg.debug('***** BIND VARIABLE: v_MainCursor *****');

Line 708: v_MainReturn := DBMS_SQL.EXECUTE(v_MainCursor);

704:
705: fa_rx_util_pkg.debug('***** BIND VARIABLE: v_MainCursor *****');
706:
707:
708: v_MainReturn := DBMS_SQL.EXECUTE(v_MainCursor);
709: fa_rx_util_pkg.debug('***** EXECUTE: v_MainCursor *****');
710: fa_rx_util_pkg.debug('v_MainReturn :'||v_MainReturn);
711:
712: /* Loop and Fetch v_MainCursor */

Line 715: v_MainFetch := DBMS_SQL.FETCH_ROWS(v_MainCursor);

711:
712: /* Loop and Fetch v_MainCursor */
713: Loop
714:
715: v_MainFetch := DBMS_SQL.FETCH_ROWS(v_MainCursor);
716: fa_rx_util_pkg.debug('***** FETCH ROWS: v_MainCursor *****');
717: fa_rx_util_pkg.debug('v_MainFetch :'||v_MainFetch);
718:
719: If v_MainFetch =0 then

Line 723: DBMS_SQL.COLUMN_VALUE(v_MainCursor,1,h_invoice_id);

719: If v_MainFetch =0 then
720: Exit;
721: end if;
722:
723: DBMS_SQL.COLUMN_VALUE(v_MainCursor,1,h_invoice_id);
724: DBMS_SQL.COLUMN_VALUE(v_MainCursor,2,h_liability_ccid);
725: DBMS_SQL.COLUMN_VALUE(v_MainCursor,3,h_invoice_type);
726: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_inv_dist_id);
727: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_dist_number); -- Originally line_number);

Line 724: DBMS_SQL.COLUMN_VALUE(v_MainCursor,2,h_liability_ccid);

720: Exit;
721: end if;
722:
723: DBMS_SQL.COLUMN_VALUE(v_MainCursor,1,h_invoice_id);
724: DBMS_SQL.COLUMN_VALUE(v_MainCursor,2,h_liability_ccid);
725: DBMS_SQL.COLUMN_VALUE(v_MainCursor,3,h_invoice_type);
726: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_inv_dist_id);
727: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_dist_number); -- Originally line_number);
728: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_dist_type); -- Originally line_type);

Line 725: DBMS_SQL.COLUMN_VALUE(v_MainCursor,3,h_invoice_type);

721: end if;
722:
723: DBMS_SQL.COLUMN_VALUE(v_MainCursor,1,h_invoice_id);
724: DBMS_SQL.COLUMN_VALUE(v_MainCursor,2,h_liability_ccid);
725: DBMS_SQL.COLUMN_VALUE(v_MainCursor,3,h_invoice_type);
726: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_inv_dist_id);
727: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_dist_number); -- Originally line_number);
728: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_dist_type); -- Originally line_type);
729: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_dist_ccid);

Line 726: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_inv_dist_id);

722:
723: DBMS_SQL.COLUMN_VALUE(v_MainCursor,1,h_invoice_id);
724: DBMS_SQL.COLUMN_VALUE(v_MainCursor,2,h_liability_ccid);
725: DBMS_SQL.COLUMN_VALUE(v_MainCursor,3,h_invoice_type);
726: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_inv_dist_id);
727: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_dist_number); -- Originally line_number);
728: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_dist_type); -- Originally line_type);
729: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_dist_ccid);
730: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_dist_acct_date); -- Newly Added

Line 727: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_dist_number); -- Originally line_number);

723: DBMS_SQL.COLUMN_VALUE(v_MainCursor,1,h_invoice_id);
724: DBMS_SQL.COLUMN_VALUE(v_MainCursor,2,h_liability_ccid);
725: DBMS_SQL.COLUMN_VALUE(v_MainCursor,3,h_invoice_type);
726: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_inv_dist_id);
727: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_dist_number); -- Originally line_number);
728: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_dist_type); -- Originally line_type);
729: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_dist_ccid);
730: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_dist_acct_date); -- Newly Added
731: DBMS_SQL.COLUMN_VALUE(v_MainCursor,9,h_line_number); -- Newly Added

Line 728: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_dist_type); -- Originally line_type);

724: DBMS_SQL.COLUMN_VALUE(v_MainCursor,2,h_liability_ccid);
725: DBMS_SQL.COLUMN_VALUE(v_MainCursor,3,h_invoice_type);
726: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_inv_dist_id);
727: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_dist_number); -- Originally line_number);
728: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_dist_type); -- Originally line_type);
729: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_dist_ccid);
730: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_dist_acct_date); -- Newly Added
731: DBMS_SQL.COLUMN_VALUE(v_MainCursor,9,h_line_number); -- Newly Added
732: DBMS_SQL.COLUMN_VALUE(v_MainCursor,10,h_line_type); -- Newly Added

Line 729: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_dist_ccid);

725: DBMS_SQL.COLUMN_VALUE(v_MainCursor,3,h_invoice_type);
726: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_inv_dist_id);
727: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_dist_number); -- Originally line_number);
728: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_dist_type); -- Originally line_type);
729: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_dist_ccid);
730: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_dist_acct_date); -- Newly Added
731: DBMS_SQL.COLUMN_VALUE(v_MainCursor,9,h_line_number); -- Newly Added
732: DBMS_SQL.COLUMN_VALUE(v_MainCursor,10,h_line_type); -- Newly Added
733:

Line 730: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_dist_acct_date); -- Newly Added

726: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_inv_dist_id);
727: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_dist_number); -- Originally line_number);
728: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_dist_type); -- Originally line_type);
729: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_dist_ccid);
730: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_dist_acct_date); -- Newly Added
731: DBMS_SQL.COLUMN_VALUE(v_MainCursor,9,h_line_number); -- Newly Added
732: DBMS_SQL.COLUMN_VALUE(v_MainCursor,10,h_line_type); -- Newly Added
733:
734: fa_rx_util_pkg.debug('h_invoice_id: '||h_invoice_id);

Line 731: DBMS_SQL.COLUMN_VALUE(v_MainCursor,9,h_line_number); -- Newly Added

727: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_dist_number); -- Originally line_number);
728: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_dist_type); -- Originally line_type);
729: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_dist_ccid);
730: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_dist_acct_date); -- Newly Added
731: DBMS_SQL.COLUMN_VALUE(v_MainCursor,9,h_line_number); -- Newly Added
732: DBMS_SQL.COLUMN_VALUE(v_MainCursor,10,h_line_type); -- Newly Added
733:
734: fa_rx_util_pkg.debug('h_invoice_id: '||h_invoice_id);
735: fa_rx_util_pkg.debug('h_liability_ccid: '||h_liability_ccid);

Line 732: DBMS_SQL.COLUMN_VALUE(v_MainCursor,10,h_line_type); -- Newly Added

728: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_dist_type); -- Originally line_type);
729: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_dist_ccid);
730: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_dist_acct_date); -- Newly Added
731: DBMS_SQL.COLUMN_VALUE(v_MainCursor,9,h_line_number); -- Newly Added
732: DBMS_SQL.COLUMN_VALUE(v_MainCursor,10,h_line_type); -- Newly Added
733:
734: fa_rx_util_pkg.debug('h_invoice_id: '||h_invoice_id);
735: fa_rx_util_pkg.debug('h_liability_ccid: '||h_liability_ccid);
736: fa_rx_util_pkg.debug('h_invoice_type: '||h_invoice_type);

Line 896: DBMS_SQL.CLOSE_CURSOR(v_MainCursor);

892: fa_rx_util_pkg.debug('Inserted invoice_id: '||h_invoice_id||' inv_dist_id : '||h_inv_dist_id);
893:
894: End Loop;
895:
896: DBMS_SQL.CLOSE_CURSOR(v_MainCursor);
897:
898: fa_rx_util_pkg.debug('***** Close Cursor v_MainCursor *****');
899:
900: commit;