APPS.AMW_THRESHOLD_VALUES_PKG dependencies on AMW_THRESHOLD_VALUES

Line 1: package body AMW_THRESHOLD_VALUES_PKG as

1: package body AMW_THRESHOLD_VALUES_PKG as
2: /* $Header: amwtthrb.pls 115.3 2004/01/08 01:38:52 cpetriuc noship $ */
3:
4: procedure INSERT_ROW (
5: X_THRESHOLD_ID in NUMBER,

Line 18: insert into AMW_THRESHOLD_VALUES (

14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: begin
18: insert into AMW_THRESHOLD_VALUES (
19: THRESHOLD_ID,
20: START_PERCENT_VALUE,
21: END_PERCENT_VALUE,
22: IMAGE_FILE,

Line 59: from AMW_THRESHOLD_VALUES

55: END_PERCENT_VALUE,
56: IMAGE_FILE,
57: SECURITY_GROUP_ID,
58: OBJECT_VERSION_NUMBER
59: from AMW_THRESHOLD_VALUES
60: where THRESHOLD_ID = X_THRESHOLD_ID
61: for update of THRESHOLD_ID nowait;
62: recinfo c%rowtype;
63:

Line 106: update AMW_THRESHOLD_VALUES set

102: X_LAST_UPDATED_BY in NUMBER,
103: X_LAST_UPDATE_LOGIN in NUMBER
104: ) is
105: begin
106: update AMW_THRESHOLD_VALUES set
107: THRESHOLD_ID = X_THRESHOLD_ID,
108: START_PERCENT_VALUE = X_START_PERCENT_VALUE,
109: END_PERCENT_VALUE = X_END_PERCENT_VALUE,
110: IMAGE_FILE = X_IMAGE_FILE,

Line 127: delete from AMW_THRESHOLD_VALUES

123: procedure DELETE_ROW (
124: X_THRESHOLD_ID in NUMBER
125: ) is
126: begin
127: delete from AMW_THRESHOLD_VALUES
128: where THRESHOLD_ID = X_THRESHOLD_ID;
129:
130: if (sql%notfound) then
131: raise no_data_found;

Line 158: from AMW_THRESHOLD_VALUES

154: -- Translate char last_update_date to date
155: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
156:
157: select last_updated_by, last_update_date into db_luby, db_ludate
158: from AMW_THRESHOLD_VALUES
159: where threshold_id = X_THRESHOLD_ID;
160:
161: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
162: then AMW_THRESHOLD_VALUES_PKG.UPDATE_ROW(

Line 162: then AMW_THRESHOLD_VALUES_PKG.UPDATE_ROW(

158: from AMW_THRESHOLD_VALUES
159: where threshold_id = X_THRESHOLD_ID;
160:
161: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
162: then AMW_THRESHOLD_VALUES_PKG.UPDATE_ROW(
163: X_THRESHOLD_ID => X_THRESHOLD_ID,
164: X_START_PERCENT_VALUE => X_START_PERCENT_VALUE,
165: X_END_PERCENT_VALUE => X_END_PERCENT_VALUE,
166: X_IMAGE_FILE => X_IMAGE_FILE,

Line 174: then AMW_THRESHOLD_VALUES_PKG.INSERT_ROW(

170: X_LAST_UPDATED_BY => f_luby,
171: X_LAST_UPDATE_LOGIN => 0);
172: end if;
173: exception when NO_DATA_FOUND
174: then AMW_THRESHOLD_VALUES_PKG.INSERT_ROW(
175: X_THRESHOLD_ID => X_THRESHOLD_ID,
176: X_START_PERCENT_VALUE => X_START_PERCENT_VALUE,
177: X_END_PERCENT_VALUE => X_END_PERCENT_VALUE,
178: X_IMAGE_FILE => X_IMAGE_FILE,

Line 188: end AMW_THRESHOLD_VALUES_PKG;

184: X_LAST_UPDATED_BY => f_luby,
185: X_LAST_UPDATE_LOGIN => 0);
186: end LOAD_ROW;
187:
188: end AMW_THRESHOLD_VALUES_PKG;