APPS.IEU_UWQM_ITEMS_PKG dependencies on IEU_UWQM_ITEMS

Line 1: package body IEU_UWQM_ITEMS_PKG as

1: package body IEU_UWQM_ITEMS_PKG as
2: /* $Header: IEUUWQMB.pls 120.0 2005/06/02 15:56:29 appldev noship $ */
3:
4: procedure INSERT_ROW
5: ( p_workitem_obj_code IN VARCHAR2,

Line 35: INSERT INTO IEU_UWQM_ITEMS

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

Line 66: ( IEU_UWQM_ITEMS_S1.NEXTVAL,

62: RESCHEDULE_TIME,
63: STATUS_UPDATE_USER_ID
64: )
65: VALUES
66: ( IEU_UWQM_ITEMS_S1.NEXTVAL,
67: 1,
68: P_USER_ID,
69: SYSDATE,
70: P_USER_ID,

Line 134: UPDATE IEU_UWQM_ITEMS

130: begin
131:
132: x_return_status := fnd_api.g_ret_sts_success;
133:
134: UPDATE IEU_UWQM_ITEMS
135: SET
136: CREATED_BY = P_USER_ID,
137: CREATION_DATE = SYSDATE,
138: LAST_UPDATED_BY = P_USER_ID,

Line 205: IEU_UWQM_ITEMS_PKG.UPDATE_ROW

201: begin
202:
203: x_return_status := fnd_api.g_ret_sts_success;
204:
205: IEU_UWQM_ITEMS_PKG.UPDATE_ROW
206: ( p_WORKITEM_OBJ_CODE,
207: p_workitem_pk_id,
208: p_title,
209: p_party_id,

Line 234: IEU_UWQM_ITEMS_PKG.INSERT_ROW

230: raise no_data_found;
231: end if;
232: Exception
233: when no_data_found then
234: IEU_UWQM_ITEMS_PKG.INSERT_ROW
235: ( p_workitem_obj_code,
236: p_workitem_pk_id,
237: p_work_item_number,
238: p_title,

Line 274: delete from IEU_UWQM_ITEMS

270: begin
271:
272: x_return_status := fnd_api.g_ret_sts_success;
273:
274: delete from IEU_UWQM_ITEMS
275: where WORK_ITEM_ID = P_WORK_ITEM_ID
276: and WORKITEM_OBJ_CODE = P_WORKITEM_OBJ_CODE
277: and WORKITEM_PK_ID = P_WORKITEM_PK_ID;
278:

Line 302: UPDATE IEU_UWQM_ITEMS

298: x_return_status := fnd_api.g_ret_sts_success;
299:
300: IF ( p_work_item_id is not null)
301: THEN
302: UPDATE IEU_UWQM_ITEMS
303: SET status_id = p_status_id,
304: status_update_user_id = p_status_update_user_id
305: -- reschedule_time = nvl(p_reschedule_time, sysdate)
306: WHERE WORK_ITEM_ID = P_WORK_ITEM_ID;

Line 309: UPDATE IEU_UWQM_ITEMS

305: -- reschedule_time = nvl(p_reschedule_time, sysdate)
306: WHERE WORK_ITEM_ID = P_WORK_ITEM_ID;
307: ELSE
308: --IF ( ( p_workitem_obj_code is not null) and ( p_work_item_id is not null) )
309: UPDATE IEU_UWQM_ITEMS
310: SET status_id = p_status_id,
311: status_update_user_id = p_status_update_user_id
312: -- reschedule_time = nvl(p_reschedule_time, sysdate)
313: WHERE WORKITEM_OBJ_CODE = P_WORKITEM_OBJ_CODE

Line 322: end IEU_UWQM_ITEMS_PKG;

318: x_return_status := fnd_api.g_ret_sts_error;
319: end if;
320:
321: end UPDATE_STATUS_FLAG;
322: end IEU_UWQM_ITEMS_PKG;