DBA Data[Home] [Help]

APPS.AP_VOID_PKG dependencies on AP_CHECKS

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

229: l_unaccounted_row_count NUMBER;
230: l_old_accounting_event_id NUMBER(38);
231: l_postable_flag VARCHAR2(1);
232:
233: l_payment_type_flag ap_checks.payment_type_flag%TYPE; -- Bug3343314
234: l_amount ap_checks.amount%TYPE; -- Bug3343314
235: l_currency_code ap_checks.currency_code%TYPE; -- Bug3343314
236: l_exchange_rate_type ap_checks.exchange_rate_type%TYPE; -- Bug3343314
237: l_exchange_date ap_checks.exchange_date%TYPE; -- Bug3343314

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

230: l_old_accounting_event_id NUMBER(38);
231: l_postable_flag VARCHAR2(1);
232:
233: l_payment_type_flag ap_checks.payment_type_flag%TYPE; -- Bug3343314
234: l_amount ap_checks.amount%TYPE; -- Bug3343314
235: l_currency_code ap_checks.currency_code%TYPE; -- Bug3343314
236: l_exchange_rate_type ap_checks.exchange_rate_type%TYPE; -- Bug3343314
237: l_exchange_date ap_checks.exchange_date%TYPE; -- Bug3343314
238: l_exchange_rate ap_checks.exchange_rate%TYPE; -- Bug3343314

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

231: l_postable_flag VARCHAR2(1);
232:
233: l_payment_type_flag ap_checks.payment_type_flag%TYPE; -- Bug3343314
234: l_amount ap_checks.amount%TYPE; -- Bug3343314
235: l_currency_code ap_checks.currency_code%TYPE; -- Bug3343314
236: l_exchange_rate_type ap_checks.exchange_rate_type%TYPE; -- Bug3343314
237: l_exchange_date ap_checks.exchange_date%TYPE; -- Bug3343314
238: l_exchange_rate ap_checks.exchange_rate%TYPE; -- Bug3343314
239: l_base_amount ap_checks.base_amount%TYPE; -- Bug3343314

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

232:
233: l_payment_type_flag ap_checks.payment_type_flag%TYPE; -- Bug3343314
234: l_amount ap_checks.amount%TYPE; -- Bug3343314
235: l_currency_code ap_checks.currency_code%TYPE; -- Bug3343314
236: l_exchange_rate_type ap_checks.exchange_rate_type%TYPE; -- Bug3343314
237: l_exchange_date ap_checks.exchange_date%TYPE; -- Bug3343314
238: l_exchange_rate ap_checks.exchange_rate%TYPE; -- Bug3343314
239: l_base_amount ap_checks.base_amount%TYPE; -- Bug3343314
240:

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

233: l_payment_type_flag ap_checks.payment_type_flag%TYPE; -- Bug3343314
234: l_amount ap_checks.amount%TYPE; -- Bug3343314
235: l_currency_code ap_checks.currency_code%TYPE; -- Bug3343314
236: l_exchange_rate_type ap_checks.exchange_rate_type%TYPE; -- Bug3343314
237: l_exchange_date ap_checks.exchange_date%TYPE; -- Bug3343314
238: l_exchange_rate ap_checks.exchange_rate%TYPE; -- Bug3343314
239: l_base_amount ap_checks.base_amount%TYPE; -- Bug3343314
240:
241: --Bug 2840203 DBI logging

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

234: l_amount ap_checks.amount%TYPE; -- Bug3343314
235: l_currency_code ap_checks.currency_code%TYPE; -- Bug3343314
236: l_exchange_rate_type ap_checks.exchange_rate_type%TYPE; -- Bug3343314
237: l_exchange_date ap_checks.exchange_date%TYPE; -- Bug3343314
238: l_exchange_rate ap_checks.exchange_rate%TYPE; -- Bug3343314
239: l_base_amount ap_checks.base_amount%TYPE; -- Bug3343314
240:
241: --Bug 2840203 DBI logging
242: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;

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

235: l_currency_code ap_checks.currency_code%TYPE; -- Bug3343314
236: l_exchange_rate_type ap_checks.exchange_rate_type%TYPE; -- Bug3343314
237: l_exchange_date ap_checks.exchange_date%TYPE; -- Bug3343314
238: l_exchange_rate ap_checks.exchange_rate%TYPE; -- Bug3343314
239: l_base_amount ap_checks.base_amount%TYPE; -- Bug3343314
240:
241: --Bug 2840203 DBI logging
242: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;
243: l_dbi_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;

Line 281: FROM ap_checks

277: l_debug_info := 'Get Payment Type information';
278:
279: SELECT payment_type_flag
280: INTO l_netting_type
281: FROM ap_checks
282: WHERE check_id = p_check_id;
283:
284: ---------------------------------------------------------------------
285: -- Fix for bug 893626:

Line 617: ap_checks

613: l_exchange_rate,
614: l_base_amount,
615: l_org_id
616: FROM
617: ap_checks
618: WHERE
619: check_id = p_check_id;
620:
621: --------------------------------------------------------------------

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;