[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: ============================================================================*/
125: --Contract Payments: Modified the IF condition to look at the invoice_type
126: --rather than the sign of the invoice_amount in deciding which category to
127: --apply, and also added the logic for 'PREPAYMENT' invoices.
128:
129: IF (l_invoice_type_lookup_code= 'STANDARD') THEN
130: l_doc_category_code := 'STD INV';
131: ELSIF (l_invoice_type_lookup_code= 'PAYMENT REQUEST') THEN
132: l_doc_category_code := 'PAY REQ INV';
133: ELSIF (l_invoice_type_lookup_code= 'CREDIT') THEN
323: SELECT terms_id
324: INTO p_terms_id
325: FROM po_headers_all
326: WHERE po_header_id = l_po_header_id
327: AND type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD');
328:
329: debug_info := l_api_name || ': p_terms_id = ' || p_terms_id;
330: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
331: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, debug_info);
341: BEGIN
342: SELECT p.terms_id
343: INTO p_terms_id
344: FROM po_headers_all p, ap_invoice_lines_all l
345: WHERE p.type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD')
346: AND l.po_header_id = p.po_header_id
347: AND l.invoice_id = p_invoice_id
348: AND p.terms_id IS NOT NULL
349: GROUP BY p.terms_id;