APPS.MTH_EVENT_PKG dependencies on MTH_EVENT_ACTIONS

Line 228: INSERT INTO MTH_EVENT_ACTIONS

224: FOR j IN p_action_statuses.FIRST .. p_action_statuses.LAST
225: LOOP
226: l_action_status_rec := p_action_statuses(j);
227:
228: INSERT INTO MTH_EVENT_ACTIONS
229: (EVENT_ID, ACTION_TYPE_CODE, LINE_NUM, NOTIFICATION_ID, NOTIFICATION_CONTENT, ACTION_REFERENCE_ID,
230: ACTION_STATUS, ACTION_HANDLER_API, CREATION_DATE, LAST_UPDATE_DATE, CREATION_SYSTEM_ID, LAST_UPDATE_SYSTEM_ID)
231: VALUES (p_event_id, l_action_status_rec.action_type_code, j,
232: l_action_status_rec.notification_id,

Line 247: raise_application_error(-20003,'Unknown Exception to Insert MTH_EVENT_ACTIONS');

243: COMMIT;
244:
245: EXCEPTION
246: WHEN OTHERS THEN
247: raise_application_error(-20003,'Unknown Exception to Insert MTH_EVENT_ACTIONS');
248:
249: END UPDATE_MTH_EVENT_ACTION;
250:
251:

Line 256: l_email_id MTH_EVENT_ACTIONS.NOTIFICATION_ID%TYPE;

252: PROCEDURE INVOKE_EVENT_NOTIFICATION(p_event_id IN NUMBER,
253: p_event_action_rec IN ActionHandlerRec,
254: p_action_statuses OUT NOCOPY ActionStatusTableType)
255: AS
256: l_email_id MTH_EVENT_ACTIONS.NOTIFICATION_ID%TYPE;
257: l_mobile_id MTH_EVENT_ACTIONS.NOTIFICATION_ID%TYPE;
258: l_subject VARCHAR2(100);
259: l_content VARCHAR2(1000);
260: l_status VARCHAR2(1024);

Line 257: l_mobile_id MTH_EVENT_ACTIONS.NOTIFICATION_ID%TYPE;

253: p_event_action_rec IN ActionHandlerRec,
254: p_action_statuses OUT NOCOPY ActionStatusTableType)
255: AS
256: l_email_id MTH_EVENT_ACTIONS.NOTIFICATION_ID%TYPE;
257: l_mobile_id MTH_EVENT_ACTIONS.NOTIFICATION_ID%TYPE;
258: l_subject VARCHAR2(100);
259: l_content VARCHAR2(1000);
260: l_status VARCHAR2(1024);
261: l_equip_name VARCHAR2(60);