APPS.AMS_IBA_PS_CNDCLSES_B_PKG dependencies on AMS_IBA_PS_CNDCLSES_B

Line 1: PACKAGE BODY AMS_IBA_PS_CNDCLSES_B_PKG as

1: PACKAGE BODY AMS_IBA_PS_CNDCLSES_B_PKG as
2: /* $Header: amstcclb.pls 120.0 2005/05/31 16:25:45 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_IBA_PS_CNDCLSES_B_PKG

2: /* $Header: amstcclb.pls 120.0 2005/05/31 16:25:45 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_IBA_PS_CNDCLSES_B_PKG
7: -- Purpose
8: --
9: -- History
10: --

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

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

Line 56: INSERT INTO AMS_IBA_PS_CNDCLSES_B(

52: BEGIN
53:
54: px_object_version_number := 1;
55:
56: INSERT INTO AMS_IBA_PS_CNDCLSES_B(
57: created_by,
58: creation_date,
59: last_updated_by,
60: last_update_date,

Line 150: Update AMS_IBA_PS_CNDCLSES_B

146: p_cnd_clause_description VARCHAR2)
147:
148: IS
149: BEGIN
150: Update AMS_IBA_PS_CNDCLSES_B
151: SET
152: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
153: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
154: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 206: DELETE FROM AMS_IBA_PS_CNDCLSES_B

202: PROCEDURE Delete_Row(
203: p_CND_CLAUSE_ID NUMBER)
204: IS
205: BEGIN
206: DELETE FROM AMS_IBA_PS_CNDCLSES_B
207: WHERE CND_CLAUSE_ID = p_CND_CLAUSE_ID;
208: If (SQL%NOTFOUND) then
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210: End If;

Line 226: from AMS_IBA_PS_CNDCLSES_B B

222: begin
223: delete from AMS_IBA_PS_CNDCLSES_TL T
224: where not exists
225: (select NULL
226: from AMS_IBA_PS_CNDCLSES_B B
227: where B.CND_CLAUSE_ID = T.CND_CLAUSE_ID
228: );
229:
230: update AMS_IBA_PS_CNDCLSES_TL T set (

Line 321: FROM AMS_IBA_PS_CNDCLSES_B

317:
318: IS
319: CURSOR C IS
320: SELECT *
321: FROM AMS_IBA_PS_CNDCLSES_B
322: WHERE CND_CLAUSE_ID = p_CND_CLAUSE_ID
323: FOR UPDATE of CND_CLAUSE_ID NOWAIT;
324: Recinfo C%ROWTYPE;
325: BEGIN

Line 374: END AMS_IBA_PS_CNDCLSES_B_PKG;

370: APP_EXCEPTION.RAISE_EXCEPTION;
371: END IF;
372: END Lock_Row;
373:
374: END AMS_IBA_PS_CNDCLSES_B_PKG;