APPS.AMS_WEB_CITEM_ASSOC_PKG dependencies on AMS_WEB_PLCE_CITEM_ASSOC

Line 59: INSERT INTO ams_web_plce_citem_assoc(

55:
56: px_object_version_number := 1;
57:
58:
59: INSERT INTO ams_web_plce_citem_assoc(
60: placement_citem_id,
61: placement_mp_id,
62: content_item_id,
63: citem_version_id,

Line 118: UPDATE ams_web_plce_citem_assoc

114: AMS_UTILITY_PVT.debug_message('table handler : before update p_placement_citem_id =' || p_placement_citem_id );
115: END IF;
116:
117:
118: UPDATE ams_web_plce_citem_assoc
119: SET
120: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
121: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
122: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 156: DELETE FROM ams_web_plce_citem_assoc

152: IF (AMS_DEBUG_HIGH_ON) THEN
153:
154: AMS_UTILITY_PVT.debug_message('table handler : before delete of b; placement_citem_id = ' || p_placement_citem_id || ' object_version_num = ' || p_object_version_number);
155: END IF;
156: DELETE FROM ams_web_plce_citem_assoc
157: WHERE placement_citem_id = p_placement_citem_id
158: AND object_version_number = p_object_version_number;
159:
160: IF (AMS_DEBUG_HIGH_ON) THEN

Line 204: FROM ams_web_plce_citem_assoc

200:
201: IS
202: CURSOR C IS
203: SELECT *
204: FROM ams_web_plce_citem_assoc
205: WHERE PLACEMENT_CITEM_ID = p_placement_citem_id
206: FOR UPDATE of PLACEMENT_CITEM_ID NOWAIT;
207: Recinfo C%ROWTYPE;
208: BEGIN

Line 286: from ams_web_plce_citem_assoc

282: l_msg_data varchar2(100);
283:
284: cursor c_db_data_details is
285: select last_updated_by, nvl(object_version_number,1)
286: from ams_web_plce_citem_assoc
287: where placement_citem_id = x_placement_citem_id;
288:
289: cursor c_chk_plce_citem_id_exists is
290: select 'x'

Line 291: from ams_web_plce_citem_assoc

287: where placement_citem_id = x_placement_citem_id;
288:
289: cursor c_chk_plce_citem_id_exists is
290: select 'x'
291: from ams_web_plce_citem_assoc
292: where placement_citem_id = x_placement_citem_id;
293:
294: cursor c_get_placement_citem_id is
295: select ams_web_plce_citem_assoc_s.nextval

Line 295: select ams_web_plce_citem_assoc_s.nextval

291: from ams_web_plce_citem_assoc
292: where placement_citem_id = x_placement_citem_id;
293:
294: cursor c_get_placement_citem_id is
295: select ams_web_plce_citem_assoc_s.nextval
296: from dual;
297: BEGIN
298: if X_OWNER = 'SEED' then
299: l_user_id := 1;