APPS.AMS_WEB_PLCE_MP_PKG dependencies on AMS_WEB_PLCE_MP_B

Line 40: cursor C is select ROWID from AMS_WEB_PLCE_MP_B

36: X_LAST_UPDATE_DATE in DATE,
37: X_LAST_UPDATED_BY in NUMBER,
38: X_LAST_UPDATE_LOGIN in NUMBER
39: ) is
40: cursor C is select ROWID from AMS_WEB_PLCE_MP_B
41: where PLACEMENT_MP_ID = X_PLACEMENT_MP_ID
42: ;
43: begin
44: insert into AMS_WEB_PLCE_MP_B (

Line 44: insert into AMS_WEB_PLCE_MP_B (

40: cursor C is select ROWID from AMS_WEB_PLCE_MP_B
41: where PLACEMENT_MP_ID = X_PLACEMENT_MP_ID
42: ;
43: begin
44: insert into AMS_WEB_PLCE_MP_B (
45: PLACEMENT_MP_ID,
46: PLACEMENT_ID,
47: CONTENT_ITEM_ID,
48: CITEM_VERSION_ID,

Line 214: from AMS_WEB_PLCE_MP_B

210: ATTRIBUTE13,
211: ATTRIBUTE14,
212: ATTRIBUTE15,
213: CONTENT_TYPE_CODE
214: from AMS_WEB_PLCE_MP_B
215: where PLACEMENT_MP_ID = X_PLACEMENT_MP_ID
216: for update of PLACEMENT_MP_ID nowait;
217: recinfo c%rowtype;
218:

Line 341: update AMS_WEB_PLCE_MP_B set

337: X_LAST_UPDATED_BY in NUMBER,
338: X_LAST_UPDATE_LOGIN in NUMBER
339: ) is
340: begin
341: update AMS_WEB_PLCE_MP_B set
342: PLACEMENT_ID = X_PLACEMENT_ID,
343: CONTENT_ITEM_ID = X_CONTENT_ITEM_ID,
344: CITEM_VERSION_ID = X_CITEM_VERSION_ID,
345: DISPLAY_PRIORITY = X_DISPLAY_PRIORITY,

Line 403: delete from AMS_WEB_PLCE_MP_B

399: if (sql%notfound) then
400: raise no_data_found;
401: end if;
402:
403: delete from AMS_WEB_PLCE_MP_B
404: where PLACEMENT_MP_ID = X_PLACEMENT_MP_ID;
405:
406: if (sql%notfound) then
407: raise no_data_found;

Line 417: from AMS_WEB_PLCE_MP_B B

413: begin
414: delete from AMS_WEB_PLCE_MP_TL T
415: where not exists
416: (select NULL
417: from AMS_WEB_PLCE_MP_B B
418: where B.PLACEMENT_MP_ID = T.PLACEMENT_MP_ID
419: );
420:
421: update AMS_WEB_PLCE_MP_TL T set (