APPS.AR_RECEIPT_API_PUB dependencies on RA_CUSTOMER_TRX_LINES

Line 1142: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,

1138: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1139: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1140: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1141: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
1142: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
1143: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
1144: p_called_from IN VARCHAR2 DEFAULT NULL,
1145: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
1146: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,

Line 1225: l_group_id ra_customer_trx_lines.source_data_key4%TYPE := NULL;

1221: l_org_id NUMBER;
1222:
1223: -- LLCA
1224: l_llca_type varchar2(1) := NULL;
1225: l_group_id ra_customer_trx_lines.source_data_key4%TYPE := NULL;
1226: l_line_amount NUMBER;
1227: l_tax_amount NUMBER;
1228: l_freight_amount NUMBER;
1229: l_charges_amount NUMBER;

Line 2000: l_group_id ra_customer_trx_lines.source_data_key4%TYPE;

1996: l_freight_remaining NUMBER;
1997: l_rec_charges_charged NUMBER;
1998: l_rec_charges_remaining NUMBER;
1999: l_llca_type VARCHAR2(1);
2000: l_group_id ra_customer_trx_lines.source_data_key4%TYPE;
2001: l_sum_amount_applied NUMBER :=0;
2002: l_sum_disc_earn_allow NUMBER;
2003: l_sum_disc_max_allow NUMBER;
2004: l_llca_msg_data VARCHAR2(2000);

Line 2671: from ra_customer_trx_lines

2667: where source_id is null
2668: and nvl(current_activity_flag, 'Y') = 'Y' -- Bug 7241111
2669: and cash_receipt_id = l_cash_receipt_id
2670: and customer_trx_line_id in (select customer_trx_line_id
2671: from ra_customer_trx_lines
2672: where customer_trx_id = l_customer_trx_id);
2673:
2674: -- Clean the GT Table even though the table get refreshed in the commit stage.
2675: delete from ar_llca_trx_lines_gt

Line 3096: (select customer_trx_line_id from ra_customer_trx_lines

3092: /*
3093: delete from ar_activity_details ad
3094: where ad.cash_receipt_id = l_cash_receipt_id
3095: and ad.customer_trx_line_id in
3096: (select customer_trx_line_id from ra_customer_trx_lines
3097: where customer_trx_id = l_customer_trx_id);
3098: */
3099:
3100: -- Bug 7241111 to retain the old application record under activity details

Line 3203: from ra_customer_trx_lines

3199: where LLD.cash_receipt_id = l_cash_receipt_id
3200: and nvl(LLD.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y'
3201: and LLD.customer_trx_line_id in
3202: (select customer_trx_line_id
3203: from ra_customer_trx_lines
3204: where customer_trx_id = l_customer_trx_id);
3205:
3206: UPDATE ar_Activity_details dtl
3207: set CURRENT_ACTIVITY_FLAG = 'N'

Line 3212: from ra_customer_trx_lines

3208: where dtl.cash_receipt_id = l_cash_receipt_id
3209: and nvl(dtl.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y'
3210: and dtl.customer_trx_line_id in
3211: (select customer_trx_line_id
3212: from ra_customer_trx_lines
3213: where customer_trx_id = l_customer_trx_id);
3214:
3215:
3216:

Line 4658: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,

4654: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
4655: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
4656: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
4657: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
4658: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
4659: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
4660: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
4661: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
4662: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,