APPS.AMS_DM_PERFORMANCE_PKG dependencies on AMS_DM_PERFORMANCE

Line 1: PACKAGE BODY AMS_DM_PERFORMANCE_PKG as

1: PACKAGE BODY AMS_DM_PERFORMANCE_PKG as
2: /* $Header: amstdpfb.pls 120.1 2005/06/15 23:58:08 appldev $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_DM_PERFORMANCE_PKG

2: /* $Header: amstdpfb.pls 120.1 2005/06/15 23:58:08 appldev $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_DM_PERFORMANCE_PKG
7: -- Purpose
8: --
9: -- History
10: -- 26-Jan-2001 choang Removed object ver num from update criteria.

Line 19: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_DM_PERFORMANCE_PKG';

15: -- End of Comments
16: -- ===============================================================
17:
18:
19: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_DM_PERFORMANCE_PKG';
20: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amstdpfb.pls';
21:
22: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
23: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 45: INSERT INTO AMS_DM_PERFORMANCE(

41: BEGIN
42: px_object_version_number := 1;
43:
44:
45: INSERT INTO AMS_DM_PERFORMANCE(
46: performance_id,
47: last_update_date,
48: last_updated_by,
49: creation_date,

Line 89: Update AMS_DM_PERFORMANCE

85: p_model_id NUMBER)
86:
87: IS
88: BEGIN
89: Update AMS_DM_PERFORMANCE
90: SET
91: performance_id = DECODE( p_performance_id, FND_API.g_miss_num, performance_id, p_performance_id),
92: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
93: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 112: DELETE FROM AMS_DM_PERFORMANCE

108: PROCEDURE Delete_Row(
109: p_PERFORMANCE_ID NUMBER)
110: IS
111: BEGIN
112: DELETE FROM AMS_DM_PERFORMANCE
113: WHERE PERFORMANCE_ID = p_PERFORMANCE_ID;
114: If (SQL%NOTFOUND) then
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: End If;

Line 137: FROM AMS_DM_PERFORMANCE

133:
134: IS
135: CURSOR C IS
136: SELECT *
137: FROM AMS_DM_PERFORMANCE
138: WHERE PERFORMANCE_ID = p_PERFORMANCE_ID
139: FOR UPDATE of PERFORMANCE_ID NOWAIT;
140: Recinfo C%ROWTYPE;
141: BEGIN

Line 193: END AMS_DM_PERFORMANCE_PKG;

189: APP_EXCEPTION.RAISE_EXCEPTION;
190: END IF;
191: END Lock_Row;
192:
193: END AMS_DM_PERFORMANCE_PKG;