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_BR_REMIT_IMPORT_API_PUB dependencies on AR_PAYMENT_SCHEDULES

Line 25: PROCEDURE Dummy_Remittance (p_reserved_value ar_payment_schedules.reserved_value%TYPE,x_return_status IN OUT NOCOPY VARCHAR2) is

21: | routine ARP_BR_REMIT_BATCHES.cancel_remit(p_reserved_value,l_batch_applied_status). |
22: | |
23: |---------------------------------------------------------------------------------------------------------------------------*/
24:
25: PROCEDURE Dummy_Remittance (p_reserved_value ar_payment_schedules.reserved_value%TYPE,x_return_status IN OUT NOCOPY VARCHAR2) is
26: count_brs number;
27: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;
28: BEGIN
29: --Check if the remittance is empty, i.e. has no Br's assiged to i,

Line 66: p_reserved_value OUT NOCOPY AR_PAYMENT_SCHEDULES.reserved_value%TYPE,

62: | DESCRIPTION : |
63: | Check that the BR is assigned to an approved remittance. |
64: |---------------------------------------------------------------------------------------------------------------------------*/
65: PROCEDURE Check_BR_and_Batch_Status (p_internal_reference IN RA_CUSTOMER_TRX.Customer_trx_id%TYPE,
66: p_reserved_value OUT NOCOPY AR_PAYMENT_SCHEDULES.reserved_value%TYPE,
67: p_payment_schedule_id OUT NOCOPY AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
68: p_media_reference OUT NOCOPY AR_BATCHES.media_reference%TYPE)
69: is
70:

Line 67: p_payment_schedule_id OUT NOCOPY AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,

63: | Check that the BR is assigned to an approved remittance. |
64: |---------------------------------------------------------------------------------------------------------------------------*/
65: PROCEDURE Check_BR_and_Batch_Status (p_internal_reference IN RA_CUSTOMER_TRX.Customer_trx_id%TYPE,
66: p_reserved_value OUT NOCOPY AR_PAYMENT_SCHEDULES.reserved_value%TYPE,
67: p_payment_schedule_id OUT NOCOPY AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
68: p_media_reference OUT NOCOPY AR_BATCHES.media_reference%TYPE)
69: is
70:
71: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;

Line 87: from ar_payment_schedules

83: select max(reserved_value), -- remittance batch id null check
84: max(payment_schedule_id)
85: into p_reserved_value,
86: p_payment_schedule_id
87: from ar_payment_schedules
88: where customer_trx_id = p_internal_reference
89: and reserved_type = 'REMITTANCE';
90:
91: IF p_reserved_value is null THEN

Line 167: l_reserved_value ar_payment_schedules.reserved_value%TYPE;

163: l_batch_date ar_batches.batch_date%TYPE;
164: l_receipt_method_id ar_batches.receipt_method_id%TYPE;
165: l_remit_method_code ar_batches.remit_method_code%TYPE;
166: l_media_reference ar_batches.media_reference%TYPE;
167: l_reserved_value ar_payment_schedules.reserved_value%TYPE;
168: l_count NUMBER;
169: l_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
170: l_payment_method ar_receipt_methods.name%TYPE;
171: l_bank_account_num ce_bank_accounts.bank_account_num%TYPE;

Line 169: l_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;

165: l_remit_method_code ar_batches.remit_method_code%TYPE;
166: l_media_reference ar_batches.media_reference%TYPE;
167: l_reserved_value ar_payment_schedules.reserved_value%TYPE;
168: l_count NUMBER;
169: l_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
170: l_payment_method ar_receipt_methods.name%TYPE;
171: l_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
172:
173: BEGIN

Line 325: l_reserved_value AR_PAYMENT_SCHEDULES.reserved_value%TYPE;

321: x_return_status IN OUT NOCOPY VARCHAR2
322: ) IS
323:
324: l_media_reference AR_BATCHES.media_reference%TYPE;
325: l_reserved_value AR_PAYMENT_SCHEDULES.reserved_value%TYPE;
326: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
327: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;
328: l_batch_id AR_BATCHES.batch_id%TYPE;
329:

Line 326: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;

322: ) IS
323:
324: l_media_reference AR_BATCHES.media_reference%TYPE;
325: l_reserved_value AR_PAYMENT_SCHEDULES.reserved_value%TYPE;
326: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
327: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;
328: l_batch_id AR_BATCHES.batch_id%TYPE;
329:
330: Invalid_Br Exception;

Line 414: l_reserved_value ar_payment_schedules.reserved_value%TYPE;

410: l_auto_print_program_id ar_receipt_methods.auto_print_program_id%TYPE;
411: l_auto_trans_program_id ar_receipt_methods.auto_trans_program_id%TYPE;
412: l_bank_branch_id ce_bank_branches_v.branch_party_id%TYPE;
413: l_payment_method ar_batches.receipt_method_id%TYPE;
414: l_reserved_value ar_payment_schedules.reserved_value%TYPE;
415: l_batch_id ar_batches.batch_id%TYPE := null;
416: l_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
417: l_receipt_method_id ra_customer_trx.receipt_method_id%TYPE;
418: l_remit_bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;

Line 416: l_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;

412: l_bank_branch_id ce_bank_branches_v.branch_party_id%TYPE;
413: l_payment_method ar_batches.receipt_method_id%TYPE;
414: l_reserved_value ar_payment_schedules.reserved_value%TYPE;
415: l_batch_id ar_batches.batch_id%TYPE := null;
416: l_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
417: l_receipt_method_id ra_customer_trx.receipt_method_id%TYPE;
418: l_remit_bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;
419: l_media_reference ar_batches.media_reference%TYPE;
420: