APPS.ARP_PROCESS_HEADER_POST_COMMIT dependencies on RA_CUSTOMER_TRX

Line 88: ra_customer_trx.customer_trx_id%type,

84: +===========================================================================*/
85: PROCEDURE post_commit( p_form_name IN varchar2,
86: p_form_version IN number,
87: p_customer_trx_id IN
88: ra_customer_trx.customer_trx_id%type,
89: p_previous_customer_trx_id IN
90: ra_customer_trx.previous_customer_trx_id%type,
91: p_complete_flag IN
92: ra_customer_trx.complete_flag%type,

Line 90: ra_customer_trx.previous_customer_trx_id%type,

86: p_form_version IN number,
87: p_customer_trx_id IN
88: ra_customer_trx.customer_trx_id%type,
89: p_previous_customer_trx_id IN
90: ra_customer_trx.previous_customer_trx_id%type,
91: p_complete_flag IN
92: ra_customer_trx.complete_flag%type,
93: p_trx_open_receivables_flag IN
94: ra_cust_trx_types.accounting_affect_flag%type,

Line 92: ra_customer_trx.complete_flag%type,

88: ra_customer_trx.customer_trx_id%type,
89: p_previous_customer_trx_id IN
90: ra_customer_trx.previous_customer_trx_id%type,
91: p_complete_flag IN
92: ra_customer_trx.complete_flag%type,
93: p_trx_open_receivables_flag IN
94: ra_cust_trx_types.accounting_affect_flag%type,
95: p_prev_open_receivables_flag IN
96: ra_cust_trx_types.accounting_affect_flag%type,

Line 209: ra_customer_trx ct

205: l_ct_rev_cash_id
206: FROM ar_payment_schedules ps,
207: ra_cust_trx_types ctt,
208: ra_cust_trx_line_gl_dist lgd,
209: ra_customer_trx ct
210: WHERE ct.customer_trx_id = ps.customer_trx_id(+)
211: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
212: AND ct.customer_trx_id = lgd.customer_trx_id
213: AND lgd.account_class = 'REC'

Line 278: UPDATE RA_CUSTOMER_TRX SET REVERSED_CASH_RECEIPT_ID = l_ps_rev_cash_id

274: +-------------------------------------------------------*/
275:
276: /*3463885*/
277: IF l_ps_rev_cash_id is not null and l_ct_rev_cash_id is null THEN
278: UPDATE RA_CUSTOMER_TRX SET REVERSED_CASH_RECEIPT_ID = l_ps_rev_cash_id
279: WHERE CUSTOMER_TRX_ID = p_customer_trx_id;
280: END IF;
281:
282: arp_rounding.correct_scredit_rounding_errs( p_customer_trx_id,

Line 302: ra_customer_trx ct,

298: l_type,
299: l_initial_customer_trx_id,
300: l_previous_customer_trx_id
301: from
302: ra_customer_trx ct,
303: ra_cust_trx_types ctt
304: WHERE
305: ct.customer_trx_id = p_customer_trx_id
306: and

Line 727: ra_customer_trx ct

723: l_term_changed_flag
724: FROM ar_payment_schedules ps,
725: ra_cust_trx_types ctt,
726: ra_cust_trx_line_gl_dist lgd,
727: ra_customer_trx ct
728: WHERE ct.customer_trx_id = ps.customer_trx_id(+)
729: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
730: AND ct.customer_trx_id = lgd.customer_trx_id
731: AND lgd.account_class = 'REC'

Line 771: ra_customer_trx ct,

767: l_type,
768: l_initial_customer_trx_id,
769: l_previous_customer_trx_id
770: from
771: ra_customer_trx ct,
772: ra_cust_trx_types ctt
773: WHERE
774: ct.customer_trx_id = p_customer_trx_id
775: and