APPS.AMS_MET_TPL_DETAILS_PKG dependencies on AMS_MET_TPL_DETAILS

Line 1: PACKAGE BODY Ams_Met_Tpl_Details_Pkg AS

1: PACKAGE BODY Ams_Met_Tpl_Details_Pkg AS
2: /* $Header: amslmtdb.pls 115.12 2003/03/07 22:45:50 dmvincen ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_MET_TPL_DETAILS_PKG

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

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

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

Line 66: INSERT INTO AMS_MET_TPL_DETAILS(

62:
63: -- px_object_version_number := 1;
64:
65:
66: INSERT INTO AMS_MET_TPL_DETAILS(
67: metric_template_detail_id,
68: last_update_date,
69: last_updated_by,
70: creation_date,

Line 119: UPDATE AMS_MET_TPL_DETAILS

115: p_enabled_flag VARCHAR2)
116:
117: IS
118: BEGIN
119: UPDATE AMS_MET_TPL_DETAILS
120: SET
121: metric_template_detail_id = DECODE( p_metric_template_detail_id, FND_API.g_miss_num, metric_template_detail_id, p_metric_template_detail_id),
122: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
123: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 158: DELETE FROM AMS_MET_TPL_DETAILS

154: PROCEDURE Delete_Row(
155: p_METRIC_TEMPLATE_DETAIL_ID NUMBER)
156: IS
157: BEGIN
158: DELETE FROM AMS_MET_TPL_DETAILS
159: WHERE METRIC_TEMPLATE_DETAIL_ID = p_METRIC_TEMPLATE_DETAIL_ID;
160: IF (SQL%NOTFOUND) THEN
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162: END IF;

Line 198: FROM AMS_MET_TPL_DETAILS

194:
195: IS
196: CURSOR C IS
197: SELECT *
198: FROM AMS_MET_TPL_DETAILS
199: WHERE METRIC_TEMPLATE_DETAIL_ID = p_METRIC_TEMPLATE_DETAIL_ID
200: FOR UPDATE OF METRIC_TEMPLATE_DETAIL_ID NOWAIT;
201: Recinfo C%ROWTYPE;
202: BEGIN

Line 266: FROM AMS_MET_TPL_DETAILS

262: l_db_luby_id NUMBER;
263:
264: CURSOR c_db_data_details IS
265: SELECT last_updated_by, object_version_number
266: FROM AMS_MET_TPL_DETAILS
267: WHERE METRIC_TEMPLATE_DETAIL_ID = X_METRIC_TEMPLATE_DETAIL_ID;
268:
269: CURSOR c_get_mtdid IS
270: SELECT AMS_MET_TPL_DETAILS_S.NEXTVAL

Line 270: SELECT AMS_MET_TPL_DETAILS_S.NEXTVAL

266: FROM AMS_MET_TPL_DETAILS
267: WHERE METRIC_TEMPLATE_DETAIL_ID = X_METRIC_TEMPLATE_DETAIL_ID;
268:
269: CURSOR c_get_mtdid IS
270: SELECT AMS_MET_TPL_DETAILS_S.NEXTVAL
271: FROM dual;
272:
273: BEGIN
274:

Line 328: END Ams_Met_Tpl_Details_Pkg;

324: END IF;
325: END IF;
326: END LOAD_ROW;
327:
328: END Ams_Met_Tpl_Details_Pkg;