APPS.AMS_IBA_PS_RULES_PKG dependencies on AMS_IBA_PS_RULES

Line 1: PACKAGE BODY AMS_IBA_PS_RULES_PKG as

1: PACKAGE BODY AMS_IBA_PS_RULES_PKG as
2: /* $Header: amstrulb.pls 120.0 2005/05/31 14:42:20 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_IBA_PS_RULES_PKG

2: /* $Header: amstrulb.pls 120.0 2005/05/31 14:42:20 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_IBA_PS_RULES_PKG
7: -- Purpose
8: --
9: -- History
10: --

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_IBA_PS_RULES_PKG';

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

Line 77: INSERT INTO AMS_IBA_PS_RULES(

73:
74: px_object_version_number := 1;
75:
76:
77: INSERT INTO AMS_IBA_PS_RULES(
78: created_by,
79: creation_date,
80: last_updated_by,
81: last_update_date,

Line 186: Update AMS_IBA_PS_RULES

182: p_use_clause9 VARCHAR2,
183: p_use_clause10 VARCHAR2)
184: IS
185: BEGIN
186: Update AMS_IBA_PS_RULES
187: SET
188: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
189: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 244: DELETE FROM AMS_IBA_PS_RULES

240: PROCEDURE Delete_Row(
241: p_RULE_ID NUMBER)
242: IS
243: BEGIN
244: DELETE FROM AMS_IBA_PS_RULES
245: WHERE RULE_ID = p_RULE_ID;
246: If (SQL%NOTFOUND) then
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: End If;

Line 296: FROM AMS_IBA_PS_RULES

292:
293: IS
294: CURSOR C IS
295: SELECT *
296: FROM AMS_IBA_PS_RULES
297: WHERE RULE_ID = p_RULE_ID
298: FOR UPDATE of RULE_ID NOWAIT;
299: Recinfo C%ROWTYPE;
300: BEGIN

Line 382: END AMS_IBA_PS_RULES_PKG;

378: APP_EXCEPTION.RAISE_EXCEPTION;
379: END IF;
380: END Lock_Row;
381:
382: END AMS_IBA_PS_RULES_PKG;