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

1136: x_msg_data OUT NOCOPY VARCHAR2,
1137: -- Receipt application parameters.
1138: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
1139: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1140: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1141: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1142: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1143: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1144: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

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

1137: -- Receipt application parameters.
1138: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
1139: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1140: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1141: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1142: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1143: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1144: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1145: -- this is the allocated receipt amount

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

1149: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1150: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1151: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1152: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
1153: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
1154: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
1155: p_called_from IN VARCHAR2 DEFAULT NULL,
1156: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
1157: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,

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

1232: l_org_id NUMBER;
1233:
1234: -- LLCA
1235: l_llca_type varchar2(1) := NULL;
1236: l_group_id ra_customer_trx_lines.source_data_key4%TYPE := NULL;
1237: l_line_amount NUMBER;
1238: l_tax_amount NUMBER;
1239: l_freight_amount NUMBER;
1240: l_charges_amount NUMBER;

Line 1319: select COUNT(*) into l_gt from ra_customer_trx_lines_gt where customer_trx_id=p_customer_trx_id;

1315:
1316: IF(p_called_from = 'OZFAPI') THEN
1317:
1318: if ( FND_API.to_Boolean(p_commit) = FALSE ) then
1319: select COUNT(*) into l_gt from ra_customer_trx_lines_gt where customer_trx_id=p_customer_trx_id;
1320:
1321: IF (l_gt > 0 ) then
1322: delete FROM ra_customer_trx_lines_gt where customer_trx_id=p_customer_trx_id;
1323: end if;

Line 1322: delete FROM ra_customer_trx_lines_gt where customer_trx_id=p_customer_trx_id;

1318: if ( FND_API.to_Boolean(p_commit) = FALSE ) then
1319: select COUNT(*) into l_gt from ra_customer_trx_lines_gt where customer_trx_id=p_customer_trx_id;
1320:
1321: IF (l_gt > 0 ) then
1322: delete FROM ra_customer_trx_lines_gt where customer_trx_id=p_customer_trx_id;
1323: end if;
1324:
1325: end if;
1326: l_called_from := NULL;

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

1908: x_msg_data OUT NOCOPY VARCHAR2,
1909: -- Receipt application parameters.
1910: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
1911: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1912: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1913: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1914: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1915: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1916: -- LLCA Parameters

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

1909: -- Receipt application parameters.
1910: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
1911: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1912: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1913: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1914: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1915: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1916: -- LLCA Parameters
1917: p_llca_type IN VARCHAR2 DEFAULT 'S',

Line 2033: l_group_id ra_customer_trx_lines.source_data_key4%TYPE;

2029: l_freight_remaining NUMBER;
2030: l_rec_charges_charged NUMBER;
2031: l_rec_charges_remaining NUMBER;
2032: l_llca_type VARCHAR2(1);
2033: l_group_id ra_customer_trx_lines.source_data_key4%TYPE;
2034: l_sum_amount_applied NUMBER :=0;
2035: l_sum_disc_earn_allow NUMBER;
2036: l_sum_disc_max_allow NUMBER;
2037: l_llca_msg_data VARCHAR2(2000);

Line 2716: from ra_customer_trx_lines

2712: where source_id is null
2713: and nvl(current_activity_flag, 'Y') = 'Y' -- Bug 7241111
2714: and cash_receipt_id = l_cash_receipt_id
2715: and customer_trx_line_id in (select customer_trx_line_id
2716: from ra_customer_trx_lines
2717: where customer_trx_id = l_customer_trx_id);
2718:
2719: -- Clean the GT Table even though the table get refreshed in the commit stage.
2720: delete from ar_llca_trx_lines_gt

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

2924: x_msg_data OUT NOCOPY VARCHAR2,
2925: -- *** Receipt Info. parameters *****
2926: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
2927: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
2928: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
2929: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
2930: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
2931: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
2932: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,

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

2925: -- *** Receipt Info. parameters *****
2926: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
2927: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
2928: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
2929: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
2930: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
2931: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
2932: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
2933: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,

