APPS.IEU_WR_ITEMS_PKG dependencies on IEU_UWQM_ITEMS

Line 37: INSERT INTO IEU_UWQM_ITEMS

33: begin
34:
35: begin
36: x_return_status := fnd_api.g_ret_sts_success;
37: INSERT INTO IEU_UWQM_ITEMS
38: ( WORK_ITEM_ID,
39: OBJECT_VERSION_NUMBER,
40: CREATED_BY,
41: CREATION_DATE,

Line 70: ( IEU_UWQM_ITEMS_S1.NEXTVAL,

66: WS_ID,
67: DISTRIBUTION_STATUS_ID
68: )
69: VALUES
70: ( IEU_UWQM_ITEMS_S1.NEXTVAL,
71: 1,
72: P_USER_ID,
73: SYSDATE,
74: P_USER_ID,

Line 142: UPDATE IEU_UWQM_ITEMS

138: begin
139:
140: x_return_status := fnd_api.g_ret_sts_success;
141:
142: UPDATE IEU_UWQM_ITEMS
143: SET
144: CREATED_BY = P_USER_ID,
145: CREATION_DATE = SYSDATE,
146: LAST_UPDATED_BY = P_USER_ID,

Line 293: delete from IEU_UWQM_ITEMS

289: begin
290: l_message := '';
291: x_return_status := fnd_api.g_ret_sts_success;
292:
293: delete from IEU_UWQM_ITEMS
294: where WORKITEM_OBJ_CODE = P_WORKITEM_OBJ_CODE
295: and WORKITEM_PK_ID = P_WORKITEM_PK_ID;
296:
297: if (sql%notfound) then

Line 331: UPDATE IEU_UWQM_ITEMS

327: x_return_status := fnd_api.g_ret_sts_success;
328:
329: IF ( p_work_item_id is not null)
330: THEN
331: UPDATE IEU_UWQM_ITEMS
332: SET status_id = p_status_id,
333: status_update_user_id = p_status_update_user_id
334: -- reschedule_time = nvl(p_reschedule_time, sysdate)
335: WHERE WORK_ITEM_ID = P_WORK_ITEM_ID;

Line 338: UPDATE IEU_UWQM_ITEMS

334: -- reschedule_time = nvl(p_reschedule_time, sysdate)
335: WHERE WORK_ITEM_ID = P_WORK_ITEM_ID;
336: ELSE
337: --IF ( ( p_workitem_obj_code is not null) and ( p_work_item_id is not null) )
338: UPDATE IEU_UWQM_ITEMS
339: SET status_id = p_status_id,
340: status_update_user_id = p_status_update_user_id
341: -- reschedule_time = nvl(p_reschedule_time, sysdate)
342: WHERE WORKITEM_OBJ_CODE = P_WORKITEM_OBJ_CODE