DBA Data[Home] [Help]

APPS.AP_IMPORT_UTILITIES_PKG dependencies on FND_DOC_SEQUENCE_CATEGORIES

Line 2800: FND_DOC_SEQUENCE_CATEGORIES for AP_INVOICES or AP_INVOICES_ALL

2796: and the invoice amount is greated than zero then the invoice will be
2797: rejected for 'Invalid Category'.
2798:
2799: The document category specified should be valid in
2800: FND_DOC_SEQUENCE_CATEGORIES for AP_INVOICES or AP_INVOICES_ALL
2801: table. If not then the invoice will be rejected for 'Invalid Category'.
2802:
2803: If the document category is valid then Check the status of the
2804: sequence assigned to this category.The sequence should be automatic

Line 2972: FROM fnd_doc_sequence_categories

2968:
2969: BEGIN
2970: SELECT name, application_id
2971: INTO l_name, l_application_id
2972: FROM fnd_doc_sequence_categories
2973: WHERE code = p_invoice_rec.doc_category_code
2974: AND table_name IN ('AP_INVOICES','AP_INVOICES_ALL');
2975: EXCEPTION
2976: WHEN NO_DATA_FOUND THEN