APPS.AR_BUS_EVENT_COVER dependencies on AR_TRX_SUMMARY_HIST

Line 74: PROCEDURE p_insert_trx_sum_hist(p_trx_sum_hist_rec IN AR_TRX_SUMMARY_HIST%rowtype,

70: FND_GLOBAL.login_id);
71:
72: END insert_events_hist;
73:
74: PROCEDURE p_insert_trx_sum_hist(p_trx_sum_hist_rec IN AR_TRX_SUMMARY_HIST%rowtype,
75: p_history_id OUT NOCOPY NUMBER,
76: p_trx_type IN VARCHAR2,
77: p_event_type IN VARCHAR2 DEFAULT NULL)
78: IS

Line 84: FROM AR_TRX_SUMMARY_HIST

80: l_previous_history_id NUMBER;
81: l_history_id NUMBER;
82: CURSOR get_prev_hist_id (p_ps_id IN NUMBER) IS
83: SELECT max(history_id)
84: FROM AR_TRX_SUMMARY_HIST
85: WHERE payment_schedule_id = p_ps_id;
86:
87: BEGIN
88: OPEN get_prev_hist_id (p_trx_sum_hist_rec.payment_schedule_id);

Line 166: SELECT AR_TRX_SUMMARY_HIST_S.nextval

162: l_event_name := 'oracle.apps.ar.receipts.CashReceipt.Delete';
163: END IF;
164:
165:
166: SELECT AR_TRX_SUMMARY_HIST_S.nextval
167: INTO l_history_id
168: FROM dual;
169:
170: INSERT INTO AR_TRX_SUMMARY_HIST

Line 170: INSERT INTO AR_TRX_SUMMARY_HIST

166: SELECT AR_TRX_SUMMARY_HIST_S.nextval
167: INTO l_history_id
168: FROM dual;
169:
170: INSERT INTO AR_TRX_SUMMARY_HIST
171: (history_id,
172: last_update_date,
173: last_updated_by,
174: creation_date,

Line 1674: -- We do not need to create a history record in AR_TRX_SUMMARY_HIST for the

1670: l_event_name VARCHAR2(50) := 'oracle.apps.ar.batch.AutoAdjustments.run';
1671: BEGIN
1672:
1673: --
1674: -- We do not need to create a history record in AR_TRX_SUMMARY_HIST for the
1675: -- adjustments done against the transactions because of fllowing reasons:
1676: -- 1) The adjustment history is stored in AR_ADJUSTMENTS table
1677: -- 2) AR Subscription of no other core event would look at the adjustment.
1678: