1 PACKAGE "EGO_EBI_ITEM_LOAD" AUTHID CURRENT_USER AS
2 /* $Header: EGOVEILS.pls 120.1.12010000.1 2009/05/19 12:08:36 aashah noship $ */
3
4 G_ITEM_LOAD_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.ego.ebi.itemLoad';
5
6 --Generate Events. This can be run multiple times to generate the events incrementally.
7 --When run for the first time, qualifying item id records will be inserted into the event log table
8 -- and the procedure will stamp the records with the event id and raise the event.
9 -- if the records left in the the event log table without stamped event id, the output message
10 -- will state so. On the subsequent run, it will start stamping the events after the last run left.
11
12 PROCEDURE GENERATE_EVENTS( p_organization_id IN NUMBER
13 ,p_batch_size IN NUMBER DEFAULT 20
14 ,p_max_events IN NUMBER DEFAULT NULL
15 ,x_err_msg OUT NOCOPY VARCHAR2
16 );
17
18 -- Purge load events from Event log
19 PROCEDURE PURGE_EVENTLOG;
20
21
22 --To regenrate failed event provide the event id
23 PROCEDURE REGENERATE_FAILED_EVENT( p_organization_id IN NUMBER
24 ,p_event_id IN NUMBER
25 ,x_err_msg OUT NOCOPY VARCHAR2
26 );
27
28 END EGO_EBI_ITEM_LOAD;