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 210: ra_customer_trx ct

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

Line 280: UPDATE RA_CUSTOMER_TRX SET REVERSED_CASH_RECEIPT_ID = l_ps_rev_cash_id

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

Line 304: ra_customer_trx ct,

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

Line 729: ra_customer_trx ct

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

Line 773: ra_customer_trx ct,

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