[Home] [Help]
2321: debug_info := 'Get the interest invoice NUM EXT2';
2322:
2323: SELECT count(*)
2324: INTO C_int_inv_num_ext2
2325: FROM ap_selected_invoices
2326: -- CHANGES FOR BUG - 3293874 ** STARTS **
2327: --WHERE original_invoice_id = P_invoice_id;
2328: WHERE original_invoice_id = to_char(P_invoice_id);
2329: -- CHANGES FOR BUG - 3293874 ** ENDS **
2583: || P_calling_sequence;
2584:
2585: -- populating values later used to create interest invoice.
2586:
2587: debug_info := 'Count from ap_selected_invoices for P_reference_invoice_id';
2588:
2589: BEGIN
2590: SELECT COUNT(*)
2591: INTO C_int_num1
2588:
2589: BEGIN
2590: SELECT COUNT(*)
2591: INTO C_int_num1
2592: FROM ap_selected_invoices
2593: -- CHANGES FOR BUG - 3293874 ** STARTS **
2594: --WHERE original_invoice_id = P_reference_invoice_id;
2595: WHERE original_invoice_id = to_char(P_reference_invoice_id);
2596: -- CHANGES FOR BUG - 3293874 ** ENDS **
2623: nvl(C_int_num2,0)+1)))) || '-' ||
2624: P_reference_nls_int || to_char(nvl(C_int_num1,0) +
2625: nvl(C_int_num2,0)+1);
2626:
2627: debug_info := 'Insert ap_selected_invoices';
2628:
2629: INSERT INTO AP_SELECTED_INVOICES (
2630: checkrun_name,
2631: invoice_id,
2625: nvl(C_int_num2,0)+1);
2626:
2627: debug_info := 'Insert ap_selected_invoices';
2628:
2629: INSERT INTO AP_SELECTED_INVOICES (
2630: checkrun_name,
2631: invoice_id,
2632: vendor_id,
2633: vendor_site_id,
2806: orig.invoice_currency_code P_invoice_currency_code,
2807: orig.org_id P_org_id
2808: FROM po_vendors pv,
2809: ap_invoices_all orig,
2810: ap_selected_invoices_all new,
2811: fnd_currencies base,
2812: fnd_currencies fcinv,
2813: iby_fd_docs_payable_v ibydocs
2814: WHERE new.original_invoice_id = orig.invoice_id --4346023, reverted 3293874