APPS.AP_INVOICE_LINES_UTILITY_PKG dependencies on AP_PAYMENT_SCHEDULES

Line 1034: from ap_payment_schedules_all

1030: +-----------------------------------------------------------------*/
1031: --bug 10012646
1032: select nvl(count(1),0)
1033: INTO l_count
1034: from ap_payment_schedules_all
1035: where invoice_id =p_line_rec.invoice_id
1036: and checkrun_id is not null
1037: and payment_status_flag <>'Y';
1038:

Line 2182: * Objective update ap_payment_schedules.remaining_amount for manual entry

2178: End Get_Retained_Amount;
2179:
2180: /* ==========================================================================================
2181: * Procedure manual_withhold_tax()
2182: * Objective update ap_payment_schedules.remaining_amount for manual entry
2183: * withholding lines
2184: * This procedire has been moved from payment schedules library since it did
2185: * not consider the
2186: * ap lines model

Line 2193: l_inv_amt_remaining ap_payment_schedules.amount_remaining%TYPE := 0;

2189: PROCEDURE Manual_Withhold_Tax(p_invoice_id IN number
2190: ,p_manual_withhold_amount IN number
2191: ) IS
2192:
2193: l_inv_amt_remaining ap_payment_schedules.amount_remaining%TYPE := 0;
2194: l_gross_amount ap_payment_schedules.gross_amount%TYPE := 0;
2195: l_payment_cross_rate ap_invoices_all.payment_cross_rate%TYPE :=0;
2196: l_payment_currency_code ap_invoices_all.payment_currency_code%TYPE;
2197:

Line 2194: l_gross_amount ap_payment_schedules.gross_amount%TYPE := 0;

2190: ,p_manual_withhold_amount IN number
2191: ) IS
2192:
2193: l_inv_amt_remaining ap_payment_schedules.amount_remaining%TYPE := 0;
2194: l_gross_amount ap_payment_schedules.gross_amount%TYPE := 0;
2195: l_payment_cross_rate ap_invoices_all.payment_cross_rate%TYPE :=0;
2196: l_payment_currency_code ap_invoices_all.payment_currency_code%TYPE;
2197:
2198: -- Debug variables

Line 2215: FROM ap_payment_schedules

2211: WHERE invoice_id = p_invoice_id;
2212:
2213: SELECT sum(nvl(amount_remaining,0)), sum(nvl(gross_amount,0))
2214: INTO l_inv_amt_remaining, l_gross_amount
2215: FROM ap_payment_schedules
2216: WHERE invoice_id = p_invoice_id;
2217:
2218: l_debug_info := 'Updating payment schedules due a manual withholding tax';
2219:

Line 2222: update ap_payment_schedules

2218: l_debug_info := 'Updating payment schedules due a manual withholding tax';
2219:
2220: IF ((l_inv_amt_remaining <> 0) AND (p_manual_withhold_amount is not null))
2221: THEN
2222: update ap_payment_schedules
2223: set amount_remaining = (amount_remaining +
2224: ap_utilities_pkg.ap_round_currency(
2225: (amount_remaining * (p_manual_withhold_amount/l_inv_amt_remaining)
2226: * l_payment_cross_rate), l_payment_currency_code))

Line 2231: update ap_payment_schedules

2227: where invoice_id = p_invoice_id;
2228:
2229: ELSIF ((l_inv_amt_remaining = 0) and (p_manual_withhold_amount is not null))
2230: THEN
2231: update ap_payment_schedules
2232: set amount_remaining = (amount_remaining +
2233: ap_utilities_pkg.ap_round_currency(
2234: (gross_amount * (p_manual_withhold_amount/l_gross_amount)
2235: * l_payment_cross_rate), l_payment_currency_code)),