APPS.JAI_BOE_MIGRATION_PKG dependencies on DUAL

Line 415: SELECT jai_boe_details_s.NEXTVAL INTO ln_boe_detail_id FROM dual;

411:
412: OPEN detail_line_cur(pn_boe_id);
413: FETCH detail_line_cur INTO detail_line_rec;
414: CLOSE detail_line_cur;
415: SELECT jai_boe_details_s.NEXTVAL INTO ln_boe_detail_id FROM dual;
416:
417: l_boe_detail_type_rec.boe_detail_id := ln_boe_detail_id;
418: l_boe_detail_type_rec.boe_id := pn_boe_id;
419: l_boe_detail_type_rec.detail_line_num := ln_boe_detail_line_num;

Line 533: SELECT jai_boe_details_s.NEXTVAL INTO ln_boe_detail_id FROM dual;

529: OPEN detail_line_cur(pn_boe_id,item_boe_detail_rec.item_number);
530: FETCH detail_line_cur INTO detail_line_rec;
531: CLOSE detail_line_cur;
532:
533: SELECT jai_boe_details_s.NEXTVAL INTO ln_boe_detail_id FROM dual;
534: ln_boe_detail_line_num := ln_boe_detail_line_num + 1;
535:
536: l_boe_detail_type_rec.boe_detail_id := ln_boe_detail_id;
537: l_boe_detail_type_rec.boe_id := pn_boe_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 932: SELECT jai_boe_detail_taxes_s.NEXTVAL INTO ln_boe_tax_id FROM dual;

928: ,pv_tax_type => pv_tax_type
929: --OUT--
930: ,xn_tax_id => ln_tax_id);
931:
932: SELECT jai_boe_detail_taxes_s.NEXTVAL INTO ln_boe_tax_id FROM dual;
933:
934: l_boe_tax_type_rec.BOE_DETAIL_TAX_ID := ln_boe_tax_id;
935: l_boe_tax_type_rec.TAX_ID := ln_tax_id;
936: l_boe_tax_type_rec.BOE_DETAIL_ID := pn_boe_detail_id;