[Home] [Help]
2603: if( l_count > 0 ) then
2604: begin
2605: select cba.receipt_multi_currency_flag
2606: into l_flag
2607: from ce_bank_accounts cba, ce_bank_acct_uses_ALL ba,ar_receipt_classes rc,
2608: ar_receipt_methods rm,ar_receipt_method_accounts_ALL rma
2609: where rc.creation_method_code = 'NETTING'
2610: and rc.receipt_class_id = rm.receipt_class_id
2611: and ba.bank_account_id = cba.bank_account_id
3018: p_bank_acct_name,
3019: p_bank_acct_num,
3020: p_le_id,
3021: p_bank_num
3022: FROM ce_bank_acct_uses ac_use,
3023: ce_bank_accounts ac,
3024: ce_banks_v ba
3025: WHERE ac.bank_account_id = g_bank_account_id
3026: AND ac.bank_account_id = ac_use.bank_account_id
3247: END Validate_Settlement_Period;
3248: /* Creates AP Check per vendor / vendor site / currency . Also creates
3249: invoice payments for each AP Check */
3250: PROCEDURE settle_ap_invs(
3251: p_bank_acct_use_id IN ce_bank_acct_uses_all.bank_acct_use_id%TYPE,
3252: p_bank_acct_name IN ce_bank_accounts.bank_account_name%TYPE,
3253: p_bank_acct_num IN ce_bank_accounts.bank_account_num%TYPE,
3254: p_le_id IN xle_entity_profiles.legal_entity_id%TYPE,
3255: p_bank_num IN ce_banks_v.bank_number%TYPE,
4302: PROCEDURE settle_ar_txns(
4303: txnTable IN txnTblType,
4304: p_bank_acct_name IN ce_bank_accounts.bank_account_name%TYPE,
4305: p_bank_acct_num IN ce_bank_accounts.bank_account_num%TYPE,
4306: p_bank_acct_use_id IN ce_bank_acct_uses_all.bank_acct_use_id%TYPE,
4307: x_return_status OUT NOCOPY VARCHAR2,
4308: x_msg_data OUT NOCOPY VARCHAR2,
4309: x_msg_count OUT NOCOPY NUMBER)
4310: IS
4611: l_schd_tab pymt_sch_tab;
4612: l_status_flag VARCHAR2(1);
4613: l_return_status VARCHAR2(1);
4614: l_batch_status fun_net_batches_all.settlement_date%TYPE;
4615: l_bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;
4616: l_bank_acct_name ce_bank_accounts.bank_account_name%TYPE;
4617: l_bank_acct_num ce_bank_accounts.bank_account_num%TYPE;
4618: l_le_id xle_entity_profiles.legal_entity_id%TYPE;
4619: l_bank_num ce_banks_v.bank_number%TYPE;