704: ------------------------------------------------
705: BEGIN
706: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
707:
708: p_insert_ps_c := dbms_sql.open_cursor;
709: dbms_sql.parse( p_insert_ps_c, l_insert_ps_sql,
710: dbms_sql.v7 );
711:
712: p_select_c := dbms_sql.open_cursor;
705: BEGIN
706: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
707:
708: p_insert_ps_c := dbms_sql.open_cursor;
709: dbms_sql.parse( p_insert_ps_c, l_insert_ps_sql,
710: dbms_sql.v7 );
711:
712: p_select_c := dbms_sql.open_cursor;
713: dbms_sql.parse( p_select_c, l_select_sql,
706: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
707:
708: p_insert_ps_c := dbms_sql.open_cursor;
709: dbms_sql.parse( p_insert_ps_c, l_insert_ps_sql,
710: dbms_sql.v7 );
711:
712: p_select_c := dbms_sql.open_cursor;
713: dbms_sql.parse( p_select_c, l_select_sql,
714: dbms_sql.v7 );
708: p_insert_ps_c := dbms_sql.open_cursor;
709: dbms_sql.parse( p_insert_ps_c, l_insert_ps_sql,
710: dbms_sql.v7 );
711:
712: p_select_c := dbms_sql.open_cursor;
713: dbms_sql.parse( p_select_c, l_select_sql,
714: dbms_sql.v7 );
715:
716: EXCEPTION
709: dbms_sql.parse( p_insert_ps_c, l_insert_ps_sql,
710: dbms_sql.v7 );
711:
712: p_select_c := dbms_sql.open_cursor;
713: dbms_sql.parse( p_select_c, l_select_sql,
714: dbms_sql.v7 );
715:
716: EXCEPTION
717: WHEN OTHERS THEN
710: dbms_sql.v7 );
711:
712: p_select_c := dbms_sql.open_cursor;
713: dbms_sql.parse( p_select_c, l_select_sql,
714: dbms_sql.v7 );
715:
716: EXCEPTION
717: WHEN OTHERS THEN
718: debug( 'EXCEPTION: Error parsing stmts', MSG_LEVEL_BASIC );
739: BEGIN
740:
741: print_fcn_label2( 'arp_maintain_ps2.define_ips_select_columns()+' );
742:
743: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );
744: dbms_sql.define_column( p_select_c, 2, p_select_rec.total_line_amount );
745: dbms_sql.define_column( p_select_c, 3, p_select_rec.total_tax_amount );
746: dbms_sql.define_column( p_select_c, 4, p_select_rec.total_freight_amount );
747: dbms_sql.define_column( p_select_c, 5, p_select_rec.term_id );
740:
741: print_fcn_label2( 'arp_maintain_ps2.define_ips_select_columns()+' );
742:
743: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );
744: dbms_sql.define_column( p_select_c, 2, p_select_rec.total_line_amount );
745: dbms_sql.define_column( p_select_c, 3, p_select_rec.total_tax_amount );
746: dbms_sql.define_column( p_select_c, 4, p_select_rec.total_freight_amount );
747: dbms_sql.define_column( p_select_c, 5, p_select_rec.term_id );
748: dbms_sql.define_column( p_select_c, 6, p_select_rec.term_sequence_num );
741: print_fcn_label2( 'arp_maintain_ps2.define_ips_select_columns()+' );
742:
743: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );
744: dbms_sql.define_column( p_select_c, 2, p_select_rec.total_line_amount );
745: dbms_sql.define_column( p_select_c, 3, p_select_rec.total_tax_amount );
746: dbms_sql.define_column( p_select_c, 4, p_select_rec.total_freight_amount );
747: dbms_sql.define_column( p_select_c, 5, p_select_rec.term_id );
748: dbms_sql.define_column( p_select_c, 6, p_select_rec.term_sequence_num );
749: dbms_sql.define_column( p_select_c, 7, p_select_rec.due_date );
742:
743: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );
744: dbms_sql.define_column( p_select_c, 2, p_select_rec.total_line_amount );
745: dbms_sql.define_column( p_select_c, 3, p_select_rec.total_tax_amount );
746: dbms_sql.define_column( p_select_c, 4, p_select_rec.total_freight_amount );
747: dbms_sql.define_column( p_select_c, 5, p_select_rec.term_id );
748: dbms_sql.define_column( p_select_c, 6, p_select_rec.term_sequence_num );
749: dbms_sql.define_column( p_select_c, 7, p_select_rec.due_date );
750: dbms_sql.define_column( p_select_c, 8, p_select_rec.customer_id );
743: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );
744: dbms_sql.define_column( p_select_c, 2, p_select_rec.total_line_amount );
745: dbms_sql.define_column( p_select_c, 3, p_select_rec.total_tax_amount );
746: dbms_sql.define_column( p_select_c, 4, p_select_rec.total_freight_amount );
747: dbms_sql.define_column( p_select_c, 5, p_select_rec.term_id );
748: dbms_sql.define_column( p_select_c, 6, p_select_rec.term_sequence_num );
749: dbms_sql.define_column( p_select_c, 7, p_select_rec.due_date );
750: dbms_sql.define_column( p_select_c, 8, p_select_rec.customer_id );
751: dbms_sql.define_column( p_select_c, 9, p_select_rec.trx_type, 20 );
744: dbms_sql.define_column( p_select_c, 2, p_select_rec.total_line_amount );
745: dbms_sql.define_column( p_select_c, 3, p_select_rec.total_tax_amount );
746: dbms_sql.define_column( p_select_c, 4, p_select_rec.total_freight_amount );
747: dbms_sql.define_column( p_select_c, 5, p_select_rec.term_id );
748: dbms_sql.define_column( p_select_c, 6, p_select_rec.term_sequence_num );
749: dbms_sql.define_column( p_select_c, 7, p_select_rec.due_date );
750: dbms_sql.define_column( p_select_c, 8, p_select_rec.customer_id );
751: dbms_sql.define_column( p_select_c, 9, p_select_rec.trx_type, 20 );
752: dbms_sql.define_column( p_select_c, 10, p_select_rec.site_use_id );
745: dbms_sql.define_column( p_select_c, 3, p_select_rec.total_tax_amount );
746: dbms_sql.define_column( p_select_c, 4, p_select_rec.total_freight_amount );
747: dbms_sql.define_column( p_select_c, 5, p_select_rec.term_id );
748: dbms_sql.define_column( p_select_c, 6, p_select_rec.term_sequence_num );
749: dbms_sql.define_column( p_select_c, 7, p_select_rec.due_date );
750: dbms_sql.define_column( p_select_c, 8, p_select_rec.customer_id );
751: dbms_sql.define_column( p_select_c, 9, p_select_rec.trx_type, 20 );
752: dbms_sql.define_column( p_select_c, 10, p_select_rec.site_use_id );
753: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
746: dbms_sql.define_column( p_select_c, 4, p_select_rec.total_freight_amount );
747: dbms_sql.define_column( p_select_c, 5, p_select_rec.term_id );
748: dbms_sql.define_column( p_select_c, 6, p_select_rec.term_sequence_num );
749: dbms_sql.define_column( p_select_c, 7, p_select_rec.due_date );
750: dbms_sql.define_column( p_select_c, 8, p_select_rec.customer_id );
751: dbms_sql.define_column( p_select_c, 9, p_select_rec.trx_type, 20 );
752: dbms_sql.define_column( p_select_c, 10, p_select_rec.site_use_id );
753: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
754: dbms_sql.define_column( p_select_c, 12,
747: dbms_sql.define_column( p_select_c, 5, p_select_rec.term_id );
748: dbms_sql.define_column( p_select_c, 6, p_select_rec.term_sequence_num );
749: dbms_sql.define_column( p_select_c, 7, p_select_rec.due_date );
750: dbms_sql.define_column( p_select_c, 8, p_select_rec.customer_id );
751: dbms_sql.define_column( p_select_c, 9, p_select_rec.trx_type, 20 );
752: dbms_sql.define_column( p_select_c, 10, p_select_rec.site_use_id );
753: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
754: dbms_sql.define_column( p_select_c, 12,
755: p_select_rec.currency_code, 15 );
748: dbms_sql.define_column( p_select_c, 6, p_select_rec.term_sequence_num );
749: dbms_sql.define_column( p_select_c, 7, p_select_rec.due_date );
750: dbms_sql.define_column( p_select_c, 8, p_select_rec.customer_id );
751: dbms_sql.define_column( p_select_c, 9, p_select_rec.trx_type, 20 );
752: dbms_sql.define_column( p_select_c, 10, p_select_rec.site_use_id );
753: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
754: dbms_sql.define_column( p_select_c, 12,
755: p_select_rec.currency_code, 15 );
756: dbms_sql.define_column( p_select_c, 13,
749: dbms_sql.define_column( p_select_c, 7, p_select_rec.due_date );
750: dbms_sql.define_column( p_select_c, 8, p_select_rec.customer_id );
751: dbms_sql.define_column( p_select_c, 9, p_select_rec.trx_type, 20 );
752: dbms_sql.define_column( p_select_c, 10, p_select_rec.site_use_id );
753: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
754: dbms_sql.define_column( p_select_c, 12,
755: p_select_rec.currency_code, 15 );
756: dbms_sql.define_column( p_select_c, 13,
757: p_select_rec.exchange_rate_type, 30 );
750: dbms_sql.define_column( p_select_c, 8, p_select_rec.customer_id );
751: dbms_sql.define_column( p_select_c, 9, p_select_rec.trx_type, 20 );
752: dbms_sql.define_column( p_select_c, 10, p_select_rec.site_use_id );
753: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
754: dbms_sql.define_column( p_select_c, 12,
755: p_select_rec.currency_code, 15 );
756: dbms_sql.define_column( p_select_c, 13,
757: p_select_rec.exchange_rate_type, 30 );
758: dbms_sql.define_column( p_select_c, 14, p_select_rec.exchange_rate );
752: dbms_sql.define_column( p_select_c, 10, p_select_rec.site_use_id );
753: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
754: dbms_sql.define_column( p_select_c, 12,
755: p_select_rec.currency_code, 15 );
756: dbms_sql.define_column( p_select_c, 13,
757: p_select_rec.exchange_rate_type, 30 );
758: dbms_sql.define_column( p_select_c, 14, p_select_rec.exchange_rate );
759: dbms_sql.define_column( p_select_c, 15, p_select_rec.exchange_date );
760: dbms_sql.define_column( p_select_c, 16, p_select_rec.trx_number, 20 );
754: dbms_sql.define_column( p_select_c, 12,
755: p_select_rec.currency_code, 15 );
756: dbms_sql.define_column( p_select_c, 13,
757: p_select_rec.exchange_rate_type, 30 );
758: dbms_sql.define_column( p_select_c, 14, p_select_rec.exchange_rate );
759: dbms_sql.define_column( p_select_c, 15, p_select_rec.exchange_date );
760: dbms_sql.define_column( p_select_c, 16, p_select_rec.trx_number, 20 );
761: dbms_sql.define_column( p_select_c, 17, p_select_rec.trx_date );
762: dbms_sql.define_column( p_select_c, 18, p_select_rec.percent );
755: p_select_rec.currency_code, 15 );
756: dbms_sql.define_column( p_select_c, 13,
757: p_select_rec.exchange_rate_type, 30 );
758: dbms_sql.define_column( p_select_c, 14, p_select_rec.exchange_rate );
759: dbms_sql.define_column( p_select_c, 15, p_select_rec.exchange_date );
760: dbms_sql.define_column( p_select_c, 16, p_select_rec.trx_number, 20 );
761: dbms_sql.define_column( p_select_c, 17, p_select_rec.trx_date );
762: dbms_sql.define_column( p_select_c, 18, p_select_rec.percent );
763: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
756: dbms_sql.define_column( p_select_c, 13,
757: p_select_rec.exchange_rate_type, 30 );
758: dbms_sql.define_column( p_select_c, 14, p_select_rec.exchange_rate );
759: dbms_sql.define_column( p_select_c, 15, p_select_rec.exchange_date );
760: dbms_sql.define_column( p_select_c, 16, p_select_rec.trx_number, 20 );
761: dbms_sql.define_column( p_select_c, 17, p_select_rec.trx_date );
762: dbms_sql.define_column( p_select_c, 18, p_select_rec.percent );
763: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
764: dbms_sql.define_column( p_select_c, 20,
757: p_select_rec.exchange_rate_type, 30 );
758: dbms_sql.define_column( p_select_c, 14, p_select_rec.exchange_rate );
759: dbms_sql.define_column( p_select_c, 15, p_select_rec.exchange_date );
760: dbms_sql.define_column( p_select_c, 16, p_select_rec.trx_number, 20 );
761: dbms_sql.define_column( p_select_c, 17, p_select_rec.trx_date );
762: dbms_sql.define_column( p_select_c, 18, p_select_rec.percent );
763: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
764: dbms_sql.define_column( p_select_c, 20,
765: p_select_rec.first_installment_code, 12 );
758: dbms_sql.define_column( p_select_c, 14, p_select_rec.exchange_rate );
759: dbms_sql.define_column( p_select_c, 15, p_select_rec.exchange_date );
760: dbms_sql.define_column( p_select_c, 16, p_select_rec.trx_number, 20 );
761: dbms_sql.define_column( p_select_c, 17, p_select_rec.trx_date );
762: dbms_sql.define_column( p_select_c, 18, p_select_rec.percent );
763: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
764: dbms_sql.define_column( p_select_c, 20,
765: p_select_rec.first_installment_code, 12 );
766: dbms_sql.define_column( p_select_c, 21,
759: dbms_sql.define_column( p_select_c, 15, p_select_rec.exchange_date );
760: dbms_sql.define_column( p_select_c, 16, p_select_rec.trx_number, 20 );
761: dbms_sql.define_column( p_select_c, 17, p_select_rec.trx_date );
762: dbms_sql.define_column( p_select_c, 18, p_select_rec.percent );
763: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
764: dbms_sql.define_column( p_select_c, 20,
765: p_select_rec.first_installment_code, 12 );
766: dbms_sql.define_column( p_select_c, 21,
767: p_select_rec.min_acc_unit );
760: dbms_sql.define_column( p_select_c, 16, p_select_rec.trx_number, 20 );
761: dbms_sql.define_column( p_select_c, 17, p_select_rec.trx_date );
762: dbms_sql.define_column( p_select_c, 18, p_select_rec.percent );
763: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
764: dbms_sql.define_column( p_select_c, 20,
765: p_select_rec.first_installment_code, 12 );
766: dbms_sql.define_column( p_select_c, 21,
767: p_select_rec.min_acc_unit );
768: dbms_sql.define_column( p_select_c, 22, p_select_rec.gl_date );
762: dbms_sql.define_column( p_select_c, 18, p_select_rec.percent );
763: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
764: dbms_sql.define_column( p_select_c, 20,
765: p_select_rec.first_installment_code, 12 );
766: dbms_sql.define_column( p_select_c, 21,
767: p_select_rec.min_acc_unit );
768: dbms_sql.define_column( p_select_c, 22, p_select_rec.gl_date );
769:
770: dbms_sql.define_column( p_select_c, 23, p_select_rec.rec_acctd_amount );
764: dbms_sql.define_column( p_select_c, 20,
765: p_select_rec.first_installment_code, 12 );
766: dbms_sql.define_column( p_select_c, 21,
767: p_select_rec.min_acc_unit );
768: dbms_sql.define_column( p_select_c, 22, p_select_rec.gl_date );
769:
770: dbms_sql.define_column( p_select_c, 23, p_select_rec.rec_acctd_amount );
771: dbms_sql.define_column( p_select_c, 24,
772: p_select_rec.total_charges_amount );
766: dbms_sql.define_column( p_select_c, 21,
767: p_select_rec.min_acc_unit );
768: dbms_sql.define_column( p_select_c, 22, p_select_rec.gl_date );
769:
770: dbms_sql.define_column( p_select_c, 23, p_select_rec.rec_acctd_amount );
771: dbms_sql.define_column( p_select_c, 24,
772: p_select_rec.total_charges_amount );
773: dbms_sql.define_column( p_select_c, 25,p_select_rec.reversed_cash_receipt_id); /*Bug3328690 */
774:
767: p_select_rec.min_acc_unit );
768: dbms_sql.define_column( p_select_c, 22, p_select_rec.gl_date );
769:
770: dbms_sql.define_column( p_select_c, 23, p_select_rec.rec_acctd_amount );
771: dbms_sql.define_column( p_select_c, 24,
772: p_select_rec.total_charges_amount );
773: dbms_sql.define_column( p_select_c, 25,p_select_rec.reversed_cash_receipt_id); /*Bug3328690 */
774:
775:
769:
770: dbms_sql.define_column( p_select_c, 23, p_select_rec.rec_acctd_amount );
771: dbms_sql.define_column( p_select_c, 24,
772: p_select_rec.total_charges_amount );
773: dbms_sql.define_column( p_select_c, 25,p_select_rec.reversed_cash_receipt_id); /*Bug3328690 */
774:
775:
776: print_fcn_label2( 'arp_maintain_ps2.define_ips_select_columns()-' );
777:
789: /* Bug 460927 - Modified IN to IN OUT in the above line - Oracle 8 */
790: BEGIN
791: print_fcn_label2( 'arp_maintain_ps2.get_ips_column_values()+' );
792:
793: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
794: dbms_sql.column_value( p_select_c, 2, p_select_rec.total_line_amount );
795: dbms_sql.column_value( p_select_c, 3, p_select_rec.total_tax_amount );
796: dbms_sql.column_value( p_select_c, 4, p_select_rec.total_freight_amount );
797: dbms_sql.column_value( p_select_c, 5, p_select_rec.term_id );
790: BEGIN
791: print_fcn_label2( 'arp_maintain_ps2.get_ips_column_values()+' );
792:
793: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
794: dbms_sql.column_value( p_select_c, 2, p_select_rec.total_line_amount );
795: dbms_sql.column_value( p_select_c, 3, p_select_rec.total_tax_amount );
796: dbms_sql.column_value( p_select_c, 4, p_select_rec.total_freight_amount );
797: dbms_sql.column_value( p_select_c, 5, p_select_rec.term_id );
798: dbms_sql.column_value( p_select_c, 6, p_select_rec.term_sequence_num );
791: print_fcn_label2( 'arp_maintain_ps2.get_ips_column_values()+' );
792:
793: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
794: dbms_sql.column_value( p_select_c, 2, p_select_rec.total_line_amount );
795: dbms_sql.column_value( p_select_c, 3, p_select_rec.total_tax_amount );
796: dbms_sql.column_value( p_select_c, 4, p_select_rec.total_freight_amount );
797: dbms_sql.column_value( p_select_c, 5, p_select_rec.term_id );
798: dbms_sql.column_value( p_select_c, 6, p_select_rec.term_sequence_num );
799: dbms_sql.column_value( p_select_c, 7, p_select_rec.due_date );
792:
793: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
794: dbms_sql.column_value( p_select_c, 2, p_select_rec.total_line_amount );
795: dbms_sql.column_value( p_select_c, 3, p_select_rec.total_tax_amount );
796: dbms_sql.column_value( p_select_c, 4, p_select_rec.total_freight_amount );
797: dbms_sql.column_value( p_select_c, 5, p_select_rec.term_id );
798: dbms_sql.column_value( p_select_c, 6, p_select_rec.term_sequence_num );
799: dbms_sql.column_value( p_select_c, 7, p_select_rec.due_date );
800: dbms_sql.column_value( p_select_c, 8, p_select_rec.customer_id );
793: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
794: dbms_sql.column_value( p_select_c, 2, p_select_rec.total_line_amount );
795: dbms_sql.column_value( p_select_c, 3, p_select_rec.total_tax_amount );
796: dbms_sql.column_value( p_select_c, 4, p_select_rec.total_freight_amount );
797: dbms_sql.column_value( p_select_c, 5, p_select_rec.term_id );
798: dbms_sql.column_value( p_select_c, 6, p_select_rec.term_sequence_num );
799: dbms_sql.column_value( p_select_c, 7, p_select_rec.due_date );
800: dbms_sql.column_value( p_select_c, 8, p_select_rec.customer_id );
801: dbms_sql.column_value( p_select_c, 9, p_select_rec.trx_type );
794: dbms_sql.column_value( p_select_c, 2, p_select_rec.total_line_amount );
795: dbms_sql.column_value( p_select_c, 3, p_select_rec.total_tax_amount );
796: dbms_sql.column_value( p_select_c, 4, p_select_rec.total_freight_amount );
797: dbms_sql.column_value( p_select_c, 5, p_select_rec.term_id );
798: dbms_sql.column_value( p_select_c, 6, p_select_rec.term_sequence_num );
799: dbms_sql.column_value( p_select_c, 7, p_select_rec.due_date );
800: dbms_sql.column_value( p_select_c, 8, p_select_rec.customer_id );
801: dbms_sql.column_value( p_select_c, 9, p_select_rec.trx_type );
802: dbms_sql.column_value( p_select_c, 10, p_select_rec.site_use_id );
795: dbms_sql.column_value( p_select_c, 3, p_select_rec.total_tax_amount );
796: dbms_sql.column_value( p_select_c, 4, p_select_rec.total_freight_amount );
797: dbms_sql.column_value( p_select_c, 5, p_select_rec.term_id );
798: dbms_sql.column_value( p_select_c, 6, p_select_rec.term_sequence_num );
799: dbms_sql.column_value( p_select_c, 7, p_select_rec.due_date );
800: dbms_sql.column_value( p_select_c, 8, p_select_rec.customer_id );
801: dbms_sql.column_value( p_select_c, 9, p_select_rec.trx_type );
802: dbms_sql.column_value( p_select_c, 10, p_select_rec.site_use_id );
803: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
796: dbms_sql.column_value( p_select_c, 4, p_select_rec.total_freight_amount );
797: dbms_sql.column_value( p_select_c, 5, p_select_rec.term_id );
798: dbms_sql.column_value( p_select_c, 6, p_select_rec.term_sequence_num );
799: dbms_sql.column_value( p_select_c, 7, p_select_rec.due_date );
800: dbms_sql.column_value( p_select_c, 8, p_select_rec.customer_id );
801: dbms_sql.column_value( p_select_c, 9, p_select_rec.trx_type );
802: dbms_sql.column_value( p_select_c, 10, p_select_rec.site_use_id );
803: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
804: dbms_sql.column_value( p_select_c, 12,
797: dbms_sql.column_value( p_select_c, 5, p_select_rec.term_id );
798: dbms_sql.column_value( p_select_c, 6, p_select_rec.term_sequence_num );
799: dbms_sql.column_value( p_select_c, 7, p_select_rec.due_date );
800: dbms_sql.column_value( p_select_c, 8, p_select_rec.customer_id );
801: dbms_sql.column_value( p_select_c, 9, p_select_rec.trx_type );
802: dbms_sql.column_value( p_select_c, 10, p_select_rec.site_use_id );
803: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
804: dbms_sql.column_value( p_select_c, 12,
805: p_select_rec.currency_code );
798: dbms_sql.column_value( p_select_c, 6, p_select_rec.term_sequence_num );
799: dbms_sql.column_value( p_select_c, 7, p_select_rec.due_date );
800: dbms_sql.column_value( p_select_c, 8, p_select_rec.customer_id );
801: dbms_sql.column_value( p_select_c, 9, p_select_rec.trx_type );
802: dbms_sql.column_value( p_select_c, 10, p_select_rec.site_use_id );
803: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
804: dbms_sql.column_value( p_select_c, 12,
805: p_select_rec.currency_code );
806: dbms_sql.column_value( p_select_c, 13,
799: dbms_sql.column_value( p_select_c, 7, p_select_rec.due_date );
800: dbms_sql.column_value( p_select_c, 8, p_select_rec.customer_id );
801: dbms_sql.column_value( p_select_c, 9, p_select_rec.trx_type );
802: dbms_sql.column_value( p_select_c, 10, p_select_rec.site_use_id );
803: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
804: dbms_sql.column_value( p_select_c, 12,
805: p_select_rec.currency_code );
806: dbms_sql.column_value( p_select_c, 13,
807: p_select_rec.exchange_rate_type );
800: dbms_sql.column_value( p_select_c, 8, p_select_rec.customer_id );
801: dbms_sql.column_value( p_select_c, 9, p_select_rec.trx_type );
802: dbms_sql.column_value( p_select_c, 10, p_select_rec.site_use_id );
803: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
804: dbms_sql.column_value( p_select_c, 12,
805: p_select_rec.currency_code );
806: dbms_sql.column_value( p_select_c, 13,
807: p_select_rec.exchange_rate_type );
808: dbms_sql.column_value( p_select_c, 14, p_select_rec.exchange_rate );
802: dbms_sql.column_value( p_select_c, 10, p_select_rec.site_use_id );
803: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
804: dbms_sql.column_value( p_select_c, 12,
805: p_select_rec.currency_code );
806: dbms_sql.column_value( p_select_c, 13,
807: p_select_rec.exchange_rate_type );
808: dbms_sql.column_value( p_select_c, 14, p_select_rec.exchange_rate );
809: dbms_sql.column_value( p_select_c, 15, p_select_rec.exchange_date );
810: dbms_sql.column_value( p_select_c, 16, p_select_rec.trx_number );
804: dbms_sql.column_value( p_select_c, 12,
805: p_select_rec.currency_code );
806: dbms_sql.column_value( p_select_c, 13,
807: p_select_rec.exchange_rate_type );
808: dbms_sql.column_value( p_select_c, 14, p_select_rec.exchange_rate );
809: dbms_sql.column_value( p_select_c, 15, p_select_rec.exchange_date );
810: dbms_sql.column_value( p_select_c, 16, p_select_rec.trx_number );
811: dbms_sql.column_value( p_select_c, 17, p_select_rec.trx_date );
812: dbms_sql.column_value( p_select_c, 18, p_select_rec.percent );
805: p_select_rec.currency_code );
806: dbms_sql.column_value( p_select_c, 13,
807: p_select_rec.exchange_rate_type );
808: dbms_sql.column_value( p_select_c, 14, p_select_rec.exchange_rate );
809: dbms_sql.column_value( p_select_c, 15, p_select_rec.exchange_date );
810: dbms_sql.column_value( p_select_c, 16, p_select_rec.trx_number );
811: dbms_sql.column_value( p_select_c, 17, p_select_rec.trx_date );
812: dbms_sql.column_value( p_select_c, 18, p_select_rec.percent );
813: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
806: dbms_sql.column_value( p_select_c, 13,
807: p_select_rec.exchange_rate_type );
808: dbms_sql.column_value( p_select_c, 14, p_select_rec.exchange_rate );
809: dbms_sql.column_value( p_select_c, 15, p_select_rec.exchange_date );
810: dbms_sql.column_value( p_select_c, 16, p_select_rec.trx_number );
811: dbms_sql.column_value( p_select_c, 17, p_select_rec.trx_date );
812: dbms_sql.column_value( p_select_c, 18, p_select_rec.percent );
813: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
814: dbms_sql.column_value( p_select_c, 20,
807: p_select_rec.exchange_rate_type );
808: dbms_sql.column_value( p_select_c, 14, p_select_rec.exchange_rate );
809: dbms_sql.column_value( p_select_c, 15, p_select_rec.exchange_date );
810: dbms_sql.column_value( p_select_c, 16, p_select_rec.trx_number );
811: dbms_sql.column_value( p_select_c, 17, p_select_rec.trx_date );
812: dbms_sql.column_value( p_select_c, 18, p_select_rec.percent );
813: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
814: dbms_sql.column_value( p_select_c, 20,
815: p_select_rec.first_installment_code );
808: dbms_sql.column_value( p_select_c, 14, p_select_rec.exchange_rate );
809: dbms_sql.column_value( p_select_c, 15, p_select_rec.exchange_date );
810: dbms_sql.column_value( p_select_c, 16, p_select_rec.trx_number );
811: dbms_sql.column_value( p_select_c, 17, p_select_rec.trx_date );
812: dbms_sql.column_value( p_select_c, 18, p_select_rec.percent );
813: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
814: dbms_sql.column_value( p_select_c, 20,
815: p_select_rec.first_installment_code );
816: dbms_sql.column_value( p_select_c, 21,
809: dbms_sql.column_value( p_select_c, 15, p_select_rec.exchange_date );
810: dbms_sql.column_value( p_select_c, 16, p_select_rec.trx_number );
811: dbms_sql.column_value( p_select_c, 17, p_select_rec.trx_date );
812: dbms_sql.column_value( p_select_c, 18, p_select_rec.percent );
813: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
814: dbms_sql.column_value( p_select_c, 20,
815: p_select_rec.first_installment_code );
816: dbms_sql.column_value( p_select_c, 21,
817: p_select_rec.min_acc_unit );
810: dbms_sql.column_value( p_select_c, 16, p_select_rec.trx_number );
811: dbms_sql.column_value( p_select_c, 17, p_select_rec.trx_date );
812: dbms_sql.column_value( p_select_c, 18, p_select_rec.percent );
813: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
814: dbms_sql.column_value( p_select_c, 20,
815: p_select_rec.first_installment_code );
816: dbms_sql.column_value( p_select_c, 21,
817: p_select_rec.min_acc_unit );
818: dbms_sql.column_value( p_select_c, 22, p_select_rec.gl_date );
812: dbms_sql.column_value( p_select_c, 18, p_select_rec.percent );
813: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
814: dbms_sql.column_value( p_select_c, 20,
815: p_select_rec.first_installment_code );
816: dbms_sql.column_value( p_select_c, 21,
817: p_select_rec.min_acc_unit );
818: dbms_sql.column_value( p_select_c, 22, p_select_rec.gl_date );
819:
820: dbms_sql.column_value( p_select_c, 23, p_select_rec.rec_acctd_amount );
814: dbms_sql.column_value( p_select_c, 20,
815: p_select_rec.first_installment_code );
816: dbms_sql.column_value( p_select_c, 21,
817: p_select_rec.min_acc_unit );
818: dbms_sql.column_value( p_select_c, 22, p_select_rec.gl_date );
819:
820: dbms_sql.column_value( p_select_c, 23, p_select_rec.rec_acctd_amount );
821: dbms_sql.column_value( p_select_c, 24, p_select_rec.total_charges_amount );
822: dbms_sql.column_value( p_select_c, 25, p_select_rec.reversed_cash_receipt_id); /*Bug3328690 */
816: dbms_sql.column_value( p_select_c, 21,
817: p_select_rec.min_acc_unit );
818: dbms_sql.column_value( p_select_c, 22, p_select_rec.gl_date );
819:
820: dbms_sql.column_value( p_select_c, 23, p_select_rec.rec_acctd_amount );
821: dbms_sql.column_value( p_select_c, 24, p_select_rec.total_charges_amount );
822: dbms_sql.column_value( p_select_c, 25, p_select_rec.reversed_cash_receipt_id); /*Bug3328690 */
823:
824: print_fcn_label2( 'arp_maintain_ps2.get_ips_column_values()-' );
817: p_select_rec.min_acc_unit );
818: dbms_sql.column_value( p_select_c, 22, p_select_rec.gl_date );
819:
820: dbms_sql.column_value( p_select_c, 23, p_select_rec.rec_acctd_amount );
821: dbms_sql.column_value( p_select_c, 24, p_select_rec.total_charges_amount );
822: dbms_sql.column_value( p_select_c, 25, p_select_rec.reversed_cash_receipt_id); /*Bug3328690 */
823:
824: print_fcn_label2( 'arp_maintain_ps2.get_ips_column_values()-' );
825: EXCEPTION
818: dbms_sql.column_value( p_select_c, 22, p_select_rec.gl_date );
819:
820: dbms_sql.column_value( p_select_c, 23, p_select_rec.rec_acctd_amount );
821: dbms_sql.column_value( p_select_c, 24, p_select_rec.total_charges_amount );
822: dbms_sql.column_value( p_select_c, 25, p_select_rec.reversed_cash_receipt_id); /*Bug3328690 */
823:
824: print_fcn_label2( 'arp_maintain_ps2.get_ips_column_values()-' );
825: EXCEPTION
826: WHEN OTHERS THEN
1044: -------------------------------------------------------------
1045: BEGIN
1046: debug( ' Binding insert_ps_c', MSG_LEVEL_DEBUG );
1047:
1048: dbms_sql.bind_variable( p_insert_ps_c,
1049: 'user_id',
1050: p_profile_info.user_id );
1051:
1052: dbms_sql.bind_variable( p_insert_ps_c,
1048: dbms_sql.bind_variable( p_insert_ps_c,
1049: 'user_id',
1050: p_profile_info.user_id );
1051:
1052: dbms_sql.bind_variable( p_insert_ps_c,
1053: 'login_id',
1054: p_profile_info.conc_login_id );
1055:
1056: dbms_sql.bind_variable( p_insert_ps_c,
1052: dbms_sql.bind_variable( p_insert_ps_c,
1053: 'login_id',
1054: p_profile_info.conc_login_id );
1055:
1056: dbms_sql.bind_variable( p_insert_ps_c,
1057: 'request_id',
1058: p_profile_info.request_id );
1059:
1060: dbms_sql.bind_variable( p_insert_ps_c,
1056: dbms_sql.bind_variable( p_insert_ps_c,
1057: 'request_id',
1058: p_profile_info.request_id );
1059:
1060: dbms_sql.bind_variable( p_insert_ps_c,
1061: 'application_id',
1062: p_profile_info.application_id );
1063:
1064: dbms_sql.bind_variable( p_insert_ps_c,
1060: dbms_sql.bind_variable( p_insert_ps_c,
1061: 'application_id',
1062: p_profile_info.application_id );
1063:
1064: dbms_sql.bind_variable( p_insert_ps_c,
1065: 'program_id',
1066: p_profile_info.conc_program_id );
1067:
1068: /* retrieve the next payment schedule id. Added for
1071: SELECT ar_payment_schedules_s.nextval
1072: INTO l_ps_id
1073: FROM dual;
1074:
1075: dbms_sql.bind_variable( p_insert_ps_c,
1076: 'payment_schedule_id',
1077: l_ps_id );
1078:
1079:
1076: 'payment_schedule_id',
1077: l_ps_id );
1078:
1079:
1080: dbms_sql.bind_variable( p_insert_ps_c,
1081: 'customer_trx_id',
1082: p_select_rec.customer_trx_id );
1083:
1084: dbms_sql.bind_variable( p_insert_ps_c,
1080: dbms_sql.bind_variable( p_insert_ps_c,
1081: 'customer_trx_id',
1082: p_select_rec.customer_trx_id );
1083:
1084: dbms_sql.bind_variable( p_insert_ps_c,
1085: 'line_amt',
1086: p_line_amount_t(i) );
1087:
1088: dbms_sql.bind_variable( p_insert_ps_c,
1084: dbms_sql.bind_variable( p_insert_ps_c,
1085: 'line_amt',
1086: p_line_amount_t(i) );
1087:
1088: dbms_sql.bind_variable( p_insert_ps_c,
1089: 'tax_amt',
1090: p_tax_amount_t(i) );
1091:
1092: dbms_sql.bind_variable( p_insert_ps_c,
1088: dbms_sql.bind_variable( p_insert_ps_c,
1089: 'tax_amt',
1090: p_tax_amount_t(i) );
1091:
1092: dbms_sql.bind_variable( p_insert_ps_c,
1093: 'frt_amt',
1094: p_freight_amount_t(i) );
1095:
1096: dbms_sql.bind_variable( p_insert_ps_c,
1092: dbms_sql.bind_variable( p_insert_ps_c,
1093: 'frt_amt',
1094: p_freight_amount_t(i) );
1095:
1096: dbms_sql.bind_variable( p_insert_ps_c,
1097: 'charge_amt',
1098: p_charges_amount_t(i) );
1099:
1100: dbms_sql.bind_variable( p_insert_ps_c,
1096: dbms_sql.bind_variable( p_insert_ps_c,
1097: 'charge_amt',
1098: p_charges_amount_t(i) );
1099:
1100: dbms_sql.bind_variable( p_insert_ps_c,
1101: 'acctd_adr',
1102: p_acctd_amt_due_rem_t(i) );
1103:
1104: dbms_sql.bind_variable( p_insert_ps_c,
1100: dbms_sql.bind_variable( p_insert_ps_c,
1101: 'acctd_adr',
1102: p_acctd_amt_due_rem_t(i) );
1103:
1104: dbms_sql.bind_variable( p_insert_ps_c,
1105: 'terms_sequence_number',
1106: p_terms_sequence_num_t(i) );
1107:
1108: dbms_sql.bind_variable( p_insert_ps_c,
1104: dbms_sql.bind_variable( p_insert_ps_c,
1105: 'terms_sequence_number',
1106: p_terms_sequence_num_t(i) );
1107:
1108: dbms_sql.bind_variable( p_insert_ps_c,
1109: 'due_date',
1110: p_due_date_t(i) );
1111:
1112: dbms_sql.bind_variable( p_insert_ps_c,
1108: dbms_sql.bind_variable( p_insert_ps_c,
1109: 'due_date',
1110: p_due_date_t(i) );
1111:
1112: dbms_sql.bind_variable( p_insert_ps_c,
1113: 'term_id',
1114: p_select_rec.term_id );
1115:
1116: dbms_sql.bind_variable( p_insert_ps_c,
1112: dbms_sql.bind_variable( p_insert_ps_c,
1113: 'term_id',
1114: p_select_rec.term_id );
1115:
1116: dbms_sql.bind_variable( p_insert_ps_c,
1117: 'customer_id',
1118: p_select_rec.customer_id );
1119:
1120: dbms_sql.bind_variable( p_insert_ps_c,
1116: dbms_sql.bind_variable( p_insert_ps_c,
1117: 'customer_id',
1118: p_select_rec.customer_id );
1119:
1120: dbms_sql.bind_variable( p_insert_ps_c,
1121: 'type',
1122: p_select_rec.trx_type );
1123:
1124: dbms_sql.bind_variable( p_insert_ps_c,
1120: dbms_sql.bind_variable( p_insert_ps_c,
1121: 'type',
1122: p_select_rec.trx_type );
1123:
1124: dbms_sql.bind_variable( p_insert_ps_c,
1125: 'site_use_id',
1126: p_select_rec.site_use_id );
1127:
1128: dbms_sql.bind_variable( p_insert_ps_c,
1124: dbms_sql.bind_variable( p_insert_ps_c,
1125: 'site_use_id',
1126: p_select_rec.site_use_id );
1127:
1128: dbms_sql.bind_variable( p_insert_ps_c,
1129: 'cust_trx_type_id',
1130: p_select_rec.cust_trx_type_id );
1131:
1132: dbms_sql.bind_variable( p_insert_ps_c,
1128: dbms_sql.bind_variable( p_insert_ps_c,
1129: 'cust_trx_type_id',
1130: p_select_rec.cust_trx_type_id );
1131:
1132: dbms_sql.bind_variable( p_insert_ps_c,
1133: 'currency_code',
1134: p_select_rec.currency_code );
1135:
1136: dbms_sql.bind_variable( p_insert_ps_c,
1132: dbms_sql.bind_variable( p_insert_ps_c,
1133: 'currency_code',
1134: p_select_rec.currency_code );
1135:
1136: dbms_sql.bind_variable( p_insert_ps_c,
1137: 'trx_date',
1138: p_select_rec.trx_date );
1139:
1140: dbms_sql.bind_variable( p_insert_ps_c,
1136: dbms_sql.bind_variable( p_insert_ps_c,
1137: 'trx_date',
1138: p_select_rec.trx_date );
1139:
1140: dbms_sql.bind_variable( p_insert_ps_c,
1141: 'gl_date',
1142: p_select_rec.gl_date );
1143:
1144: dbms_sql.bind_variable( p_insert_ps_c,
1140: dbms_sql.bind_variable( p_insert_ps_c,
1141: 'gl_date',
1142: p_select_rec.gl_date );
1143:
1144: dbms_sql.bind_variable( p_insert_ps_c,
1145: 'trx_number',
1146: p_select_rec.trx_number );
1147:
1148: dbms_sql.bind_variable( p_insert_ps_c,
1144: dbms_sql.bind_variable( p_insert_ps_c,
1145: 'trx_number',
1146: p_select_rec.trx_number );
1147:
1148: dbms_sql.bind_variable( p_insert_ps_c,
1149: 'exchange_rate_type',
1150: p_select_rec.exchange_rate_type );
1151:
1152: dbms_sql.bind_variable( p_insert_ps_c,
1148: dbms_sql.bind_variable( p_insert_ps_c,
1149: 'exchange_rate_type',
1150: p_select_rec.exchange_rate_type );
1151:
1152: dbms_sql.bind_variable( p_insert_ps_c,
1153: 'exchange_rate',
1154: p_select_rec.exchange_rate );
1155:
1156: dbms_sql.bind_variable( p_insert_ps_c,
1152: dbms_sql.bind_variable( p_insert_ps_c,
1153: 'exchange_rate',
1154: p_select_rec.exchange_rate );
1155:
1156: dbms_sql.bind_variable( p_insert_ps_c,
1157: 'exchange_date',
1158: p_select_rec.exchange_date );
1159:
1160: dbms_sql.bind_variable( p_insert_ps_c,
1156: dbms_sql.bind_variable( p_insert_ps_c,
1157: 'exchange_date',
1158: p_select_rec.exchange_date );
1159:
1160: dbms_sql.bind_variable( p_insert_ps_c,
1161: 'number_of_due_dates',
1162: p_number_of_due_dates );
1163:
1164: dbms_sql.bind_variable( p_insert_ps_c,
1160: dbms_sql.bind_variable( p_insert_ps_c,
1161: 'number_of_due_dates',
1162: p_number_of_due_dates );
1163:
1164: dbms_sql.bind_variable( p_insert_ps_c,
1165: 'reversed_cash_receipt_id',
1166: p_select_rec.reversed_cash_receipt_id );
1167:
1168: --anuj
1165: 'reversed_cash_receipt_id',
1166: p_select_rec.reversed_cash_receipt_id );
1167:
1168: --anuj
1169: dbms_sql.bind_variable( p_insert_ps_c,
1170: 'org_id',
1171: arp_standard.sysparm.org_id /* SSA changes anuj */ );
1172:
1173: EXCEPTION
1181: -- Execute
1182: -------------------------------------------------------------
1183: BEGIN
1184: debug( ' Inserting payment schedules', MSG_LEVEL_DEBUG );
1185: l_ignore := dbms_sql.execute( p_insert_ps_c );
1186: debug( to_char(l_ignore) || ' row(s) inserted',
1187: MSG_LEVEL_DEBUG );
1188:
1189: /* Call JL for locking the invoice for approval if JL is installed.
1314:
1315: --
1316: clear_tables;
1317: --
1318: IF( NOT( dbms_sql.is_open( ips_select_c ) AND
1319: dbms_sql.is_open( ips_insert_ps_c ) )) THEN
1320:
1321: build_ips_sql( system_info,
1322: profile_info,
1315: --
1316: clear_tables;
1317: --
1318: IF( NOT( dbms_sql.is_open( ips_select_c ) AND
1319: dbms_sql.is_open( ips_insert_ps_c ) )) THEN
1320:
1321: build_ips_sql( system_info,
1322: profile_info,
1323: ips_select_c,
1329:
1330: ---------------------------------------------------------------
1331: -- Bind variables
1332: ---------------------------------------------------------------
1333: dbms_sql.bind_variable( ips_select_c,
1334: 'customer_trx_id',
1335: p_customer_trx_id );
1336:
1337: ---------------------------------------------------------------
1339: ---------------------------------------------------------------
1340: debug( ' Executing select sql', MSG_LEVEL_DEBUG );
1341:
1342: BEGIN
1343: l_ignore := dbms_sql.execute( ips_select_c );
1344:
1345: EXCEPTION
1346: WHEN OTHERS THEN
1347: debug( 'EXCEPTION: Error executing select sql',
1355: ---------------------------------------------------------------
1356: BEGIN
1357: LOOP
1358:
1359: IF dbms_sql.fetch_rows( ips_select_c ) > 0 THEN
1360:
1361: debug(' Fetched a row', MSG_LEVEL_DEBUG );
1362:
1363: -----------------------------------------------
1362:
1363: -----------------------------------------------
1364: -- Load row into record
1365: -----------------------------------------------
1366: dbms_sql.column_value( ips_select_c, 1, l_customer_trx_id );
1367:
1368: IF( l_old_trx_id IS NULL OR
1369: l_customer_trx_id <> l_old_trx_id ) THEN
1370:
1892: BEGIN
1893: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
1894:
1895: debug( ' Parsing insert_ps_c', MSG_LEVEL_DEBUG );
1896: p_insert_ps_c := dbms_sql.open_cursor;
1897: dbms_sql.parse( p_insert_ps_c, l_insert_ps_sql,
1898: dbms_sql.v7 );
1899:
1900: debug( ' Parsing insert_ra_c', MSG_LEVEL_DEBUG );
1893: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
1894:
1895: debug( ' Parsing insert_ps_c', MSG_LEVEL_DEBUG );
1896: p_insert_ps_c := dbms_sql.open_cursor;
1897: dbms_sql.parse( p_insert_ps_c, l_insert_ps_sql,
1898: dbms_sql.v7 );
1899:
1900: debug( ' Parsing insert_ra_c', MSG_LEVEL_DEBUG );
1901: p_insert_ra_c := dbms_sql.open_cursor;
1894:
1895: debug( ' Parsing insert_ps_c', MSG_LEVEL_DEBUG );
1896: p_insert_ps_c := dbms_sql.open_cursor;
1897: dbms_sql.parse( p_insert_ps_c, l_insert_ps_sql,
1898: dbms_sql.v7 );
1899:
1900: debug( ' Parsing insert_ra_c', MSG_LEVEL_DEBUG );
1901: p_insert_ra_c := dbms_sql.open_cursor;
1902: dbms_sql.parse( p_insert_ra_c, l_insert_ra_sql,
1897: dbms_sql.parse( p_insert_ps_c, l_insert_ps_sql,
1898: dbms_sql.v7 );
1899:
1900: debug( ' Parsing insert_ra_c', MSG_LEVEL_DEBUG );
1901: p_insert_ra_c := dbms_sql.open_cursor;
1902: dbms_sql.parse( p_insert_ra_c, l_insert_ra_sql,
1903: dbms_sql.v7 );
1904:
1905: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
1898: dbms_sql.v7 );
1899:
1900: debug( ' Parsing insert_ra_c', MSG_LEVEL_DEBUG );
1901: p_insert_ra_c := dbms_sql.open_cursor;
1902: dbms_sql.parse( p_insert_ra_c, l_insert_ra_sql,
1903: dbms_sql.v7 );
1904:
1905: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
1906: p_update_ps_c := dbms_sql.open_cursor;
1899:
1900: debug( ' Parsing insert_ra_c', MSG_LEVEL_DEBUG );
1901: p_insert_ra_c := dbms_sql.open_cursor;
1902: dbms_sql.parse( p_insert_ra_c, l_insert_ra_sql,
1903: dbms_sql.v7 );
1904:
1905: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
1906: p_update_ps_c := dbms_sql.open_cursor;
1907: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
1902: dbms_sql.parse( p_insert_ra_c, l_insert_ra_sql,
1903: dbms_sql.v7 );
1904:
1905: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
1906: p_update_ps_c := dbms_sql.open_cursor;
1907: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
1908: dbms_sql.v7 );
1909:
1910: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
1903: dbms_sql.v7 );
1904:
1905: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
1906: p_update_ps_c := dbms_sql.open_cursor;
1907: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
1908: dbms_sql.v7 );
1909:
1910: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
1911: p_select_c := dbms_sql.open_cursor;
1904:
1905: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
1906: p_update_ps_c := dbms_sql.open_cursor;
1907: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
1908: dbms_sql.v7 );
1909:
1910: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
1911: p_select_c := dbms_sql.open_cursor;
1912: dbms_sql.parse( p_select_c, l_select_sql,
1907: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
1908: dbms_sql.v7 );
1909:
1910: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
1911: p_select_c := dbms_sql.open_cursor;
1912: dbms_sql.parse( p_select_c, l_select_sql,
1913: dbms_sql.v7 );
1914:
1915: EXCEPTION
1908: dbms_sql.v7 );
1909:
1910: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
1911: p_select_c := dbms_sql.open_cursor;
1912: dbms_sql.parse( p_select_c, l_select_sql,
1913: dbms_sql.v7 );
1914:
1915: EXCEPTION
1916: WHEN OTHERS THEN
1909:
1910: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
1911: p_select_c := dbms_sql.open_cursor;
1912: dbms_sql.parse( p_select_c, l_select_sql,
1913: dbms_sql.v7 );
1914:
1915: EXCEPTION
1916: WHEN OTHERS THEN
1917: IF PG_DEBUG in ('Y', 'C') THEN
1941: BEGIN
1942:
1943: print_fcn_label2( 'arp_maintain_ps2.define_ira_select_columns()+' );
1944:
1945: dbms_sql.define_column( p_select_c, 1, p_select_rec.trx_date );
1946: dbms_sql.define_column( p_select_c, 2, p_select_rec.customer_id );
1947: dbms_sql.define_column( p_select_c, 3, p_select_rec.cust_trx_type_id );
1948: dbms_sql.define_column( p_select_c, 4, p_select_rec.customer_trx_id );
1949: dbms_sql.define_column( p_select_c, 5, p_select_rec.currency_code, 15 );
1942:
1943: print_fcn_label2( 'arp_maintain_ps2.define_ira_select_columns()+' );
1944:
1945: dbms_sql.define_column( p_select_c, 1, p_select_rec.trx_date );
1946: dbms_sql.define_column( p_select_c, 2, p_select_rec.customer_id );
1947: dbms_sql.define_column( p_select_c, 3, p_select_rec.cust_trx_type_id );
1948: dbms_sql.define_column( p_select_c, 4, p_select_rec.customer_trx_id );
1949: dbms_sql.define_column( p_select_c, 5, p_select_rec.currency_code, 15 );
1950: dbms_sql.define_column( p_select_c, 6, p_select_rec.total_cm_line_amount );
1943: print_fcn_label2( 'arp_maintain_ps2.define_ira_select_columns()+' );
1944:
1945: dbms_sql.define_column( p_select_c, 1, p_select_rec.trx_date );
1946: dbms_sql.define_column( p_select_c, 2, p_select_rec.customer_id );
1947: dbms_sql.define_column( p_select_c, 3, p_select_rec.cust_trx_type_id );
1948: dbms_sql.define_column( p_select_c, 4, p_select_rec.customer_trx_id );
1949: dbms_sql.define_column( p_select_c, 5, p_select_rec.currency_code, 15 );
1950: dbms_sql.define_column( p_select_c, 6, p_select_rec.total_cm_line_amount );
1951: dbms_sql.define_column( p_select_c, 7,
1944:
1945: dbms_sql.define_column( p_select_c, 1, p_select_rec.trx_date );
1946: dbms_sql.define_column( p_select_c, 2, p_select_rec.customer_id );
1947: dbms_sql.define_column( p_select_c, 3, p_select_rec.cust_trx_type_id );
1948: dbms_sql.define_column( p_select_c, 4, p_select_rec.customer_trx_id );
1949: dbms_sql.define_column( p_select_c, 5, p_select_rec.currency_code, 15 );
1950: dbms_sql.define_column( p_select_c, 6, p_select_rec.total_cm_line_amount );
1951: dbms_sql.define_column( p_select_c, 7,
1952: p_select_rec.total_cm_freight_amount );
1945: dbms_sql.define_column( p_select_c, 1, p_select_rec.trx_date );
1946: dbms_sql.define_column( p_select_c, 2, p_select_rec.customer_id );
1947: dbms_sql.define_column( p_select_c, 3, p_select_rec.cust_trx_type_id );
1948: dbms_sql.define_column( p_select_c, 4, p_select_rec.customer_trx_id );
1949: dbms_sql.define_column( p_select_c, 5, p_select_rec.currency_code, 15 );
1950: dbms_sql.define_column( p_select_c, 6, p_select_rec.total_cm_line_amount );
1951: dbms_sql.define_column( p_select_c, 7,
1952: p_select_rec.total_cm_freight_amount );
1953: dbms_sql.define_column( p_select_c, 8, p_select_rec.total_cm_tax_amount );
1946: dbms_sql.define_column( p_select_c, 2, p_select_rec.customer_id );
1947: dbms_sql.define_column( p_select_c, 3, p_select_rec.cust_trx_type_id );
1948: dbms_sql.define_column( p_select_c, 4, p_select_rec.customer_trx_id );
1949: dbms_sql.define_column( p_select_c, 5, p_select_rec.currency_code, 15 );
1950: dbms_sql.define_column( p_select_c, 6, p_select_rec.total_cm_line_amount );
1951: dbms_sql.define_column( p_select_c, 7,
1952: p_select_rec.total_cm_freight_amount );
1953: dbms_sql.define_column( p_select_c, 8, p_select_rec.total_cm_tax_amount );
1954: dbms_sql.define_column( p_select_c, 9,
1947: dbms_sql.define_column( p_select_c, 3, p_select_rec.cust_trx_type_id );
1948: dbms_sql.define_column( p_select_c, 4, p_select_rec.customer_trx_id );
1949: dbms_sql.define_column( p_select_c, 5, p_select_rec.currency_code, 15 );
1950: dbms_sql.define_column( p_select_c, 6, p_select_rec.total_cm_line_amount );
1951: dbms_sql.define_column( p_select_c, 7,
1952: p_select_rec.total_cm_freight_amount );
1953: dbms_sql.define_column( p_select_c, 8, p_select_rec.total_cm_tax_amount );
1954: dbms_sql.define_column( p_select_c, 9,
1955: p_select_rec.exchange_rate_type, 30 );
1949: dbms_sql.define_column( p_select_c, 5, p_select_rec.currency_code, 15 );
1950: dbms_sql.define_column( p_select_c, 6, p_select_rec.total_cm_line_amount );
1951: dbms_sql.define_column( p_select_c, 7,
1952: p_select_rec.total_cm_freight_amount );
1953: dbms_sql.define_column( p_select_c, 8, p_select_rec.total_cm_tax_amount );
1954: dbms_sql.define_column( p_select_c, 9,
1955: p_select_rec.exchange_rate_type, 30 );
1956: dbms_sql.define_column( p_select_c, 10, p_select_rec.exchange_rate );
1957: dbms_sql.define_column( p_select_c, 11, p_select_rec.exchange_date );
1950: dbms_sql.define_column( p_select_c, 6, p_select_rec.total_cm_line_amount );
1951: dbms_sql.define_column( p_select_c, 7,
1952: p_select_rec.total_cm_freight_amount );
1953: dbms_sql.define_column( p_select_c, 8, p_select_rec.total_cm_tax_amount );
1954: dbms_sql.define_column( p_select_c, 9,
1955: p_select_rec.exchange_rate_type, 30 );
1956: dbms_sql.define_column( p_select_c, 10, p_select_rec.exchange_rate );
1957: dbms_sql.define_column( p_select_c, 11, p_select_rec.exchange_date );
1958: dbms_sql.define_column( p_select_c, 12, p_select_rec.trx_number, 20 );
1952: p_select_rec.total_cm_freight_amount );
1953: dbms_sql.define_column( p_select_c, 8, p_select_rec.total_cm_tax_amount );
1954: dbms_sql.define_column( p_select_c, 9,
1955: p_select_rec.exchange_rate_type, 30 );
1956: dbms_sql.define_column( p_select_c, 10, p_select_rec.exchange_rate );
1957: dbms_sql.define_column( p_select_c, 11, p_select_rec.exchange_date );
1958: dbms_sql.define_column( p_select_c, 12, p_select_rec.trx_number, 20 );
1959: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date );
1960: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1953: dbms_sql.define_column( p_select_c, 8, p_select_rec.total_cm_tax_amount );
1954: dbms_sql.define_column( p_select_c, 9,
1955: p_select_rec.exchange_rate_type, 30 );
1956: dbms_sql.define_column( p_select_c, 10, p_select_rec.exchange_rate );
1957: dbms_sql.define_column( p_select_c, 11, p_select_rec.exchange_date );
1958: dbms_sql.define_column( p_select_c, 12, p_select_rec.trx_number, 20 );
1959: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date );
1960: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1961: dbms_sql.define_column( p_select_c, 15, p_select_rec.inv_customer_trx_id );
1954: dbms_sql.define_column( p_select_c, 9,
1955: p_select_rec.exchange_rate_type, 30 );
1956: dbms_sql.define_column( p_select_c, 10, p_select_rec.exchange_rate );
1957: dbms_sql.define_column( p_select_c, 11, p_select_rec.exchange_date );
1958: dbms_sql.define_column( p_select_c, 12, p_select_rec.trx_number, 20 );
1959: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date );
1960: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1961: dbms_sql.define_column( p_select_c, 15, p_select_rec.inv_customer_trx_id );
1962: dbms_sql.define_column( p_select_c, 16,
1955: p_select_rec.exchange_rate_type, 30 );
1956: dbms_sql.define_column( p_select_c, 10, p_select_rec.exchange_rate );
1957: dbms_sql.define_column( p_select_c, 11, p_select_rec.exchange_date );
1958: dbms_sql.define_column( p_select_c, 12, p_select_rec.trx_number, 20 );
1959: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date );
1960: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1961: dbms_sql.define_column( p_select_c, 15, p_select_rec.inv_customer_trx_id );
1962: dbms_sql.define_column( p_select_c, 16,
1963: p_select_rec.inv_payment_schedule_id );
1956: dbms_sql.define_column( p_select_c, 10, p_select_rec.exchange_rate );
1957: dbms_sql.define_column( p_select_c, 11, p_select_rec.exchange_date );
1958: dbms_sql.define_column( p_select_c, 12, p_select_rec.trx_number, 20 );
1959: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date );
1960: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1961: dbms_sql.define_column( p_select_c, 15, p_select_rec.inv_customer_trx_id );
1962: dbms_sql.define_column( p_select_c, 16,
1963: p_select_rec.inv_payment_schedule_id );
1964: dbms_sql.define_column( p_select_c, 17, p_select_rec.gl_date_closed );
1957: dbms_sql.define_column( p_select_c, 11, p_select_rec.exchange_date );
1958: dbms_sql.define_column( p_select_c, 12, p_select_rec.trx_number, 20 );
1959: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date );
1960: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1961: dbms_sql.define_column( p_select_c, 15, p_select_rec.inv_customer_trx_id );
1962: dbms_sql.define_column( p_select_c, 16,
1963: p_select_rec.inv_payment_schedule_id );
1964: dbms_sql.define_column( p_select_c, 17, p_select_rec.gl_date_closed );
1965: dbms_sql.define_column( p_select_c, 18, p_select_rec.actual_date_closed );
1958: dbms_sql.define_column( p_select_c, 12, p_select_rec.trx_number, 20 );
1959: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date );
1960: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1961: dbms_sql.define_column( p_select_c, 15, p_select_rec.inv_customer_trx_id );
1962: dbms_sql.define_column( p_select_c, 16,
1963: p_select_rec.inv_payment_schedule_id );
1964: dbms_sql.define_column( p_select_c, 17, p_select_rec.gl_date_closed );
1965: dbms_sql.define_column( p_select_c, 18, p_select_rec.actual_date_closed );
1966: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
1960: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1961: dbms_sql.define_column( p_select_c, 15, p_select_rec.inv_customer_trx_id );
1962: dbms_sql.define_column( p_select_c, 16,
1963: p_select_rec.inv_payment_schedule_id );
1964: dbms_sql.define_column( p_select_c, 17, p_select_rec.gl_date_closed );
1965: dbms_sql.define_column( p_select_c, 18, p_select_rec.actual_date_closed );
1966: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
1967: dbms_sql.define_column( p_select_c, 20, p_select_rec.inv_line_remaining );
1968: dbms_sql.define_column( p_select_c, 21,
1961: dbms_sql.define_column( p_select_c, 15, p_select_rec.inv_customer_trx_id );
1962: dbms_sql.define_column( p_select_c, 16,
1963: p_select_rec.inv_payment_schedule_id );
1964: dbms_sql.define_column( p_select_c, 17, p_select_rec.gl_date_closed );
1965: dbms_sql.define_column( p_select_c, 18, p_select_rec.actual_date_closed );
1966: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
1967: dbms_sql.define_column( p_select_c, 20, p_select_rec.inv_line_remaining );
1968: dbms_sql.define_column( p_select_c, 21,
1969: p_select_rec.inv_freight_remaining );
1962: dbms_sql.define_column( p_select_c, 16,
1963: p_select_rec.inv_payment_schedule_id );
1964: dbms_sql.define_column( p_select_c, 17, p_select_rec.gl_date_closed );
1965: dbms_sql.define_column( p_select_c, 18, p_select_rec.actual_date_closed );
1966: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
1967: dbms_sql.define_column( p_select_c, 20, p_select_rec.inv_line_remaining );
1968: dbms_sql.define_column( p_select_c, 21,
1969: p_select_rec.inv_freight_remaining );
1970: dbms_sql.define_column( p_select_c, 22, p_select_rec.inv_tax_remaining );
1963: p_select_rec.inv_payment_schedule_id );
1964: dbms_sql.define_column( p_select_c, 17, p_select_rec.gl_date_closed );
1965: dbms_sql.define_column( p_select_c, 18, p_select_rec.actual_date_closed );
1966: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
1967: dbms_sql.define_column( p_select_c, 20, p_select_rec.inv_line_remaining );
1968: dbms_sql.define_column( p_select_c, 21,
1969: p_select_rec.inv_freight_remaining );
1970: dbms_sql.define_column( p_select_c, 22, p_select_rec.inv_tax_remaining );
1971: dbms_sql.define_column( p_select_c, 23, p_select_rec.site_use_id );
1964: dbms_sql.define_column( p_select_c, 17, p_select_rec.gl_date_closed );
1965: dbms_sql.define_column( p_select_c, 18, p_select_rec.actual_date_closed );
1966: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
1967: dbms_sql.define_column( p_select_c, 20, p_select_rec.inv_line_remaining );
1968: dbms_sql.define_column( p_select_c, 21,
1969: p_select_rec.inv_freight_remaining );
1970: dbms_sql.define_column( p_select_c, 22, p_select_rec.inv_tax_remaining );
1971: dbms_sql.define_column( p_select_c, 23, p_select_rec.site_use_id );
1972: dbms_sql.define_column( p_select_c, 24,
1966: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
1967: dbms_sql.define_column( p_select_c, 20, p_select_rec.inv_line_remaining );
1968: dbms_sql.define_column( p_select_c, 21,
1969: p_select_rec.inv_freight_remaining );
1970: dbms_sql.define_column( p_select_c, 22, p_select_rec.inv_tax_remaining );
1971: dbms_sql.define_column( p_select_c, 23, p_select_rec.site_use_id );
1972: dbms_sql.define_column( p_select_c, 24,
1973: p_select_rec.min_acc_unit );
1974: dbms_sql.define_column( p_select_c, 25,
1967: dbms_sql.define_column( p_select_c, 20, p_select_rec.inv_line_remaining );
1968: dbms_sql.define_column( p_select_c, 21,
1969: p_select_rec.inv_freight_remaining );
1970: dbms_sql.define_column( p_select_c, 22, p_select_rec.inv_tax_remaining );
1971: dbms_sql.define_column( p_select_c, 23, p_select_rec.site_use_id );
1972: dbms_sql.define_column( p_select_c, 24,
1973: p_select_rec.min_acc_unit );
1974: dbms_sql.define_column( p_select_c, 25,
1975: p_select_rec.post_to_gl_flag, 1 );
1968: dbms_sql.define_column( p_select_c, 21,
1969: p_select_rec.inv_freight_remaining );
1970: dbms_sql.define_column( p_select_c, 22, p_select_rec.inv_tax_remaining );
1971: dbms_sql.define_column( p_select_c, 23, p_select_rec.site_use_id );
1972: dbms_sql.define_column( p_select_c, 24,
1973: p_select_rec.min_acc_unit );
1974: dbms_sql.define_column( p_select_c, 25,
1975: p_select_rec.post_to_gl_flag, 1 );
1976: dbms_sql.define_column( p_select_c, 26,
1970: dbms_sql.define_column( p_select_c, 22, p_select_rec.inv_tax_remaining );
1971: dbms_sql.define_column( p_select_c, 23, p_select_rec.site_use_id );
1972: dbms_sql.define_column( p_select_c, 24,
1973: p_select_rec.min_acc_unit );
1974: dbms_sql.define_column( p_select_c, 25,
1975: p_select_rec.post_to_gl_flag, 1 );
1976: dbms_sql.define_column( p_select_c, 26,
1977: p_select_rec.credit_method, 30 );
1978: dbms_sql.define_column( p_select_c, 27,
1972: dbms_sql.define_column( p_select_c, 24,
1973: p_select_rec.min_acc_unit );
1974: dbms_sql.define_column( p_select_c, 25,
1975: p_select_rec.post_to_gl_flag, 1 );
1976: dbms_sql.define_column( p_select_c, 26,
1977: p_select_rec.credit_method, 30 );
1978: dbms_sql.define_column( p_select_c, 27,
1979: p_select_rec.inv_amount_credited );
1980: dbms_sql.define_column( p_select_c, 28,
1974: dbms_sql.define_column( p_select_c, 25,
1975: p_select_rec.post_to_gl_flag, 1 );
1976: dbms_sql.define_column( p_select_c, 26,
1977: p_select_rec.credit_method, 30 );
1978: dbms_sql.define_column( p_select_c, 27,
1979: p_select_rec.inv_amount_credited );
1980: dbms_sql.define_column( p_select_c, 28,
1981: p_select_rec.inv_amount_due_remaining );
1982: dbms_sql.define_column( p_select_c, 29,
1976: dbms_sql.define_column( p_select_c, 26,
1977: p_select_rec.credit_method, 30 );
1978: dbms_sql.define_column( p_select_c, 27,
1979: p_select_rec.inv_amount_credited );
1980: dbms_sql.define_column( p_select_c, 28,
1981: p_select_rec.inv_amount_due_remaining );
1982: dbms_sql.define_column( p_select_c, 29,
1983: p_select_rec.inv_acctd_amt_due_rem );
1984: dbms_sql.define_column( p_select_c, 30, p_select_rec.inv_precision );
1978: dbms_sql.define_column( p_select_c, 27,
1979: p_select_rec.inv_amount_credited );
1980: dbms_sql.define_column( p_select_c, 28,
1981: p_select_rec.inv_amount_due_remaining );
1982: dbms_sql.define_column( p_select_c, 29,
1983: p_select_rec.inv_acctd_amt_due_rem );
1984: dbms_sql.define_column( p_select_c, 30, p_select_rec.inv_precision );
1985: dbms_sql.define_column( p_select_c, 31,
1986: p_select_rec.inv_min_acc_unit );
1980: dbms_sql.define_column( p_select_c, 28,
1981: p_select_rec.inv_amount_due_remaining );
1982: dbms_sql.define_column( p_select_c, 29,
1983: p_select_rec.inv_acctd_amt_due_rem );
1984: dbms_sql.define_column( p_select_c, 30, p_select_rec.inv_precision );
1985: dbms_sql.define_column( p_select_c, 31,
1986: p_select_rec.inv_min_acc_unit );
1987: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_exchange_rate );
1988: dbms_sql.define_column( p_select_c, 33, p_select_rec.rec_acctd_amount );
1981: p_select_rec.inv_amount_due_remaining );
1982: dbms_sql.define_column( p_select_c, 29,
1983: p_select_rec.inv_acctd_amt_due_rem );
1984: dbms_sql.define_column( p_select_c, 30, p_select_rec.inv_precision );
1985: dbms_sql.define_column( p_select_c, 31,
1986: p_select_rec.inv_min_acc_unit );
1987: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_exchange_rate );
1988: dbms_sql.define_column( p_select_c, 33, p_select_rec.rec_acctd_amount );
1989: dbms_sql.define_column( p_select_c, 34,
1983: p_select_rec.inv_acctd_amt_due_rem );
1984: dbms_sql.define_column( p_select_c, 30, p_select_rec.inv_precision );
1985: dbms_sql.define_column( p_select_c, 31,
1986: p_select_rec.inv_min_acc_unit );
1987: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_exchange_rate );
1988: dbms_sql.define_column( p_select_c, 33, p_select_rec.rec_acctd_amount );
1989: dbms_sql.define_column( p_select_c, 34,
1990: p_select_rec.total_cm_charges_amount );
1991: dbms_sql.define_column( p_select_c, 35,
1984: dbms_sql.define_column( p_select_c, 30, p_select_rec.inv_precision );
1985: dbms_sql.define_column( p_select_c, 31,
1986: p_select_rec.inv_min_acc_unit );
1987: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_exchange_rate );
1988: dbms_sql.define_column( p_select_c, 33, p_select_rec.rec_acctd_amount );
1989: dbms_sql.define_column( p_select_c, 34,
1990: p_select_rec.total_cm_charges_amount );
1991: dbms_sql.define_column( p_select_c, 35,
1992: p_select_rec.inv_charges_remaining );
1985: dbms_sql.define_column( p_select_c, 31,
1986: p_select_rec.inv_min_acc_unit );
1987: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_exchange_rate );
1988: dbms_sql.define_column( p_select_c, 33, p_select_rec.rec_acctd_amount );
1989: dbms_sql.define_column( p_select_c, 34,
1990: p_select_rec.total_cm_charges_amount );
1991: dbms_sql.define_column( p_select_c, 35,
1992: p_select_rec.inv_charges_remaining );
1993:
1987: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_exchange_rate );
1988: dbms_sql.define_column( p_select_c, 33, p_select_rec.rec_acctd_amount );
1989: dbms_sql.define_column( p_select_c, 34,
1990: p_select_rec.total_cm_charges_amount );
1991: dbms_sql.define_column( p_select_c, 35,
1992: p_select_rec.inv_charges_remaining );
1993:
1994:
1995: print_fcn_label2( 'arp_maintain_ps2.define_ira_select_columns()-' );
2008: /* Bug 460927 - Modified IN to IN OUT oin the above line - oracle 8 */
2009: BEGIN
2010: print_fcn_label2( 'arp_maintain_ps2.get_ira_column_values()+' );
2011:
2012: dbms_sql.column_value( p_select_c, 1, p_select_rec.trx_date );
2013: dbms_sql.column_value( p_select_c, 2, p_select_rec.customer_id );
2014: dbms_sql.column_value( p_select_c, 3, p_select_rec.cust_trx_type_id );
2015: dbms_sql.column_value( p_select_c, 4, p_select_rec.customer_trx_id );
2016: dbms_sql.column_value( p_select_c, 5, p_select_rec.currency_code );
2009: BEGIN
2010: print_fcn_label2( 'arp_maintain_ps2.get_ira_column_values()+' );
2011:
2012: dbms_sql.column_value( p_select_c, 1, p_select_rec.trx_date );
2013: dbms_sql.column_value( p_select_c, 2, p_select_rec.customer_id );
2014: dbms_sql.column_value( p_select_c, 3, p_select_rec.cust_trx_type_id );
2015: dbms_sql.column_value( p_select_c, 4, p_select_rec.customer_trx_id );
2016: dbms_sql.column_value( p_select_c, 5, p_select_rec.currency_code );
2017: dbms_sql.column_value( p_select_c, 6, p_select_rec.total_cm_line_amount );
2010: print_fcn_label2( 'arp_maintain_ps2.get_ira_column_values()+' );
2011:
2012: dbms_sql.column_value( p_select_c, 1, p_select_rec.trx_date );
2013: dbms_sql.column_value( p_select_c, 2, p_select_rec.customer_id );
2014: dbms_sql.column_value( p_select_c, 3, p_select_rec.cust_trx_type_id );
2015: dbms_sql.column_value( p_select_c, 4, p_select_rec.customer_trx_id );
2016: dbms_sql.column_value( p_select_c, 5, p_select_rec.currency_code );
2017: dbms_sql.column_value( p_select_c, 6, p_select_rec.total_cm_line_amount );
2018: dbms_sql.column_value( p_select_c, 7,
2011:
2012: dbms_sql.column_value( p_select_c, 1, p_select_rec.trx_date );
2013: dbms_sql.column_value( p_select_c, 2, p_select_rec.customer_id );
2014: dbms_sql.column_value( p_select_c, 3, p_select_rec.cust_trx_type_id );
2015: dbms_sql.column_value( p_select_c, 4, p_select_rec.customer_trx_id );
2016: dbms_sql.column_value( p_select_c, 5, p_select_rec.currency_code );
2017: dbms_sql.column_value( p_select_c, 6, p_select_rec.total_cm_line_amount );
2018: dbms_sql.column_value( p_select_c, 7,
2019: p_select_rec.total_cm_freight_amount );
2012: dbms_sql.column_value( p_select_c, 1, p_select_rec.trx_date );
2013: dbms_sql.column_value( p_select_c, 2, p_select_rec.customer_id );
2014: dbms_sql.column_value( p_select_c, 3, p_select_rec.cust_trx_type_id );
2015: dbms_sql.column_value( p_select_c, 4, p_select_rec.customer_trx_id );
2016: dbms_sql.column_value( p_select_c, 5, p_select_rec.currency_code );
2017: dbms_sql.column_value( p_select_c, 6, p_select_rec.total_cm_line_amount );
2018: dbms_sql.column_value( p_select_c, 7,
2019: p_select_rec.total_cm_freight_amount );
2020: dbms_sql.column_value( p_select_c, 8, p_select_rec.total_cm_tax_amount );
2013: dbms_sql.column_value( p_select_c, 2, p_select_rec.customer_id );
2014: dbms_sql.column_value( p_select_c, 3, p_select_rec.cust_trx_type_id );
2015: dbms_sql.column_value( p_select_c, 4, p_select_rec.customer_trx_id );
2016: dbms_sql.column_value( p_select_c, 5, p_select_rec.currency_code );
2017: dbms_sql.column_value( p_select_c, 6, p_select_rec.total_cm_line_amount );
2018: dbms_sql.column_value( p_select_c, 7,
2019: p_select_rec.total_cm_freight_amount );
2020: dbms_sql.column_value( p_select_c, 8, p_select_rec.total_cm_tax_amount );
2021: dbms_sql.column_value( p_select_c, 9,
2014: dbms_sql.column_value( p_select_c, 3, p_select_rec.cust_trx_type_id );
2015: dbms_sql.column_value( p_select_c, 4, p_select_rec.customer_trx_id );
2016: dbms_sql.column_value( p_select_c, 5, p_select_rec.currency_code );
2017: dbms_sql.column_value( p_select_c, 6, p_select_rec.total_cm_line_amount );
2018: dbms_sql.column_value( p_select_c, 7,
2019: p_select_rec.total_cm_freight_amount );
2020: dbms_sql.column_value( p_select_c, 8, p_select_rec.total_cm_tax_amount );
2021: dbms_sql.column_value( p_select_c, 9,
2022: p_select_rec.exchange_rate_type );
2016: dbms_sql.column_value( p_select_c, 5, p_select_rec.currency_code );
2017: dbms_sql.column_value( p_select_c, 6, p_select_rec.total_cm_line_amount );
2018: dbms_sql.column_value( p_select_c, 7,
2019: p_select_rec.total_cm_freight_amount );
2020: dbms_sql.column_value( p_select_c, 8, p_select_rec.total_cm_tax_amount );
2021: dbms_sql.column_value( p_select_c, 9,
2022: p_select_rec.exchange_rate_type );
2023: dbms_sql.column_value( p_select_c, 10, p_select_rec.exchange_rate );
2024: dbms_sql.column_value( p_select_c, 11, p_select_rec.exchange_date );
2017: dbms_sql.column_value( p_select_c, 6, p_select_rec.total_cm_line_amount );
2018: dbms_sql.column_value( p_select_c, 7,
2019: p_select_rec.total_cm_freight_amount );
2020: dbms_sql.column_value( p_select_c, 8, p_select_rec.total_cm_tax_amount );
2021: dbms_sql.column_value( p_select_c, 9,
2022: p_select_rec.exchange_rate_type );
2023: dbms_sql.column_value( p_select_c, 10, p_select_rec.exchange_rate );
2024: dbms_sql.column_value( p_select_c, 11, p_select_rec.exchange_date );
2025: dbms_sql.column_value( p_select_c, 12, p_select_rec.trx_number );
2019: p_select_rec.total_cm_freight_amount );
2020: dbms_sql.column_value( p_select_c, 8, p_select_rec.total_cm_tax_amount );
2021: dbms_sql.column_value( p_select_c, 9,
2022: p_select_rec.exchange_rate_type );
2023: dbms_sql.column_value( p_select_c, 10, p_select_rec.exchange_rate );
2024: dbms_sql.column_value( p_select_c, 11, p_select_rec.exchange_date );
2025: dbms_sql.column_value( p_select_c, 12, p_select_rec.trx_number );
2026: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date );
2027: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
2020: dbms_sql.column_value( p_select_c, 8, p_select_rec.total_cm_tax_amount );
2021: dbms_sql.column_value( p_select_c, 9,
2022: p_select_rec.exchange_rate_type );
2023: dbms_sql.column_value( p_select_c, 10, p_select_rec.exchange_rate );
2024: dbms_sql.column_value( p_select_c, 11, p_select_rec.exchange_date );
2025: dbms_sql.column_value( p_select_c, 12, p_select_rec.trx_number );
2026: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date );
2027: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
2028: dbms_sql.column_value( p_select_c, 15, p_select_rec.inv_customer_trx_id );
2021: dbms_sql.column_value( p_select_c, 9,
2022: p_select_rec.exchange_rate_type );
2023: dbms_sql.column_value( p_select_c, 10, p_select_rec.exchange_rate );
2024: dbms_sql.column_value( p_select_c, 11, p_select_rec.exchange_date );
2025: dbms_sql.column_value( p_select_c, 12, p_select_rec.trx_number );
2026: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date );
2027: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
2028: dbms_sql.column_value( p_select_c, 15, p_select_rec.inv_customer_trx_id );
2029: dbms_sql.column_value( p_select_c, 16,
2022: p_select_rec.exchange_rate_type );
2023: dbms_sql.column_value( p_select_c, 10, p_select_rec.exchange_rate );
2024: dbms_sql.column_value( p_select_c, 11, p_select_rec.exchange_date );
2025: dbms_sql.column_value( p_select_c, 12, p_select_rec.trx_number );
2026: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date );
2027: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
2028: dbms_sql.column_value( p_select_c, 15, p_select_rec.inv_customer_trx_id );
2029: dbms_sql.column_value( p_select_c, 16,
2030: p_select_rec.inv_payment_schedule_id );
2023: dbms_sql.column_value( p_select_c, 10, p_select_rec.exchange_rate );
2024: dbms_sql.column_value( p_select_c, 11, p_select_rec.exchange_date );
2025: dbms_sql.column_value( p_select_c, 12, p_select_rec.trx_number );
2026: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date );
2027: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
2028: dbms_sql.column_value( p_select_c, 15, p_select_rec.inv_customer_trx_id );
2029: dbms_sql.column_value( p_select_c, 16,
2030: p_select_rec.inv_payment_schedule_id );
2031: dbms_sql.column_value( p_select_c, 17, p_select_rec.gl_date_closed );
2024: dbms_sql.column_value( p_select_c, 11, p_select_rec.exchange_date );
2025: dbms_sql.column_value( p_select_c, 12, p_select_rec.trx_number );
2026: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date );
2027: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
2028: dbms_sql.column_value( p_select_c, 15, p_select_rec.inv_customer_trx_id );
2029: dbms_sql.column_value( p_select_c, 16,
2030: p_select_rec.inv_payment_schedule_id );
2031: dbms_sql.column_value( p_select_c, 17, p_select_rec.gl_date_closed );
2032: dbms_sql.column_value( p_select_c, 18, p_select_rec.actual_date_closed );
2025: dbms_sql.column_value( p_select_c, 12, p_select_rec.trx_number );
2026: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date );
2027: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
2028: dbms_sql.column_value( p_select_c, 15, p_select_rec.inv_customer_trx_id );
2029: dbms_sql.column_value( p_select_c, 16,
2030: p_select_rec.inv_payment_schedule_id );
2031: dbms_sql.column_value( p_select_c, 17, p_select_rec.gl_date_closed );
2032: dbms_sql.column_value( p_select_c, 18, p_select_rec.actual_date_closed );
2033: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
2027: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
2028: dbms_sql.column_value( p_select_c, 15, p_select_rec.inv_customer_trx_id );
2029: dbms_sql.column_value( p_select_c, 16,
2030: p_select_rec.inv_payment_schedule_id );
2031: dbms_sql.column_value( p_select_c, 17, p_select_rec.gl_date_closed );
2032: dbms_sql.column_value( p_select_c, 18, p_select_rec.actual_date_closed );
2033: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
2034: dbms_sql.column_value( p_select_c, 20, p_select_rec.inv_line_remaining );
2035: dbms_sql.column_value( p_select_c, 21,
2028: dbms_sql.column_value( p_select_c, 15, p_select_rec.inv_customer_trx_id );
2029: dbms_sql.column_value( p_select_c, 16,
2030: p_select_rec.inv_payment_schedule_id );
2031: dbms_sql.column_value( p_select_c, 17, p_select_rec.gl_date_closed );
2032: dbms_sql.column_value( p_select_c, 18, p_select_rec.actual_date_closed );
2033: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
2034: dbms_sql.column_value( p_select_c, 20, p_select_rec.inv_line_remaining );
2035: dbms_sql.column_value( p_select_c, 21,
2036: p_select_rec.inv_freight_remaining );
2029: dbms_sql.column_value( p_select_c, 16,
2030: p_select_rec.inv_payment_schedule_id );
2031: dbms_sql.column_value( p_select_c, 17, p_select_rec.gl_date_closed );
2032: dbms_sql.column_value( p_select_c, 18, p_select_rec.actual_date_closed );
2033: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
2034: dbms_sql.column_value( p_select_c, 20, p_select_rec.inv_line_remaining );
2035: dbms_sql.column_value( p_select_c, 21,
2036: p_select_rec.inv_freight_remaining );
2037: dbms_sql.column_value( p_select_c, 22, p_select_rec.inv_tax_remaining );
2030: p_select_rec.inv_payment_schedule_id );
2031: dbms_sql.column_value( p_select_c, 17, p_select_rec.gl_date_closed );
2032: dbms_sql.column_value( p_select_c, 18, p_select_rec.actual_date_closed );
2033: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
2034: dbms_sql.column_value( p_select_c, 20, p_select_rec.inv_line_remaining );
2035: dbms_sql.column_value( p_select_c, 21,
2036: p_select_rec.inv_freight_remaining );
2037: dbms_sql.column_value( p_select_c, 22, p_select_rec.inv_tax_remaining );
2038: dbms_sql.column_value( p_select_c, 23, p_select_rec.site_use_id );
2031: dbms_sql.column_value( p_select_c, 17, p_select_rec.gl_date_closed );
2032: dbms_sql.column_value( p_select_c, 18, p_select_rec.actual_date_closed );
2033: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
2034: dbms_sql.column_value( p_select_c, 20, p_select_rec.inv_line_remaining );
2035: dbms_sql.column_value( p_select_c, 21,
2036: p_select_rec.inv_freight_remaining );
2037: dbms_sql.column_value( p_select_c, 22, p_select_rec.inv_tax_remaining );
2038: dbms_sql.column_value( p_select_c, 23, p_select_rec.site_use_id );
2039: dbms_sql.column_value( p_select_c, 24,
2033: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
2034: dbms_sql.column_value( p_select_c, 20, p_select_rec.inv_line_remaining );
2035: dbms_sql.column_value( p_select_c, 21,
2036: p_select_rec.inv_freight_remaining );
2037: dbms_sql.column_value( p_select_c, 22, p_select_rec.inv_tax_remaining );
2038: dbms_sql.column_value( p_select_c, 23, p_select_rec.site_use_id );
2039: dbms_sql.column_value( p_select_c, 24,
2040: p_select_rec.min_acc_unit );
2041: dbms_sql.column_value( p_select_c, 25,
2034: dbms_sql.column_value( p_select_c, 20, p_select_rec.inv_line_remaining );
2035: dbms_sql.column_value( p_select_c, 21,
2036: p_select_rec.inv_freight_remaining );
2037: dbms_sql.column_value( p_select_c, 22, p_select_rec.inv_tax_remaining );
2038: dbms_sql.column_value( p_select_c, 23, p_select_rec.site_use_id );
2039: dbms_sql.column_value( p_select_c, 24,
2040: p_select_rec.min_acc_unit );
2041: dbms_sql.column_value( p_select_c, 25,
2042: p_select_rec.post_to_gl_flag );
2035: dbms_sql.column_value( p_select_c, 21,
2036: p_select_rec.inv_freight_remaining );
2037: dbms_sql.column_value( p_select_c, 22, p_select_rec.inv_tax_remaining );
2038: dbms_sql.column_value( p_select_c, 23, p_select_rec.site_use_id );
2039: dbms_sql.column_value( p_select_c, 24,
2040: p_select_rec.min_acc_unit );
2041: dbms_sql.column_value( p_select_c, 25,
2042: p_select_rec.post_to_gl_flag );
2043: dbms_sql.column_value( p_select_c, 26,
2037: dbms_sql.column_value( p_select_c, 22, p_select_rec.inv_tax_remaining );
2038: dbms_sql.column_value( p_select_c, 23, p_select_rec.site_use_id );
2039: dbms_sql.column_value( p_select_c, 24,
2040: p_select_rec.min_acc_unit );
2041: dbms_sql.column_value( p_select_c, 25,
2042: p_select_rec.post_to_gl_flag );
2043: dbms_sql.column_value( p_select_c, 26,
2044: p_select_rec.credit_method );
2045: dbms_sql.column_value( p_select_c, 27,
2039: dbms_sql.column_value( p_select_c, 24,
2040: p_select_rec.min_acc_unit );
2041: dbms_sql.column_value( p_select_c, 25,
2042: p_select_rec.post_to_gl_flag );
2043: dbms_sql.column_value( p_select_c, 26,
2044: p_select_rec.credit_method );
2045: dbms_sql.column_value( p_select_c, 27,
2046: p_select_rec.inv_amount_credited );
2047: dbms_sql.column_value( p_select_c, 28,
2041: dbms_sql.column_value( p_select_c, 25,
2042: p_select_rec.post_to_gl_flag );
2043: dbms_sql.column_value( p_select_c, 26,
2044: p_select_rec.credit_method );
2045: dbms_sql.column_value( p_select_c, 27,
2046: p_select_rec.inv_amount_credited );
2047: dbms_sql.column_value( p_select_c, 28,
2048: p_select_rec.inv_amount_due_remaining );
2049: dbms_sql.column_value( p_select_c, 29,
2043: dbms_sql.column_value( p_select_c, 26,
2044: p_select_rec.credit_method );
2045: dbms_sql.column_value( p_select_c, 27,
2046: p_select_rec.inv_amount_credited );
2047: dbms_sql.column_value( p_select_c, 28,
2048: p_select_rec.inv_amount_due_remaining );
2049: dbms_sql.column_value( p_select_c, 29,
2050: p_select_rec.inv_acctd_amt_due_rem );
2051: dbms_sql.column_value( p_select_c, 30, p_select_rec.inv_precision );
2045: dbms_sql.column_value( p_select_c, 27,
2046: p_select_rec.inv_amount_credited );
2047: dbms_sql.column_value( p_select_c, 28,
2048: p_select_rec.inv_amount_due_remaining );
2049: dbms_sql.column_value( p_select_c, 29,
2050: p_select_rec.inv_acctd_amt_due_rem );
2051: dbms_sql.column_value( p_select_c, 30, p_select_rec.inv_precision );
2052: dbms_sql.column_value( p_select_c, 31,
2053: p_select_rec.inv_min_acc_unit );
2047: dbms_sql.column_value( p_select_c, 28,
2048: p_select_rec.inv_amount_due_remaining );
2049: dbms_sql.column_value( p_select_c, 29,
2050: p_select_rec.inv_acctd_amt_due_rem );
2051: dbms_sql.column_value( p_select_c, 30, p_select_rec.inv_precision );
2052: dbms_sql.column_value( p_select_c, 31,
2053: p_select_rec.inv_min_acc_unit );
2054: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_exchange_rate );
2055: dbms_sql.column_value( p_select_c, 33, p_select_rec.rec_acctd_amount );
2048: p_select_rec.inv_amount_due_remaining );
2049: dbms_sql.column_value( p_select_c, 29,
2050: p_select_rec.inv_acctd_amt_due_rem );
2051: dbms_sql.column_value( p_select_c, 30, p_select_rec.inv_precision );
2052: dbms_sql.column_value( p_select_c, 31,
2053: p_select_rec.inv_min_acc_unit );
2054: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_exchange_rate );
2055: dbms_sql.column_value( p_select_c, 33, p_select_rec.rec_acctd_amount );
2056: dbms_sql.column_value( p_select_c, 34,
2050: p_select_rec.inv_acctd_amt_due_rem );
2051: dbms_sql.column_value( p_select_c, 30, p_select_rec.inv_precision );
2052: dbms_sql.column_value( p_select_c, 31,
2053: p_select_rec.inv_min_acc_unit );
2054: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_exchange_rate );
2055: dbms_sql.column_value( p_select_c, 33, p_select_rec.rec_acctd_amount );
2056: dbms_sql.column_value( p_select_c, 34,
2057: p_select_rec.total_cm_charges_amount );
2058: dbms_sql.column_value( p_select_c, 35,
2051: dbms_sql.column_value( p_select_c, 30, p_select_rec.inv_precision );
2052: dbms_sql.column_value( p_select_c, 31,
2053: p_select_rec.inv_min_acc_unit );
2054: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_exchange_rate );
2055: dbms_sql.column_value( p_select_c, 33, p_select_rec.rec_acctd_amount );
2056: dbms_sql.column_value( p_select_c, 34,
2057: p_select_rec.total_cm_charges_amount );
2058: dbms_sql.column_value( p_select_c, 35,
2059: p_select_rec.inv_charges_remaining );
2052: dbms_sql.column_value( p_select_c, 31,
2053: p_select_rec.inv_min_acc_unit );
2054: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_exchange_rate );
2055: dbms_sql.column_value( p_select_c, 33, p_select_rec.rec_acctd_amount );
2056: dbms_sql.column_value( p_select_c, 34,
2057: p_select_rec.total_cm_charges_amount );
2058: dbms_sql.column_value( p_select_c, 35,
2059: p_select_rec.inv_charges_remaining );
2060:
2054: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_exchange_rate );
2055: dbms_sql.column_value( p_select_c, 33, p_select_rec.rec_acctd_amount );
2056: dbms_sql.column_value( p_select_c, 34,
2057: p_select_rec.total_cm_charges_amount );
2058: dbms_sql.column_value( p_select_c, 35,
2059: p_select_rec.inv_charges_remaining );
2060:
2061:
2062: print_fcn_label2( 'arp_maintain_ps2.get_ira_column_values()-' );
2690: -------------------------------------------------------------
2691: BEGIN
2692: debug( ' Binding insert_ps_c', MSG_LEVEL_DEBUG );
2693:
2694: dbms_sql.bind_variable( p_insert_ps_c,
2695: 'user_id',
2696: p_profile_info.user_id );
2697:
2698: dbms_sql.bind_variable( p_insert_ps_c,
2694: dbms_sql.bind_variable( p_insert_ps_c,
2695: 'user_id',
2696: p_profile_info.user_id );
2697:
2698: dbms_sql.bind_variable( p_insert_ps_c,
2699: 'login_id',
2700: p_profile_info.conc_login_id );
2701:
2702: dbms_sql.bind_variable( p_insert_ps_c,
2698: dbms_sql.bind_variable( p_insert_ps_c,
2699: 'login_id',
2700: p_profile_info.conc_login_id );
2701:
2702: dbms_sql.bind_variable( p_insert_ps_c,
2703: 'request_id',
2704: p_profile_info.request_id );
2705:
2706: dbms_sql.bind_variable( p_insert_ps_c,
2702: dbms_sql.bind_variable( p_insert_ps_c,
2703: 'request_id',
2704: p_profile_info.request_id );
2705:
2706: dbms_sql.bind_variable( p_insert_ps_c,
2707: 'application_id',
2708: p_profile_info.application_id );
2709:
2710: dbms_sql.bind_variable( p_insert_ps_c,
2706: dbms_sql.bind_variable( p_insert_ps_c,
2707: 'application_id',
2708: p_profile_info.application_id );
2709:
2710: dbms_sql.bind_variable( p_insert_ps_c,
2711: 'program_id',
2712: p_profile_info.conc_program_id );
2713:
2714: /* added for mrc trigger elimination */
2715: SELECT ar_payment_schedules_s.nextval
2716: INTO l_ps_id
2717: FROM dual;
2718:
2719: dbms_sql.bind_variable( p_insert_ps_c,
2720: 'payment_schedule_id',
2721: l_ps_id );
2722:
2723: dbms_sql.bind_variable( p_insert_ps_c,
2719: dbms_sql.bind_variable( p_insert_ps_c,
2720: 'payment_schedule_id',
2721: l_ps_id );
2722:
2723: dbms_sql.bind_variable( p_insert_ps_c,
2724: 'customer_trx_id',
2725: p_select_rec.customer_trx_id );
2726:
2727: dbms_sql.bind_variable( p_insert_ps_c,
2723: dbms_sql.bind_variable( p_insert_ps_c,
2724: 'customer_trx_id',
2725: p_select_rec.customer_trx_id );
2726:
2727: dbms_sql.bind_variable( p_insert_ps_c,
2728: 'amount_due_original',
2729: p_select_rec.total_cm_line_amount +
2730: p_select_rec.total_cm_tax_amount +
2731: p_select_rec.total_cm_freight_amount +
2730: p_select_rec.total_cm_tax_amount +
2731: p_select_rec.total_cm_freight_amount +
2732: p_select_rec.total_cm_charges_amount );
2733:
2734: dbms_sql.bind_variable( p_insert_ps_c,
2735: 'amount_line_items_original',
2736: p_select_rec.total_cm_line_amount );
2737:
2738: dbms_sql.bind_variable( p_insert_ps_c,
2734: dbms_sql.bind_variable( p_insert_ps_c,
2735: 'amount_line_items_original',
2736: p_select_rec.total_cm_line_amount );
2737:
2738: dbms_sql.bind_variable( p_insert_ps_c,
2739: 'tax_original',
2740: p_select_rec.total_cm_tax_amount );
2741:
2742: dbms_sql.bind_variable( p_insert_ps_c,
2738: dbms_sql.bind_variable( p_insert_ps_c,
2739: 'tax_original',
2740: p_select_rec.total_cm_tax_amount );
2741:
2742: dbms_sql.bind_variable( p_insert_ps_c,
2743: 'freight_original',
2744: p_select_rec.total_cm_freight_amount );
2745:
2746: dbms_sql.bind_variable( p_insert_ps_c,
2742: dbms_sql.bind_variable( p_insert_ps_c,
2743: 'freight_original',
2744: p_select_rec.total_cm_freight_amount );
2745:
2746: dbms_sql.bind_variable( p_insert_ps_c,
2747: 'receivables_charges_charged',
2748: p_select_rec.total_cm_charges_amount );
2749:
2750: dbms_sql.bind_variable( p_insert_ps_c,
2746: dbms_sql.bind_variable( p_insert_ps_c,
2747: 'receivables_charges_charged',
2748: p_select_rec.total_cm_charges_amount );
2749:
2750: dbms_sql.bind_variable( p_insert_ps_c,
2751: 'amount_applied',
2752: p_select_rec.total_cm_line_amount +
2753: p_select_rec.total_cm_tax_amount +
2754: p_select_rec.total_cm_freight_amount +
2753: p_select_rec.total_cm_tax_amount +
2754: p_select_rec.total_cm_freight_amount +
2755: p_select_rec.total_cm_charges_amount );
2756:
2757: dbms_sql.bind_variable( p_insert_ps_c,
2758: 'trx_date',
2759: p_select_rec.trx_date );
2760:
2761: dbms_sql.bind_variable( p_insert_ps_c,
2757: dbms_sql.bind_variable( p_insert_ps_c,
2758: 'trx_date',
2759: p_select_rec.trx_date );
2760:
2761: dbms_sql.bind_variable( p_insert_ps_c,
2762: 'customer_id',
2763: p_select_rec.customer_id );
2764:
2765: dbms_sql.bind_variable( p_insert_ps_c,
2761: dbms_sql.bind_variable( p_insert_ps_c,
2762: 'customer_id',
2763: p_select_rec.customer_id );
2764:
2765: dbms_sql.bind_variable( p_insert_ps_c,
2766: 'site_use_id',
2767: p_select_rec.site_use_id );
2768:
2769: dbms_sql.bind_variable( p_insert_ps_c,
2765: dbms_sql.bind_variable( p_insert_ps_c,
2766: 'site_use_id',
2767: p_select_rec.site_use_id );
2768:
2769: dbms_sql.bind_variable( p_insert_ps_c,
2770: 'cust_trx_type_id',
2771: p_select_rec.cust_trx_type_id );
2772:
2773: dbms_sql.bind_variable( p_insert_ps_c,
2769: dbms_sql.bind_variable( p_insert_ps_c,
2770: 'cust_trx_type_id',
2771: p_select_rec.cust_trx_type_id );
2772:
2773: dbms_sql.bind_variable( p_insert_ps_c,
2774: 'currency_code',
2775: p_select_rec.currency_code );
2776:
2777: dbms_sql.bind_variable( p_insert_ps_c,
2773: dbms_sql.bind_variable( p_insert_ps_c,
2774: 'currency_code',
2775: p_select_rec.currency_code );
2776:
2777: dbms_sql.bind_variable( p_insert_ps_c,
2778: 'exchange_rate_type',
2779: p_select_rec.exchange_rate_type );
2780:
2781:
2778: 'exchange_rate_type',
2779: p_select_rec.exchange_rate_type );
2780:
2781:
2782: dbms_sql.bind_variable( p_insert_ps_c,
2783: 'exchange_rate',
2784: p_select_rec.exchange_rate );
2785:
2786:
2783: 'exchange_rate',
2784: p_select_rec.exchange_rate );
2785:
2786:
2787: dbms_sql.bind_variable( p_insert_ps_c,
2788: 'exchange_date',
2789: p_select_rec.exchange_date );
2790:
2791: dbms_sql.bind_variable( p_insert_ps_c,
2787: dbms_sql.bind_variable( p_insert_ps_c,
2788: 'exchange_date',
2789: p_select_rec.exchange_date );
2790:
2791: dbms_sql.bind_variable( p_insert_ps_c,
2792: 'gl_date',
2793: p_select_rec.gl_date );
2794:
2795: dbms_sql.bind_variable( p_insert_ps_c,
2791: dbms_sql.bind_variable( p_insert_ps_c,
2792: 'gl_date',
2793: p_select_rec.gl_date );
2794:
2795: dbms_sql.bind_variable( p_insert_ps_c,
2796: 'trx_number',
2797: p_select_rec.trx_number );
2798: --begin anuj
2799: dbms_sql.bind_variable( p_insert_ps_c,
2795: dbms_sql.bind_variable( p_insert_ps_c,
2796: 'trx_number',
2797: p_select_rec.trx_number );
2798: --begin anuj
2799: dbms_sql.bind_variable( p_insert_ps_c,
2800: 'org_id',
2801: arp_standard.sysparm.org_id /* SSA changes anuj */
2802: );
2803: --end anuj
2814: -- Execute
2815: -------------------------------------------------------------
2816: BEGIN
2817: debug( ' Inserting CM payment schedules', MSG_LEVEL_DEBUG );
2818: l_ignore := dbms_sql.execute( p_insert_ps_c );
2819: debug( to_char(l_ignore) || ' row(s) inserted',
2820: MSG_LEVEL_DEBUG );
2821:
2822: /*-------------------------------------------+
2853: select ct.default_ussgl_transaction_code into l_ussgl_transaction_code
2854: from ra_customer_trx ct
2855: WHERE ct.customer_trx_id=p_select_rec.customer_trx_id;
2856:
2857: dbms_sql.bind_variable( p_insert_ra_c,
2858: 'user_id',
2859: p_profile_info.user_id );
2860:
2861: dbms_sql.bind_variable( p_insert_ra_c,
2857: dbms_sql.bind_variable( p_insert_ra_c,
2858: 'user_id',
2859: p_profile_info.user_id );
2860:
2861: dbms_sql.bind_variable( p_insert_ra_c,
2862: 'login_id',
2863: p_profile_info.conc_login_id );
2864:
2865: dbms_sql.bind_variable( p_insert_ra_c,
2861: dbms_sql.bind_variable( p_insert_ra_c,
2862: 'login_id',
2863: p_profile_info.conc_login_id );
2864:
2865: dbms_sql.bind_variable( p_insert_ra_c,
2866: 'request_id',
2867: p_profile_info.request_id );
2868:
2869: dbms_sql.bind_variable( p_insert_ra_c,
2865: dbms_sql.bind_variable( p_insert_ra_c,
2866: 'request_id',
2867: p_profile_info.request_id );
2868:
2869: dbms_sql.bind_variable( p_insert_ra_c,
2870: 'application_id',
2871: p_profile_info.application_id );
2872:
2873: dbms_sql.bind_variable( p_insert_ra_c,
2869: dbms_sql.bind_variable( p_insert_ra_c,
2870: 'application_id',
2871: p_profile_info.application_id );
2872:
2873: dbms_sql.bind_variable( p_insert_ra_c,
2874: 'program_id',
2875: p_profile_info.conc_program_id );
2876:
2877:
2874: 'program_id',
2875: p_profile_info.conc_program_id );
2876:
2877:
2878: dbms_sql.bind_variable( p_insert_ra_c,
2879: 'customer_trx_id',
2880: p_select_rec.customer_trx_id );
2881:
2882: dbms_sql.bind_variable( p_insert_ra_c,
2878: dbms_sql.bind_variable( p_insert_ra_c,
2879: 'customer_trx_id',
2880: p_select_rec.customer_trx_id );
2881:
2882: dbms_sql.bind_variable( p_insert_ra_c,
2883: 'gl_date',
2884: p_select_rec.gl_date );
2885:
2886: dbms_sql.bind_variable( p_insert_ra_c,
2882: dbms_sql.bind_variable( p_insert_ra_c,
2883: 'gl_date',
2884: p_select_rec.gl_date );
2885:
2886: dbms_sql.bind_variable( p_insert_ra_c,
2887: 'code_combination_id',
2888: p_select_rec.code_combination_id );
2889:
2890: dbms_sql.bind_variable(
2886: dbms_sql.bind_variable( p_insert_ra_c,
2887: 'code_combination_id',
2888: p_select_rec.code_combination_id );
2889:
2890: dbms_sql.bind_variable(
2891: p_insert_ra_c,
2892: 'set_of_books_id',
2893: arp_standard.sysparm.set_of_books_id );
2894:
2891: p_insert_ra_c,
2892: 'set_of_books_id',
2893: arp_standard.sysparm.set_of_books_id );
2894:
2895: dbms_sql.bind_variable( p_insert_ra_c,
2896: 'trx_date',
2897: p_select_rec.trx_date );
2898:
2899: dbms_sql.bind_variable( p_insert_ra_c,
2895: dbms_sql.bind_variable( p_insert_ra_c,
2896: 'trx_date',
2897: p_select_rec.trx_date );
2898:
2899: dbms_sql.bind_variable( p_insert_ra_c,
2900: 'applied_customer_trx_id',
2901: p_select_rec.inv_customer_trx_id );
2902:
2903:
2900: 'applied_customer_trx_id',
2901: p_select_rec.inv_customer_trx_id );
2902:
2903:
2904: dbms_sql.bind_variable( p_insert_ra_c,
2905: 'applied_payment_schedule_id',
2906: p_inv_ps_id_t( i ) );
2907:
2908: dbms_sql.bind_variable( p_insert_ra_c,
2904: dbms_sql.bind_variable( p_insert_ra_c,
2905: 'applied_payment_schedule_id',
2906: p_inv_ps_id_t( i ) );
2907:
2908: dbms_sql.bind_variable( p_insert_ra_c,
2909: 'amount_applied',
2910: p_line_applied_t( i ) +
2911: p_tax_applied_t( i ) +
2912: p_freight_applied_t( i ) +
2912: p_freight_applied_t( i ) +
2913: p_charges_applied_t( i ) );
2914:
2915:
2916: dbms_sql.bind_variable( p_insert_ra_c,
2917: 'acctd_amount_applied_from',
2918: p_acctd_amt_applied_from_t( i ) );
2919:
2920: dbms_sql.bind_variable( p_insert_ra_c,
2916: dbms_sql.bind_variable( p_insert_ra_c,
2917: 'acctd_amount_applied_from',
2918: p_acctd_amt_applied_from_t( i ) );
2919:
2920: dbms_sql.bind_variable( p_insert_ra_c,
2921: 'acctd_amount_applied_to',
2922: p_acctd_amt_applied_to_t( i ) );
2923:
2924: dbms_sql.bind_variable( p_insert_ra_c,
2920: dbms_sql.bind_variable( p_insert_ra_c,
2921: 'acctd_amount_applied_to',
2922: p_acctd_amt_applied_to_t( i ) );
2923:
2924: dbms_sql.bind_variable( p_insert_ra_c,
2925: 'line_applied',
2926: p_line_applied_t( i ) );
2927:
2928: dbms_sql.bind_variable( p_insert_ra_c,
2924: dbms_sql.bind_variable( p_insert_ra_c,
2925: 'line_applied',
2926: p_line_applied_t( i ) );
2927:
2928: dbms_sql.bind_variable( p_insert_ra_c,
2929: 'tax_applied',
2930: p_tax_applied_t( i ) );
2931:
2932: dbms_sql.bind_variable( p_insert_ra_c,
2928: dbms_sql.bind_variable( p_insert_ra_c,
2929: 'tax_applied',
2930: p_tax_applied_t( i ) );
2931:
2932: dbms_sql.bind_variable( p_insert_ra_c,
2933: 'freight_applied',
2934: p_freight_applied_t( i ) );
2935:
2936: dbms_sql.bind_variable( p_insert_ra_c,
2932: dbms_sql.bind_variable( p_insert_ra_c,
2933: 'freight_applied',
2934: p_freight_applied_t( i ) );
2935:
2936: dbms_sql.bind_variable( p_insert_ra_c,
2937: 'receivables_charges_applied',
2938: p_charges_applied_t( i ) );
2939:
2940: dbms_sql.bind_variable( p_insert_ra_c,
2936: dbms_sql.bind_variable( p_insert_ra_c,
2937: 'receivables_charges_applied',
2938: p_charges_applied_t( i ) );
2939:
2940: dbms_sql.bind_variable( p_insert_ra_c,
2941: 'post_to_gl_flag',
2942: p_select_rec.post_to_gl_flag );
2943:
2944: select ar_receivable_applications_s.nextval
2944: select ar_receivable_applications_s.nextval
2945: into l_receivable_application_id
2946: from dual;
2947:
2948: dbms_sql.bind_variable( p_insert_ra_c,
2949: 'receivable_application_id',
2950: l_receivable_application_id );
2951:
2952: dbms_sql.bind_variable( p_insert_ra_c,
2948: dbms_sql.bind_variable( p_insert_ra_c,
2949: 'receivable_application_id',
2950: l_receivable_application_id );
2951:
2952: dbms_sql.bind_variable( p_insert_ra_c,
2953: 'ussgl_transaction_code',
2954: l_ussgl_transaction_code );
2955:
2956:
2970: -- Execute
2971: -------------------------------------------------------------
2972: BEGIN
2973: debug( ' Inserting applications', MSG_LEVEL_DEBUG );
2974: l_ignore := dbms_sql.execute( p_insert_ra_c );
2975:
2976: debug( to_char(l_ignore) || ' row(s) inserted',
2977: MSG_LEVEL_DEBUG );
2978:
3037: -------------------------------------------------------------
3038: BEGIN
3039: debug( ' Binding update_ps_c', MSG_LEVEL_DEBUG );
3040:
3041: dbms_sql.bind_variable( p_update_ps_c,
3042: 'user_id',
3043: p_profile_info.user_id );
3044:
3045: dbms_sql.bind_variable( p_update_ps_c,
3041: dbms_sql.bind_variable( p_update_ps_c,
3042: 'user_id',
3043: p_profile_info.user_id );
3044:
3045: dbms_sql.bind_variable( p_update_ps_c,
3046: 'login_id',
3047: p_profile_info.conc_login_id );
3048:
3049: dbms_sql.bind_variable( p_update_ps_c,
3045: dbms_sql.bind_variable( p_update_ps_c,
3046: 'login_id',
3047: p_profile_info.conc_login_id );
3048:
3049: dbms_sql.bind_variable( p_update_ps_c,
3050: 'amount_due_remaining',
3051: p_inv_amount_due_rem_t( i ) );
3052:
3053: dbms_sql.bind_variable( p_update_ps_c,
3049: dbms_sql.bind_variable( p_update_ps_c,
3050: 'amount_due_remaining',
3051: p_inv_amount_due_rem_t( i ) );
3052:
3053: dbms_sql.bind_variable( p_update_ps_c,
3054: 'gl_date_closed',
3055: p_select_rec.gl_date_closed );
3056:
3057: dbms_sql.bind_variable( p_update_ps_c,
3053: dbms_sql.bind_variable( p_update_ps_c,
3054: 'gl_date_closed',
3055: p_select_rec.gl_date_closed );
3056:
3057: dbms_sql.bind_variable( p_update_ps_c,
3058: 'actual_date_closed',
3059: p_select_rec.actual_date_closed );
3060:
3061: dbms_sql.bind_variable( p_update_ps_c,
3057: dbms_sql.bind_variable( p_update_ps_c,
3058: 'actual_date_closed',
3059: p_select_rec.actual_date_closed );
3060:
3061: dbms_sql.bind_variable( p_update_ps_c,
3062: 'amount_line_items_remaining',
3063: p_inv_line_rem_t( i ) );
3064:
3065: dbms_sql.bind_variable( p_update_ps_c,
3061: dbms_sql.bind_variable( p_update_ps_c,
3062: 'amount_line_items_remaining',
3063: p_inv_line_rem_t( i ) );
3064:
3065: dbms_sql.bind_variable( p_update_ps_c,
3066: 'amount_credited',
3067: p_inv_amount_credited_t( i ) );
3068:
3069: dbms_sql.bind_variable( p_update_ps_c,
3065: dbms_sql.bind_variable( p_update_ps_c,
3066: 'amount_credited',
3067: p_inv_amount_credited_t( i ) );
3068:
3069: dbms_sql.bind_variable( p_update_ps_c,
3070: 'freight_remaining',
3071: p_inv_freight_rem_t( i ) );
3072:
3073: dbms_sql.bind_variable( p_update_ps_c,
3069: dbms_sql.bind_variable( p_update_ps_c,
3070: 'freight_remaining',
3071: p_inv_freight_rem_t( i ) );
3072:
3073: dbms_sql.bind_variable( p_update_ps_c,
3074: 'tax_remaining',
3075: p_inv_tax_rem_t( i ) );
3076:
3077: dbms_sql.bind_variable( p_update_ps_c,
3073: dbms_sql.bind_variable( p_update_ps_c,
3074: 'tax_remaining',
3075: p_inv_tax_rem_t( i ) );
3076:
3077: dbms_sql.bind_variable( p_update_ps_c,
3078: 'acctd_amount_due_remaining',
3079: p_inv_acctd_amt_due_rem_t( i ) );
3080:
3081: dbms_sql.bind_variable( p_update_ps_c,
3077: dbms_sql.bind_variable( p_update_ps_c,
3078: 'acctd_amount_due_remaining',
3079: p_inv_acctd_amt_due_rem_t( i ) );
3080:
3081: dbms_sql.bind_variable( p_update_ps_c,
3082: 'receivables_charges_remaining',
3083: p_inv_charges_rem_t( i ) );
3084:
3085: dbms_sql.bind_variable( p_update_ps_c,
3081: dbms_sql.bind_variable( p_update_ps_c,
3082: 'receivables_charges_remaining',
3083: p_inv_charges_rem_t( i ) );
3084:
3085: dbms_sql.bind_variable( p_update_ps_c,
3086: 'applied_payment_schedule_id',
3087: p_inv_ps_id_t( i ) );
3088:
3089:
3099: -- Execute
3100: -------------------------------------------------------------
3101: BEGIN
3102: debug( ' Updating invoice payment schedules', MSG_LEVEL_DEBUG );
3103: l_ignore := dbms_sql.execute( p_update_ps_c );
3104: debug( to_char(l_ignore) || ' row(s) updated',
3105: MSG_LEVEL_DEBUG );
3106:
3107: /*-------------------------------------------+
3299:
3300: --
3301: clear_all_tables;
3302: --
3303: IF( NOT( dbms_sql.is_open( ira_select_c ) AND
3304: dbms_sql.is_open( ira_insert_ps_c ) AND
3305: dbms_sql.is_open( ira_insert_ra_c ) AND
3306: dbms_sql.is_open( ira_update_ps_c ) )) THEN
3307:
3300: --
3301: clear_all_tables;
3302: --
3303: IF( NOT( dbms_sql.is_open( ira_select_c ) AND
3304: dbms_sql.is_open( ira_insert_ps_c ) AND
3305: dbms_sql.is_open( ira_insert_ra_c ) AND
3306: dbms_sql.is_open( ira_update_ps_c ) )) THEN
3307:
3308: build_ira_sql(
3301: clear_all_tables;
3302: --
3303: IF( NOT( dbms_sql.is_open( ira_select_c ) AND
3304: dbms_sql.is_open( ira_insert_ps_c ) AND
3305: dbms_sql.is_open( ira_insert_ra_c ) AND
3306: dbms_sql.is_open( ira_update_ps_c ) )) THEN
3307:
3308: build_ira_sql(
3309: system_info,
3302: --
3303: IF( NOT( dbms_sql.is_open( ira_select_c ) AND
3304: dbms_sql.is_open( ira_insert_ps_c ) AND
3305: dbms_sql.is_open( ira_insert_ra_c ) AND
3306: dbms_sql.is_open( ira_update_ps_c ) )) THEN
3307:
3308: build_ira_sql(
3309: system_info,
3310: profile_info,
3319:
3320: ---------------------------------------------------------------
3321: -- Bind variables
3322: ---------------------------------------------------------------
3323: dbms_sql.bind_variable( ira_select_c,
3324: 'customer_trx_id',
3325: p_customer_trx_id );
3326:
3327: ---------------------------------------------------------------
3329: ---------------------------------------------------------------
3330: debug( ' Executing select sql', MSG_LEVEL_DEBUG );
3331:
3332: BEGIN
3333: l_ignore := dbms_sql.execute( ira_select_c );
3334:
3335: EXCEPTION
3336: WHEN OTHERS THEN
3337: debug( 'EXCEPTION: Error executing select sql',
3345: ---------------------------------------------------------------
3346: BEGIN
3347: LOOP
3348:
3349: IF dbms_sql.fetch_rows( ira_select_c ) > 0 THEN
3350:
3351: debug(' Fetched a row', MSG_LEVEL_DEBUG );
3352:
3353: -----------------------------------------------
3352:
3353: -----------------------------------------------
3354: -- Load row into record
3355: -----------------------------------------------
3356: dbms_sql.column_value( ira_select_c, 4, l_customer_trx_id );
3357: dbms_sql.column_value( ira_select_c, 15,
3358: l_inv_customer_trx_id );
3359:
3360: -----------------------------------------------
3353: -----------------------------------------------
3354: -- Load row into record
3355: -----------------------------------------------
3356: dbms_sql.column_value( ira_select_c, 4, l_customer_trx_id );
3357: dbms_sql.column_value( ira_select_c, 15,
3358: l_inv_customer_trx_id );
3359:
3360: -----------------------------------------------
3361: -- Check if invoice or cm changed
3834: BEGIN
3835: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
3836:
3837: debug( ' Parsing insert_adj_c', MSG_LEVEL_DEBUG );
3838: p_insert_adj_c := dbms_sql.open_cursor;
3839: dbms_sql.parse( p_insert_adj_c, l_insert_adj_sql,
3840: dbms_sql.v7 );
3841:
3842: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
3835: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
3836:
3837: debug( ' Parsing insert_adj_c', MSG_LEVEL_DEBUG );
3838: p_insert_adj_c := dbms_sql.open_cursor;
3839: dbms_sql.parse( p_insert_adj_c, l_insert_adj_sql,
3840: dbms_sql.v7 );
3841:
3842: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
3843: p_update_ps_c := dbms_sql.open_cursor;
3836:
3837: debug( ' Parsing insert_adj_c', MSG_LEVEL_DEBUG );
3838: p_insert_adj_c := dbms_sql.open_cursor;
3839: dbms_sql.parse( p_insert_adj_c, l_insert_adj_sql,
3840: dbms_sql.v7 );
3841:
3842: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
3843: p_update_ps_c := dbms_sql.open_cursor;
3844: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
3839: dbms_sql.parse( p_insert_adj_c, l_insert_adj_sql,
3840: dbms_sql.v7 );
3841:
3842: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
3843: p_update_ps_c := dbms_sql.open_cursor;
3844: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
3845: dbms_sql.v7 );
3846:
3847: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
3840: dbms_sql.v7 );
3841:
3842: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
3843: p_update_ps_c := dbms_sql.open_cursor;
3844: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
3845: dbms_sql.v7 );
3846:
3847: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
3848: p_select_c := dbms_sql.open_cursor;
3841:
3842: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
3843: p_update_ps_c := dbms_sql.open_cursor;
3844: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
3845: dbms_sql.v7 );
3846:
3847: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
3848: p_select_c := dbms_sql.open_cursor;
3849: dbms_sql.parse( p_select_c, l_select_sql,
3844: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
3845: dbms_sql.v7 );
3846:
3847: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
3848: p_select_c := dbms_sql.open_cursor;
3849: dbms_sql.parse( p_select_c, l_select_sql,
3850: dbms_sql.v7 );
3851:
3852: EXCEPTION
3845: dbms_sql.v7 );
3846:
3847: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
3848: p_select_c := dbms_sql.open_cursor;
3849: dbms_sql.parse( p_select_c, l_select_sql,
3850: dbms_sql.v7 );
3851:
3852: EXCEPTION
3853: WHEN OTHERS THEN
3846:
3847: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
3848: p_select_c := dbms_sql.open_cursor;
3849: dbms_sql.parse( p_select_c, l_select_sql,
3850: dbms_sql.v7 );
3851:
3852: EXCEPTION
3853: WHEN OTHERS THEN
3854: IF PG_DEBUG in ('Y', 'C') THEN
3878: BEGIN
3879:
3880: print_fcn_label2( 'arp_maintain_ps2.define_ups_select_columns()+' );
3881:
3882: dbms_sql.define_column( p_select_c, 1, p_select_rec.set_of_books_id );
3883: dbms_sql.define_column( p_select_c, 2, p_select_rec.total_line_amount );
3884: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
3885: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
3886: dbms_sql.define_column( p_select_c, 5,
3879:
3880: print_fcn_label2( 'arp_maintain_ps2.define_ups_select_columns()+' );
3881:
3882: dbms_sql.define_column( p_select_c, 1, p_select_rec.set_of_books_id );
3883: dbms_sql.define_column( p_select_c, 2, p_select_rec.total_line_amount );
3884: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
3885: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
3886: dbms_sql.define_column( p_select_c, 5,
3887: p_select_rec.adjusted_trx_id );
3880: print_fcn_label2( 'arp_maintain_ps2.define_ups_select_columns()+' );
3881:
3882: dbms_sql.define_column( p_select_c, 1, p_select_rec.set_of_books_id );
3883: dbms_sql.define_column( p_select_c, 2, p_select_rec.total_line_amount );
3884: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
3885: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
3886: dbms_sql.define_column( p_select_c, 5,
3887: p_select_rec.adjusted_trx_id );
3888: dbms_sql.define_column( p_select_c, 6,
3881:
3882: dbms_sql.define_column( p_select_c, 1, p_select_rec.set_of_books_id );
3883: dbms_sql.define_column( p_select_c, 2, p_select_rec.total_line_amount );
3884: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
3885: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
3886: dbms_sql.define_column( p_select_c, 5,
3887: p_select_rec.adjusted_trx_id );
3888: dbms_sql.define_column( p_select_c, 6,
3889: p_select_rec.payment_schedule_id );
3882: dbms_sql.define_column( p_select_c, 1, p_select_rec.set_of_books_id );
3883: dbms_sql.define_column( p_select_c, 2, p_select_rec.total_line_amount );
3884: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
3885: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
3886: dbms_sql.define_column( p_select_c, 5,
3887: p_select_rec.adjusted_trx_id );
3888: dbms_sql.define_column( p_select_c, 6,
3889: p_select_rec.payment_schedule_id );
3890: dbms_sql.define_column( p_select_c, 7,
3884: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
3885: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
3886: dbms_sql.define_column( p_select_c, 5,
3887: p_select_rec.adjusted_trx_id );
3888: dbms_sql.define_column( p_select_c, 6,
3889: p_select_rec.payment_schedule_id );
3890: dbms_sql.define_column( p_select_c, 7,
3891: p_select_rec.subsequent_trx_id );
3892: dbms_sql.define_column( p_select_c, 8,
3886: dbms_sql.define_column( p_select_c, 5,
3887: p_select_rec.adjusted_trx_id );
3888: dbms_sql.define_column( p_select_c, 6,
3889: p_select_rec.payment_schedule_id );
3890: dbms_sql.define_column( p_select_c, 7,
3891: p_select_rec.subsequent_trx_id );
3892: dbms_sql.define_column( p_select_c, 8,
3893: p_select_rec.post_to_gl_flag, 1 );
3894: dbms_sql.define_column( p_select_c, 9,
3888: dbms_sql.define_column( p_select_c, 6,
3889: p_select_rec.payment_schedule_id );
3890: dbms_sql.define_column( p_select_c, 7,
3891: p_select_rec.subsequent_trx_id );
3892: dbms_sql.define_column( p_select_c, 8,
3893: p_select_rec.post_to_gl_flag, 1 );
3894: dbms_sql.define_column( p_select_c, 9,
3895: p_select_rec.commitment_trx_id );
3896: dbms_sql.define_column( p_select_c, 10, p_select_rec.percent );
3890: dbms_sql.define_column( p_select_c, 7,
3891: p_select_rec.subsequent_trx_id );
3892: dbms_sql.define_column( p_select_c, 8,
3893: p_select_rec.post_to_gl_flag, 1 );
3894: dbms_sql.define_column( p_select_c, 9,
3895: p_select_rec.commitment_trx_id );
3896: dbms_sql.define_column( p_select_c, 10, p_select_rec.percent );
3897: dbms_sql.define_column( p_select_c, 11, p_select_rec.precision );
3898: dbms_sql.define_column( p_select_c, 12, p_select_rec.min_acc_unit );
3892: dbms_sql.define_column( p_select_c, 8,
3893: p_select_rec.post_to_gl_flag, 1 );
3894: dbms_sql.define_column( p_select_c, 9,
3895: p_select_rec.commitment_trx_id );
3896: dbms_sql.define_column( p_select_c, 10, p_select_rec.percent );
3897: dbms_sql.define_column( p_select_c, 11, p_select_rec.precision );
3898: dbms_sql.define_column( p_select_c, 12, p_select_rec.min_acc_unit );
3899: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date_closed );
3900: dbms_sql.define_column( p_select_c, 14, p_select_rec.actual_date_closed );
3893: p_select_rec.post_to_gl_flag, 1 );
3894: dbms_sql.define_column( p_select_c, 9,
3895: p_select_rec.commitment_trx_id );
3896: dbms_sql.define_column( p_select_c, 10, p_select_rec.percent );
3897: dbms_sql.define_column( p_select_c, 11, p_select_rec.precision );
3898: dbms_sql.define_column( p_select_c, 12, p_select_rec.min_acc_unit );
3899: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date_closed );
3900: dbms_sql.define_column( p_select_c, 14, p_select_rec.actual_date_closed );
3901: dbms_sql.define_column( p_select_c, 15, p_select_rec.trx_date );
3894: dbms_sql.define_column( p_select_c, 9,
3895: p_select_rec.commitment_trx_id );
3896: dbms_sql.define_column( p_select_c, 10, p_select_rec.percent );
3897: dbms_sql.define_column( p_select_c, 11, p_select_rec.precision );
3898: dbms_sql.define_column( p_select_c, 12, p_select_rec.min_acc_unit );
3899: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date_closed );
3900: dbms_sql.define_column( p_select_c, 14, p_select_rec.actual_date_closed );
3901: dbms_sql.define_column( p_select_c, 15, p_select_rec.trx_date );
3902: dbms_sql.define_column( p_select_c, 16, p_select_rec.commitment_type, 20 );
3895: p_select_rec.commitment_trx_id );
3896: dbms_sql.define_column( p_select_c, 10, p_select_rec.percent );
3897: dbms_sql.define_column( p_select_c, 11, p_select_rec.precision );
3898: dbms_sql.define_column( p_select_c, 12, p_select_rec.min_acc_unit );
3899: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date_closed );
3900: dbms_sql.define_column( p_select_c, 14, p_select_rec.actual_date_closed );
3901: dbms_sql.define_column( p_select_c, 15, p_select_rec.trx_date );
3902: dbms_sql.define_column( p_select_c, 16, p_select_rec.commitment_type, 20 );
3903: dbms_sql.define_column( p_select_c, 17, p_select_rec.line_remaining );
3896: dbms_sql.define_column( p_select_c, 10, p_select_rec.percent );
3897: dbms_sql.define_column( p_select_c, 11, p_select_rec.precision );
3898: dbms_sql.define_column( p_select_c, 12, p_select_rec.min_acc_unit );
3899: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date_closed );
3900: dbms_sql.define_column( p_select_c, 14, p_select_rec.actual_date_closed );
3901: dbms_sql.define_column( p_select_c, 15, p_select_rec.trx_date );
3902: dbms_sql.define_column( p_select_c, 16, p_select_rec.commitment_type, 20 );
3903: dbms_sql.define_column( p_select_c, 17, p_select_rec.line_remaining );
3904: dbms_sql.define_column( p_select_c, 18,
3897: dbms_sql.define_column( p_select_c, 11, p_select_rec.precision );
3898: dbms_sql.define_column( p_select_c, 12, p_select_rec.min_acc_unit );
3899: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date_closed );
3900: dbms_sql.define_column( p_select_c, 14, p_select_rec.actual_date_closed );
3901: dbms_sql.define_column( p_select_c, 15, p_select_rec.trx_date );
3902: dbms_sql.define_column( p_select_c, 16, p_select_rec.commitment_type, 20 );
3903: dbms_sql.define_column( p_select_c, 17, p_select_rec.line_remaining );
3904: dbms_sql.define_column( p_select_c, 18,
3905: p_select_rec.amount_due_remaining );
3898: dbms_sql.define_column( p_select_c, 12, p_select_rec.min_acc_unit );
3899: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date_closed );
3900: dbms_sql.define_column( p_select_c, 14, p_select_rec.actual_date_closed );
3901: dbms_sql.define_column( p_select_c, 15, p_select_rec.trx_date );
3902: dbms_sql.define_column( p_select_c, 16, p_select_rec.commitment_type, 20 );
3903: dbms_sql.define_column( p_select_c, 17, p_select_rec.line_remaining );
3904: dbms_sql.define_column( p_select_c, 18,
3905: p_select_rec.amount_due_remaining );
3906: dbms_sql.define_column( p_select_c, 19,
3899: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date_closed );
3900: dbms_sql.define_column( p_select_c, 14, p_select_rec.actual_date_closed );
3901: dbms_sql.define_column( p_select_c, 15, p_select_rec.trx_date );
3902: dbms_sql.define_column( p_select_c, 16, p_select_rec.commitment_type, 20 );
3903: dbms_sql.define_column( p_select_c, 17, p_select_rec.line_remaining );
3904: dbms_sql.define_column( p_select_c, 18,
3905: p_select_rec.amount_due_remaining );
3906: dbms_sql.define_column( p_select_c, 19,
3907: p_select_rec.acctd_amt_due_rem );
3900: dbms_sql.define_column( p_select_c, 14, p_select_rec.actual_date_closed );
3901: dbms_sql.define_column( p_select_c, 15, p_select_rec.trx_date );
3902: dbms_sql.define_column( p_select_c, 16, p_select_rec.commitment_type, 20 );
3903: dbms_sql.define_column( p_select_c, 17, p_select_rec.line_remaining );
3904: dbms_sql.define_column( p_select_c, 18,
3905: p_select_rec.amount_due_remaining );
3906: dbms_sql.define_column( p_select_c, 19,
3907: p_select_rec.acctd_amt_due_rem );
3908: dbms_sql.define_column( p_select_c, 20,
3902: dbms_sql.define_column( p_select_c, 16, p_select_rec.commitment_type, 20 );
3903: dbms_sql.define_column( p_select_c, 17, p_select_rec.line_remaining );
3904: dbms_sql.define_column( p_select_c, 18,
3905: p_select_rec.amount_due_remaining );
3906: dbms_sql.define_column( p_select_c, 19,
3907: p_select_rec.acctd_amt_due_rem );
3908: dbms_sql.define_column( p_select_c, 20,
3909: p_select_rec.amount_adjusted );
3910: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
3904: dbms_sql.define_column( p_select_c, 18,
3905: p_select_rec.amount_due_remaining );
3906: dbms_sql.define_column( p_select_c, 19,
3907: p_select_rec.acctd_amt_due_rem );
3908: dbms_sql.define_column( p_select_c, 20,
3909: p_select_rec.amount_adjusted );
3910: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
3911: dbms_sql.define_column( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3912: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
3906: dbms_sql.define_column( p_select_c, 19,
3907: p_select_rec.acctd_amt_due_rem );
3908: dbms_sql.define_column( p_select_c, 20,
3909: p_select_rec.amount_adjusted );
3910: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
3911: dbms_sql.define_column( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3912: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
3913: dbms_sql.define_column( p_select_c, 24, p_select_rec.customer_trx_id );
3914: dbms_sql.define_column( p_select_c, 25,
3907: p_select_rec.acctd_amt_due_rem );
3908: dbms_sql.define_column( p_select_c, 20,
3909: p_select_rec.amount_adjusted );
3910: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
3911: dbms_sql.define_column( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3912: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
3913: dbms_sql.define_column( p_select_c, 24, p_select_rec.customer_trx_id );
3914: dbms_sql.define_column( p_select_c, 25,
3915: p_select_rec.ps_currency_code, 15 );
3908: dbms_sql.define_column( p_select_c, 20,
3909: p_select_rec.amount_adjusted );
3910: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
3911: dbms_sql.define_column( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3912: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
3913: dbms_sql.define_column( p_select_c, 24, p_select_rec.customer_trx_id );
3914: dbms_sql.define_column( p_select_c, 25,
3915: p_select_rec.ps_currency_code, 15 );
3916: -- 1483656 new columns for allocating tax and freight
3909: p_select_rec.amount_adjusted );
3910: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
3911: dbms_sql.define_column( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3912: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
3913: dbms_sql.define_column( p_select_c, 24, p_select_rec.customer_trx_id );
3914: dbms_sql.define_column( p_select_c, 25,
3915: p_select_rec.ps_currency_code, 15 );
3916: -- 1483656 new columns for allocating tax and freight
3917: dbms_sql.define_column( p_select_c, 26, p_select_rec.allocate_tax_freight,1 );
3910: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
3911: dbms_sql.define_column( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3912: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
3913: dbms_sql.define_column( p_select_c, 24, p_select_rec.customer_trx_id );
3914: dbms_sql.define_column( p_select_c, 25,
3915: p_select_rec.ps_currency_code, 15 );
3916: -- 1483656 new columns for allocating tax and freight
3917: dbms_sql.define_column( p_select_c, 26, p_select_rec.allocate_tax_freight,1 );
3918: dbms_sql.define_column( p_select_c, 27, p_select_rec.adjustment_type,8 );
3913: dbms_sql.define_column( p_select_c, 24, p_select_rec.customer_trx_id );
3914: dbms_sql.define_column( p_select_c, 25,
3915: p_select_rec.ps_currency_code, 15 );
3916: -- 1483656 new columns for allocating tax and freight
3917: dbms_sql.define_column( p_select_c, 26, p_select_rec.allocate_tax_freight,1 );
3918: dbms_sql.define_column( p_select_c, 27, p_select_rec.adjustment_type,8 );
3919: dbms_sql.define_column( p_select_c, 28, p_select_rec.tax_remaining );
3920: dbms_sql.define_column( p_select_c, 29, p_select_rec.freight_remaining );
3921: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_tax_amount );
3914: dbms_sql.define_column( p_select_c, 25,
3915: p_select_rec.ps_currency_code, 15 );
3916: -- 1483656 new columns for allocating tax and freight
3917: dbms_sql.define_column( p_select_c, 26, p_select_rec.allocate_tax_freight,1 );
3918: dbms_sql.define_column( p_select_c, 27, p_select_rec.adjustment_type,8 );
3919: dbms_sql.define_column( p_select_c, 28, p_select_rec.tax_remaining );
3920: dbms_sql.define_column( p_select_c, 29, p_select_rec.freight_remaining );
3921: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_tax_amount );
3922: dbms_sql.define_column( p_select_c, 31, p_select_rec.total_freight_amount );
3915: p_select_rec.ps_currency_code, 15 );
3916: -- 1483656 new columns for allocating tax and freight
3917: dbms_sql.define_column( p_select_c, 26, p_select_rec.allocate_tax_freight,1 );
3918: dbms_sql.define_column( p_select_c, 27, p_select_rec.adjustment_type,8 );
3919: dbms_sql.define_column( p_select_c, 28, p_select_rec.tax_remaining );
3920: dbms_sql.define_column( p_select_c, 29, p_select_rec.freight_remaining );
3921: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_tax_amount );
3922: dbms_sql.define_column( p_select_c, 31, p_select_rec.total_freight_amount );
3923:
3916: -- 1483656 new columns for allocating tax and freight
3917: dbms_sql.define_column( p_select_c, 26, p_select_rec.allocate_tax_freight,1 );
3918: dbms_sql.define_column( p_select_c, 27, p_select_rec.adjustment_type,8 );
3919: dbms_sql.define_column( p_select_c, 28, p_select_rec.tax_remaining );
3920: dbms_sql.define_column( p_select_c, 29, p_select_rec.freight_remaining );
3921: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_tax_amount );
3922: dbms_sql.define_column( p_select_c, 31, p_select_rec.total_freight_amount );
3923:
3924: print_fcn_label2( 'arp_maintain_ps2.define_ups_select_columns()-' );
3917: dbms_sql.define_column( p_select_c, 26, p_select_rec.allocate_tax_freight,1 );
3918: dbms_sql.define_column( p_select_c, 27, p_select_rec.adjustment_type,8 );
3919: dbms_sql.define_column( p_select_c, 28, p_select_rec.tax_remaining );
3920: dbms_sql.define_column( p_select_c, 29, p_select_rec.freight_remaining );
3921: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_tax_amount );
3922: dbms_sql.define_column( p_select_c, 31, p_select_rec.total_freight_amount );
3923:
3924: print_fcn_label2( 'arp_maintain_ps2.define_ups_select_columns()-' );
3925:
3918: dbms_sql.define_column( p_select_c, 27, p_select_rec.adjustment_type,8 );
3919: dbms_sql.define_column( p_select_c, 28, p_select_rec.tax_remaining );
3920: dbms_sql.define_column( p_select_c, 29, p_select_rec.freight_remaining );
3921: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_tax_amount );
3922: dbms_sql.define_column( p_select_c, 31, p_select_rec.total_freight_amount );
3923:
3924: print_fcn_label2( 'arp_maintain_ps2.define_ups_select_columns()-' );
3925:
3926: EXCEPTION
3937: /* Bug 460927 - Changed IN to IN OUT in the above line - Oracle 8 */
3938: BEGIN
3939: print_fcn_label2( 'arp_maintain_ps2.get_ups_column_values()+' );
3940:
3941: dbms_sql.column_value( p_select_c, 1, p_select_rec.set_of_books_id );
3942: dbms_sql.column_value( p_select_c, 2, p_select_rec.total_line_amount );
3943: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
3944: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
3945: dbms_sql.column_value( p_select_c, 5,
3938: BEGIN
3939: print_fcn_label2( 'arp_maintain_ps2.get_ups_column_values()+' );
3940:
3941: dbms_sql.column_value( p_select_c, 1, p_select_rec.set_of_books_id );
3942: dbms_sql.column_value( p_select_c, 2, p_select_rec.total_line_amount );
3943: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
3944: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
3945: dbms_sql.column_value( p_select_c, 5,
3946: p_select_rec.adjusted_trx_id );
3939: print_fcn_label2( 'arp_maintain_ps2.get_ups_column_values()+' );
3940:
3941: dbms_sql.column_value( p_select_c, 1, p_select_rec.set_of_books_id );
3942: dbms_sql.column_value( p_select_c, 2, p_select_rec.total_line_amount );
3943: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
3944: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
3945: dbms_sql.column_value( p_select_c, 5,
3946: p_select_rec.adjusted_trx_id );
3947: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
3940:
3941: dbms_sql.column_value( p_select_c, 1, p_select_rec.set_of_books_id );
3942: dbms_sql.column_value( p_select_c, 2, p_select_rec.total_line_amount );
3943: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
3944: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
3945: dbms_sql.column_value( p_select_c, 5,
3946: p_select_rec.adjusted_trx_id );
3947: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
3948: dbms_sql.column_value( p_select_c, 7, p_select_rec.subsequent_trx_id );
3941: dbms_sql.column_value( p_select_c, 1, p_select_rec.set_of_books_id );
3942: dbms_sql.column_value( p_select_c, 2, p_select_rec.total_line_amount );
3943: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
3944: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
3945: dbms_sql.column_value( p_select_c, 5,
3946: p_select_rec.adjusted_trx_id );
3947: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
3948: dbms_sql.column_value( p_select_c, 7, p_select_rec.subsequent_trx_id );
3949: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
3943: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
3944: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
3945: dbms_sql.column_value( p_select_c, 5,
3946: p_select_rec.adjusted_trx_id );
3947: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
3948: dbms_sql.column_value( p_select_c, 7, p_select_rec.subsequent_trx_id );
3949: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
3950: dbms_sql.column_value( p_select_c, 9, p_select_rec.commitment_trx_id );
3951: dbms_sql.column_value( p_select_c, 10, p_select_rec.percent );
3944: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
3945: dbms_sql.column_value( p_select_c, 5,
3946: p_select_rec.adjusted_trx_id );
3947: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
3948: dbms_sql.column_value( p_select_c, 7, p_select_rec.subsequent_trx_id );
3949: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
3950: dbms_sql.column_value( p_select_c, 9, p_select_rec.commitment_trx_id );
3951: dbms_sql.column_value( p_select_c, 10, p_select_rec.percent );
3952: dbms_sql.column_value( p_select_c, 11, p_select_rec.precision );
3945: dbms_sql.column_value( p_select_c, 5,
3946: p_select_rec.adjusted_trx_id );
3947: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
3948: dbms_sql.column_value( p_select_c, 7, p_select_rec.subsequent_trx_id );
3949: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
3950: dbms_sql.column_value( p_select_c, 9, p_select_rec.commitment_trx_id );
3951: dbms_sql.column_value( p_select_c, 10, p_select_rec.percent );
3952: dbms_sql.column_value( p_select_c, 11, p_select_rec.precision );
3953: dbms_sql.column_value( p_select_c, 12, p_select_rec.min_acc_unit );
3946: p_select_rec.adjusted_trx_id );
3947: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
3948: dbms_sql.column_value( p_select_c, 7, p_select_rec.subsequent_trx_id );
3949: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
3950: dbms_sql.column_value( p_select_c, 9, p_select_rec.commitment_trx_id );
3951: dbms_sql.column_value( p_select_c, 10, p_select_rec.percent );
3952: dbms_sql.column_value( p_select_c, 11, p_select_rec.precision );
3953: dbms_sql.column_value( p_select_c, 12, p_select_rec.min_acc_unit );
3954: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date_closed );
3947: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
3948: dbms_sql.column_value( p_select_c, 7, p_select_rec.subsequent_trx_id );
3949: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
3950: dbms_sql.column_value( p_select_c, 9, p_select_rec.commitment_trx_id );
3951: dbms_sql.column_value( p_select_c, 10, p_select_rec.percent );
3952: dbms_sql.column_value( p_select_c, 11, p_select_rec.precision );
3953: dbms_sql.column_value( p_select_c, 12, p_select_rec.min_acc_unit );
3954: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date_closed );
3955: dbms_sql.column_value( p_select_c, 14, p_select_rec.actual_date_closed );
3948: dbms_sql.column_value( p_select_c, 7, p_select_rec.subsequent_trx_id );
3949: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
3950: dbms_sql.column_value( p_select_c, 9, p_select_rec.commitment_trx_id );
3951: dbms_sql.column_value( p_select_c, 10, p_select_rec.percent );
3952: dbms_sql.column_value( p_select_c, 11, p_select_rec.precision );
3953: dbms_sql.column_value( p_select_c, 12, p_select_rec.min_acc_unit );
3954: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date_closed );
3955: dbms_sql.column_value( p_select_c, 14, p_select_rec.actual_date_closed );
3956: dbms_sql.column_value( p_select_c, 15, p_select_rec.trx_date );
3949: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
3950: dbms_sql.column_value( p_select_c, 9, p_select_rec.commitment_trx_id );
3951: dbms_sql.column_value( p_select_c, 10, p_select_rec.percent );
3952: dbms_sql.column_value( p_select_c, 11, p_select_rec.precision );
3953: dbms_sql.column_value( p_select_c, 12, p_select_rec.min_acc_unit );
3954: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date_closed );
3955: dbms_sql.column_value( p_select_c, 14, p_select_rec.actual_date_closed );
3956: dbms_sql.column_value( p_select_c, 15, p_select_rec.trx_date );
3957: dbms_sql.column_value( p_select_c, 16, p_select_rec.commitment_type );
3950: dbms_sql.column_value( p_select_c, 9, p_select_rec.commitment_trx_id );
3951: dbms_sql.column_value( p_select_c, 10, p_select_rec.percent );
3952: dbms_sql.column_value( p_select_c, 11, p_select_rec.precision );
3953: dbms_sql.column_value( p_select_c, 12, p_select_rec.min_acc_unit );
3954: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date_closed );
3955: dbms_sql.column_value( p_select_c, 14, p_select_rec.actual_date_closed );
3956: dbms_sql.column_value( p_select_c, 15, p_select_rec.trx_date );
3957: dbms_sql.column_value( p_select_c, 16, p_select_rec.commitment_type );
3958: dbms_sql.column_value( p_select_c, 17, p_select_rec.line_remaining );
3951: dbms_sql.column_value( p_select_c, 10, p_select_rec.percent );
3952: dbms_sql.column_value( p_select_c, 11, p_select_rec.precision );
3953: dbms_sql.column_value( p_select_c, 12, p_select_rec.min_acc_unit );
3954: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date_closed );
3955: dbms_sql.column_value( p_select_c, 14, p_select_rec.actual_date_closed );
3956: dbms_sql.column_value( p_select_c, 15, p_select_rec.trx_date );
3957: dbms_sql.column_value( p_select_c, 16, p_select_rec.commitment_type );
3958: dbms_sql.column_value( p_select_c, 17, p_select_rec.line_remaining );
3959: dbms_sql.column_value( p_select_c, 18,
3952: dbms_sql.column_value( p_select_c, 11, p_select_rec.precision );
3953: dbms_sql.column_value( p_select_c, 12, p_select_rec.min_acc_unit );
3954: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date_closed );
3955: dbms_sql.column_value( p_select_c, 14, p_select_rec.actual_date_closed );
3956: dbms_sql.column_value( p_select_c, 15, p_select_rec.trx_date );
3957: dbms_sql.column_value( p_select_c, 16, p_select_rec.commitment_type );
3958: dbms_sql.column_value( p_select_c, 17, p_select_rec.line_remaining );
3959: dbms_sql.column_value( p_select_c, 18,
3960: p_select_rec.amount_due_remaining );
3953: dbms_sql.column_value( p_select_c, 12, p_select_rec.min_acc_unit );
3954: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date_closed );
3955: dbms_sql.column_value( p_select_c, 14, p_select_rec.actual_date_closed );
3956: dbms_sql.column_value( p_select_c, 15, p_select_rec.trx_date );
3957: dbms_sql.column_value( p_select_c, 16, p_select_rec.commitment_type );
3958: dbms_sql.column_value( p_select_c, 17, p_select_rec.line_remaining );
3959: dbms_sql.column_value( p_select_c, 18,
3960: p_select_rec.amount_due_remaining );
3961: dbms_sql.column_value( p_select_c, 19, p_select_rec.acctd_amt_due_rem );
3954: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date_closed );
3955: dbms_sql.column_value( p_select_c, 14, p_select_rec.actual_date_closed );
3956: dbms_sql.column_value( p_select_c, 15, p_select_rec.trx_date );
3957: dbms_sql.column_value( p_select_c, 16, p_select_rec.commitment_type );
3958: dbms_sql.column_value( p_select_c, 17, p_select_rec.line_remaining );
3959: dbms_sql.column_value( p_select_c, 18,
3960: p_select_rec.amount_due_remaining );
3961: dbms_sql.column_value( p_select_c, 19, p_select_rec.acctd_amt_due_rem );
3962: dbms_sql.column_value( p_select_c, 20, p_select_rec.amount_adjusted );
3955: dbms_sql.column_value( p_select_c, 14, p_select_rec.actual_date_closed );
3956: dbms_sql.column_value( p_select_c, 15, p_select_rec.trx_date );
3957: dbms_sql.column_value( p_select_c, 16, p_select_rec.commitment_type );
3958: dbms_sql.column_value( p_select_c, 17, p_select_rec.line_remaining );
3959: dbms_sql.column_value( p_select_c, 18,
3960: p_select_rec.amount_due_remaining );
3961: dbms_sql.column_value( p_select_c, 19, p_select_rec.acctd_amt_due_rem );
3962: dbms_sql.column_value( p_select_c, 20, p_select_rec.amount_adjusted );
3963: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
3957: dbms_sql.column_value( p_select_c, 16, p_select_rec.commitment_type );
3958: dbms_sql.column_value( p_select_c, 17, p_select_rec.line_remaining );
3959: dbms_sql.column_value( p_select_c, 18,
3960: p_select_rec.amount_due_remaining );
3961: dbms_sql.column_value( p_select_c, 19, p_select_rec.acctd_amt_due_rem );
3962: dbms_sql.column_value( p_select_c, 20, p_select_rec.amount_adjusted );
3963: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
3964: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3965: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
3958: dbms_sql.column_value( p_select_c, 17, p_select_rec.line_remaining );
3959: dbms_sql.column_value( p_select_c, 18,
3960: p_select_rec.amount_due_remaining );
3961: dbms_sql.column_value( p_select_c, 19, p_select_rec.acctd_amt_due_rem );
3962: dbms_sql.column_value( p_select_c, 20, p_select_rec.amount_adjusted );
3963: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
3964: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3965: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
3966: dbms_sql.column_value( p_select_c, 24, p_select_rec.customer_trx_id );
3959: dbms_sql.column_value( p_select_c, 18,
3960: p_select_rec.amount_due_remaining );
3961: dbms_sql.column_value( p_select_c, 19, p_select_rec.acctd_amt_due_rem );
3962: dbms_sql.column_value( p_select_c, 20, p_select_rec.amount_adjusted );
3963: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
3964: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3965: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
3966: dbms_sql.column_value( p_select_c, 24, p_select_rec.customer_trx_id );
3967: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_currency_code );
3960: p_select_rec.amount_due_remaining );
3961: dbms_sql.column_value( p_select_c, 19, p_select_rec.acctd_amt_due_rem );
3962: dbms_sql.column_value( p_select_c, 20, p_select_rec.amount_adjusted );
3963: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
3964: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3965: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
3966: dbms_sql.column_value( p_select_c, 24, p_select_rec.customer_trx_id );
3967: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_currency_code );
3968: -- 1483656 new columns for allocating tax and freight
3961: dbms_sql.column_value( p_select_c, 19, p_select_rec.acctd_amt_due_rem );
3962: dbms_sql.column_value( p_select_c, 20, p_select_rec.amount_adjusted );
3963: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
3964: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3965: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
3966: dbms_sql.column_value( p_select_c, 24, p_select_rec.customer_trx_id );
3967: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_currency_code );
3968: -- 1483656 new columns for allocating tax and freight
3969: dbms_sql.column_value( p_select_c, 26, p_select_rec.allocate_tax_freight );
3962: dbms_sql.column_value( p_select_c, 20, p_select_rec.amount_adjusted );
3963: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
3964: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3965: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
3966: dbms_sql.column_value( p_select_c, 24, p_select_rec.customer_trx_id );
3967: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_currency_code );
3968: -- 1483656 new columns for allocating tax and freight
3969: dbms_sql.column_value( p_select_c, 26, p_select_rec.allocate_tax_freight );
3970: dbms_sql.column_value( p_select_c, 27, p_select_rec.adjustment_type );
3963: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
3964: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3965: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
3966: dbms_sql.column_value( p_select_c, 24, p_select_rec.customer_trx_id );
3967: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_currency_code );
3968: -- 1483656 new columns for allocating tax and freight
3969: dbms_sql.column_value( p_select_c, 26, p_select_rec.allocate_tax_freight );
3970: dbms_sql.column_value( p_select_c, 27, p_select_rec.adjustment_type );
3971: dbms_sql.column_value( p_select_c, 28, p_select_rec.tax_remaining );
3965: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
3966: dbms_sql.column_value( p_select_c, 24, p_select_rec.customer_trx_id );
3967: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_currency_code );
3968: -- 1483656 new columns for allocating tax and freight
3969: dbms_sql.column_value( p_select_c, 26, p_select_rec.allocate_tax_freight );
3970: dbms_sql.column_value( p_select_c, 27, p_select_rec.adjustment_type );
3971: dbms_sql.column_value( p_select_c, 28, p_select_rec.tax_remaining );
3972: dbms_sql.column_value( p_select_c, 29, p_select_rec.freight_remaining );
3973: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_tax_amount );
3966: dbms_sql.column_value( p_select_c, 24, p_select_rec.customer_trx_id );
3967: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_currency_code );
3968: -- 1483656 new columns for allocating tax and freight
3969: dbms_sql.column_value( p_select_c, 26, p_select_rec.allocate_tax_freight );
3970: dbms_sql.column_value( p_select_c, 27, p_select_rec.adjustment_type );
3971: dbms_sql.column_value( p_select_c, 28, p_select_rec.tax_remaining );
3972: dbms_sql.column_value( p_select_c, 29, p_select_rec.freight_remaining );
3973: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_tax_amount );
3974: dbms_sql.column_value( p_select_c, 31, p_select_rec.total_freight_amount );
3967: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_currency_code );
3968: -- 1483656 new columns for allocating tax and freight
3969: dbms_sql.column_value( p_select_c, 26, p_select_rec.allocate_tax_freight );
3970: dbms_sql.column_value( p_select_c, 27, p_select_rec.adjustment_type );
3971: dbms_sql.column_value( p_select_c, 28, p_select_rec.tax_remaining );
3972: dbms_sql.column_value( p_select_c, 29, p_select_rec.freight_remaining );
3973: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_tax_amount );
3974: dbms_sql.column_value( p_select_c, 31, p_select_rec.total_freight_amount );
3975:
3968: -- 1483656 new columns for allocating tax and freight
3969: dbms_sql.column_value( p_select_c, 26, p_select_rec.allocate_tax_freight );
3970: dbms_sql.column_value( p_select_c, 27, p_select_rec.adjustment_type );
3971: dbms_sql.column_value( p_select_c, 28, p_select_rec.tax_remaining );
3972: dbms_sql.column_value( p_select_c, 29, p_select_rec.freight_remaining );
3973: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_tax_amount );
3974: dbms_sql.column_value( p_select_c, 31, p_select_rec.total_freight_amount );
3975:
3976: print_fcn_label2( 'arp_maintain_ps2.get_ups_column_values()-' );
3969: dbms_sql.column_value( p_select_c, 26, p_select_rec.allocate_tax_freight );
3970: dbms_sql.column_value( p_select_c, 27, p_select_rec.adjustment_type );
3971: dbms_sql.column_value( p_select_c, 28, p_select_rec.tax_remaining );
3972: dbms_sql.column_value( p_select_c, 29, p_select_rec.freight_remaining );
3973: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_tax_amount );
3974: dbms_sql.column_value( p_select_c, 31, p_select_rec.total_freight_amount );
3975:
3976: print_fcn_label2( 'arp_maintain_ps2.get_ups_column_values()-' );
3977: EXCEPTION
3970: dbms_sql.column_value( p_select_c, 27, p_select_rec.adjustment_type );
3971: dbms_sql.column_value( p_select_c, 28, p_select_rec.tax_remaining );
3972: dbms_sql.column_value( p_select_c, 29, p_select_rec.freight_remaining );
3973: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_tax_amount );
3974: dbms_sql.column_value( p_select_c, 31, p_select_rec.total_freight_amount );
3975:
3976: print_fcn_label2( 'arp_maintain_ps2.get_ups_column_values()-' );
3977: EXCEPTION
3978: WHEN OTHERS THEN
4408: -------------------------------------------------------------
4409: BEGIN
4410: debug( ' Binding insert_adj_c', MSG_LEVEL_DEBUG );
4411:
4412: dbms_sql.bind_variable( p_insert_adj_c,
4413: 'user_id',
4414: p_profile_info.user_id );
4415:
4416: dbms_sql.bind_variable( p_insert_adj_c,
4412: dbms_sql.bind_variable( p_insert_adj_c,
4413: 'user_id',
4414: p_profile_info.user_id );
4415:
4416: dbms_sql.bind_variable( p_insert_adj_c,
4417: 'login_id',
4418: p_profile_info.conc_login_id );
4419:
4420: dbms_sql.bind_variable( p_insert_adj_c,
4416: dbms_sql.bind_variable( p_insert_adj_c,
4417: 'login_id',
4418: p_profile_info.conc_login_id );
4419:
4420: dbms_sql.bind_variable( p_insert_adj_c,
4421: 'request_id',
4422: p_profile_info.request_id );
4423:
4424: dbms_sql.bind_variable( p_insert_adj_c,
4420: dbms_sql.bind_variable( p_insert_adj_c,
4421: 'request_id',
4422: p_profile_info.request_id );
4423:
4424: dbms_sql.bind_variable( p_insert_adj_c,
4425: 'application_id',
4426: p_profile_info.application_id );
4427:
4428: dbms_sql.bind_variable( p_insert_adj_c,
4424: dbms_sql.bind_variable( p_insert_adj_c,
4425: 'application_id',
4426: p_profile_info.application_id );
4427:
4428: dbms_sql.bind_variable( p_insert_adj_c,
4429: 'program_id',
4430: p_profile_info.conc_program_id );
4431:
4432:
4429: 'program_id',
4430: p_profile_info.conc_program_id );
4431:
4432:
4433: dbms_sql.bind_variable(
4434: p_insert_adj_c,
4435: 'set_of_books_id',
4436: p_select_rec.set_of_books_id );
4437:
4434: p_insert_adj_c,
4435: 'set_of_books_id',
4436: p_select_rec.set_of_books_id );
4437:
4438: dbms_sql.bind_variable( p_insert_adj_c,
4439: 'trx_date',
4440: p_select_rec.trx_date );
4441:
4442: dbms_sql.bind_variable( p_insert_adj_c,
4438: dbms_sql.bind_variable( p_insert_adj_c,
4439: 'trx_date',
4440: p_select_rec.trx_date );
4441:
4442: dbms_sql.bind_variable( p_insert_adj_c,
4443: 'gl_date',
4444: p_select_rec.gl_date );
4445:
4446: dbms_sql.bind_variable( p_insert_adj_c,
4442: dbms_sql.bind_variable( p_insert_adj_c,
4443: 'gl_date',
4444: p_select_rec.gl_date );
4445:
4446: dbms_sql.bind_variable( p_insert_adj_c,
4447: 'code_combination_id',
4448: p_select_rec.code_combination_id );
4449:
4450: dbms_sql.bind_variable( p_insert_adj_c,
4446: dbms_sql.bind_variable( p_insert_adj_c,
4447: 'code_combination_id',
4448: p_select_rec.code_combination_id );
4449:
4450: dbms_sql.bind_variable( p_insert_adj_c,
4451: 'adjusted_trx_id',
4452: p_select_rec.adjusted_trx_id );
4453:
4454: dbms_sql.bind_variable( p_insert_adj_c,
4450: dbms_sql.bind_variable( p_insert_adj_c,
4451: 'adjusted_trx_id',
4452: p_select_rec.adjusted_trx_id );
4453:
4454: dbms_sql.bind_variable( p_insert_adj_c,
4455: 'payment_schedule_id',
4456: p_ps_id_t( i ) );
4457:
4458: dbms_sql.bind_variable( p_insert_adj_c,
4454: dbms_sql.bind_variable( p_insert_adj_c,
4455: 'payment_schedule_id',
4456: p_ps_id_t( i ) );
4457:
4458: dbms_sql.bind_variable( p_insert_adj_c,
4459: 'subsequent_trx_id',
4460: p_select_rec.subsequent_trx_id );
4461:
4462: dbms_sql.bind_variable( p_insert_adj_c,
4458: dbms_sql.bind_variable( p_insert_adj_c,
4459: 'subsequent_trx_id',
4460: p_select_rec.subsequent_trx_id );
4461:
4462: dbms_sql.bind_variable( p_insert_adj_c,
4463: 'post_to_gl_flag',
4464: p_select_rec.post_to_gl_flag );
4465:
4466: dbms_sql.bind_variable( p_insert_adj_c,
4462: dbms_sql.bind_variable( p_insert_adj_c,
4463: 'post_to_gl_flag',
4464: p_select_rec.post_to_gl_flag );
4465:
4466: dbms_sql.bind_variable( p_insert_adj_c,
4467: 'adj_amount',
4468: p_adj_amount_t( i ) );
4469:
4470: dbms_sql.bind_variable( p_insert_adj_c,
4466: dbms_sql.bind_variable( p_insert_adj_c,
4467: 'adj_amount',
4468: p_adj_amount_t( i ) );
4469:
4470: dbms_sql.bind_variable( p_insert_adj_c,
4471: 'acctd_adj_amount',
4472: p_acctd_adj_amount_t( i ) );
4473:
4474: /* VAT changes */
4475: SELECT ar_adjustments_s.nextval
4476: INTO l_adjustment_id
4477: FROM dual;
4478:
4479: dbms_sql.bind_variable( p_insert_adj_c,
4480: 'adjustment_id',
4481: l_adjustment_id );
4482:
4483: -- 1483656 - allocating tax and freight against commitments
4480: 'adjustment_id',
4481: l_adjustment_id );
4482:
4483: -- 1483656 - allocating tax and freight against commitments
4484: dbms_sql.bind_variable (p_insert_adj_c,
4485: 'tax_adj_amount',
4486: p_tax_adj_t(i) );
4487:
4488: dbms_sql.bind_variable (p_insert_adj_c,
4484: dbms_sql.bind_variable (p_insert_adj_c,
4485: 'tax_adj_amount',
4486: p_tax_adj_t(i) );
4487:
4488: dbms_sql.bind_variable (p_insert_adj_c,
4489: 'frt_adj_amount',
4490: p_frt_adj_t(i) );
4491:
4492: dbms_sql.bind_variable (p_insert_adj_c,
4488: dbms_sql.bind_variable (p_insert_adj_c,
4489: 'frt_adj_amount',
4490: p_frt_adj_t(i) );
4491:
4492: dbms_sql.bind_variable (p_insert_adj_c,
4493: 'line_adj_amount',
4494: p_line_adj_t(i) );
4495:
4496: dbms_sql.bind_variable (p_insert_adj_c,
4492: dbms_sql.bind_variable (p_insert_adj_c,
4493: 'line_adj_amount',
4494: p_line_adj_t(i) );
4495:
4496: dbms_sql.bind_variable (p_insert_adj_c,
4497: 'adjust_type',
4498: p_select_rec.adjustment_type);
4499:
4500: --begin anuj
4497: 'adjust_type',
4498: p_select_rec.adjustment_type);
4499:
4500: --begin anuj
4501: dbms_sql.bind_variable (p_insert_adj_c,
4502: 'org_id',
4503: arp_standard.sysparm.org_id /* SSA changes anuj */);
4504: --end anuj
4505:
4514: -- Execute
4515: -------------------------------------------------------------
4516: BEGIN
4517: debug( ' Inserting adjustments', MSG_LEVEL_DEBUG );
4518: l_ignore := dbms_sql.execute( p_insert_adj_c );
4519: debug( to_char(l_ignore) || ' row(s) inserted',
4520: MSG_LEVEL_DEBUG );
4521:
4522: /*-------------------------------------------+
4547: -------------------------------------------------------------
4548: BEGIN
4549: debug( ' Binding update_ps_c', MSG_LEVEL_DEBUG );
4550:
4551: dbms_sql.bind_variable( p_update_ps_c,
4552: 'user_id',
4553: p_profile_info.user_id );
4554:
4555: dbms_sql.bind_variable( p_update_ps_c,
4551: dbms_sql.bind_variable( p_update_ps_c,
4552: 'user_id',
4553: p_profile_info.user_id );
4554:
4555: dbms_sql.bind_variable( p_update_ps_c,
4556: 'login_id',
4557: p_profile_info.conc_login_id );
4558:
4559: dbms_sql.bind_variable( p_update_ps_c,
4555: dbms_sql.bind_variable( p_update_ps_c,
4556: 'login_id',
4557: p_profile_info.conc_login_id );
4558:
4559: dbms_sql.bind_variable( p_update_ps_c,
4560: 'amount_due_remaining',
4561: p_ps_amount_due_rem_t( i ) );
4562:
4563: dbms_sql.bind_variable( p_update_ps_c,
4559: dbms_sql.bind_variable( p_update_ps_c,
4560: 'amount_due_remaining',
4561: p_ps_amount_due_rem_t( i ) );
4562:
4563: dbms_sql.bind_variable( p_update_ps_c,
4564: 'gl_date_closed',
4565: p_select_rec.gl_date_closed );
4566:
4567: dbms_sql.bind_variable( p_update_ps_c,
4563: dbms_sql.bind_variable( p_update_ps_c,
4564: 'gl_date_closed',
4565: p_select_rec.gl_date_closed );
4566:
4567: dbms_sql.bind_variable( p_update_ps_c,
4568: 'actual_date_closed',
4569: p_select_rec.actual_date_closed );
4570:
4571: dbms_sql.bind_variable( p_update_ps_c,
4567: dbms_sql.bind_variable( p_update_ps_c,
4568: 'actual_date_closed',
4569: p_select_rec.actual_date_closed );
4570:
4571: dbms_sql.bind_variable( p_update_ps_c,
4572: 'amount_line_items_remaining',
4573: p_ps_line_rem_t( i ) );
4574:
4575: dbms_sql.bind_variable( p_update_ps_c,
4571: dbms_sql.bind_variable( p_update_ps_c,
4572: 'amount_line_items_remaining',
4573: p_ps_line_rem_t( i ) );
4574:
4575: dbms_sql.bind_variable( p_update_ps_c,
4576: 'amount_adjusted',
4577: p_ps_amount_adjusted_t( i ) );
4578:
4579: dbms_sql.bind_variable( p_update_ps_c,
4575: dbms_sql.bind_variable( p_update_ps_c,
4576: 'amount_adjusted',
4577: p_ps_amount_adjusted_t( i ) );
4578:
4579: dbms_sql.bind_variable( p_update_ps_c,
4580: 'acctd_amount_due_remaining',
4581: p_ps_acctd_amt_due_rem_t( i ) );
4582:
4583: dbms_sql.bind_variable( p_update_ps_c,
4579: dbms_sql.bind_variable( p_update_ps_c,
4580: 'acctd_amount_due_remaining',
4581: p_ps_acctd_amt_due_rem_t( i ) );
4582:
4583: dbms_sql.bind_variable( p_update_ps_c,
4584: 'payment_schedule_id',
4585: p_ps_id_t( i ) );
4586:
4587: /* 1483656 - Commitments Project */
4584: 'payment_schedule_id',
4585: p_ps_id_t( i ) );
4586:
4587: /* 1483656 - Commitments Project */
4588: dbms_sql.bind_variable( p_update_ps_c,
4589: 'tax_remaining',
4590: p_ps_tax_rem_t( i ) );
4591:
4592: dbms_sql.bind_variable( p_update_ps_c,
4588: dbms_sql.bind_variable( p_update_ps_c,
4589: 'tax_remaining',
4590: p_ps_tax_rem_t( i ) );
4591:
4592: dbms_sql.bind_variable( p_update_ps_c,
4593: 'freight_remaining',
4594: p_ps_freight_rem_t( i ) );
4595:
4596:
4605: -- Execute
4606: -------------------------------------------------------------
4607: BEGIN
4608: debug( ' Updating invoice payment schedules', MSG_LEVEL_DEBUG );
4609: l_ignore := dbms_sql.execute( p_update_ps_c );
4610: debug( to_char(l_ignore) || ' row(s) updated',
4611: MSG_LEVEL_DEBUG );
4612:
4613: /*-------------------------------------------+
4833: --
4834: clear_all_tables;
4835: --
4836:
4837: IF( NOT( dbms_sql.is_open( ups_select_c ) AND
4838: dbms_sql.is_open( ups_insert_adj_c ) AND
4839: dbms_sql.is_open( ups_update_ps_c ) )) THEN
4840:
4841: build_ups_sql(
4834: clear_all_tables;
4835: --
4836:
4837: IF( NOT( dbms_sql.is_open( ups_select_c ) AND
4838: dbms_sql.is_open( ups_insert_adj_c ) AND
4839: dbms_sql.is_open( ups_update_ps_c ) )) THEN
4840:
4841: build_ups_sql(
4842: system_info,
4835: --
4836:
4837: IF( NOT( dbms_sql.is_open( ups_select_c ) AND
4838: dbms_sql.is_open( ups_insert_adj_c ) AND
4839: dbms_sql.is_open( ups_update_ps_c ) )) THEN
4840:
4841: build_ups_sql(
4842: system_info,
4843: profile_info,
4851:
4852: ---------------------------------------------------------------
4853: -- Bind variables
4854: ---------------------------------------------------------------
4855: dbms_sql.bind_variable( ups_select_c,
4856: 'customer_trx_id',
4857: p_customer_trx_id );
4858:
4859: /* bug 3431804 - bind dates for latecoming deposits */
4856: 'customer_trx_id',
4857: p_customer_trx_id );
4858:
4859: /* bug 3431804 - bind dates for latecoming deposits */
4860: dbms_sql.bind_variable( ups_select_c,
4861: 'gl_date',
4862: p_gl_date);
4863:
4864: dbms_sql.bind_variable( ups_select_c,
4860: dbms_sql.bind_variable( ups_select_c,
4861: 'gl_date',
4862: p_gl_date);
4863:
4864: dbms_sql.bind_variable( ups_select_c,
4865: 'apply_date',
4866: p_adj_date);
4867: ---------------------------------------------------------------
4868: -- Execute sql
4869: ---------------------------------------------------------------
4870: debug( ' Executing select sql', MSG_LEVEL_DEBUG );
4871:
4872: BEGIN
4873: l_ignore := dbms_sql.execute( ups_select_c );
4874:
4875: EXCEPTION
4876: WHEN OTHERS THEN
4877: debug( 'EXCEPTION: Error executing select sql',
4885: ---------------------------------------------------------------
4886: BEGIN
4887: LOOP
4888:
4889: IF dbms_sql.fetch_rows( ups_select_c ) > 0 THEN
4890:
4891: debug(' Fetched a row', MSG_LEVEL_DEBUG );
4892:
4893: -----------------------------------------------
4892:
4893: -----------------------------------------------
4894: -- Load row into record
4895: -----------------------------------------------
4896: dbms_sql.column_value( ups_select_c, 24, l_customer_trx_id );
4897: dbms_sql.column_value( ups_select_c, 5, l_adjusted_trx_id );
4898:
4899: -----------------------------------------------
4900: -- Check if adjusted trx or invoice changed
4893: -----------------------------------------------
4894: -- Load row into record
4895: -----------------------------------------------
4896: dbms_sql.column_value( ups_select_c, 24, l_customer_trx_id );
4897: dbms_sql.column_value( ups_select_c, 5, l_adjusted_trx_id );
4898:
4899: -----------------------------------------------
4900: -- Check if adjusted trx or invoice changed
4901: -----------------------------------------------
5420: BEGIN
5421: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
5422:
5423: debug( ' Parsing insert_adj_c', MSG_LEVEL_DEBUG );
5424: p_insert_adj_c := dbms_sql.open_cursor;
5425: dbms_sql.parse( p_insert_adj_c, l_insert_adj_sql,
5426: dbms_sql.v7 );
5427:
5428: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
5421: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
5422:
5423: debug( ' Parsing insert_adj_c', MSG_LEVEL_DEBUG );
5424: p_insert_adj_c := dbms_sql.open_cursor;
5425: dbms_sql.parse( p_insert_adj_c, l_insert_adj_sql,
5426: dbms_sql.v7 );
5427:
5428: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
5429: p_update_ps_c := dbms_sql.open_cursor;
5422:
5423: debug( ' Parsing insert_adj_c', MSG_LEVEL_DEBUG );
5424: p_insert_adj_c := dbms_sql.open_cursor;
5425: dbms_sql.parse( p_insert_adj_c, l_insert_adj_sql,
5426: dbms_sql.v7 );
5427:
5428: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
5429: p_update_ps_c := dbms_sql.open_cursor;
5430: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
5425: dbms_sql.parse( p_insert_adj_c, l_insert_adj_sql,
5426: dbms_sql.v7 );
5427:
5428: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
5429: p_update_ps_c := dbms_sql.open_cursor;
5430: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
5431: dbms_sql.v7 );
5432:
5433: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
5426: dbms_sql.v7 );
5427:
5428: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
5429: p_update_ps_c := dbms_sql.open_cursor;
5430: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
5431: dbms_sql.v7 );
5432:
5433: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
5434: p_select_c := dbms_sql.open_cursor;
5427:
5428: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
5429: p_update_ps_c := dbms_sql.open_cursor;
5430: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
5431: dbms_sql.v7 );
5432:
5433: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
5434: p_select_c := dbms_sql.open_cursor;
5435: dbms_sql.parse( p_select_c, l_select_sql,
5430: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
5431: dbms_sql.v7 );
5432:
5433: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
5434: p_select_c := dbms_sql.open_cursor;
5435: dbms_sql.parse( p_select_c, l_select_sql,
5436: dbms_sql.v7 );
5437:
5438: EXCEPTION
5431: dbms_sql.v7 );
5432:
5433: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
5434: p_select_c := dbms_sql.open_cursor;
5435: dbms_sql.parse( p_select_c, l_select_sql,
5436: dbms_sql.v7 );
5437:
5438: EXCEPTION
5439: WHEN OTHERS THEN
5432:
5433: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
5434: p_select_c := dbms_sql.open_cursor;
5435: dbms_sql.parse( p_select_c, l_select_sql,
5436: dbms_sql.v7 );
5437:
5438: EXCEPTION
5439: WHEN OTHERS THEN
5440: debug( 'EXCEPTION: Error parsing stmts', MSG_LEVEL_BASIC );
5461: BEGIN
5462:
5463: print_fcn_label2( 'arp_maintain_ps2.define_iad_select_columns()+' );
5464:
5465: dbms_sql.define_column( p_select_c, 1, p_select_rec.set_of_books_id );
5466: dbms_sql.define_column( p_select_c, 2, p_select_rec.trx_date );
5467: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
5468: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
5469: dbms_sql.define_column( p_select_c, 5, p_select_rec.adjusted_trx_id );
5462:
5463: print_fcn_label2( 'arp_maintain_ps2.define_iad_select_columns()+' );
5464:
5465: dbms_sql.define_column( p_select_c, 1, p_select_rec.set_of_books_id );
5466: dbms_sql.define_column( p_select_c, 2, p_select_rec.trx_date );
5467: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
5468: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
5469: dbms_sql.define_column( p_select_c, 5, p_select_rec.adjusted_trx_id );
5470: dbms_sql.define_column( p_select_c, 6, p_select_rec.payment_schedule_id );
5463: print_fcn_label2( 'arp_maintain_ps2.define_iad_select_columns()+' );
5464:
5465: dbms_sql.define_column( p_select_c, 1, p_select_rec.set_of_books_id );
5466: dbms_sql.define_column( p_select_c, 2, p_select_rec.trx_date );
5467: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
5468: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
5469: dbms_sql.define_column( p_select_c, 5, p_select_rec.adjusted_trx_id );
5470: dbms_sql.define_column( p_select_c, 6, p_select_rec.payment_schedule_id );
5471: dbms_sql.define_column( p_select_c, 7, p_select_rec.customer_trx_id );
5464:
5465: dbms_sql.define_column( p_select_c, 1, p_select_rec.set_of_books_id );
5466: dbms_sql.define_column( p_select_c, 2, p_select_rec.trx_date );
5467: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
5468: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
5469: dbms_sql.define_column( p_select_c, 5, p_select_rec.adjusted_trx_id );
5470: dbms_sql.define_column( p_select_c, 6, p_select_rec.payment_schedule_id );
5471: dbms_sql.define_column( p_select_c, 7, p_select_rec.customer_trx_id );
5472: dbms_sql.define_column( p_select_c, 8,
5465: dbms_sql.define_column( p_select_c, 1, p_select_rec.set_of_books_id );
5466: dbms_sql.define_column( p_select_c, 2, p_select_rec.trx_date );
5467: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
5468: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
5469: dbms_sql.define_column( p_select_c, 5, p_select_rec.adjusted_trx_id );
5470: dbms_sql.define_column( p_select_c, 6, p_select_rec.payment_schedule_id );
5471: dbms_sql.define_column( p_select_c, 7, p_select_rec.customer_trx_id );
5472: dbms_sql.define_column( p_select_c, 8,
5473: p_select_rec.post_to_gl_flag, 1 );
5466: dbms_sql.define_column( p_select_c, 2, p_select_rec.trx_date );
5467: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
5468: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
5469: dbms_sql.define_column( p_select_c, 5, p_select_rec.adjusted_trx_id );
5470: dbms_sql.define_column( p_select_c, 6, p_select_rec.payment_schedule_id );
5471: dbms_sql.define_column( p_select_c, 7, p_select_rec.customer_trx_id );
5472: dbms_sql.define_column( p_select_c, 8,
5473: p_select_rec.post_to_gl_flag, 1 );
5474: dbms_sql.define_column( p_select_c, 9, p_select_rec.actual_date_closed );
5467: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
5468: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
5469: dbms_sql.define_column( p_select_c, 5, p_select_rec.adjusted_trx_id );
5470: dbms_sql.define_column( p_select_c, 6, p_select_rec.payment_schedule_id );
5471: dbms_sql.define_column( p_select_c, 7, p_select_rec.customer_trx_id );
5472: dbms_sql.define_column( p_select_c, 8,
5473: p_select_rec.post_to_gl_flag, 1 );
5474: dbms_sql.define_column( p_select_c, 9, p_select_rec.actual_date_closed );
5475: dbms_sql.define_column( p_select_c, 10, p_select_rec.gl_date_closed );
5468: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
5469: dbms_sql.define_column( p_select_c, 5, p_select_rec.adjusted_trx_id );
5470: dbms_sql.define_column( p_select_c, 6, p_select_rec.payment_schedule_id );
5471: dbms_sql.define_column( p_select_c, 7, p_select_rec.customer_trx_id );
5472: dbms_sql.define_column( p_select_c, 8,
5473: p_select_rec.post_to_gl_flag, 1 );
5474: dbms_sql.define_column( p_select_c, 9, p_select_rec.actual_date_closed );
5475: dbms_sql.define_column( p_select_c, 10, p_select_rec.gl_date_closed );
5476: dbms_sql.define_column( p_select_c, 11, p_select_rec.min_acc_unit );
5470: dbms_sql.define_column( p_select_c, 6, p_select_rec.payment_schedule_id );
5471: dbms_sql.define_column( p_select_c, 7, p_select_rec.customer_trx_id );
5472: dbms_sql.define_column( p_select_c, 8,
5473: p_select_rec.post_to_gl_flag, 1 );
5474: dbms_sql.define_column( p_select_c, 9, p_select_rec.actual_date_closed );
5475: dbms_sql.define_column( p_select_c, 10, p_select_rec.gl_date_closed );
5476: dbms_sql.define_column( p_select_c, 11, p_select_rec.min_acc_unit );
5477: dbms_sql.define_column( p_select_c, 12, p_select_rec.precision );
5478: dbms_sql.define_column( p_select_c, 13,
5471: dbms_sql.define_column( p_select_c, 7, p_select_rec.customer_trx_id );
5472: dbms_sql.define_column( p_select_c, 8,
5473: p_select_rec.post_to_gl_flag, 1 );
5474: dbms_sql.define_column( p_select_c, 9, p_select_rec.actual_date_closed );
5475: dbms_sql.define_column( p_select_c, 10, p_select_rec.gl_date_closed );
5476: dbms_sql.define_column( p_select_c, 11, p_select_rec.min_acc_unit );
5477: dbms_sql.define_column( p_select_c, 12, p_select_rec.precision );
5478: dbms_sql.define_column( p_select_c, 13,
5479: p_select_rec.total_cm_line_amount );
5472: dbms_sql.define_column( p_select_c, 8,
5473: p_select_rec.post_to_gl_flag, 1 );
5474: dbms_sql.define_column( p_select_c, 9, p_select_rec.actual_date_closed );
5475: dbms_sql.define_column( p_select_c, 10, p_select_rec.gl_date_closed );
5476: dbms_sql.define_column( p_select_c, 11, p_select_rec.min_acc_unit );
5477: dbms_sql.define_column( p_select_c, 12, p_select_rec.precision );
5478: dbms_sql.define_column( p_select_c, 13,
5479: p_select_rec.total_cm_line_amount );
5480: dbms_sql.define_column( p_select_c, 14,
5473: p_select_rec.post_to_gl_flag, 1 );
5474: dbms_sql.define_column( p_select_c, 9, p_select_rec.actual_date_closed );
5475: dbms_sql.define_column( p_select_c, 10, p_select_rec.gl_date_closed );
5476: dbms_sql.define_column( p_select_c, 11, p_select_rec.min_acc_unit );
5477: dbms_sql.define_column( p_select_c, 12, p_select_rec.precision );
5478: dbms_sql.define_column( p_select_c, 13,
5479: p_select_rec.total_cm_line_amount );
5480: dbms_sql.define_column( p_select_c, 14,
5481: p_select_rec.total_inv_adj_amount );
5474: dbms_sql.define_column( p_select_c, 9, p_select_rec.actual_date_closed );
5475: dbms_sql.define_column( p_select_c, 10, p_select_rec.gl_date_closed );
5476: dbms_sql.define_column( p_select_c, 11, p_select_rec.min_acc_unit );
5477: dbms_sql.define_column( p_select_c, 12, p_select_rec.precision );
5478: dbms_sql.define_column( p_select_c, 13,
5479: p_select_rec.total_cm_line_amount );
5480: dbms_sql.define_column( p_select_c, 14,
5481: p_select_rec.total_inv_adj_amount );
5482: dbms_sql.define_column( p_select_c, 15, p_select_rec.commitment_code );
5476: dbms_sql.define_column( p_select_c, 11, p_select_rec.min_acc_unit );
5477: dbms_sql.define_column( p_select_c, 12, p_select_rec.precision );
5478: dbms_sql.define_column( p_select_c, 13,
5479: p_select_rec.total_cm_line_amount );
5480: dbms_sql.define_column( p_select_c, 14,
5481: p_select_rec.total_inv_adj_amount );
5482: dbms_sql.define_column( p_select_c, 15, p_select_rec.commitment_code );
5483: dbms_sql.define_column( p_select_c, 16, p_select_rec.invoice_trx_id );
5484: dbms_sql.define_column( p_select_c, 17, p_select_rec.ps_line_remaining );
5478: dbms_sql.define_column( p_select_c, 13,
5479: p_select_rec.total_cm_line_amount );
5480: dbms_sql.define_column( p_select_c, 14,
5481: p_select_rec.total_inv_adj_amount );
5482: dbms_sql.define_column( p_select_c, 15, p_select_rec.commitment_code );
5483: dbms_sql.define_column( p_select_c, 16, p_select_rec.invoice_trx_id );
5484: dbms_sql.define_column( p_select_c, 17, p_select_rec.ps_line_remaining );
5485: dbms_sql.define_column( p_select_c, 18,
5486: p_select_rec.ps_amount_due_remaining );
5479: p_select_rec.total_cm_line_amount );
5480: dbms_sql.define_column( p_select_c, 14,
5481: p_select_rec.total_inv_adj_amount );
5482: dbms_sql.define_column( p_select_c, 15, p_select_rec.commitment_code );
5483: dbms_sql.define_column( p_select_c, 16, p_select_rec.invoice_trx_id );
5484: dbms_sql.define_column( p_select_c, 17, p_select_rec.ps_line_remaining );
5485: dbms_sql.define_column( p_select_c, 18,
5486: p_select_rec.ps_amount_due_remaining );
5487: dbms_sql.define_column( p_select_c, 19,
5480: dbms_sql.define_column( p_select_c, 14,
5481: p_select_rec.total_inv_adj_amount );
5482: dbms_sql.define_column( p_select_c, 15, p_select_rec.commitment_code );
5483: dbms_sql.define_column( p_select_c, 16, p_select_rec.invoice_trx_id );
5484: dbms_sql.define_column( p_select_c, 17, p_select_rec.ps_line_remaining );
5485: dbms_sql.define_column( p_select_c, 18,
5486: p_select_rec.ps_amount_due_remaining );
5487: dbms_sql.define_column( p_select_c, 19,
5488: p_select_rec.ps_acctd_amt_due_rem );
5481: p_select_rec.total_inv_adj_amount );
5482: dbms_sql.define_column( p_select_c, 15, p_select_rec.commitment_code );
5483: dbms_sql.define_column( p_select_c, 16, p_select_rec.invoice_trx_id );
5484: dbms_sql.define_column( p_select_c, 17, p_select_rec.ps_line_remaining );
5485: dbms_sql.define_column( p_select_c, 18,
5486: p_select_rec.ps_amount_due_remaining );
5487: dbms_sql.define_column( p_select_c, 19,
5488: p_select_rec.ps_acctd_amt_due_rem );
5489: dbms_sql.define_column( p_select_c, 20,
5483: dbms_sql.define_column( p_select_c, 16, p_select_rec.invoice_trx_id );
5484: dbms_sql.define_column( p_select_c, 17, p_select_rec.ps_line_remaining );
5485: dbms_sql.define_column( p_select_c, 18,
5486: p_select_rec.ps_amount_due_remaining );
5487: dbms_sql.define_column( p_select_c, 19,
5488: p_select_rec.ps_acctd_amt_due_rem );
5489: dbms_sql.define_column( p_select_c, 20,
5490: p_select_rec.ps_amount_adjusted );
5491: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
5485: dbms_sql.define_column( p_select_c, 18,
5486: p_select_rec.ps_amount_due_remaining );
5487: dbms_sql.define_column( p_select_c, 19,
5488: p_select_rec.ps_acctd_amt_due_rem );
5489: dbms_sql.define_column( p_select_c, 20,
5490: p_select_rec.ps_amount_adjusted );
5491: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
5492: dbms_sql.define_column( p_select_c, 22, p_select_rec.ps_min_acc_unit );
5493: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
5487: dbms_sql.define_column( p_select_c, 19,
5488: p_select_rec.ps_acctd_amt_due_rem );
5489: dbms_sql.define_column( p_select_c, 20,
5490: p_select_rec.ps_amount_adjusted );
5491: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
5492: dbms_sql.define_column( p_select_c, 22, p_select_rec.ps_min_acc_unit );
5493: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
5494: dbms_sql.define_column( p_select_c, 24,
5495: p_select_rec.total_inv_line_remaining );
5488: p_select_rec.ps_acctd_amt_due_rem );
5489: dbms_sql.define_column( p_select_c, 20,
5490: p_select_rec.ps_amount_adjusted );
5491: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
5492: dbms_sql.define_column( p_select_c, 22, p_select_rec.ps_min_acc_unit );
5493: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
5494: dbms_sql.define_column( p_select_c, 24,
5495: p_select_rec.total_inv_line_remaining );
5496: dbms_sql.define_column( p_select_c, 25, p_select_rec.ps_line_original );
5489: dbms_sql.define_column( p_select_c, 20,
5490: p_select_rec.ps_amount_adjusted );
5491: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
5492: dbms_sql.define_column( p_select_c, 22, p_select_rec.ps_min_acc_unit );
5493: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
5494: dbms_sql.define_column( p_select_c, 24,
5495: p_select_rec.total_inv_line_remaining );
5496: dbms_sql.define_column( p_select_c, 25, p_select_rec.ps_line_original );
5497: dbms_sql.define_column( p_select_c, 26,
5490: p_select_rec.ps_amount_adjusted );
5491: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
5492: dbms_sql.define_column( p_select_c, 22, p_select_rec.ps_min_acc_unit );
5493: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
5494: dbms_sql.define_column( p_select_c, 24,
5495: p_select_rec.total_inv_line_remaining );
5496: dbms_sql.define_column( p_select_c, 25, p_select_rec.ps_line_original );
5497: dbms_sql.define_column( p_select_c, 26,
5498: p_select_rec.ps_currency_code, 15 );
5492: dbms_sql.define_column( p_select_c, 22, p_select_rec.ps_min_acc_unit );
5493: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
5494: dbms_sql.define_column( p_select_c, 24,
5495: p_select_rec.total_inv_line_remaining );
5496: dbms_sql.define_column( p_select_c, 25, p_select_rec.ps_line_original );
5497: dbms_sql.define_column( p_select_c, 26,
5498: p_select_rec.ps_currency_code, 15 );
5499: dbms_sql.define_column( p_select_c, 27, p_select_rec.allocate_tax_freight, 1);
5500: dbms_sql.define_column( p_select_c, 28, p_select_rec.adjustment_type, 8);
5493: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
5494: dbms_sql.define_column( p_select_c, 24,
5495: p_select_rec.total_inv_line_remaining );
5496: dbms_sql.define_column( p_select_c, 25, p_select_rec.ps_line_original );
5497: dbms_sql.define_column( p_select_c, 26,
5498: p_select_rec.ps_currency_code, 15 );
5499: dbms_sql.define_column( p_select_c, 27, p_select_rec.allocate_tax_freight, 1);
5500: dbms_sql.define_column( p_select_c, 28, p_select_rec.adjustment_type, 8);
5501: dbms_sql.define_column( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5495: p_select_rec.total_inv_line_remaining );
5496: dbms_sql.define_column( p_select_c, 25, p_select_rec.ps_line_original );
5497: dbms_sql.define_column( p_select_c, 26,
5498: p_select_rec.ps_currency_code, 15 );
5499: dbms_sql.define_column( p_select_c, 27, p_select_rec.allocate_tax_freight, 1);
5500: dbms_sql.define_column( p_select_c, 28, p_select_rec.adjustment_type, 8);
5501: dbms_sql.define_column( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5502: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5503: dbms_sql.define_column( p_select_c, 31, p_select_rec.inv_line_adj);
5496: dbms_sql.define_column( p_select_c, 25, p_select_rec.ps_line_original );
5497: dbms_sql.define_column( p_select_c, 26,
5498: p_select_rec.ps_currency_code, 15 );
5499: dbms_sql.define_column( p_select_c, 27, p_select_rec.allocate_tax_freight, 1);
5500: dbms_sql.define_column( p_select_c, 28, p_select_rec.adjustment_type, 8);
5501: dbms_sql.define_column( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5502: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5503: dbms_sql.define_column( p_select_c, 31, p_select_rec.inv_line_adj);
5504: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_tax_adj);
5497: dbms_sql.define_column( p_select_c, 26,
5498: p_select_rec.ps_currency_code, 15 );
5499: dbms_sql.define_column( p_select_c, 27, p_select_rec.allocate_tax_freight, 1);
5500: dbms_sql.define_column( p_select_c, 28, p_select_rec.adjustment_type, 8);
5501: dbms_sql.define_column( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5502: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5503: dbms_sql.define_column( p_select_c, 31, p_select_rec.inv_line_adj);
5504: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_tax_adj);
5505: dbms_sql.define_column( p_select_c, 33, p_select_rec.inv_frt_adj);
5498: p_select_rec.ps_currency_code, 15 );
5499: dbms_sql.define_column( p_select_c, 27, p_select_rec.allocate_tax_freight, 1);
5500: dbms_sql.define_column( p_select_c, 28, p_select_rec.adjustment_type, 8);
5501: dbms_sql.define_column( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5502: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5503: dbms_sql.define_column( p_select_c, 31, p_select_rec.inv_line_adj);
5504: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_tax_adj);
5505: dbms_sql.define_column( p_select_c, 33, p_select_rec.inv_frt_adj);
5506: dbms_sql.define_column( p_select_c, 34, p_select_rec.ps_tax_remaining);
5499: dbms_sql.define_column( p_select_c, 27, p_select_rec.allocate_tax_freight, 1);
5500: dbms_sql.define_column( p_select_c, 28, p_select_rec.adjustment_type, 8);
5501: dbms_sql.define_column( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5502: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5503: dbms_sql.define_column( p_select_c, 31, p_select_rec.inv_line_adj);
5504: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_tax_adj);
5505: dbms_sql.define_column( p_select_c, 33, p_select_rec.inv_frt_adj);
5506: dbms_sql.define_column( p_select_c, 34, p_select_rec.ps_tax_remaining);
5507: dbms_sql.define_column( p_select_c, 35, p_select_rec.ps_freight_remaining);
5500: dbms_sql.define_column( p_select_c, 28, p_select_rec.adjustment_type, 8);
5501: dbms_sql.define_column( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5502: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5503: dbms_sql.define_column( p_select_c, 31, p_select_rec.inv_line_adj);
5504: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_tax_adj);
5505: dbms_sql.define_column( p_select_c, 33, p_select_rec.inv_frt_adj);
5506: dbms_sql.define_column( p_select_c, 34, p_select_rec.ps_tax_remaining);
5507: dbms_sql.define_column( p_select_c, 35, p_select_rec.ps_freight_remaining);
5508: dbms_sql.define_column( p_select_c, 36, p_select_rec.ps_tax_original);
5501: dbms_sql.define_column( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5502: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5503: dbms_sql.define_column( p_select_c, 31, p_select_rec.inv_line_adj);
5504: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_tax_adj);
5505: dbms_sql.define_column( p_select_c, 33, p_select_rec.inv_frt_adj);
5506: dbms_sql.define_column( p_select_c, 34, p_select_rec.ps_tax_remaining);
5507: dbms_sql.define_column( p_select_c, 35, p_select_rec.ps_freight_remaining);
5508: dbms_sql.define_column( p_select_c, 36, p_select_rec.ps_tax_original);
5509: dbms_sql.define_column( p_select_c, 37, p_select_rec.ps_freight_remaining);
5502: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5503: dbms_sql.define_column( p_select_c, 31, p_select_rec.inv_line_adj);
5504: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_tax_adj);
5505: dbms_sql.define_column( p_select_c, 33, p_select_rec.inv_frt_adj);
5506: dbms_sql.define_column( p_select_c, 34, p_select_rec.ps_tax_remaining);
5507: dbms_sql.define_column( p_select_c, 35, p_select_rec.ps_freight_remaining);
5508: dbms_sql.define_column( p_select_c, 36, p_select_rec.ps_tax_original);
5509: dbms_sql.define_column( p_select_c, 37, p_select_rec.ps_freight_remaining);
5510:
5503: dbms_sql.define_column( p_select_c, 31, p_select_rec.inv_line_adj);
5504: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_tax_adj);
5505: dbms_sql.define_column( p_select_c, 33, p_select_rec.inv_frt_adj);
5506: dbms_sql.define_column( p_select_c, 34, p_select_rec.ps_tax_remaining);
5507: dbms_sql.define_column( p_select_c, 35, p_select_rec.ps_freight_remaining);
5508: dbms_sql.define_column( p_select_c, 36, p_select_rec.ps_tax_original);
5509: dbms_sql.define_column( p_select_c, 37, p_select_rec.ps_freight_remaining);
5510:
5511: print_fcn_label2( 'arp_maintain_ps2.define_iad_select_columns()-' );
5504: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_tax_adj);
5505: dbms_sql.define_column( p_select_c, 33, p_select_rec.inv_frt_adj);
5506: dbms_sql.define_column( p_select_c, 34, p_select_rec.ps_tax_remaining);
5507: dbms_sql.define_column( p_select_c, 35, p_select_rec.ps_freight_remaining);
5508: dbms_sql.define_column( p_select_c, 36, p_select_rec.ps_tax_original);
5509: dbms_sql.define_column( p_select_c, 37, p_select_rec.ps_freight_remaining);
5510:
5511: print_fcn_label2( 'arp_maintain_ps2.define_iad_select_columns()-' );
5512:
5505: dbms_sql.define_column( p_select_c, 33, p_select_rec.inv_frt_adj);
5506: dbms_sql.define_column( p_select_c, 34, p_select_rec.ps_tax_remaining);
5507: dbms_sql.define_column( p_select_c, 35, p_select_rec.ps_freight_remaining);
5508: dbms_sql.define_column( p_select_c, 36, p_select_rec.ps_tax_original);
5509: dbms_sql.define_column( p_select_c, 37, p_select_rec.ps_freight_remaining);
5510:
5511: print_fcn_label2( 'arp_maintain_ps2.define_iad_select_columns()-' );
5512:
5513: EXCEPTION
5524: /* Bug 460927 - Changed IN to IN OUT in the above line - Oracle 8 */
5525: BEGIN
5526: print_fcn_label2( 'arp_maintain_ps2.get_iad_column_values()+' );
5527:
5528: dbms_sql.column_value( p_select_c, 1, p_select_rec.set_of_books_id );
5529: dbms_sql.column_value( p_select_c, 2, p_select_rec.trx_date );
5530: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
5531: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
5532: dbms_sql.column_value( p_select_c, 5, p_select_rec.adjusted_trx_id );
5525: BEGIN
5526: print_fcn_label2( 'arp_maintain_ps2.get_iad_column_values()+' );
5527:
5528: dbms_sql.column_value( p_select_c, 1, p_select_rec.set_of_books_id );
5529: dbms_sql.column_value( p_select_c, 2, p_select_rec.trx_date );
5530: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
5531: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
5532: dbms_sql.column_value( p_select_c, 5, p_select_rec.adjusted_trx_id );
5533: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
5526: print_fcn_label2( 'arp_maintain_ps2.get_iad_column_values()+' );
5527:
5528: dbms_sql.column_value( p_select_c, 1, p_select_rec.set_of_books_id );
5529: dbms_sql.column_value( p_select_c, 2, p_select_rec.trx_date );
5530: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
5531: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
5532: dbms_sql.column_value( p_select_c, 5, p_select_rec.adjusted_trx_id );
5533: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
5534: dbms_sql.column_value( p_select_c, 7, p_select_rec.customer_trx_id );
5527:
5528: dbms_sql.column_value( p_select_c, 1, p_select_rec.set_of_books_id );
5529: dbms_sql.column_value( p_select_c, 2, p_select_rec.trx_date );
5530: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
5531: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
5532: dbms_sql.column_value( p_select_c, 5, p_select_rec.adjusted_trx_id );
5533: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
5534: dbms_sql.column_value( p_select_c, 7, p_select_rec.customer_trx_id );
5535: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
5528: dbms_sql.column_value( p_select_c, 1, p_select_rec.set_of_books_id );
5529: dbms_sql.column_value( p_select_c, 2, p_select_rec.trx_date );
5530: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
5531: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
5532: dbms_sql.column_value( p_select_c, 5, p_select_rec.adjusted_trx_id );
5533: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
5534: dbms_sql.column_value( p_select_c, 7, p_select_rec.customer_trx_id );
5535: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
5536: dbms_sql.column_value( p_select_c, 9, p_select_rec.actual_date_closed );
5529: dbms_sql.column_value( p_select_c, 2, p_select_rec.trx_date );
5530: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
5531: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
5532: dbms_sql.column_value( p_select_c, 5, p_select_rec.adjusted_trx_id );
5533: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
5534: dbms_sql.column_value( p_select_c, 7, p_select_rec.customer_trx_id );
5535: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
5536: dbms_sql.column_value( p_select_c, 9, p_select_rec.actual_date_closed );
5537: dbms_sql.column_value( p_select_c, 10, p_select_rec.gl_date_closed );
5530: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
5531: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
5532: dbms_sql.column_value( p_select_c, 5, p_select_rec.adjusted_trx_id );
5533: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
5534: dbms_sql.column_value( p_select_c, 7, p_select_rec.customer_trx_id );
5535: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
5536: dbms_sql.column_value( p_select_c, 9, p_select_rec.actual_date_closed );
5537: dbms_sql.column_value( p_select_c, 10, p_select_rec.gl_date_closed );
5538: dbms_sql.column_value( p_select_c, 11, p_select_rec.min_acc_unit );
5531: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
5532: dbms_sql.column_value( p_select_c, 5, p_select_rec.adjusted_trx_id );
5533: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
5534: dbms_sql.column_value( p_select_c, 7, p_select_rec.customer_trx_id );
5535: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
5536: dbms_sql.column_value( p_select_c, 9, p_select_rec.actual_date_closed );
5537: dbms_sql.column_value( p_select_c, 10, p_select_rec.gl_date_closed );
5538: dbms_sql.column_value( p_select_c, 11, p_select_rec.min_acc_unit );
5539: dbms_sql.column_value( p_select_c, 12, p_select_rec.precision );
5532: dbms_sql.column_value( p_select_c, 5, p_select_rec.adjusted_trx_id );
5533: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
5534: dbms_sql.column_value( p_select_c, 7, p_select_rec.customer_trx_id );
5535: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
5536: dbms_sql.column_value( p_select_c, 9, p_select_rec.actual_date_closed );
5537: dbms_sql.column_value( p_select_c, 10, p_select_rec.gl_date_closed );
5538: dbms_sql.column_value( p_select_c, 11, p_select_rec.min_acc_unit );
5539: dbms_sql.column_value( p_select_c, 12, p_select_rec.precision );
5540: dbms_sql.column_value( p_select_c, 13, p_select_rec.total_cm_line_amount );
5533: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
5534: dbms_sql.column_value( p_select_c, 7, p_select_rec.customer_trx_id );
5535: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
5536: dbms_sql.column_value( p_select_c, 9, p_select_rec.actual_date_closed );
5537: dbms_sql.column_value( p_select_c, 10, p_select_rec.gl_date_closed );
5538: dbms_sql.column_value( p_select_c, 11, p_select_rec.min_acc_unit );
5539: dbms_sql.column_value( p_select_c, 12, p_select_rec.precision );
5540: dbms_sql.column_value( p_select_c, 13, p_select_rec.total_cm_line_amount );
5541: dbms_sql.column_value( p_select_c, 14, p_select_rec.total_inv_adj_amount );
5534: dbms_sql.column_value( p_select_c, 7, p_select_rec.customer_trx_id );
5535: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
5536: dbms_sql.column_value( p_select_c, 9, p_select_rec.actual_date_closed );
5537: dbms_sql.column_value( p_select_c, 10, p_select_rec.gl_date_closed );
5538: dbms_sql.column_value( p_select_c, 11, p_select_rec.min_acc_unit );
5539: dbms_sql.column_value( p_select_c, 12, p_select_rec.precision );
5540: dbms_sql.column_value( p_select_c, 13, p_select_rec.total_cm_line_amount );
5541: dbms_sql.column_value( p_select_c, 14, p_select_rec.total_inv_adj_amount );
5542: dbms_sql.column_value( p_select_c, 15, p_select_rec.commitment_code );
5535: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
5536: dbms_sql.column_value( p_select_c, 9, p_select_rec.actual_date_closed );
5537: dbms_sql.column_value( p_select_c, 10, p_select_rec.gl_date_closed );
5538: dbms_sql.column_value( p_select_c, 11, p_select_rec.min_acc_unit );
5539: dbms_sql.column_value( p_select_c, 12, p_select_rec.precision );
5540: dbms_sql.column_value( p_select_c, 13, p_select_rec.total_cm_line_amount );
5541: dbms_sql.column_value( p_select_c, 14, p_select_rec.total_inv_adj_amount );
5542: dbms_sql.column_value( p_select_c, 15, p_select_rec.commitment_code );
5543: dbms_sql.column_value( p_select_c, 16, p_select_rec.invoice_trx_id );
5536: dbms_sql.column_value( p_select_c, 9, p_select_rec.actual_date_closed );
5537: dbms_sql.column_value( p_select_c, 10, p_select_rec.gl_date_closed );
5538: dbms_sql.column_value( p_select_c, 11, p_select_rec.min_acc_unit );
5539: dbms_sql.column_value( p_select_c, 12, p_select_rec.precision );
5540: dbms_sql.column_value( p_select_c, 13, p_select_rec.total_cm_line_amount );
5541: dbms_sql.column_value( p_select_c, 14, p_select_rec.total_inv_adj_amount );
5542: dbms_sql.column_value( p_select_c, 15, p_select_rec.commitment_code );
5543: dbms_sql.column_value( p_select_c, 16, p_select_rec.invoice_trx_id );
5544: dbms_sql.column_value( p_select_c, 17, p_select_rec.ps_line_remaining );
5537: dbms_sql.column_value( p_select_c, 10, p_select_rec.gl_date_closed );
5538: dbms_sql.column_value( p_select_c, 11, p_select_rec.min_acc_unit );
5539: dbms_sql.column_value( p_select_c, 12, p_select_rec.precision );
5540: dbms_sql.column_value( p_select_c, 13, p_select_rec.total_cm_line_amount );
5541: dbms_sql.column_value( p_select_c, 14, p_select_rec.total_inv_adj_amount );
5542: dbms_sql.column_value( p_select_c, 15, p_select_rec.commitment_code );
5543: dbms_sql.column_value( p_select_c, 16, p_select_rec.invoice_trx_id );
5544: dbms_sql.column_value( p_select_c, 17, p_select_rec.ps_line_remaining );
5545: dbms_sql.column_value( p_select_c, 18,
5538: dbms_sql.column_value( p_select_c, 11, p_select_rec.min_acc_unit );
5539: dbms_sql.column_value( p_select_c, 12, p_select_rec.precision );
5540: dbms_sql.column_value( p_select_c, 13, p_select_rec.total_cm_line_amount );
5541: dbms_sql.column_value( p_select_c, 14, p_select_rec.total_inv_adj_amount );
5542: dbms_sql.column_value( p_select_c, 15, p_select_rec.commitment_code );
5543: dbms_sql.column_value( p_select_c, 16, p_select_rec.invoice_trx_id );
5544: dbms_sql.column_value( p_select_c, 17, p_select_rec.ps_line_remaining );
5545: dbms_sql.column_value( p_select_c, 18,
5546: p_select_rec.ps_amount_due_remaining );
5539: dbms_sql.column_value( p_select_c, 12, p_select_rec.precision );
5540: dbms_sql.column_value( p_select_c, 13, p_select_rec.total_cm_line_amount );
5541: dbms_sql.column_value( p_select_c, 14, p_select_rec.total_inv_adj_amount );
5542: dbms_sql.column_value( p_select_c, 15, p_select_rec.commitment_code );
5543: dbms_sql.column_value( p_select_c, 16, p_select_rec.invoice_trx_id );
5544: dbms_sql.column_value( p_select_c, 17, p_select_rec.ps_line_remaining );
5545: dbms_sql.column_value( p_select_c, 18,
5546: p_select_rec.ps_amount_due_remaining );
5547: dbms_sql.column_value( p_select_c, 19,
5540: dbms_sql.column_value( p_select_c, 13, p_select_rec.total_cm_line_amount );
5541: dbms_sql.column_value( p_select_c, 14, p_select_rec.total_inv_adj_amount );
5542: dbms_sql.column_value( p_select_c, 15, p_select_rec.commitment_code );
5543: dbms_sql.column_value( p_select_c, 16, p_select_rec.invoice_trx_id );
5544: dbms_sql.column_value( p_select_c, 17, p_select_rec.ps_line_remaining );
5545: dbms_sql.column_value( p_select_c, 18,
5546: p_select_rec.ps_amount_due_remaining );
5547: dbms_sql.column_value( p_select_c, 19,
5548: p_select_rec.ps_acctd_amt_due_rem );
5541: dbms_sql.column_value( p_select_c, 14, p_select_rec.total_inv_adj_amount );
5542: dbms_sql.column_value( p_select_c, 15, p_select_rec.commitment_code );
5543: dbms_sql.column_value( p_select_c, 16, p_select_rec.invoice_trx_id );
5544: dbms_sql.column_value( p_select_c, 17, p_select_rec.ps_line_remaining );
5545: dbms_sql.column_value( p_select_c, 18,
5546: p_select_rec.ps_amount_due_remaining );
5547: dbms_sql.column_value( p_select_c, 19,
5548: p_select_rec.ps_acctd_amt_due_rem );
5549: dbms_sql.column_value( p_select_c, 20,
5543: dbms_sql.column_value( p_select_c, 16, p_select_rec.invoice_trx_id );
5544: dbms_sql.column_value( p_select_c, 17, p_select_rec.ps_line_remaining );
5545: dbms_sql.column_value( p_select_c, 18,
5546: p_select_rec.ps_amount_due_remaining );
5547: dbms_sql.column_value( p_select_c, 19,
5548: p_select_rec.ps_acctd_amt_due_rem );
5549: dbms_sql.column_value( p_select_c, 20,
5550: p_select_rec.ps_amount_adjusted );
5551: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
5545: dbms_sql.column_value( p_select_c, 18,
5546: p_select_rec.ps_amount_due_remaining );
5547: dbms_sql.column_value( p_select_c, 19,
5548: p_select_rec.ps_acctd_amt_due_rem );
5549: dbms_sql.column_value( p_select_c, 20,
5550: p_select_rec.ps_amount_adjusted );
5551: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
5552: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
5553: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
5547: dbms_sql.column_value( p_select_c, 19,
5548: p_select_rec.ps_acctd_amt_due_rem );
5549: dbms_sql.column_value( p_select_c, 20,
5550: p_select_rec.ps_amount_adjusted );
5551: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
5552: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
5553: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
5554: dbms_sql.column_value( p_select_c, 24,
5555: p_select_rec.total_inv_line_remaining );
5548: p_select_rec.ps_acctd_amt_due_rem );
5549: dbms_sql.column_value( p_select_c, 20,
5550: p_select_rec.ps_amount_adjusted );
5551: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
5552: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
5553: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
5554: dbms_sql.column_value( p_select_c, 24,
5555: p_select_rec.total_inv_line_remaining );
5556: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_line_original );
5549: dbms_sql.column_value( p_select_c, 20,
5550: p_select_rec.ps_amount_adjusted );
5551: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
5552: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
5553: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
5554: dbms_sql.column_value( p_select_c, 24,
5555: p_select_rec.total_inv_line_remaining );
5556: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_line_original );
5557: dbms_sql.column_value( p_select_c, 26, p_select_rec.ps_currency_code );
5550: p_select_rec.ps_amount_adjusted );
5551: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
5552: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
5553: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
5554: dbms_sql.column_value( p_select_c, 24,
5555: p_select_rec.total_inv_line_remaining );
5556: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_line_original );
5557: dbms_sql.column_value( p_select_c, 26, p_select_rec.ps_currency_code );
5558: dbms_sql.column_value( p_select_c, 27, p_select_rec.allocate_tax_freight);
5552: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
5553: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
5554: dbms_sql.column_value( p_select_c, 24,
5555: p_select_rec.total_inv_line_remaining );
5556: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_line_original );
5557: dbms_sql.column_value( p_select_c, 26, p_select_rec.ps_currency_code );
5558: dbms_sql.column_value( p_select_c, 27, p_select_rec.allocate_tax_freight);
5559: dbms_sql.column_value( p_select_c, 28, p_select_rec.adjustment_type);
5560: dbms_sql.column_value( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5553: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
5554: dbms_sql.column_value( p_select_c, 24,
5555: p_select_rec.total_inv_line_remaining );
5556: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_line_original );
5557: dbms_sql.column_value( p_select_c, 26, p_select_rec.ps_currency_code );
5558: dbms_sql.column_value( p_select_c, 27, p_select_rec.allocate_tax_freight);
5559: dbms_sql.column_value( p_select_c, 28, p_select_rec.adjustment_type);
5560: dbms_sql.column_value( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5561: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5554: dbms_sql.column_value( p_select_c, 24,
5555: p_select_rec.total_inv_line_remaining );
5556: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_line_original );
5557: dbms_sql.column_value( p_select_c, 26, p_select_rec.ps_currency_code );
5558: dbms_sql.column_value( p_select_c, 27, p_select_rec.allocate_tax_freight);
5559: dbms_sql.column_value( p_select_c, 28, p_select_rec.adjustment_type);
5560: dbms_sql.column_value( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5561: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5562: dbms_sql.column_value( p_select_c, 31, p_select_rec.inv_line_adj);
5555: p_select_rec.total_inv_line_remaining );
5556: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_line_original );
5557: dbms_sql.column_value( p_select_c, 26, p_select_rec.ps_currency_code );
5558: dbms_sql.column_value( p_select_c, 27, p_select_rec.allocate_tax_freight);
5559: dbms_sql.column_value( p_select_c, 28, p_select_rec.adjustment_type);
5560: dbms_sql.column_value( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5561: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5562: dbms_sql.column_value( p_select_c, 31, p_select_rec.inv_line_adj);
5563: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_tax_adj);
5556: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_line_original );
5557: dbms_sql.column_value( p_select_c, 26, p_select_rec.ps_currency_code );
5558: dbms_sql.column_value( p_select_c, 27, p_select_rec.allocate_tax_freight);
5559: dbms_sql.column_value( p_select_c, 28, p_select_rec.adjustment_type);
5560: dbms_sql.column_value( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5561: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5562: dbms_sql.column_value( p_select_c, 31, p_select_rec.inv_line_adj);
5563: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_tax_adj);
5564: dbms_sql.column_value( p_select_c, 33, p_select_rec.inv_frt_adj);
5557: dbms_sql.column_value( p_select_c, 26, p_select_rec.ps_currency_code );
5558: dbms_sql.column_value( p_select_c, 27, p_select_rec.allocate_tax_freight);
5559: dbms_sql.column_value( p_select_c, 28, p_select_rec.adjustment_type);
5560: dbms_sql.column_value( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5561: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5562: dbms_sql.column_value( p_select_c, 31, p_select_rec.inv_line_adj);
5563: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_tax_adj);
5564: dbms_sql.column_value( p_select_c, 33, p_select_rec.inv_frt_adj);
5565: dbms_sql.column_value( p_select_c, 34, p_select_rec.ps_tax_remaining);
5558: dbms_sql.column_value( p_select_c, 27, p_select_rec.allocate_tax_freight);
5559: dbms_sql.column_value( p_select_c, 28, p_select_rec.adjustment_type);
5560: dbms_sql.column_value( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5561: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5562: dbms_sql.column_value( p_select_c, 31, p_select_rec.inv_line_adj);
5563: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_tax_adj);
5564: dbms_sql.column_value( p_select_c, 33, p_select_rec.inv_frt_adj);
5565: dbms_sql.column_value( p_select_c, 34, p_select_rec.ps_tax_remaining);
5566: dbms_sql.column_value( p_select_c, 35, p_select_rec.ps_freight_remaining);
5559: dbms_sql.column_value( p_select_c, 28, p_select_rec.adjustment_type);
5560: dbms_sql.column_value( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5561: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5562: dbms_sql.column_value( p_select_c, 31, p_select_rec.inv_line_adj);
5563: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_tax_adj);
5564: dbms_sql.column_value( p_select_c, 33, p_select_rec.inv_frt_adj);
5565: dbms_sql.column_value( p_select_c, 34, p_select_rec.ps_tax_remaining);
5566: dbms_sql.column_value( p_select_c, 35, p_select_rec.ps_freight_remaining);
5567: dbms_sql.column_value( p_select_c, 36, p_select_rec.ps_tax_original);
5560: dbms_sql.column_value( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5561: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5562: dbms_sql.column_value( p_select_c, 31, p_select_rec.inv_line_adj);
5563: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_tax_adj);
5564: dbms_sql.column_value( p_select_c, 33, p_select_rec.inv_frt_adj);
5565: dbms_sql.column_value( p_select_c, 34, p_select_rec.ps_tax_remaining);
5566: dbms_sql.column_value( p_select_c, 35, p_select_rec.ps_freight_remaining);
5567: dbms_sql.column_value( p_select_c, 36, p_select_rec.ps_tax_original);
5568: dbms_sql.column_value( p_select_c, 37, p_select_rec.ps_freight_original);
5561: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5562: dbms_sql.column_value( p_select_c, 31, p_select_rec.inv_line_adj);
5563: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_tax_adj);
5564: dbms_sql.column_value( p_select_c, 33, p_select_rec.inv_frt_adj);
5565: dbms_sql.column_value( p_select_c, 34, p_select_rec.ps_tax_remaining);
5566: dbms_sql.column_value( p_select_c, 35, p_select_rec.ps_freight_remaining);
5567: dbms_sql.column_value( p_select_c, 36, p_select_rec.ps_tax_original);
5568: dbms_sql.column_value( p_select_c, 37, p_select_rec.ps_freight_original);
5569:
5562: dbms_sql.column_value( p_select_c, 31, p_select_rec.inv_line_adj);
5563: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_tax_adj);
5564: dbms_sql.column_value( p_select_c, 33, p_select_rec.inv_frt_adj);
5565: dbms_sql.column_value( p_select_c, 34, p_select_rec.ps_tax_remaining);
5566: dbms_sql.column_value( p_select_c, 35, p_select_rec.ps_freight_remaining);
5567: dbms_sql.column_value( p_select_c, 36, p_select_rec.ps_tax_original);
5568: dbms_sql.column_value( p_select_c, 37, p_select_rec.ps_freight_original);
5569:
5570: print_fcn_label2( 'arp_maintain_ps2.get_iad_column_values()-' );
5563: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_tax_adj);
5564: dbms_sql.column_value( p_select_c, 33, p_select_rec.inv_frt_adj);
5565: dbms_sql.column_value( p_select_c, 34, p_select_rec.ps_tax_remaining);
5566: dbms_sql.column_value( p_select_c, 35, p_select_rec.ps_freight_remaining);
5567: dbms_sql.column_value( p_select_c, 36, p_select_rec.ps_tax_original);
5568: dbms_sql.column_value( p_select_c, 37, p_select_rec.ps_freight_original);
5569:
5570: print_fcn_label2( 'arp_maintain_ps2.get_iad_column_values()-' );
5571: EXCEPTION
5564: dbms_sql.column_value( p_select_c, 33, p_select_rec.inv_frt_adj);
5565: dbms_sql.column_value( p_select_c, 34, p_select_rec.ps_tax_remaining);
5566: dbms_sql.column_value( p_select_c, 35, p_select_rec.ps_freight_remaining);
5567: dbms_sql.column_value( p_select_c, 36, p_select_rec.ps_tax_original);
5568: dbms_sql.column_value( p_select_c, 37, p_select_rec.ps_freight_original);
5569:
5570: print_fcn_label2( 'arp_maintain_ps2.get_iad_column_values()-' );
5571: EXCEPTION
5572: WHEN OTHERS THEN
6238: -------------------------------------------------------------
6239: BEGIN
6240: debug( ' Binding insert_adj_c', MSG_LEVEL_DEBUG );
6241:
6242: dbms_sql.bind_variable( p_insert_adj_c,
6243: 'user_id',
6244: p_profile_info.user_id );
6245:
6246: dbms_sql.bind_variable( p_insert_adj_c,
6242: dbms_sql.bind_variable( p_insert_adj_c,
6243: 'user_id',
6244: p_profile_info.user_id );
6245:
6246: dbms_sql.bind_variable( p_insert_adj_c,
6247: 'login_id',
6248: p_profile_info.conc_login_id );
6249:
6250: dbms_sql.bind_variable( p_insert_adj_c,
6246: dbms_sql.bind_variable( p_insert_adj_c,
6247: 'login_id',
6248: p_profile_info.conc_login_id );
6249:
6250: dbms_sql.bind_variable( p_insert_adj_c,
6251: 'request_id',
6252: p_profile_info.request_id );
6253:
6254: dbms_sql.bind_variable( p_insert_adj_c,
6250: dbms_sql.bind_variable( p_insert_adj_c,
6251: 'request_id',
6252: p_profile_info.request_id );
6253:
6254: dbms_sql.bind_variable( p_insert_adj_c,
6255: 'application_id',
6256: p_profile_info.application_id );
6257:
6258: dbms_sql.bind_variable( p_insert_adj_c,
6254: dbms_sql.bind_variable( p_insert_adj_c,
6255: 'application_id',
6256: p_profile_info.application_id );
6257:
6258: dbms_sql.bind_variable( p_insert_adj_c,
6259: 'program_id',
6260: p_profile_info.conc_program_id );
6261:
6262:
6259: 'program_id',
6260: p_profile_info.conc_program_id );
6261:
6262:
6263: dbms_sql.bind_variable(
6264: p_insert_adj_c,
6265: 'set_of_books_id',
6266: p_select_rec.set_of_books_id );
6267:
6264: p_insert_adj_c,
6265: 'set_of_books_id',
6266: p_select_rec.set_of_books_id );
6267:
6268: dbms_sql.bind_variable( p_insert_adj_c,
6269: 'trx_date',
6270: p_select_rec.trx_date );
6271:
6272: dbms_sql.bind_variable( p_insert_adj_c,
6268: dbms_sql.bind_variable( p_insert_adj_c,
6269: 'trx_date',
6270: p_select_rec.trx_date );
6271:
6272: dbms_sql.bind_variable( p_insert_adj_c,
6273: 'gl_date',
6274: p_select_rec.gl_date );
6275:
6276: dbms_sql.bind_variable( p_insert_adj_c,
6272: dbms_sql.bind_variable( p_insert_adj_c,
6273: 'gl_date',
6274: p_select_rec.gl_date );
6275:
6276: dbms_sql.bind_variable( p_insert_adj_c,
6277: 'code_combination_id',
6278: p_select_rec.code_combination_id );
6279:
6280: dbms_sql.bind_variable( p_insert_adj_c,
6276: dbms_sql.bind_variable( p_insert_adj_c,
6277: 'code_combination_id',
6278: p_select_rec.code_combination_id );
6279:
6280: dbms_sql.bind_variable( p_insert_adj_c,
6281: 'adjusted_trx_id',
6282: p_select_rec.adjusted_trx_id );
6283:
6284: dbms_sql.bind_variable( p_insert_adj_c,
6280: dbms_sql.bind_variable( p_insert_adj_c,
6281: 'adjusted_trx_id',
6282: p_select_rec.adjusted_trx_id );
6283:
6284: dbms_sql.bind_variable( p_insert_adj_c,
6285: 'payment_schedule_id',
6286: p_ps_id_t( i ) );
6287:
6288: dbms_sql.bind_variable( p_insert_adj_c,
6284: dbms_sql.bind_variable( p_insert_adj_c,
6285: 'payment_schedule_id',
6286: p_ps_id_t( i ) );
6287:
6288: dbms_sql.bind_variable( p_insert_adj_c,
6289: 'subsequent_trx_id',
6290: p_select_rec.customer_trx_id );
6291:
6292: dbms_sql.bind_variable( p_insert_adj_c,
6288: dbms_sql.bind_variable( p_insert_adj_c,
6289: 'subsequent_trx_id',
6290: p_select_rec.customer_trx_id );
6291:
6292: dbms_sql.bind_variable( p_insert_adj_c,
6293: 'post_to_gl_flag',
6294: p_select_rec.post_to_gl_flag );
6295:
6296: dbms_sql.bind_variable( p_insert_adj_c,
6292: dbms_sql.bind_variable( p_insert_adj_c,
6293: 'post_to_gl_flag',
6294: p_select_rec.post_to_gl_flag );
6295:
6296: dbms_sql.bind_variable( p_insert_adj_c,
6297: 'adj_amount',
6298: p_adj_amount_t( i ) );
6299:
6300: dbms_sql.bind_variable( p_insert_adj_c,
6296: dbms_sql.bind_variable( p_insert_adj_c,
6297: 'adj_amount',
6298: p_adj_amount_t( i ) );
6299:
6300: dbms_sql.bind_variable( p_insert_adj_c,
6301: 'acctd_adj_amount',
6302: p_acctd_adj_amount_t( i ) );
6303:
6304: /* VAT changes */
6305: SELECT ar_adjustments_s.nextval
6306: INTO l_adjustment_id
6307: FROM dual;
6308:
6309: dbms_sql.bind_variable( p_insert_adj_c,
6310: 'adjustment_id',
6311: l_adjustment_id );
6312:
6313: dbms_sql.bind_variable( p_insert_adj_c,
6309: dbms_sql.bind_variable( p_insert_adj_c,
6310: 'adjustment_id',
6311: l_adjustment_id );
6312:
6313: dbms_sql.bind_variable( p_insert_adj_c,
6314: 'adj_type',
6315: p_select_rec.adjustment_type);
6316:
6317: dbms_sql.bind_variable( p_insert_adj_c,
6313: dbms_sql.bind_variable( p_insert_adj_c,
6314: 'adj_type',
6315: p_select_rec.adjustment_type);
6316:
6317: dbms_sql.bind_variable( p_insert_adj_c,
6318: 'line_adjusted',
6319: p_line_adj_t(i));
6320:
6321: dbms_sql.bind_variable( p_insert_adj_c,
6317: dbms_sql.bind_variable( p_insert_adj_c,
6318: 'line_adjusted',
6319: p_line_adj_t(i));
6320:
6321: dbms_sql.bind_variable( p_insert_adj_c,
6322: 'tax_adjusted',
6323: p_tax_adj_t(i));
6324:
6325: dbms_sql.bind_variable( p_insert_adj_c,
6321: dbms_sql.bind_variable( p_insert_adj_c,
6322: 'tax_adjusted',
6323: p_tax_adj_t(i));
6324:
6325: dbms_sql.bind_variable( p_insert_adj_c,
6326: 'freight_adjusted',
6327: p_frt_adj_t(i));
6328: /* anuj: Corrected typo for SSA retrofit */
6329: dbms_sql.bind_variable( p_insert_adj_c,
6325: dbms_sql.bind_variable( p_insert_adj_c,
6326: 'freight_adjusted',
6327: p_frt_adj_t(i));
6328: /* anuj: Corrected typo for SSA retrofit */
6329: dbms_sql.bind_variable( p_insert_adj_c,
6330: 'org_id',
6331: arp_standard.sysparm.org_id);
6332:
6333: EXCEPTION
6341: -- Execute
6342: -------------------------------------------------------------
6343: BEGIN
6344: debug( ' Inserting adjustments', MSG_LEVEL_DEBUG );
6345: l_ignore := dbms_sql.execute( p_insert_adj_c );
6346: debug( to_char(l_ignore) || ' row(s) inserted',
6347: MSG_LEVEL_DEBUG );
6348:
6349: /*-------------------------------------------+
6374: -------------------------------------------------------------
6375: BEGIN
6376: debug( ' Binding update_ps_c', MSG_LEVEL_DEBUG );
6377:
6378: dbms_sql.bind_variable( p_update_ps_c,
6379: 'user_id',
6380: p_profile_info.user_id );
6381:
6382: dbms_sql.bind_variable( p_update_ps_c,
6378: dbms_sql.bind_variable( p_update_ps_c,
6379: 'user_id',
6380: p_profile_info.user_id );
6381:
6382: dbms_sql.bind_variable( p_update_ps_c,
6383: 'login_id',
6384: p_profile_info.conc_login_id );
6385:
6386: dbms_sql.bind_variable( p_update_ps_c,
6382: dbms_sql.bind_variable( p_update_ps_c,
6383: 'login_id',
6384: p_profile_info.conc_login_id );
6385:
6386: dbms_sql.bind_variable( p_update_ps_c,
6387: 'amount_due_remaining',
6388: p_ps_amount_due_rem_t( i ) );
6389:
6390: dbms_sql.bind_variable( p_update_ps_c,
6386: dbms_sql.bind_variable( p_update_ps_c,
6387: 'amount_due_remaining',
6388: p_ps_amount_due_rem_t( i ) );
6389:
6390: dbms_sql.bind_variable( p_update_ps_c,
6391: 'gl_date_closed',
6392: p_select_rec.gl_date_closed );
6393:
6394: dbms_sql.bind_variable( p_update_ps_c,
6390: dbms_sql.bind_variable( p_update_ps_c,
6391: 'gl_date_closed',
6392: p_select_rec.gl_date_closed );
6393:
6394: dbms_sql.bind_variable( p_update_ps_c,
6395: 'actual_date_closed',
6396: p_select_rec.actual_date_closed );
6397:
6398: dbms_sql.bind_variable( p_update_ps_c,
6394: dbms_sql.bind_variable( p_update_ps_c,
6395: 'actual_date_closed',
6396: p_select_rec.actual_date_closed );
6397:
6398: dbms_sql.bind_variable( p_update_ps_c,
6399: 'amount_line_items_remaining',
6400: p_ps_line_rem_t( i ) );
6401:
6402: dbms_sql.bind_variable( p_update_ps_c,
6398: dbms_sql.bind_variable( p_update_ps_c,
6399: 'amount_line_items_remaining',
6400: p_ps_line_rem_t( i ) );
6401:
6402: dbms_sql.bind_variable( p_update_ps_c,
6403: 'amount_adjusted',
6404: p_ps_amount_adjusted_t( i ) );
6405:
6406: dbms_sql.bind_variable( p_update_ps_c,
6402: dbms_sql.bind_variable( p_update_ps_c,
6403: 'amount_adjusted',
6404: p_ps_amount_adjusted_t( i ) );
6405:
6406: dbms_sql.bind_variable( p_update_ps_c,
6407: 'acctd_amount_due_remaining',
6408: p_ps_acctd_amt_due_rem_t( i ) );
6409:
6410: dbms_sql.bind_variable( p_update_ps_c,
6406: dbms_sql.bind_variable( p_update_ps_c,
6407: 'acctd_amount_due_remaining',
6408: p_ps_acctd_amt_due_rem_t( i ) );
6409:
6410: dbms_sql.bind_variable( p_update_ps_c,
6411: 'payment_schedule_id',
6412: p_ps_id_t( i ) );
6413:
6414: dbms_sql.bind_variable( p_update_ps_c,
6410: dbms_sql.bind_variable( p_update_ps_c,
6411: 'payment_schedule_id',
6412: p_ps_id_t( i ) );
6413:
6414: dbms_sql.bind_variable( p_update_ps_c,
6415: 'tax_remaining',
6416: p_ps_tax_rem_t( i ) );
6417:
6418: dbms_sql.bind_variable( p_update_ps_c,
6414: dbms_sql.bind_variable( p_update_ps_c,
6415: 'tax_remaining',
6416: p_ps_tax_rem_t( i ) );
6417:
6418: dbms_sql.bind_variable( p_update_ps_c,
6419: 'freight_remaining',
6420: p_ps_frt_rem_t( i ) );
6421:
6422: EXCEPTION
6430: -- Execute
6431: -------------------------------------------------------------
6432: BEGIN
6433: debug( ' Updating invoice payment schedules', MSG_LEVEL_DEBUG );
6434: l_ignore := dbms_sql.execute( p_update_ps_c );
6435: debug( to_char(l_ignore) || ' row(s) updated',
6436: MSG_LEVEL_DEBUG );
6437:
6438: /*-------------------------------------------+
6698:
6699: --
6700: clear_all_tables;
6701: --
6702: IF( NOT( dbms_sql.is_open( iad_select_c ) AND
6703: dbms_sql.is_open( iad_insert_adj_c ) AND
6704: dbms_sql.is_open( iad_update_ps_c ) )) THEN
6705:
6706: build_iad_sql(
6699: --
6700: clear_all_tables;
6701: --
6702: IF( NOT( dbms_sql.is_open( iad_select_c ) AND
6703: dbms_sql.is_open( iad_insert_adj_c ) AND
6704: dbms_sql.is_open( iad_update_ps_c ) )) THEN
6705:
6706: build_iad_sql(
6707: system_info,
6700: clear_all_tables;
6701: --
6702: IF( NOT( dbms_sql.is_open( iad_select_c ) AND
6703: dbms_sql.is_open( iad_insert_adj_c ) AND
6704: dbms_sql.is_open( iad_update_ps_c ) )) THEN
6705:
6706: build_iad_sql(
6707: system_info,
6708: profile_info,
6717:
6718: ---------------------------------------------------------------
6719: -- Bind variables
6720: ---------------------------------------------------------------
6721: dbms_sql.bind_variable( iad_select_c,
6722: 'customer_trx_id',
6723: p_customer_trx_id );
6724:
6725: ---------------------------------------------------------------
6727: ---------------------------------------------------------------
6728: debug( ' Executing select sql', MSG_LEVEL_DEBUG );
6729:
6730: BEGIN
6731: l_ignore := dbms_sql.execute( iad_select_c );
6732:
6733: EXCEPTION
6734: WHEN OTHERS THEN
6735: debug( 'EXCEPTION: Error executing select sql',
6743: ---------------------------------------------------------------
6744: BEGIN
6745: LOOP
6746:
6747: IF dbms_sql.fetch_rows( iad_select_c ) > 0 THEN
6748:
6749: debug(' Fetched a row', MSG_LEVEL_DEBUG );
6750:
6751: -----------------------------------------------
6750:
6751: -----------------------------------------------
6752: -- Load row into record
6753: -----------------------------------------------
6754: dbms_sql.column_value( iad_select_c, 7, l_customer_trx_id );
6755: dbms_sql.column_value( iad_select_c, 5, l_adjusted_trx_id );
6756: dbms_sql.column_value( iad_select_c, 16, l_inv_trx_id );
6757:
6758: -----------------------------------------------
6751: -----------------------------------------------
6752: -- Load row into record
6753: -----------------------------------------------
6754: dbms_sql.column_value( iad_select_c, 7, l_customer_trx_id );
6755: dbms_sql.column_value( iad_select_c, 5, l_adjusted_trx_id );
6756: dbms_sql.column_value( iad_select_c, 16, l_inv_trx_id );
6757:
6758: -----------------------------------------------
6759: -- Check if adjusted trx or invoice changed
6752: -- Load row into record
6753: -----------------------------------------------
6754: dbms_sql.column_value( iad_select_c, 7, l_customer_trx_id );
6755: dbms_sql.column_value( iad_select_c, 5, l_adjusted_trx_id );
6756: dbms_sql.column_value( iad_select_c, 16, l_inv_trx_id );
6757:
6758: -----------------------------------------------
6759: -- Check if adjusted trx or invoice changed
6760: -----------------------------------------------
6828:
6829: -- get total adjustments for new adjusted trx
6830: l_is_new_adj_trx := TRUE;
6831:
6832: /* dbms_sql.column_value( iad_select_c, 31,
6833: l_eff_adj_line_total );
6834: dbms_sql.column_value( iad_select_c, 32,
6835: l_eff_adj_tax_total );
6836: dbms_sql.column_value( iad_select_c, 33,
6830: l_is_new_adj_trx := TRUE;
6831:
6832: /* dbms_sql.column_value( iad_select_c, 31,
6833: l_eff_adj_line_total );
6834: dbms_sql.column_value( iad_select_c, 32,
6835: l_eff_adj_tax_total );
6836: dbms_sql.column_value( iad_select_c, 33,
6837: l_eff_adj_frt_total );
6838: */
6832: /* dbms_sql.column_value( iad_select_c, 31,
6833: l_eff_adj_line_total );
6834: dbms_sql.column_value( iad_select_c, 32,
6835: l_eff_adj_tax_total );
6836: dbms_sql.column_value( iad_select_c, 33,
6837: l_eff_adj_frt_total );
6838: */
6839: -----------------------------------------------
6840: -- Else if new cm
6851: IF( is_new_inv ) THEN
6852:
6853: l_old_inv_trx_id := l_inv_trx_id;
6854: -- get invoice line, tax, frt remaining for new invoice
6855: dbms_sql.column_value( iad_select_c, 24 ,
6856: l_eff_line_bal );
6857: dbms_sql.column_value( iad_select_c, 34 ,
6858: l_eff_tax_bal );
6859: dbms_sql.column_value( iad_select_c, 35,
6853: l_old_inv_trx_id := l_inv_trx_id;
6854: -- get invoice line, tax, frt remaining for new invoice
6855: dbms_sql.column_value( iad_select_c, 24 ,
6856: l_eff_line_bal );
6857: dbms_sql.column_value( iad_select_c, 34 ,
6858: l_eff_tax_bal );
6859: dbms_sql.column_value( iad_select_c, 35,
6860: l_eff_frt_bal );
6861:
6855: dbms_sql.column_value( iad_select_c, 24 ,
6856: l_eff_line_bal );
6857: dbms_sql.column_value( iad_select_c, 34 ,
6858: l_eff_tax_bal );
6859: dbms_sql.column_value( iad_select_c, 35,
6860: l_eff_frt_bal );
6861:
6862: END IF;
6863:
7040:
7041: -- use the select sql passed as arg
7042: --
7043:
7044: dbms_sql.close_cursor( ips_select_c );
7045: ips_select_c := dbms_sql.open_cursor;
7046:
7047: debug(' select_sql='||p_select_sql );
7048:
7041: -- use the select sql passed as arg
7042: --
7043:
7044: dbms_sql.close_cursor( ips_select_c );
7045: ips_select_c := dbms_sql.open_cursor;
7046:
7047: debug(' select_sql='||p_select_sql );
7048:
7049: debug(' parsing new select sql');
7046:
7047: debug(' select_sql='||p_select_sql );
7048:
7049: debug(' parsing new select sql');
7050: dbms_sql.parse( ips_select_c, p_select_sql, dbms_sql.v7 );
7051:
7052:
7053:
7054: insert_inv_ps_private(
7092:
7093: -- use the select sql passed as arg
7094: --
7095:
7096: dbms_sql.close_cursor( ira_select_c );
7097: ira_select_c := dbms_sql.open_cursor;
7098:
7099: debug(' select_sql='||p_select_sql );
7100:
7093: -- use the select sql passed as arg
7094: --
7095:
7096: dbms_sql.close_cursor( ira_select_c );
7097: ira_select_c := dbms_sql.open_cursor;
7098:
7099: debug(' select_sql='||p_select_sql );
7100:
7101: debug(' parsing new select sql');
7098:
7099: debug(' select_sql='||p_select_sql );
7100:
7101: debug(' parsing new select sql');
7102: dbms_sql.parse( ira_select_c, p_select_sql, dbms_sql.v7 );
7103:
7104:
7105:
7106: insert_cm_ps_private(system_info, profile_info, p_request_id);
7138:
7139: -- use the select sql passed as arg
7140: --
7141:
7142: dbms_sql.close_cursor( ups_select_c );
7143: ups_select_c := dbms_sql.open_cursor;
7144:
7145: debug(' select_sql='||p_select_sql );
7146:
7139: -- use the select sql passed as arg
7140: --
7141:
7142: dbms_sql.close_cursor( ups_select_c );
7143: ups_select_c := dbms_sql.open_cursor;
7144:
7145: debug(' select_sql='||p_select_sql );
7146:
7147: debug(' parsing new select sql');
7144:
7145: debug(' select_sql='||p_select_sql );
7146:
7147: debug(' parsing new select sql');
7148: dbms_sql.parse( ups_select_c, p_select_sql, dbms_sql.v7 );
7149:
7150:
7151:
7152: insert_child_adj_private(system_info, profile_info, p_request_id);
7185:
7186: -- use the select sql passed as arg
7187: --
7188:
7189: dbms_sql.close_cursor( iad_select_c );
7190: iad_select_c := dbms_sql.open_cursor;
7191:
7192: debug(' select_sql='||p_select_sql );
7193:
7186: -- use the select sql passed as arg
7187: --
7188:
7189: dbms_sql.close_cursor( iad_select_c );
7190: iad_select_c := dbms_sql.open_cursor;
7191:
7192: debug(' select_sql='||p_select_sql );
7193:
7194: debug(' parsing new select sql');
7191:
7192: debug(' select_sql='||p_select_sql );
7193:
7194: debug(' parsing new select sql');
7195: dbms_sql.parse( iad_select_c, p_select_sql, dbms_sql.v7 );
7196:
7197:
7198:
7199: insert_cm_child_adj_private(system_info, profile_info, p_request_id);