97: -- Event creation routines
98: -------------------------------------------------------------------------------
99:
100: FUNCTION create_event
101: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
102: ,p_valuation_method IN VARCHAR2
103: ,p_event_type_code IN VARCHAR2
104: ,p_event_date IN DATE
105: ,p_event_status_code IN VARCHAR2
104: ,p_event_date IN DATE
105: ,p_event_status_code IN VARCHAR2
106: ,p_event_number IN INTEGER DEFAULT NULL
107: ,p_transaction_date IN DATE DEFAULT NULL
108: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info DEFAULT NULL
109: ,p_budgetary_control_flag IN VARCHAR2)
110: RETURN INTEGER;
111:
112: FUNCTION create_manual_event
109: ,p_budgetary_control_flag IN VARCHAR2)
110: RETURN INTEGER;
111:
112: FUNCTION create_manual_event
113: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
114: ,p_event_type_code IN VARCHAR2
115: ,p_event_date IN DATE
116: ,p_event_status_code IN VARCHAR2
117: ,p_process_status_code IN VARCHAR2
116: ,p_event_status_code IN VARCHAR2
117: ,p_process_status_code IN VARCHAR2
118: ,p_event_number IN INTEGER DEFAULT NULL
119: ,p_transaction_date IN DATE DEFAULT NULL
120: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info DEFAULT NULL
121: ,p_budgetary_control_flag IN VARCHAR2)
122: RETURN INTEGER;
123:
124: PROCEDURE create_bulk_events
141: -- Event updation routines
142: -------------------------------------------------------------------------------
143:
144: PROCEDURE update_event_status
145: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
146: ,p_valuation_method IN VARCHAR2
147: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
148: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
149: ,p_event_date IN DATE DEFAULT NULL
149: ,p_event_date IN DATE DEFAULT NULL
150: ,p_event_status_code IN VARCHAR2);
151:
152: PROCEDURE update_event
153: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
154: ,p_valuation_method IN VARCHAR2
155: ,p_event_id IN INTEGER
156: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
157: ,p_event_date IN DATE DEFAULT NULL
157: ,p_event_date IN DATE DEFAULT NULL
158: ,p_event_status_code IN VARCHAR2 DEFAULT NULL
159: ,p_transaction_date IN DATE DEFAULT NULL
160: ,p_event_number IN INTEGER DEFAULT NULL
161: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info DEFAULT NULL
162: ,p_overwrite_event_num IN VARCHAR2 DEFAULT 'N'
163: ,p_overwrite_ref_info IN VARCHAR2 DEFAULT 'N');
164:
165: PROCEDURE update_manual_event
162: ,p_overwrite_event_num IN VARCHAR2 DEFAULT 'N'
163: ,p_overwrite_ref_info IN VARCHAR2 DEFAULT 'N');
164:
165: PROCEDURE update_manual_event
166: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
167: ,p_event_id IN INTEGER
168: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
169: ,p_event_date IN DATE DEFAULT NULL
170: ,p_event_status_code IN VARCHAR2 DEFAULT NULL
169: ,p_event_date IN DATE DEFAULT NULL
170: ,p_event_status_code IN VARCHAR2 DEFAULT NULL
171: ,p_process_status_code IN VARCHAR2 DEFAULT NULL
172: ,p_event_number IN INTEGER DEFAULT NULL
173: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info DEFAULT NULL
174: ,p_overwrite_event_num IN VARCHAR2 DEFAULT 'N'
175: ,p_overwrite_ref_info IN VARCHAR2 DEFAULT 'N');
176:
177: PROCEDURE update_bulk_event_statuses
185: -- Event deletion routines
186: -------------------------------------------------------------------------------
187:
188: PROCEDURE delete_event
189: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
190: ,p_valuation_method IN VARCHAR2
191: ,p_event_id IN INTEGER);
192:
193: PROCEDURE delete_processed_event
190: ,p_valuation_method IN VARCHAR2
191: ,p_event_id IN INTEGER);
192:
193: PROCEDURE delete_processed_event
194: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
195: ,p_event_id IN INTEGER);
196:
197: FUNCTION delete_events
198: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
194: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
195: ,p_event_id IN INTEGER);
196:
197: FUNCTION delete_events
198: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
199: ,p_valuation_method IN VARCHAR2
200: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
201: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
202: ,p_event_date IN DATE DEFAULT NULL)
203: RETURN INTEGER;
204:
205: -- return 1 if there is event for the entity, return 0 if success
206: FUNCTION delete_entity
207: (p_source_info IN xla_events_pub_pkg.t_event_source_info
208: ,p_valuation_method IN VARCHAR2)
209: RETURN INTEGER;
210:
211: PROCEDURE delete_bulk_events
215: -- Entity purge routines
216: -------------------------------------------------------------------------------
217:
218: PROCEDURE purge_entity
219: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info);
220:
221: -------------------------------------------------------------------------------
222: -- Event information routines
223: -------------------------------------------------------------------------------
222: -- Event information routines
223: -------------------------------------------------------------------------------
224:
225: FUNCTION get_event_info
226: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
227: ,p_valuation_method IN VARCHAR2
228: ,p_event_id IN INTEGER)
229: RETURN xla_events_pub_pkg.t_event_info;
230:
225: FUNCTION get_event_info
226: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
227: ,p_valuation_method IN VARCHAR2
228: ,p_event_id IN INTEGER)
229: RETURN xla_events_pub_pkg.t_event_info;
230:
231: FUNCTION get_event_status
232: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
233: ,p_valuation_method IN VARCHAR2
228: ,p_event_id IN INTEGER)
229: RETURN xla_events_pub_pkg.t_event_info;
230:
231: FUNCTION get_event_status
232: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
233: ,p_valuation_method IN VARCHAR2
234: ,p_event_id IN INTEGER)
235: RETURN VARCHAR2;
236:
234: ,p_event_id IN INTEGER)
235: RETURN VARCHAR2;
236:
237: FUNCTION event_exists
238: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
239: ,p_valuation_method IN VARCHAR2
240: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
241: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
242: ,p_event_date IN DATE DEFAULT NULL
245: ,p_event_id IN NUMBER DEFAULT NULL) -- 8761772
246: RETURN BOOLEAN;
247:
248: FUNCTION get_array_event_info
249: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
250: ,p_valuation_method IN VARCHAR2
251: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
252: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
253: ,p_event_date IN DATE DEFAULT NULL
251: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
252: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
253: ,p_event_date IN DATE DEFAULT NULL
254: ,p_event_status_code IN VARCHAR2 DEFAULT NULL)
255: RETURN xla_events_pub_pkg.t_array_event_info;
256:
257: -------------------------------------------------------------------------------
258: -- Entity update routines
259: -------------------------------------------------------------------------------
258: -- Entity update routines
259: -------------------------------------------------------------------------------
260:
261: PROCEDURE update_transaction_number
262: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
263: ,p_valuation_method IN VARCHAR2
264: ,p_transaction_number IN VARCHAR2
265: ,p_event_id IN NUMBER DEFAULT NULL); -- 8761772
266:
268: -- Control Account information routines
269: -------------------------------------------------------------------------------
270:
271: FUNCTION allow_third_party_update
272: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
273: ,p_valuation_method IN VARCHAR2)
274: RETURN BOOLEAN;
275:
276: -------------------------------------------------------------------------------
277: -- Entity information routines
278: -------------------------------------------------------------------------------
279:
280: FUNCTION get_entity_id
281: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
282: ,p_valuation_method IN VARCHAR2
283: ,p_event_id IN NUMBER DEFAULT NULL) -- 8761772
284: RETURN INTEGER;
285: