[Home] [Help]
110: IF p_transfer.transfer_amount <> 0 THEN
111: SELECT nvl(effective_date_from,to_date(p_as_of_date,'YYYY/MM/DD HH24:MI:SS')),
112: nvl(effective_date_to,to_date(p_as_of_date,'YYYY/MM/DD HH24:MI:SS'))
113: INTO l_effective_date_from, l_effective_date_to
114: FROM ce_cashpools
115: WHERE cashpool_id = p_transfer.cashpool_id;
116:
117: IF (to_date(p_as_of_date,'YYYY/MM/DD HH24:MI:SS') >= l_effective_date_from
118: AND to_date(p_as_of_date,'YYYY/MM/DD HH24:MI:SS') <= l_effective_date_to) THEN
266: l_count NUMBER;
267: l_trx_subtype VARCHAR2(30);
268: l_result VARCHAR2(7);
269: l_msg_count NUMBER;
270: l_authorization_bat CE_CASHPOOLS.authorization_bat%TYPE;
271: l_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
272: l_from_bank_account_id CE_BANK_ACCOUNTS.bank_Account_id%TYPE;
273: l_to_bank_Account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
274:
278:
279: IF (l_bat_profile = 'XTR') THEN
280: SELECT authorization_bat
281: INTO l_authorization_bat
282: FROM ce_cashpools
283: WHERE cashpool_id = X_cashpool_id;
284: IF (l_authorization_bat IS NOT NULL) THEN
285: -- cashpool was setup for CE
286: CE_ZBA_DEAL_INF_PKG.insert_row (
298: fund_conc_account_id),
299: currency_code
300: INTO l_conc_account_id,
301: l_currency_code
302: FROM ce_cashpools
303: WHERE cashpool_id = X_cashpool_id;
304:
305: --bug5346601
306: l_from_bank_account_id := X_from_Bank_Account_id;
385: );
386:
387: SELECT tst.transaction_sub_type_name
388: INTO l_trx_subtype
389: FROM ce_trxns_subtype_codes tst, ce_cashpools cp
390: WHERE cp.trxn_subtype_code_id = tst.trxn_subtype_code_id(+)
391: AND cp.cashpool_id = X_cashpool_id;
392:
393: IF l_result = 'SUCCESS' THEN
527: PROCEDURE Populate_Nested_Accounts(p_parent_cashpool_id NUMBER,
528: p_cashpool_id NUMBER) IS
529: BEGIN
530:
531: UPDATE ce_cashpools
532: SET parent_cashpool_id = p_parent_cashpool_id
533: WHERE cashpool_id = p_cashpool_id;
534:
535: INSERT INTO ce_cashpool_sub_accts(
580: --------------------------------------------------------------------- */
581: PROCEDURE Delete_Sub_Accounts(p_cashpool_id NUMBER) IS
582: BEGIN
583:
584: UPDATE ce_cashpools
585: SET parent_cashpool_id = null
586: WHERE parent_cashpool_id = p_cashpool_id;
587:
588: DELETE FROM ce_cashpool_sub_accts
722: | PUBLIC PROCEDRE |
723: | Update_Bank_Account_Id |
724: | |
725: | DESCRIPTION |
726: | This procedure updates the bank account id in ce_cashpools |
727: | and ce_cashpool_sub_accts when a bank account that is also a |
728: | cash pool sub-account is "linked" or "unlinked" with AP |
729: | |
730: | CALLED BY |
754: UPDATE ce_cashpool_sub_accts
755: SET fund_conc_account_id = p_new_bank_account_id
756: WHERE fund_conc_account_id = p_old_bank_account_id;
757:
758: UPDATE ce_cashpools
759: SET conc_account_id = p_new_bank_account_id
760: WHERE conc_account_id = p_old_bank_account_id;
761:
762: UPDATE ce_cashpools
758: UPDATE ce_cashpools
759: SET conc_account_id = p_new_bank_account_id
760: WHERE conc_account_id = p_old_bank_account_id;
761:
762: UPDATE ce_cashpools
763: SET inv_conc_account_id = p_new_bank_account_id
764: WHERE inv_conc_account_id = p_old_bank_account_id;
765:
766: UPDATE ce_cashpools
762: UPDATE ce_cashpools
763: SET inv_conc_account_id = p_new_bank_account_id
764: WHERE inv_conc_account_id = p_old_bank_account_id;
765:
766: UPDATE ce_cashpools
767: SET fund_conc_account_id = p_new_bank_account_id
768: WHERE fund_conc_account_id = p_old_bank_account_id;
769:
770: UPDATE ce_cp_worksheet_lines
822: WHERE type in ('ACCT','CONC','INV')
823: AND account_id = p_header_bank_account_id
824: AND cashpool_id in
825: (select cashpool_id
826: from ce_cashpools
827: where sweeps_flag = 'Y'
828: and nvl(effective_date_to,p_trx_date) >= p_trx_date);
829:
830: SELECT type
848: WHERE type in ('ACCT','CONC','FUND')
849: AND account_id = p_header_bank_account_id
850: AND cashpool_id in
851: (select cashpool_id
852: from ce_cashpools
853: where sweeps_flag = 'Y'
854: and nvl(effective_date_to,p_trx_date) >= p_trx_date);
855:
856: SELECT type