APPS.JAI_BOE_MIGRATION_PKG dependencies on JAI_BOE_ROUNDINGS

Line 724: -- This procedure will insert a record into JAI_BOE_ROUNDINGS table.

720:
721: -- DESCRIPTION:
722: --
723:
724: -- This procedure will insert a record into JAI_BOE_ROUNDINGS table.
725:
726: -- PARAMETERS:
727:
728: -- In: pn_boe_id The BOE id which need insert boe rounding records.

Line 741: l_boe_rounding_rec JAI_BOE_ROUNDINGS%ROWTYPE;

737: --
738:
739: --=========================================================================
740: PROCEDURE insert_boe_rounding(pn_boe_id IN NUMBER) IS
741: l_boe_rounding_rec JAI_BOE_ROUNDINGS%ROWTYPE;
742: ln_boe_rounding_id NUMBER;
743: CURSOR boe_dtl_tax_cur(pn_boe_id NUMBER) IS
744: SELECT
745: jbt.tax_id,

Line 760: SELECT jai_boe_roundings_s.NEXTVAL INTO ln_boe_rounding_id FROM dual;

756: Fnd_File.put_line(Fnd_File.LOG,' **Start insert_boe_rounding for boe_id:' ||pn_boe_id || '--- **');
757:
758: FOR boe_dtl_tax_rec IN boe_dtl_tax_cur(pn_boe_id) LOOP
759:
760: SELECT jai_boe_roundings_s.NEXTVAL INTO ln_boe_rounding_id FROM dual;
761: l_boe_rounding_rec.rounding_id := ln_boe_rounding_id;
762: l_boe_rounding_rec.boe_id := pn_boe_id;
763: l_boe_rounding_rec.tax_id := boe_dtl_tax_rec.tax_id;
764: l_boe_rounding_rec.tax_amount := round(boe_dtl_tax_rec.tax_amount,2);

Line 767: INSERT INTO JAI_BOE_ROUNDINGS

763: l_boe_rounding_rec.tax_id := boe_dtl_tax_rec.tax_id;
764: l_boe_rounding_rec.tax_amount := round(boe_dtl_tax_rec.tax_amount,2);
765: l_boe_rounding_rec.total_amount := round(boe_dtl_tax_rec.tax_amount,2);
766:
767: INSERT INTO JAI_BOE_ROUNDINGS
768: (ROUNDING_ID,
769: BOE_ID,
770: TAX_ID,
771: TAX_AMOUNT,