Line 3142: (select customer_trx_line_id from ra_customer_trx_lines

3138: /*
3139: delete from ar_activity_details ad
3140: where ad.cash_receipt_id = l_cash_receipt_id
3141: and ad.customer_trx_line_id in
3142: (select customer_trx_line_id from ra_customer_trx_lines
3143: where customer_trx_id = l_customer_trx_id);
3144: */
3145:
3146: -- Bug 7241111 to retain the old application record under activity details

Line 3249: from ra_customer_trx_lines

3245: where LLD.cash_receipt_id = l_cash_receipt_id
3246: and nvl(LLD.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y'
3247: and LLD.customer_trx_line_id in
3248: (select customer_trx_line_id
3249: from ra_customer_trx_lines
3250: where customer_trx_id = l_customer_trx_id);
3251:
3252: UPDATE ar_Activity_details dtl
3253: set CURRENT_ACTIVITY_FLAG = 'N'

Line 3258: from ra_customer_trx_lines

3254: where dtl.cash_receipt_id = l_cash_receipt_id
3255: and nvl(dtl.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y'
3256: and dtl.customer_trx_line_id in
3257: (select customer_trx_line_id
3258: from ra_customer_trx_lines
3259: where customer_trx_id = l_customer_trx_id);
3260:
3261:
3262:

Line 4585: l_customer_id ra_customer_trx.paying_customer_id%type;

4581: l_extension_id NUMBER;
4582: l_init_extension_id NUMBER;
4583: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
4584:
4585: l_customer_id ra_customer_trx.paying_customer_id%type;
4586: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;
4587: l_org_id ra_customer_trx.org_id%type;
4588: l_party_id hz_parties.party_id%type;
4589: l_trx_number ra_customer_trx.trx_number%type;

Line 4586: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;

4582: l_init_extension_id NUMBER;
4583: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
4584:
4585: l_customer_id ra_customer_trx.paying_customer_id%type;
4586: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;
4587: l_org_id ra_customer_trx.org_id%type;
4588: l_party_id hz_parties.party_id%type;
4589: l_trx_number ra_customer_trx.trx_number%type;
4590: l_payment_channel_code ar_receipt_methods.payment_channel_code%type;

Line 4587: l_org_id ra_customer_trx.org_id%type;

4583: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
4584:
4585: l_customer_id ra_customer_trx.paying_customer_id%type;
4586: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;
4587: l_org_id ra_customer_trx.org_id%type;
4588: l_party_id hz_parties.party_id%type;
4589: l_trx_number ra_customer_trx.trx_number%type;
4590: l_payment_channel_code ar_receipt_methods.payment_channel_code%type;
4591: l_customer_trx_id ra_customer_trx.customer_trx_id%type;

Line 4589: l_trx_number ra_customer_trx.trx_number%type;

4585: l_customer_id ra_customer_trx.paying_customer_id%type;
4586: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;
4587: l_org_id ra_customer_trx.org_id%type;
4588: l_party_id hz_parties.party_id%type;
4589: l_trx_number ra_customer_trx.trx_number%type;
4590: l_payment_channel_code ar_receipt_methods.payment_channel_code%type;
4591: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
4592:
4593: l_start_date DATE ;

Line 4591: l_customer_trx_id ra_customer_trx.customer_trx_id%type;

4587: l_org_id ra_customer_trx.org_id%type;
4588: l_party_id hz_parties.party_id%type;
4589: l_trx_number ra_customer_trx.trx_number%type;
4590: l_payment_channel_code ar_receipt_methods.payment_channel_code%type;
4591: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
4592:
4593: l_start_date DATE ;
4594: l_end_date DATE ;
4595:

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

4814: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
4815: -- ** OUT NOCOPY variables for Creating receipt
4816: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
4817: -- Receipt application parameters
4818: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
4819: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
4820: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
4821: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
4822: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

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

4815: -- ** OUT NOCOPY variables for Creating receipt
4816: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
4817: -- Receipt application parameters
4818: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
4819: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
4820: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
4821: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
4822: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
4823: -- this is the allocated receipt amount

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

4827: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
4828: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
4829: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
4830: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
4831: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
4832: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
4833: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
4834: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
4835: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,

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

7351: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
7352: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
7353: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
7354: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
7355: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
7356: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
7357: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
7358: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
7359: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,