APPS.IEX_CHECKLIST_UTILITY dependencies on IEX_CHECKLIST_ITEMS_B

Line 397: UPDATE iex_checklist_items_b

393: END IF;
394:
395: iex_debug_pub.logmessage('l_status=' || l_status);
396:
397: UPDATE iex_checklist_items_b
398: SET status = l_status, task_last_modified_date = SYSDATE, last_update_date = SYSDATE,
399: last_updated_by = G_USER_ID, last_update_login = G_LOGIN_ID
400: WHERE checklist_item_id = p_checklist_item_id;
401: ELSE

Line 402: UPDATE iex_checklist_items_b

398: SET status = l_status, task_last_modified_date = SYSDATE, last_update_date = SYSDATE,
399: last_updated_by = G_USER_ID, last_update_login = G_LOGIN_ID
400: WHERE checklist_item_id = p_checklist_item_id;
401: ELSE
402: UPDATE iex_checklist_items_b
403: SET status = l_status, task_last_modified_date = SYSDATE, last_update_date = SYSDATE,
404: last_updated_by = G_USER_ID, last_update_login = G_LOGIN_ID
405: WHERE checklist_item_id = p_checklist_item_id;
406:

Line 1409: FROM iex_checklist_items_b

1405: p_checklist_item_name IN VARCHAR2,
1406: x_return_status OUT NOCOPY VARCHAR2) IS
1407: CURSOR c_checklist IS
1408: SELECT checklist_item_id
1409: FROM iex_checklist_items_b
1410: WHERE checklist_item_name = p_checklist_item_name;
1411:
1412: l_checklist_item_id NUMBER;
1413: BEGIN