DBA Data[Home] [Help]

APPS.AP_IMPORT_UTILITIES_PKG dependencies on FND_DOC_SEQUENCE_CATEGORIES

Line 2116: FND_DOC_SEQUENCE_CATEGORIES for AP_INVOICES or AP_INVOICES_ALL

2112: and the invoice amount is greated than zero then the invoice will be
2113: rejected for 'Invalid Category'.
2114:
2115: The document category specified should be valid in
2116: FND_DOC_SEQUENCE_CATEGORIES for AP_INVOICES or AP_INVOICES_ALL
2117: table. If not then the invoice will be rejected for 'Invalid Category'.
2118:
2119: If the document category is valid then Check the status of the
2120: sequence assigned to this category.The sequence should be automatic

Line 2288: FROM fnd_doc_sequence_categories

2284:
2285: BEGIN
2286: SELECT name, application_id
2287: INTO l_name, l_application_id
2288: FROM fnd_doc_sequence_categories
2289: WHERE code = p_invoice_rec.doc_category_code
2290: AND table_name IN ('AP_INVOICES','AP_INVOICES_ALL');
2291: EXCEPTION
2292: WHEN NO_DATA_FOUND THEN