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_BATCHES

Line 27: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;

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,
30:
31: arp_standard.debug ('impremapi.dummy_remittance()+');

Line 41: from ar_batches

37: and current_record_flag = 'Y';
38:
39: select batch_applied_status
40: into l_batch_applied_status
41: from ar_batches
42: where batch_id = p_reserved_value;
43:
44: if count_brs = 0 and l_batch_applied_status in ('COMPLETED_CREATION','STARTED_CREATION') THEN
45: ARP_BR_REMIT_BATCHES.cancel_remit(p_reserved_value,l_batch_applied_status);

Line 68: p_media_reference OUT NOCOPY AR_BATCHES.media_reference%TYPE)

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;
72: l_status AR_BATCHES.status%TYPE;

Line 71: l_batch_applied_status AR_BATCHES.batch_applied_status%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;
72: l_status AR_BATCHES.status%TYPE;
73: Invalid_Remittance_Status Exception;
74:
75: BEGIN

Line 72: l_status AR_BATCHES.status%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;
72: l_status AR_BATCHES.status%TYPE;
73: Invalid_Remittance_Status Exception;
74:
75: BEGIN
76:

Line 102: from ar_batches

98: media_reference
99: into l_batch_applied_status,
100: l_status,
101: p_media_reference
102: from ar_batches
103: where batch_id = p_reserved_value
104: and type = 'BR_REMITTANCE';
105:
106: IF l_batch_applied_status NOT IN ('STARTED_CREATION','COMPLETED_CREATION') THEN

Line 147: p_media_reference IN ar_batches.media_reference%TYPE,

