APPS.AP_VOID_PKG dependencies on AP_CHECKS_ALL

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;