eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_VOID_PKG dependencies on AP_CHECKS

Line 247: l_payment_type_flag ap_checks.payment_type_flag%TYPE; -- Bug3343314

243: l_unaccounted_row_count NUMBER;
244: l_old_accounting_event_id NUMBER(38);
245: l_postable_flag VARCHAR2(1);
246:
247: l_payment_type_flag ap_checks.payment_type_flag%TYPE; -- Bug3343314
248: l_amount ap_checks.amount%TYPE; -- Bug3343314
249: l_currency_code ap_checks.currency_code%TYPE; -- Bug3343314
250: l_exchange_rate_type ap_checks.exchange_rate_type%TYPE; -- Bug3343314
251: l_exchange_date ap_checks.exchange_date%TYPE; -- Bug3343314

Line 248: l_amount ap_checks.amount%TYPE; -- Bug3343314

244: l_old_accounting_event_id NUMBER(38);
245: l_postable_flag VARCHAR2(1);
246:
247: l_payment_type_flag ap_checks.payment_type_flag%TYPE; -- Bug3343314
248: l_amount ap_checks.amount%TYPE; -- Bug3343314
249: l_currency_code ap_checks.currency_code%TYPE; -- Bug3343314
250: l_exchange_rate_type ap_checks.exchange_rate_type%TYPE; -- Bug3343314
251: l_exchange_date ap_checks.exchange_date%TYPE; -- Bug3343314
252: l_exchange_rate ap_checks.exchange_rate%TYPE; -- Bug3343314

Line 249: l_currency_code ap_checks.currency_code%TYPE; -- Bug3343314

245: l_postable_flag VARCHAR2(1);
246:
247: l_payment_type_flag ap_checks.payment_type_flag%TYPE; -- Bug3343314
248: l_amount ap_checks.amount%TYPE; -- Bug3343314
249: l_currency_code ap_checks.currency_code%TYPE; -- Bug3343314
250: l_exchange_rate_type ap_checks.exchange_rate_type%TYPE; -- Bug3343314
251: l_exchange_date ap_checks.exchange_date%TYPE; -- Bug3343314
252: l_exchange_rate ap_checks.exchange_rate%TYPE; -- Bug3343314
253: l_base_amount ap_checks.base_amount%TYPE; -- Bug3343314

Line 250: l_exchange_rate_type ap_checks.exchange_rate_type%TYPE; -- Bug3343314

246:
247: l_payment_type_flag ap_checks.payment_type_flag%TYPE; -- Bug3343314
248: l_amount ap_checks.amount%TYPE; -- Bug3343314
249: l_currency_code ap_checks.currency_code%TYPE; -- Bug3343314
250: l_exchange_rate_type ap_checks.exchange_rate_type%TYPE; -- Bug3343314
251: l_exchange_date ap_checks.exchange_date%TYPE; -- Bug3343314
252: l_exchange_rate ap_checks.exchange_rate%TYPE; -- Bug3343314
253: l_base_amount ap_checks.base_amount%TYPE; -- Bug3343314
254:

Line 251: l_exchange_date ap_checks.exchange_date%TYPE; -- Bug3343314

247: l_payment_type_flag ap_checks.payment_type_flag%TYPE; -- Bug3343314
248: l_amount ap_checks.amount%TYPE; -- Bug3343314
249: l_currency_code ap_checks.currency_code%TYPE; -- Bug3343314
250: l_exchange_rate_type ap_checks.exchange_rate_type%TYPE; -- Bug3343314
251: l_exchange_date ap_checks.exchange_date%TYPE; -- Bug3343314
252: l_exchange_rate ap_checks.exchange_rate%TYPE; -- Bug3343314
253: l_base_amount ap_checks.base_amount%TYPE; -- Bug3343314
254:
255: --Bug 2840203 DBI logging

Line 252: l_exchange_rate ap_checks.exchange_rate%TYPE; -- Bug3343314

