APPS.M4U_EGOEVNT_HANDLER dependencies on EGO_UCCNET_EVENTS

Line 87: l_event_type ego_uccnet_events.event_type%TYPE;

83: l_dattribute3 DATE;
84: l_dattribute4 DATE;
85: l_dattribute5 DATE;
86:
87: l_event_type ego_uccnet_events.event_type%TYPE;
88: l_event_action ego_uccnet_events.event_action%TYPE;
89: l_gtin ego_uccnet_events.gtin%TYPE;
90: l_top_gtin ego_uccnet_events.top_gtin%TYPE;
91: l_doc_owner ego_uccnet_events.last_updated_by%TYPE;

Line 88: l_event_action ego_uccnet_events.event_action%TYPE;

84: l_dattribute4 DATE;
85: l_dattribute5 DATE;
86:
87: l_event_type ego_uccnet_events.event_type%TYPE;
88: l_event_action ego_uccnet_events.event_action%TYPE;
89: l_gtin ego_uccnet_events.gtin%TYPE;
90: l_top_gtin ego_uccnet_events.top_gtin%TYPE;
91: l_doc_owner ego_uccnet_events.last_updated_by%TYPE;
92: l_item_number mtl_system_items_kfv.concatenated_segments%TYPE;

Line 89: l_gtin ego_uccnet_events.gtin%TYPE;

85: l_dattribute5 DATE;
86:
87: l_event_type ego_uccnet_events.event_type%TYPE;
88: l_event_action ego_uccnet_events.event_action%TYPE;
89: l_gtin ego_uccnet_events.gtin%TYPE;
90: l_top_gtin ego_uccnet_events.top_gtin%TYPE;
91: l_doc_owner ego_uccnet_events.last_updated_by%TYPE;
92: l_item_number mtl_system_items_kfv.concatenated_segments%TYPE;
93:

Line 90: l_top_gtin ego_uccnet_events.top_gtin%TYPE;

86:
87: l_event_type ego_uccnet_events.event_type%TYPE;
88: l_event_action ego_uccnet_events.event_action%TYPE;
89: l_gtin ego_uccnet_events.gtin%TYPE;
90: l_top_gtin ego_uccnet_events.top_gtin%TYPE;
91: l_doc_owner ego_uccnet_events.last_updated_by%TYPE;
92: l_item_number mtl_system_items_kfv.concatenated_segments%TYPE;
93:
94: BEGIN

Line 91: l_doc_owner ego_uccnet_events.last_updated_by%TYPE;

87: l_event_type ego_uccnet_events.event_type%TYPE;
88: l_event_action ego_uccnet_events.event_action%TYPE;
89: l_gtin ego_uccnet_events.gtin%TYPE;
90: l_top_gtin ego_uccnet_events.top_gtin%TYPE;
91: l_doc_owner ego_uccnet_events.last_updated_by%TYPE;
92: l_item_number mtl_system_items_kfv.concatenated_segments%TYPE;
93:
94: BEGIN
95:

Line 152: FROM ego_uccnet_events

148: /* if count > 1, we use RCIR in Batch mode for Registering the items */
149: /* else we go for simple RCIR message */
150: SELECT count(*), event_type
151: INTO l_gtin_count, l_event_type
152: FROM ego_uccnet_events
153: WHERE batch_id = l_ego_batch_id
154: AND subbatch_id = l_ego_subbatch_id
155: AND gtin = top_gtin
156: group by event_type;

Line 200: FROM ego_uccnet_events e,

196: e.organization_id, f.user_name, mtlkfv.concatenated_segments
197: INTO l_event_action, l_gtin, l_top_gtin,
198: l_doc_owner, l_target_market, l_tp_gln,
199: l_org_id, l_owner_role, l_item_number
200: FROM ego_uccnet_events e,
201: fnd_user f,
202: mtl_system_items_kfv mtlkfv
203: WHERE e.batch_id = l_ego_batch_id
204: AND e.subbatch_id = l_ego_subbatch_id