eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_RECEIPT_API_PUB dependencies on RA_CUSTOMER_TRX

Line 1129: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,

1125: x_msg_data OUT NOCOPY VARCHAR2,
1126: -- Receipt application parameters.
1127: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
1128: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1129: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1130: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1131: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1132: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1133: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

Line 1130: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,

1126: -- Receipt application parameters.
1127: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
1128: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1129: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1130: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1131: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1132: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1133: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1134: -- this is the allocated receipt amount

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 1879: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,

1875: x_msg_data OUT NOCOPY VARCHAR2,
1876: -- Receipt application parameters.
1877: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
1878: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1879: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1880: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1881: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1882: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1883: -- LLCA Parameters

Line 1880: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,

1876: -- Receipt application parameters.
1877: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
1878: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1879: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1880: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1881: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1882: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1883: -- LLCA Parameters
1884: p_llca_type IN VARCHAR2 DEFAULT 'S',

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 2882: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,

2878: x_msg_data OUT NOCOPY VARCHAR2,
2879: -- *** Receipt Info. parameters *****
2880: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
2881: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
2882: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
2883: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
2884: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
2885: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
2886: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,

Line 2883: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,

2879: -- *** Receipt Info. parameters *****
2880: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
2881: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
2882: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
2883: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
2884: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
2885: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
2886: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
2887: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,

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 4458: l_customer_id ra_customer_trx.paying_customer_id%type;

4454: l_extension_id NUMBER;
4455: l_init_extension_id NUMBER;
4456: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
4457:
4458: l_customer_id ra_customer_trx.paying_customer_id%type;
4459: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;
4460: l_org_id ra_customer_trx.org_id%type;
4461: l_party_id hz_parties.party_id%type;
4462: l_trx_number ra_customer_trx.trx_number%type;

Line 4459: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;

4455: l_init_extension_id NUMBER;
4456: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
4457:
4458: l_customer_id ra_customer_trx.paying_customer_id%type;
4459: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;
4460: l_org_id ra_customer_trx.org_id%type;
4461: l_party_id hz_parties.party_id%type;
4462: l_trx_number ra_customer_trx.trx_number%type;
4463: l_payment_channel_code ar_receipt_methods.payment_channel_code%type;

Line 4460: l_org_id ra_customer_trx.org_id%type;

4456: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
4457:
4458: l_customer_id ra_customer_trx.paying_customer_id%type;
4459: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;
4460: l_org_id ra_customer_trx.org_id%type;
4461: l_party_id hz_parties.party_id%type;
4462: l_trx_number ra_customer_trx.trx_number%type;
4463: l_payment_channel_code ar_receipt_methods.payment_channel_code%type;
4464: l_customer_trx_id ra_customer_trx.customer_trx_id%type;

Line 4462: l_trx_number ra_customer_trx.trx_number%type;

4458: l_customer_id ra_customer_trx.paying_customer_id%type;
4459: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;
4460: l_org_id ra_customer_trx.org_id%type;
4461: l_party_id hz_parties.party_id%type;
4462: l_trx_number ra_customer_trx.trx_number%type;
4463: l_payment_channel_code ar_receipt_methods.payment_channel_code%type;
4464: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
4465:
4466:

Line 4464: l_customer_trx_id ra_customer_trx.customer_trx_id%type;

4460: l_org_id ra_customer_trx.org_id%type;
4461: l_party_id hz_parties.party_id%type;
4462: l_trx_number ra_customer_trx.trx_number%type;
4463: l_payment_channel_code ar_receipt_methods.payment_channel_code%type;
4464: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
4465:
4466:
4467: BEGIN
4468:

Line 4645: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,

4641: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
4642: -- ** OUT NOCOPY variables for Creating receipt
4643: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
4644: -- Receipt application parameters
4645: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
4646: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
4647: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
4648: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
4649: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

Line 4646: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,

4642: -- ** OUT NOCOPY variables for Creating receipt
4643: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
4644: -- Receipt application parameters
4645: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
4646: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
4647: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
4648: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
4649: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
4650: -- this is the allocated receipt amount

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,

Line 7064: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,

7060: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
7061: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
7062: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
7063: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
7064: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
7065: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
7066: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
7067: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
7068: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,