APPS.IEU_UWQ_MEDIA_ACTIONS_PKG dependencies on IEU_UWQ_MEDIA_ACTIONS

Line 1: PACKAGE BODY ieu_uwq_media_actions_pkg AS

1: PACKAGE BODY ieu_uwq_media_actions_pkg AS
2: /* $Header: IEUMACLB.pls 120.0 2005/06/02 15:57:02 appldev noship $ */
3: PROCEDURE insert_row(
4: x_rowid IN OUT NOCOPY VARCHAR2
5: , x_media_action_id NUMBER

Line 19: FROM ieu_uwq_media_actions

15: , x_other_params VARCHAR2
16: ) IS
17: CURSOR l_insert IS
18: SELECT ROWID
19: FROM ieu_uwq_media_actions
20: WHERE media_action_id = x_media_action_id;
21: BEGIN
22: INSERT INTO ieu_uwq_media_actions (
23: media_action_id

Line 22: INSERT INTO ieu_uwq_media_actions (

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

Line 62: DELETE FROM ieu_uwq_media_actions

58: PROCEDURE delete_row(
59: x_media_action_id NUMBER
60: ) IS
61: BEGIN
62: DELETE FROM ieu_uwq_media_actions
63: WHERE media_action_id = x_media_action_id;
64: IF (SQL%NOTFOUND) THEN
65: RAISE NO_DATA_FOUND;
66: END IF;

Line 84: UPDATE ieu_uwq_media_actions

80: , x_classification VARCHAR2
81: , x_other_params VARCHAR2
82: ) IS
83: BEGIN
84: UPDATE ieu_uwq_media_actions
85: SET
86: media_action_id=DECODE(x_media_action_id,FND_API.G_MISS_NUM,NULL,x_media_action_id)
87: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
88: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)

Line 120: FROM ieu_uwq_media_actions

116: , x_other_params VARCHAR2
117: ) IS
118: CURSOR l_lock IS
119: SELECT *
120: FROM ieu_uwq_media_actions
121: WHERE rowid = x_rowid
122: FOR UPDATE OF media_action_id NOWAIT;
123: l_table_rec l_lock%ROWTYPE;
124: BEGIN

Line 174: END ieu_uwq_media_actions_pkg;

170: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
171: APP_EXCEPTION.RAISE_EXCEPTION;
172: END IF;
173: END lock_row;
174: END ieu_uwq_media_actions_pkg;