APPS.MTH_EVENT_PKG dependencies on MTH_EVENTS_D_SEQ

Line 86: VALUES (mth_events_d_seq.nextval, p_event_type, p_event_description, p_reason_code, p_reading_time, p_equipment_fk_key,

82: (EVENT_ID,EVENT_TYPE,EVENT_DESCRIPTION,REASON_CODE,TAG_READING_TIME,EQUIPMENT_FK_KEY,
83: SHIFT_WORKDAY_FK_KEY,WORKORDER_FK_KEY,EQUIP_STATUS,
84: CREATION_DATE, LAST_UPDATE_DATE,CREATION_SYSTEM_ID,LAST_UPDATE_SYSTEM_ID,CREATED_BY,
85: LAST_UPDATE_LOGIN,LAST_UPDATED_BY)
86: VALUES (mth_events_d_seq.nextval, p_event_type, p_event_description, p_reason_code, p_reading_time, p_equipment_fk_key,
87: p_shift_workday_fk_key, p_workorder_fk_key, p_equip_status, SYSDATE, SYSDATE, -1, -99999, -1,
88: -99999, -99999);
89:
90: -- l_event_id := mth_events_d_seq.CURRVAL;

Line 90: -- l_event_id := mth_events_d_seq.CURRVAL;

86: VALUES (mth_events_d_seq.nextval, p_event_type, p_event_description, p_reason_code, p_reading_time, p_equipment_fk_key,
87: p_shift_workday_fk_key, p_workorder_fk_key, p_equip_status, SYSDATE, SYSDATE, -1, -99999, -1,
88: -99999, -99999);
89:
90: -- l_event_id := mth_events_d_seq.CURRVAL;
91: SELECT mth_events_d_seq.CURRVAL INTO l_event_id FROM dual;
92:
93:
94: -- commit the event generation no matter what SQL error caught

Line 91: SELECT mth_events_d_seq.CURRVAL INTO l_event_id FROM dual;

87: p_shift_workday_fk_key, p_workorder_fk_key, p_equip_status, SYSDATE, SYSDATE, -1, -99999, -1,
88: -99999, -99999);
89:
90: -- l_event_id := mth_events_d_seq.CURRVAL;
91: SELECT mth_events_d_seq.CURRVAL INTO l_event_id FROM dual;
92:
93:
94: -- commit the event generation no matter what SQL error caught
95: COMMIT;