DBA Data[Home] [Help]

APPS.AP_AUTO_DM_CREATION_PKG dependencies on AP_INVOICES_S

Line 1352: SELECT p_receipt_num||'-'||AP_INVOICES_S1.nextval

1348:
1349: -- Bug 1330397
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

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,