APPS.AMS_MET_TPL_ASSOCS_PKG dependencies on AMS_MET_TPL_ASSOCS

Line 1: PACKAGE BODY AMS_MET_TPL_ASSOCS_PKG AS

1: PACKAGE BODY AMS_MET_TPL_ASSOCS_PKG AS
2: /* $Header: amslmtab.pls 115.10 2003/03/07 22:45:44 dmvincen ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_MET_TPL_ASSOCS_PKG

2: /* $Header: amslmtab.pls 115.10 2003/03/07 22:45:44 dmvincen ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_MET_TPL_ASSOCS_PKG
7: -- Purpose
8: --
9: -- History
10: -- 03/05/2002 dmvincen Created.

Line 20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_MET_TPL_ASSOCS_PKG';

16: -- End of Comments
17: -- ===============================================================
18:
19:
20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_MET_TPL_ASSOCS_PKG';
21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amslmtab.pls';
22:
23:
24: ----------------------------------------------------------

Line 65: INSERT INTO AMS_MET_TPL_ASSOCS(

61: BEGIN
62:
63: -- px_object_version_number := 1;
64:
65: INSERT INTO AMS_MET_TPL_ASSOCS(
66: metric_tpl_assoc_id,
67: last_update_date,
68: last_updated_by,
69: creation_date,

Line 124: UPDATE AMS_MET_TPL_ASSOCS

120: p_enabled_flag VARCHAR2)
121:
122: IS
123: BEGIN
124: UPDATE AMS_MET_TPL_ASSOCS
125: SET
126: metric_tpl_assoc_id = DECODE( p_metric_tpl_assoc_id, FND_API.g_miss_num, metric_tpl_assoc_id, p_metric_tpl_assoc_id),
127: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
128: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 165: DELETE FROM AMS_MET_TPL_ASSOCS

161: PROCEDURE Delete_Row(
162: p_METRIC_TPL_ASSOC_ID NUMBER)
163: IS
164: BEGIN
165: DELETE FROM AMS_MET_TPL_ASSOCS
166: WHERE METRIC_TPL_ASSOC_ID = p_METRIC_TPL_ASSOC_ID;
167: IF (SQL%NOTFOUND) THEN
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
169: END IF;

Line 207: FROM AMS_MET_TPL_ASSOCS

203:
204: IS
205: CURSOR C IS
206: SELECT *
207: FROM AMS_MET_TPL_ASSOCS
208: WHERE METRIC_TPL_ASSOC_ID = p_METRIC_TPL_ASSOC_ID
209: FOR UPDATE OF METRIC_TPL_ASSOC_ID NOWAIT;
210: Recinfo C%ROWTYPE;
211: BEGIN

Line 283: FROM AMS_MET_TPL_ASSOCS

279: l_db_luby_id NUMBER;
280:
281: CURSOR c_db_data_details IS
282: SELECT last_updated_by, object_version_number
283: FROM AMS_MET_TPL_ASSOCS
284: WHERE METRIC_TPL_ASSOC_ID = X_METRIC_TPL_ASSOC_ID;
285:
286: CURSOR c_get_mtaid IS
287: SELECT AMS_MET_TPL_ASSOCS_S.NEXTVAL

Line 287: SELECT AMS_MET_TPL_ASSOCS_S.NEXTVAL

283: FROM AMS_MET_TPL_ASSOCS
284: WHERE METRIC_TPL_ASSOC_ID = X_METRIC_TPL_ASSOC_ID;
285:
286: CURSOR c_get_mtaid IS
287: SELECT AMS_MET_TPL_ASSOCS_S.NEXTVAL
288: FROM dual;
289:
290: BEGIN
291: if X_OWNER = 'SEED' then

Line 348: END AMS_MET_TPL_ASSOCS_PKG;

344: END IF;
345: END IF;
346: END LOAD_ROW;
347:
348: END AMS_MET_TPL_ASSOCS_PKG;