[Home] [Help]
2225: debug_info := 'Get the interest invoice NUM EXT2';
2226:
2227: SELECT count(*)
2228: INTO C_int_inv_num_ext2
2229: FROM ap_selected_invoices
2230: -- CHANGES FOR BUG - 3293874 ** STARTS **
2231: --WHERE original_invoice_id = P_invoice_id;
2232: WHERE original_invoice_id = to_char(P_invoice_id);
2233: -- CHANGES FOR BUG - 3293874 ** ENDS **
2469: || P_calling_sequence;
2470:
2471: -- populating values later used to create interest invoice.
2472:
2473: debug_info := 'Count from ap_selected_invoices for P_reference_invoice_id';
2474:
2475: BEGIN
2476: SELECT COUNT(*)
2477: INTO C_int_num1
2474:
2475: BEGIN
2476: SELECT COUNT(*)
2477: INTO C_int_num1
2478: FROM ap_selected_invoices
2479: -- CHANGES FOR BUG - 3293874 ** STARTS **
2480: --WHERE original_invoice_id = P_reference_invoice_id;
2481: WHERE original_invoice_id = to_char(P_reference_invoice_id);
2482: -- CHANGES FOR BUG - 3293874 ** ENDS **
2509: nvl(C_int_num2,0)+1)))) || '-' ||
2510: P_reference_nls_int || to_char(nvl(C_int_num1,0) +
2511: nvl(C_int_num2,0)+1);
2512:
2513: debug_info := 'Insert ap_selected_invoices';
2514:
2515: INSERT INTO AP_SELECTED_INVOICES (
2516: checkrun_name,
2517: invoice_id,
2511: nvl(C_int_num2,0)+1);
2512:
2513: debug_info := 'Insert ap_selected_invoices';
2514:
2515: INSERT INTO AP_SELECTED_INVOICES (
2516: checkrun_name,
2517: invoice_id,
2518: vendor_id,
2519: vendor_site_id,
2688: orig.invoice_currency_code P_invoice_currency_code,
2689: orig.org_id P_org_id
2690: FROM po_vendors pv,
2691: ap_invoices_all orig,
2692: ap_selected_invoices_all new,
2693: fnd_currencies base,
2694: fnd_currencies fcinv,
2695: iby_fd_docs_payable_v ibydocs
2696: WHERE new.original_invoice_id = orig.invoice_id --4346023, reverted 3293874