APPS.AMS_WEB_PLACEMENTS_PKG dependencies on AMS_WEB_PLACEMENTS_B

Line 50: cursor C is select ROWID from AMS_WEB_PLACEMENTS_B

46: X_LAST_UPDATE_DATE in DATE,
47: X_LAST_UPDATED_BY in NUMBER,
48: X_LAST_UPDATE_LOGIN in NUMBER
49: ) is
50: cursor C is select ROWID from AMS_WEB_PLACEMENTS_B
51: where PLACEMENT_ID = X_PLACEMENT_ID
52: ;
53: begin
54: insert into AMS_WEB_PLACEMENTS_B (

Line 54: insert into AMS_WEB_PLACEMENTS_B (

50: cursor C is select ROWID from AMS_WEB_PLACEMENTS_B
51: where PLACEMENT_ID = X_PLACEMENT_ID
52: ;
53: begin
54: insert into AMS_WEB_PLACEMENTS_B (
55: PLACEMENT_ID,
56: PLACEMENT_CATEGORY,
57: SITE_ID,
58: SITE_REF_CODE,

Line 264: from AMS_WEB_PLACEMENTS_B

260: ATTRIBUTE12,
261: ATTRIBUTE13,
262: ATTRIBUTE14,
263: ATTRIBUTE15
264: from AMS_WEB_PLACEMENTS_B
265: where PLACEMENT_ID = X_PLACEMENT_ID
266: for update of PLACEMENT_ID nowait;
267: recinfo c%rowtype;
268:

Line 421: update AMS_WEB_PLACEMENTS_B set

417: X_LAST_UPDATED_BY in NUMBER,
418: X_LAST_UPDATE_LOGIN in NUMBER
419: ) is
420: begin
421: update AMS_WEB_PLACEMENTS_B set
422: PLACEMENT_CATEGORY = X_PLACEMENT_CATEGORY,
423: SITE_ID = X_SITE_ID,
424: SITE_REF_CODE = X_SITE_REF_CODE,
425: PAGE_ID = X_PAGE_ID,

Line 493: delete from AMS_WEB_PLACEMENTS_B

489: if (sql%notfound) then
490: raise no_data_found;
491: end if;
492:
493: delete from AMS_WEB_PLACEMENTS_B
494: where PLACEMENT_ID = X_PLACEMENT_ID;
495:
496: if (sql%notfound) then
497: raise no_data_found;

Line 507: from AMS_WEB_PLACEMENTS_B B

503: begin
504: delete from AMS_WEB_PLACEMENTS_TL T
505: where not exists
506: (select NULL
507: from AMS_WEB_PLACEMENTS_B B
508: where B.PLACEMENT_ID = T.PLACEMENT_ID
509: );
510:
511: update AMS_WEB_PLACEMENTS_TL T set (