APPS.AR_TRX_SUMMARY_PKG dependencies on AR_TRX_BAL_SUMMARY

Line 55: MERGE INTO ar_trx_bal_summary t

51: EXECUTE IMMEDIATE 'alter session enable parallel dml';
52: EXECUTE IMMEDIATE 'alter session force parallel query';
53:
54: /* 8713252 - Changed from INSERT to MERGE */
55: MERGE INTO ar_trx_bal_summary t
56: USING (SELECT D.CUSTOMER_ID,
57: D.CUSTOMER_SITE_USE_ID,
58: D.CURRENCY_CODE,
59: D.ORG_ID,

Line 255: merge into AR_TRX_BAL_SUMMARY t

251: /* 8713252 - Now update last_payment_amounts */
252:
253: /* 8784962 - Added WHEN NOT MATCHED to meet 9i requirements,
254: that code should never execute */
255: merge into AR_TRX_BAL_SUMMARY t
256: using (SELECT
257: A1.CUSTOMER_ID,
258: A1.CUSTOMER_SITE_USE_ID,
259: A1.CURRENCY,

Line 353: merge into AR_TRX_BAL_SUMMARY t

349: /* We have to issue a commit or the next statement will
350: raise an ORA-12838 */
351: COMMIT;
352:
353: merge into AR_TRX_BAL_SUMMARY t
354: using (SELECT CR.PAY_FROM_CUSTOMER CUSTOMER_ID,
355: NVL(CR.CUSTOMER_SITE_USE_ID,-99) CUSTOMER_SITE_USE_ID,
356: CR.CURRENCY_CODE CURRENCY,
357: CR.ORG_ID ORG_ID,

Line 1168: /* The processing of ar_trx_bal_summary requires all customers,

1164: arp_standard.debug('arp_trx_summary_pkg.collect_customers()+');
1165: arp_standard.debug(' p_worker_number = ' || p_worker_number);
1166: arp_standard.debug(' p_list_size = ' || p_list_size);
1167:
1168: /* The processing of ar_trx_bal_summary requires all customers,
1169: but the one for ar_trx_summary only requires active customers.
1170: So we can rebuild the list for each table separately and
1171: significantly cust the discarded data from the ar_trx_summary
1172: routine(s) */

Line 1215: ar_trx_summary or both ar_trx_bal_summary and ar_trx_summary.

1211: END collect_customers;
1212:
1213:
1214: /* 8784962 - Allow for call to this function that only clears
1215: ar_trx_summary or both ar_trx_bal_summary and ar_trx_summary.
1216:
1217: legal values are A(all), B(bal only), S(summary only) */
1218:
1219: PROCEDURE clear_summary_tables(p_table_to_clear IN VARCHAR2) IS

Line 1248: EXECUTE IMMEDIATE 'truncate table ' || l_schema || '.AR_TRX_BAL_SUMMARY';

1244: arp_standard.debug('truncating table data');
1245: END IF;
1246: IF p_table_to_clear IN ('A','B')
1247: THEN
1248: EXECUTE IMMEDIATE 'truncate table ' || l_schema || '.AR_TRX_BAL_SUMMARY';
1249: END IF;
1250:
1251: IF p_table_to_clear IN ('A','S')
1252: THEN

Line 1267: DELETE FROM AR_TRX_BAL_SUMMARY

1263: arp_standard.debug('ar_trx_summary_pkg.clear_summary_by_customer()+');
1264: END IF;
1265:
1266: FORALL i IN 1..p_cust_id.COUNT
1267: DELETE FROM AR_TRX_BAL_SUMMARY
1268: WHERE cust_account_id = p_cust_id(i);
1269:
1270: FORALL i IN 1..p_cust_id.COUNT
1271: DELETE FROM AR_TRX_SUMMARY

Line 1382: INSERT INTO AR_TRX_BAL_SUMMARY

1378: arp_standard.debug('ar_trx_summary_pkg.load_trx_bal_summary()+');
1379: END IF;
1380:
1381: FORALL i IN 1..p_cust_id.COUNT
1382: INSERT INTO AR_TRX_BAL_SUMMARY
1383: (CUST_ACCOUNT_ID,
1384: SITE_USE_ID,
1385: CURRENCY,
1386: ORG_ID,