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 613: v_MainCursor :=DBMS_SQL.OPEN_CURSOR;

609: fa_rx_util_pkg.debug('Main SQL:');
610: fa_rx_util_pkg.debug(l_main_sql);
611:
612: /* Open v_MainCursor */
613: v_MainCursor :=DBMS_SQL.OPEN_CURSOR;
614: fa_rx_util_pkg.debug('***** OPEN CURSOR: v_MainCursor *****');
615: fa_rx_util_pkg.debug('v_MainCursor :'||v_MainCursor);
616:
617: /* PARSE v_MainCursor */

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

614: fa_rx_util_pkg.debug('***** OPEN CURSOR: v_MainCursor *****');
615: fa_rx_util_pkg.debug('v_MainCursor :'||v_MainCursor);
616:
617: /* PARSE v_MainCursor */
618: DBMS_SQL.PARSE (v_MainCursor,l_main_sql,DBMS_SQL.V7);
619: fa_rx_util_pkg.debug('***** PARSE: v_MainCursor *****');
620:
621: /* DEFINE COLUMN v_MainCursor */
622: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,1,h_invoice_id);

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

618: DBMS_SQL.PARSE (v_MainCursor,l_main_sql,DBMS_SQL.V7);
619: fa_rx_util_pkg.debug('***** PARSE: v_MainCursor *****');
620:
621: /* DEFINE COLUMN v_MainCursor */
622: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,1,h_invoice_id);
623: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,2,h_liability_ccid);
624: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,3,h_invoice_type,25);
625: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_inv_dist_id);
626: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_dist_number); -- Originally line_number);

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

619: fa_rx_util_pkg.debug('***** PARSE: v_MainCursor *****');
620:
621: /* DEFINE COLUMN v_MainCursor */
622: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,1,h_invoice_id);
623: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,2,h_liability_ccid);
624: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,3,h_invoice_type,25);
625: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_inv_dist_id);
626: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_dist_number); -- Originally line_number);
627: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_dist_type,25); -- Originally line_type,25);

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

620:
621: /* DEFINE COLUMN v_MainCursor */
622: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,1,h_invoice_id);
623: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,2,h_liability_ccid);
624: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,3,h_invoice_type,25);
625: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_inv_dist_id);
626: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_dist_number); -- Originally line_number);
627: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_dist_type,25); -- Originally line_type,25);
628: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_dist_ccid);

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

621: /* DEFINE COLUMN v_MainCursor */
622: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,1,h_invoice_id);
623: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,2,h_liability_ccid);
624: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,3,h_invoice_type,25);
625: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_inv_dist_id);
626: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_dist_number); -- Originally line_number);
627: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_dist_type,25); -- Originally line_type,25);
628: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_dist_ccid);
629: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_dist_acct_date); -- Newly Added

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

622: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,1,h_invoice_id);
623: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,2,h_liability_ccid);
624: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,3,h_invoice_type,25);
625: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_inv_dist_id);
626: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_dist_number); -- Originally line_number);
627: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_dist_type,25); -- Originally line_type,25);
628: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_dist_ccid);
629: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_dist_acct_date); -- Newly Added
630: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,9,h_line_number); -- Newly Added

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

623: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,2,h_liability_ccid);
624: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,3,h_invoice_type,25);
625: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_inv_dist_id);
626: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_dist_number); -- Originally line_number);
627: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_dist_type,25); -- Originally line_type,25);
628: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_dist_ccid);
629: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_dist_acct_date); -- Newly Added
630: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,9,h_line_number); -- Newly Added
631: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,10,h_line_type,25); -- Newly Added

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

624: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,3,h_invoice_type,25);
625: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_inv_dist_id);
626: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_dist_number); -- Originally line_number);
627: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_dist_type,25); -- Originally line_type,25);
628: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_dist_ccid);
629: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_dist_acct_date); -- Newly Added
630: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,9,h_line_number); -- Newly Added
631: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,10,h_line_type,25); -- Newly Added
632:

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

