APPS.AP_MATCHING_UTILS_PKG dependencies on AP_PREPAY_UTILS_PKG

Line 1320: AP_Prepay_Utils_Pkg.Get_Ln_Prep_Amt_Remain_Recoup(

1316: SELECT ai.invoice_id prepayment_invoice_id,
1317: ai.invoice_num prepayment_invoice_num,
1318: ail.line_number prepayment_line_number,
1319: decode(pll.payment_type,'ADVANCE',2,1) prepayment_order_number,
1320: AP_Prepay_Utils_Pkg.Get_Ln_Prep_Amt_Remain_Recoup(
1321: ai.invoice_id,ail.line_number) prepay_amount_remaining,
1322: max(aip.accounting_date) prepayment_payment_date
1323: FROM ap_invoices ai,
1324: ap_invoice_lines ail,

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

1329: AND ai.invoice_type_lookup_code = 'PREPAYMENT'
1330: AND ail.line_type_lookup_code = 'ITEM'
1331: AND pll.po_line_id = p_po_line_id
1332: AND pll.payment_type IS NOT NULL
1333: AND AP_PREPAY_UTILS_PKG.Get_Ln_Prep_Amt_Remain_Recoup(ai.invoice_id,ail.line_number) > 0
1334: AND NVL(aip.reversal_flag,'N') <> 'Y' -- Added for bug 8340944
1335: AND aip.invoice_id = ai.invoice_id
1336: AND pll.line_location_id = ail.po_line_location_id
1337: --bugfix:4880825 removed '+1' from the NVL condition

Line 1474: l_is_line_locked := AP_PREPAY_UTILS_PKG.Is_Line_Locked (

1470: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1471: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1472: END IF;
1473:
1474: l_is_line_locked := AP_PREPAY_UTILS_PKG.Is_Line_Locked (
1475: l_prepayment_invoice_id,
1476: l_prepayment_line_number,
1477: NULL);
1478:

Line 1485: l_lock_result := AP_PREPAY_UTILS_PKG.Lock_Line(

1481: l_debug_info := 'Lock the Prepayment Invoice - Item line for this recoupment';
1482: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1483: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1484: END IF;
1485: l_lock_result := AP_PREPAY_UTILS_PKG.Lock_Line(
1486: l_prepayment_invoice_id,
1487: l_prepayment_line_number,
1488: NULL);
1489: