APPS.AMS_IBA_PL_PLACEMENTS_B_PKG dependencies on AMS_IBA_PL_PLACEMENTS_B

Line 1: PACKAGE BODY AMS_IBA_PL_PLACEMENTS_B_PKG as

1: PACKAGE BODY AMS_IBA_PL_PLACEMENTS_B_PKG as
2: /* $Header: amstplcb.pls 120.0 2005/06/01 03:42:23 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_IBA_PL_PLACEMENTS_B_PKG

2: /* $Header: amstplcb.pls 120.0 2005/06/01 03:42:23 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_IBA_PL_PLACEMENTS_B_PKG
7: -- Purpose
8: --
9: -- History
10: --

Line 16: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_IBA_PL_PLACEMENTS_B_PKG';

12: --
13: -- End of Comments
14: -- ===============================================================
15:
16: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_IBA_PL_PLACEMENTS_B_PKG';
17: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amstplcb.pls';
18:
19: ----------------------------------------------------------
20: ---- MEDIA ----

Line 71: INSERT INTO AMS_IBA_PL_PLACEMENTS_B(

67:
68: px_object_version_number := 1;
69:
70:
71: INSERT INTO AMS_IBA_PL_PLACEMENTS_B(
72: placement_id,
73: site_id,
74: site_ref_code,
75: page_id,

Line 194: Update AMS_IBA_PL_PLACEMENTS_B

190: p_description VARCHAR2)
191:
192: IS
193: BEGIN
194: Update AMS_IBA_PL_PLACEMENTS_B
195: SET
196: site_id = DECODE( p_site_id, FND_API.g_miss_num, site_id, p_site_id),
197: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
198: page_id = DECODE( p_page_id, FND_API.g_miss_num, page_id, p_page_id),

Line 267: DELETE FROM ams_iba_pl_placements_b

263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
264: End If;
265:
266:
267: DELETE FROM ams_iba_pl_placements_b
268: WHERE placement_id = p_placement_id;
269:
270: If (SQL%NOTFOUND) then
271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 282: from AMS_IBA_PL_PLACEMENTS_B B

278: begin
279: delete from AMS_IBA_PL_PLACEMENTS_TL T
280: where not exists
281: (select NULL
282: from AMS_IBA_PL_PLACEMENTS_B B
283: where B.PLACEMENT_ID = T.PLACEMENT_ID
284: );
285:
286: update AMS_IBA_PL_PLACEMENTS_TL T set (

Line 385: FROM AMS_IBA_PL_PLACEMENTS_B

381:
382: IS
383: CURSOR C IS
384: SELECT *
385: FROM AMS_IBA_PL_PLACEMENTS_B
386: WHERE PLACEMENT_ID = p_PLACEMENT_ID
387: FOR UPDATE of PLACEMENT_ID NOWAIT;
388: Recinfo C%ROWTYPE;
389: BEGIN

Line 468: END AMS_IBA_PL_PLACEMENTS_B_PKG;

464: APP_EXCEPTION.RAISE_EXCEPTION;
465: END IF;
466: END Lock_Row;
467:
468: END AMS_IBA_PL_PLACEMENTS_B_PKG;