625: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,4,h_inv_dist_id);
626: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_dist_number); -- Originally line_number);
627: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_dist_type,25); -- Originally line_type,25);
628: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_dist_ccid);
629: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_dist_acct_date); -- Newly Added
630: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,9,h_line_number); -- Newly Added
631: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,10,h_line_type,25); -- Newly Added
632:
633: fa_rx_util_pkg.debug('***** DEFINE COLUMN: v_MainCursor *****');

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

626: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,5,h_dist_number); -- Originally line_number);
627: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_dist_type,25); -- Originally line_type,25);
628: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_dist_ccid);
629: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_dist_acct_date); -- Newly Added
630: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,9,h_line_number); -- Newly Added
631: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,10,h_line_type,25); -- Newly Added
632:
633: fa_rx_util_pkg.debug('***** DEFINE COLUMN: v_MainCursor *****');
634:

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

627: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,6,h_dist_type,25); -- Originally line_type,25);
628: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,7,h_dist_ccid);
629: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_dist_acct_date); -- Newly Added
630: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,9,h_line_number); -- Newly Added
631: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,10,h_line_type,25); -- Newly Added
632:
633: fa_rx_util_pkg.debug('***** DEFINE COLUMN: v_MainCursor *****');
634:
635: /* BIND BARIABLE v_MainCursor */

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

633: fa_rx_util_pkg.debug('***** DEFINE COLUMN: v_MainCursor *****');
634:
635: /* BIND BARIABLE v_MainCursor */
636: if p_acct_date_min is not null then
637: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_acct_date_min',p_acct_date_min);
638: end if;
639:
640: if p_acct_date_max is not null then
641: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_acct_date_max',p_acct_date_max);

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

637: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_acct_date_min',p_acct_date_min);
638: end if;
639:
640: if p_acct_date_max is not null then
641: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_acct_date_max',p_acct_date_max);
642: end if;
643:
644: if p_entered_date_min is not null then
645: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entered_date_min',p_entered_date_min);

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

641: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_acct_date_max',p_acct_date_max);
642: end if;
643:
644: if p_entered_date_min is not null then
645: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entered_date_min',p_entered_date_min);
646: end if;
647:
648: if p_entered_date_max is not null then
649: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entered_date_max',p_entered_date_max);

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

645: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entered_date_min',p_entered_date_min);
646: end if;
647:
648: if p_entered_date_max is not null then
649: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entered_date_max',p_entered_date_max);
650: end if;
651:
652: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_sort_by_alternate', h_sort_by_alternate);
653:

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

648: if p_entered_date_max is not null then
649: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entered_date_max',p_entered_date_max);
650: end if;
651:
652: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_sort_by_alternate', h_sort_by_alternate);
653:
654: /* Entered by */
655: if p_entry_person_id is not null then
656: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entry_person_id', p_entry_person_id);

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

652: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_sort_by_alternate', h_sort_by_alternate);
653:
654: /* Entered by */
655: if p_entry_person_id is not null then
656: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entry_person_id', p_entry_person_id);
657: end if;
658:
659: /*Invoice Type */
660: if p_invoice_type is not null then

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

657: end if;
658:
659: /*Invoice Type */
660: if p_invoice_type is not null then
661: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_invoice_type', p_invoice_type);
662: end if;
663:
664: /* Batch ID */
665: if p_batch_id is not null then

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

662: end if;
663:
664: /* Batch ID */
665: if p_batch_id is not null then
666: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_batch_id', p_batch_id);
667: end if;
668:
669: /* Document Sequence Id */
670: if p_doc_sequence_id is not null then

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

667: end if;
668:
669: /* Document Sequence Id */
670: if p_doc_sequence_id is not null then
671: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_doc_sequence_id', p_doc_sequence_id);
672: end if;
673:
674: /* Document Sequence value range */
675: if p_doc_sequence_value_min is not null then

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

