APPS.AP_AUTO_DM_CREATION_PKG dependencies on DUAL

Line 1058: SELECT ap_batches_s.nextval INTO p_batch_id FROM dual;

1054: curr_calling_sequence := p_calling_sequence ||' <- Create_Invoice_batch';
1055:
1056: debug_info := 'Insert into ap_batches';
1057:
1058: SELECT ap_batches_s.nextval INTO p_batch_id FROM dual;
1059:
1060: --Bug fix:1858452
1061: --Note: When matched to a PO , po_distribution_id is not populated
1062: --in rcv_transactions, hence need to join using po_header_id...

Line 1354: FROM dual;

1350: -- Added a hyphen for the invoice number between receipt_num and the sequence
1351:
1352: SELECT p_receipt_num||'-'||AP_INVOICES_S1.nextval
1353: INTO l_invoice_num
1354: FROM dual;
1355:
1356: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1357: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1358: 'Invoice Number := '||l_invoice_num);

Line 1643: SELECT ap_invoices_s.nextval INTO l_invoice_id FROM dual;

1639: debug_info);
1640: END IF;
1641:
1642:
1643: SELECT ap_invoices_s.nextval INTO l_invoice_id FROM dual;
1644:
1645: debug_info := 'Inserting row in ap_invoices';
1646: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1647: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,