[Home] [Help]
696: ------------------------------------------------
697: BEGIN
698: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
699:
700: p_insert_ps_c := dbms_sql.open_cursor;
701: dbms_sql.parse( p_insert_ps_c, l_insert_ps_sql,
702: dbms_sql.v7 );
703:
704: p_select_c := dbms_sql.open_cursor;
697: BEGIN
698: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
699:
700: p_insert_ps_c := dbms_sql.open_cursor;
701: dbms_sql.parse( p_insert_ps_c, l_insert_ps_sql,
702: dbms_sql.v7 );
703:
704: p_select_c := dbms_sql.open_cursor;
705: dbms_sql.parse( p_select_c, l_select_sql,
698: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
699:
700: p_insert_ps_c := dbms_sql.open_cursor;
701: dbms_sql.parse( p_insert_ps_c, l_insert_ps_sql,
702: dbms_sql.v7 );
703:
704: p_select_c := dbms_sql.open_cursor;
705: dbms_sql.parse( p_select_c, l_select_sql,
706: dbms_sql.v7 );
700: p_insert_ps_c := dbms_sql.open_cursor;
701: dbms_sql.parse( p_insert_ps_c, l_insert_ps_sql,
702: dbms_sql.v7 );
703:
704: p_select_c := dbms_sql.open_cursor;
705: dbms_sql.parse( p_select_c, l_select_sql,
706: dbms_sql.v7 );
707:
708: EXCEPTION
701: dbms_sql.parse( p_insert_ps_c, l_insert_ps_sql,
702: dbms_sql.v7 );
703:
704: p_select_c := dbms_sql.open_cursor;
705: dbms_sql.parse( p_select_c, l_select_sql,
706: dbms_sql.v7 );
707:
708: EXCEPTION
709: WHEN OTHERS THEN
702: dbms_sql.v7 );
703:
704: p_select_c := dbms_sql.open_cursor;
705: dbms_sql.parse( p_select_c, l_select_sql,
706: dbms_sql.v7 );
707:
708: EXCEPTION
709: WHEN OTHERS THEN
710: debug( 'EXCEPTION: Error parsing stmts', MSG_LEVEL_BASIC );
731: BEGIN
732:
733: print_fcn_label2( 'arp_maintain_ps2.define_ips_select_columns()+' );
734:
735: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );
736: dbms_sql.define_column( p_select_c, 2, p_select_rec.total_line_amount );
737: dbms_sql.define_column( p_select_c, 3, p_select_rec.total_tax_amount );
738: dbms_sql.define_column( p_select_c, 4, p_select_rec.total_freight_amount );
739: dbms_sql.define_column( p_select_c, 5, p_select_rec.term_id );
732:
733: print_fcn_label2( 'arp_maintain_ps2.define_ips_select_columns()+' );
734:
735: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );
736: dbms_sql.define_column( p_select_c, 2, p_select_rec.total_line_amount );
737: dbms_sql.define_column( p_select_c, 3, p_select_rec.total_tax_amount );
738: dbms_sql.define_column( p_select_c, 4, p_select_rec.total_freight_amount );
739: dbms_sql.define_column( p_select_c, 5, p_select_rec.term_id );
740: dbms_sql.define_column( p_select_c, 6, p_select_rec.term_sequence_num );
733: print_fcn_label2( 'arp_maintain_ps2.define_ips_select_columns()+' );
734:
735: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );
736: dbms_sql.define_column( p_select_c, 2, p_select_rec.total_line_amount );
737: dbms_sql.define_column( p_select_c, 3, p_select_rec.total_tax_amount );
738: dbms_sql.define_column( p_select_c, 4, p_select_rec.total_freight_amount );
739: dbms_sql.define_column( p_select_c, 5, p_select_rec.term_id );
740: dbms_sql.define_column( p_select_c, 6, p_select_rec.term_sequence_num );
741: dbms_sql.define_column( p_select_c, 7, p_select_rec.due_date );
734:
735: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );
736: dbms_sql.define_column( p_select_c, 2, p_select_rec.total_line_amount );
737: dbms_sql.define_column( p_select_c, 3, p_select_rec.total_tax_amount );
738: dbms_sql.define_column( p_select_c, 4, p_select_rec.total_freight_amount );
739: dbms_sql.define_column( p_select_c, 5, p_select_rec.term_id );
740: dbms_sql.define_column( p_select_c, 6, p_select_rec.term_sequence_num );
741: dbms_sql.define_column( p_select_c, 7, p_select_rec.due_date );
742: dbms_sql.define_column( p_select_c, 8, p_select_rec.customer_id );
735: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );
736: dbms_sql.define_column( p_select_c, 2, p_select_rec.total_line_amount );
737: dbms_sql.define_column( p_select_c, 3, p_select_rec.total_tax_amount );
738: dbms_sql.define_column( p_select_c, 4, p_select_rec.total_freight_amount );
739: dbms_sql.define_column( p_select_c, 5, p_select_rec.term_id );
740: dbms_sql.define_column( p_select_c, 6, p_select_rec.term_sequence_num );
741: dbms_sql.define_column( p_select_c, 7, p_select_rec.due_date );
742: dbms_sql.define_column( p_select_c, 8, p_select_rec.customer_id );
743: dbms_sql.define_column( p_select_c, 9, p_select_rec.trx_type, 20 );
736: dbms_sql.define_column( p_select_c, 2, p_select_rec.total_line_amount );
737: dbms_sql.define_column( p_select_c, 3, p_select_rec.total_tax_amount );
738: dbms_sql.define_column( p_select_c, 4, p_select_rec.total_freight_amount );
739: dbms_sql.define_column( p_select_c, 5, p_select_rec.term_id );
740: dbms_sql.define_column( p_select_c, 6, p_select_rec.term_sequence_num );
741: dbms_sql.define_column( p_select_c, 7, p_select_rec.due_date );
742: dbms_sql.define_column( p_select_c, 8, p_select_rec.customer_id );
743: dbms_sql.define_column( p_select_c, 9, p_select_rec.trx_type, 20 );
744: dbms_sql.define_column( p_select_c, 10, p_select_rec.site_use_id );
737: dbms_sql.define_column( p_select_c, 3, p_select_rec.total_tax_amount );
738: dbms_sql.define_column( p_select_c, 4, p_select_rec.total_freight_amount );
739: dbms_sql.define_column( p_select_c, 5, p_select_rec.term_id );
740: dbms_sql.define_column( p_select_c, 6, p_select_rec.term_sequence_num );
741: dbms_sql.define_column( p_select_c, 7, p_select_rec.due_date );
742: dbms_sql.define_column( p_select_c, 8, p_select_rec.customer_id );
743: dbms_sql.define_column( p_select_c, 9, p_select_rec.trx_type, 20 );
744: dbms_sql.define_column( p_select_c, 10, p_select_rec.site_use_id );
745: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
738: dbms_sql.define_column( p_select_c, 4, p_select_rec.total_freight_amount );
739: dbms_sql.define_column( p_select_c, 5, p_select_rec.term_id );
740: dbms_sql.define_column( p_select_c, 6, p_select_rec.term_sequence_num );
741: dbms_sql.define_column( p_select_c, 7, p_select_rec.due_date );
742: dbms_sql.define_column( p_select_c, 8, p_select_rec.customer_id );
743: dbms_sql.define_column( p_select_c, 9, p_select_rec.trx_type, 20 );
744: dbms_sql.define_column( p_select_c, 10, p_select_rec.site_use_id );
745: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
746: dbms_sql.define_column( p_select_c, 12,
739: dbms_sql.define_column( p_select_c, 5, p_select_rec.term_id );
740: dbms_sql.define_column( p_select_c, 6, p_select_rec.term_sequence_num );
741: dbms_sql.define_column( p_select_c, 7, p_select_rec.due_date );
742: dbms_sql.define_column( p_select_c, 8, p_select_rec.customer_id );
743: dbms_sql.define_column( p_select_c, 9, p_select_rec.trx_type, 20 );
744: dbms_sql.define_column( p_select_c, 10, p_select_rec.site_use_id );
745: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
746: dbms_sql.define_column( p_select_c, 12,
747: p_select_rec.currency_code, 15 );
740: dbms_sql.define_column( p_select_c, 6, p_select_rec.term_sequence_num );
741: dbms_sql.define_column( p_select_c, 7, p_select_rec.due_date );
742: dbms_sql.define_column( p_select_c, 8, p_select_rec.customer_id );
743: dbms_sql.define_column( p_select_c, 9, p_select_rec.trx_type, 20 );
744: dbms_sql.define_column( p_select_c, 10, p_select_rec.site_use_id );
745: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
746: dbms_sql.define_column( p_select_c, 12,
747: p_select_rec.currency_code, 15 );
748: dbms_sql.define_column( p_select_c, 13,
741: dbms_sql.define_column( p_select_c, 7, p_select_rec.due_date );
742: dbms_sql.define_column( p_select_c, 8, p_select_rec.customer_id );
743: dbms_sql.define_column( p_select_c, 9, p_select_rec.trx_type, 20 );
744: dbms_sql.define_column( p_select_c, 10, p_select_rec.site_use_id );
745: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
746: dbms_sql.define_column( p_select_c, 12,
747: p_select_rec.currency_code, 15 );
748: dbms_sql.define_column( p_select_c, 13,
749: p_select_rec.exchange_rate_type, 30 );
742: dbms_sql.define_column( p_select_c, 8, p_select_rec.customer_id );
743: dbms_sql.define_column( p_select_c, 9, p_select_rec.trx_type, 20 );
744: dbms_sql.define_column( p_select_c, 10, p_select_rec.site_use_id );
745: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
746: dbms_sql.define_column( p_select_c, 12,
747: p_select_rec.currency_code, 15 );
748: dbms_sql.define_column( p_select_c, 13,
749: p_select_rec.exchange_rate_type, 30 );
750: dbms_sql.define_column( p_select_c, 14, p_select_rec.exchange_rate );
744: dbms_sql.define_column( p_select_c, 10, p_select_rec.site_use_id );
745: dbms_sql.define_column( p_select_c, 11, p_select_rec.cust_trx_type_id );
746: dbms_sql.define_column( p_select_c, 12,
747: p_select_rec.currency_code, 15 );
748: dbms_sql.define_column( p_select_c, 13,
749: p_select_rec.exchange_rate_type, 30 );
750: dbms_sql.define_column( p_select_c, 14, p_select_rec.exchange_rate );
751: dbms_sql.define_column( p_select_c, 15, p_select_rec.exchange_date );
752: dbms_sql.define_column( p_select_c, 16, p_select_rec.trx_number, 20 );
746: dbms_sql.define_column( p_select_c, 12,
747: p_select_rec.currency_code, 15 );
748: dbms_sql.define_column( p_select_c, 13,
749: p_select_rec.exchange_rate_type, 30 );
750: dbms_sql.define_column( p_select_c, 14, p_select_rec.exchange_rate );
751: dbms_sql.define_column( p_select_c, 15, p_select_rec.exchange_date );
752: dbms_sql.define_column( p_select_c, 16, p_select_rec.trx_number, 20 );
753: dbms_sql.define_column( p_select_c, 17, p_select_rec.trx_date );
754: dbms_sql.define_column( p_select_c, 18, p_select_rec.percent );
747: p_select_rec.currency_code, 15 );
748: dbms_sql.define_column( p_select_c, 13,
749: p_select_rec.exchange_rate_type, 30 );
750: dbms_sql.define_column( p_select_c, 14, p_select_rec.exchange_rate );
751: dbms_sql.define_column( p_select_c, 15, p_select_rec.exchange_date );
752: dbms_sql.define_column( p_select_c, 16, p_select_rec.trx_number, 20 );
753: dbms_sql.define_column( p_select_c, 17, p_select_rec.trx_date );
754: dbms_sql.define_column( p_select_c, 18, p_select_rec.percent );
755: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
748: dbms_sql.define_column( p_select_c, 13,
749: p_select_rec.exchange_rate_type, 30 );
750: dbms_sql.define_column( p_select_c, 14, p_select_rec.exchange_rate );
751: dbms_sql.define_column( p_select_c, 15, p_select_rec.exchange_date );
752: dbms_sql.define_column( p_select_c, 16, p_select_rec.trx_number, 20 );
753: dbms_sql.define_column( p_select_c, 17, p_select_rec.trx_date );
754: dbms_sql.define_column( p_select_c, 18, p_select_rec.percent );
755: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
756: dbms_sql.define_column( p_select_c, 20,
749: p_select_rec.exchange_rate_type, 30 );
750: dbms_sql.define_column( p_select_c, 14, p_select_rec.exchange_rate );
751: dbms_sql.define_column( p_select_c, 15, p_select_rec.exchange_date );
752: dbms_sql.define_column( p_select_c, 16, p_select_rec.trx_number, 20 );
753: dbms_sql.define_column( p_select_c, 17, p_select_rec.trx_date );
754: dbms_sql.define_column( p_select_c, 18, p_select_rec.percent );
755: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
756: dbms_sql.define_column( p_select_c, 20,
757: p_select_rec.first_installment_code, 12 );
750: dbms_sql.define_column( p_select_c, 14, p_select_rec.exchange_rate );
751: dbms_sql.define_column( p_select_c, 15, p_select_rec.exchange_date );
752: dbms_sql.define_column( p_select_c, 16, p_select_rec.trx_number, 20 );
753: dbms_sql.define_column( p_select_c, 17, p_select_rec.trx_date );
754: dbms_sql.define_column( p_select_c, 18, p_select_rec.percent );
755: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
756: dbms_sql.define_column( p_select_c, 20,
757: p_select_rec.first_installment_code, 12 );
758: dbms_sql.define_column( p_select_c, 21,
751: dbms_sql.define_column( p_select_c, 15, p_select_rec.exchange_date );
752: dbms_sql.define_column( p_select_c, 16, p_select_rec.trx_number, 20 );
753: dbms_sql.define_column( p_select_c, 17, p_select_rec.trx_date );
754: dbms_sql.define_column( p_select_c, 18, p_select_rec.percent );
755: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
756: dbms_sql.define_column( p_select_c, 20,
757: p_select_rec.first_installment_code, 12 );
758: dbms_sql.define_column( p_select_c, 21,
759: p_select_rec.min_acc_unit );
752: dbms_sql.define_column( p_select_c, 16, p_select_rec.trx_number, 20 );
753: dbms_sql.define_column( p_select_c, 17, p_select_rec.trx_date );
754: dbms_sql.define_column( p_select_c, 18, p_select_rec.percent );
755: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
756: dbms_sql.define_column( p_select_c, 20,
757: p_select_rec.first_installment_code, 12 );
758: dbms_sql.define_column( p_select_c, 21,
759: p_select_rec.min_acc_unit );
760: dbms_sql.define_column( p_select_c, 22, p_select_rec.gl_date );
754: dbms_sql.define_column( p_select_c, 18, p_select_rec.percent );
755: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
756: dbms_sql.define_column( p_select_c, 20,
757: p_select_rec.first_installment_code, 12 );
758: dbms_sql.define_column( p_select_c, 21,
759: p_select_rec.min_acc_unit );
760: dbms_sql.define_column( p_select_c, 22, p_select_rec.gl_date );
761:
762: dbms_sql.define_column( p_select_c, 23, p_select_rec.rec_acctd_amount );
756: dbms_sql.define_column( p_select_c, 20,
757: p_select_rec.first_installment_code, 12 );
758: dbms_sql.define_column( p_select_c, 21,
759: p_select_rec.min_acc_unit );
760: dbms_sql.define_column( p_select_c, 22, p_select_rec.gl_date );
761:
762: dbms_sql.define_column( p_select_c, 23, p_select_rec.rec_acctd_amount );
763: dbms_sql.define_column( p_select_c, 24,
764: p_select_rec.total_charges_amount );
758: dbms_sql.define_column( p_select_c, 21,
759: p_select_rec.min_acc_unit );
760: dbms_sql.define_column( p_select_c, 22, p_select_rec.gl_date );
761:
762: dbms_sql.define_column( p_select_c, 23, p_select_rec.rec_acctd_amount );
763: dbms_sql.define_column( p_select_c, 24,
764: p_select_rec.total_charges_amount );
765: dbms_sql.define_column( p_select_c, 25,p_select_rec.reversed_cash_receipt_id); /*Bug3328690 */
766:
759: p_select_rec.min_acc_unit );
760: dbms_sql.define_column( p_select_c, 22, p_select_rec.gl_date );
761:
762: dbms_sql.define_column( p_select_c, 23, p_select_rec.rec_acctd_amount );
763: dbms_sql.define_column( p_select_c, 24,
764: p_select_rec.total_charges_amount );
765: dbms_sql.define_column( p_select_c, 25,p_select_rec.reversed_cash_receipt_id); /*Bug3328690 */
766:
767:
761:
762: dbms_sql.define_column( p_select_c, 23, p_select_rec.rec_acctd_amount );
763: dbms_sql.define_column( p_select_c, 24,
764: p_select_rec.total_charges_amount );
765: dbms_sql.define_column( p_select_c, 25,p_select_rec.reversed_cash_receipt_id); /*Bug3328690 */
766:
767:
768: print_fcn_label2( 'arp_maintain_ps2.define_ips_select_columns()-' );
769:
781: /* Bug 460927 - Modified IN to IN OUT in the above line - Oracle 8 */
782: BEGIN
783: print_fcn_label2( 'arp_maintain_ps2.get_ips_column_values()+' );
784:
785: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
786: dbms_sql.column_value( p_select_c, 2, p_select_rec.total_line_amount );
787: dbms_sql.column_value( p_select_c, 3, p_select_rec.total_tax_amount );
788: dbms_sql.column_value( p_select_c, 4, p_select_rec.total_freight_amount );
789: dbms_sql.column_value( p_select_c, 5, p_select_rec.term_id );
782: BEGIN
783: print_fcn_label2( 'arp_maintain_ps2.get_ips_column_values()+' );
784:
785: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
786: dbms_sql.column_value( p_select_c, 2, p_select_rec.total_line_amount );
787: dbms_sql.column_value( p_select_c, 3, p_select_rec.total_tax_amount );
788: dbms_sql.column_value( p_select_c, 4, p_select_rec.total_freight_amount );
789: dbms_sql.column_value( p_select_c, 5, p_select_rec.term_id );
790: dbms_sql.column_value( p_select_c, 6, p_select_rec.term_sequence_num );
783: print_fcn_label2( 'arp_maintain_ps2.get_ips_column_values()+' );
784:
785: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
786: dbms_sql.column_value( p_select_c, 2, p_select_rec.total_line_amount );
787: dbms_sql.column_value( p_select_c, 3, p_select_rec.total_tax_amount );
788: dbms_sql.column_value( p_select_c, 4, p_select_rec.total_freight_amount );
789: dbms_sql.column_value( p_select_c, 5, p_select_rec.term_id );
790: dbms_sql.column_value( p_select_c, 6, p_select_rec.term_sequence_num );
791: dbms_sql.column_value( p_select_c, 7, p_select_rec.due_date );
784:
785: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
786: dbms_sql.column_value( p_select_c, 2, p_select_rec.total_line_amount );
787: dbms_sql.column_value( p_select_c, 3, p_select_rec.total_tax_amount );
788: dbms_sql.column_value( p_select_c, 4, p_select_rec.total_freight_amount );
789: dbms_sql.column_value( p_select_c, 5, p_select_rec.term_id );
790: dbms_sql.column_value( p_select_c, 6, p_select_rec.term_sequence_num );
791: dbms_sql.column_value( p_select_c, 7, p_select_rec.due_date );
792: dbms_sql.column_value( p_select_c, 8, p_select_rec.customer_id );
785: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
786: dbms_sql.column_value( p_select_c, 2, p_select_rec.total_line_amount );
787: dbms_sql.column_value( p_select_c, 3, p_select_rec.total_tax_amount );
788: dbms_sql.column_value( p_select_c, 4, p_select_rec.total_freight_amount );
789: dbms_sql.column_value( p_select_c, 5, p_select_rec.term_id );
790: dbms_sql.column_value( p_select_c, 6, p_select_rec.term_sequence_num );
791: dbms_sql.column_value( p_select_c, 7, p_select_rec.due_date );
792: dbms_sql.column_value( p_select_c, 8, p_select_rec.customer_id );
793: dbms_sql.column_value( p_select_c, 9, p_select_rec.trx_type );
786: dbms_sql.column_value( p_select_c, 2, p_select_rec.total_line_amount );
787: dbms_sql.column_value( p_select_c, 3, p_select_rec.total_tax_amount );
788: dbms_sql.column_value( p_select_c, 4, p_select_rec.total_freight_amount );
789: dbms_sql.column_value( p_select_c, 5, p_select_rec.term_id );
790: dbms_sql.column_value( p_select_c, 6, p_select_rec.term_sequence_num );
791: dbms_sql.column_value( p_select_c, 7, p_select_rec.due_date );
792: dbms_sql.column_value( p_select_c, 8, p_select_rec.customer_id );
793: dbms_sql.column_value( p_select_c, 9, p_select_rec.trx_type );
794: dbms_sql.column_value( p_select_c, 10, p_select_rec.site_use_id );
787: dbms_sql.column_value( p_select_c, 3, p_select_rec.total_tax_amount );
788: dbms_sql.column_value( p_select_c, 4, p_select_rec.total_freight_amount );
789: dbms_sql.column_value( p_select_c, 5, p_select_rec.term_id );
790: dbms_sql.column_value( p_select_c, 6, p_select_rec.term_sequence_num );
791: dbms_sql.column_value( p_select_c, 7, p_select_rec.due_date );
792: dbms_sql.column_value( p_select_c, 8, p_select_rec.customer_id );
793: dbms_sql.column_value( p_select_c, 9, p_select_rec.trx_type );
794: dbms_sql.column_value( p_select_c, 10, p_select_rec.site_use_id );
795: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
788: dbms_sql.column_value( p_select_c, 4, p_select_rec.total_freight_amount );
789: dbms_sql.column_value( p_select_c, 5, p_select_rec.term_id );
790: dbms_sql.column_value( p_select_c, 6, p_select_rec.term_sequence_num );
791: dbms_sql.column_value( p_select_c, 7, p_select_rec.due_date );
792: dbms_sql.column_value( p_select_c, 8, p_select_rec.customer_id );
793: dbms_sql.column_value( p_select_c, 9, p_select_rec.trx_type );
794: dbms_sql.column_value( p_select_c, 10, p_select_rec.site_use_id );
795: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
796: dbms_sql.column_value( p_select_c, 12,
789: dbms_sql.column_value( p_select_c, 5, p_select_rec.term_id );
790: dbms_sql.column_value( p_select_c, 6, p_select_rec.term_sequence_num );
791: dbms_sql.column_value( p_select_c, 7, p_select_rec.due_date );
792: dbms_sql.column_value( p_select_c, 8, p_select_rec.customer_id );
793: dbms_sql.column_value( p_select_c, 9, p_select_rec.trx_type );
794: dbms_sql.column_value( p_select_c, 10, p_select_rec.site_use_id );
795: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
796: dbms_sql.column_value( p_select_c, 12,
797: p_select_rec.currency_code );
790: dbms_sql.column_value( p_select_c, 6, p_select_rec.term_sequence_num );
791: dbms_sql.column_value( p_select_c, 7, p_select_rec.due_date );
792: dbms_sql.column_value( p_select_c, 8, p_select_rec.customer_id );
793: dbms_sql.column_value( p_select_c, 9, p_select_rec.trx_type );
794: dbms_sql.column_value( p_select_c, 10, p_select_rec.site_use_id );
795: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
796: dbms_sql.column_value( p_select_c, 12,
797: p_select_rec.currency_code );
798: dbms_sql.column_value( p_select_c, 13,
791: dbms_sql.column_value( p_select_c, 7, p_select_rec.due_date );
792: dbms_sql.column_value( p_select_c, 8, p_select_rec.customer_id );
793: dbms_sql.column_value( p_select_c, 9, p_select_rec.trx_type );
794: dbms_sql.column_value( p_select_c, 10, p_select_rec.site_use_id );
795: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
796: dbms_sql.column_value( p_select_c, 12,
797: p_select_rec.currency_code );
798: dbms_sql.column_value( p_select_c, 13,
799: p_select_rec.exchange_rate_type );
792: dbms_sql.column_value( p_select_c, 8, p_select_rec.customer_id );
793: dbms_sql.column_value( p_select_c, 9, p_select_rec.trx_type );
794: dbms_sql.column_value( p_select_c, 10, p_select_rec.site_use_id );
795: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
796: dbms_sql.column_value( p_select_c, 12,
797: p_select_rec.currency_code );
798: dbms_sql.column_value( p_select_c, 13,
799: p_select_rec.exchange_rate_type );
800: dbms_sql.column_value( p_select_c, 14, p_select_rec.exchange_rate );
794: dbms_sql.column_value( p_select_c, 10, p_select_rec.site_use_id );
795: dbms_sql.column_value( p_select_c, 11, p_select_rec.cust_trx_type_id );
796: dbms_sql.column_value( p_select_c, 12,
797: p_select_rec.currency_code );
798: dbms_sql.column_value( p_select_c, 13,
799: p_select_rec.exchange_rate_type );
800: dbms_sql.column_value( p_select_c, 14, p_select_rec.exchange_rate );
801: dbms_sql.column_value( p_select_c, 15, p_select_rec.exchange_date );
802: dbms_sql.column_value( p_select_c, 16, p_select_rec.trx_number );
796: dbms_sql.column_value( p_select_c, 12,
797: p_select_rec.currency_code );
798: dbms_sql.column_value( p_select_c, 13,
799: p_select_rec.exchange_rate_type );
800: dbms_sql.column_value( p_select_c, 14, p_select_rec.exchange_rate );
801: dbms_sql.column_value( p_select_c, 15, p_select_rec.exchange_date );
802: dbms_sql.column_value( p_select_c, 16, p_select_rec.trx_number );
803: dbms_sql.column_value( p_select_c, 17, p_select_rec.trx_date );
804: dbms_sql.column_value( p_select_c, 18, p_select_rec.percent );
797: p_select_rec.currency_code );
798: dbms_sql.column_value( p_select_c, 13,
799: p_select_rec.exchange_rate_type );
800: dbms_sql.column_value( p_select_c, 14, p_select_rec.exchange_rate );
801: dbms_sql.column_value( p_select_c, 15, p_select_rec.exchange_date );
802: dbms_sql.column_value( p_select_c, 16, p_select_rec.trx_number );
803: dbms_sql.column_value( p_select_c, 17, p_select_rec.trx_date );
804: dbms_sql.column_value( p_select_c, 18, p_select_rec.percent );
805: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
798: dbms_sql.column_value( p_select_c, 13,
799: p_select_rec.exchange_rate_type );
800: dbms_sql.column_value( p_select_c, 14, p_select_rec.exchange_rate );
801: dbms_sql.column_value( p_select_c, 15, p_select_rec.exchange_date );
802: dbms_sql.column_value( p_select_c, 16, p_select_rec.trx_number );
803: dbms_sql.column_value( p_select_c, 17, p_select_rec.trx_date );
804: dbms_sql.column_value( p_select_c, 18, p_select_rec.percent );
805: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
806: dbms_sql.column_value( p_select_c, 20,
799: p_select_rec.exchange_rate_type );
800: dbms_sql.column_value( p_select_c, 14, p_select_rec.exchange_rate );
801: dbms_sql.column_value( p_select_c, 15, p_select_rec.exchange_date );
802: dbms_sql.column_value( p_select_c, 16, p_select_rec.trx_number );
803: dbms_sql.column_value( p_select_c, 17, p_select_rec.trx_date );
804: dbms_sql.column_value( p_select_c, 18, p_select_rec.percent );
805: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
806: dbms_sql.column_value( p_select_c, 20,
807: p_select_rec.first_installment_code );
800: dbms_sql.column_value( p_select_c, 14, p_select_rec.exchange_rate );
801: dbms_sql.column_value( p_select_c, 15, p_select_rec.exchange_date );
802: dbms_sql.column_value( p_select_c, 16, p_select_rec.trx_number );
803: dbms_sql.column_value( p_select_c, 17, p_select_rec.trx_date );
804: dbms_sql.column_value( p_select_c, 18, p_select_rec.percent );
805: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
806: dbms_sql.column_value( p_select_c, 20,
807: p_select_rec.first_installment_code );
808: dbms_sql.column_value( p_select_c, 21,
801: dbms_sql.column_value( p_select_c, 15, p_select_rec.exchange_date );
802: dbms_sql.column_value( p_select_c, 16, p_select_rec.trx_number );
803: dbms_sql.column_value( p_select_c, 17, p_select_rec.trx_date );
804: dbms_sql.column_value( p_select_c, 18, p_select_rec.percent );
805: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
806: dbms_sql.column_value( p_select_c, 20,
807: p_select_rec.first_installment_code );
808: dbms_sql.column_value( p_select_c, 21,
809: p_select_rec.min_acc_unit );
802: dbms_sql.column_value( p_select_c, 16, p_select_rec.trx_number );
803: dbms_sql.column_value( p_select_c, 17, p_select_rec.trx_date );
804: dbms_sql.column_value( p_select_c, 18, p_select_rec.percent );
805: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
806: dbms_sql.column_value( p_select_c, 20,
807: p_select_rec.first_installment_code );
808: dbms_sql.column_value( p_select_c, 21,
809: p_select_rec.min_acc_unit );
810: dbms_sql.column_value( p_select_c, 22, p_select_rec.gl_date );
804: dbms_sql.column_value( p_select_c, 18, p_select_rec.percent );
805: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
806: dbms_sql.column_value( p_select_c, 20,
807: p_select_rec.first_installment_code );
808: dbms_sql.column_value( p_select_c, 21,
809: p_select_rec.min_acc_unit );
810: dbms_sql.column_value( p_select_c, 22, p_select_rec.gl_date );
811:
812: dbms_sql.column_value( p_select_c, 23, p_select_rec.rec_acctd_amount );
806: dbms_sql.column_value( p_select_c, 20,
807: p_select_rec.first_installment_code );
808: dbms_sql.column_value( p_select_c, 21,
809: p_select_rec.min_acc_unit );
810: dbms_sql.column_value( p_select_c, 22, p_select_rec.gl_date );
811:
812: dbms_sql.column_value( p_select_c, 23, p_select_rec.rec_acctd_amount );
813: dbms_sql.column_value( p_select_c, 24, p_select_rec.total_charges_amount );
814: dbms_sql.column_value( p_select_c, 25, p_select_rec.reversed_cash_receipt_id); /*Bug3328690 */
808: dbms_sql.column_value( p_select_c, 21,
809: p_select_rec.min_acc_unit );
810: dbms_sql.column_value( p_select_c, 22, p_select_rec.gl_date );
811:
812: dbms_sql.column_value( p_select_c, 23, p_select_rec.rec_acctd_amount );
813: dbms_sql.column_value( p_select_c, 24, p_select_rec.total_charges_amount );
814: dbms_sql.column_value( p_select_c, 25, p_select_rec.reversed_cash_receipt_id); /*Bug3328690 */
815:
816: print_fcn_label2( 'arp_maintain_ps2.get_ips_column_values()-' );
809: p_select_rec.min_acc_unit );
810: dbms_sql.column_value( p_select_c, 22, p_select_rec.gl_date );
811:
812: dbms_sql.column_value( p_select_c, 23, p_select_rec.rec_acctd_amount );
813: dbms_sql.column_value( p_select_c, 24, p_select_rec.total_charges_amount );
814: dbms_sql.column_value( p_select_c, 25, p_select_rec.reversed_cash_receipt_id); /*Bug3328690 */
815:
816: print_fcn_label2( 'arp_maintain_ps2.get_ips_column_values()-' );
817: EXCEPTION
810: dbms_sql.column_value( p_select_c, 22, p_select_rec.gl_date );
811:
812: dbms_sql.column_value( p_select_c, 23, p_select_rec.rec_acctd_amount );
813: dbms_sql.column_value( p_select_c, 24, p_select_rec.total_charges_amount );
814: dbms_sql.column_value( p_select_c, 25, p_select_rec.reversed_cash_receipt_id); /*Bug3328690 */
815:
816: print_fcn_label2( 'arp_maintain_ps2.get_ips_column_values()-' );
817: EXCEPTION
818: WHEN OTHERS THEN
1036: -------------------------------------------------------------
1037: BEGIN
1038: debug( ' Binding insert_ps_c', MSG_LEVEL_DEBUG );
1039:
1040: dbms_sql.bind_variable( p_insert_ps_c,
1041: 'user_id',
1042: p_profile_info.user_id );
1043:
1044: dbms_sql.bind_variable( p_insert_ps_c,
1040: dbms_sql.bind_variable( p_insert_ps_c,
1041: 'user_id',
1042: p_profile_info.user_id );
1043:
1044: dbms_sql.bind_variable( p_insert_ps_c,
1045: 'login_id',
1046: p_profile_info.conc_login_id );
1047:
1048: dbms_sql.bind_variable( p_insert_ps_c,
1044: dbms_sql.bind_variable( p_insert_ps_c,
1045: 'login_id',
1046: p_profile_info.conc_login_id );
1047:
1048: dbms_sql.bind_variable( p_insert_ps_c,
1049: 'request_id',
1050: p_profile_info.request_id );
1051:
1052: dbms_sql.bind_variable( p_insert_ps_c,
1048: dbms_sql.bind_variable( p_insert_ps_c,
1049: 'request_id',
1050: p_profile_info.request_id );
1051:
1052: dbms_sql.bind_variable( p_insert_ps_c,
1053: 'application_id',
1054: p_profile_info.application_id );
1055:
1056: dbms_sql.bind_variable( p_insert_ps_c,
1052: dbms_sql.bind_variable( p_insert_ps_c,
1053: 'application_id',
1054: p_profile_info.application_id );
1055:
1056: dbms_sql.bind_variable( p_insert_ps_c,
1057: 'program_id',
1058: p_profile_info.conc_program_id );
1059:
1060: /* retrieve the next payment schedule id. Added for
1063: SELECT ar_payment_schedules_s.nextval
1064: INTO l_ps_id
1065: FROM dual;
1066:
1067: dbms_sql.bind_variable( p_insert_ps_c,
1068: 'payment_schedule_id',
1069: l_ps_id );
1070:
1071:
1068: 'payment_schedule_id',
1069: l_ps_id );
1070:
1071:
1072: dbms_sql.bind_variable( p_insert_ps_c,
1073: 'customer_trx_id',
1074: p_select_rec.customer_trx_id );
1075:
1076: dbms_sql.bind_variable( p_insert_ps_c,
1072: dbms_sql.bind_variable( p_insert_ps_c,
1073: 'customer_trx_id',
1074: p_select_rec.customer_trx_id );
1075:
1076: dbms_sql.bind_variable( p_insert_ps_c,
1077: 'line_amt',
1078: p_line_amount_t(i) );
1079:
1080: dbms_sql.bind_variable( p_insert_ps_c,
1076: dbms_sql.bind_variable( p_insert_ps_c,
1077: 'line_amt',
1078: p_line_amount_t(i) );
1079:
1080: dbms_sql.bind_variable( p_insert_ps_c,
1081: 'tax_amt',
1082: p_tax_amount_t(i) );
1083:
1084: dbms_sql.bind_variable( p_insert_ps_c,
1080: dbms_sql.bind_variable( p_insert_ps_c,
1081: 'tax_amt',
1082: p_tax_amount_t(i) );
1083:
1084: dbms_sql.bind_variable( p_insert_ps_c,
1085: 'frt_amt',
1086: p_freight_amount_t(i) );
1087:
1088: dbms_sql.bind_variable( p_insert_ps_c,
1084: dbms_sql.bind_variable( p_insert_ps_c,
1085: 'frt_amt',
1086: p_freight_amount_t(i) );
1087:
1088: dbms_sql.bind_variable( p_insert_ps_c,
1089: 'charge_amt',
1090: p_charges_amount_t(i) );
1091:
1092: dbms_sql.bind_variable( p_insert_ps_c,
1088: dbms_sql.bind_variable( p_insert_ps_c,
1089: 'charge_amt',
1090: p_charges_amount_t(i) );
1091:
1092: dbms_sql.bind_variable( p_insert_ps_c,
1093: 'acctd_adr',
1094: p_acctd_amt_due_rem_t(i) );
1095:
1096: dbms_sql.bind_variable( p_insert_ps_c,
1092: dbms_sql.bind_variable( p_insert_ps_c,
1093: 'acctd_adr',
1094: p_acctd_amt_due_rem_t(i) );
1095:
1096: dbms_sql.bind_variable( p_insert_ps_c,
1097: 'terms_sequence_number',
1098: p_terms_sequence_num_t(i) );
1099:
1100: dbms_sql.bind_variable( p_insert_ps_c,
1096: dbms_sql.bind_variable( p_insert_ps_c,
1097: 'terms_sequence_number',
1098: p_terms_sequence_num_t(i) );
1099:
1100: dbms_sql.bind_variable( p_insert_ps_c,
1101: 'due_date',
1102: p_due_date_t(i) );
1103:
1104: dbms_sql.bind_variable( p_insert_ps_c,
1100: dbms_sql.bind_variable( p_insert_ps_c,
1101: 'due_date',
1102: p_due_date_t(i) );
1103:
1104: dbms_sql.bind_variable( p_insert_ps_c,
1105: 'term_id',
1106: p_select_rec.term_id );
1107:
1108: dbms_sql.bind_variable( p_insert_ps_c,
1104: dbms_sql.bind_variable( p_insert_ps_c,
1105: 'term_id',
1106: p_select_rec.term_id );
1107:
1108: dbms_sql.bind_variable( p_insert_ps_c,
1109: 'customer_id',
1110: p_select_rec.customer_id );
1111:
1112: dbms_sql.bind_variable( p_insert_ps_c,
1108: dbms_sql.bind_variable( p_insert_ps_c,
1109: 'customer_id',
1110: p_select_rec.customer_id );
1111:
1112: dbms_sql.bind_variable( p_insert_ps_c,
1113: 'type',
1114: p_select_rec.trx_type );
1115:
1116: dbms_sql.bind_variable( p_insert_ps_c,
1112: dbms_sql.bind_variable( p_insert_ps_c,
1113: 'type',
1114: p_select_rec.trx_type );
1115:
1116: dbms_sql.bind_variable( p_insert_ps_c,
1117: 'site_use_id',
1118: p_select_rec.site_use_id );
1119:
1120: dbms_sql.bind_variable( p_insert_ps_c,
1116: dbms_sql.bind_variable( p_insert_ps_c,
1117: 'site_use_id',
1118: p_select_rec.site_use_id );
1119:
1120: dbms_sql.bind_variable( p_insert_ps_c,
1121: 'cust_trx_type_id',
1122: p_select_rec.cust_trx_type_id );
1123:
1124: dbms_sql.bind_variable( p_insert_ps_c,
1120: dbms_sql.bind_variable( p_insert_ps_c,
1121: 'cust_trx_type_id',
1122: p_select_rec.cust_trx_type_id );
1123:
1124: dbms_sql.bind_variable( p_insert_ps_c,
1125: 'currency_code',
1126: p_select_rec.currency_code );
1127:
1128: dbms_sql.bind_variable( p_insert_ps_c,
1124: dbms_sql.bind_variable( p_insert_ps_c,
1125: 'currency_code',
1126: p_select_rec.currency_code );
1127:
1128: dbms_sql.bind_variable( p_insert_ps_c,
1129: 'trx_date',
1130: p_select_rec.trx_date );
1131:
1132: dbms_sql.bind_variable( p_insert_ps_c,
1128: dbms_sql.bind_variable( p_insert_ps_c,
1129: 'trx_date',
1130: p_select_rec.trx_date );
1131:
1132: dbms_sql.bind_variable( p_insert_ps_c,
1133: 'gl_date',
1134: p_select_rec.gl_date );
1135:
1136: dbms_sql.bind_variable( p_insert_ps_c,
1132: dbms_sql.bind_variable( p_insert_ps_c,
1133: 'gl_date',
1134: p_select_rec.gl_date );
1135:
1136: dbms_sql.bind_variable( p_insert_ps_c,
1137: 'trx_number',
1138: p_select_rec.trx_number );
1139:
1140: dbms_sql.bind_variable( p_insert_ps_c,
1136: dbms_sql.bind_variable( p_insert_ps_c,
1137: 'trx_number',
1138: p_select_rec.trx_number );
1139:
1140: dbms_sql.bind_variable( p_insert_ps_c,
1141: 'exchange_rate_type',
1142: p_select_rec.exchange_rate_type );
1143:
1144: dbms_sql.bind_variable( p_insert_ps_c,
1140: dbms_sql.bind_variable( p_insert_ps_c,
1141: 'exchange_rate_type',
1142: p_select_rec.exchange_rate_type );
1143:
1144: dbms_sql.bind_variable( p_insert_ps_c,
1145: 'exchange_rate',
1146: p_select_rec.exchange_rate );
1147:
1148: dbms_sql.bind_variable( p_insert_ps_c,
1144: dbms_sql.bind_variable( p_insert_ps_c,
1145: 'exchange_rate',
1146: p_select_rec.exchange_rate );
1147:
1148: dbms_sql.bind_variable( p_insert_ps_c,
1149: 'exchange_date',
1150: p_select_rec.exchange_date );
1151:
1152: dbms_sql.bind_variable( p_insert_ps_c,
1148: dbms_sql.bind_variable( p_insert_ps_c,
1149: 'exchange_date',
1150: p_select_rec.exchange_date );
1151:
1152: dbms_sql.bind_variable( p_insert_ps_c,
1153: 'number_of_due_dates',
1154: p_number_of_due_dates );
1155:
1156: dbms_sql.bind_variable( p_insert_ps_c,
1152: dbms_sql.bind_variable( p_insert_ps_c,
1153: 'number_of_due_dates',
1154: p_number_of_due_dates );
1155:
1156: dbms_sql.bind_variable( p_insert_ps_c,
1157: 'reversed_cash_receipt_id',
1158: p_select_rec.reversed_cash_receipt_id );
1159:
1160: --anuj
1157: 'reversed_cash_receipt_id',
1158: p_select_rec.reversed_cash_receipt_id );
1159:
1160: --anuj
1161: dbms_sql.bind_variable( p_insert_ps_c,
1162: 'org_id',
1163: arp_standard.sysparm.org_id /* SSA changes anuj */ );
1164:
1165: EXCEPTION
1173: -- Execute
1174: -------------------------------------------------------------
1175: BEGIN
1176: debug( ' Inserting payment schedules', MSG_LEVEL_DEBUG );
1177: l_ignore := dbms_sql.execute( p_insert_ps_c );
1178: debug( to_char(l_ignore) || ' row(s) inserted',
1179: MSG_LEVEL_DEBUG );
1180:
1181: /* Call JL for locking the invoice for approval if JL is installed.
1306:
1307: --
1308: clear_tables;
1309: --
1310: IF( NOT( dbms_sql.is_open( ips_select_c ) AND
1311: dbms_sql.is_open( ips_insert_ps_c ) )) THEN
1312:
1313: build_ips_sql( system_info,
1314: profile_info,
1307: --
1308: clear_tables;
1309: --
1310: IF( NOT( dbms_sql.is_open( ips_select_c ) AND
1311: dbms_sql.is_open( ips_insert_ps_c ) )) THEN
1312:
1313: build_ips_sql( system_info,
1314: profile_info,
1315: ips_select_c,
1321:
1322: ---------------------------------------------------------------
1323: -- Bind variables
1324: ---------------------------------------------------------------
1325: dbms_sql.bind_variable( ips_select_c,
1326: 'customer_trx_id',
1327: p_customer_trx_id );
1328:
1329: ---------------------------------------------------------------
1331: ---------------------------------------------------------------
1332: debug( ' Executing select sql', MSG_LEVEL_DEBUG );
1333:
1334: BEGIN
1335: l_ignore := dbms_sql.execute( ips_select_c );
1336:
1337: EXCEPTION
1338: WHEN OTHERS THEN
1339: debug( 'EXCEPTION: Error executing select sql',
1347: ---------------------------------------------------------------
1348: BEGIN
1349: LOOP
1350:
1351: IF dbms_sql.fetch_rows( ips_select_c ) > 0 THEN
1352:
1353: debug(' Fetched a row', MSG_LEVEL_DEBUG );
1354:
1355: -----------------------------------------------
1354:
1355: -----------------------------------------------
1356: -- Load row into record
1357: -----------------------------------------------
1358: dbms_sql.column_value( ips_select_c, 1, l_customer_trx_id );
1359:
1360: IF( l_old_trx_id IS NULL OR
1361: l_customer_trx_id <> l_old_trx_id ) THEN
1362:
1884: BEGIN
1885: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
1886:
1887: debug( ' Parsing insert_ps_c', MSG_LEVEL_DEBUG );
1888: p_insert_ps_c := dbms_sql.open_cursor;
1889: dbms_sql.parse( p_insert_ps_c, l_insert_ps_sql,
1890: dbms_sql.v7 );
1891:
1892: debug( ' Parsing insert_ra_c', MSG_LEVEL_DEBUG );
1885: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
1886:
1887: debug( ' Parsing insert_ps_c', MSG_LEVEL_DEBUG );
1888: p_insert_ps_c := dbms_sql.open_cursor;
1889: dbms_sql.parse( p_insert_ps_c, l_insert_ps_sql,
1890: dbms_sql.v7 );
1891:
1892: debug( ' Parsing insert_ra_c', MSG_LEVEL_DEBUG );
1893: p_insert_ra_c := dbms_sql.open_cursor;
1886:
1887: debug( ' Parsing insert_ps_c', MSG_LEVEL_DEBUG );
1888: p_insert_ps_c := dbms_sql.open_cursor;
1889: dbms_sql.parse( p_insert_ps_c, l_insert_ps_sql,
1890: dbms_sql.v7 );
1891:
1892: debug( ' Parsing insert_ra_c', MSG_LEVEL_DEBUG );
1893: p_insert_ra_c := dbms_sql.open_cursor;
1894: dbms_sql.parse( p_insert_ra_c, l_insert_ra_sql,
1889: dbms_sql.parse( p_insert_ps_c, l_insert_ps_sql,
1890: dbms_sql.v7 );
1891:
1892: debug( ' Parsing insert_ra_c', MSG_LEVEL_DEBUG );
1893: p_insert_ra_c := dbms_sql.open_cursor;
1894: dbms_sql.parse( p_insert_ra_c, l_insert_ra_sql,
1895: dbms_sql.v7 );
1896:
1897: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
1890: dbms_sql.v7 );
1891:
1892: debug( ' Parsing insert_ra_c', MSG_LEVEL_DEBUG );
1893: p_insert_ra_c := dbms_sql.open_cursor;
1894: dbms_sql.parse( p_insert_ra_c, l_insert_ra_sql,
1895: dbms_sql.v7 );
1896:
1897: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
1898: p_update_ps_c := dbms_sql.open_cursor;
1891:
1892: debug( ' Parsing insert_ra_c', MSG_LEVEL_DEBUG );
1893: p_insert_ra_c := dbms_sql.open_cursor;
1894: dbms_sql.parse( p_insert_ra_c, l_insert_ra_sql,
1895: dbms_sql.v7 );
1896:
1897: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
1898: p_update_ps_c := dbms_sql.open_cursor;
1899: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
1894: dbms_sql.parse( p_insert_ra_c, l_insert_ra_sql,
1895: dbms_sql.v7 );
1896:
1897: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
1898: p_update_ps_c := dbms_sql.open_cursor;
1899: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
1900: dbms_sql.v7 );
1901:
1902: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
1895: dbms_sql.v7 );
1896:
1897: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
1898: p_update_ps_c := dbms_sql.open_cursor;
1899: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
1900: dbms_sql.v7 );
1901:
1902: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
1903: p_select_c := dbms_sql.open_cursor;
1896:
1897: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
1898: p_update_ps_c := dbms_sql.open_cursor;
1899: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
1900: dbms_sql.v7 );
1901:
1902: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
1903: p_select_c := dbms_sql.open_cursor;
1904: dbms_sql.parse( p_select_c, l_select_sql,
1899: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
1900: dbms_sql.v7 );
1901:
1902: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
1903: p_select_c := dbms_sql.open_cursor;
1904: dbms_sql.parse( p_select_c, l_select_sql,
1905: dbms_sql.v7 );
1906:
1907: EXCEPTION
1900: dbms_sql.v7 );
1901:
1902: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
1903: p_select_c := dbms_sql.open_cursor;
1904: dbms_sql.parse( p_select_c, l_select_sql,
1905: dbms_sql.v7 );
1906:
1907: EXCEPTION
1908: WHEN OTHERS THEN
1901:
1902: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
1903: p_select_c := dbms_sql.open_cursor;
1904: dbms_sql.parse( p_select_c, l_select_sql,
1905: dbms_sql.v7 );
1906:
1907: EXCEPTION
1908: WHEN OTHERS THEN
1909: IF PG_DEBUG in ('Y', 'C') THEN
1933: BEGIN
1934:
1935: print_fcn_label2( 'arp_maintain_ps2.define_ira_select_columns()+' );
1936:
1937: dbms_sql.define_column( p_select_c, 1, p_select_rec.trx_date );
1938: dbms_sql.define_column( p_select_c, 2, p_select_rec.customer_id );
1939: dbms_sql.define_column( p_select_c, 3, p_select_rec.cust_trx_type_id );
1940: dbms_sql.define_column( p_select_c, 4, p_select_rec.customer_trx_id );
1941: dbms_sql.define_column( p_select_c, 5, p_select_rec.currency_code, 15 );
1934:
1935: print_fcn_label2( 'arp_maintain_ps2.define_ira_select_columns()+' );
1936:
1937: dbms_sql.define_column( p_select_c, 1, p_select_rec.trx_date );
1938: dbms_sql.define_column( p_select_c, 2, p_select_rec.customer_id );
1939: dbms_sql.define_column( p_select_c, 3, p_select_rec.cust_trx_type_id );
1940: dbms_sql.define_column( p_select_c, 4, p_select_rec.customer_trx_id );
1941: dbms_sql.define_column( p_select_c, 5, p_select_rec.currency_code, 15 );
1942: dbms_sql.define_column( p_select_c, 6, p_select_rec.total_cm_line_amount );
1935: print_fcn_label2( 'arp_maintain_ps2.define_ira_select_columns()+' );
1936:
1937: dbms_sql.define_column( p_select_c, 1, p_select_rec.trx_date );
1938: dbms_sql.define_column( p_select_c, 2, p_select_rec.customer_id );
1939: dbms_sql.define_column( p_select_c, 3, p_select_rec.cust_trx_type_id );
1940: dbms_sql.define_column( p_select_c, 4, p_select_rec.customer_trx_id );
1941: dbms_sql.define_column( p_select_c, 5, p_select_rec.currency_code, 15 );
1942: dbms_sql.define_column( p_select_c, 6, p_select_rec.total_cm_line_amount );
1943: dbms_sql.define_column( p_select_c, 7,
1936:
1937: dbms_sql.define_column( p_select_c, 1, p_select_rec.trx_date );
1938: dbms_sql.define_column( p_select_c, 2, p_select_rec.customer_id );
1939: dbms_sql.define_column( p_select_c, 3, p_select_rec.cust_trx_type_id );
1940: dbms_sql.define_column( p_select_c, 4, p_select_rec.customer_trx_id );
1941: dbms_sql.define_column( p_select_c, 5, p_select_rec.currency_code, 15 );
1942: dbms_sql.define_column( p_select_c, 6, p_select_rec.total_cm_line_amount );
1943: dbms_sql.define_column( p_select_c, 7,
1944: p_select_rec.total_cm_freight_amount );
1937: dbms_sql.define_column( p_select_c, 1, p_select_rec.trx_date );
1938: dbms_sql.define_column( p_select_c, 2, p_select_rec.customer_id );
1939: dbms_sql.define_column( p_select_c, 3, p_select_rec.cust_trx_type_id );
1940: dbms_sql.define_column( p_select_c, 4, p_select_rec.customer_trx_id );
1941: dbms_sql.define_column( p_select_c, 5, p_select_rec.currency_code, 15 );
1942: dbms_sql.define_column( p_select_c, 6, p_select_rec.total_cm_line_amount );
1943: dbms_sql.define_column( p_select_c, 7,
1944: p_select_rec.total_cm_freight_amount );
1945: dbms_sql.define_column( p_select_c, 8, p_select_rec.total_cm_tax_amount );
1938: dbms_sql.define_column( p_select_c, 2, p_select_rec.customer_id );
1939: dbms_sql.define_column( p_select_c, 3, p_select_rec.cust_trx_type_id );
1940: dbms_sql.define_column( p_select_c, 4, p_select_rec.customer_trx_id );
1941: dbms_sql.define_column( p_select_c, 5, p_select_rec.currency_code, 15 );
1942: dbms_sql.define_column( p_select_c, 6, p_select_rec.total_cm_line_amount );
1943: dbms_sql.define_column( p_select_c, 7,
1944: p_select_rec.total_cm_freight_amount );
1945: dbms_sql.define_column( p_select_c, 8, p_select_rec.total_cm_tax_amount );
1946: dbms_sql.define_column( p_select_c, 9,
1939: dbms_sql.define_column( p_select_c, 3, p_select_rec.cust_trx_type_id );
1940: dbms_sql.define_column( p_select_c, 4, p_select_rec.customer_trx_id );
1941: dbms_sql.define_column( p_select_c, 5, p_select_rec.currency_code, 15 );
1942: dbms_sql.define_column( p_select_c, 6, p_select_rec.total_cm_line_amount );
1943: dbms_sql.define_column( p_select_c, 7,
1944: p_select_rec.total_cm_freight_amount );
1945: dbms_sql.define_column( p_select_c, 8, p_select_rec.total_cm_tax_amount );
1946: dbms_sql.define_column( p_select_c, 9,
1947: p_select_rec.exchange_rate_type, 30 );
1941: dbms_sql.define_column( p_select_c, 5, p_select_rec.currency_code, 15 );
1942: dbms_sql.define_column( p_select_c, 6, p_select_rec.total_cm_line_amount );
1943: dbms_sql.define_column( p_select_c, 7,
1944: p_select_rec.total_cm_freight_amount );
1945: dbms_sql.define_column( p_select_c, 8, p_select_rec.total_cm_tax_amount );
1946: dbms_sql.define_column( p_select_c, 9,
1947: p_select_rec.exchange_rate_type, 30 );
1948: dbms_sql.define_column( p_select_c, 10, p_select_rec.exchange_rate );
1949: dbms_sql.define_column( p_select_c, 11, p_select_rec.exchange_date );
1942: dbms_sql.define_column( p_select_c, 6, p_select_rec.total_cm_line_amount );
1943: dbms_sql.define_column( p_select_c, 7,
1944: p_select_rec.total_cm_freight_amount );
1945: dbms_sql.define_column( p_select_c, 8, p_select_rec.total_cm_tax_amount );
1946: dbms_sql.define_column( p_select_c, 9,
1947: p_select_rec.exchange_rate_type, 30 );
1948: dbms_sql.define_column( p_select_c, 10, p_select_rec.exchange_rate );
1949: dbms_sql.define_column( p_select_c, 11, p_select_rec.exchange_date );
1950: dbms_sql.define_column( p_select_c, 12, p_select_rec.trx_number, 20 );
1944: p_select_rec.total_cm_freight_amount );
1945: dbms_sql.define_column( p_select_c, 8, p_select_rec.total_cm_tax_amount );
1946: dbms_sql.define_column( p_select_c, 9,
1947: p_select_rec.exchange_rate_type, 30 );
1948: dbms_sql.define_column( p_select_c, 10, p_select_rec.exchange_rate );
1949: dbms_sql.define_column( p_select_c, 11, p_select_rec.exchange_date );
1950: dbms_sql.define_column( p_select_c, 12, p_select_rec.trx_number, 20 );
1951: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date );
1952: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1945: dbms_sql.define_column( p_select_c, 8, p_select_rec.total_cm_tax_amount );
1946: dbms_sql.define_column( p_select_c, 9,
1947: p_select_rec.exchange_rate_type, 30 );
1948: dbms_sql.define_column( p_select_c, 10, p_select_rec.exchange_rate );
1949: dbms_sql.define_column( p_select_c, 11, p_select_rec.exchange_date );
1950: dbms_sql.define_column( p_select_c, 12, p_select_rec.trx_number, 20 );
1951: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date );
1952: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1953: dbms_sql.define_column( p_select_c, 15, p_select_rec.inv_customer_trx_id );
1946: dbms_sql.define_column( p_select_c, 9,
1947: p_select_rec.exchange_rate_type, 30 );
1948: dbms_sql.define_column( p_select_c, 10, p_select_rec.exchange_rate );
1949: dbms_sql.define_column( p_select_c, 11, p_select_rec.exchange_date );
1950: dbms_sql.define_column( p_select_c, 12, p_select_rec.trx_number, 20 );
1951: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date );
1952: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1953: dbms_sql.define_column( p_select_c, 15, p_select_rec.inv_customer_trx_id );
1954: dbms_sql.define_column( p_select_c, 16,
1947: p_select_rec.exchange_rate_type, 30 );
1948: dbms_sql.define_column( p_select_c, 10, p_select_rec.exchange_rate );
1949: dbms_sql.define_column( p_select_c, 11, p_select_rec.exchange_date );
1950: dbms_sql.define_column( p_select_c, 12, p_select_rec.trx_number, 20 );
1951: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date );
1952: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1953: dbms_sql.define_column( p_select_c, 15, p_select_rec.inv_customer_trx_id );
1954: dbms_sql.define_column( p_select_c, 16,
1955: p_select_rec.inv_payment_schedule_id );
1948: dbms_sql.define_column( p_select_c, 10, p_select_rec.exchange_rate );
1949: dbms_sql.define_column( p_select_c, 11, p_select_rec.exchange_date );
1950: dbms_sql.define_column( p_select_c, 12, p_select_rec.trx_number, 20 );
1951: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date );
1952: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1953: dbms_sql.define_column( p_select_c, 15, p_select_rec.inv_customer_trx_id );
1954: dbms_sql.define_column( p_select_c, 16,
1955: p_select_rec.inv_payment_schedule_id );
1956: dbms_sql.define_column( p_select_c, 17, p_select_rec.gl_date_closed );
1949: dbms_sql.define_column( p_select_c, 11, p_select_rec.exchange_date );
1950: dbms_sql.define_column( p_select_c, 12, p_select_rec.trx_number, 20 );
1951: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date );
1952: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1953: dbms_sql.define_column( p_select_c, 15, p_select_rec.inv_customer_trx_id );
1954: dbms_sql.define_column( p_select_c, 16,
1955: p_select_rec.inv_payment_schedule_id );
1956: dbms_sql.define_column( p_select_c, 17, p_select_rec.gl_date_closed );
1957: dbms_sql.define_column( p_select_c, 18, p_select_rec.actual_date_closed );
1950: dbms_sql.define_column( p_select_c, 12, p_select_rec.trx_number, 20 );
1951: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date );
1952: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1953: dbms_sql.define_column( p_select_c, 15, p_select_rec.inv_customer_trx_id );
1954: dbms_sql.define_column( p_select_c, 16,
1955: p_select_rec.inv_payment_schedule_id );
1956: dbms_sql.define_column( p_select_c, 17, p_select_rec.gl_date_closed );
1957: dbms_sql.define_column( p_select_c, 18, p_select_rec.actual_date_closed );
1958: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
1952: dbms_sql.define_column( p_select_c, 14, p_select_rec.code_combination_id );
1953: dbms_sql.define_column( p_select_c, 15, p_select_rec.inv_customer_trx_id );
1954: dbms_sql.define_column( p_select_c, 16,
1955: p_select_rec.inv_payment_schedule_id );
1956: dbms_sql.define_column( p_select_c, 17, p_select_rec.gl_date_closed );
1957: dbms_sql.define_column( p_select_c, 18, p_select_rec.actual_date_closed );
1958: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
1959: dbms_sql.define_column( p_select_c, 20, p_select_rec.inv_line_remaining );
1960: dbms_sql.define_column( p_select_c, 21,
1953: dbms_sql.define_column( p_select_c, 15, p_select_rec.inv_customer_trx_id );
1954: dbms_sql.define_column( p_select_c, 16,
1955: p_select_rec.inv_payment_schedule_id );
1956: dbms_sql.define_column( p_select_c, 17, p_select_rec.gl_date_closed );
1957: dbms_sql.define_column( p_select_c, 18, p_select_rec.actual_date_closed );
1958: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
1959: dbms_sql.define_column( p_select_c, 20, p_select_rec.inv_line_remaining );
1960: dbms_sql.define_column( p_select_c, 21,
1961: p_select_rec.inv_freight_remaining );
1954: dbms_sql.define_column( p_select_c, 16,
1955: p_select_rec.inv_payment_schedule_id );
1956: dbms_sql.define_column( p_select_c, 17, p_select_rec.gl_date_closed );
1957: dbms_sql.define_column( p_select_c, 18, p_select_rec.actual_date_closed );
1958: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
1959: dbms_sql.define_column( p_select_c, 20, p_select_rec.inv_line_remaining );
1960: dbms_sql.define_column( p_select_c, 21,
1961: p_select_rec.inv_freight_remaining );
1962: dbms_sql.define_column( p_select_c, 22, p_select_rec.inv_tax_remaining );
1955: p_select_rec.inv_payment_schedule_id );
1956: dbms_sql.define_column( p_select_c, 17, p_select_rec.gl_date_closed );
1957: dbms_sql.define_column( p_select_c, 18, p_select_rec.actual_date_closed );
1958: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
1959: dbms_sql.define_column( p_select_c, 20, p_select_rec.inv_line_remaining );
1960: dbms_sql.define_column( p_select_c, 21,
1961: p_select_rec.inv_freight_remaining );
1962: dbms_sql.define_column( p_select_c, 22, p_select_rec.inv_tax_remaining );
1963: dbms_sql.define_column( p_select_c, 23, p_select_rec.site_use_id );
1956: dbms_sql.define_column( p_select_c, 17, p_select_rec.gl_date_closed );
1957: dbms_sql.define_column( p_select_c, 18, p_select_rec.actual_date_closed );
1958: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
1959: dbms_sql.define_column( p_select_c, 20, p_select_rec.inv_line_remaining );
1960: dbms_sql.define_column( p_select_c, 21,
1961: p_select_rec.inv_freight_remaining );
1962: dbms_sql.define_column( p_select_c, 22, p_select_rec.inv_tax_remaining );
1963: dbms_sql.define_column( p_select_c, 23, p_select_rec.site_use_id );
1964: dbms_sql.define_column( p_select_c, 24,
1958: dbms_sql.define_column( p_select_c, 19, p_select_rec.precision );
1959: dbms_sql.define_column( p_select_c, 20, p_select_rec.inv_line_remaining );
1960: dbms_sql.define_column( p_select_c, 21,
1961: p_select_rec.inv_freight_remaining );
1962: dbms_sql.define_column( p_select_c, 22, p_select_rec.inv_tax_remaining );
1963: dbms_sql.define_column( p_select_c, 23, p_select_rec.site_use_id );
1964: dbms_sql.define_column( p_select_c, 24,
1965: p_select_rec.min_acc_unit );
1966: dbms_sql.define_column( p_select_c, 25,
1959: dbms_sql.define_column( p_select_c, 20, p_select_rec.inv_line_remaining );
1960: dbms_sql.define_column( p_select_c, 21,
1961: p_select_rec.inv_freight_remaining );
1962: dbms_sql.define_column( p_select_c, 22, p_select_rec.inv_tax_remaining );
1963: dbms_sql.define_column( p_select_c, 23, p_select_rec.site_use_id );
1964: dbms_sql.define_column( p_select_c, 24,
1965: p_select_rec.min_acc_unit );
1966: dbms_sql.define_column( p_select_c, 25,
1967: p_select_rec.post_to_gl_flag, 1 );
1960: dbms_sql.define_column( p_select_c, 21,
1961: p_select_rec.inv_freight_remaining );
1962: dbms_sql.define_column( p_select_c, 22, p_select_rec.inv_tax_remaining );
1963: dbms_sql.define_column( p_select_c, 23, p_select_rec.site_use_id );
1964: dbms_sql.define_column( p_select_c, 24,
1965: p_select_rec.min_acc_unit );
1966: dbms_sql.define_column( p_select_c, 25,
1967: p_select_rec.post_to_gl_flag, 1 );
1968: dbms_sql.define_column( p_select_c, 26,
1962: dbms_sql.define_column( p_select_c, 22, p_select_rec.inv_tax_remaining );
1963: dbms_sql.define_column( p_select_c, 23, p_select_rec.site_use_id );
1964: dbms_sql.define_column( p_select_c, 24,
1965: p_select_rec.min_acc_unit );
1966: dbms_sql.define_column( p_select_c, 25,
1967: p_select_rec.post_to_gl_flag, 1 );
1968: dbms_sql.define_column( p_select_c, 26,
1969: p_select_rec.credit_method, 30 );
1970: dbms_sql.define_column( p_select_c, 27,
1964: dbms_sql.define_column( p_select_c, 24,
1965: p_select_rec.min_acc_unit );
1966: dbms_sql.define_column( p_select_c, 25,
1967: p_select_rec.post_to_gl_flag, 1 );
1968: dbms_sql.define_column( p_select_c, 26,
1969: p_select_rec.credit_method, 30 );
1970: dbms_sql.define_column( p_select_c, 27,
1971: p_select_rec.inv_amount_credited );
1972: dbms_sql.define_column( p_select_c, 28,
1966: dbms_sql.define_column( p_select_c, 25,
1967: p_select_rec.post_to_gl_flag, 1 );
1968: dbms_sql.define_column( p_select_c, 26,
1969: p_select_rec.credit_method, 30 );
1970: dbms_sql.define_column( p_select_c, 27,
1971: p_select_rec.inv_amount_credited );
1972: dbms_sql.define_column( p_select_c, 28,
1973: p_select_rec.inv_amount_due_remaining );
1974: dbms_sql.define_column( p_select_c, 29,
1968: dbms_sql.define_column( p_select_c, 26,
1969: p_select_rec.credit_method, 30 );
1970: dbms_sql.define_column( p_select_c, 27,
1971: p_select_rec.inv_amount_credited );
1972: dbms_sql.define_column( p_select_c, 28,
1973: p_select_rec.inv_amount_due_remaining );
1974: dbms_sql.define_column( p_select_c, 29,
1975: p_select_rec.inv_acctd_amt_due_rem );
1976: dbms_sql.define_column( p_select_c, 30, p_select_rec.inv_precision );
1970: dbms_sql.define_column( p_select_c, 27,
1971: p_select_rec.inv_amount_credited );
1972: dbms_sql.define_column( p_select_c, 28,
1973: p_select_rec.inv_amount_due_remaining );
1974: dbms_sql.define_column( p_select_c, 29,
1975: p_select_rec.inv_acctd_amt_due_rem );
1976: dbms_sql.define_column( p_select_c, 30, p_select_rec.inv_precision );
1977: dbms_sql.define_column( p_select_c, 31,
1978: p_select_rec.inv_min_acc_unit );
1972: dbms_sql.define_column( p_select_c, 28,
1973: p_select_rec.inv_amount_due_remaining );
1974: dbms_sql.define_column( p_select_c, 29,
1975: p_select_rec.inv_acctd_amt_due_rem );
1976: dbms_sql.define_column( p_select_c, 30, p_select_rec.inv_precision );
1977: dbms_sql.define_column( p_select_c, 31,
1978: p_select_rec.inv_min_acc_unit );
1979: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_exchange_rate );
1980: dbms_sql.define_column( p_select_c, 33, p_select_rec.rec_acctd_amount );
1973: p_select_rec.inv_amount_due_remaining );
1974: dbms_sql.define_column( p_select_c, 29,
1975: p_select_rec.inv_acctd_amt_due_rem );
1976: dbms_sql.define_column( p_select_c, 30, p_select_rec.inv_precision );
1977: dbms_sql.define_column( p_select_c, 31,
1978: p_select_rec.inv_min_acc_unit );
1979: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_exchange_rate );
1980: dbms_sql.define_column( p_select_c, 33, p_select_rec.rec_acctd_amount );
1981: dbms_sql.define_column( p_select_c, 34,
1975: p_select_rec.inv_acctd_amt_due_rem );
1976: dbms_sql.define_column( p_select_c, 30, p_select_rec.inv_precision );
1977: dbms_sql.define_column( p_select_c, 31,
1978: p_select_rec.inv_min_acc_unit );
1979: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_exchange_rate );
1980: dbms_sql.define_column( p_select_c, 33, p_select_rec.rec_acctd_amount );
1981: dbms_sql.define_column( p_select_c, 34,
1982: p_select_rec.total_cm_charges_amount );
1983: dbms_sql.define_column( p_select_c, 35,
1976: dbms_sql.define_column( p_select_c, 30, p_select_rec.inv_precision );
1977: dbms_sql.define_column( p_select_c, 31,
1978: p_select_rec.inv_min_acc_unit );
1979: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_exchange_rate );
1980: dbms_sql.define_column( p_select_c, 33, p_select_rec.rec_acctd_amount );
1981: dbms_sql.define_column( p_select_c, 34,
1982: p_select_rec.total_cm_charges_amount );
1983: dbms_sql.define_column( p_select_c, 35,
1984: p_select_rec.inv_charges_remaining );
1977: dbms_sql.define_column( p_select_c, 31,
1978: p_select_rec.inv_min_acc_unit );
1979: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_exchange_rate );
1980: dbms_sql.define_column( p_select_c, 33, p_select_rec.rec_acctd_amount );
1981: dbms_sql.define_column( p_select_c, 34,
1982: p_select_rec.total_cm_charges_amount );
1983: dbms_sql.define_column( p_select_c, 35,
1984: p_select_rec.inv_charges_remaining );
1985:
1979: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_exchange_rate );
1980: dbms_sql.define_column( p_select_c, 33, p_select_rec.rec_acctd_amount );
1981: dbms_sql.define_column( p_select_c, 34,
1982: p_select_rec.total_cm_charges_amount );
1983: dbms_sql.define_column( p_select_c, 35,
1984: p_select_rec.inv_charges_remaining );
1985:
1986:
1987: print_fcn_label2( 'arp_maintain_ps2.define_ira_select_columns()-' );
2000: /* Bug 460927 - Modified IN to IN OUT oin the above line - oracle 8 */
2001: BEGIN
2002: print_fcn_label2( 'arp_maintain_ps2.get_ira_column_values()+' );
2003:
2004: dbms_sql.column_value( p_select_c, 1, p_select_rec.trx_date );
2005: dbms_sql.column_value( p_select_c, 2, p_select_rec.customer_id );
2006: dbms_sql.column_value( p_select_c, 3, p_select_rec.cust_trx_type_id );
2007: dbms_sql.column_value( p_select_c, 4, p_select_rec.customer_trx_id );
2008: dbms_sql.column_value( p_select_c, 5, p_select_rec.currency_code );
2001: BEGIN
2002: print_fcn_label2( 'arp_maintain_ps2.get_ira_column_values()+' );
2003:
2004: dbms_sql.column_value( p_select_c, 1, p_select_rec.trx_date );
2005: dbms_sql.column_value( p_select_c, 2, p_select_rec.customer_id );
2006: dbms_sql.column_value( p_select_c, 3, p_select_rec.cust_trx_type_id );
2007: dbms_sql.column_value( p_select_c, 4, p_select_rec.customer_trx_id );
2008: dbms_sql.column_value( p_select_c, 5, p_select_rec.currency_code );
2009: dbms_sql.column_value( p_select_c, 6, p_select_rec.total_cm_line_amount );
2002: print_fcn_label2( 'arp_maintain_ps2.get_ira_column_values()+' );
2003:
2004: dbms_sql.column_value( p_select_c, 1, p_select_rec.trx_date );
2005: dbms_sql.column_value( p_select_c, 2, p_select_rec.customer_id );
2006: dbms_sql.column_value( p_select_c, 3, p_select_rec.cust_trx_type_id );
2007: dbms_sql.column_value( p_select_c, 4, p_select_rec.customer_trx_id );
2008: dbms_sql.column_value( p_select_c, 5, p_select_rec.currency_code );
2009: dbms_sql.column_value( p_select_c, 6, p_select_rec.total_cm_line_amount );
2010: dbms_sql.column_value( p_select_c, 7,
2003:
2004: dbms_sql.column_value( p_select_c, 1, p_select_rec.trx_date );
2005: dbms_sql.column_value( p_select_c, 2, p_select_rec.customer_id );
2006: dbms_sql.column_value( p_select_c, 3, p_select_rec.cust_trx_type_id );
2007: dbms_sql.column_value( p_select_c, 4, p_select_rec.customer_trx_id );
2008: dbms_sql.column_value( p_select_c, 5, p_select_rec.currency_code );
2009: dbms_sql.column_value( p_select_c, 6, p_select_rec.total_cm_line_amount );
2010: dbms_sql.column_value( p_select_c, 7,
2011: p_select_rec.total_cm_freight_amount );
2004: dbms_sql.column_value( p_select_c, 1, p_select_rec.trx_date );
2005: dbms_sql.column_value( p_select_c, 2, p_select_rec.customer_id );
2006: dbms_sql.column_value( p_select_c, 3, p_select_rec.cust_trx_type_id );
2007: dbms_sql.column_value( p_select_c, 4, p_select_rec.customer_trx_id );
2008: dbms_sql.column_value( p_select_c, 5, p_select_rec.currency_code );
2009: dbms_sql.column_value( p_select_c, 6, p_select_rec.total_cm_line_amount );
2010: dbms_sql.column_value( p_select_c, 7,
2011: p_select_rec.total_cm_freight_amount );
2012: dbms_sql.column_value( p_select_c, 8, p_select_rec.total_cm_tax_amount );
2005: dbms_sql.column_value( p_select_c, 2, p_select_rec.customer_id );
2006: dbms_sql.column_value( p_select_c, 3, p_select_rec.cust_trx_type_id );
2007: dbms_sql.column_value( p_select_c, 4, p_select_rec.customer_trx_id );
2008: dbms_sql.column_value( p_select_c, 5, p_select_rec.currency_code );
2009: dbms_sql.column_value( p_select_c, 6, p_select_rec.total_cm_line_amount );
2010: dbms_sql.column_value( p_select_c, 7,
2011: p_select_rec.total_cm_freight_amount );
2012: dbms_sql.column_value( p_select_c, 8, p_select_rec.total_cm_tax_amount );
2013: dbms_sql.column_value( p_select_c, 9,
2006: dbms_sql.column_value( p_select_c, 3, p_select_rec.cust_trx_type_id );
2007: dbms_sql.column_value( p_select_c, 4, p_select_rec.customer_trx_id );
2008: dbms_sql.column_value( p_select_c, 5, p_select_rec.currency_code );
2009: dbms_sql.column_value( p_select_c, 6, p_select_rec.total_cm_line_amount );
2010: dbms_sql.column_value( p_select_c, 7,
2011: p_select_rec.total_cm_freight_amount );
2012: dbms_sql.column_value( p_select_c, 8, p_select_rec.total_cm_tax_amount );
2013: dbms_sql.column_value( p_select_c, 9,
2014: p_select_rec.exchange_rate_type );
2008: dbms_sql.column_value( p_select_c, 5, p_select_rec.currency_code );
2009: dbms_sql.column_value( p_select_c, 6, p_select_rec.total_cm_line_amount );
2010: dbms_sql.column_value( p_select_c, 7,
2011: p_select_rec.total_cm_freight_amount );
2012: dbms_sql.column_value( p_select_c, 8, p_select_rec.total_cm_tax_amount );
2013: dbms_sql.column_value( p_select_c, 9,
2014: p_select_rec.exchange_rate_type );
2015: dbms_sql.column_value( p_select_c, 10, p_select_rec.exchange_rate );
2016: dbms_sql.column_value( p_select_c, 11, p_select_rec.exchange_date );
2009: dbms_sql.column_value( p_select_c, 6, p_select_rec.total_cm_line_amount );
2010: dbms_sql.column_value( p_select_c, 7,
2011: p_select_rec.total_cm_freight_amount );
2012: dbms_sql.column_value( p_select_c, 8, p_select_rec.total_cm_tax_amount );
2013: dbms_sql.column_value( p_select_c, 9,
2014: p_select_rec.exchange_rate_type );
2015: dbms_sql.column_value( p_select_c, 10, p_select_rec.exchange_rate );
2016: dbms_sql.column_value( p_select_c, 11, p_select_rec.exchange_date );
2017: dbms_sql.column_value( p_select_c, 12, p_select_rec.trx_number );
2011: p_select_rec.total_cm_freight_amount );
2012: dbms_sql.column_value( p_select_c, 8, p_select_rec.total_cm_tax_amount );
2013: dbms_sql.column_value( p_select_c, 9,
2014: p_select_rec.exchange_rate_type );
2015: dbms_sql.column_value( p_select_c, 10, p_select_rec.exchange_rate );
2016: dbms_sql.column_value( p_select_c, 11, p_select_rec.exchange_date );
2017: dbms_sql.column_value( p_select_c, 12, p_select_rec.trx_number );
2018: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date );
2019: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
2012: dbms_sql.column_value( p_select_c, 8, p_select_rec.total_cm_tax_amount );
2013: dbms_sql.column_value( p_select_c, 9,
2014: p_select_rec.exchange_rate_type );
2015: dbms_sql.column_value( p_select_c, 10, p_select_rec.exchange_rate );
2016: dbms_sql.column_value( p_select_c, 11, p_select_rec.exchange_date );
2017: dbms_sql.column_value( p_select_c, 12, p_select_rec.trx_number );
2018: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date );
2019: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
2020: dbms_sql.column_value( p_select_c, 15, p_select_rec.inv_customer_trx_id );
2013: dbms_sql.column_value( p_select_c, 9,
2014: p_select_rec.exchange_rate_type );
2015: dbms_sql.column_value( p_select_c, 10, p_select_rec.exchange_rate );
2016: dbms_sql.column_value( p_select_c, 11, p_select_rec.exchange_date );
2017: dbms_sql.column_value( p_select_c, 12, p_select_rec.trx_number );
2018: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date );
2019: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
2020: dbms_sql.column_value( p_select_c, 15, p_select_rec.inv_customer_trx_id );
2021: dbms_sql.column_value( p_select_c, 16,
2014: p_select_rec.exchange_rate_type );
2015: dbms_sql.column_value( p_select_c, 10, p_select_rec.exchange_rate );
2016: dbms_sql.column_value( p_select_c, 11, p_select_rec.exchange_date );
2017: dbms_sql.column_value( p_select_c, 12, p_select_rec.trx_number );
2018: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date );
2019: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
2020: dbms_sql.column_value( p_select_c, 15, p_select_rec.inv_customer_trx_id );
2021: dbms_sql.column_value( p_select_c, 16,
2022: p_select_rec.inv_payment_schedule_id );
2015: dbms_sql.column_value( p_select_c, 10, p_select_rec.exchange_rate );
2016: dbms_sql.column_value( p_select_c, 11, p_select_rec.exchange_date );
2017: dbms_sql.column_value( p_select_c, 12, p_select_rec.trx_number );
2018: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date );
2019: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
2020: dbms_sql.column_value( p_select_c, 15, p_select_rec.inv_customer_trx_id );
2021: dbms_sql.column_value( p_select_c, 16,
2022: p_select_rec.inv_payment_schedule_id );
2023: dbms_sql.column_value( p_select_c, 17, p_select_rec.gl_date_closed );
2016: dbms_sql.column_value( p_select_c, 11, p_select_rec.exchange_date );
2017: dbms_sql.column_value( p_select_c, 12, p_select_rec.trx_number );
2018: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date );
2019: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
2020: dbms_sql.column_value( p_select_c, 15, p_select_rec.inv_customer_trx_id );
2021: dbms_sql.column_value( p_select_c, 16,
2022: p_select_rec.inv_payment_schedule_id );
2023: dbms_sql.column_value( p_select_c, 17, p_select_rec.gl_date_closed );
2024: dbms_sql.column_value( p_select_c, 18, p_select_rec.actual_date_closed );
2017: dbms_sql.column_value( p_select_c, 12, p_select_rec.trx_number );
2018: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date );
2019: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
2020: dbms_sql.column_value( p_select_c, 15, p_select_rec.inv_customer_trx_id );
2021: dbms_sql.column_value( p_select_c, 16,
2022: p_select_rec.inv_payment_schedule_id );
2023: dbms_sql.column_value( p_select_c, 17, p_select_rec.gl_date_closed );
2024: dbms_sql.column_value( p_select_c, 18, p_select_rec.actual_date_closed );
2025: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
2019: dbms_sql.column_value( p_select_c, 14, p_select_rec.code_combination_id );
2020: dbms_sql.column_value( p_select_c, 15, p_select_rec.inv_customer_trx_id );
2021: dbms_sql.column_value( p_select_c, 16,
2022: p_select_rec.inv_payment_schedule_id );
2023: dbms_sql.column_value( p_select_c, 17, p_select_rec.gl_date_closed );
2024: dbms_sql.column_value( p_select_c, 18, p_select_rec.actual_date_closed );
2025: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
2026: dbms_sql.column_value( p_select_c, 20, p_select_rec.inv_line_remaining );
2027: dbms_sql.column_value( p_select_c, 21,
2020: dbms_sql.column_value( p_select_c, 15, p_select_rec.inv_customer_trx_id );
2021: dbms_sql.column_value( p_select_c, 16,
2022: p_select_rec.inv_payment_schedule_id );
2023: dbms_sql.column_value( p_select_c, 17, p_select_rec.gl_date_closed );
2024: dbms_sql.column_value( p_select_c, 18, p_select_rec.actual_date_closed );
2025: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
2026: dbms_sql.column_value( p_select_c, 20, p_select_rec.inv_line_remaining );
2027: dbms_sql.column_value( p_select_c, 21,
2028: p_select_rec.inv_freight_remaining );
2021: dbms_sql.column_value( p_select_c, 16,
2022: p_select_rec.inv_payment_schedule_id );
2023: dbms_sql.column_value( p_select_c, 17, p_select_rec.gl_date_closed );
2024: dbms_sql.column_value( p_select_c, 18, p_select_rec.actual_date_closed );
2025: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
2026: dbms_sql.column_value( p_select_c, 20, p_select_rec.inv_line_remaining );
2027: dbms_sql.column_value( p_select_c, 21,
2028: p_select_rec.inv_freight_remaining );
2029: dbms_sql.column_value( p_select_c, 22, p_select_rec.inv_tax_remaining );
2022: p_select_rec.inv_payment_schedule_id );
2023: dbms_sql.column_value( p_select_c, 17, p_select_rec.gl_date_closed );
2024: dbms_sql.column_value( p_select_c, 18, p_select_rec.actual_date_closed );
2025: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
2026: dbms_sql.column_value( p_select_c, 20, p_select_rec.inv_line_remaining );
2027: dbms_sql.column_value( p_select_c, 21,
2028: p_select_rec.inv_freight_remaining );
2029: dbms_sql.column_value( p_select_c, 22, p_select_rec.inv_tax_remaining );
2030: dbms_sql.column_value( p_select_c, 23, p_select_rec.site_use_id );
2023: dbms_sql.column_value( p_select_c, 17, p_select_rec.gl_date_closed );
2024: dbms_sql.column_value( p_select_c, 18, p_select_rec.actual_date_closed );
2025: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
2026: dbms_sql.column_value( p_select_c, 20, p_select_rec.inv_line_remaining );
2027: dbms_sql.column_value( p_select_c, 21,
2028: p_select_rec.inv_freight_remaining );
2029: dbms_sql.column_value( p_select_c, 22, p_select_rec.inv_tax_remaining );
2030: dbms_sql.column_value( p_select_c, 23, p_select_rec.site_use_id );
2031: dbms_sql.column_value( p_select_c, 24,
2025: dbms_sql.column_value( p_select_c, 19, p_select_rec.precision );
2026: dbms_sql.column_value( p_select_c, 20, p_select_rec.inv_line_remaining );
2027: dbms_sql.column_value( p_select_c, 21,
2028: p_select_rec.inv_freight_remaining );
2029: dbms_sql.column_value( p_select_c, 22, p_select_rec.inv_tax_remaining );
2030: dbms_sql.column_value( p_select_c, 23, p_select_rec.site_use_id );
2031: dbms_sql.column_value( p_select_c, 24,
2032: p_select_rec.min_acc_unit );
2033: dbms_sql.column_value( p_select_c, 25,
2026: dbms_sql.column_value( p_select_c, 20, p_select_rec.inv_line_remaining );
2027: dbms_sql.column_value( p_select_c, 21,
2028: p_select_rec.inv_freight_remaining );
2029: dbms_sql.column_value( p_select_c, 22, p_select_rec.inv_tax_remaining );
2030: dbms_sql.column_value( p_select_c, 23, p_select_rec.site_use_id );
2031: dbms_sql.column_value( p_select_c, 24,
2032: p_select_rec.min_acc_unit );
2033: dbms_sql.column_value( p_select_c, 25,
2034: p_select_rec.post_to_gl_flag );
2027: dbms_sql.column_value( p_select_c, 21,
2028: p_select_rec.inv_freight_remaining );
2029: dbms_sql.column_value( p_select_c, 22, p_select_rec.inv_tax_remaining );
2030: dbms_sql.column_value( p_select_c, 23, p_select_rec.site_use_id );
2031: dbms_sql.column_value( p_select_c, 24,
2032: p_select_rec.min_acc_unit );
2033: dbms_sql.column_value( p_select_c, 25,
2034: p_select_rec.post_to_gl_flag );
2035: dbms_sql.column_value( p_select_c, 26,
2029: dbms_sql.column_value( p_select_c, 22, p_select_rec.inv_tax_remaining );
2030: dbms_sql.column_value( p_select_c, 23, p_select_rec.site_use_id );
2031: dbms_sql.column_value( p_select_c, 24,
2032: p_select_rec.min_acc_unit );
2033: dbms_sql.column_value( p_select_c, 25,
2034: p_select_rec.post_to_gl_flag );
2035: dbms_sql.column_value( p_select_c, 26,
2036: p_select_rec.credit_method );
2037: dbms_sql.column_value( p_select_c, 27,
2031: dbms_sql.column_value( p_select_c, 24,
2032: p_select_rec.min_acc_unit );
2033: dbms_sql.column_value( p_select_c, 25,
2034: p_select_rec.post_to_gl_flag );
2035: dbms_sql.column_value( p_select_c, 26,
2036: p_select_rec.credit_method );
2037: dbms_sql.column_value( p_select_c, 27,
2038: p_select_rec.inv_amount_credited );
2039: dbms_sql.column_value( p_select_c, 28,
2033: dbms_sql.column_value( p_select_c, 25,
2034: p_select_rec.post_to_gl_flag );
2035: dbms_sql.column_value( p_select_c, 26,
2036: p_select_rec.credit_method );
2037: dbms_sql.column_value( p_select_c, 27,
2038: p_select_rec.inv_amount_credited );
2039: dbms_sql.column_value( p_select_c, 28,
2040: p_select_rec.inv_amount_due_remaining );
2041: dbms_sql.column_value( p_select_c, 29,
2035: dbms_sql.column_value( p_select_c, 26,
2036: p_select_rec.credit_method );
2037: dbms_sql.column_value( p_select_c, 27,
2038: p_select_rec.inv_amount_credited );
2039: dbms_sql.column_value( p_select_c, 28,
2040: p_select_rec.inv_amount_due_remaining );
2041: dbms_sql.column_value( p_select_c, 29,
2042: p_select_rec.inv_acctd_amt_due_rem );
2043: dbms_sql.column_value( p_select_c, 30, p_select_rec.inv_precision );
2037: dbms_sql.column_value( p_select_c, 27,
2038: p_select_rec.inv_amount_credited );
2039: dbms_sql.column_value( p_select_c, 28,
2040: p_select_rec.inv_amount_due_remaining );
2041: dbms_sql.column_value( p_select_c, 29,
2042: p_select_rec.inv_acctd_amt_due_rem );
2043: dbms_sql.column_value( p_select_c, 30, p_select_rec.inv_precision );
2044: dbms_sql.column_value( p_select_c, 31,
2045: p_select_rec.inv_min_acc_unit );
2039: dbms_sql.column_value( p_select_c, 28,
2040: p_select_rec.inv_amount_due_remaining );
2041: dbms_sql.column_value( p_select_c, 29,
2042: p_select_rec.inv_acctd_amt_due_rem );
2043: dbms_sql.column_value( p_select_c, 30, p_select_rec.inv_precision );
2044: dbms_sql.column_value( p_select_c, 31,
2045: p_select_rec.inv_min_acc_unit );
2046: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_exchange_rate );
2047: dbms_sql.column_value( p_select_c, 33, p_select_rec.rec_acctd_amount );
2040: p_select_rec.inv_amount_due_remaining );
2041: dbms_sql.column_value( p_select_c, 29,
2042: p_select_rec.inv_acctd_amt_due_rem );
2043: dbms_sql.column_value( p_select_c, 30, p_select_rec.inv_precision );
2044: dbms_sql.column_value( p_select_c, 31,
2045: p_select_rec.inv_min_acc_unit );
2046: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_exchange_rate );
2047: dbms_sql.column_value( p_select_c, 33, p_select_rec.rec_acctd_amount );
2048: dbms_sql.column_value( p_select_c, 34,
2042: p_select_rec.inv_acctd_amt_due_rem );
2043: dbms_sql.column_value( p_select_c, 30, p_select_rec.inv_precision );
2044: dbms_sql.column_value( p_select_c, 31,
2045: p_select_rec.inv_min_acc_unit );
2046: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_exchange_rate );
2047: dbms_sql.column_value( p_select_c, 33, p_select_rec.rec_acctd_amount );
2048: dbms_sql.column_value( p_select_c, 34,
2049: p_select_rec.total_cm_charges_amount );
2050: dbms_sql.column_value( p_select_c, 35,
2043: dbms_sql.column_value( p_select_c, 30, p_select_rec.inv_precision );
2044: dbms_sql.column_value( p_select_c, 31,
2045: p_select_rec.inv_min_acc_unit );
2046: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_exchange_rate );
2047: dbms_sql.column_value( p_select_c, 33, p_select_rec.rec_acctd_amount );
2048: dbms_sql.column_value( p_select_c, 34,
2049: p_select_rec.total_cm_charges_amount );
2050: dbms_sql.column_value( p_select_c, 35,
2051: p_select_rec.inv_charges_remaining );
2044: dbms_sql.column_value( p_select_c, 31,
2045: p_select_rec.inv_min_acc_unit );
2046: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_exchange_rate );
2047: dbms_sql.column_value( p_select_c, 33, p_select_rec.rec_acctd_amount );
2048: dbms_sql.column_value( p_select_c, 34,
2049: p_select_rec.total_cm_charges_amount );
2050: dbms_sql.column_value( p_select_c, 35,
2051: p_select_rec.inv_charges_remaining );
2052:
2046: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_exchange_rate );
2047: dbms_sql.column_value( p_select_c, 33, p_select_rec.rec_acctd_amount );
2048: dbms_sql.column_value( p_select_c, 34,
2049: p_select_rec.total_cm_charges_amount );
2050: dbms_sql.column_value( p_select_c, 35,
2051: p_select_rec.inv_charges_remaining );
2052:
2053:
2054: print_fcn_label2( 'arp_maintain_ps2.get_ira_column_values()-' );
2682: -------------------------------------------------------------
2683: BEGIN
2684: debug( ' Binding insert_ps_c', MSG_LEVEL_DEBUG );
2685:
2686: dbms_sql.bind_variable( p_insert_ps_c,
2687: 'user_id',
2688: p_profile_info.user_id );
2689:
2690: dbms_sql.bind_variable( p_insert_ps_c,
2686: dbms_sql.bind_variable( p_insert_ps_c,
2687: 'user_id',
2688: p_profile_info.user_id );
2689:
2690: dbms_sql.bind_variable( p_insert_ps_c,
2691: 'login_id',
2692: p_profile_info.conc_login_id );
2693:
2694: dbms_sql.bind_variable( p_insert_ps_c,
2690: dbms_sql.bind_variable( p_insert_ps_c,
2691: 'login_id',
2692: p_profile_info.conc_login_id );
2693:
2694: dbms_sql.bind_variable( p_insert_ps_c,
2695: 'request_id',
2696: p_profile_info.request_id );
2697:
2698: dbms_sql.bind_variable( p_insert_ps_c,
2694: dbms_sql.bind_variable( p_insert_ps_c,
2695: 'request_id',
2696: p_profile_info.request_id );
2697:
2698: dbms_sql.bind_variable( p_insert_ps_c,
2699: 'application_id',
2700: p_profile_info.application_id );
2701:
2702: dbms_sql.bind_variable( p_insert_ps_c,
2698: dbms_sql.bind_variable( p_insert_ps_c,
2699: 'application_id',
2700: p_profile_info.application_id );
2701:
2702: dbms_sql.bind_variable( p_insert_ps_c,
2703: 'program_id',
2704: p_profile_info.conc_program_id );
2705:
2706: /* added for mrc trigger elimination */
2707: SELECT ar_payment_schedules_s.nextval
2708: INTO l_ps_id
2709: FROM dual;
2710:
2711: dbms_sql.bind_variable( p_insert_ps_c,
2712: 'payment_schedule_id',
2713: l_ps_id );
2714:
2715: dbms_sql.bind_variable( p_insert_ps_c,
2711: dbms_sql.bind_variable( p_insert_ps_c,
2712: 'payment_schedule_id',
2713: l_ps_id );
2714:
2715: dbms_sql.bind_variable( p_insert_ps_c,
2716: 'customer_trx_id',
2717: p_select_rec.customer_trx_id );
2718:
2719: dbms_sql.bind_variable( p_insert_ps_c,
2715: dbms_sql.bind_variable( p_insert_ps_c,
2716: 'customer_trx_id',
2717: p_select_rec.customer_trx_id );
2718:
2719: dbms_sql.bind_variable( p_insert_ps_c,
2720: 'amount_due_original',
2721: p_select_rec.total_cm_line_amount +
2722: p_select_rec.total_cm_tax_amount +
2723: p_select_rec.total_cm_freight_amount +
2722: p_select_rec.total_cm_tax_amount +
2723: p_select_rec.total_cm_freight_amount +
2724: p_select_rec.total_cm_charges_amount );
2725:
2726: dbms_sql.bind_variable( p_insert_ps_c,
2727: 'amount_line_items_original',
2728: p_select_rec.total_cm_line_amount );
2729:
2730: dbms_sql.bind_variable( p_insert_ps_c,
2726: dbms_sql.bind_variable( p_insert_ps_c,
2727: 'amount_line_items_original',
2728: p_select_rec.total_cm_line_amount );
2729:
2730: dbms_sql.bind_variable( p_insert_ps_c,
2731: 'tax_original',
2732: p_select_rec.total_cm_tax_amount );
2733:
2734: dbms_sql.bind_variable( p_insert_ps_c,
2730: dbms_sql.bind_variable( p_insert_ps_c,
2731: 'tax_original',
2732: p_select_rec.total_cm_tax_amount );
2733:
2734: dbms_sql.bind_variable( p_insert_ps_c,
2735: 'freight_original',
2736: p_select_rec.total_cm_freight_amount );
2737:
2738: dbms_sql.bind_variable( p_insert_ps_c,
2734: dbms_sql.bind_variable( p_insert_ps_c,
2735: 'freight_original',
2736: p_select_rec.total_cm_freight_amount );
2737:
2738: dbms_sql.bind_variable( p_insert_ps_c,
2739: 'receivables_charges_charged',
2740: p_select_rec.total_cm_charges_amount );
2741:
2742: dbms_sql.bind_variable( p_insert_ps_c,
2738: dbms_sql.bind_variable( p_insert_ps_c,
2739: 'receivables_charges_charged',
2740: p_select_rec.total_cm_charges_amount );
2741:
2742: dbms_sql.bind_variable( p_insert_ps_c,
2743: 'amount_applied',
2744: p_select_rec.total_cm_line_amount +
2745: p_select_rec.total_cm_tax_amount +
2746: p_select_rec.total_cm_freight_amount +
2745: p_select_rec.total_cm_tax_amount +
2746: p_select_rec.total_cm_freight_amount +
2747: p_select_rec.total_cm_charges_amount );
2748:
2749: dbms_sql.bind_variable( p_insert_ps_c,
2750: 'trx_date',
2751: p_select_rec.trx_date );
2752:
2753: dbms_sql.bind_variable( p_insert_ps_c,
2749: dbms_sql.bind_variable( p_insert_ps_c,
2750: 'trx_date',
2751: p_select_rec.trx_date );
2752:
2753: dbms_sql.bind_variable( p_insert_ps_c,
2754: 'customer_id',
2755: p_select_rec.customer_id );
2756:
2757: dbms_sql.bind_variable( p_insert_ps_c,
2753: dbms_sql.bind_variable( p_insert_ps_c,
2754: 'customer_id',
2755: p_select_rec.customer_id );
2756:
2757: dbms_sql.bind_variable( p_insert_ps_c,
2758: 'site_use_id',
2759: p_select_rec.site_use_id );
2760:
2761: dbms_sql.bind_variable( p_insert_ps_c,
2757: dbms_sql.bind_variable( p_insert_ps_c,
2758: 'site_use_id',
2759: p_select_rec.site_use_id );
2760:
2761: dbms_sql.bind_variable( p_insert_ps_c,
2762: 'cust_trx_type_id',
2763: p_select_rec.cust_trx_type_id );
2764:
2765: dbms_sql.bind_variable( p_insert_ps_c,
2761: dbms_sql.bind_variable( p_insert_ps_c,
2762: 'cust_trx_type_id',
2763: p_select_rec.cust_trx_type_id );
2764:
2765: dbms_sql.bind_variable( p_insert_ps_c,
2766: 'currency_code',
2767: p_select_rec.currency_code );
2768:
2769: dbms_sql.bind_variable( p_insert_ps_c,
2765: dbms_sql.bind_variable( p_insert_ps_c,
2766: 'currency_code',
2767: p_select_rec.currency_code );
2768:
2769: dbms_sql.bind_variable( p_insert_ps_c,
2770: 'exchange_rate_type',
2771: p_select_rec.exchange_rate_type );
2772:
2773:
2770: 'exchange_rate_type',
2771: p_select_rec.exchange_rate_type );
2772:
2773:
2774: dbms_sql.bind_variable( p_insert_ps_c,
2775: 'exchange_rate',
2776: p_select_rec.exchange_rate );
2777:
2778:
2775: 'exchange_rate',
2776: p_select_rec.exchange_rate );
2777:
2778:
2779: dbms_sql.bind_variable( p_insert_ps_c,
2780: 'exchange_date',
2781: p_select_rec.exchange_date );
2782:
2783: dbms_sql.bind_variable( p_insert_ps_c,
2779: dbms_sql.bind_variable( p_insert_ps_c,
2780: 'exchange_date',
2781: p_select_rec.exchange_date );
2782:
2783: dbms_sql.bind_variable( p_insert_ps_c,
2784: 'gl_date',
2785: p_select_rec.gl_date );
2786:
2787: dbms_sql.bind_variable( p_insert_ps_c,
2783: dbms_sql.bind_variable( p_insert_ps_c,
2784: 'gl_date',
2785: p_select_rec.gl_date );
2786:
2787: dbms_sql.bind_variable( p_insert_ps_c,
2788: 'trx_number',
2789: p_select_rec.trx_number );
2790: --begin anuj
2791: dbms_sql.bind_variable( p_insert_ps_c,
2787: dbms_sql.bind_variable( p_insert_ps_c,
2788: 'trx_number',
2789: p_select_rec.trx_number );
2790: --begin anuj
2791: dbms_sql.bind_variable( p_insert_ps_c,
2792: 'org_id',
2793: arp_standard.sysparm.org_id /* SSA changes anuj */
2794: );
2795: --end anuj
2806: -- Execute
2807: -------------------------------------------------------------
2808: BEGIN
2809: debug( ' Inserting CM payment schedules', MSG_LEVEL_DEBUG );
2810: l_ignore := dbms_sql.execute( p_insert_ps_c );
2811: debug( to_char(l_ignore) || ' row(s) inserted',
2812: MSG_LEVEL_DEBUG );
2813:
2814: /*-------------------------------------------+
2845: select ct.default_ussgl_transaction_code into l_ussgl_transaction_code
2846: from ra_customer_trx ct
2847: WHERE ct.customer_trx_id=p_select_rec.customer_trx_id;
2848:
2849: dbms_sql.bind_variable( p_insert_ra_c,
2850: 'user_id',
2851: p_profile_info.user_id );
2852:
2853: dbms_sql.bind_variable( p_insert_ra_c,
2849: dbms_sql.bind_variable( p_insert_ra_c,
2850: 'user_id',
2851: p_profile_info.user_id );
2852:
2853: dbms_sql.bind_variable( p_insert_ra_c,
2854: 'login_id',
2855: p_profile_info.conc_login_id );
2856:
2857: dbms_sql.bind_variable( p_insert_ra_c,
2853: dbms_sql.bind_variable( p_insert_ra_c,
2854: 'login_id',
2855: p_profile_info.conc_login_id );
2856:
2857: dbms_sql.bind_variable( p_insert_ra_c,
2858: 'request_id',
2859: p_profile_info.request_id );
2860:
2861: dbms_sql.bind_variable( p_insert_ra_c,
2857: dbms_sql.bind_variable( p_insert_ra_c,
2858: 'request_id',
2859: p_profile_info.request_id );
2860:
2861: dbms_sql.bind_variable( p_insert_ra_c,
2862: 'application_id',
2863: p_profile_info.application_id );
2864:
2865: dbms_sql.bind_variable( p_insert_ra_c,
2861: dbms_sql.bind_variable( p_insert_ra_c,
2862: 'application_id',
2863: p_profile_info.application_id );
2864:
2865: dbms_sql.bind_variable( p_insert_ra_c,
2866: 'program_id',
2867: p_profile_info.conc_program_id );
2868:
2869:
2866: 'program_id',
2867: p_profile_info.conc_program_id );
2868:
2869:
2870: dbms_sql.bind_variable( p_insert_ra_c,
2871: 'customer_trx_id',
2872: p_select_rec.customer_trx_id );
2873:
2874: dbms_sql.bind_variable( p_insert_ra_c,
2870: dbms_sql.bind_variable( p_insert_ra_c,
2871: 'customer_trx_id',
2872: p_select_rec.customer_trx_id );
2873:
2874: dbms_sql.bind_variable( p_insert_ra_c,
2875: 'gl_date',
2876: p_select_rec.gl_date );
2877:
2878: dbms_sql.bind_variable( p_insert_ra_c,
2874: dbms_sql.bind_variable( p_insert_ra_c,
2875: 'gl_date',
2876: p_select_rec.gl_date );
2877:
2878: dbms_sql.bind_variable( p_insert_ra_c,
2879: 'code_combination_id',
2880: p_select_rec.code_combination_id );
2881:
2882: dbms_sql.bind_variable(
2878: dbms_sql.bind_variable( p_insert_ra_c,
2879: 'code_combination_id',
2880: p_select_rec.code_combination_id );
2881:
2882: dbms_sql.bind_variable(
2883: p_insert_ra_c,
2884: 'set_of_books_id',
2885: arp_standard.sysparm.set_of_books_id );
2886:
2883: p_insert_ra_c,
2884: 'set_of_books_id',
2885: arp_standard.sysparm.set_of_books_id );
2886:
2887: dbms_sql.bind_variable( p_insert_ra_c,
2888: 'trx_date',
2889: p_select_rec.trx_date );
2890:
2891: dbms_sql.bind_variable( p_insert_ra_c,
2887: dbms_sql.bind_variable( p_insert_ra_c,
2888: 'trx_date',
2889: p_select_rec.trx_date );
2890:
2891: dbms_sql.bind_variable( p_insert_ra_c,
2892: 'applied_customer_trx_id',
2893: p_select_rec.inv_customer_trx_id );
2894:
2895:
2892: 'applied_customer_trx_id',
2893: p_select_rec.inv_customer_trx_id );
2894:
2895:
2896: dbms_sql.bind_variable( p_insert_ra_c,
2897: 'applied_payment_schedule_id',
2898: p_inv_ps_id_t( i ) );
2899:
2900: dbms_sql.bind_variable( p_insert_ra_c,
2896: dbms_sql.bind_variable( p_insert_ra_c,
2897: 'applied_payment_schedule_id',
2898: p_inv_ps_id_t( i ) );
2899:
2900: dbms_sql.bind_variable( p_insert_ra_c,
2901: 'amount_applied',
2902: p_line_applied_t( i ) +
2903: p_tax_applied_t( i ) +
2904: p_freight_applied_t( i ) +
2904: p_freight_applied_t( i ) +
2905: p_charges_applied_t( i ) );
2906:
2907:
2908: dbms_sql.bind_variable( p_insert_ra_c,
2909: 'acctd_amount_applied_from',
2910: p_acctd_amt_applied_from_t( i ) );
2911:
2912: dbms_sql.bind_variable( p_insert_ra_c,
2908: dbms_sql.bind_variable( p_insert_ra_c,
2909: 'acctd_amount_applied_from',
2910: p_acctd_amt_applied_from_t( i ) );
2911:
2912: dbms_sql.bind_variable( p_insert_ra_c,
2913: 'acctd_amount_applied_to',
2914: p_acctd_amt_applied_to_t( i ) );
2915:
2916: dbms_sql.bind_variable( p_insert_ra_c,
2912: dbms_sql.bind_variable( p_insert_ra_c,
2913: 'acctd_amount_applied_to',
2914: p_acctd_amt_applied_to_t( i ) );
2915:
2916: dbms_sql.bind_variable( p_insert_ra_c,
2917: 'line_applied',
2918: p_line_applied_t( i ) );
2919:
2920: dbms_sql.bind_variable( p_insert_ra_c,
2916: dbms_sql.bind_variable( p_insert_ra_c,
2917: 'line_applied',
2918: p_line_applied_t( i ) );
2919:
2920: dbms_sql.bind_variable( p_insert_ra_c,
2921: 'tax_applied',
2922: p_tax_applied_t( i ) );
2923:
2924: dbms_sql.bind_variable( p_insert_ra_c,
2920: dbms_sql.bind_variable( p_insert_ra_c,
2921: 'tax_applied',
2922: p_tax_applied_t( i ) );
2923:
2924: dbms_sql.bind_variable( p_insert_ra_c,
2925: 'freight_applied',
2926: p_freight_applied_t( i ) );
2927:
2928: dbms_sql.bind_variable( p_insert_ra_c,
2924: dbms_sql.bind_variable( p_insert_ra_c,
2925: 'freight_applied',
2926: p_freight_applied_t( i ) );
2927:
2928: dbms_sql.bind_variable( p_insert_ra_c,
2929: 'receivables_charges_applied',
2930: p_charges_applied_t( i ) );
2931:
2932: dbms_sql.bind_variable( p_insert_ra_c,
2928: dbms_sql.bind_variable( p_insert_ra_c,
2929: 'receivables_charges_applied',
2930: p_charges_applied_t( i ) );
2931:
2932: dbms_sql.bind_variable( p_insert_ra_c,
2933: 'post_to_gl_flag',
2934: p_select_rec.post_to_gl_flag );
2935:
2936: select ar_receivable_applications_s.nextval
2936: select ar_receivable_applications_s.nextval
2937: into l_receivable_application_id
2938: from dual;
2939:
2940: dbms_sql.bind_variable( p_insert_ra_c,
2941: 'receivable_application_id',
2942: l_receivable_application_id );
2943:
2944: dbms_sql.bind_variable( p_insert_ra_c,
2940: dbms_sql.bind_variable( p_insert_ra_c,
2941: 'receivable_application_id',
2942: l_receivable_application_id );
2943:
2944: dbms_sql.bind_variable( p_insert_ra_c,
2945: 'ussgl_transaction_code',
2946: l_ussgl_transaction_code );
2947:
2948:
2962: -- Execute
2963: -------------------------------------------------------------
2964: BEGIN
2965: debug( ' Inserting applications', MSG_LEVEL_DEBUG );
2966: l_ignore := dbms_sql.execute( p_insert_ra_c );
2967:
2968: debug( to_char(l_ignore) || ' row(s) inserted',
2969: MSG_LEVEL_DEBUG );
2970:
3029: -------------------------------------------------------------
3030: BEGIN
3031: debug( ' Binding update_ps_c', MSG_LEVEL_DEBUG );
3032:
3033: dbms_sql.bind_variable( p_update_ps_c,
3034: 'user_id',
3035: p_profile_info.user_id );
3036:
3037: dbms_sql.bind_variable( p_update_ps_c,
3033: dbms_sql.bind_variable( p_update_ps_c,
3034: 'user_id',
3035: p_profile_info.user_id );
3036:
3037: dbms_sql.bind_variable( p_update_ps_c,
3038: 'login_id',
3039: p_profile_info.conc_login_id );
3040:
3041: dbms_sql.bind_variable( p_update_ps_c,
3037: dbms_sql.bind_variable( p_update_ps_c,
3038: 'login_id',
3039: p_profile_info.conc_login_id );
3040:
3041: dbms_sql.bind_variable( p_update_ps_c,
3042: 'amount_due_remaining',
3043: p_inv_amount_due_rem_t( i ) );
3044:
3045: dbms_sql.bind_variable( p_update_ps_c,
3041: dbms_sql.bind_variable( p_update_ps_c,
3042: 'amount_due_remaining',
3043: p_inv_amount_due_rem_t( i ) );
3044:
3045: dbms_sql.bind_variable( p_update_ps_c,
3046: 'gl_date_closed',
3047: p_select_rec.gl_date_closed );
3048:
3049: dbms_sql.bind_variable( p_update_ps_c,
3045: dbms_sql.bind_variable( p_update_ps_c,
3046: 'gl_date_closed',
3047: p_select_rec.gl_date_closed );
3048:
3049: dbms_sql.bind_variable( p_update_ps_c,
3050: 'actual_date_closed',
3051: p_select_rec.actual_date_closed );
3052:
3053: dbms_sql.bind_variable( p_update_ps_c,
3049: dbms_sql.bind_variable( p_update_ps_c,
3050: 'actual_date_closed',
3051: p_select_rec.actual_date_closed );
3052:
3053: dbms_sql.bind_variable( p_update_ps_c,
3054: 'amount_line_items_remaining',
3055: p_inv_line_rem_t( i ) );
3056:
3057: dbms_sql.bind_variable( p_update_ps_c,
3053: dbms_sql.bind_variable( p_update_ps_c,
3054: 'amount_line_items_remaining',
3055: p_inv_line_rem_t( i ) );
3056:
3057: dbms_sql.bind_variable( p_update_ps_c,
3058: 'amount_credited',
3059: p_inv_amount_credited_t( i ) );
3060:
3061: dbms_sql.bind_variable( p_update_ps_c,
3057: dbms_sql.bind_variable( p_update_ps_c,
3058: 'amount_credited',
3059: p_inv_amount_credited_t( i ) );
3060:
3061: dbms_sql.bind_variable( p_update_ps_c,
3062: 'freight_remaining',
3063: p_inv_freight_rem_t( i ) );
3064:
3065: dbms_sql.bind_variable( p_update_ps_c,
3061: dbms_sql.bind_variable( p_update_ps_c,
3062: 'freight_remaining',
3063: p_inv_freight_rem_t( i ) );
3064:
3065: dbms_sql.bind_variable( p_update_ps_c,
3066: 'tax_remaining',
3067: p_inv_tax_rem_t( i ) );
3068:
3069: dbms_sql.bind_variable( p_update_ps_c,
3065: dbms_sql.bind_variable( p_update_ps_c,
3066: 'tax_remaining',
3067: p_inv_tax_rem_t( i ) );
3068:
3069: dbms_sql.bind_variable( p_update_ps_c,
3070: 'acctd_amount_due_remaining',
3071: p_inv_acctd_amt_due_rem_t( i ) );
3072:
3073: dbms_sql.bind_variable( p_update_ps_c,
3069: dbms_sql.bind_variable( p_update_ps_c,
3070: 'acctd_amount_due_remaining',
3071: p_inv_acctd_amt_due_rem_t( i ) );
3072:
3073: dbms_sql.bind_variable( p_update_ps_c,
3074: 'receivables_charges_remaining',
3075: p_inv_charges_rem_t( i ) );
3076:
3077: dbms_sql.bind_variable( p_update_ps_c,
3073: dbms_sql.bind_variable( p_update_ps_c,
3074: 'receivables_charges_remaining',
3075: p_inv_charges_rem_t( i ) );
3076:
3077: dbms_sql.bind_variable( p_update_ps_c,
3078: 'applied_payment_schedule_id',
3079: p_inv_ps_id_t( i ) );
3080:
3081:
3091: -- Execute
3092: -------------------------------------------------------------
3093: BEGIN
3094: debug( ' Updating invoice payment schedules', MSG_LEVEL_DEBUG );
3095: l_ignore := dbms_sql.execute( p_update_ps_c );
3096: debug( to_char(l_ignore) || ' row(s) updated',
3097: MSG_LEVEL_DEBUG );
3098:
3099: /*-------------------------------------------+
3291:
3292: --
3293: clear_all_tables;
3294: --
3295: IF( NOT( dbms_sql.is_open( ira_select_c ) AND
3296: dbms_sql.is_open( ira_insert_ps_c ) AND
3297: dbms_sql.is_open( ira_insert_ra_c ) AND
3298: dbms_sql.is_open( ira_update_ps_c ) )) THEN
3299:
3292: --
3293: clear_all_tables;
3294: --
3295: IF( NOT( dbms_sql.is_open( ira_select_c ) AND
3296: dbms_sql.is_open( ira_insert_ps_c ) AND
3297: dbms_sql.is_open( ira_insert_ra_c ) AND
3298: dbms_sql.is_open( ira_update_ps_c ) )) THEN
3299:
3300: build_ira_sql(
3293: clear_all_tables;
3294: --
3295: IF( NOT( dbms_sql.is_open( ira_select_c ) AND
3296: dbms_sql.is_open( ira_insert_ps_c ) AND
3297: dbms_sql.is_open( ira_insert_ra_c ) AND
3298: dbms_sql.is_open( ira_update_ps_c ) )) THEN
3299:
3300: build_ira_sql(
3301: system_info,
3294: --
3295: IF( NOT( dbms_sql.is_open( ira_select_c ) AND
3296: dbms_sql.is_open( ira_insert_ps_c ) AND
3297: dbms_sql.is_open( ira_insert_ra_c ) AND
3298: dbms_sql.is_open( ira_update_ps_c ) )) THEN
3299:
3300: build_ira_sql(
3301: system_info,
3302: profile_info,
3311:
3312: ---------------------------------------------------------------
3313: -- Bind variables
3314: ---------------------------------------------------------------
3315: dbms_sql.bind_variable( ira_select_c,
3316: 'customer_trx_id',
3317: p_customer_trx_id );
3318:
3319: ---------------------------------------------------------------
3321: ---------------------------------------------------------------
3322: debug( ' Executing select sql', MSG_LEVEL_DEBUG );
3323:
3324: BEGIN
3325: l_ignore := dbms_sql.execute( ira_select_c );
3326:
3327: EXCEPTION
3328: WHEN OTHERS THEN
3329: debug( 'EXCEPTION: Error executing select sql',
3337: ---------------------------------------------------------------
3338: BEGIN
3339: LOOP
3340:
3341: IF dbms_sql.fetch_rows( ira_select_c ) > 0 THEN
3342:
3343: debug(' Fetched a row', MSG_LEVEL_DEBUG );
3344:
3345: -----------------------------------------------
3344:
3345: -----------------------------------------------
3346: -- Load row into record
3347: -----------------------------------------------
3348: dbms_sql.column_value( ira_select_c, 4, l_customer_trx_id );
3349: dbms_sql.column_value( ira_select_c, 15,
3350: l_inv_customer_trx_id );
3351:
3352: -----------------------------------------------
3345: -----------------------------------------------
3346: -- Load row into record
3347: -----------------------------------------------
3348: dbms_sql.column_value( ira_select_c, 4, l_customer_trx_id );
3349: dbms_sql.column_value( ira_select_c, 15,
3350: l_inv_customer_trx_id );
3351:
3352: -----------------------------------------------
3353: -- Check if invoice or cm changed
3825: BEGIN
3826: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
3827:
3828: debug( ' Parsing insert_adj_c', MSG_LEVEL_DEBUG );
3829: p_insert_adj_c := dbms_sql.open_cursor;
3830: dbms_sql.parse( p_insert_adj_c, l_insert_adj_sql,
3831: dbms_sql.v7 );
3832:
3833: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
3826: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
3827:
3828: debug( ' Parsing insert_adj_c', MSG_LEVEL_DEBUG );
3829: p_insert_adj_c := dbms_sql.open_cursor;
3830: dbms_sql.parse( p_insert_adj_c, l_insert_adj_sql,
3831: dbms_sql.v7 );
3832:
3833: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
3834: p_update_ps_c := dbms_sql.open_cursor;
3827:
3828: debug( ' Parsing insert_adj_c', MSG_LEVEL_DEBUG );
3829: p_insert_adj_c := dbms_sql.open_cursor;
3830: dbms_sql.parse( p_insert_adj_c, l_insert_adj_sql,
3831: dbms_sql.v7 );
3832:
3833: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
3834: p_update_ps_c := dbms_sql.open_cursor;
3835: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
3830: dbms_sql.parse( p_insert_adj_c, l_insert_adj_sql,
3831: dbms_sql.v7 );
3832:
3833: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
3834: p_update_ps_c := dbms_sql.open_cursor;
3835: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
3836: dbms_sql.v7 );
3837:
3838: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
3831: dbms_sql.v7 );
3832:
3833: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
3834: p_update_ps_c := dbms_sql.open_cursor;
3835: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
3836: dbms_sql.v7 );
3837:
3838: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
3839: p_select_c := dbms_sql.open_cursor;
3832:
3833: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
3834: p_update_ps_c := dbms_sql.open_cursor;
3835: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
3836: dbms_sql.v7 );
3837:
3838: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
3839: p_select_c := dbms_sql.open_cursor;
3840: dbms_sql.parse( p_select_c, l_select_sql,
3835: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
3836: dbms_sql.v7 );
3837:
3838: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
3839: p_select_c := dbms_sql.open_cursor;
3840: dbms_sql.parse( p_select_c, l_select_sql,
3841: dbms_sql.v7 );
3842:
3843: EXCEPTION
3836: dbms_sql.v7 );
3837:
3838: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
3839: p_select_c := dbms_sql.open_cursor;
3840: dbms_sql.parse( p_select_c, l_select_sql,
3841: dbms_sql.v7 );
3842:
3843: EXCEPTION
3844: WHEN OTHERS THEN
3837:
3838: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
3839: p_select_c := dbms_sql.open_cursor;
3840: dbms_sql.parse( p_select_c, l_select_sql,
3841: dbms_sql.v7 );
3842:
3843: EXCEPTION
3844: WHEN OTHERS THEN
3845: IF PG_DEBUG in ('Y', 'C') THEN
3869: BEGIN
3870:
3871: print_fcn_label2( 'arp_maintain_ps2.define_ups_select_columns()+' );
3872:
3873: dbms_sql.define_column( p_select_c, 1, p_select_rec.set_of_books_id );
3874: dbms_sql.define_column( p_select_c, 2, p_select_rec.total_line_amount );
3875: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
3876: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
3877: dbms_sql.define_column( p_select_c, 5,
3870:
3871: print_fcn_label2( 'arp_maintain_ps2.define_ups_select_columns()+' );
3872:
3873: dbms_sql.define_column( p_select_c, 1, p_select_rec.set_of_books_id );
3874: dbms_sql.define_column( p_select_c, 2, p_select_rec.total_line_amount );
3875: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
3876: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
3877: dbms_sql.define_column( p_select_c, 5,
3878: p_select_rec.adjusted_trx_id );
3871: print_fcn_label2( 'arp_maintain_ps2.define_ups_select_columns()+' );
3872:
3873: dbms_sql.define_column( p_select_c, 1, p_select_rec.set_of_books_id );
3874: dbms_sql.define_column( p_select_c, 2, p_select_rec.total_line_amount );
3875: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
3876: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
3877: dbms_sql.define_column( p_select_c, 5,
3878: p_select_rec.adjusted_trx_id );
3879: dbms_sql.define_column( p_select_c, 6,
3872:
3873: dbms_sql.define_column( p_select_c, 1, p_select_rec.set_of_books_id );
3874: dbms_sql.define_column( p_select_c, 2, p_select_rec.total_line_amount );
3875: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
3876: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
3877: dbms_sql.define_column( p_select_c, 5,
3878: p_select_rec.adjusted_trx_id );
3879: dbms_sql.define_column( p_select_c, 6,
3880: p_select_rec.payment_schedule_id );
3873: dbms_sql.define_column( p_select_c, 1, p_select_rec.set_of_books_id );
3874: dbms_sql.define_column( p_select_c, 2, p_select_rec.total_line_amount );
3875: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
3876: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
3877: dbms_sql.define_column( p_select_c, 5,
3878: p_select_rec.adjusted_trx_id );
3879: dbms_sql.define_column( p_select_c, 6,
3880: p_select_rec.payment_schedule_id );
3881: dbms_sql.define_column( p_select_c, 7,
3875: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
3876: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
3877: dbms_sql.define_column( p_select_c, 5,
3878: p_select_rec.adjusted_trx_id );
3879: dbms_sql.define_column( p_select_c, 6,
3880: p_select_rec.payment_schedule_id );
3881: dbms_sql.define_column( p_select_c, 7,
3882: p_select_rec.subsequent_trx_id );
3883: dbms_sql.define_column( p_select_c, 8,
3877: dbms_sql.define_column( p_select_c, 5,
3878: p_select_rec.adjusted_trx_id );
3879: dbms_sql.define_column( p_select_c, 6,
3880: p_select_rec.payment_schedule_id );
3881: dbms_sql.define_column( p_select_c, 7,
3882: p_select_rec.subsequent_trx_id );
3883: dbms_sql.define_column( p_select_c, 8,
3884: p_select_rec.post_to_gl_flag, 1 );
3885: dbms_sql.define_column( p_select_c, 9,
3879: dbms_sql.define_column( p_select_c, 6,
3880: p_select_rec.payment_schedule_id );
3881: dbms_sql.define_column( p_select_c, 7,
3882: p_select_rec.subsequent_trx_id );
3883: dbms_sql.define_column( p_select_c, 8,
3884: p_select_rec.post_to_gl_flag, 1 );
3885: dbms_sql.define_column( p_select_c, 9,
3886: p_select_rec.commitment_trx_id );
3887: dbms_sql.define_column( p_select_c, 10, p_select_rec.percent );
3881: dbms_sql.define_column( p_select_c, 7,
3882: p_select_rec.subsequent_trx_id );
3883: dbms_sql.define_column( p_select_c, 8,
3884: p_select_rec.post_to_gl_flag, 1 );
3885: dbms_sql.define_column( p_select_c, 9,
3886: p_select_rec.commitment_trx_id );
3887: dbms_sql.define_column( p_select_c, 10, p_select_rec.percent );
3888: dbms_sql.define_column( p_select_c, 11, p_select_rec.precision );
3889: dbms_sql.define_column( p_select_c, 12, p_select_rec.min_acc_unit );
3883: dbms_sql.define_column( p_select_c, 8,
3884: p_select_rec.post_to_gl_flag, 1 );
3885: dbms_sql.define_column( p_select_c, 9,
3886: p_select_rec.commitment_trx_id );
3887: dbms_sql.define_column( p_select_c, 10, p_select_rec.percent );
3888: dbms_sql.define_column( p_select_c, 11, p_select_rec.precision );
3889: dbms_sql.define_column( p_select_c, 12, p_select_rec.min_acc_unit );
3890: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date_closed );
3891: dbms_sql.define_column( p_select_c, 14, p_select_rec.actual_date_closed );
3884: p_select_rec.post_to_gl_flag, 1 );
3885: dbms_sql.define_column( p_select_c, 9,
3886: p_select_rec.commitment_trx_id );
3887: dbms_sql.define_column( p_select_c, 10, p_select_rec.percent );
3888: dbms_sql.define_column( p_select_c, 11, p_select_rec.precision );
3889: dbms_sql.define_column( p_select_c, 12, p_select_rec.min_acc_unit );
3890: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date_closed );
3891: dbms_sql.define_column( p_select_c, 14, p_select_rec.actual_date_closed );
3892: dbms_sql.define_column( p_select_c, 15, p_select_rec.trx_date );
3885: dbms_sql.define_column( p_select_c, 9,
3886: p_select_rec.commitment_trx_id );
3887: dbms_sql.define_column( p_select_c, 10, p_select_rec.percent );
3888: dbms_sql.define_column( p_select_c, 11, p_select_rec.precision );
3889: dbms_sql.define_column( p_select_c, 12, p_select_rec.min_acc_unit );
3890: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date_closed );
3891: dbms_sql.define_column( p_select_c, 14, p_select_rec.actual_date_closed );
3892: dbms_sql.define_column( p_select_c, 15, p_select_rec.trx_date );
3893: dbms_sql.define_column( p_select_c, 16, p_select_rec.commitment_type, 20 );
3886: p_select_rec.commitment_trx_id );
3887: dbms_sql.define_column( p_select_c, 10, p_select_rec.percent );
3888: dbms_sql.define_column( p_select_c, 11, p_select_rec.precision );
3889: dbms_sql.define_column( p_select_c, 12, p_select_rec.min_acc_unit );
3890: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date_closed );
3891: dbms_sql.define_column( p_select_c, 14, p_select_rec.actual_date_closed );
3892: dbms_sql.define_column( p_select_c, 15, p_select_rec.trx_date );
3893: dbms_sql.define_column( p_select_c, 16, p_select_rec.commitment_type, 20 );
3894: dbms_sql.define_column( p_select_c, 17, p_select_rec.line_remaining );
3887: dbms_sql.define_column( p_select_c, 10, p_select_rec.percent );
3888: dbms_sql.define_column( p_select_c, 11, p_select_rec.precision );
3889: dbms_sql.define_column( p_select_c, 12, p_select_rec.min_acc_unit );
3890: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date_closed );
3891: dbms_sql.define_column( p_select_c, 14, p_select_rec.actual_date_closed );
3892: dbms_sql.define_column( p_select_c, 15, p_select_rec.trx_date );
3893: dbms_sql.define_column( p_select_c, 16, p_select_rec.commitment_type, 20 );
3894: dbms_sql.define_column( p_select_c, 17, p_select_rec.line_remaining );
3895: dbms_sql.define_column( p_select_c, 18,
3888: dbms_sql.define_column( p_select_c, 11, p_select_rec.precision );
3889: dbms_sql.define_column( p_select_c, 12, p_select_rec.min_acc_unit );
3890: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date_closed );
3891: dbms_sql.define_column( p_select_c, 14, p_select_rec.actual_date_closed );
3892: dbms_sql.define_column( p_select_c, 15, p_select_rec.trx_date );
3893: dbms_sql.define_column( p_select_c, 16, p_select_rec.commitment_type, 20 );
3894: dbms_sql.define_column( p_select_c, 17, p_select_rec.line_remaining );
3895: dbms_sql.define_column( p_select_c, 18,
3896: p_select_rec.amount_due_remaining );
3889: dbms_sql.define_column( p_select_c, 12, p_select_rec.min_acc_unit );
3890: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date_closed );
3891: dbms_sql.define_column( p_select_c, 14, p_select_rec.actual_date_closed );
3892: dbms_sql.define_column( p_select_c, 15, p_select_rec.trx_date );
3893: dbms_sql.define_column( p_select_c, 16, p_select_rec.commitment_type, 20 );
3894: dbms_sql.define_column( p_select_c, 17, p_select_rec.line_remaining );
3895: dbms_sql.define_column( p_select_c, 18,
3896: p_select_rec.amount_due_remaining );
3897: dbms_sql.define_column( p_select_c, 19,
3890: dbms_sql.define_column( p_select_c, 13, p_select_rec.gl_date_closed );
3891: dbms_sql.define_column( p_select_c, 14, p_select_rec.actual_date_closed );
3892: dbms_sql.define_column( p_select_c, 15, p_select_rec.trx_date );
3893: dbms_sql.define_column( p_select_c, 16, p_select_rec.commitment_type, 20 );
3894: dbms_sql.define_column( p_select_c, 17, p_select_rec.line_remaining );
3895: dbms_sql.define_column( p_select_c, 18,
3896: p_select_rec.amount_due_remaining );
3897: dbms_sql.define_column( p_select_c, 19,
3898: p_select_rec.acctd_amt_due_rem );
3891: dbms_sql.define_column( p_select_c, 14, p_select_rec.actual_date_closed );
3892: dbms_sql.define_column( p_select_c, 15, p_select_rec.trx_date );
3893: dbms_sql.define_column( p_select_c, 16, p_select_rec.commitment_type, 20 );
3894: dbms_sql.define_column( p_select_c, 17, p_select_rec.line_remaining );
3895: dbms_sql.define_column( p_select_c, 18,
3896: p_select_rec.amount_due_remaining );
3897: dbms_sql.define_column( p_select_c, 19,
3898: p_select_rec.acctd_amt_due_rem );
3899: dbms_sql.define_column( p_select_c, 20,
3893: dbms_sql.define_column( p_select_c, 16, p_select_rec.commitment_type, 20 );
3894: dbms_sql.define_column( p_select_c, 17, p_select_rec.line_remaining );
3895: dbms_sql.define_column( p_select_c, 18,
3896: p_select_rec.amount_due_remaining );
3897: dbms_sql.define_column( p_select_c, 19,
3898: p_select_rec.acctd_amt_due_rem );
3899: dbms_sql.define_column( p_select_c, 20,
3900: p_select_rec.amount_adjusted );
3901: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
3895: dbms_sql.define_column( p_select_c, 18,
3896: p_select_rec.amount_due_remaining );
3897: dbms_sql.define_column( p_select_c, 19,
3898: p_select_rec.acctd_amt_due_rem );
3899: dbms_sql.define_column( p_select_c, 20,
3900: p_select_rec.amount_adjusted );
3901: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
3902: dbms_sql.define_column( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3903: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
3897: dbms_sql.define_column( p_select_c, 19,
3898: p_select_rec.acctd_amt_due_rem );
3899: dbms_sql.define_column( p_select_c, 20,
3900: p_select_rec.amount_adjusted );
3901: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
3902: dbms_sql.define_column( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3903: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
3904: dbms_sql.define_column( p_select_c, 24, p_select_rec.customer_trx_id );
3905: dbms_sql.define_column( p_select_c, 25,
3898: p_select_rec.acctd_amt_due_rem );
3899: dbms_sql.define_column( p_select_c, 20,
3900: p_select_rec.amount_adjusted );
3901: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
3902: dbms_sql.define_column( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3903: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
3904: dbms_sql.define_column( p_select_c, 24, p_select_rec.customer_trx_id );
3905: dbms_sql.define_column( p_select_c, 25,
3906: p_select_rec.ps_currency_code, 15 );
3899: dbms_sql.define_column( p_select_c, 20,
3900: p_select_rec.amount_adjusted );
3901: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
3902: dbms_sql.define_column( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3903: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
3904: dbms_sql.define_column( p_select_c, 24, p_select_rec.customer_trx_id );
3905: dbms_sql.define_column( p_select_c, 25,
3906: p_select_rec.ps_currency_code, 15 );
3907: -- 1483656 new columns for allocating tax and freight
3900: p_select_rec.amount_adjusted );
3901: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
3902: dbms_sql.define_column( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3903: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
3904: dbms_sql.define_column( p_select_c, 24, p_select_rec.customer_trx_id );
3905: dbms_sql.define_column( p_select_c, 25,
3906: p_select_rec.ps_currency_code, 15 );
3907: -- 1483656 new columns for allocating tax and freight
3908: dbms_sql.define_column( p_select_c, 26, p_select_rec.allocate_tax_freight,1 );
3901: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
3902: dbms_sql.define_column( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3903: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
3904: dbms_sql.define_column( p_select_c, 24, p_select_rec.customer_trx_id );
3905: dbms_sql.define_column( p_select_c, 25,
3906: p_select_rec.ps_currency_code, 15 );
3907: -- 1483656 new columns for allocating tax and freight
3908: dbms_sql.define_column( p_select_c, 26, p_select_rec.allocate_tax_freight,1 );
3909: dbms_sql.define_column( p_select_c, 27, p_select_rec.adjustment_type,8 );
3904: dbms_sql.define_column( p_select_c, 24, p_select_rec.customer_trx_id );
3905: dbms_sql.define_column( p_select_c, 25,
3906: p_select_rec.ps_currency_code, 15 );
3907: -- 1483656 new columns for allocating tax and freight
3908: dbms_sql.define_column( p_select_c, 26, p_select_rec.allocate_tax_freight,1 );
3909: dbms_sql.define_column( p_select_c, 27, p_select_rec.adjustment_type,8 );
3910: dbms_sql.define_column( p_select_c, 28, p_select_rec.tax_remaining );
3911: dbms_sql.define_column( p_select_c, 29, p_select_rec.freight_remaining );
3912: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_tax_amount );
3905: dbms_sql.define_column( p_select_c, 25,
3906: p_select_rec.ps_currency_code, 15 );
3907: -- 1483656 new columns for allocating tax and freight
3908: dbms_sql.define_column( p_select_c, 26, p_select_rec.allocate_tax_freight,1 );
3909: dbms_sql.define_column( p_select_c, 27, p_select_rec.adjustment_type,8 );
3910: dbms_sql.define_column( p_select_c, 28, p_select_rec.tax_remaining );
3911: dbms_sql.define_column( p_select_c, 29, p_select_rec.freight_remaining );
3912: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_tax_amount );
3913: dbms_sql.define_column( p_select_c, 31, p_select_rec.total_freight_amount );
3906: p_select_rec.ps_currency_code, 15 );
3907: -- 1483656 new columns for allocating tax and freight
3908: dbms_sql.define_column( p_select_c, 26, p_select_rec.allocate_tax_freight,1 );
3909: dbms_sql.define_column( p_select_c, 27, p_select_rec.adjustment_type,8 );
3910: dbms_sql.define_column( p_select_c, 28, p_select_rec.tax_remaining );
3911: dbms_sql.define_column( p_select_c, 29, p_select_rec.freight_remaining );
3912: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_tax_amount );
3913: dbms_sql.define_column( p_select_c, 31, p_select_rec.total_freight_amount );
3914:
3907: -- 1483656 new columns for allocating tax and freight
3908: dbms_sql.define_column( p_select_c, 26, p_select_rec.allocate_tax_freight,1 );
3909: dbms_sql.define_column( p_select_c, 27, p_select_rec.adjustment_type,8 );
3910: dbms_sql.define_column( p_select_c, 28, p_select_rec.tax_remaining );
3911: dbms_sql.define_column( p_select_c, 29, p_select_rec.freight_remaining );
3912: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_tax_amount );
3913: dbms_sql.define_column( p_select_c, 31, p_select_rec.total_freight_amount );
3914:
3915: print_fcn_label2( 'arp_maintain_ps2.define_ups_select_columns()-' );
3908: dbms_sql.define_column( p_select_c, 26, p_select_rec.allocate_tax_freight,1 );
3909: dbms_sql.define_column( p_select_c, 27, p_select_rec.adjustment_type,8 );
3910: dbms_sql.define_column( p_select_c, 28, p_select_rec.tax_remaining );
3911: dbms_sql.define_column( p_select_c, 29, p_select_rec.freight_remaining );
3912: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_tax_amount );
3913: dbms_sql.define_column( p_select_c, 31, p_select_rec.total_freight_amount );
3914:
3915: print_fcn_label2( 'arp_maintain_ps2.define_ups_select_columns()-' );
3916:
3909: dbms_sql.define_column( p_select_c, 27, p_select_rec.adjustment_type,8 );
3910: dbms_sql.define_column( p_select_c, 28, p_select_rec.tax_remaining );
3911: dbms_sql.define_column( p_select_c, 29, p_select_rec.freight_remaining );
3912: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_tax_amount );
3913: dbms_sql.define_column( p_select_c, 31, p_select_rec.total_freight_amount );
3914:
3915: print_fcn_label2( 'arp_maintain_ps2.define_ups_select_columns()-' );
3916:
3917: EXCEPTION
3928: /* Bug 460927 - Changed IN to IN OUT in the above line - Oracle 8 */
3929: BEGIN
3930: print_fcn_label2( 'arp_maintain_ps2.get_ups_column_values()+' );
3931:
3932: dbms_sql.column_value( p_select_c, 1, p_select_rec.set_of_books_id );
3933: dbms_sql.column_value( p_select_c, 2, p_select_rec.total_line_amount );
3934: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
3935: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
3936: dbms_sql.column_value( p_select_c, 5,
3929: BEGIN
3930: print_fcn_label2( 'arp_maintain_ps2.get_ups_column_values()+' );
3931:
3932: dbms_sql.column_value( p_select_c, 1, p_select_rec.set_of_books_id );
3933: dbms_sql.column_value( p_select_c, 2, p_select_rec.total_line_amount );
3934: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
3935: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
3936: dbms_sql.column_value( p_select_c, 5,
3937: p_select_rec.adjusted_trx_id );
3930: print_fcn_label2( 'arp_maintain_ps2.get_ups_column_values()+' );
3931:
3932: dbms_sql.column_value( p_select_c, 1, p_select_rec.set_of_books_id );
3933: dbms_sql.column_value( p_select_c, 2, p_select_rec.total_line_amount );
3934: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
3935: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
3936: dbms_sql.column_value( p_select_c, 5,
3937: p_select_rec.adjusted_trx_id );
3938: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
3931:
3932: dbms_sql.column_value( p_select_c, 1, p_select_rec.set_of_books_id );
3933: dbms_sql.column_value( p_select_c, 2, p_select_rec.total_line_amount );
3934: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
3935: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
3936: dbms_sql.column_value( p_select_c, 5,
3937: p_select_rec.adjusted_trx_id );
3938: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
3939: dbms_sql.column_value( p_select_c, 7, p_select_rec.subsequent_trx_id );
3932: dbms_sql.column_value( p_select_c, 1, p_select_rec.set_of_books_id );
3933: dbms_sql.column_value( p_select_c, 2, p_select_rec.total_line_amount );
3934: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
3935: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
3936: dbms_sql.column_value( p_select_c, 5,
3937: p_select_rec.adjusted_trx_id );
3938: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
3939: dbms_sql.column_value( p_select_c, 7, p_select_rec.subsequent_trx_id );
3940: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
3934: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
3935: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
3936: dbms_sql.column_value( p_select_c, 5,
3937: p_select_rec.adjusted_trx_id );
3938: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
3939: dbms_sql.column_value( p_select_c, 7, p_select_rec.subsequent_trx_id );
3940: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
3941: dbms_sql.column_value( p_select_c, 9, p_select_rec.commitment_trx_id );
3942: dbms_sql.column_value( p_select_c, 10, p_select_rec.percent );
3935: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
3936: dbms_sql.column_value( p_select_c, 5,
3937: p_select_rec.adjusted_trx_id );
3938: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
3939: dbms_sql.column_value( p_select_c, 7, p_select_rec.subsequent_trx_id );
3940: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
3941: dbms_sql.column_value( p_select_c, 9, p_select_rec.commitment_trx_id );
3942: dbms_sql.column_value( p_select_c, 10, p_select_rec.percent );
3943: dbms_sql.column_value( p_select_c, 11, p_select_rec.precision );
3936: dbms_sql.column_value( p_select_c, 5,
3937: p_select_rec.adjusted_trx_id );
3938: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
3939: dbms_sql.column_value( p_select_c, 7, p_select_rec.subsequent_trx_id );
3940: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
3941: dbms_sql.column_value( p_select_c, 9, p_select_rec.commitment_trx_id );
3942: dbms_sql.column_value( p_select_c, 10, p_select_rec.percent );
3943: dbms_sql.column_value( p_select_c, 11, p_select_rec.precision );
3944: dbms_sql.column_value( p_select_c, 12, p_select_rec.min_acc_unit );
3937: p_select_rec.adjusted_trx_id );
3938: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
3939: dbms_sql.column_value( p_select_c, 7, p_select_rec.subsequent_trx_id );
3940: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
3941: dbms_sql.column_value( p_select_c, 9, p_select_rec.commitment_trx_id );
3942: dbms_sql.column_value( p_select_c, 10, p_select_rec.percent );
3943: dbms_sql.column_value( p_select_c, 11, p_select_rec.precision );
3944: dbms_sql.column_value( p_select_c, 12, p_select_rec.min_acc_unit );
3945: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date_closed );
3938: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
3939: dbms_sql.column_value( p_select_c, 7, p_select_rec.subsequent_trx_id );
3940: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
3941: dbms_sql.column_value( p_select_c, 9, p_select_rec.commitment_trx_id );
3942: dbms_sql.column_value( p_select_c, 10, p_select_rec.percent );
3943: dbms_sql.column_value( p_select_c, 11, p_select_rec.precision );
3944: dbms_sql.column_value( p_select_c, 12, p_select_rec.min_acc_unit );
3945: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date_closed );
3946: dbms_sql.column_value( p_select_c, 14, p_select_rec.actual_date_closed );
3939: dbms_sql.column_value( p_select_c, 7, p_select_rec.subsequent_trx_id );
3940: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
3941: dbms_sql.column_value( p_select_c, 9, p_select_rec.commitment_trx_id );
3942: dbms_sql.column_value( p_select_c, 10, p_select_rec.percent );
3943: dbms_sql.column_value( p_select_c, 11, p_select_rec.precision );
3944: dbms_sql.column_value( p_select_c, 12, p_select_rec.min_acc_unit );
3945: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date_closed );
3946: dbms_sql.column_value( p_select_c, 14, p_select_rec.actual_date_closed );
3947: dbms_sql.column_value( p_select_c, 15, p_select_rec.trx_date );
3940: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
3941: dbms_sql.column_value( p_select_c, 9, p_select_rec.commitment_trx_id );
3942: dbms_sql.column_value( p_select_c, 10, p_select_rec.percent );
3943: dbms_sql.column_value( p_select_c, 11, p_select_rec.precision );
3944: dbms_sql.column_value( p_select_c, 12, p_select_rec.min_acc_unit );
3945: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date_closed );
3946: dbms_sql.column_value( p_select_c, 14, p_select_rec.actual_date_closed );
3947: dbms_sql.column_value( p_select_c, 15, p_select_rec.trx_date );
3948: dbms_sql.column_value( p_select_c, 16, p_select_rec.commitment_type );
3941: dbms_sql.column_value( p_select_c, 9, p_select_rec.commitment_trx_id );
3942: dbms_sql.column_value( p_select_c, 10, p_select_rec.percent );
3943: dbms_sql.column_value( p_select_c, 11, p_select_rec.precision );
3944: dbms_sql.column_value( p_select_c, 12, p_select_rec.min_acc_unit );
3945: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date_closed );
3946: dbms_sql.column_value( p_select_c, 14, p_select_rec.actual_date_closed );
3947: dbms_sql.column_value( p_select_c, 15, p_select_rec.trx_date );
3948: dbms_sql.column_value( p_select_c, 16, p_select_rec.commitment_type );
3949: dbms_sql.column_value( p_select_c, 17, p_select_rec.line_remaining );
3942: dbms_sql.column_value( p_select_c, 10, p_select_rec.percent );
3943: dbms_sql.column_value( p_select_c, 11, p_select_rec.precision );
3944: dbms_sql.column_value( p_select_c, 12, p_select_rec.min_acc_unit );
3945: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date_closed );
3946: dbms_sql.column_value( p_select_c, 14, p_select_rec.actual_date_closed );
3947: dbms_sql.column_value( p_select_c, 15, p_select_rec.trx_date );
3948: dbms_sql.column_value( p_select_c, 16, p_select_rec.commitment_type );
3949: dbms_sql.column_value( p_select_c, 17, p_select_rec.line_remaining );
3950: dbms_sql.column_value( p_select_c, 18,
3943: dbms_sql.column_value( p_select_c, 11, p_select_rec.precision );
3944: dbms_sql.column_value( p_select_c, 12, p_select_rec.min_acc_unit );
3945: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date_closed );
3946: dbms_sql.column_value( p_select_c, 14, p_select_rec.actual_date_closed );
3947: dbms_sql.column_value( p_select_c, 15, p_select_rec.trx_date );
3948: dbms_sql.column_value( p_select_c, 16, p_select_rec.commitment_type );
3949: dbms_sql.column_value( p_select_c, 17, p_select_rec.line_remaining );
3950: dbms_sql.column_value( p_select_c, 18,
3951: p_select_rec.amount_due_remaining );
3944: dbms_sql.column_value( p_select_c, 12, p_select_rec.min_acc_unit );
3945: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date_closed );
3946: dbms_sql.column_value( p_select_c, 14, p_select_rec.actual_date_closed );
3947: dbms_sql.column_value( p_select_c, 15, p_select_rec.trx_date );
3948: dbms_sql.column_value( p_select_c, 16, p_select_rec.commitment_type );
3949: dbms_sql.column_value( p_select_c, 17, p_select_rec.line_remaining );
3950: dbms_sql.column_value( p_select_c, 18,
3951: p_select_rec.amount_due_remaining );
3952: dbms_sql.column_value( p_select_c, 19, p_select_rec.acctd_amt_due_rem );
3945: dbms_sql.column_value( p_select_c, 13, p_select_rec.gl_date_closed );
3946: dbms_sql.column_value( p_select_c, 14, p_select_rec.actual_date_closed );
3947: dbms_sql.column_value( p_select_c, 15, p_select_rec.trx_date );
3948: dbms_sql.column_value( p_select_c, 16, p_select_rec.commitment_type );
3949: dbms_sql.column_value( p_select_c, 17, p_select_rec.line_remaining );
3950: dbms_sql.column_value( p_select_c, 18,
3951: p_select_rec.amount_due_remaining );
3952: dbms_sql.column_value( p_select_c, 19, p_select_rec.acctd_amt_due_rem );
3953: dbms_sql.column_value( p_select_c, 20, p_select_rec.amount_adjusted );
3946: dbms_sql.column_value( p_select_c, 14, p_select_rec.actual_date_closed );
3947: dbms_sql.column_value( p_select_c, 15, p_select_rec.trx_date );
3948: dbms_sql.column_value( p_select_c, 16, p_select_rec.commitment_type );
3949: dbms_sql.column_value( p_select_c, 17, p_select_rec.line_remaining );
3950: dbms_sql.column_value( p_select_c, 18,
3951: p_select_rec.amount_due_remaining );
3952: dbms_sql.column_value( p_select_c, 19, p_select_rec.acctd_amt_due_rem );
3953: dbms_sql.column_value( p_select_c, 20, p_select_rec.amount_adjusted );
3954: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
3948: dbms_sql.column_value( p_select_c, 16, p_select_rec.commitment_type );
3949: dbms_sql.column_value( p_select_c, 17, p_select_rec.line_remaining );
3950: dbms_sql.column_value( p_select_c, 18,
3951: p_select_rec.amount_due_remaining );
3952: dbms_sql.column_value( p_select_c, 19, p_select_rec.acctd_amt_due_rem );
3953: dbms_sql.column_value( p_select_c, 20, p_select_rec.amount_adjusted );
3954: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
3955: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3956: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
3949: dbms_sql.column_value( p_select_c, 17, p_select_rec.line_remaining );
3950: dbms_sql.column_value( p_select_c, 18,
3951: p_select_rec.amount_due_remaining );
3952: dbms_sql.column_value( p_select_c, 19, p_select_rec.acctd_amt_due_rem );
3953: dbms_sql.column_value( p_select_c, 20, p_select_rec.amount_adjusted );
3954: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
3955: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3956: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
3957: dbms_sql.column_value( p_select_c, 24, p_select_rec.customer_trx_id );
3950: dbms_sql.column_value( p_select_c, 18,
3951: p_select_rec.amount_due_remaining );
3952: dbms_sql.column_value( p_select_c, 19, p_select_rec.acctd_amt_due_rem );
3953: dbms_sql.column_value( p_select_c, 20, p_select_rec.amount_adjusted );
3954: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
3955: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3956: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
3957: dbms_sql.column_value( p_select_c, 24, p_select_rec.customer_trx_id );
3958: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_currency_code );
3951: p_select_rec.amount_due_remaining );
3952: dbms_sql.column_value( p_select_c, 19, p_select_rec.acctd_amt_due_rem );
3953: dbms_sql.column_value( p_select_c, 20, p_select_rec.amount_adjusted );
3954: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
3955: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3956: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
3957: dbms_sql.column_value( p_select_c, 24, p_select_rec.customer_trx_id );
3958: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_currency_code );
3959: -- 1483656 new columns for allocating tax and freight
3952: dbms_sql.column_value( p_select_c, 19, p_select_rec.acctd_amt_due_rem );
3953: dbms_sql.column_value( p_select_c, 20, p_select_rec.amount_adjusted );
3954: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
3955: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3956: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
3957: dbms_sql.column_value( p_select_c, 24, p_select_rec.customer_trx_id );
3958: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_currency_code );
3959: -- 1483656 new columns for allocating tax and freight
3960: dbms_sql.column_value( p_select_c, 26, p_select_rec.allocate_tax_freight );
3953: dbms_sql.column_value( p_select_c, 20, p_select_rec.amount_adjusted );
3954: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
3955: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3956: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
3957: dbms_sql.column_value( p_select_c, 24, p_select_rec.customer_trx_id );
3958: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_currency_code );
3959: -- 1483656 new columns for allocating tax and freight
3960: dbms_sql.column_value( p_select_c, 26, p_select_rec.allocate_tax_freight );
3961: dbms_sql.column_value( p_select_c, 27, p_select_rec.adjustment_type );
3954: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
3955: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
3956: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
3957: dbms_sql.column_value( p_select_c, 24, p_select_rec.customer_trx_id );
3958: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_currency_code );
3959: -- 1483656 new columns for allocating tax and freight
3960: dbms_sql.column_value( p_select_c, 26, p_select_rec.allocate_tax_freight );
3961: dbms_sql.column_value( p_select_c, 27, p_select_rec.adjustment_type );
3962: dbms_sql.column_value( p_select_c, 28, p_select_rec.tax_remaining );
3956: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
3957: dbms_sql.column_value( p_select_c, 24, p_select_rec.customer_trx_id );
3958: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_currency_code );
3959: -- 1483656 new columns for allocating tax and freight
3960: dbms_sql.column_value( p_select_c, 26, p_select_rec.allocate_tax_freight );
3961: dbms_sql.column_value( p_select_c, 27, p_select_rec.adjustment_type );
3962: dbms_sql.column_value( p_select_c, 28, p_select_rec.tax_remaining );
3963: dbms_sql.column_value( p_select_c, 29, p_select_rec.freight_remaining );
3964: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_tax_amount );
3957: dbms_sql.column_value( p_select_c, 24, p_select_rec.customer_trx_id );
3958: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_currency_code );
3959: -- 1483656 new columns for allocating tax and freight
3960: dbms_sql.column_value( p_select_c, 26, p_select_rec.allocate_tax_freight );
3961: dbms_sql.column_value( p_select_c, 27, p_select_rec.adjustment_type );
3962: dbms_sql.column_value( p_select_c, 28, p_select_rec.tax_remaining );
3963: dbms_sql.column_value( p_select_c, 29, p_select_rec.freight_remaining );
3964: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_tax_amount );
3965: dbms_sql.column_value( p_select_c, 31, p_select_rec.total_freight_amount );
3958: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_currency_code );
3959: -- 1483656 new columns for allocating tax and freight
3960: dbms_sql.column_value( p_select_c, 26, p_select_rec.allocate_tax_freight );
3961: dbms_sql.column_value( p_select_c, 27, p_select_rec.adjustment_type );
3962: dbms_sql.column_value( p_select_c, 28, p_select_rec.tax_remaining );
3963: dbms_sql.column_value( p_select_c, 29, p_select_rec.freight_remaining );
3964: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_tax_amount );
3965: dbms_sql.column_value( p_select_c, 31, p_select_rec.total_freight_amount );
3966:
3959: -- 1483656 new columns for allocating tax and freight
3960: dbms_sql.column_value( p_select_c, 26, p_select_rec.allocate_tax_freight );
3961: dbms_sql.column_value( p_select_c, 27, p_select_rec.adjustment_type );
3962: dbms_sql.column_value( p_select_c, 28, p_select_rec.tax_remaining );
3963: dbms_sql.column_value( p_select_c, 29, p_select_rec.freight_remaining );
3964: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_tax_amount );
3965: dbms_sql.column_value( p_select_c, 31, p_select_rec.total_freight_amount );
3966:
3967: print_fcn_label2( 'arp_maintain_ps2.get_ups_column_values()-' );
3960: dbms_sql.column_value( p_select_c, 26, p_select_rec.allocate_tax_freight );
3961: dbms_sql.column_value( p_select_c, 27, p_select_rec.adjustment_type );
3962: dbms_sql.column_value( p_select_c, 28, p_select_rec.tax_remaining );
3963: dbms_sql.column_value( p_select_c, 29, p_select_rec.freight_remaining );
3964: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_tax_amount );
3965: dbms_sql.column_value( p_select_c, 31, p_select_rec.total_freight_amount );
3966:
3967: print_fcn_label2( 'arp_maintain_ps2.get_ups_column_values()-' );
3968: EXCEPTION
3961: dbms_sql.column_value( p_select_c, 27, p_select_rec.adjustment_type );
3962: dbms_sql.column_value( p_select_c, 28, p_select_rec.tax_remaining );
3963: dbms_sql.column_value( p_select_c, 29, p_select_rec.freight_remaining );
3964: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_tax_amount );
3965: dbms_sql.column_value( p_select_c, 31, p_select_rec.total_freight_amount );
3966:
3967: print_fcn_label2( 'arp_maintain_ps2.get_ups_column_values()-' );
3968: EXCEPTION
3969: WHEN OTHERS THEN
4399: -------------------------------------------------------------
4400: BEGIN
4401: debug( ' Binding insert_adj_c', MSG_LEVEL_DEBUG );
4402:
4403: dbms_sql.bind_variable( p_insert_adj_c,
4404: 'user_id',
4405: p_profile_info.user_id );
4406:
4407: dbms_sql.bind_variable( p_insert_adj_c,
4403: dbms_sql.bind_variable( p_insert_adj_c,
4404: 'user_id',
4405: p_profile_info.user_id );
4406:
4407: dbms_sql.bind_variable( p_insert_adj_c,
4408: 'login_id',
4409: p_profile_info.conc_login_id );
4410:
4411: dbms_sql.bind_variable( p_insert_adj_c,
4407: dbms_sql.bind_variable( p_insert_adj_c,
4408: 'login_id',
4409: p_profile_info.conc_login_id );
4410:
4411: dbms_sql.bind_variable( p_insert_adj_c,
4412: 'request_id',
4413: p_profile_info.request_id );
4414:
4415: dbms_sql.bind_variable( p_insert_adj_c,
4411: dbms_sql.bind_variable( p_insert_adj_c,
4412: 'request_id',
4413: p_profile_info.request_id );
4414:
4415: dbms_sql.bind_variable( p_insert_adj_c,
4416: 'application_id',
4417: p_profile_info.application_id );
4418:
4419: dbms_sql.bind_variable( p_insert_adj_c,
4415: dbms_sql.bind_variable( p_insert_adj_c,
4416: 'application_id',
4417: p_profile_info.application_id );
4418:
4419: dbms_sql.bind_variable( p_insert_adj_c,
4420: 'program_id',
4421: p_profile_info.conc_program_id );
4422:
4423:
4420: 'program_id',
4421: p_profile_info.conc_program_id );
4422:
4423:
4424: dbms_sql.bind_variable(
4425: p_insert_adj_c,
4426: 'set_of_books_id',
4427: p_select_rec.set_of_books_id );
4428:
4425: p_insert_adj_c,
4426: 'set_of_books_id',
4427: p_select_rec.set_of_books_id );
4428:
4429: dbms_sql.bind_variable( p_insert_adj_c,
4430: 'trx_date',
4431: p_select_rec.trx_date );
4432:
4433: dbms_sql.bind_variable( p_insert_adj_c,
4429: dbms_sql.bind_variable( p_insert_adj_c,
4430: 'trx_date',
4431: p_select_rec.trx_date );
4432:
4433: dbms_sql.bind_variable( p_insert_adj_c,
4434: 'gl_date',
4435: p_select_rec.gl_date );
4436:
4437: dbms_sql.bind_variable( p_insert_adj_c,
4433: dbms_sql.bind_variable( p_insert_adj_c,
4434: 'gl_date',
4435: p_select_rec.gl_date );
4436:
4437: dbms_sql.bind_variable( p_insert_adj_c,
4438: 'code_combination_id',
4439: p_select_rec.code_combination_id );
4440:
4441: dbms_sql.bind_variable( p_insert_adj_c,
4437: dbms_sql.bind_variable( p_insert_adj_c,
4438: 'code_combination_id',
4439: p_select_rec.code_combination_id );
4440:
4441: dbms_sql.bind_variable( p_insert_adj_c,
4442: 'adjusted_trx_id',
4443: p_select_rec.adjusted_trx_id );
4444:
4445: dbms_sql.bind_variable( p_insert_adj_c,
4441: dbms_sql.bind_variable( p_insert_adj_c,
4442: 'adjusted_trx_id',
4443: p_select_rec.adjusted_trx_id );
4444:
4445: dbms_sql.bind_variable( p_insert_adj_c,
4446: 'payment_schedule_id',
4447: p_ps_id_t( i ) );
4448:
4449: dbms_sql.bind_variable( p_insert_adj_c,
4445: dbms_sql.bind_variable( p_insert_adj_c,
4446: 'payment_schedule_id',
4447: p_ps_id_t( i ) );
4448:
4449: dbms_sql.bind_variable( p_insert_adj_c,
4450: 'subsequent_trx_id',
4451: p_select_rec.subsequent_trx_id );
4452:
4453: dbms_sql.bind_variable( p_insert_adj_c,
4449: dbms_sql.bind_variable( p_insert_adj_c,
4450: 'subsequent_trx_id',
4451: p_select_rec.subsequent_trx_id );
4452:
4453: dbms_sql.bind_variable( p_insert_adj_c,
4454: 'post_to_gl_flag',
4455: p_select_rec.post_to_gl_flag );
4456:
4457: dbms_sql.bind_variable( p_insert_adj_c,
4453: dbms_sql.bind_variable( p_insert_adj_c,
4454: 'post_to_gl_flag',
4455: p_select_rec.post_to_gl_flag );
4456:
4457: dbms_sql.bind_variable( p_insert_adj_c,
4458: 'adj_amount',
4459: p_adj_amount_t( i ) );
4460:
4461: dbms_sql.bind_variable( p_insert_adj_c,
4457: dbms_sql.bind_variable( p_insert_adj_c,
4458: 'adj_amount',
4459: p_adj_amount_t( i ) );
4460:
4461: dbms_sql.bind_variable( p_insert_adj_c,
4462: 'acctd_adj_amount',
4463: p_acctd_adj_amount_t( i ) );
4464:
4465: /* VAT changes */
4466: SELECT ar_adjustments_s.nextval
4467: INTO l_adjustment_id
4468: FROM dual;
4469:
4470: dbms_sql.bind_variable( p_insert_adj_c,
4471: 'adjustment_id',
4472: l_adjustment_id );
4473:
4474: -- 1483656 - allocating tax and freight against commitments
4471: 'adjustment_id',
4472: l_adjustment_id );
4473:
4474: -- 1483656 - allocating tax and freight against commitments
4475: dbms_sql.bind_variable (p_insert_adj_c,
4476: 'tax_adj_amount',
4477: p_tax_adj_t(i) );
4478:
4479: dbms_sql.bind_variable (p_insert_adj_c,
4475: dbms_sql.bind_variable (p_insert_adj_c,
4476: 'tax_adj_amount',
4477: p_tax_adj_t(i) );
4478:
4479: dbms_sql.bind_variable (p_insert_adj_c,
4480: 'frt_adj_amount',
4481: p_frt_adj_t(i) );
4482:
4483: dbms_sql.bind_variable (p_insert_adj_c,
4479: dbms_sql.bind_variable (p_insert_adj_c,
4480: 'frt_adj_amount',
4481: p_frt_adj_t(i) );
4482:
4483: dbms_sql.bind_variable (p_insert_adj_c,
4484: 'line_adj_amount',
4485: p_line_adj_t(i) );
4486:
4487: dbms_sql.bind_variable (p_insert_adj_c,
4483: dbms_sql.bind_variable (p_insert_adj_c,
4484: 'line_adj_amount',
4485: p_line_adj_t(i) );
4486:
4487: dbms_sql.bind_variable (p_insert_adj_c,
4488: 'adjust_type',
4489: p_select_rec.adjustment_type);
4490:
4491: --begin anuj
4488: 'adjust_type',
4489: p_select_rec.adjustment_type);
4490:
4491: --begin anuj
4492: dbms_sql.bind_variable (p_insert_adj_c,
4493: 'org_id',
4494: arp_standard.sysparm.org_id /* SSA changes anuj */);
4495: --end anuj
4496:
4505: -- Execute
4506: -------------------------------------------------------------
4507: BEGIN
4508: debug( ' Inserting adjustments', MSG_LEVEL_DEBUG );
4509: l_ignore := dbms_sql.execute( p_insert_adj_c );
4510: debug( to_char(l_ignore) || ' row(s) inserted',
4511: MSG_LEVEL_DEBUG );
4512:
4513: /*-------------------------------------------+
4538: -------------------------------------------------------------
4539: BEGIN
4540: debug( ' Binding update_ps_c', MSG_LEVEL_DEBUG );
4541:
4542: dbms_sql.bind_variable( p_update_ps_c,
4543: 'user_id',
4544: p_profile_info.user_id );
4545:
4546: dbms_sql.bind_variable( p_update_ps_c,
4542: dbms_sql.bind_variable( p_update_ps_c,
4543: 'user_id',
4544: p_profile_info.user_id );
4545:
4546: dbms_sql.bind_variable( p_update_ps_c,
4547: 'login_id',
4548: p_profile_info.conc_login_id );
4549:
4550: dbms_sql.bind_variable( p_update_ps_c,
4546: dbms_sql.bind_variable( p_update_ps_c,
4547: 'login_id',
4548: p_profile_info.conc_login_id );
4549:
4550: dbms_sql.bind_variable( p_update_ps_c,
4551: 'amount_due_remaining',
4552: p_ps_amount_due_rem_t( i ) );
4553:
4554: dbms_sql.bind_variable( p_update_ps_c,
4550: dbms_sql.bind_variable( p_update_ps_c,
4551: 'amount_due_remaining',
4552: p_ps_amount_due_rem_t( i ) );
4553:
4554: dbms_sql.bind_variable( p_update_ps_c,
4555: 'gl_date_closed',
4556: p_select_rec.gl_date_closed );
4557:
4558: dbms_sql.bind_variable( p_update_ps_c,
4554: dbms_sql.bind_variable( p_update_ps_c,
4555: 'gl_date_closed',
4556: p_select_rec.gl_date_closed );
4557:
4558: dbms_sql.bind_variable( p_update_ps_c,
4559: 'actual_date_closed',
4560: p_select_rec.actual_date_closed );
4561:
4562: dbms_sql.bind_variable( p_update_ps_c,
4558: dbms_sql.bind_variable( p_update_ps_c,
4559: 'actual_date_closed',
4560: p_select_rec.actual_date_closed );
4561:
4562: dbms_sql.bind_variable( p_update_ps_c,
4563: 'amount_line_items_remaining',
4564: p_ps_line_rem_t( i ) );
4565:
4566: dbms_sql.bind_variable( p_update_ps_c,
4562: dbms_sql.bind_variable( p_update_ps_c,
4563: 'amount_line_items_remaining',
4564: p_ps_line_rem_t( i ) );
4565:
4566: dbms_sql.bind_variable( p_update_ps_c,
4567: 'amount_adjusted',
4568: p_ps_amount_adjusted_t( i ) );
4569:
4570: dbms_sql.bind_variable( p_update_ps_c,
4566: dbms_sql.bind_variable( p_update_ps_c,
4567: 'amount_adjusted',
4568: p_ps_amount_adjusted_t( i ) );
4569:
4570: dbms_sql.bind_variable( p_update_ps_c,
4571: 'acctd_amount_due_remaining',
4572: p_ps_acctd_amt_due_rem_t( i ) );
4573:
4574: dbms_sql.bind_variable( p_update_ps_c,
4570: dbms_sql.bind_variable( p_update_ps_c,
4571: 'acctd_amount_due_remaining',
4572: p_ps_acctd_amt_due_rem_t( i ) );
4573:
4574: dbms_sql.bind_variable( p_update_ps_c,
4575: 'payment_schedule_id',
4576: p_ps_id_t( i ) );
4577:
4578: /* 1483656 - Commitments Project */
4575: 'payment_schedule_id',
4576: p_ps_id_t( i ) );
4577:
4578: /* 1483656 - Commitments Project */
4579: dbms_sql.bind_variable( p_update_ps_c,
4580: 'tax_remaining',
4581: p_ps_tax_rem_t( i ) );
4582:
4583: dbms_sql.bind_variable( p_update_ps_c,
4579: dbms_sql.bind_variable( p_update_ps_c,
4580: 'tax_remaining',
4581: p_ps_tax_rem_t( i ) );
4582:
4583: dbms_sql.bind_variable( p_update_ps_c,
4584: 'freight_remaining',
4585: p_ps_freight_rem_t( i ) );
4586:
4587:
4596: -- Execute
4597: -------------------------------------------------------------
4598: BEGIN
4599: debug( ' Updating invoice payment schedules', MSG_LEVEL_DEBUG );
4600: l_ignore := dbms_sql.execute( p_update_ps_c );
4601: debug( to_char(l_ignore) || ' row(s) updated',
4602: MSG_LEVEL_DEBUG );
4603:
4604: /*-------------------------------------------+
4824: --
4825: clear_all_tables;
4826: --
4827:
4828: IF( NOT( dbms_sql.is_open( ups_select_c ) AND
4829: dbms_sql.is_open( ups_insert_adj_c ) AND
4830: dbms_sql.is_open( ups_update_ps_c ) )) THEN
4831:
4832: build_ups_sql(
4825: clear_all_tables;
4826: --
4827:
4828: IF( NOT( dbms_sql.is_open( ups_select_c ) AND
4829: dbms_sql.is_open( ups_insert_adj_c ) AND
4830: dbms_sql.is_open( ups_update_ps_c ) )) THEN
4831:
4832: build_ups_sql(
4833: system_info,
4826: --
4827:
4828: IF( NOT( dbms_sql.is_open( ups_select_c ) AND
4829: dbms_sql.is_open( ups_insert_adj_c ) AND
4830: dbms_sql.is_open( ups_update_ps_c ) )) THEN
4831:
4832: build_ups_sql(
4833: system_info,
4834: profile_info,
4842:
4843: ---------------------------------------------------------------
4844: -- Bind variables
4845: ---------------------------------------------------------------
4846: dbms_sql.bind_variable( ups_select_c,
4847: 'customer_trx_id',
4848: p_customer_trx_id );
4849:
4850: /* bug 3431804 - bind dates for latecoming deposits */
4847: 'customer_trx_id',
4848: p_customer_trx_id );
4849:
4850: /* bug 3431804 - bind dates for latecoming deposits */
4851: dbms_sql.bind_variable( ups_select_c,
4852: 'gl_date',
4853: p_gl_date);
4854:
4855: dbms_sql.bind_variable( ups_select_c,
4851: dbms_sql.bind_variable( ups_select_c,
4852: 'gl_date',
4853: p_gl_date);
4854:
4855: dbms_sql.bind_variable( ups_select_c,
4856: 'apply_date',
4857: p_adj_date);
4858: ---------------------------------------------------------------
4859: -- Execute sql
4860: ---------------------------------------------------------------
4861: debug( ' Executing select sql', MSG_LEVEL_DEBUG );
4862:
4863: BEGIN
4864: l_ignore := dbms_sql.execute( ups_select_c );
4865:
4866: EXCEPTION
4867: WHEN OTHERS THEN
4868: debug( 'EXCEPTION: Error executing select sql',
4876: ---------------------------------------------------------------
4877: BEGIN
4878: LOOP
4879:
4880: IF dbms_sql.fetch_rows( ups_select_c ) > 0 THEN
4881:
4882: debug(' Fetched a row', MSG_LEVEL_DEBUG );
4883:
4884: -----------------------------------------------
4883:
4884: -----------------------------------------------
4885: -- Load row into record
4886: -----------------------------------------------
4887: dbms_sql.column_value( ups_select_c, 24, l_customer_trx_id );
4888: dbms_sql.column_value( ups_select_c, 5, l_adjusted_trx_id );
4889:
4890: -----------------------------------------------
4891: -- Check if adjusted trx or invoice changed
4884: -----------------------------------------------
4885: -- Load row into record
4886: -----------------------------------------------
4887: dbms_sql.column_value( ups_select_c, 24, l_customer_trx_id );
4888: dbms_sql.column_value( ups_select_c, 5, l_adjusted_trx_id );
4889:
4890: -----------------------------------------------
4891: -- Check if adjusted trx or invoice changed
4892: -----------------------------------------------
5411: BEGIN
5412: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
5413:
5414: debug( ' Parsing insert_adj_c', MSG_LEVEL_DEBUG );
5415: p_insert_adj_c := dbms_sql.open_cursor;
5416: dbms_sql.parse( p_insert_adj_c, l_insert_adj_sql,
5417: dbms_sql.v7 );
5418:
5419: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
5412: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
5413:
5414: debug( ' Parsing insert_adj_c', MSG_LEVEL_DEBUG );
5415: p_insert_adj_c := dbms_sql.open_cursor;
5416: dbms_sql.parse( p_insert_adj_c, l_insert_adj_sql,
5417: dbms_sql.v7 );
5418:
5419: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
5420: p_update_ps_c := dbms_sql.open_cursor;
5413:
5414: debug( ' Parsing insert_adj_c', MSG_LEVEL_DEBUG );
5415: p_insert_adj_c := dbms_sql.open_cursor;
5416: dbms_sql.parse( p_insert_adj_c, l_insert_adj_sql,
5417: dbms_sql.v7 );
5418:
5419: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
5420: p_update_ps_c := dbms_sql.open_cursor;
5421: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
5416: dbms_sql.parse( p_insert_adj_c, l_insert_adj_sql,
5417: dbms_sql.v7 );
5418:
5419: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
5420: p_update_ps_c := dbms_sql.open_cursor;
5421: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
5422: dbms_sql.v7 );
5423:
5424: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
5417: dbms_sql.v7 );
5418:
5419: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
5420: p_update_ps_c := dbms_sql.open_cursor;
5421: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
5422: dbms_sql.v7 );
5423:
5424: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
5425: p_select_c := dbms_sql.open_cursor;
5418:
5419: debug( ' Parsing update_ps_c', MSG_LEVEL_DEBUG );
5420: p_update_ps_c := dbms_sql.open_cursor;
5421: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
5422: dbms_sql.v7 );
5423:
5424: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
5425: p_select_c := dbms_sql.open_cursor;
5426: dbms_sql.parse( p_select_c, l_select_sql,
5421: dbms_sql.parse( p_update_ps_c, l_update_ps_sql,
5422: dbms_sql.v7 );
5423:
5424: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
5425: p_select_c := dbms_sql.open_cursor;
5426: dbms_sql.parse( p_select_c, l_select_sql,
5427: dbms_sql.v7 );
5428:
5429: EXCEPTION
5422: dbms_sql.v7 );
5423:
5424: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
5425: p_select_c := dbms_sql.open_cursor;
5426: dbms_sql.parse( p_select_c, l_select_sql,
5427: dbms_sql.v7 );
5428:
5429: EXCEPTION
5430: WHEN OTHERS THEN
5423:
5424: debug( ' Parsing select_c', MSG_LEVEL_DEBUG );
5425: p_select_c := dbms_sql.open_cursor;
5426: dbms_sql.parse( p_select_c, l_select_sql,
5427: dbms_sql.v7 );
5428:
5429: EXCEPTION
5430: WHEN OTHERS THEN
5431: debug( 'EXCEPTION: Error parsing stmts', MSG_LEVEL_BASIC );
5452: BEGIN
5453:
5454: print_fcn_label2( 'arp_maintain_ps2.define_iad_select_columns()+' );
5455:
5456: dbms_sql.define_column( p_select_c, 1, p_select_rec.set_of_books_id );
5457: dbms_sql.define_column( p_select_c, 2, p_select_rec.trx_date );
5458: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
5459: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
5460: dbms_sql.define_column( p_select_c, 5, p_select_rec.adjusted_trx_id );
5453:
5454: print_fcn_label2( 'arp_maintain_ps2.define_iad_select_columns()+' );
5455:
5456: dbms_sql.define_column( p_select_c, 1, p_select_rec.set_of_books_id );
5457: dbms_sql.define_column( p_select_c, 2, p_select_rec.trx_date );
5458: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
5459: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
5460: dbms_sql.define_column( p_select_c, 5, p_select_rec.adjusted_trx_id );
5461: dbms_sql.define_column( p_select_c, 6, p_select_rec.payment_schedule_id );
5454: print_fcn_label2( 'arp_maintain_ps2.define_iad_select_columns()+' );
5455:
5456: dbms_sql.define_column( p_select_c, 1, p_select_rec.set_of_books_id );
5457: dbms_sql.define_column( p_select_c, 2, p_select_rec.trx_date );
5458: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
5459: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
5460: dbms_sql.define_column( p_select_c, 5, p_select_rec.adjusted_trx_id );
5461: dbms_sql.define_column( p_select_c, 6, p_select_rec.payment_schedule_id );
5462: dbms_sql.define_column( p_select_c, 7, p_select_rec.customer_trx_id );
5455:
5456: dbms_sql.define_column( p_select_c, 1, p_select_rec.set_of_books_id );
5457: dbms_sql.define_column( p_select_c, 2, p_select_rec.trx_date );
5458: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
5459: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
5460: dbms_sql.define_column( p_select_c, 5, p_select_rec.adjusted_trx_id );
5461: dbms_sql.define_column( p_select_c, 6, p_select_rec.payment_schedule_id );
5462: dbms_sql.define_column( p_select_c, 7, p_select_rec.customer_trx_id );
5463: dbms_sql.define_column( p_select_c, 8,
5456: dbms_sql.define_column( p_select_c, 1, p_select_rec.set_of_books_id );
5457: dbms_sql.define_column( p_select_c, 2, p_select_rec.trx_date );
5458: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
5459: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
5460: dbms_sql.define_column( p_select_c, 5, p_select_rec.adjusted_trx_id );
5461: dbms_sql.define_column( p_select_c, 6, p_select_rec.payment_schedule_id );
5462: dbms_sql.define_column( p_select_c, 7, p_select_rec.customer_trx_id );
5463: dbms_sql.define_column( p_select_c, 8,
5464: p_select_rec.post_to_gl_flag, 1 );
5457: dbms_sql.define_column( p_select_c, 2, p_select_rec.trx_date );
5458: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
5459: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
5460: dbms_sql.define_column( p_select_c, 5, p_select_rec.adjusted_trx_id );
5461: dbms_sql.define_column( p_select_c, 6, p_select_rec.payment_schedule_id );
5462: dbms_sql.define_column( p_select_c, 7, p_select_rec.customer_trx_id );
5463: dbms_sql.define_column( p_select_c, 8,
5464: p_select_rec.post_to_gl_flag, 1 );
5465: dbms_sql.define_column( p_select_c, 9, p_select_rec.actual_date_closed );
5458: dbms_sql.define_column( p_select_c, 3, p_select_rec.gl_date );
5459: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
5460: dbms_sql.define_column( p_select_c, 5, p_select_rec.adjusted_trx_id );
5461: dbms_sql.define_column( p_select_c, 6, p_select_rec.payment_schedule_id );
5462: dbms_sql.define_column( p_select_c, 7, p_select_rec.customer_trx_id );
5463: dbms_sql.define_column( p_select_c, 8,
5464: p_select_rec.post_to_gl_flag, 1 );
5465: dbms_sql.define_column( p_select_c, 9, p_select_rec.actual_date_closed );
5466: dbms_sql.define_column( p_select_c, 10, p_select_rec.gl_date_closed );
5459: dbms_sql.define_column( p_select_c, 4, p_select_rec.code_combination_id );
5460: dbms_sql.define_column( p_select_c, 5, p_select_rec.adjusted_trx_id );
5461: dbms_sql.define_column( p_select_c, 6, p_select_rec.payment_schedule_id );
5462: dbms_sql.define_column( p_select_c, 7, p_select_rec.customer_trx_id );
5463: dbms_sql.define_column( p_select_c, 8,
5464: p_select_rec.post_to_gl_flag, 1 );
5465: dbms_sql.define_column( p_select_c, 9, p_select_rec.actual_date_closed );
5466: dbms_sql.define_column( p_select_c, 10, p_select_rec.gl_date_closed );
5467: dbms_sql.define_column( p_select_c, 11, p_select_rec.min_acc_unit );
5461: dbms_sql.define_column( p_select_c, 6, p_select_rec.payment_schedule_id );
5462: dbms_sql.define_column( p_select_c, 7, p_select_rec.customer_trx_id );
5463: dbms_sql.define_column( p_select_c, 8,
5464: p_select_rec.post_to_gl_flag, 1 );
5465: dbms_sql.define_column( p_select_c, 9, p_select_rec.actual_date_closed );
5466: dbms_sql.define_column( p_select_c, 10, p_select_rec.gl_date_closed );
5467: dbms_sql.define_column( p_select_c, 11, p_select_rec.min_acc_unit );
5468: dbms_sql.define_column( p_select_c, 12, p_select_rec.precision );
5469: dbms_sql.define_column( p_select_c, 13,
5462: dbms_sql.define_column( p_select_c, 7, p_select_rec.customer_trx_id );
5463: dbms_sql.define_column( p_select_c, 8,
5464: p_select_rec.post_to_gl_flag, 1 );
5465: dbms_sql.define_column( p_select_c, 9, p_select_rec.actual_date_closed );
5466: dbms_sql.define_column( p_select_c, 10, p_select_rec.gl_date_closed );
5467: dbms_sql.define_column( p_select_c, 11, p_select_rec.min_acc_unit );
5468: dbms_sql.define_column( p_select_c, 12, p_select_rec.precision );
5469: dbms_sql.define_column( p_select_c, 13,
5470: p_select_rec.total_cm_line_amount );
5463: dbms_sql.define_column( p_select_c, 8,
5464: p_select_rec.post_to_gl_flag, 1 );
5465: dbms_sql.define_column( p_select_c, 9, p_select_rec.actual_date_closed );
5466: dbms_sql.define_column( p_select_c, 10, p_select_rec.gl_date_closed );
5467: dbms_sql.define_column( p_select_c, 11, p_select_rec.min_acc_unit );
5468: dbms_sql.define_column( p_select_c, 12, p_select_rec.precision );
5469: dbms_sql.define_column( p_select_c, 13,
5470: p_select_rec.total_cm_line_amount );
5471: dbms_sql.define_column( p_select_c, 14,
5464: p_select_rec.post_to_gl_flag, 1 );
5465: dbms_sql.define_column( p_select_c, 9, p_select_rec.actual_date_closed );
5466: dbms_sql.define_column( p_select_c, 10, p_select_rec.gl_date_closed );
5467: dbms_sql.define_column( p_select_c, 11, p_select_rec.min_acc_unit );
5468: dbms_sql.define_column( p_select_c, 12, p_select_rec.precision );
5469: dbms_sql.define_column( p_select_c, 13,
5470: p_select_rec.total_cm_line_amount );
5471: dbms_sql.define_column( p_select_c, 14,
5472: p_select_rec.total_inv_adj_amount );
5465: dbms_sql.define_column( p_select_c, 9, p_select_rec.actual_date_closed );
5466: dbms_sql.define_column( p_select_c, 10, p_select_rec.gl_date_closed );
5467: dbms_sql.define_column( p_select_c, 11, p_select_rec.min_acc_unit );
5468: dbms_sql.define_column( p_select_c, 12, p_select_rec.precision );
5469: dbms_sql.define_column( p_select_c, 13,
5470: p_select_rec.total_cm_line_amount );
5471: dbms_sql.define_column( p_select_c, 14,
5472: p_select_rec.total_inv_adj_amount );
5473: dbms_sql.define_column( p_select_c, 15, p_select_rec.commitment_code );
5467: dbms_sql.define_column( p_select_c, 11, p_select_rec.min_acc_unit );
5468: dbms_sql.define_column( p_select_c, 12, p_select_rec.precision );
5469: dbms_sql.define_column( p_select_c, 13,
5470: p_select_rec.total_cm_line_amount );
5471: dbms_sql.define_column( p_select_c, 14,
5472: p_select_rec.total_inv_adj_amount );
5473: dbms_sql.define_column( p_select_c, 15, p_select_rec.commitment_code );
5474: dbms_sql.define_column( p_select_c, 16, p_select_rec.invoice_trx_id );
5475: dbms_sql.define_column( p_select_c, 17, p_select_rec.ps_line_remaining );
5469: dbms_sql.define_column( p_select_c, 13,
5470: p_select_rec.total_cm_line_amount );
5471: dbms_sql.define_column( p_select_c, 14,
5472: p_select_rec.total_inv_adj_amount );
5473: dbms_sql.define_column( p_select_c, 15, p_select_rec.commitment_code );
5474: dbms_sql.define_column( p_select_c, 16, p_select_rec.invoice_trx_id );
5475: dbms_sql.define_column( p_select_c, 17, p_select_rec.ps_line_remaining );
5476: dbms_sql.define_column( p_select_c, 18,
5477: p_select_rec.ps_amount_due_remaining );
5470: p_select_rec.total_cm_line_amount );
5471: dbms_sql.define_column( p_select_c, 14,
5472: p_select_rec.total_inv_adj_amount );
5473: dbms_sql.define_column( p_select_c, 15, p_select_rec.commitment_code );
5474: dbms_sql.define_column( p_select_c, 16, p_select_rec.invoice_trx_id );
5475: dbms_sql.define_column( p_select_c, 17, p_select_rec.ps_line_remaining );
5476: dbms_sql.define_column( p_select_c, 18,
5477: p_select_rec.ps_amount_due_remaining );
5478: dbms_sql.define_column( p_select_c, 19,
5471: dbms_sql.define_column( p_select_c, 14,
5472: p_select_rec.total_inv_adj_amount );
5473: dbms_sql.define_column( p_select_c, 15, p_select_rec.commitment_code );
5474: dbms_sql.define_column( p_select_c, 16, p_select_rec.invoice_trx_id );
5475: dbms_sql.define_column( p_select_c, 17, p_select_rec.ps_line_remaining );
5476: dbms_sql.define_column( p_select_c, 18,
5477: p_select_rec.ps_amount_due_remaining );
5478: dbms_sql.define_column( p_select_c, 19,
5479: p_select_rec.ps_acctd_amt_due_rem );
5472: p_select_rec.total_inv_adj_amount );
5473: dbms_sql.define_column( p_select_c, 15, p_select_rec.commitment_code );
5474: dbms_sql.define_column( p_select_c, 16, p_select_rec.invoice_trx_id );
5475: dbms_sql.define_column( p_select_c, 17, p_select_rec.ps_line_remaining );
5476: dbms_sql.define_column( p_select_c, 18,
5477: p_select_rec.ps_amount_due_remaining );
5478: dbms_sql.define_column( p_select_c, 19,
5479: p_select_rec.ps_acctd_amt_due_rem );
5480: dbms_sql.define_column( p_select_c, 20,
5474: dbms_sql.define_column( p_select_c, 16, p_select_rec.invoice_trx_id );
5475: dbms_sql.define_column( p_select_c, 17, p_select_rec.ps_line_remaining );
5476: dbms_sql.define_column( p_select_c, 18,
5477: p_select_rec.ps_amount_due_remaining );
5478: dbms_sql.define_column( p_select_c, 19,
5479: p_select_rec.ps_acctd_amt_due_rem );
5480: dbms_sql.define_column( p_select_c, 20,
5481: p_select_rec.ps_amount_adjusted );
5482: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
5476: dbms_sql.define_column( p_select_c, 18,
5477: p_select_rec.ps_amount_due_remaining );
5478: dbms_sql.define_column( p_select_c, 19,
5479: p_select_rec.ps_acctd_amt_due_rem );
5480: dbms_sql.define_column( p_select_c, 20,
5481: p_select_rec.ps_amount_adjusted );
5482: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
5483: dbms_sql.define_column( p_select_c, 22, p_select_rec.ps_min_acc_unit );
5484: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
5478: dbms_sql.define_column( p_select_c, 19,
5479: p_select_rec.ps_acctd_amt_due_rem );
5480: dbms_sql.define_column( p_select_c, 20,
5481: p_select_rec.ps_amount_adjusted );
5482: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
5483: dbms_sql.define_column( p_select_c, 22, p_select_rec.ps_min_acc_unit );
5484: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
5485: dbms_sql.define_column( p_select_c, 24,
5486: p_select_rec.total_inv_line_remaining );
5479: p_select_rec.ps_acctd_amt_due_rem );
5480: dbms_sql.define_column( p_select_c, 20,
5481: p_select_rec.ps_amount_adjusted );
5482: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
5483: dbms_sql.define_column( p_select_c, 22, p_select_rec.ps_min_acc_unit );
5484: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
5485: dbms_sql.define_column( p_select_c, 24,
5486: p_select_rec.total_inv_line_remaining );
5487: dbms_sql.define_column( p_select_c, 25, p_select_rec.ps_line_original );
5480: dbms_sql.define_column( p_select_c, 20,
5481: p_select_rec.ps_amount_adjusted );
5482: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
5483: dbms_sql.define_column( p_select_c, 22, p_select_rec.ps_min_acc_unit );
5484: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
5485: dbms_sql.define_column( p_select_c, 24,
5486: p_select_rec.total_inv_line_remaining );
5487: dbms_sql.define_column( p_select_c, 25, p_select_rec.ps_line_original );
5488: dbms_sql.define_column( p_select_c, 26,
5481: p_select_rec.ps_amount_adjusted );
5482: dbms_sql.define_column( p_select_c, 21, p_select_rec.ps_precision );
5483: dbms_sql.define_column( p_select_c, 22, p_select_rec.ps_min_acc_unit );
5484: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
5485: dbms_sql.define_column( p_select_c, 24,
5486: p_select_rec.total_inv_line_remaining );
5487: dbms_sql.define_column( p_select_c, 25, p_select_rec.ps_line_original );
5488: dbms_sql.define_column( p_select_c, 26,
5489: p_select_rec.ps_currency_code, 15 );
5483: dbms_sql.define_column( p_select_c, 22, p_select_rec.ps_min_acc_unit );
5484: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
5485: dbms_sql.define_column( p_select_c, 24,
5486: p_select_rec.total_inv_line_remaining );
5487: dbms_sql.define_column( p_select_c, 25, p_select_rec.ps_line_original );
5488: dbms_sql.define_column( p_select_c, 26,
5489: p_select_rec.ps_currency_code, 15 );
5490: dbms_sql.define_column( p_select_c, 27, p_select_rec.allocate_tax_freight, 1);
5491: dbms_sql.define_column( p_select_c, 28, p_select_rec.adjustment_type, 8);
5484: dbms_sql.define_column( p_select_c, 23, p_select_rec.ps_exchange_rate );
5485: dbms_sql.define_column( p_select_c, 24,
5486: p_select_rec.total_inv_line_remaining );
5487: dbms_sql.define_column( p_select_c, 25, p_select_rec.ps_line_original );
5488: dbms_sql.define_column( p_select_c, 26,
5489: p_select_rec.ps_currency_code, 15 );
5490: dbms_sql.define_column( p_select_c, 27, p_select_rec.allocate_tax_freight, 1);
5491: dbms_sql.define_column( p_select_c, 28, p_select_rec.adjustment_type, 8);
5492: dbms_sql.define_column( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5486: p_select_rec.total_inv_line_remaining );
5487: dbms_sql.define_column( p_select_c, 25, p_select_rec.ps_line_original );
5488: dbms_sql.define_column( p_select_c, 26,
5489: p_select_rec.ps_currency_code, 15 );
5490: dbms_sql.define_column( p_select_c, 27, p_select_rec.allocate_tax_freight, 1);
5491: dbms_sql.define_column( p_select_c, 28, p_select_rec.adjustment_type, 8);
5492: dbms_sql.define_column( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5493: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5494: dbms_sql.define_column( p_select_c, 31, p_select_rec.inv_line_adj);
5487: dbms_sql.define_column( p_select_c, 25, p_select_rec.ps_line_original );
5488: dbms_sql.define_column( p_select_c, 26,
5489: p_select_rec.ps_currency_code, 15 );
5490: dbms_sql.define_column( p_select_c, 27, p_select_rec.allocate_tax_freight, 1);
5491: dbms_sql.define_column( p_select_c, 28, p_select_rec.adjustment_type, 8);
5492: dbms_sql.define_column( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5493: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5494: dbms_sql.define_column( p_select_c, 31, p_select_rec.inv_line_adj);
5495: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_tax_adj);
5488: dbms_sql.define_column( p_select_c, 26,
5489: p_select_rec.ps_currency_code, 15 );
5490: dbms_sql.define_column( p_select_c, 27, p_select_rec.allocate_tax_freight, 1);
5491: dbms_sql.define_column( p_select_c, 28, p_select_rec.adjustment_type, 8);
5492: dbms_sql.define_column( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5493: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5494: dbms_sql.define_column( p_select_c, 31, p_select_rec.inv_line_adj);
5495: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_tax_adj);
5496: dbms_sql.define_column( p_select_c, 33, p_select_rec.inv_frt_adj);
5489: p_select_rec.ps_currency_code, 15 );
5490: dbms_sql.define_column( p_select_c, 27, p_select_rec.allocate_tax_freight, 1);
5491: dbms_sql.define_column( p_select_c, 28, p_select_rec.adjustment_type, 8);
5492: dbms_sql.define_column( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5493: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5494: dbms_sql.define_column( p_select_c, 31, p_select_rec.inv_line_adj);
5495: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_tax_adj);
5496: dbms_sql.define_column( p_select_c, 33, p_select_rec.inv_frt_adj);
5497: dbms_sql.define_column( p_select_c, 34, p_select_rec.ps_tax_remaining);
5490: dbms_sql.define_column( p_select_c, 27, p_select_rec.allocate_tax_freight, 1);
5491: dbms_sql.define_column( p_select_c, 28, p_select_rec.adjustment_type, 8);
5492: dbms_sql.define_column( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5493: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5494: dbms_sql.define_column( p_select_c, 31, p_select_rec.inv_line_adj);
5495: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_tax_adj);
5496: dbms_sql.define_column( p_select_c, 33, p_select_rec.inv_frt_adj);
5497: dbms_sql.define_column( p_select_c, 34, p_select_rec.ps_tax_remaining);
5498: dbms_sql.define_column( p_select_c, 35, p_select_rec.ps_freight_remaining);
5491: dbms_sql.define_column( p_select_c, 28, p_select_rec.adjustment_type, 8);
5492: dbms_sql.define_column( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5493: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5494: dbms_sql.define_column( p_select_c, 31, p_select_rec.inv_line_adj);
5495: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_tax_adj);
5496: dbms_sql.define_column( p_select_c, 33, p_select_rec.inv_frt_adj);
5497: dbms_sql.define_column( p_select_c, 34, p_select_rec.ps_tax_remaining);
5498: dbms_sql.define_column( p_select_c, 35, p_select_rec.ps_freight_remaining);
5499: dbms_sql.define_column( p_select_c, 36, p_select_rec.ps_tax_original);
5492: dbms_sql.define_column( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5493: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5494: dbms_sql.define_column( p_select_c, 31, p_select_rec.inv_line_adj);
5495: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_tax_adj);
5496: dbms_sql.define_column( p_select_c, 33, p_select_rec.inv_frt_adj);
5497: dbms_sql.define_column( p_select_c, 34, p_select_rec.ps_tax_remaining);
5498: dbms_sql.define_column( p_select_c, 35, p_select_rec.ps_freight_remaining);
5499: dbms_sql.define_column( p_select_c, 36, p_select_rec.ps_tax_original);
5500: dbms_sql.define_column( p_select_c, 37, p_select_rec.ps_freight_remaining);
5493: dbms_sql.define_column( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5494: dbms_sql.define_column( p_select_c, 31, p_select_rec.inv_line_adj);
5495: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_tax_adj);
5496: dbms_sql.define_column( p_select_c, 33, p_select_rec.inv_frt_adj);
5497: dbms_sql.define_column( p_select_c, 34, p_select_rec.ps_tax_remaining);
5498: dbms_sql.define_column( p_select_c, 35, p_select_rec.ps_freight_remaining);
5499: dbms_sql.define_column( p_select_c, 36, p_select_rec.ps_tax_original);
5500: dbms_sql.define_column( p_select_c, 37, p_select_rec.ps_freight_remaining);
5501:
5494: dbms_sql.define_column( p_select_c, 31, p_select_rec.inv_line_adj);
5495: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_tax_adj);
5496: dbms_sql.define_column( p_select_c, 33, p_select_rec.inv_frt_adj);
5497: dbms_sql.define_column( p_select_c, 34, p_select_rec.ps_tax_remaining);
5498: dbms_sql.define_column( p_select_c, 35, p_select_rec.ps_freight_remaining);
5499: dbms_sql.define_column( p_select_c, 36, p_select_rec.ps_tax_original);
5500: dbms_sql.define_column( p_select_c, 37, p_select_rec.ps_freight_remaining);
5501:
5502: print_fcn_label2( 'arp_maintain_ps2.define_iad_select_columns()-' );
5495: dbms_sql.define_column( p_select_c, 32, p_select_rec.inv_tax_adj);
5496: dbms_sql.define_column( p_select_c, 33, p_select_rec.inv_frt_adj);
5497: dbms_sql.define_column( p_select_c, 34, p_select_rec.ps_tax_remaining);
5498: dbms_sql.define_column( p_select_c, 35, p_select_rec.ps_freight_remaining);
5499: dbms_sql.define_column( p_select_c, 36, p_select_rec.ps_tax_original);
5500: dbms_sql.define_column( p_select_c, 37, p_select_rec.ps_freight_remaining);
5501:
5502: print_fcn_label2( 'arp_maintain_ps2.define_iad_select_columns()-' );
5503:
5496: dbms_sql.define_column( p_select_c, 33, p_select_rec.inv_frt_adj);
5497: dbms_sql.define_column( p_select_c, 34, p_select_rec.ps_tax_remaining);
5498: dbms_sql.define_column( p_select_c, 35, p_select_rec.ps_freight_remaining);
5499: dbms_sql.define_column( p_select_c, 36, p_select_rec.ps_tax_original);
5500: dbms_sql.define_column( p_select_c, 37, p_select_rec.ps_freight_remaining);
5501:
5502: print_fcn_label2( 'arp_maintain_ps2.define_iad_select_columns()-' );
5503:
5504: EXCEPTION
5515: /* Bug 460927 - Changed IN to IN OUT in the above line - Oracle 8 */
5516: BEGIN
5517: print_fcn_label2( 'arp_maintain_ps2.get_iad_column_values()+' );
5518:
5519: dbms_sql.column_value( p_select_c, 1, p_select_rec.set_of_books_id );
5520: dbms_sql.column_value( p_select_c, 2, p_select_rec.trx_date );
5521: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
5522: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
5523: dbms_sql.column_value( p_select_c, 5, p_select_rec.adjusted_trx_id );
5516: BEGIN
5517: print_fcn_label2( 'arp_maintain_ps2.get_iad_column_values()+' );
5518:
5519: dbms_sql.column_value( p_select_c, 1, p_select_rec.set_of_books_id );
5520: dbms_sql.column_value( p_select_c, 2, p_select_rec.trx_date );
5521: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
5522: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
5523: dbms_sql.column_value( p_select_c, 5, p_select_rec.adjusted_trx_id );
5524: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
5517: print_fcn_label2( 'arp_maintain_ps2.get_iad_column_values()+' );
5518:
5519: dbms_sql.column_value( p_select_c, 1, p_select_rec.set_of_books_id );
5520: dbms_sql.column_value( p_select_c, 2, p_select_rec.trx_date );
5521: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
5522: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
5523: dbms_sql.column_value( p_select_c, 5, p_select_rec.adjusted_trx_id );
5524: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
5525: dbms_sql.column_value( p_select_c, 7, p_select_rec.customer_trx_id );
5518:
5519: dbms_sql.column_value( p_select_c, 1, p_select_rec.set_of_books_id );
5520: dbms_sql.column_value( p_select_c, 2, p_select_rec.trx_date );
5521: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
5522: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
5523: dbms_sql.column_value( p_select_c, 5, p_select_rec.adjusted_trx_id );
5524: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
5525: dbms_sql.column_value( p_select_c, 7, p_select_rec.customer_trx_id );
5526: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
5519: dbms_sql.column_value( p_select_c, 1, p_select_rec.set_of_books_id );
5520: dbms_sql.column_value( p_select_c, 2, p_select_rec.trx_date );
5521: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
5522: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
5523: dbms_sql.column_value( p_select_c, 5, p_select_rec.adjusted_trx_id );
5524: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
5525: dbms_sql.column_value( p_select_c, 7, p_select_rec.customer_trx_id );
5526: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
5527: dbms_sql.column_value( p_select_c, 9, p_select_rec.actual_date_closed );
5520: dbms_sql.column_value( p_select_c, 2, p_select_rec.trx_date );
5521: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
5522: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
5523: dbms_sql.column_value( p_select_c, 5, p_select_rec.adjusted_trx_id );
5524: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
5525: dbms_sql.column_value( p_select_c, 7, p_select_rec.customer_trx_id );
5526: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
5527: dbms_sql.column_value( p_select_c, 9, p_select_rec.actual_date_closed );
5528: dbms_sql.column_value( p_select_c, 10, p_select_rec.gl_date_closed );
5521: dbms_sql.column_value( p_select_c, 3, p_select_rec.gl_date );
5522: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
5523: dbms_sql.column_value( p_select_c, 5, p_select_rec.adjusted_trx_id );
5524: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
5525: dbms_sql.column_value( p_select_c, 7, p_select_rec.customer_trx_id );
5526: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
5527: dbms_sql.column_value( p_select_c, 9, p_select_rec.actual_date_closed );
5528: dbms_sql.column_value( p_select_c, 10, p_select_rec.gl_date_closed );
5529: dbms_sql.column_value( p_select_c, 11, p_select_rec.min_acc_unit );
5522: dbms_sql.column_value( p_select_c, 4, p_select_rec.code_combination_id );
5523: dbms_sql.column_value( p_select_c, 5, p_select_rec.adjusted_trx_id );
5524: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
5525: dbms_sql.column_value( p_select_c, 7, p_select_rec.customer_trx_id );
5526: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
5527: dbms_sql.column_value( p_select_c, 9, p_select_rec.actual_date_closed );
5528: dbms_sql.column_value( p_select_c, 10, p_select_rec.gl_date_closed );
5529: dbms_sql.column_value( p_select_c, 11, p_select_rec.min_acc_unit );
5530: dbms_sql.column_value( p_select_c, 12, p_select_rec.precision );
5523: dbms_sql.column_value( p_select_c, 5, p_select_rec.adjusted_trx_id );
5524: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
5525: dbms_sql.column_value( p_select_c, 7, p_select_rec.customer_trx_id );
5526: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
5527: dbms_sql.column_value( p_select_c, 9, p_select_rec.actual_date_closed );
5528: dbms_sql.column_value( p_select_c, 10, p_select_rec.gl_date_closed );
5529: dbms_sql.column_value( p_select_c, 11, p_select_rec.min_acc_unit );
5530: dbms_sql.column_value( p_select_c, 12, p_select_rec.precision );
5531: dbms_sql.column_value( p_select_c, 13, p_select_rec.total_cm_line_amount );
5524: dbms_sql.column_value( p_select_c, 6, p_select_rec.payment_schedule_id );
5525: dbms_sql.column_value( p_select_c, 7, p_select_rec.customer_trx_id );
5526: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
5527: dbms_sql.column_value( p_select_c, 9, p_select_rec.actual_date_closed );
5528: dbms_sql.column_value( p_select_c, 10, p_select_rec.gl_date_closed );
5529: dbms_sql.column_value( p_select_c, 11, p_select_rec.min_acc_unit );
5530: dbms_sql.column_value( p_select_c, 12, p_select_rec.precision );
5531: dbms_sql.column_value( p_select_c, 13, p_select_rec.total_cm_line_amount );
5532: dbms_sql.column_value( p_select_c, 14, p_select_rec.total_inv_adj_amount );
5525: dbms_sql.column_value( p_select_c, 7, p_select_rec.customer_trx_id );
5526: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
5527: dbms_sql.column_value( p_select_c, 9, p_select_rec.actual_date_closed );
5528: dbms_sql.column_value( p_select_c, 10, p_select_rec.gl_date_closed );
5529: dbms_sql.column_value( p_select_c, 11, p_select_rec.min_acc_unit );
5530: dbms_sql.column_value( p_select_c, 12, p_select_rec.precision );
5531: dbms_sql.column_value( p_select_c, 13, p_select_rec.total_cm_line_amount );
5532: dbms_sql.column_value( p_select_c, 14, p_select_rec.total_inv_adj_amount );
5533: dbms_sql.column_value( p_select_c, 15, p_select_rec.commitment_code );
5526: dbms_sql.column_value( p_select_c, 8, p_select_rec.post_to_gl_flag );
5527: dbms_sql.column_value( p_select_c, 9, p_select_rec.actual_date_closed );
5528: dbms_sql.column_value( p_select_c, 10, p_select_rec.gl_date_closed );
5529: dbms_sql.column_value( p_select_c, 11, p_select_rec.min_acc_unit );
5530: dbms_sql.column_value( p_select_c, 12, p_select_rec.precision );
5531: dbms_sql.column_value( p_select_c, 13, p_select_rec.total_cm_line_amount );
5532: dbms_sql.column_value( p_select_c, 14, p_select_rec.total_inv_adj_amount );
5533: dbms_sql.column_value( p_select_c, 15, p_select_rec.commitment_code );
5534: dbms_sql.column_value( p_select_c, 16, p_select_rec.invoice_trx_id );
5527: dbms_sql.column_value( p_select_c, 9, p_select_rec.actual_date_closed );
5528: dbms_sql.column_value( p_select_c, 10, p_select_rec.gl_date_closed );
5529: dbms_sql.column_value( p_select_c, 11, p_select_rec.min_acc_unit );
5530: dbms_sql.column_value( p_select_c, 12, p_select_rec.precision );
5531: dbms_sql.column_value( p_select_c, 13, p_select_rec.total_cm_line_amount );
5532: dbms_sql.column_value( p_select_c, 14, p_select_rec.total_inv_adj_amount );
5533: dbms_sql.column_value( p_select_c, 15, p_select_rec.commitment_code );
5534: dbms_sql.column_value( p_select_c, 16, p_select_rec.invoice_trx_id );
5535: dbms_sql.column_value( p_select_c, 17, p_select_rec.ps_line_remaining );
5528: dbms_sql.column_value( p_select_c, 10, p_select_rec.gl_date_closed );
5529: dbms_sql.column_value( p_select_c, 11, p_select_rec.min_acc_unit );
5530: dbms_sql.column_value( p_select_c, 12, p_select_rec.precision );
5531: dbms_sql.column_value( p_select_c, 13, p_select_rec.total_cm_line_amount );
5532: dbms_sql.column_value( p_select_c, 14, p_select_rec.total_inv_adj_amount );
5533: dbms_sql.column_value( p_select_c, 15, p_select_rec.commitment_code );
5534: dbms_sql.column_value( p_select_c, 16, p_select_rec.invoice_trx_id );
5535: dbms_sql.column_value( p_select_c, 17, p_select_rec.ps_line_remaining );
5536: dbms_sql.column_value( p_select_c, 18,
5529: dbms_sql.column_value( p_select_c, 11, p_select_rec.min_acc_unit );
5530: dbms_sql.column_value( p_select_c, 12, p_select_rec.precision );
5531: dbms_sql.column_value( p_select_c, 13, p_select_rec.total_cm_line_amount );
5532: dbms_sql.column_value( p_select_c, 14, p_select_rec.total_inv_adj_amount );
5533: dbms_sql.column_value( p_select_c, 15, p_select_rec.commitment_code );
5534: dbms_sql.column_value( p_select_c, 16, p_select_rec.invoice_trx_id );
5535: dbms_sql.column_value( p_select_c, 17, p_select_rec.ps_line_remaining );
5536: dbms_sql.column_value( p_select_c, 18,
5537: p_select_rec.ps_amount_due_remaining );
5530: dbms_sql.column_value( p_select_c, 12, p_select_rec.precision );
5531: dbms_sql.column_value( p_select_c, 13, p_select_rec.total_cm_line_amount );
5532: dbms_sql.column_value( p_select_c, 14, p_select_rec.total_inv_adj_amount );
5533: dbms_sql.column_value( p_select_c, 15, p_select_rec.commitment_code );
5534: dbms_sql.column_value( p_select_c, 16, p_select_rec.invoice_trx_id );
5535: dbms_sql.column_value( p_select_c, 17, p_select_rec.ps_line_remaining );
5536: dbms_sql.column_value( p_select_c, 18,
5537: p_select_rec.ps_amount_due_remaining );
5538: dbms_sql.column_value( p_select_c, 19,
5531: dbms_sql.column_value( p_select_c, 13, p_select_rec.total_cm_line_amount );
5532: dbms_sql.column_value( p_select_c, 14, p_select_rec.total_inv_adj_amount );
5533: dbms_sql.column_value( p_select_c, 15, p_select_rec.commitment_code );
5534: dbms_sql.column_value( p_select_c, 16, p_select_rec.invoice_trx_id );
5535: dbms_sql.column_value( p_select_c, 17, p_select_rec.ps_line_remaining );
5536: dbms_sql.column_value( p_select_c, 18,
5537: p_select_rec.ps_amount_due_remaining );
5538: dbms_sql.column_value( p_select_c, 19,
5539: p_select_rec.ps_acctd_amt_due_rem );
5532: dbms_sql.column_value( p_select_c, 14, p_select_rec.total_inv_adj_amount );
5533: dbms_sql.column_value( p_select_c, 15, p_select_rec.commitment_code );
5534: dbms_sql.column_value( p_select_c, 16, p_select_rec.invoice_trx_id );
5535: dbms_sql.column_value( p_select_c, 17, p_select_rec.ps_line_remaining );
5536: dbms_sql.column_value( p_select_c, 18,
5537: p_select_rec.ps_amount_due_remaining );
5538: dbms_sql.column_value( p_select_c, 19,
5539: p_select_rec.ps_acctd_amt_due_rem );
5540: dbms_sql.column_value( p_select_c, 20,
5534: dbms_sql.column_value( p_select_c, 16, p_select_rec.invoice_trx_id );
5535: dbms_sql.column_value( p_select_c, 17, p_select_rec.ps_line_remaining );
5536: dbms_sql.column_value( p_select_c, 18,
5537: p_select_rec.ps_amount_due_remaining );
5538: dbms_sql.column_value( p_select_c, 19,
5539: p_select_rec.ps_acctd_amt_due_rem );
5540: dbms_sql.column_value( p_select_c, 20,
5541: p_select_rec.ps_amount_adjusted );
5542: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
5536: dbms_sql.column_value( p_select_c, 18,
5537: p_select_rec.ps_amount_due_remaining );
5538: dbms_sql.column_value( p_select_c, 19,
5539: p_select_rec.ps_acctd_amt_due_rem );
5540: dbms_sql.column_value( p_select_c, 20,
5541: p_select_rec.ps_amount_adjusted );
5542: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
5543: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
5544: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
5538: dbms_sql.column_value( p_select_c, 19,
5539: p_select_rec.ps_acctd_amt_due_rem );
5540: dbms_sql.column_value( p_select_c, 20,
5541: p_select_rec.ps_amount_adjusted );
5542: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
5543: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
5544: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
5545: dbms_sql.column_value( p_select_c, 24,
5546: p_select_rec.total_inv_line_remaining );
5539: p_select_rec.ps_acctd_amt_due_rem );
5540: dbms_sql.column_value( p_select_c, 20,
5541: p_select_rec.ps_amount_adjusted );
5542: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
5543: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
5544: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
5545: dbms_sql.column_value( p_select_c, 24,
5546: p_select_rec.total_inv_line_remaining );
5547: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_line_original );
5540: dbms_sql.column_value( p_select_c, 20,
5541: p_select_rec.ps_amount_adjusted );
5542: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
5543: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
5544: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
5545: dbms_sql.column_value( p_select_c, 24,
5546: p_select_rec.total_inv_line_remaining );
5547: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_line_original );
5548: dbms_sql.column_value( p_select_c, 26, p_select_rec.ps_currency_code );
5541: p_select_rec.ps_amount_adjusted );
5542: dbms_sql.column_value( p_select_c, 21, p_select_rec.ps_precision );
5543: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
5544: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
5545: dbms_sql.column_value( p_select_c, 24,
5546: p_select_rec.total_inv_line_remaining );
5547: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_line_original );
5548: dbms_sql.column_value( p_select_c, 26, p_select_rec.ps_currency_code );
5549: dbms_sql.column_value( p_select_c, 27, p_select_rec.allocate_tax_freight);
5543: dbms_sql.column_value( p_select_c, 22, p_select_rec.ps_min_acc_unit );
5544: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
5545: dbms_sql.column_value( p_select_c, 24,
5546: p_select_rec.total_inv_line_remaining );
5547: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_line_original );
5548: dbms_sql.column_value( p_select_c, 26, p_select_rec.ps_currency_code );
5549: dbms_sql.column_value( p_select_c, 27, p_select_rec.allocate_tax_freight);
5550: dbms_sql.column_value( p_select_c, 28, p_select_rec.adjustment_type);
5551: dbms_sql.column_value( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5544: dbms_sql.column_value( p_select_c, 23, p_select_rec.ps_exchange_rate );
5545: dbms_sql.column_value( p_select_c, 24,
5546: p_select_rec.total_inv_line_remaining );
5547: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_line_original );
5548: dbms_sql.column_value( p_select_c, 26, p_select_rec.ps_currency_code );
5549: dbms_sql.column_value( p_select_c, 27, p_select_rec.allocate_tax_freight);
5550: dbms_sql.column_value( p_select_c, 28, p_select_rec.adjustment_type);
5551: dbms_sql.column_value( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5552: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5545: dbms_sql.column_value( p_select_c, 24,
5546: p_select_rec.total_inv_line_remaining );
5547: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_line_original );
5548: dbms_sql.column_value( p_select_c, 26, p_select_rec.ps_currency_code );
5549: dbms_sql.column_value( p_select_c, 27, p_select_rec.allocate_tax_freight);
5550: dbms_sql.column_value( p_select_c, 28, p_select_rec.adjustment_type);
5551: dbms_sql.column_value( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5552: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5553: dbms_sql.column_value( p_select_c, 31, p_select_rec.inv_line_adj);
5546: p_select_rec.total_inv_line_remaining );
5547: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_line_original );
5548: dbms_sql.column_value( p_select_c, 26, p_select_rec.ps_currency_code );
5549: dbms_sql.column_value( p_select_c, 27, p_select_rec.allocate_tax_freight);
5550: dbms_sql.column_value( p_select_c, 28, p_select_rec.adjustment_type);
5551: dbms_sql.column_value( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5552: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5553: dbms_sql.column_value( p_select_c, 31, p_select_rec.inv_line_adj);
5554: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_tax_adj);
5547: dbms_sql.column_value( p_select_c, 25, p_select_rec.ps_line_original );
5548: dbms_sql.column_value( p_select_c, 26, p_select_rec.ps_currency_code );
5549: dbms_sql.column_value( p_select_c, 27, p_select_rec.allocate_tax_freight);
5550: dbms_sql.column_value( p_select_c, 28, p_select_rec.adjustment_type);
5551: dbms_sql.column_value( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5552: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5553: dbms_sql.column_value( p_select_c, 31, p_select_rec.inv_line_adj);
5554: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_tax_adj);
5555: dbms_sql.column_value( p_select_c, 33, p_select_rec.inv_frt_adj);
5548: dbms_sql.column_value( p_select_c, 26, p_select_rec.ps_currency_code );
5549: dbms_sql.column_value( p_select_c, 27, p_select_rec.allocate_tax_freight);
5550: dbms_sql.column_value( p_select_c, 28, p_select_rec.adjustment_type);
5551: dbms_sql.column_value( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5552: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5553: dbms_sql.column_value( p_select_c, 31, p_select_rec.inv_line_adj);
5554: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_tax_adj);
5555: dbms_sql.column_value( p_select_c, 33, p_select_rec.inv_frt_adj);
5556: dbms_sql.column_value( p_select_c, 34, p_select_rec.ps_tax_remaining);
5549: dbms_sql.column_value( p_select_c, 27, p_select_rec.allocate_tax_freight);
5550: dbms_sql.column_value( p_select_c, 28, p_select_rec.adjustment_type);
5551: dbms_sql.column_value( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5552: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5553: dbms_sql.column_value( p_select_c, 31, p_select_rec.inv_line_adj);
5554: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_tax_adj);
5555: dbms_sql.column_value( p_select_c, 33, p_select_rec.inv_frt_adj);
5556: dbms_sql.column_value( p_select_c, 34, p_select_rec.ps_tax_remaining);
5557: dbms_sql.column_value( p_select_c, 35, p_select_rec.ps_freight_remaining);
5550: dbms_sql.column_value( p_select_c, 28, p_select_rec.adjustment_type);
5551: dbms_sql.column_value( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5552: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5553: dbms_sql.column_value( p_select_c, 31, p_select_rec.inv_line_adj);
5554: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_tax_adj);
5555: dbms_sql.column_value( p_select_c, 33, p_select_rec.inv_frt_adj);
5556: dbms_sql.column_value( p_select_c, 34, p_select_rec.ps_tax_remaining);
5557: dbms_sql.column_value( p_select_c, 35, p_select_rec.ps_freight_remaining);
5558: dbms_sql.column_value( p_select_c, 36, p_select_rec.ps_tax_original);
5551: dbms_sql.column_value( p_select_c, 29, p_select_rec.total_cm_tax_amount);
5552: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5553: dbms_sql.column_value( p_select_c, 31, p_select_rec.inv_line_adj);
5554: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_tax_adj);
5555: dbms_sql.column_value( p_select_c, 33, p_select_rec.inv_frt_adj);
5556: dbms_sql.column_value( p_select_c, 34, p_select_rec.ps_tax_remaining);
5557: dbms_sql.column_value( p_select_c, 35, p_select_rec.ps_freight_remaining);
5558: dbms_sql.column_value( p_select_c, 36, p_select_rec.ps_tax_original);
5559: dbms_sql.column_value( p_select_c, 37, p_select_rec.ps_freight_original);
5552: dbms_sql.column_value( p_select_c, 30, p_select_rec.total_cm_frt_amount);
5553: dbms_sql.column_value( p_select_c, 31, p_select_rec.inv_line_adj);
5554: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_tax_adj);
5555: dbms_sql.column_value( p_select_c, 33, p_select_rec.inv_frt_adj);
5556: dbms_sql.column_value( p_select_c, 34, p_select_rec.ps_tax_remaining);
5557: dbms_sql.column_value( p_select_c, 35, p_select_rec.ps_freight_remaining);
5558: dbms_sql.column_value( p_select_c, 36, p_select_rec.ps_tax_original);
5559: dbms_sql.column_value( p_select_c, 37, p_select_rec.ps_freight_original);
5560:
5553: dbms_sql.column_value( p_select_c, 31, p_select_rec.inv_line_adj);
5554: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_tax_adj);
5555: dbms_sql.column_value( p_select_c, 33, p_select_rec.inv_frt_adj);
5556: dbms_sql.column_value( p_select_c, 34, p_select_rec.ps_tax_remaining);
5557: dbms_sql.column_value( p_select_c, 35, p_select_rec.ps_freight_remaining);
5558: dbms_sql.column_value( p_select_c, 36, p_select_rec.ps_tax_original);
5559: dbms_sql.column_value( p_select_c, 37, p_select_rec.ps_freight_original);
5560:
5561: print_fcn_label2( 'arp_maintain_ps2.get_iad_column_values()-' );
5554: dbms_sql.column_value( p_select_c, 32, p_select_rec.inv_tax_adj);
5555: dbms_sql.column_value( p_select_c, 33, p_select_rec.inv_frt_adj);
5556: dbms_sql.column_value( p_select_c, 34, p_select_rec.ps_tax_remaining);
5557: dbms_sql.column_value( p_select_c, 35, p_select_rec.ps_freight_remaining);
5558: dbms_sql.column_value( p_select_c, 36, p_select_rec.ps_tax_original);
5559: dbms_sql.column_value( p_select_c, 37, p_select_rec.ps_freight_original);
5560:
5561: print_fcn_label2( 'arp_maintain_ps2.get_iad_column_values()-' );
5562: EXCEPTION
5555: dbms_sql.column_value( p_select_c, 33, p_select_rec.inv_frt_adj);
5556: dbms_sql.column_value( p_select_c, 34, p_select_rec.ps_tax_remaining);
5557: dbms_sql.column_value( p_select_c, 35, p_select_rec.ps_freight_remaining);
5558: dbms_sql.column_value( p_select_c, 36, p_select_rec.ps_tax_original);
5559: dbms_sql.column_value( p_select_c, 37, p_select_rec.ps_freight_original);
5560:
5561: print_fcn_label2( 'arp_maintain_ps2.get_iad_column_values()-' );
5562: EXCEPTION
5563: WHEN OTHERS THEN
6229: -------------------------------------------------------------
6230: BEGIN
6231: debug( ' Binding insert_adj_c', MSG_LEVEL_DEBUG );
6232:
6233: dbms_sql.bind_variable( p_insert_adj_c,
6234: 'user_id',
6235: p_profile_info.user_id );
6236:
6237: dbms_sql.bind_variable( p_insert_adj_c,
6233: dbms_sql.bind_variable( p_insert_adj_c,
6234: 'user_id',
6235: p_profile_info.user_id );
6236:
6237: dbms_sql.bind_variable( p_insert_adj_c,
6238: 'login_id',
6239: p_profile_info.conc_login_id );
6240:
6241: dbms_sql.bind_variable( p_insert_adj_c,
6237: dbms_sql.bind_variable( p_insert_adj_c,
6238: 'login_id',
6239: p_profile_info.conc_login_id );
6240:
6241: dbms_sql.bind_variable( p_insert_adj_c,
6242: 'request_id',
6243: p_profile_info.request_id );
6244:
6245: dbms_sql.bind_variable( p_insert_adj_c,
6241: dbms_sql.bind_variable( p_insert_adj_c,
6242: 'request_id',
6243: p_profile_info.request_id );
6244:
6245: dbms_sql.bind_variable( p_insert_adj_c,
6246: 'application_id',
6247: p_profile_info.application_id );
6248:
6249: dbms_sql.bind_variable( p_insert_adj_c,
6245: dbms_sql.bind_variable( p_insert_adj_c,
6246: 'application_id',
6247: p_profile_info.application_id );
6248:
6249: dbms_sql.bind_variable( p_insert_adj_c,
6250: 'program_id',
6251: p_profile_info.conc_program_id );
6252:
6253:
6250: 'program_id',
6251: p_profile_info.conc_program_id );
6252:
6253:
6254: dbms_sql.bind_variable(
6255: p_insert_adj_c,
6256: 'set_of_books_id',
6257: p_select_rec.set_of_books_id );
6258:
6255: p_insert_adj_c,
6256: 'set_of_books_id',
6257: p_select_rec.set_of_books_id );
6258:
6259: dbms_sql.bind_variable( p_insert_adj_c,
6260: 'trx_date',
6261: p_select_rec.trx_date );
6262:
6263: dbms_sql.bind_variable( p_insert_adj_c,
6259: dbms_sql.bind_variable( p_insert_adj_c,
6260: 'trx_date',
6261: p_select_rec.trx_date );
6262:
6263: dbms_sql.bind_variable( p_insert_adj_c,
6264: 'gl_date',
6265: p_select_rec.gl_date );
6266:
6267: dbms_sql.bind_variable( p_insert_adj_c,
6263: dbms_sql.bind_variable( p_insert_adj_c,
6264: 'gl_date',
6265: p_select_rec.gl_date );
6266:
6267: dbms_sql.bind_variable( p_insert_adj_c,
6268: 'code_combination_id',
6269: p_select_rec.code_combination_id );
6270:
6271: dbms_sql.bind_variable( p_insert_adj_c,
6267: dbms_sql.bind_variable( p_insert_adj_c,
6268: 'code_combination_id',
6269: p_select_rec.code_combination_id );
6270:
6271: dbms_sql.bind_variable( p_insert_adj_c,
6272: 'adjusted_trx_id',
6273: p_select_rec.adjusted_trx_id );
6274:
6275: dbms_sql.bind_variable( p_insert_adj_c,
6271: dbms_sql.bind_variable( p_insert_adj_c,
6272: 'adjusted_trx_id',
6273: p_select_rec.adjusted_trx_id );
6274:
6275: dbms_sql.bind_variable( p_insert_adj_c,
6276: 'payment_schedule_id',
6277: p_ps_id_t( i ) );
6278:
6279: dbms_sql.bind_variable( p_insert_adj_c,
6275: dbms_sql.bind_variable( p_insert_adj_c,
6276: 'payment_schedule_id',
6277: p_ps_id_t( i ) );
6278:
6279: dbms_sql.bind_variable( p_insert_adj_c,
6280: 'subsequent_trx_id',
6281: p_select_rec.customer_trx_id );
6282:
6283: dbms_sql.bind_variable( p_insert_adj_c,
6279: dbms_sql.bind_variable( p_insert_adj_c,
6280: 'subsequent_trx_id',
6281: p_select_rec.customer_trx_id );
6282:
6283: dbms_sql.bind_variable( p_insert_adj_c,
6284: 'post_to_gl_flag',
6285: p_select_rec.post_to_gl_flag );
6286:
6287: dbms_sql.bind_variable( p_insert_adj_c,
6283: dbms_sql.bind_variable( p_insert_adj_c,
6284: 'post_to_gl_flag',
6285: p_select_rec.post_to_gl_flag );
6286:
6287: dbms_sql.bind_variable( p_insert_adj_c,
6288: 'adj_amount',
6289: p_adj_amount_t( i ) );
6290:
6291: dbms_sql.bind_variable( p_insert_adj_c,
6287: dbms_sql.bind_variable( p_insert_adj_c,
6288: 'adj_amount',
6289: p_adj_amount_t( i ) );
6290:
6291: dbms_sql.bind_variable( p_insert_adj_c,
6292: 'acctd_adj_amount',
6293: p_acctd_adj_amount_t( i ) );
6294:
6295: /* VAT changes */
6296: SELECT ar_adjustments_s.nextval
6297: INTO l_adjustment_id
6298: FROM dual;
6299:
6300: dbms_sql.bind_variable( p_insert_adj_c,
6301: 'adjustment_id',
6302: l_adjustment_id );
6303:
6304: dbms_sql.bind_variable( p_insert_adj_c,
6300: dbms_sql.bind_variable( p_insert_adj_c,
6301: 'adjustment_id',
6302: l_adjustment_id );
6303:
6304: dbms_sql.bind_variable( p_insert_adj_c,
6305: 'adj_type',
6306: p_select_rec.adjustment_type);
6307:
6308: dbms_sql.bind_variable( p_insert_adj_c,
6304: dbms_sql.bind_variable( p_insert_adj_c,
6305: 'adj_type',
6306: p_select_rec.adjustment_type);
6307:
6308: dbms_sql.bind_variable( p_insert_adj_c,
6309: 'line_adjusted',
6310: p_line_adj_t(i));
6311:
6312: dbms_sql.bind_variable( p_insert_adj_c,
6308: dbms_sql.bind_variable( p_insert_adj_c,
6309: 'line_adjusted',
6310: p_line_adj_t(i));
6311:
6312: dbms_sql.bind_variable( p_insert_adj_c,
6313: 'tax_adjusted',
6314: p_tax_adj_t(i));
6315:
6316: dbms_sql.bind_variable( p_insert_adj_c,
6312: dbms_sql.bind_variable( p_insert_adj_c,
6313: 'tax_adjusted',
6314: p_tax_adj_t(i));
6315:
6316: dbms_sql.bind_variable( p_insert_adj_c,
6317: 'freight_adjusted',
6318: p_frt_adj_t(i));
6319: /* anuj: Corrected typo for SSA retrofit */
6320: dbms_sql.bind_variable( p_insert_adj_c,
6316: dbms_sql.bind_variable( p_insert_adj_c,
6317: 'freight_adjusted',
6318: p_frt_adj_t(i));
6319: /* anuj: Corrected typo for SSA retrofit */
6320: dbms_sql.bind_variable( p_insert_adj_c,
6321: 'org_id',
6322: arp_standard.sysparm.org_id);
6323:
6324: EXCEPTION
6332: -- Execute
6333: -------------------------------------------------------------
6334: BEGIN
6335: debug( ' Inserting adjustments', MSG_LEVEL_DEBUG );
6336: l_ignore := dbms_sql.execute( p_insert_adj_c );
6337: debug( to_char(l_ignore) || ' row(s) inserted',
6338: MSG_LEVEL_DEBUG );
6339:
6340: /*-------------------------------------------+
6365: -------------------------------------------------------------
6366: BEGIN
6367: debug( ' Binding update_ps_c', MSG_LEVEL_DEBUG );
6368:
6369: dbms_sql.bind_variable( p_update_ps_c,
6370: 'user_id',
6371: p_profile_info.user_id );
6372:
6373: dbms_sql.bind_variable( p_update_ps_c,
6369: dbms_sql.bind_variable( p_update_ps_c,
6370: 'user_id',
6371: p_profile_info.user_id );
6372:
6373: dbms_sql.bind_variable( p_update_ps_c,
6374: 'login_id',
6375: p_profile_info.conc_login_id );
6376:
6377: dbms_sql.bind_variable( p_update_ps_c,
6373: dbms_sql.bind_variable( p_update_ps_c,
6374: 'login_id',
6375: p_profile_info.conc_login_id );
6376:
6377: dbms_sql.bind_variable( p_update_ps_c,
6378: 'amount_due_remaining',
6379: p_ps_amount_due_rem_t( i ) );
6380:
6381: dbms_sql.bind_variable( p_update_ps_c,
6377: dbms_sql.bind_variable( p_update_ps_c,
6378: 'amount_due_remaining',
6379: p_ps_amount_due_rem_t( i ) );
6380:
6381: dbms_sql.bind_variable( p_update_ps_c,
6382: 'gl_date_closed',
6383: p_select_rec.gl_date_closed );
6384:
6385: dbms_sql.bind_variable( p_update_ps_c,
6381: dbms_sql.bind_variable( p_update_ps_c,
6382: 'gl_date_closed',
6383: p_select_rec.gl_date_closed );
6384:
6385: dbms_sql.bind_variable( p_update_ps_c,
6386: 'actual_date_closed',
6387: p_select_rec.actual_date_closed );
6388:
6389: dbms_sql.bind_variable( p_update_ps_c,
6385: dbms_sql.bind_variable( p_update_ps_c,
6386: 'actual_date_closed',
6387: p_select_rec.actual_date_closed );
6388:
6389: dbms_sql.bind_variable( p_update_ps_c,
6390: 'amount_line_items_remaining',
6391: p_ps_line_rem_t( i ) );
6392:
6393: dbms_sql.bind_variable( p_update_ps_c,
6389: dbms_sql.bind_variable( p_update_ps_c,
6390: 'amount_line_items_remaining',
6391: p_ps_line_rem_t( i ) );
6392:
6393: dbms_sql.bind_variable( p_update_ps_c,
6394: 'amount_adjusted',
6395: p_ps_amount_adjusted_t( i ) );
6396:
6397: dbms_sql.bind_variable( p_update_ps_c,
6393: dbms_sql.bind_variable( p_update_ps_c,
6394: 'amount_adjusted',
6395: p_ps_amount_adjusted_t( i ) );
6396:
6397: dbms_sql.bind_variable( p_update_ps_c,
6398: 'acctd_amount_due_remaining',
6399: p_ps_acctd_amt_due_rem_t( i ) );
6400:
6401: dbms_sql.bind_variable( p_update_ps_c,
6397: dbms_sql.bind_variable( p_update_ps_c,
6398: 'acctd_amount_due_remaining',
6399: p_ps_acctd_amt_due_rem_t( i ) );
6400:
6401: dbms_sql.bind_variable( p_update_ps_c,
6402: 'payment_schedule_id',
6403: p_ps_id_t( i ) );
6404:
6405: dbms_sql.bind_variable( p_update_ps_c,
6401: dbms_sql.bind_variable( p_update_ps_c,
6402: 'payment_schedule_id',
6403: p_ps_id_t( i ) );
6404:
6405: dbms_sql.bind_variable( p_update_ps_c,
6406: 'tax_remaining',
6407: p_ps_tax_rem_t( i ) );
6408:
6409: dbms_sql.bind_variable( p_update_ps_c,
6405: dbms_sql.bind_variable( p_update_ps_c,
6406: 'tax_remaining',
6407: p_ps_tax_rem_t( i ) );
6408:
6409: dbms_sql.bind_variable( p_update_ps_c,
6410: 'freight_remaining',
6411: p_ps_frt_rem_t( i ) );
6412:
6413: EXCEPTION
6421: -- Execute
6422: -------------------------------------------------------------
6423: BEGIN
6424: debug( ' Updating invoice payment schedules', MSG_LEVEL_DEBUG );
6425: l_ignore := dbms_sql.execute( p_update_ps_c );
6426: debug( to_char(l_ignore) || ' row(s) updated',
6427: MSG_LEVEL_DEBUG );
6428:
6429: /*-------------------------------------------+
6689:
6690: --
6691: clear_all_tables;
6692: --
6693: IF( NOT( dbms_sql.is_open( iad_select_c ) AND
6694: dbms_sql.is_open( iad_insert_adj_c ) AND
6695: dbms_sql.is_open( iad_update_ps_c ) )) THEN
6696:
6697: build_iad_sql(
6690: --
6691: clear_all_tables;
6692: --
6693: IF( NOT( dbms_sql.is_open( iad_select_c ) AND
6694: dbms_sql.is_open( iad_insert_adj_c ) AND
6695: dbms_sql.is_open( iad_update_ps_c ) )) THEN
6696:
6697: build_iad_sql(
6698: system_info,
6691: clear_all_tables;
6692: --
6693: IF( NOT( dbms_sql.is_open( iad_select_c ) AND
6694: dbms_sql.is_open( iad_insert_adj_c ) AND
6695: dbms_sql.is_open( iad_update_ps_c ) )) THEN
6696:
6697: build_iad_sql(
6698: system_info,
6699: profile_info,
6708:
6709: ---------------------------------------------------------------
6710: -- Bind variables
6711: ---------------------------------------------------------------
6712: dbms_sql.bind_variable( iad_select_c,
6713: 'customer_trx_id',
6714: p_customer_trx_id );
6715:
6716: ---------------------------------------------------------------
6718: ---------------------------------------------------------------
6719: debug( ' Executing select sql', MSG_LEVEL_DEBUG );
6720:
6721: BEGIN
6722: l_ignore := dbms_sql.execute( iad_select_c );
6723:
6724: EXCEPTION
6725: WHEN OTHERS THEN
6726: debug( 'EXCEPTION: Error executing select sql',
6734: ---------------------------------------------------------------
6735: BEGIN
6736: LOOP
6737:
6738: IF dbms_sql.fetch_rows( iad_select_c ) > 0 THEN
6739:
6740: debug(' Fetched a row', MSG_LEVEL_DEBUG );
6741:
6742: -----------------------------------------------
6741:
6742: -----------------------------------------------
6743: -- Load row into record
6744: -----------------------------------------------
6745: dbms_sql.column_value( iad_select_c, 7, l_customer_trx_id );
6746: dbms_sql.column_value( iad_select_c, 5, l_adjusted_trx_id );
6747: dbms_sql.column_value( iad_select_c, 16, l_inv_trx_id );
6748:
6749: -----------------------------------------------
6742: -----------------------------------------------
6743: -- Load row into record
6744: -----------------------------------------------
6745: dbms_sql.column_value( iad_select_c, 7, l_customer_trx_id );
6746: dbms_sql.column_value( iad_select_c, 5, l_adjusted_trx_id );
6747: dbms_sql.column_value( iad_select_c, 16, l_inv_trx_id );
6748:
6749: -----------------------------------------------
6750: -- Check if adjusted trx or invoice changed
6743: -- Load row into record
6744: -----------------------------------------------
6745: dbms_sql.column_value( iad_select_c, 7, l_customer_trx_id );
6746: dbms_sql.column_value( iad_select_c, 5, l_adjusted_trx_id );
6747: dbms_sql.column_value( iad_select_c, 16, l_inv_trx_id );
6748:
6749: -----------------------------------------------
6750: -- Check if adjusted trx or invoice changed
6751: -----------------------------------------------
6819:
6820: -- get total adjustments for new adjusted trx
6821: l_is_new_adj_trx := TRUE;
6822:
6823: /* dbms_sql.column_value( iad_select_c, 31,
6824: l_eff_adj_line_total );
6825: dbms_sql.column_value( iad_select_c, 32,
6826: l_eff_adj_tax_total );
6827: dbms_sql.column_value( iad_select_c, 33,
6821: l_is_new_adj_trx := TRUE;
6822:
6823: /* dbms_sql.column_value( iad_select_c, 31,
6824: l_eff_adj_line_total );
6825: dbms_sql.column_value( iad_select_c, 32,
6826: l_eff_adj_tax_total );
6827: dbms_sql.column_value( iad_select_c, 33,
6828: l_eff_adj_frt_total );
6829: */
6823: /* dbms_sql.column_value( iad_select_c, 31,
6824: l_eff_adj_line_total );
6825: dbms_sql.column_value( iad_select_c, 32,
6826: l_eff_adj_tax_total );
6827: dbms_sql.column_value( iad_select_c, 33,
6828: l_eff_adj_frt_total );
6829: */
6830: -----------------------------------------------
6831: -- Else if new cm
6842: IF( is_new_inv ) THEN
6843:
6844: l_old_inv_trx_id := l_inv_trx_id;
6845: -- get invoice line, tax, frt remaining for new invoice
6846: dbms_sql.column_value( iad_select_c, 24 ,
6847: l_eff_line_bal );
6848: dbms_sql.column_value( iad_select_c, 34 ,
6849: l_eff_tax_bal );
6850: dbms_sql.column_value( iad_select_c, 35,
6844: l_old_inv_trx_id := l_inv_trx_id;
6845: -- get invoice line, tax, frt remaining for new invoice
6846: dbms_sql.column_value( iad_select_c, 24 ,
6847: l_eff_line_bal );
6848: dbms_sql.column_value( iad_select_c, 34 ,
6849: l_eff_tax_bal );
6850: dbms_sql.column_value( iad_select_c, 35,
6851: l_eff_frt_bal );
6852:
6846: dbms_sql.column_value( iad_select_c, 24 ,
6847: l_eff_line_bal );
6848: dbms_sql.column_value( iad_select_c, 34 ,
6849: l_eff_tax_bal );
6850: dbms_sql.column_value( iad_select_c, 35,
6851: l_eff_frt_bal );
6852:
6853: END IF;
6854:
7031:
7032: -- use the select sql passed as arg
7033: --
7034:
7035: dbms_sql.close_cursor( ips_select_c );
7036: ips_select_c := dbms_sql.open_cursor;
7037:
7038: debug(' select_sql='||p_select_sql );
7039:
7032: -- use the select sql passed as arg
7033: --
7034:
7035: dbms_sql.close_cursor( ips_select_c );
7036: ips_select_c := dbms_sql.open_cursor;
7037:
7038: debug(' select_sql='||p_select_sql );
7039:
7040: debug(' parsing new select sql');
7037:
7038: debug(' select_sql='||p_select_sql );
7039:
7040: debug(' parsing new select sql');
7041: dbms_sql.parse( ips_select_c, p_select_sql, dbms_sql.v7 );
7042:
7043:
7044:
7045: insert_inv_ps_private(
7083:
7084: -- use the select sql passed as arg
7085: --
7086:
7087: dbms_sql.close_cursor( ira_select_c );
7088: ira_select_c := dbms_sql.open_cursor;
7089:
7090: debug(' select_sql='||p_select_sql );
7091:
7084: -- use the select sql passed as arg
7085: --
7086:
7087: dbms_sql.close_cursor( ira_select_c );
7088: ira_select_c := dbms_sql.open_cursor;
7089:
7090: debug(' select_sql='||p_select_sql );
7091:
7092: debug(' parsing new select sql');
7089:
7090: debug(' select_sql='||p_select_sql );
7091:
7092: debug(' parsing new select sql');
7093: dbms_sql.parse( ira_select_c, p_select_sql, dbms_sql.v7 );
7094:
7095:
7096:
7097: insert_cm_ps_private(system_info, profile_info, p_request_id);
7129:
7130: -- use the select sql passed as arg
7131: --
7132:
7133: dbms_sql.close_cursor( ups_select_c );
7134: ups_select_c := dbms_sql.open_cursor;
7135:
7136: debug(' select_sql='||p_select_sql );
7137:
7130: -- use the select sql passed as arg
7131: --
7132:
7133: dbms_sql.close_cursor( ups_select_c );
7134: ups_select_c := dbms_sql.open_cursor;
7135:
7136: debug(' select_sql='||p_select_sql );
7137:
7138: debug(' parsing new select sql');
7135:
7136: debug(' select_sql='||p_select_sql );
7137:
7138: debug(' parsing new select sql');
7139: dbms_sql.parse( ups_select_c, p_select_sql, dbms_sql.v7 );
7140:
7141:
7142:
7143: insert_child_adj_private(system_info, profile_info, p_request_id);
7176:
7177: -- use the select sql passed as arg
7178: --
7179:
7180: dbms_sql.close_cursor( iad_select_c );
7181: iad_select_c := dbms_sql.open_cursor;
7182:
7183: debug(' select_sql='||p_select_sql );
7184:
7177: -- use the select sql passed as arg
7178: --
7179:
7180: dbms_sql.close_cursor( iad_select_c );
7181: iad_select_c := dbms_sql.open_cursor;
7182:
7183: debug(' select_sql='||p_select_sql );
7184:
7185: debug(' parsing new select sql');
7182:
7183: debug(' select_sql='||p_select_sql );
7184:
7185: debug(' parsing new select sql');
7186: dbms_sql.parse( iad_select_c, p_select_sql, dbms_sql.v7 );
7187:
7188:
7189:
7190: insert_cm_child_adj_private(system_info, profile_info, p_request_id);