APPS.ARP_CASH_RECEIPT_HISTORY dependencies on AR_CASH_RECEIPT_HISTORY

Line 10: FROM ar_cash_receipt_history

6: l_CashReceiptHistoryId NUMBER(15);
7: BEGIN
8: SELECT cash_receipt_history_id
9: INTO l_CashReceiptHistoryId
10: FROM ar_cash_receipt_history
11: WHERE cash_receipt_id = p_CashReceiptId
12: AND current_record_flag = 'Y';
13: --
14: RETURN l_CashReceiptHistoryId;

Line 63: SELECT ar_cash_receipt_history_s.NEXTVAL

59: created_from VARCHAR2,
60: reversal_created_from VARCHAR2) RETURN NUMBER IS
61:
62: CURSOR get_crh_id IS
63: SELECT ar_cash_receipt_history_s.NEXTVAL
64: FROM dual;
65: --
66: crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
67: --

Line 66: crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

62: CURSOR get_crh_id IS
63: SELECT ar_cash_receipt_history_s.NEXTVAL
64: FROM dual;
65: --
66: crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
67: --
68: BEGIN
69:
70: /*---------------------------------*

Line 83: INSERT INTO AR_CASH_RECEIPT_HISTORY(CASH_RECEIPT_HISTORY_ID,

79: /*-----------------------*
80: | Insert the new record |
81: *-----------------------*/
82: --
83: INSERT INTO AR_CASH_RECEIPT_HISTORY(CASH_RECEIPT_HISTORY_ID,
84: AMOUNT,
85: ACCTD_AMOUNT,
86: CASH_RECEIPT_ID,
87: FACTOR_FLAG,

Line 167: p_table_name => 'AR_CASH_RECEIPT_HISTORY',

163: +-------------------------------------------*/
164:
165: ar_mrc_engine.maintain_mrc_data(
166: p_event_mode => 'INSERT',
167: p_table_name => 'AR_CASH_RECEIPT_HISTORY',
168: p_mode => 'SINGLE',
169: p_key_value => crh_id);
170:
171:

Line 190: UPDATE ar_cash_receipt_history

186: p_last_updated_by NUMBER,
187: p_last_update_date DATE,
188: p_last_update_login NUMBER) IS
189: BEGIN
190: UPDATE ar_cash_receipt_history
191: SET current_record_flag = '',
192: reversal_cash_receipt_hist_id = p_reversal_cash_rec_hist_id,
193: reversal_posting_control_id = -3,
194: reversal_gl_date = p_reversal_gl_date,

Line 208: p_table_name => 'AR_CASH_RECEIPT_HISTORY',

204: +----------------------------------------------------*/
205:
206: ar_mrc_engine.maintain_mrc_data(
207: p_event_mode => 'UPDATE',
208: p_table_name => 'AR_CASH_RECEIPT_HISTORY',
209: p_mode => 'SINGLE',
210: p_key_value => p_cash_receipt_history_id
211: );
212:

Line 228: UPDATE ar_cash_receipt_history

224: l_rec_hist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
225:
226:
227: BEGIN
228: UPDATE ar_cash_receipt_history
229: SET acctd_factor_discount_amount = acctd_fd_amt
230: WHERE cash_receipt_id = cr_id
231: AND current_record_flag = 'Y'
232: RETURNING cash_receipt_history_id

Line 242: p_table_name => 'AR_CASH_RECEIPT_HISTORY',

238: +---------------------------------*/
239:
240: ar_mrc_engine.maintain_mrc_data(
241: p_event_mode => 'UPDATE',
242: p_table_name => 'AR_CASH_RECEIPT_HISTORY',
243: p_mode => 'BULK',
244: p_key_value_list => l_rec_hist_key_value_list);
245:
246:

Line 262: UPDATE ar_cash_receipt_history

258:
259: l_rec_hist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
260:
261: BEGIN
262: UPDATE ar_cash_receipt_history
263: SET acctd_amount = acctd_amt
264: WHERE cash_receipt_id = cr_id
265: AND current_record_flag = 'Y'
266: RETURNING cash_receipt_history_id

Line 276: p_table_name => 'AR_CASH_RECEIPT_HISTORY',

272: +---------------------------------*/
273:
274: ar_mrc_engine.maintain_mrc_data(
275: p_event_mode => 'UPDATE',
276: p_table_name => 'AR_CASH_RECEIPT_HISTORY',
277: p_mode => 'BULK',
278: p_key_value_list => l_rec_hist_key_value_list);
279:
280: