[Home] [Help]
1910: if( l_count > 0 ) then
1911: begin
1912: select cba.receipt_multi_currency_flag
1913: into l_flag
1914: from ce_bank_accounts cba, ce_bank_acct_uses_ALL ba,ar_receipt_classes rc,
1915: ar_receipt_methods rm,ar_receipt_method_accounts_ALL rma
1916: where rc.creation_method_code = 'NETTING'
1917: and rc.receipt_class_id = rm.receipt_class_id
1918: and ba.bank_account_id = cba.bank_account_id
2333: p_bank_acct_name,
2334: p_bank_acct_num,
2335: p_le_id,
2336: p_bank_num
2337: FROM ce_bank_acct_uses ac_use,
2338: ce_bank_accounts ac,
2339: ce_banks_v ba
2340: WHERE ac.bank_account_id = g_bank_account_id
2341: AND ac.bank_account_id = ac_use.bank_account_id
2565: /* Creates AP Check per vendor / vendor site / currency . Also creates
2566: invoice payments for each AP Check */
2567:
2568: PROCEDURE settle_ap_invs(
2569: p_bank_acct_use_id IN ce_bank_acct_uses_all.bank_acct_use_id%TYPE,
2570: p_bank_acct_name IN ce_bank_accounts.bank_account_name%TYPE,
2571: p_bank_acct_num IN ce_bank_accounts.bank_account_num%TYPE,
2572: p_le_id IN xle_entity_profiles.legal_entity_id%TYPE,
2573: p_bank_num IN ce_banks_v.bank_number%TYPE,
3694: PROCEDURE settle_ar_txns(
3695: txnTable IN txnTblType,
3696: p_bank_acct_name IN ce_bank_accounts.bank_account_name%TYPE,
3697: p_bank_acct_num IN ce_bank_accounts.bank_account_num%TYPE,
3698: p_bank_acct_use_id IN ce_bank_acct_uses_all.bank_acct_use_id%TYPE,
3699: x_return_status OUT NOCOPY VARCHAR2,
3700: x_msg_data OUT NOCOPY VARCHAR2,
3701: x_msg_count OUT NOCOPY NUMBER)
3702: IS
3955: l_schd_tab pymt_sch_tab;
3956: l_status_flag VARCHAR2(1);
3957: l_return_status VARCHAR2(1);
3958: l_batch_status fun_net_batches_all.settlement_date%TYPE;
3959: l_bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;
3960: l_bank_acct_name ce_bank_accounts.bank_account_name%TYPE;
3961: l_bank_acct_num ce_bank_accounts.bank_account_num%TYPE;
3962: l_le_id xle_entity_profiles.legal_entity_id%TYPE;
3963: l_bank_num ce_banks_v.bank_number%TYPE;