[Home] [Help]
44: If the profile value is "Partial" or "Always" then
45: document sequencing will be generated???
46:
47: If the profile value is "Always" and no document category is specified
48: by the user, then "Standard Invoices" category will be used for
49: standard invoices and "Credit Memo Invoices" category will be used
50: for credits.
51: We assume that a valid automatic sequence exists for such categories.
52:
45: document sequencing will be generated???
46:
47: If the profile value is "Always" and no document category is specified
48: by the user, then "Standard Invoices" category will be used for
49: standard invoices and "Credit Memo Invoices" category will be used
50: for credits.
51: We assume that a valid automatic sequence exists for such categories.
52:
53: ============================================================================*/
127: --apply, and also added the logic for 'PREPAYMENT' invoices.
128:
129: -- Bug 10206983. Added 'INVOICE REQUEST'.
130:
131: IF (l_invoice_type_lookup_code IN ('STANDARD', 'INVOICE REQUEST')) THEN
132: l_doc_category_code := 'STD INV';
133: ELSIF (l_invoice_type_lookup_code= 'PAYMENT REQUEST') THEN
134: l_doc_category_code := 'PAY REQ INV';
135: ELSIF (l_invoice_type_lookup_code= 'CREDIT') THEN
327: SELECT terms_id
328: INTO p_terms_id
329: FROM po_headers_all
330: WHERE po_header_id = l_po_header_id
331: AND type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD');
332:
333: debug_info := l_api_name || ': p_terms_id = ' || p_terms_id;
334: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
335: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, debug_info);
345: BEGIN
346: SELECT p.terms_id
347: INTO p_terms_id
348: FROM po_headers_all p, ap_invoice_lines_all l
349: WHERE p.type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD')
350: AND l.po_header_id = p.po_header_id
351: AND l.invoice_id = p_invoice_id
352: AND p.terms_id IS NOT NULL
353: GROUP BY p.terms_id;