DBA Data[Home] [Help]

APPS.AR_BR_REMIT_IMPORT_API_PUB dependencies on CE_BANK_BRANCHES_V

Line 401: p_remittance_bnk_branch_number IN ce_bank_branches_v.branch_number%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,
405: x_batch_name OUT NOCOPY ar_batches.name%TYPE,

Line 402: p_remittance_bank_number IN ce_bank_branches_v.bank_number%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,
405: x_batch_name OUT NOCOPY ar_batches.name%TYPE,
406: x_return_status IN OUT NOCOPY VARCHAR2

Line 412: l_bank_branch_id ce_bank_branches_v.branch_party_id%TYPE;

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;
416: l_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;

Line 426: FROM ce_bank_branches_v cbb

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
427: WHERE cbb.bank_number = p_bank_number
428: AND cbb.branch_number = p_branch_number;
429:
430: CURSOR account (p_branch_id NUMBER,

Line 663: p_remittance_bank_number IN ce_bank_branches_v.bank_number%TYPE,

659: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
660: x_return_status OUT NOCOPY VARCHAR2,
661: x_msg_count OUT NOCOPY NUMBER,
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,

Line 664: p_remittance_bnk_branch_number IN ce_bank_branches_v.branch_number%TYPE,

660: x_return_status OUT NOCOPY VARCHAR2,
661: x_msg_count OUT NOCOPY NUMBER,
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.