APPS.AP_MATCHING_UTILS_PKG dependencies on AP_PREPAY_UTILS_PKG

Line 1255: AP_Prepay_Utils_Pkg.Get_Ln_Prep_Amt_Remain_Recoup(

1251: SELECT ai.invoice_id prepayment_invoice_id,
1252: ai.invoice_num prepayment_invoice_num,
1253: ail.line_number prepayment_line_number,
1254: decode(pll.payment_type,'ADVANCE',2,1) prepayment_order_number,
1255: AP_Prepay_Utils_Pkg.Get_Ln_Prep_Amt_Remain_Recoup(
1256: ai.invoice_id,ail.line_number) prepay_amount_remaining,
1257: max(aip.accounting_date) prepayment_payment_date
1258: FROM ap_invoices ai,
1259: ap_invoice_lines ail,

Line 1268: AND AP_PREPAY_UTILS_PKG.Get_Ln_Prep_Amt_Remain_Recoup(ai.invoice_id,ail.line_number) > 0

1264: AND ai.invoice_type_lookup_code = 'PREPAYMENT'
1265: AND ail.line_type_lookup_code = 'ITEM'
1266: AND pll.po_line_id = p_po_line_id
1267: AND pll.payment_type IS NOT NULL
1268: AND AP_PREPAY_UTILS_PKG.Get_Ln_Prep_Amt_Remain_Recoup(ai.invoice_id,ail.line_number) > 0
1269: AND aip.invoice_id = ai.invoice_id
1270: AND pll.line_location_id = ail.po_line_location_id
1271: --bugfix:4880825 removed '+1' from the NVL condition
1272: AND nvl(ai.earliest_settlement_date,SYSDATE) <= SYSDATE

Line 1408: l_is_line_locked := AP_PREPAY_UTILS_PKG.Is_Line_Locked (

1404: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1405: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1406: END IF;
1407:
1408: l_is_line_locked := AP_PREPAY_UTILS_PKG.Is_Line_Locked (
1409: l_prepayment_invoice_id,
1410: l_prepayment_line_number,
1411: NULL);
1412:

Line 1419: l_lock_result := AP_PREPAY_UTILS_PKG.Lock_Line(

1415: l_debug_info := 'Lock the Prepayment Invoice - Item line for this recoupment';
1416: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1417: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1418: END IF;
1419: l_lock_result := AP_PREPAY_UTILS_PKG.Lock_Line(
1420: l_prepayment_invoice_id,
1421: l_prepayment_line_number,
1422: NULL);
1423: