APPS.EGO_EBI_ITEM_LOAD dependencies on EGO_EBI_ITEM_LOAD_LOG

Line 15: DELETE FROM EGO_EBI_ITEM_LOAD_LOG;

11: --Purge load events from Event log table
12: PROCEDURE PURGE_EVENTLOG
13: IS
14: BEGIN
15: DELETE FROM EGO_EBI_ITEM_LOAD_LOG;
16: COMMIT;
17: END PURGE_EVENTLOG;
18:
19: --Genrate Item Load Events

Line 41: SELECT count(*) INTO l_logItemCount FROM EGO_EBI_ITEM_LOAD_LOG;

37: l_batch_size := p_batch_size;
38: l_max_events := p_max_events;
39:
40: -- Get the Item count in the event log
41: SELECT count(*) INTO l_logItemCount FROM EGO_EBI_ITEM_LOAD_LOG;
42:
43: --if there are no records in the event log table Insert records to Event Log table .
44: IF (l_logItemCount = 0) THEN
45: BEGIN

Line 50: INSERT INTO EGO_EBI_ITEM_LOAD_LOG (INVENTORY_ITEM_ID,ORGANIZATION_ID, EVENT_ID)

46: --Insert required item records into event log table .
47: x_err_msg := x_err_msg || '\n Inserting Records to Event log table';
48: -- Initialize Event Id to 0
49: l_eventId := 0;
50: INSERT INTO EGO_EBI_ITEM_LOAD_LOG (INVENTORY_ITEM_ID,ORGANIZATION_ID, EVENT_ID)
51: SELECT INVENTORY_ITEM_ID, ORGANIZATION_ID, NULL
52: FROM MTL_SYSTEM_ITEMS_B
53: WHERE ORGANIZATION_ID = p_organization_id
54: AND bom_item_type in (1, 2, 4)

Line 61: SELECT MAX(NVL(EVENT_ID,0)) into l_eventId FROM EGO_EBI_ITEM_LOAD_LOG;

57: COMMIT;
58: END;
59: ELSE
60: -- Initialize Event Id from the last run of the generate_events
61: SELECT MAX(NVL(EVENT_ID,0)) into l_eventId FROM EGO_EBI_ITEM_LOAD_LOG;
62: END IF;
63: x_err_msg := 'Event Id Initialized to ' || TO_CHAR(l_eventId) ;
64:
65: --Get Count of Item for which the Event should be raised

Line 66: SELECT count(*) INTO l_ItemCount FROM EGO_EBI_ITEM_LOAD_LOG WHERE EVENT_ID IS NULL;

62: END IF;
63: x_err_msg := 'Event Id Initialized to ' || TO_CHAR(l_eventId) ;
64:
65: --Get Count of Item for which the Event should be raised
66: SELECT count(*) INTO l_ItemCount FROM EGO_EBI_ITEM_LOAD_LOG WHERE EVENT_ID IS NULL;
67: WHILE (l_ItemCount > 0 AND (l_max_events IS NULL OR l_eventsRaised < l_max_events)) LOOP
68: BEGIN
69: --Generate new
70: l_eventId := l_eventId +1;

Line 72: UPDATE EGO_EBI_ITEM_LOAD_LOG

68: BEGIN
69: --Generate new
70: l_eventId := l_eventId +1;
71: x_err_msg := 'Event Id ' ||TO_CHAR(l_eventId)|| ' updating';
72: UPDATE EGO_EBI_ITEM_LOAD_LOG
73: SET EVENT_ID = l_eventId
74: WHERE EVENT_ID IS NULl AND ROWNUM < l_batch_size +1;
75: l_ItemCount := l_ItemCount - l_batch_size;
76:

Line 109: FROM EGO_EBI_ITEM_LOAD_LOG

105: l_return_status := '';
106: l_msg_data := '';
107: -- Get the Item count in the event log for the event
108: SELECT count(*) INTO l_logItemCount
109: FROM EGO_EBI_ITEM_LOAD_LOG
110: WHERE ORGANIZATION_ID = p_organization_id
111: AND EVENT_ID = p_event_id;
112:
113: --if there are records in the event log table Insert records to Event Log table .

Line 119: DELETE FROM EGO_EBI_ITEM_LOAD_LOG

115: BEGIN
116: --Insert required item records into event log table .
117: x_err_msg := x_err_msg || 'Deleting recods from Event log table for the event ' || TO_CHAR(p_event_id) || ' that are not active';
118:
119: DELETE FROM EGO_EBI_ITEM_LOAD_LOG
120: WHERE ORGANIZATION_ID = p_organization_id AND
121: EVENT_ID = p_event_id AND
122: INVENTORY_ITEM_ID NOT IN(
123: SELECT INVENTORY_ITEM_ID

Line 130: SELECT MAX(NVL(EVENT_ID,0))+1 into l_eventId FROM EGO_EBI_ITEM_LOAD_LOG;

126: AND bom_item_type in (1, 2, 4)
127: AND customer_order_flag = 'Y'
128: AND customer_order_enabled_flag = 'Y');
129:
130: SELECT MAX(NVL(EVENT_ID,0))+1 into l_eventId FROM EGO_EBI_ITEM_LOAD_LOG;
131: UPDATE EGO_EBI_ITEM_LOAD_LOG
132: SET EVENT_ID = l_eventId
133: WHERE EVENT_ID = p_event_id ;
134:

Line 131: UPDATE EGO_EBI_ITEM_LOAD_LOG

127: AND customer_order_flag = 'Y'
128: AND customer_order_enabled_flag = 'Y');
129:
130: SELECT MAX(NVL(EVENT_ID,0))+1 into l_eventId FROM EGO_EBI_ITEM_LOAD_LOG;
131: UPDATE EGO_EBI_ITEM_LOAD_LOG
132: SET EVENT_ID = l_eventId
133: WHERE EVENT_ID = p_event_id ;
134:
135: --Raise event