143: | |
144: | |
145: |----------------------------------------------------------------------------------------------------------------------------*/
146: PROCEDURE compare_old_versus_new_values (
147: p_media_reference IN ar_batches.media_reference%TYPE,
148: p_remittance_accounting_Date IN ar_batches.gl_date%TYPE,
149: p_remittance_method IN ar_batches.remit_method_code%TYPE,
150: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
151: p_payment_method IN ar_receipt_methods.name%TYPE,

Line 148: p_remittance_accounting_Date IN ar_batches.gl_date%TYPE,

144: | |
145: |----------------------------------------------------------------------------------------------------------------------------*/
146: PROCEDURE compare_old_versus_new_values (
147: p_media_reference IN ar_batches.media_reference%TYPE,
148: p_remittance_accounting_Date IN ar_batches.gl_date%TYPE,
149: p_remittance_method IN ar_batches.remit_method_code%TYPE,
150: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
151: p_payment_method IN ar_receipt_methods.name%TYPE,
152: p_remittance_date IN ar_batches.batch_date%TYPE,

Line 149: p_remittance_method IN ar_batches.remit_method_code%TYPE,

145: |----------------------------------------------------------------------------------------------------------------------------*/
146: PROCEDURE compare_old_versus_new_values (
147: p_media_reference IN ar_batches.media_reference%TYPE,
148: p_remittance_accounting_Date IN ar_batches.gl_date%TYPE,
149: p_remittance_method IN ar_batches.remit_method_code%TYPE,
150: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
151: p_payment_method IN ar_receipt_methods.name%TYPE,
152: p_remittance_date IN ar_batches.batch_date%TYPE,
153: p_Currency_code IN ar_batches.currency_code%TYPE,

Line 150: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,

146: PROCEDURE compare_old_versus_new_values (
147: p_media_reference IN ar_batches.media_reference%TYPE,
148: p_remittance_accounting_Date IN ar_batches.gl_date%TYPE,
149: p_remittance_method IN ar_batches.remit_method_code%TYPE,
150: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
151: p_payment_method IN ar_receipt_methods.name%TYPE,
152: p_remittance_date IN ar_batches.batch_date%TYPE,
153: p_Currency_code IN ar_batches.currency_code%TYPE,
154: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,

Line 152: p_remittance_date IN ar_batches.batch_date%TYPE,

148: p_remittance_accounting_Date IN ar_batches.gl_date%TYPE,
149: p_remittance_method IN ar_batches.remit_method_code%TYPE,
150: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
151: p_payment_method IN ar_receipt_methods.name%TYPE,
152: p_remittance_date IN ar_batches.batch_date%TYPE,
153: p_Currency_code IN ar_batches.currency_code%TYPE,
154: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
155: l_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
156: l_batch_id OUT NOCOPY ar_batches.batch_id%TYPE

Line 153: p_Currency_code IN ar_batches.currency_code%TYPE,

149: p_remittance_method IN ar_batches.remit_method_code%TYPE,
150: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
151: p_payment_method IN ar_receipt_methods.name%TYPE,
152: p_remittance_date IN ar_batches.batch_date%TYPE,
153: p_Currency_code IN ar_batches.currency_code%TYPE,
154: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
155: l_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
156: l_batch_id OUT NOCOPY ar_batches.batch_id%TYPE
157: ) IS

Line 155: l_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,

151: p_payment_method IN ar_receipt_methods.name%TYPE,
152: p_remittance_date IN ar_batches.batch_date%TYPE,
153: p_Currency_code IN ar_batches.currency_code%TYPE,
154: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
155: l_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
156: l_batch_id OUT NOCOPY ar_batches.batch_id%TYPE
157: ) IS
158:
159: l_remit_bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;

Line 156: l_batch_id OUT NOCOPY ar_batches.batch_id%TYPE

152: p_remittance_date IN ar_batches.batch_date%TYPE,
153: p_Currency_code IN ar_batches.currency_code%TYPE,
154: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
155: l_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
156: l_batch_id OUT NOCOPY ar_batches.batch_id%TYPE
157: ) IS
158:
159: l_remit_bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;
160: l_currency_code ar_batches.currency_code%TYPE;

Line 160: l_currency_code ar_batches.currency_code%TYPE;

156: l_batch_id OUT NOCOPY ar_batches.batch_id%TYPE
157: ) IS
158:
159: l_remit_bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;
160: l_currency_code ar_batches.currency_code%TYPE;
161: l_gl_date ar_batches.gl_date%type;
162: l_with_recourse_flag ar_batches.with_recourse_flag%TYPE;
163: l_batch_date ar_batches.batch_date%TYPE;
164: l_receipt_method_id ar_batches.receipt_method_id%TYPE;

Line 161: l_gl_date ar_batches.gl_date%type;

157: ) IS
158:
159: l_remit_bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;
160: l_currency_code ar_batches.currency_code%TYPE;
161: l_gl_date ar_batches.gl_date%type;
162: l_with_recourse_flag ar_batches.with_recourse_flag%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;

Line 162: l_with_recourse_flag ar_batches.with_recourse_flag%TYPE;

158:
159: l_remit_bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;
160: l_currency_code ar_batches.currency_code%TYPE;
161: l_gl_date ar_batches.gl_date%type;
162: l_with_recourse_flag ar_batches.with_recourse_flag%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;

Line 163: l_batch_date ar_batches.batch_date%TYPE;

159: l_remit_bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;
160: l_currency_code ar_batches.currency_code%TYPE;
161: l_gl_date ar_batches.gl_date%type;
162: l_with_recourse_flag ar_batches.with_recourse_flag%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;

Line 164: l_receipt_method_id ar_batches.receipt_method_id%TYPE;

160: l_currency_code ar_batches.currency_code%TYPE;
161: l_gl_date ar_batches.gl_date%type;
162: l_with_recourse_flag ar_batches.with_recourse_flag%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;

Line 165: l_remit_method_code ar_batches.remit_method_code%TYPE;

161: l_gl_date ar_batches.gl_date%type;
162: l_with_recourse_flag ar_batches.with_recourse_flag%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;

