DBA Data[Home] [Help]

APPS.AR_BR_REMIT_IMPORT_API_PUB dependencies on AR_RECEIPT_METHODS

Line 151: p_payment_method IN ar_receipt_methods.name%TYPE,

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,
155: l_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,

Line 170: l_payment_method ar_receipt_methods.name%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
174:

Line 252: from ar_receipt_methods

248: select name
249:
250: into l_payment_method
251:
252: from ar_receipt_methods
253: where receipt_method_id = l_receipt_method_id;
254:
255:
256: EXCEPTION

Line 317: p_payment_method IN ar_receipt_methods.name%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,
321: x_return_status IN OUT NOCOPY VARCHAR2

Line 404: p_payment_method IN ar_receipt_methods.name%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,
405: x_batch_name OUT NOCOPY ar_batches.name%TYPE,
406: x_return_status IN OUT NOCOPY VARCHAR2
407: ) IS
408:

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

Line 410: l_auto_print_program_id ar_receipt_methods.auto_print_program_id%TYPE;

406: x_return_status IN OUT NOCOPY VARCHAR2
407: ) IS
408:
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;

Line 411: l_auto_trans_program_id ar_receipt_methods.auto_trans_program_id%TYPE;

407: ) IS
408:
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;

Line 495: from ar_receipt_methods

491: into l_receipt_method_id
492: ,l_auto_print_program_id
493: ,l_auto_trans_program_id
494: ,l_receipt_class_id
495: from ar_receipt_methods
496: where name = p_payment_method;
497:
498: EXCEPTION
499: WHEN NO_DATA_FOUND THEN

Line 515: from ar_receipt_methods

511:
512: into l_auto_print_program_id,
513: l_auto_trans_program_id
514:
515: from ar_receipt_methods
516: where receipt_method_id = l_receipt_method_id;
517:
518:
519: EXCEPTION

Line 670: p_payment_method IN ar_receipt_methods.name%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,
674: p_internal_reference IN ra_customer_trx.Customer_trx_id%TYPE,