DBA Data[Home] [Help]

APPS.ARP_MISC_CD dependencies on AR_MISC_CASH_DISTRIBUTIONS

Line 33: SELECT AR_MISC_CASH_DISTRIBUTIONS_S.NEXTVAL

29: p_cash_receipt_history_id NUMBER DEFAULT NULL)
30: RETURN NUMBER
31: IS
32: CURSOR get_id IS
33: SELECT AR_MISC_CASH_DISTRIBUTIONS_S.NEXTVAL
34: FROM DUAL;
35: misc_id NUMBER;
36: BEGIN
37: arp_standard.debug('ins_misc_cash_distributions +');

Line 51: INSERT INTO AR_MISC_CASH_DISTRIBUTIONS(MISC_CASH_DISTRIBUTION_ID,

47: /*---------------*
48: | Insert Record |
49: *---------------*/
50:
51: INSERT INTO AR_MISC_CASH_DISTRIBUTIONS(MISC_CASH_DISTRIBUTION_ID,
52: LAST_UPDATED_BY,
53: LAST_UPDATE_DATE,
54: LAST_UPDATE_LOGIN,
55: CREATED_BY,

Line 164: UPDATE AR_MISC_CASH_DISTRIBUTIONS

160: ) IS
161: BEGIN
162: arp_standard.debug('upd_reversal_gl_date +');
163:
164: UPDATE AR_MISC_CASH_DISTRIBUTIONS
165: SET REVERSAL_GL_DATE = rev_gl_date,
166: LAST_UPDATED_BY = p_last_updated_by,
167: LAST_UPDATE_DATE = p_last_update_date,
168: LAST_UPDATE_LOGIN = p_last_update_login,