248: l_amount ap_checks.amount%TYPE; -- Bug3343314
249: l_currency_code ap_checks.currency_code%TYPE; -- Bug3343314
250: l_exchange_rate_type ap_checks.exchange_rate_type%TYPE; -- Bug3343314
251: l_exchange_date ap_checks.exchange_date%TYPE; -- Bug3343314
252: l_exchange_rate ap_checks.exchange_rate%TYPE; -- Bug3343314
253: l_base_amount ap_checks.base_amount%TYPE; -- Bug3343314
254:
255: --Bug 2840203 DBI logging
256: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;

Line 253: l_base_amount ap_checks.base_amount%TYPE; -- Bug3343314

249: l_currency_code ap_checks.currency_code%TYPE; -- Bug3343314
250: l_exchange_rate_type ap_checks.exchange_rate_type%TYPE; -- Bug3343314
251: l_exchange_date ap_checks.exchange_date%TYPE; -- Bug3343314
252: l_exchange_rate ap_checks.exchange_rate%TYPE; -- Bug3343314
253: l_base_amount ap_checks.base_amount%TYPE; -- Bug3343314
254:
255: --Bug 2840203 DBI logging
256: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;
257: l_dbi_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;

Line 402: FROM ap_checks

398: END IF;
399:
400: SELECT payment_type_flag
401: INTO l_netting_type
402: FROM ap_checks
403: WHERE check_id = p_check_id;
404:
405: ---------------------------------------------------------------------
406: -- Fix for bug 893626:

Line 768: ap_checks

764: l_exchange_rate,
765: l_base_amount,
766: l_org_id
767: FROM
768: ap_checks
769: WHERE
770: check_id = p_check_id;
771:
772: --------------------------------------------------------------------

Line 1326: UPDATE ap_checks_all

1322: -- bug6634891
1323:
1324: IF l_netting_type = 'N' THEN
1325:
1326: UPDATE ap_checks_all
1327: SET status_lookup_code = 'VOIDED',
1328: void_date = P_reversal_date
1329: WHERE check_id = p_check_id;
1330:

Line 1337: l_debug_info := 'Selecting the IBY payment id from ap_checks_all';

1333:
1334: IF (p_calling_module <> 'IBY') AND (l_payment_type_flag NOT IN ('R','N'))
1335: THEN
1336:
1337: l_debug_info := 'Selecting the IBY payment id from ap_checks_all';
1338: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1339: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1340: END IF;
1341:

Line 1345: FROM AP_CHECKS_ALL

1341:
1342: BEGIN
1343: SELECT payment_id
1344: INTO l_payment_id
1345: FROM AP_CHECKS_ALL
1346: WHERE check_id = p_check_id;
1347: EXCEPTION
1348: WHEN NO_DATA_FOUND THEN
1349: null;

Line 1452: l_checkrun_name ap_checks_all.checkrun_name%type;

1448: l_num_not_cancelled NUMBER;
1449: l_gl_date DATE;
1450: l_check_id NUMBER;
1451: -- bug# 6643035 l_checkrun_name is changed to database column type
1452: l_checkrun_name ap_checks_all.checkrun_name%type;
1453: l_org_id NUMBER;
1454: l_debug_info VARCHAR2(2000);
1455:
1456: BEGIN

Line 1497: FROM AP_CHECKS_ALL

1493: org_id
1494: INTO l_check_id,
1495: l_checkrun_name,
1496: l_org_id
1497: FROM AP_CHECKS_ALL
1498: WHERE payment_id = p_payment_id;
1499: EXCEPTION
1500: WHEN NO_DATA_FOUND THEN
1501: l_check_id := NULL;

Line 1571: UPDATE AP_CHECKS_ALL

1567: END IF;
1568:
1569: /* Bug 5407058 */
1570: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1571: UPDATE AP_CHECKS_ALL
1572: SET status_lookup_code = 'VOIDED'
1573: ,void_date = l_reversal_date
1574: WHERE check_id = l_check_id;
1575: END IF;