APPS.INV_CONSIGN_NOTIF_UTL dependencies on MTL_CONSIGNED_DIAG_ERRORS

Line 64: p_agent_id IN mtl_consigned_diag_errors.agent_id%TYPE,

60: -- 10/06/03 vma Created.
61: --=========================================================================
62: PROCEDURE Call_Workflow_Notification(
63: p_user_name IN fnd_user.user_name%TYPE,
64: p_agent_id IN mtl_consigned_diag_errors.agent_id%TYPE,
65: p_lang_code IN fnd_languages.language_code%TYPE,
66: x_notification_id OUT NOCOPY mtl_consigned_diag_errors.notification_id%TYPE,
67: x_notification_date OUT NOCOPY mtl_consigned_diag_errors.last_notification_date%TYPE,
68: x_return_status OUT NOCOPY VARCHAR2

Line 66: x_notification_id OUT NOCOPY mtl_consigned_diag_errors.notification_id%TYPE,

62: PROCEDURE Call_Workflow_Notification(
63: p_user_name IN fnd_user.user_name%TYPE,
64: p_agent_id IN mtl_consigned_diag_errors.agent_id%TYPE,
65: p_lang_code IN fnd_languages.language_code%TYPE,
66: x_notification_id OUT NOCOPY mtl_consigned_diag_errors.notification_id%TYPE,
67: x_notification_date OUT NOCOPY mtl_consigned_diag_errors.last_notification_date%TYPE,
68: x_return_status OUT NOCOPY VARCHAR2
69: )
70: IS

Line 67: x_notification_date OUT NOCOPY mtl_consigned_diag_errors.last_notification_date%TYPE,

63: p_user_name IN fnd_user.user_name%TYPE,
64: p_agent_id IN mtl_consigned_diag_errors.agent_id%TYPE,
65: p_lang_code IN fnd_languages.language_code%TYPE,
66: x_notification_id OUT NOCOPY mtl_consigned_diag_errors.notification_id%TYPE,
67: x_notification_date OUT NOCOPY mtl_consigned_diag_errors.last_notification_date%TYPE,
68: x_return_status OUT NOCOPY VARCHAR2
69: )
70: IS
71:

Line 229: l_agent_id mtl_consigned_diag_errors.agent_id%TYPE;

225:
226: l_api_name CONSTANT VARCHAR2(30) := 'Send_Notification';
227: l_api_version CONSTANT NUMBER := 1.0;
228:
229: l_agent_id mtl_consigned_diag_errors.agent_id%TYPE;
230: l_user_name fnd_user.user_name%TYPE;
231: l_language fnd_languages.nls_language%TYPE;
232: l_lang_code fnd_languages.language_code%TYPE;
233:

Line 235: mtl_consigned_diag_errors.notification_id%TYPE

231: l_language fnd_languages.nls_language%TYPE;
232: l_lang_code fnd_languages.language_code%TYPE;
233:
234: TYPE notif_id_tbl_type IS TABLE OF
235: mtl_consigned_diag_errors.notification_id%TYPE
236: INDEX BY BINARY_INTEGER;
237:
238: TYPE notif_date_tbl_type IS TABLE OF
239: mtl_consigned_diag_errors.last_notification_date%TYPE

Line 239: mtl_consigned_diag_errors.last_notification_date%TYPE

235: mtl_consigned_diag_errors.notification_id%TYPE
236: INDEX BY BINARY_INTEGER;
237:
238: TYPE notif_date_tbl_type IS TABLE OF
239: mtl_consigned_diag_errors.last_notification_date%TYPE
240: INDEX BY BINARY_INTEGER;
241:
242: TYPE notif_status_tbl_type IS TABLE OF VARCHAR2(20)
243: INDEX BY BINARY_INTEGER;

Line 246: MTL_CONSIGNED_DIAG_ERRORS.agent_id%TYPE

242: TYPE notif_status_tbl_type IS TABLE OF VARCHAR2(20)
243: INDEX BY BINARY_INTEGER;
244:
245: TYPE agent_id_tbl_type IS TABLE OF
246: MTL_CONSIGNED_DIAG_ERRORS.agent_id%TYPE
247: INDEX BY BINARY_INTEGER;
248:
249: agent_id_tbl agent_id_tbl_type;
250: notif_id_tbl notif_id_tbl_type;

Line 283: FROM mtl_consigned_diag_errors

279:
280: x_return_status := FND_API.G_RET_STS_SUCCESS;
281:
282: SELECT DISTINCT agent_id BULK COLLECT INTO agent_id_tbl
283: FROM mtl_consigned_diag_errors
284: WHERE agent_id IS NOT NULL
285: AND (notification_id IS NULL
286: OR last_notification_date + p_notification_resend_days <= SYSDATE);
287:

Line 339: UPDATE mtl_consigned_diag_errors

335: END LOOP;
336:
337: -- update last_notification_date and notification_id
338: FORALL j IN agent_id_tbl.FIRST..agent_id_tbl.LAST
339: UPDATE mtl_consigned_diag_errors
340: SET notification_id = notif_id_tbl(j),
341: last_notification_date = notif_date_tbl(j),
342: last_update_date = SYSDATE,
343: last_updated_by = G_USER_ID,