DBA Data[Home] [Help]

APPS.AP_AUTO_DM_CREATION_PKG dependencies on AP_INVOICES_S

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

1273:
1274: -- Bug 1330397
1275: -- Added a hyphen for the invoice number between receipt_num and the sequence
1276:
1277: SELECT p_receipt_num||'-'||AP_INVOICES_S1.nextval
1278: INTO l_invoice_num
1279: FROM dual;
1280:
1281: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1556: debug_info);
1557: END IF;
1558:
1559:
1560: SELECT ap_invoices_s.nextval INTO l_invoice_id FROM dual;
1561:
1562: debug_info := 'Inserting row in ap_invoices';
1563: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1564: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,