APPS.AMS_DM_SOURCE_PKG dependencies on AMS_DM_SOURCE

Line 1: PACKAGE BODY AMS_DM_SOURCE_PKG as

1: PACKAGE BODY AMS_DM_SOURCE_PKG as
2: /* $Header: amstdsrb.pls 115.9 2003/09/03 19:26:46 nyostos ship $ */
3: -- Start of Comments
4: -- Package name : AMS_DM_SOURCE_PKG
5: -- Purpose :

Line 4: -- Package name : AMS_DM_SOURCE_PKG

1: PACKAGE BODY AMS_DM_SOURCE_PKG as
2: /* $Header: amstdsrb.pls 115.9 2003/09/03 19:26:46 nyostos ship $ */
3: -- Start of Comments
4: -- Package name : AMS_DM_SOURCE_PKG
5: -- Purpose :
6: -- History :
7: -- 26-Jan-2001 choang Removed object ver num increment and update criteria.
8: -- 30-jan-2001 choang Changed p_tree_node to p_rule_id.

Line 15: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_DM_SOURCE_PKG';

11: -- NOTE :
12: -- End of Comments
13:
14:
15: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_DM_SOURCE_PKG';
16: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amstdsrb.pls';
17:
18: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
19: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 43: CURSOR C IS SELECT rowid FROM AMS_DM_SOURCE

39: p_PERCENTILE NUMBER)
40: IS
41: X_ROWID VARCHAR2(30);
42:
43: CURSOR C IS SELECT rowid FROM AMS_DM_SOURCE
44: WHERE SOURCE_ID = px_SOURCE_ID;
45:
46: BEGIN
47:

Line 52: INSERT INTO AMS_DM_SOURCE(

48:
49: px_object_version_number := 1;
50:
51:
52: INSERT INTO AMS_DM_SOURCE(
53: SOURCE_ID,
54: LAST_UPDATE_DATE,
55: LAST_UPDATED_BY,
56: CREATION_DATE,

Line 114: Update AMS_DM_SOURCE

110: p_decile NUMBER,
111: p_PERCENTILE NUMBER)
112: IS
113: BEGIN
114: Update AMS_DM_SOURCE
115: SET
116: SOURCE_ID = decode( p_SOURCE_ID, FND_API.g_miss_num, SOURCE_ID, p_SOURCE_ID),
117: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.g_miss_date, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
118: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.g_miss_num, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 142: DELETE FROM AMS_DM_SOURCE

138: PROCEDURE Delete_Row(
139: p_SOURCE_ID NUMBER)
140: IS
141: BEGIN
142: DELETE FROM AMS_DM_SOURCE
143: WHERE SOURCE_ID = p_SOURCE_ID;
144: If (SQL%NOTFOUND) then
145: RAISE NO_DATA_FOUND;
146: End If;

Line 170: FROM AMS_DM_SOURCE

166: p_PERCENTILE NUMBER)
167: IS
168: CURSOR C IS
169: SELECT *
170: FROM AMS_DM_SOURCE
171: WHERE SOURCE_ID = p_SOURCE_ID
172: FOR UPDATE of SOURCE_ID NOWAIT;
173: Recinfo C%ROWTYPE;
174: BEGIN

Line 235: End AMS_DM_SOURCE_PKG;

231: APP_EXCEPTION.RAISE_EXCEPTION;
232: End If;
233: END Lock_Row;
234:
235: End AMS_DM_SOURCE_PKG;