APPS.CE_LEVELING_UTILS dependencies on CE_PROPOSED_TRANSFERS

Line 70: | proposed transfer in CE_PROPOSED_TRANSFERS. |

66: | DESCRIPTION |
67: | This procedure serves as the executable of the |
68: | 'Generate Cash Leveling Fund Transfers' concurrent program. |
69: | This procedure will generate a fund transfer for each |
70: | proposed transfer in CE_PROPOSED_TRANSFERS. |
71: | |
72: | CALLED BY |
73: | 'Generate Cash Leveling Fund Transfers' concurrent program |
74: | |

Line 94: FROM ce_proposed_transfers

90: sub_account_id,
91: conc_account_id,
92: transfer_amount,
93: cashpool_id
94: FROM ce_proposed_transfers
95: WHERE status = c_run_id;
96:
97: l_from_bank_account_id NUMBER;
98: l_to_bank_account_id NUMBER;

Line 172: DELETE ce_proposed_transfers

168: X_msg_count => l_msg_count,
169: X_cashflows_created_flag => l_cashflows_created_flag,
170: X_called_by_flag => 'L');
171: ELSE -- cash pool (p_as_of_date) is not effective
172: DELETE ce_proposed_transfers
173: WHERE proposed_transfer_id = p_transfer.proposed_transfer_id;
174: COMMIT;
175: END IF;
176: ELSE -- transfer amount = 0

Line 177: DELETE ce_proposed_transfers

173: WHERE proposed_transfer_id = p_transfer.proposed_transfer_id;
174: COMMIT;
175: END IF;
176: ELSE -- transfer amount = 0
177: DELETE ce_proposed_transfers
178: WHERE proposed_transfer_id = p_transfer.proposed_transfer_id;
179: COMMIT;
180: END IF;
181: END LOOP;

Line 184: DELETE FROM ce_proposed_transfers

180: END IF;
181: END LOOP;
182:
183: -- Purge all submitted transfers
184: DELETE FROM ce_proposed_transfers
185: WHERE status = p_run_id;
186: COMMIT;
187:
188: -- Launch the Cash Leveling Execution Report