APPS.ARP_AUTOMATIC_CLEARING_PKG dependencies on AR_AUTOCLEAR_INTERIM

Line 1157: from ar_autoclear_interim

1153: END IF;
1154: BEGIN
1155: select count(*)
1156: into l_count
1157: from ar_autoclear_interim
1158: where request_id = l_master_request_id;
1159: EXCEPTION
1160: WHEN OTHERS THEN
1161: fnd_file.put_line( FND_FILE.LOG, SQLERRM);

Line 1202: DELETE FROM ar_autoclear_interim

1198: arp_util.debug('Worker # '|| i||' completed successfully');
1199: END IF;
1200:
1201: END LOOP;
1202: DELETE FROM ar_autoclear_interim
1203: WHERE request_id = l_master_request_id;
1204: commit;
1205: END IF;
1206:

Line 1274: statement := 'INSERT INTO ar_autoclear_interim

1270: fnd_file.put_line( FND_FILE.LOG, 'populate_interim_table()+');
1271: select set_of_books_id INTO v_set_of_bks_id from ar_system_parameters;
1272: --
1273: IF ( remitted_or_factored_or_risk = 1) 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 = 2) THEN
1302: statement := 'INSERT INTO ar_autoclear_interim
1303: ( cash_receipt_id,
1304: trx_date,
1305: gl_date,
1306: exchange_date,

Line 1330: statement := 'INSERT INTO ar_autoclear_interim

1326: p_request_id );
1327: END IF;
1328: --
1329: IF ( remitted_or_factored_or_risk = 3) THEN
1330: statement := 'INSERT INTO ar_autoclear_interim
1331: ( cash_receipt_id,
1332: trx_date,
1333: gl_date,
1334: module_name,

Line 1430: 'ar_autoclear_interim ' ||

1426: ' module_name, ' ||
1427: ' module_version, ' ||
1428: 'cash_receipt_history_id ' ||
1429: 'from ' ||
1430: 'ar_autoclear_interim ' ||
1431: 'where ' ||
1432: 'request_id = :b_request_id ' ||
1433: 'and current_worker = :b_worker_number '||
1434: 'and type = ''RISK'' ';

Line 1478: 'ar_autoclear_interim ' ||

1474: 'crh_factor_discount_amount, ' ||
1475: 'cr_currency_code, ' ||
1476: 'exchange_rate_old ' ||
1477: 'from ' ||
1478: 'ar_autoclear_interim ' ||
1479: 'where ' ||
1480: 'request_id = :b_request_id ' ||
1481: 'and current_worker = :b_worker_number '||
1482: 'and type = ''FACTOR'' ';

Line 1524: 'ar_autoclear_interim ' ||

1520: 'crh_factor_discount_amount, ' ||
1521: 'cr_currency_code, ' ||
1522: 'exchange_rate_old ' ||
1523: 'from ' ||
1524: 'ar_autoclear_interim ' ||
1525: 'where ' ||
1526: 'request_id = :b_request_id ' ||
1527: 'and current_worker = :b_worker_number '||
1528: 'and type = ''REMIT'' ';