672: end if;
673:
674: /* Document Sequence value range */
675: if p_doc_sequence_value_min is not null then
676: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_doc_sequence_value_min', p_doc_sequence_value_min);
677: end if;
678:
679: if p_doc_sequence_value_max is not null then
680: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_doc_sequence_value_max', p_doc_sequence_value_max);

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

676: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_doc_sequence_value_min', p_doc_sequence_value_min);
677: end if;
678:
679: if p_doc_sequence_value_max is not null then
680: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_doc_sequence_value_max', p_doc_sequence_value_max);
681: end if;
682:
683: /* Supplier name range */
684: if p_supplier_min is not null then

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

681: end if;
682:
683: /* Supplier name range */
684: if p_supplier_min is not null then
685: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_supplier_min', p_supplier_min);
686: end if;
687:
688: if p_supplier_max is not null then
689: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_supplier_max', p_supplier_max);

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

685: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_supplier_min', p_supplier_min);
686: end if;
687:
688: if p_supplier_max is not null then
689: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_supplier_max', p_supplier_max);
690: end if;
691:
692: /* Liability account range */
693: -- if p_liability_min is not null and p_liability_max is not null then

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

690: end if;
691:
692: /* Liability account range */
693: -- if p_liability_min is not null and p_liability_max is not null then
694: -- DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_liability_min', p_liability_min);
695: -- DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_liability_max', p_liability_max);
696: -- end if;
697:
698: /* Distribution account range */

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

691:
692: /* Liability account range */
693: -- if p_liability_min is not null and p_liability_max is not null then
694: -- DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_liability_min', p_liability_min);
695: -- DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_liability_max', p_liability_max);
696: -- end if;
697:
698: /* Distribution account range */
699: -- if p_dist_acct_min is not null and p_dist_acct_max is not null then

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

696: -- end if;
697:
698: /* Distribution account range */
699: -- if p_dist_acct_min is not null and p_dist_acct_max is not null then
700: -- DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_dist_acct_min', p_dist_acct_min);
701: -- DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_dist_acct_max', p_dist_acct_max);
702: -- end if;
703:
704: /* Invoice Currency Code */

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

697:
698: /* Distribution account range */
699: -- if p_dist_acct_min is not null and p_dist_acct_max is not null then
700: -- DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_dist_acct_min', p_dist_acct_min);
701: -- DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_dist_acct_max', p_dist_acct_max);
702: -- end if;
703:
704: /* Invoice Currency Code */
705: if p_inv_currency_code is not null then

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

702: -- end if;
703:
704: /* Invoice Currency Code */
705: if p_inv_currency_code is not null then
706: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_inv_currency_code', p_inv_currency_code);
707: end if;
708:
709: /* Distribution mount range */
710: if p_dist_amount_min is not null then

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

707: end if;
708:
709: /* Distribution mount range */
710: if p_dist_amount_min is not null then
711: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_dist_amount_min', p_dist_amount_min);
712: end if;
713:
714: if p_dist_amount_max is not null then
715: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_dist_amount_max', p_dist_amount_max);

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

711: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_dist_amount_min', p_dist_amount_min);
712: end if;
713:
714: if p_dist_amount_max is not null then
715: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_dist_amount_max', p_dist_amount_max);
716: end if;
717:
718: /* Entered date range */
719: if p_entered_date_min is not null then

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

716: end if;
717:
718: /* Entered date range */
719: if p_entered_date_min is not null then
720: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entered_date_min', p_entered_date_min);
721: end if;
722:
723: if p_entered_date_max is not null then
724: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entered_date_max', p_entered_date_max);

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

720: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entered_date_min', p_entered_date_min);
721: end if;
722:
723: if p_entered_date_max is not null then
724: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_entered_date_max', p_entered_date_max);
725: end if;
726:
727: /* MOAC Change - bind p_reporting_entity_id */
728: -- bug: 9914839 Bind variable set for reporting Level : Legal Entity as well

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

