APPS.ALR_ALERT_INPUTS_PKG dependencies on ALR_ALERT_INPUTS

Line 1: package body ALR_ALERT_INPUTS_PKG as

1: package body ALR_ALERT_INPUTS_PKG as
2: /* $Header: ALRAINPB.pls 120.5.12010000.1 2008/07/27 06:58:16 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_APPLICATION_ID in NUMBER,

Line 20: cursor C is select ROWID from ALR_ALERT_INPUTS

16: X_LAST_UPDATE_DATE in DATE,
17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: cursor C is select ROWID from ALR_ALERT_INPUTS
21: where APPLICATION_ID = X_APPLICATION_ID
22: and ALERT_ID = X_ALERT_ID
23: and NAME = X_NAME
24: ;

Line 26: insert into ALR_ALERT_INPUTS (

22: and ALERT_ID = X_ALERT_ID
23: and NAME = X_NAME
24: ;
25: begin
26: insert into ALR_ALERT_INPUTS (
27: LAST_UPDATED_BY,
28: CREATED_BY,
29: LAST_UPDATE_LOGIN,
30: ENABLED_FLAG,

Line 111: from ALR_ALERT_INPUTS

107: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
108:
109: select last_updated_by, last_update_date
110: into db_luby, db_ludate
111: from ALR_ALERT_INPUTS
112: where application_id = l_app_id
113: and alert_id = l_alert_id
114: and name = X_NAME;
115:

Line 119: ALR_ALERT_INPUTS_PKG.UPDATE_ROW(

115:
116: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
117: x_custom_mode)) then
118:
119: ALR_ALERT_INPUTS_PKG.UPDATE_ROW(
120: X_APPLICATION_ID => l_app_id,
121: X_ALERT_ID => l_alert_id,
122: X_NAME => X_NAME,
123: X_ENABLED_FLAG => X_ENABLED_FLAG,

Line 139: ALR_ALERT_INPUTS_PKG.INSERT_ROW(

135:
136: exception
137: when NO_DATA_FOUND then
138:
139: ALR_ALERT_INPUTS_PKG.INSERT_ROW(
140: X_ROWID => l_row_id,
141: X_APPLICATION_ID => l_app_id,
142: X_ALERT_ID => l_alert_id,
143: X_NAME => X_NAME,

Line 181: from ALR_ALERT_INPUTS

177: END_DATE_ACTIVE,
178: TITLE,
179: DATA_TYPE,
180: DEFAULT_VALUE
181: from ALR_ALERT_INPUTS
182: where APPLICATION_ID = X_APPLICATION_ID
183: and ALERT_ID = X_ALERT_ID
184: and NAME = X_NAME
185: for update of APPLICATION_ID nowait;

Line 224: update ALR_ALERT_INPUTS set

220: X_LAST_UPDATED_BY in NUMBER,
221: X_LAST_UPDATE_LOGIN in NUMBER
222: ) is
223: begin
224: update ALR_ALERT_INPUTS set
225: ENABLED_FLAG = X_ENABLED_FLAG,
226: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
227: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
228: TITLE = X_TITLE,

Line 252: delete from ALR_ALERT_INPUTS

248: X_ALERT_ID in NUMBER,
249: X_NAME in VARCHAR2
250: ) is
251: begin
252: delete from ALR_ALERT_INPUTS
253: where APPLICATION_ID = X_APPLICATION_ID
254: and ALERT_ID = X_ALERT_ID
255: and NAME = X_NAME;
256:

Line 263: end ALR_ALERT_INPUTS_PKG;

259: end if;
260:
261: end DELETE_ROW;
262:
263: end ALR_ALERT_INPUTS_PKG;