APPS.AMS_MET_TPL_HEADERS_PKG dependencies on AMS_MET_TPL_HEADERS

Line 1: package body AMS_MET_TPL_HEADERS_PKG as

1: package body AMS_MET_TPL_HEADERS_PKG as
2: /* $Header: amslmthb.pls 115.1 2000/01/09 17:55:04 pkm ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out VARCHAR2,
5: X_METRIC_TPL_HEADER_ID in NUMBER,

Line 18: cursor C is select ROWID from AMS_MET_TPL_HEADERS

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from AMS_MET_TPL_HEADERS
19: where METRIC_TPL_HEADER_ID = X_METRIC_TPL_HEADER_ID;
20: begin
21: insert into AMS_MET_TPL_HEADERS (
22: METRIC_TPL_HEADER_ID,

Line 21: insert into AMS_MET_TPL_HEADERS (

17: ) is
18: cursor C is select ROWID from AMS_MET_TPL_HEADERS
19: where METRIC_TPL_HEADER_ID = X_METRIC_TPL_HEADER_ID;
20: begin
21: insert into AMS_MET_TPL_HEADERS (
22: METRIC_TPL_HEADER_ID,
23: LAST_UPDATE_DATE,
24: LAST_UPDATED_BY,
25: CREATION_DATE,

Line 71: update AMS_MET_TPL_HEADERS set

67: X_LAST_UPDATED_BY in NUMBER,
68: X_LAST_UPDATE_LOGIN in NUMBER
69: ) is
70: begin
71: update AMS_MET_TPL_HEADERS set
72: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
73: METRIC_TPL_HEADER_NAME = X_METRIC_TPL_HEADER_NAME,
74: DESCRIPTION = X_DESCRIPTION,
75: ARC_ACT_METRIC_USED_BY = X_ARC_ACT_METRIC_USED_BY,

Line 93: delete from AMS_MET_TPL_HEADERS

89: procedure DELETE_ROW (
90: X_METRIC_TPL_HEADER_ID in NUMBER
91: ) is
92: begin
93: delete from AMS_MET_TPL_HEADERS
94: where METRIC_TPL_HEADER_ID = X_METRIC_TPL_HEADER_ID;
95:
96: if (sql%notfound) then
97: raise no_data_found;

Line 121: from AMS_MET_TPL_HEADERS

117: l_met_tpl_hdr_id number;
118:
119: cursor c_obj_verno is
120: select object_version_number
121: from AMS_MET_TPL_HEADERS
122: where METRIC_TPL_HEADER_ID = X_METRIC_TPL_HEADER_ID;
123:
124: cursor c_chk_mth_exists is
125: select 'x'

Line 126: from AMS_MET_TPL_HEADERS

122: where METRIC_TPL_HEADER_ID = X_METRIC_TPL_HEADER_ID;
123:
124: cursor c_chk_mth_exists is
125: select 'x'
126: from AMS_MET_TPL_HEADERS
127: where METRIC_TPL_HEADER_ID = X_METRIC_TPL_HEADER_ID;
128:
129: cursor c_get_mthid is
130: select AMS_MET_TPL_HEADERS_ALL_S.nextval

Line 130: select AMS_MET_TPL_HEADERS_ALL_S.nextval

126: from AMS_MET_TPL_HEADERS
127: where METRIC_TPL_HEADER_ID = X_METRIC_TPL_HEADER_ID;
128:
129: cursor c_get_mthid is
130: select AMS_MET_TPL_HEADERS_ALL_S.nextval
131: from dual;
132:
133: BEGIN
134:

Line 153: AMS_MET_TPL_HEADERS_PKG.INSERT_ROW(

149: else
150: l_met_tpl_hdr_id := X_METRIC_TPL_HEADER_ID;
151: end if;
152: l_obj_verno := 1;
153: AMS_MET_TPL_HEADERS_PKG.INSERT_ROW(
154: X_ROWID => l_row_id,
155: X_METRIC_TPL_HEADER_ID => l_met_tpl_hdr_id,
156: X_OBJECT_VERSION_NUMBER => l_obj_verno,
157: X_METRIC_TPL_HEADER_NAME => X_METRIC_TPL_HEADER_NAME,

Line 173: AMS_MET_TPL_HEADERS_PKG.UPDATE_ROW(

169: close c_chk_mth_exists;
170: open c_obj_verno;
171: fetch c_obj_verno into l_obj_verno;
172: close c_obj_verno;
173: AMS_MET_TPL_HEADERS_PKG.UPDATE_ROW(
174: X_METRIC_TPL_HEADER_ID => X_METRIC_TPL_HEADER_ID,
175: X_OBJECT_VERSION_NUMBER => l_obj_verno + 1,
176: X_METRIC_TPL_HEADER_NAME => X_METRIC_TPL_HEADER_NAME,
177: X_DESCRIPTION => X_DESCRIPTION,

Line 190: end AMS_MET_TPL_HEADERS_PKG;

186: end if;
187:
188: END LOAD_ROW;
189:
190: end AMS_MET_TPL_HEADERS_PKG;