726:
727: /* MOAC Change - bind p_reporting_entity_id */
728: -- bug: 9914839 Bind variable set for reporting Level : Legal Entity as well
729: if p_reporting_level = '3000' or p_reporting_level = '2000' then
730: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_reporting_entity_id', h_reporting_entity_id);
731: fa_rx_util_pkg.debug('h_reporting_entity_id :'||h_reporting_entity_id);
732: end if;
733:
734: fa_rx_util_pkg.debug('***** BIND VARIABLE: v_MainCursor *****');

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

733:
734: fa_rx_util_pkg.debug('***** BIND VARIABLE: v_MainCursor *****');
735:
736:
737: v_MainReturn := DBMS_SQL.EXECUTE(v_MainCursor);
738: fa_rx_util_pkg.debug('***** EXECUTE: v_MainCursor *****');
739: fa_rx_util_pkg.debug('v_MainReturn :'||v_MainReturn);
740:
741: /* Loop and Fetch v_MainCursor */

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

740:
741: /* Loop and Fetch v_MainCursor */
742: Loop
743:
744: v_MainFetch := DBMS_SQL.FETCH_ROWS(v_MainCursor);
745: fa_rx_util_pkg.debug('***** FETCH ROWS: v_MainCursor *****');
746: fa_rx_util_pkg.debug('v_MainFetch :'||v_MainFetch);
747:
748: If v_MainFetch =0 then

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

748: If v_MainFetch =0 then
749: Exit;
750: end if;
751:
752: DBMS_SQL.COLUMN_VALUE(v_MainCursor,1,h_invoice_id);
753: DBMS_SQL.COLUMN_VALUE(v_MainCursor,2,h_liability_ccid);
754: DBMS_SQL.COLUMN_VALUE(v_MainCursor,3,h_invoice_type);
755: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_inv_dist_id);
756: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_dist_number); -- Originally line_number);

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

749: Exit;
750: end if;
751:
752: DBMS_SQL.COLUMN_VALUE(v_MainCursor,1,h_invoice_id);
753: DBMS_SQL.COLUMN_VALUE(v_MainCursor,2,h_liability_ccid);
754: DBMS_SQL.COLUMN_VALUE(v_MainCursor,3,h_invoice_type);
755: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_inv_dist_id);
756: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_dist_number); -- Originally line_number);
757: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_dist_type); -- Originally line_type);

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

750: end if;
751:
752: DBMS_SQL.COLUMN_VALUE(v_MainCursor,1,h_invoice_id);
753: DBMS_SQL.COLUMN_VALUE(v_MainCursor,2,h_liability_ccid);
754: DBMS_SQL.COLUMN_VALUE(v_MainCursor,3,h_invoice_type);
755: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_inv_dist_id);
756: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_dist_number); -- Originally line_number);
757: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_dist_type); -- Originally line_type);
758: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_dist_ccid);

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

751:
752: DBMS_SQL.COLUMN_VALUE(v_MainCursor,1,h_invoice_id);
753: DBMS_SQL.COLUMN_VALUE(v_MainCursor,2,h_liability_ccid);
754: DBMS_SQL.COLUMN_VALUE(v_MainCursor,3,h_invoice_type);
755: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_inv_dist_id);
756: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_dist_number); -- Originally line_number);
757: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_dist_type); -- Originally line_type);
758: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_dist_ccid);
759: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_dist_acct_date); -- Newly Added

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

752: DBMS_SQL.COLUMN_VALUE(v_MainCursor,1,h_invoice_id);
753: DBMS_SQL.COLUMN_VALUE(v_MainCursor,2,h_liability_ccid);
754: DBMS_SQL.COLUMN_VALUE(v_MainCursor,3,h_invoice_type);
755: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_inv_dist_id);
756: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_dist_number); -- Originally line_number);
757: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_dist_type); -- Originally line_type);
758: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_dist_ccid);
759: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_dist_acct_date); -- Newly Added
760: DBMS_SQL.COLUMN_VALUE(v_MainCursor,9,h_line_number); -- Newly Added

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

