APPS.AMS_METRIC_FORMULAS_PKG dependencies on AMS_METRIC_FORMULAS

Line 1: PACKAGE BODY AMS_METRIC_FORMULAS_PKG as

1: PACKAGE BODY AMS_METRIC_FORMULAS_PKG as
2: /* $Header: amslmtfb.pls 115.2 2003/09/30 22:47:57 dmvincen noship $ */
3: -- ===============================================================
4: -- Package name
5: -- AMS_METRIC_FORMULAS_PKG

Line 5: -- AMS_METRIC_FORMULAS_PKG

1: PACKAGE BODY AMS_METRIC_FORMULAS_PKG as
2: /* $Header: amslmtfb.pls 115.2 2003/09/30 22:47:57 dmvincen noship $ */
3: -- ===============================================================
4: -- Package name
5: -- AMS_METRIC_FORMULAS_PKG
6: -- Purpose
7: --
8: -- History
9: -- 08/20/2003 dmvincen Created.

Line 37: cursor C is select ROWID from AMS_METRIC_FORMULAS

33: X_LAST_UPDATE_DATE in DATE,
34: X_LAST_UPDATED_BY in NUMBER,
35: X_LAST_UPDATE_LOGIN in NUMBER
36: ) is
37: cursor C is select ROWID from AMS_METRIC_FORMULAS
38: where METRIC_FORMULA_ID = X_METRIC_FORMULA_ID;
39: l_rowid VARCHAR2(1000);
40: begin
41: insert into AMS_METRIC_FORMULAS (

Line 41: insert into AMS_METRIC_FORMULAS (

37: cursor C is select ROWID from AMS_METRIC_FORMULAS
38: where METRIC_FORMULA_ID = X_METRIC_FORMULA_ID;
39: l_rowid VARCHAR2(1000);
40: begin
41: insert into AMS_METRIC_FORMULAS (
42: METRIC_FORMULA_ID,
43: METRIC_ID,
44: SOURCE_TYPE,
45: SOURCE_ID,

Line 111: from AMS_METRIC_FORMULAS

107: SOURCE_VALUE,
108: TOKEN,
109: SEQUENCE,
110: NOTATION_TYPE
111: from AMS_METRIC_FORMULAS
112: where METRIC_FORMULA_ID = X_METRIC_FORMULA_ID
113: for update of METRIC_FORMULA_ID nowait;
114: recinfo c%rowtype;
115:

Line 166: update AMS_METRIC_FORMULAS set

162: X_LAST_UPDATED_BY in NUMBER,
163: X_LAST_UPDATE_LOGIN in NUMBER
164: ) is
165: begin
166: update AMS_METRIC_FORMULAS set
167: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
168: METRIC_ID = X_METRIC_ID,
169: SOURCE_TYPE = X_SOURCE_TYPE,
170: SOURCE_ID = X_SOURCE_ID,

Line 192: delete from AMS_METRIC_FORMULAS

188: procedure DELETE_ROW (
189: X_METRIC_FORMULA_ID in NUMBER
190: ) is
191: begin
192: delete from AMS_METRIC_FORMULAS
193: where METRIC_FORMULA_ID = X_METRIC_FORMULA_ID;
194:
195: if (sql%notfound) then
196: raise no_data_found;

Line 224: from AMS_METRIC_FORMULAS

220: l_db_luby_id NUMBER;
221:
222: cursor c_db_data_details is
223: select last_updated_by, object_version_number
224: from AMS_METRIC_FORMULAS
225: where metric_formula_id = X_METRIC_FORMULA_ID;
226:
227: cursor c_get_mtfid is
228: select AMS_METRIC_FORMULAS_S.nextval

Line 228: select AMS_METRIC_FORMULAS_S.nextval

224: from AMS_METRIC_FORMULAS
225: where metric_formula_id = X_METRIC_FORMULA_ID;
226:
227: cursor c_get_mtfid is
228: select AMS_METRIC_FORMULAS_S.nextval
229: from dual;
230:
231: BEGIN
232:

Line 302: end AMS_METRIC_FORMULAS_PKG;

298: end if;
299: end if;
300: END LOAD_ROW;
301:
302: end AMS_METRIC_FORMULAS_PKG;