APPS.IEX_CHECKLIST_UTILITY dependencies on IEX_CHECKLIST_ITEMS_B

Line 365: UPDATE iex_checklist_items_b

361: END IF;
362:
363: iex_debug_pub.logmessage('l_status=' || l_status);
364:
365: UPDATE iex_checklist_items_b
366: SET status = l_status, task_last_modified_date = SYSDATE, last_update_date = SYSDATE,
367: last_updated_by = G_USER_ID, last_update_login = G_LOGIN_ID
368: WHERE checklist_item_id = p_checklist_item_id;
369: ELSE

Line 370: UPDATE iex_checklist_items_b

366: SET status = l_status, task_last_modified_date = SYSDATE, last_update_date = SYSDATE,
367: last_updated_by = G_USER_ID, last_update_login = G_LOGIN_ID
368: WHERE checklist_item_id = p_checklist_item_id;
369: ELSE
370: UPDATE iex_checklist_items_b
371: SET status = l_status, task_last_modified_date = SYSDATE, last_update_date = SYSDATE,
372: last_updated_by = G_USER_ID, last_update_login = G_LOGIN_ID
373: WHERE checklist_item_id = p_checklist_item_id;
374:

Line 1338: FROM iex_checklist_items_b

1334: p_checklist_item_name IN VARCHAR2,
1335: x_return_status OUT NOCOPY VARCHAR2) IS
1336: CURSOR c_checklist IS
1337: SELECT checklist_item_id
1338: FROM iex_checklist_items_b
1339: WHERE checklist_item_name = p_checklist_item_name;
1340:
1341: l_checklist_item_id NUMBER;
1342: BEGIN