APPS.ALR_ALERT_INSTALLATIONS_PKG dependencies on ALR_ALERT_INSTALLATIONS

Line 1: package body ALR_ALERT_INSTALLATIONS_PKG as

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

Line 18: cursor C is select ROWID from ALR_ALERT_INSTALLATIONS

14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16:
17: /* oracle_id and data_group_id can be null */
18: cursor C is select ROWID from ALR_ALERT_INSTALLATIONS
19: where APPLICATION_ID = X_APPLICATION_ID
20: and ALERT_ID = X_ALERT_ID
21: and (((ORACLE_ID is null)
22: and (X_ORACLE_ID is null))

Line 31: insert into ALR_ALERT_INSTALLATIONS (

27: or ((DATA_GROUP_ID is not null)
28: and (DATA_GROUP_ID = X_DATA_GROUP_ID)))
29: ;
30: begin
31: insert into ALR_ALERT_INSTALLATIONS (
32: APPLICATION_ID,
33: ALERT_ID,
34: ORACLE_ID,
35: DATA_GROUP_ID,

Line 122: from ALR_ALERT_INSTALLATIONS

118:
119:
120: select last_updated_by, last_update_date
121: into db_luby, db_ludate
122: from ALR_ALERT_INSTALLATIONS
123: where application_id = l_app_id
124: and alert_id = l_alert_id
125: and ((data_group_id is null and l_data_group_id is null) or
126: data_group_id = l_data_group_id)

Line 133: ALR_ALERT_INSTALLATIONS_PKG.UPDATE_ROW(

129:
130: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
131: x_custom_mode)) then
132:
133: ALR_ALERT_INSTALLATIONS_PKG.UPDATE_ROW(
134: X_APPLICATION_ID => l_app_id,
135: X_ALERT_ID => l_alert_id,
136: X_ORACLE_ID => l_oracle_id,
137: X_DATA_GROUP_ID => l_data_group_id,

Line 153: ALR_ALERT_INSTALLATIONS_PKG.INSERT_ROW(

149:
150: -- insert into applsys.nancy values ('insert l_user_id', l_user_id);
151: -- commit;
152:
153: ALR_ALERT_INSTALLATIONS_PKG.INSERT_ROW(
154: X_ROWID => l_row_id,
155: X_APPLICATION_ID => l_app_id,
156: X_ALERT_ID => l_alert_id,
157: X_ORACLE_ID => l_oracle_id,

Line 182: from ALR_ALERT_INSTALLATIONS

178: APPLICATION_ID,
179: ALERT_ID,
180: ORACLE_ID,
181: DATA_GROUP_ID
182: from ALR_ALERT_INSTALLATIONS
183: where APPLICATION_ID = X_APPLICATION_ID
184: and ALERT_ID = X_ALERT_ID
185: and (((ORACLE_ID is null)
186: and (X_ORACLE_ID is null))

Line 224: update ALR_ALERT_INSTALLATIONS set

220: X_LAST_UPDATED_BY in NUMBER,
221: X_LAST_UPDATE_LOGIN in NUMBER
222: ) is
223: begin
224: update ALR_ALERT_INSTALLATIONS set
225: ENABLED_FLAG = X_ENABLED_FLAG,
226: APPLICATION_ID = X_APPLICATION_ID,
227: ALERT_ID = X_ALERT_ID,
228: ORACLE_ID = X_ORACLE_ID,

Line 256: delete from ALR_ALERT_INSTALLATIONS

252: X_ORACLE_ID in NUMBER,
253: X_DATA_GROUP_ID in NUMBER
254: ) is
255: begin
256: delete from ALR_ALERT_INSTALLATIONS
257: where APPLICATION_ID = X_APPLICATION_ID
258: and ALERT_ID = X_ALERT_ID
259: and (((ORACLE_ID is null)
260: and (X_ORACLE_ID is null))

Line 274: end ALR_ALERT_INSTALLATIONS_PKG;

270: end if;
271:
272: end DELETE_ROW;
273:
274: end ALR_ALERT_INSTALLATIONS_PKG;