APPS.ARP_AUTOMATIC_CLEARING_PKG dependencies on AR_AUTOCLEAR_INTERIM

Line 1129: from ar_autoclear_interim

1125: END IF;
1126: BEGIN
1127: select count(*)
1128: into l_count
1129: from ar_autoclear_interim
1130: where request_id = l_master_request_id;
1131: EXCEPTION
1132: WHEN OTHERS THEN
1133: fnd_file.put_line( FND_FILE.LOG, SQLERRM);

Line 1174: DELETE FROM ar_autoclear_interim

1170: arp_util.debug('Worker # '|| i||' completed successfully');
1171: END IF;
1172:
1173: END LOOP;
1174: DELETE FROM ar_autoclear_interim
1175: WHERE request_id = l_master_request_id;
1176: commit;
1177: END IF;
1178:

Line 1246: statement := 'INSERT INTO ar_autoclear_interim

1242: fnd_file.put_line( FND_FILE.LOG, 'populate_interim_table()+');
1243: select set_of_books_id INTO v_set_of_bks_id from ar_system_parameters;
1244: --
1245: IF ( remitted_or_factored_or_risk = 1) THEN
1246: statement := 'INSERT INTO ar_autoclear_interim
1247: ( cash_receipt_id,
1248: trx_date,
1249: gl_date,
1250: exchange_date,

Line 1274: statement := 'INSERT INTO ar_autoclear_interim

1270: p_request_id );
1271: END IF;
1272: --
1273: IF ( remitted_or_factored_or_risk = 2) THEN
1274: statement := 'INSERT INTO ar_autoclear_interim
1275: ( cash_receipt_id,
1276: trx_date,
1277: gl_date,
1278: exchange_date,

Line 1302: statement := 'INSERT INTO ar_autoclear_interim

1298: p_request_id );
1299: END IF;
1300: --
1301: IF ( remitted_or_factored_or_risk = 3) THEN
1302: statement := 'INSERT INTO ar_autoclear_interim
1303: ( cash_receipt_id,
1304: trx_date,
1305: gl_date,
1306: module_name,

Line 1402: 'ar_autoclear_interim ' ||

1398: ' module_name, ' ||
1399: ' module_version, ' ||
1400: 'cash_receipt_history_id ' ||
1401: 'from ' ||
1402: 'ar_autoclear_interim ' ||
1403: 'where ' ||
1404: 'request_id = :b_request_id ' ||
1405: 'and current_worker = :b_worker_number '||
1406: 'and type = ''RISK'' ';

Line 1450: 'ar_autoclear_interim ' ||

1446: 'crh_factor_discount_amount, ' ||
1447: 'cr_currency_code, ' ||
1448: 'exchange_rate_old ' ||
1449: 'from ' ||
1450: 'ar_autoclear_interim ' ||
1451: 'where ' ||
1452: 'request_id = :b_request_id ' ||
1453: 'and current_worker = :b_worker_number '||
1454: 'and type = ''FACTOR'' ';

Line 1496: 'ar_autoclear_interim ' ||

1492: 'crh_factor_discount_amount, ' ||
1493: 'cr_currency_code, ' ||
1494: 'exchange_rate_old ' ||
1495: 'from ' ||
1496: 'ar_autoclear_interim ' ||
1497: 'where ' ||
1498: 'request_id = :b_request_id ' ||
1499: 'and current_worker = :b_worker_number '||
1500: 'and type = ''REMIT'' ';