753: DBMS_SQL.COLUMN_VALUE(v_MainCursor,2,h_liability_ccid);
754: DBMS_SQL.COLUMN_VALUE(v_MainCursor,3,h_invoice_type);
755: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_inv_dist_id);
756: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_dist_number); -- Originally line_number);
757: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_dist_type); -- Originally line_type);
758: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_dist_ccid);
759: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_dist_acct_date); -- Newly Added
760: DBMS_SQL.COLUMN_VALUE(v_MainCursor,9,h_line_number); -- Newly Added
761: DBMS_SQL.COLUMN_VALUE(v_MainCursor,10,h_line_type); -- Newly Added

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

754: DBMS_SQL.COLUMN_VALUE(v_MainCursor,3,h_invoice_type);
755: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_inv_dist_id);
756: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_dist_number); -- Originally line_number);
757: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_dist_type); -- Originally line_type);
758: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_dist_ccid);
759: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_dist_acct_date); -- Newly Added
760: DBMS_SQL.COLUMN_VALUE(v_MainCursor,9,h_line_number); -- Newly Added
761: DBMS_SQL.COLUMN_VALUE(v_MainCursor,10,h_line_type); -- Newly Added
762:

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

755: DBMS_SQL.COLUMN_VALUE(v_MainCursor,4,h_inv_dist_id);
756: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_dist_number); -- Originally line_number);
757: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_dist_type); -- Originally line_type);
758: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_dist_ccid);
759: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_dist_acct_date); -- Newly Added
760: DBMS_SQL.COLUMN_VALUE(v_MainCursor,9,h_line_number); -- Newly Added
761: DBMS_SQL.COLUMN_VALUE(v_MainCursor,10,h_line_type); -- Newly Added
762:
763: fa_rx_util_pkg.debug('h_invoice_id: '||h_invoice_id);

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

756: DBMS_SQL.COLUMN_VALUE(v_MainCursor,5,h_dist_number); -- Originally line_number);
757: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_dist_type); -- Originally line_type);
758: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_dist_ccid);
759: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_dist_acct_date); -- Newly Added
760: DBMS_SQL.COLUMN_VALUE(v_MainCursor,9,h_line_number); -- Newly Added
761: DBMS_SQL.COLUMN_VALUE(v_MainCursor,10,h_line_type); -- Newly Added
762:
763: fa_rx_util_pkg.debug('h_invoice_id: '||h_invoice_id);
764: fa_rx_util_pkg.debug('h_liability_ccid: '||h_liability_ccid);

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

757: DBMS_SQL.COLUMN_VALUE(v_MainCursor,6,h_dist_type); -- Originally line_type);
758: DBMS_SQL.COLUMN_VALUE(v_MainCursor,7,h_dist_ccid);
759: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_dist_acct_date); -- Newly Added
760: DBMS_SQL.COLUMN_VALUE(v_MainCursor,9,h_line_number); -- Newly Added
761: DBMS_SQL.COLUMN_VALUE(v_MainCursor,10,h_line_type); -- Newly Added
762:
763: fa_rx_util_pkg.debug('h_invoice_id: '||h_invoice_id);
764: fa_rx_util_pkg.debug('h_liability_ccid: '||h_liability_ccid);
765: fa_rx_util_pkg.debug('h_invoice_type: '||h_invoice_type);

Line 925: DBMS_SQL.CLOSE_CURSOR(v_MainCursor);

921: fa_rx_util_pkg.debug('Inserted invoice_id: '||h_invoice_id||' inv_dist_id : '||h_inv_dist_id);
922:
923: End Loop;
924:
925: DBMS_SQL.CLOSE_CURSOR(v_MainCursor);
926:
927: fa_rx_util_pkg.debug('***** Close Cursor v_MainCursor *****');
928:
929: commit;