Line 166: l_media_reference ar_batches.media_reference%TYPE;

162: l_with_recourse_flag ar_batches.with_recourse_flag%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;

Line 199: from ar_batches

195: l_remit_method_code,
196: l_batch_applied_status,
197: l_batch_id
198:
199: from ar_batches
200: where media_reference = p_media_reference
201: and gl_date = p_remittance_accounting_Date
202: and type = 'BR_REMITTANCE';
203:

Line 312: p_media_reference IN ar_batches.media_reference%TYPE,

308: | |
309: |---------------------------------------------------------------------------------------------------------------------------*/
310:
311: PROCEDURE existing_remittance (
312: p_media_reference IN ar_batches.media_reference%TYPE,
313: p_remittance_accounting_Date IN ar_batches.gl_date%TYPE,
314: p_internal_reference IN ra_customer_trx.customer_trx_id%TYPE,
315: p_remittance_method IN ar_batches.remit_method_code%TYPE,
316: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,

Line 313: p_remittance_accounting_Date IN ar_batches.gl_date%TYPE,

309: |---------------------------------------------------------------------------------------------------------------------------*/
310:
311: PROCEDURE existing_remittance (
312: p_media_reference IN ar_batches.media_reference%TYPE,
313: p_remittance_accounting_Date IN ar_batches.gl_date%TYPE,
314: p_internal_reference IN ra_customer_trx.customer_trx_id%TYPE,
315: p_remittance_method IN ar_batches.remit_method_code%TYPE,
316: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
317: p_payment_method IN ar_receipt_methods.name%TYPE,

Line 315: p_remittance_method IN ar_batches.remit_method_code%TYPE,

311: PROCEDURE existing_remittance (
312: p_media_reference IN ar_batches.media_reference%TYPE,
313: p_remittance_accounting_Date IN ar_batches.gl_date%TYPE,
314: p_internal_reference IN ra_customer_trx.customer_trx_id%TYPE,
315: p_remittance_method IN ar_batches.remit_method_code%TYPE,
316: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
317: p_payment_method IN ar_receipt_methods.name%TYPE,
318: p_remittance_date IN ar_batches.batch_date%TYPE,
319: p_currency_code IN ar_batches.currency_code%TYPE,

Line 316: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,

312: p_media_reference IN ar_batches.media_reference%TYPE,
313: p_remittance_accounting_Date IN ar_batches.gl_date%TYPE,
314: p_internal_reference IN ra_customer_trx.customer_trx_id%TYPE,
315: p_remittance_method IN ar_batches.remit_method_code%TYPE,
316: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
317: p_payment_method IN ar_receipt_methods.name%TYPE,
318: p_remittance_date IN ar_batches.batch_date%TYPE,
319: p_currency_code IN ar_batches.currency_code%TYPE,
320: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,

Line 318: p_remittance_date IN ar_batches.batch_date%TYPE,

314: p_internal_reference IN ra_customer_trx.customer_trx_id%TYPE,
315: p_remittance_method IN ar_batches.remit_method_code%TYPE,
316: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
317: p_payment_method IN ar_receipt_methods.name%TYPE,
318: p_remittance_date IN ar_batches.batch_date%TYPE,
319: p_currency_code IN ar_batches.currency_code%TYPE,
320: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
321: x_return_status IN OUT NOCOPY VARCHAR2
322: ) IS

Line 319: p_currency_code IN ar_batches.currency_code%TYPE,

315: p_remittance_method IN ar_batches.remit_method_code%TYPE,
316: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
317: p_payment_method IN ar_receipt_methods.name%TYPE,
318: p_remittance_date IN ar_batches.batch_date%TYPE,
319: p_currency_code IN ar_batches.currency_code%TYPE,
320: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
321: x_return_status IN OUT NOCOPY VARCHAR2
322: ) IS
323:

Line 324: l_media_reference AR_BATCHES.media_reference%TYPE;

320: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%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;

Line 327: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;

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;
331: invalid_Remittance_status Exception;

Line 328: l_batch_id AR_BATCHES.batch_id%TYPE;

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;
331: invalid_Remittance_status Exception;
332:

Line 394: p_media_reference IN ar_batches.media_reference%TYPE,

390: | |
391: |---------------------------------------------------------------------------------------------------------------------------*/
392:
393: PROCEDURE new_remittance(
394: p_media_reference IN ar_batches.media_reference%TYPE,
395: p_remittance_accounting_date IN ar_batches.gl_date%TYPE,
396: p_remittance_Date IN ar_batches.batch_date%TYPE,
397: p_internal_reference IN ra_customer_trx.Customer_trx_id%TYPE,
398: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,

Line 395: p_remittance_accounting_date IN ar_batches.gl_date%TYPE,

391: |---------------------------------------------------------------------------------------------------------------------------*/
392:
393: PROCEDURE new_remittance(
394: p_media_reference IN ar_batches.media_reference%TYPE,
395: p_remittance_accounting_date IN ar_batches.gl_date%TYPE,
396: p_remittance_Date IN ar_batches.batch_date%TYPE,
397: p_internal_reference IN ra_customer_trx.Customer_trx_id%TYPE,
398: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
399: p_currency_code IN ar_batches.currency_code%TYPE,

Line 396: p_remittance_Date IN ar_batches.batch_date%TYPE,

392:
393: PROCEDURE new_remittance(
394: p_media_reference IN ar_batches.media_reference%TYPE,
395: p_remittance_accounting_date IN ar_batches.gl_date%TYPE,
396: p_remittance_Date IN ar_batches.batch_date%TYPE,
397: p_internal_reference IN ra_customer_trx.Customer_trx_id%TYPE,
398: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
399: p_currency_code IN ar_batches.currency_code%TYPE,
400: p_remittance_method IN ar_batches.remit_method_code%TYPE,

Line 398: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,

394: p_media_reference IN ar_batches.media_reference%TYPE,
395: p_remittance_accounting_date IN ar_batches.gl_date%TYPE,
396: p_remittance_Date IN ar_batches.batch_date%TYPE,
397: p_internal_reference IN ra_customer_trx.Customer_trx_id%TYPE,
398: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
399: p_currency_code IN ar_batches.currency_code%TYPE,
400: p_remittance_method IN ar_batches.remit_method_code%TYPE,
401: p_remittance_bnk_branch_number IN ce_bank_branches_v.branch_number%TYPE,
402: p_remittance_bank_number IN ce_bank_branches_v.bank_number%TYPE,

Line 399: p_currency_code IN ar_batches.currency_code%TYPE,

395: p_remittance_accounting_date IN ar_batches.gl_date%TYPE,
396: p_remittance_Date IN ar_batches.batch_date%TYPE,
397: p_internal_reference IN ra_customer_trx.Customer_trx_id%TYPE,
398: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
399: p_currency_code IN ar_batches.currency_code%TYPE,
400: p_remittance_method IN ar_batches.remit_method_code%TYPE,
401: p_remittance_bnk_branch_number IN ce_bank_branches_v.branch_number%TYPE,
402: p_remittance_bank_number IN ce_bank_branches_v.bank_number%TYPE,
403: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,

Line 400: p_remittance_method IN ar_batches.remit_method_code%TYPE,

396: p_remittance_Date IN ar_batches.batch_date%TYPE,
397: p_internal_reference IN ra_customer_trx.Customer_trx_id%TYPE,
398: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
399: p_currency_code IN ar_batches.currency_code%TYPE,
400: p_remittance_method IN ar_batches.remit_method_code%TYPE,
401: p_remittance_bnk_branch_number IN ce_bank_branches_v.branch_number%TYPE,
402: p_remittance_bank_number IN ce_bank_branches_v.bank_number%TYPE,
403: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
404: p_payment_method IN ar_receipt_methods.name%TYPE,

Line 405: x_batch_name OUT NOCOPY ar_batches.name%TYPE,

401: p_remittance_bnk_branch_number IN ce_bank_branches_v.branch_number%TYPE,
402: p_remittance_bank_number IN ce_bank_branches_v.bank_number%TYPE,
403: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
404: p_payment_method IN ar_receipt_methods.name%TYPE,
405: x_batch_name OUT NOCOPY ar_batches.name%TYPE,
406: x_return_status IN OUT NOCOPY VARCHAR2
407: ) IS
408:
409: l_receipt_class_id ar_receipt_methods.receipt_class_id%TYPE;

Line 413: l_payment_method ar_batches.receipt_method_id%TYPE;

409: l_receipt_class_id ar_receipt_methods.receipt_class_id%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;

Line 415: l_batch_id ar_batches.batch_id%TYPE := null;

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;
419: l_media_reference ar_batches.media_reference%TYPE;

Line 419: l_media_reference ar_batches.media_reference%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:
421: x_batch_id ar_batches.batch_id%TYPE;
422: x_batch_applied_status ar_batches.batch_applied_status%TYPE;
423:

Line 421: x_batch_id ar_batches.batch_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:
421: x_batch_id ar_batches.batch_id%TYPE;
422: x_batch_applied_status ar_batches.batch_applied_status%TYPE;
423:
424: CURSOR branch (p_bank_number NUMBER, p_branch_number NUMBER) IS
425: SELECT branch_party_id

Line 422: x_batch_applied_status ar_batches.batch_applied_status%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:
421: x_batch_id ar_batches.batch_id%TYPE;
422: x_batch_applied_status ar_batches.batch_applied_status%TYPE;
423:
424: CURSOR branch (p_bank_number NUMBER, p_branch_number NUMBER) IS
425: SELECT branch_party_id
426: FROM ce_bank_branches_v cbb

Line 601: FUNCTION Remittance_Exists (p_media_reference AR_BATCHES.media_reference%TYPE) return boolean

597: | |
598: | CALLS TO EXTERNAL PROCEDURES ; |
599: | |
600: |---------------------------------------------------------------------------------------------------------------------------*/
601: FUNCTION Remittance_Exists (p_media_reference AR_BATCHES.media_reference%TYPE) return boolean
602: IS
603:
604: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;
605: l_status AR_BATCHES.status%TYPE;

Line 604: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;

600: |---------------------------------------------------------------------------------------------------------------------------*/
601: FUNCTION Remittance_Exists (p_media_reference AR_BATCHES.media_reference%TYPE) return boolean
602: IS
603:
604: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;
605: l_status AR_BATCHES.status%TYPE;
606:
607: BEGIN
608:

Line 605: l_status AR_BATCHES.status%TYPE;

601: FUNCTION Remittance_Exists (p_media_reference AR_BATCHES.media_reference%TYPE) return boolean
602: IS
603:
604: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;
605: l_status AR_BATCHES.status%TYPE;
606:
607: BEGIN
608:
609: arp_standard.debug ('impremapi.remittance_Exists()+');

Line 616: from ar_batches

612: status
613: into
614: l_batch_applied_status,
615: l_status
616: from ar_batches
617: where media_reference = p_media_reference;
618:
619: IF l_batch_applied_status in ('STARTED_CREATION', 'COMPLETED_CREATION')
620: AND l_status in ('OP','NB') THEN

Line 666: p_media_reference IN ar_batches.media_reference%TYPE,

662: x_msg_data OUT NOCOPY VARCHAR2,
663: p_remittance_bank_number IN ce_bank_branches_v.bank_number%TYPE,
664: p_remittance_bnk_branch_number IN ce_bank_branches_v.branch_number%TYPE,
665: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
666: p_media_reference IN ar_batches.media_reference%TYPE,
667: p_remittance_method IN ar_batches.remit_method_code%TYPE,
668: -- 'STANDARD' , 'FACTORING' etc.
669: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
670: p_payment_method IN ar_receipt_methods.name%TYPE,

Line 667: p_remittance_method IN ar_batches.remit_method_code%TYPE,

663: p_remittance_bank_number IN ce_bank_branches_v.bank_number%TYPE,
664: p_remittance_bnk_branch_number IN ce_bank_branches_v.branch_number%TYPE,
665: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
666: p_media_reference IN ar_batches.media_reference%TYPE,
667: p_remittance_method IN ar_batches.remit_method_code%TYPE,
668: -- 'STANDARD' , 'FACTORING' etc.
669: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
670: p_payment_method IN ar_receipt_methods.name%TYPE,
671: p_remittance_date IN ar_batches.batch_date%TYPE,

Line 669: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,

665: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
666: p_media_reference IN ar_batches.media_reference%TYPE,
667: p_remittance_method IN ar_batches.remit_method_code%TYPE,
668: -- 'STANDARD' , 'FACTORING' etc.
669: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
670: p_payment_method IN ar_receipt_methods.name%TYPE,
671: p_remittance_date IN ar_batches.batch_date%TYPE,
672: p_remittance_accounting_date IN ar_batches.gl_date%TYPE,
673: p_currency_code IN ar_batches.currency_code%TYPE,

Line 671: p_remittance_date IN ar_batches.batch_date%TYPE,

667: p_remittance_method IN ar_batches.remit_method_code%TYPE,
668: -- 'STANDARD' , 'FACTORING' etc.
669: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
670: p_payment_method IN ar_receipt_methods.name%TYPE,
671: p_remittance_date IN ar_batches.batch_date%TYPE,
672: p_remittance_accounting_date IN ar_batches.gl_date%TYPE,
673: p_currency_code IN ar_batches.currency_code%TYPE,
674: p_internal_reference IN ra_customer_trx.Customer_trx_id%TYPE,
675: p_org_id IN Number default null,

Line 672: p_remittance_accounting_date IN ar_batches.gl_date%TYPE,

668: -- 'STANDARD' , 'FACTORING' etc.
669: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
670: p_payment_method IN ar_receipt_methods.name%TYPE,
671: p_remittance_date IN ar_batches.batch_date%TYPE,
672: p_remittance_accounting_date IN ar_batches.gl_date%TYPE,
673: p_currency_code IN ar_batches.currency_code%TYPE,
674: p_internal_reference IN ra_customer_trx.Customer_trx_id%TYPE,
675: p_org_id IN Number default null,
676: p_remittance_name OUT NOCOPY ar_batches.name%TYPE

Line 673: p_currency_code IN ar_batches.currency_code%TYPE,

669: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
670: p_payment_method IN ar_receipt_methods.name%TYPE,
671: p_remittance_date IN ar_batches.batch_date%TYPE,
672: p_remittance_accounting_date IN ar_batches.gl_date%TYPE,
673: p_currency_code IN ar_batches.currency_code%TYPE,
674: p_internal_reference IN ra_customer_trx.Customer_trx_id%TYPE,
675: p_org_id IN Number default null,
676: p_remittance_name OUT NOCOPY ar_batches.name%TYPE
677: ) IS

Line 676: p_remittance_name OUT NOCOPY ar_batches.name%TYPE

672: p_remittance_accounting_date IN ar_batches.gl_date%TYPE,
673: p_currency_code IN ar_batches.currency_code%TYPE,
674: p_internal_reference IN ra_customer_trx.Customer_trx_id%TYPE,
675: p_org_id IN Number default null,
676: p_remittance_name OUT NOCOPY ar_batches.name%TYPE
677: ) IS
678:
679: l_api_name CONSTANT VARCHAR2(30) := 'IMPREMAPI';
680: l_api_version CONSTANT NUMBER := 1.0;