APPS.IEU_UWQ_NONMEDIA_ACTIONS_PKG dependencies on IEU_UWQ_NONMEDIA_ACTIONS

Line 1: PACKAGE BODY ieu_uwq_nonmedia_actions_pkg AS

1: PACKAGE BODY ieu_uwq_nonmedia_actions_pkg AS
2: /* $Header: IEUNMACB.pls 115.4 2003/08/21 18:34:42 fsuthar ship $ */
3: PROCEDURE insert_row(
4: x_rowid IN OUT NOCOPY VARCHAR2
5: , x_nonmedia_action_id NUMBER

Line 19: FROM ieu_uwq_nonmedia_actions

15: , x_responsibility_id NUMBER
16: ) IS
17: CURSOR l_insert IS
18: SELECT ROWID
19: FROM ieu_uwq_nonmedia_actions
20: WHERE nonmedia_action_id = x_nonmedia_action_id;
21: BEGIN
22: INSERT INTO ieu_uwq_nonmedia_actions (
23: nonmedia_action_id

Line 22: INSERT INTO ieu_uwq_nonmedia_actions (

18: SELECT ROWID
19: FROM ieu_uwq_nonmedia_actions
20: WHERE nonmedia_action_id = x_nonmedia_action_id;
21: BEGIN
22: INSERT INTO ieu_uwq_nonmedia_actions (
23: nonmedia_action_id
24: , created_by
25: , creation_date
26: , last_updated_by

Line 63: DELETE FROM ieu_uwq_nonmedia_actions

59: PROCEDURE delete_row(
60: x_nonmedia_action_id NUMBER
61: ) IS
62: BEGIN
63: DELETE FROM ieu_uwq_nonmedia_actions
64: WHERE nonmedia_action_id = x_nonmedia_action_id;
65: IF (SQL%NOTFOUND) THEN
66: RAISE NO_DATA_FOUND;
67: END IF;

Line 85: UPDATE ieu_uwq_nonmedia_actions

81: , x_source_for_task_flag VARCHAR2
82: , x_responsibility_id NUMBER
83: ) IS
84: BEGIN
85: UPDATE ieu_uwq_nonmedia_actions
86: SET
87: nonmedia_action_id=DECODE(x_nonmedia_action_id,FND_API.G_MISS_NUM,NULL,x_nonmedia_action_id)
88: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
89: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)

Line 122: FROM ieu_uwq_nonmedia_actions

118: , x_responsibility_id NUMBER
119: ) IS
120: CURSOR l_lock IS
121: SELECT *
122: FROM ieu_uwq_nonmedia_actions
123: WHERE rowid = x_rowid
124: FOR UPDATE OF nonmedia_action_id NOWAIT;
125: l_table_rec l_lock%ROWTYPE;
126: BEGIN

Line 176: END ieu_uwq_nonmedia_actions_pkg;

172: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
173: APP_EXCEPTION.RAISE_EXCEPTION;
174: END IF;
175: END lock_row;
176: END ieu_uwq_nonmedia_actions_pkg;