APPS.CE_LEVELING_UTILS dependencies on CE_PROPOSED_TRANSFERS

Line 54: | proposed transfer in CE_PROPOSED_TRANSFERS. |

50: | DESCRIPTION |
51: | This procedure serves as the executable of the |
52: | 'Generate Cash Leveling Fund Transfers' concurrent program. |
53: | This procedure will generate a fund transfer for each |
54: | proposed transfer in CE_PROPOSED_TRANSFERS. |
55: | |
56: | CALLED BY |
57: | 'Generate Cash Leveling Fund Transfers' concurrent program |
58: | |

Line 75: FROM ce_proposed_transfers

71: sub_account_id,
72: conc_account_id,
73: transfer_amount,
74: cashpool_id
75: FROM ce_proposed_transfers
76: WHERE status = c_run_id;
77:
78: l_from_bank_account_id NUMBER;
79: l_to_bank_account_id NUMBER;

Line 149: DELETE FROM ce_proposed_transfers

145: l_cashflows_created_flag,
146: 'L' -- called_by_flag
147: );
148: ELSE -- cash pool is not effective
149: DELETE FROM ce_proposed_transfers
150: WHERE proposed_transfer_id = p_transfer.proposed_transfer_id;
151: commit;
152: END IF;
153: ELSE -- transfer amount = 0

Line 154: DELETE FROM ce_proposed_transfers

150: WHERE proposed_transfer_id = p_transfer.proposed_transfer_id;
151: commit;
152: END IF;
153: ELSE -- transfer amount = 0
154: DELETE FROM ce_proposed_transfers
155: WHERE proposed_transfer_id = p_transfer.proposed_transfer_id;
156: commit;
157: END IF;
158: END LOOP;

Line 161: DELETE FROM ce_proposed_transfers

157: END IF;
158: END LOOP;
159:
160: -- Purge all submitted transfers
161: DELETE FROM ce_proposed_transfers
162: WHERE status = p_run_id;
163: commit;
164:
165: -- Launch the Cash Leveling Execution Report