APPS.AP_VOID_PKG dependencies on AP_CHECKS_ALL

Line 1135: UPDATE ap_checks_all

1131: -- bug6634891
1132:
1133: IF l_netting_type = 'N' THEN
1134:
1135: UPDATE ap_checks_all
1136: SET status_lookup_code = 'VOIDED',
1137: void_date = P_reversal_date
1138: WHERE check_id = p_check_id;
1139:

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

1142:
1143: IF (p_calling_module <> 'IBY') AND (l_payment_type_flag NOT IN ('R','N'))
1144: THEN
1145:
1146: l_debug_info := 'Selecting the IBY payment id from ap_checks_all';
1147:
1148: BEGIN
1149: SELECT payment_id
1150: INTO l_payment_id

Line 1151: FROM AP_CHECKS_ALL

1147:
1148: BEGIN
1149: SELECT payment_id
1150: INTO l_payment_id
1151: FROM AP_CHECKS_ALL
1152: WHERE check_id = p_check_id;
1153: EXCEPTION
1154: WHEN NO_DATA_FOUND THEN
1155: null;

Line 1251: l_checkrun_name ap_checks_all.checkrun_name%type;

1247: l_num_not_cancelled NUMBER;
1248: l_gl_date DATE;
1249: l_check_id NUMBER;
1250: -- bug# 6643035 l_checkrun_name is changed to database column type
1251: l_checkrun_name ap_checks_all.checkrun_name%type;
1252: l_org_id NUMBER;
1253: l_debug_info VARCHAR2(2000);
1254:
1255: BEGIN

Line 1296: FROM AP_CHECKS_ALL

1292: org_id
1293: INTO l_check_id,
1294: l_checkrun_name,
1295: l_org_id
1296: FROM AP_CHECKS_ALL
1297: WHERE payment_id = p_payment_id;
1298: EXCEPTION
1299: WHEN NO_DATA_FOUND THEN
1300: l_check_id := NULL;

Line 1370: UPDATE AP_CHECKS_ALL

1366: END IF;
1367:
1368: /* Bug 5407058 */
1369: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1370: UPDATE AP_CHECKS_ALL
1371: SET status_lookup_code = 'VOIDED'
1372: ,void_date = l_reversal_date
1373: WHERE check_id = l_check_id;
1374: END IF;