APPS.ALR_ACTION_GROUPS_PKG dependencies on ALR_ACTION_GROUPS

Line 1: package body ALR_ACTION_GROUPS_PKG as

1: package body ALR_ACTION_GROUPS_PKG as
2: /* $Header: ALRAGRPB.pls 120.3.12010000.1 2008/07/27 06:58:14 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_ACTION_GROUPS

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_ACTION_GROUPS
21: where APPLICATION_ID = X_APPLICATION_ID
22: and ACTION_GROUP_ID = X_ACTION_GROUP_ID
23: ;
24: begin

Line 25: insert into ALR_ACTION_GROUPS (

21: where APPLICATION_ID = X_APPLICATION_ID
22: and ACTION_GROUP_ID = X_ACTION_GROUP_ID
23: ;
24: begin
25: insert into ALR_ACTION_GROUPS (
26: APPLICATION_ID,
27: ACTION_GROUP_ID,
28: NAME,
29: ALERT_ID,

Line 109: from ALR_ACTION_GROUPS

105: where APPLICATION_ID = l_app_id
106: and ALERT_NAME = X_ALERT_NAME;
107:
108: select ACTION_GROUP_ID into l_action_group_id
109: from ALR_ACTION_GROUPS
110: where APPLICATION_ID = l_app_id
111: and ALERT_ID = l_alert_id
112: and NAME = X_NAME
113: and GROUP_TYPE = X_GROUP_TYPE;

Line 117: from ALR_ACTION_GROUPS

113: and GROUP_TYPE = X_GROUP_TYPE;
114:
115: select last_updated_by, last_update_date
116: into db_luby, db_ludate
117: from ALR_ACTION_GROUPS
118: where application_id = l_app_id
119: and action_group_id = l_action_group_id;
120:
121: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,

Line 124: ALR_ACTION_GROUPS_PKG.UPDATE_ROW(

120:
121: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
122: x_custom_mode)) then
123:
124: ALR_ACTION_GROUPS_PKG.UPDATE_ROW(
125: X_APPLICATION_ID => l_app_id,
126: X_ACTION_GROUP_ID => l_action_group_id,
127: X_NAME => X_NAME,
128: X_ALERT_ID => l_alert_id,

Line 145: select ALR_ACTION_GROUPS_S.nextval into l_action_group_id

141: exception
142:
143: when NO_DATA_FOUND then
144:
145: select ALR_ACTION_GROUPS_S.nextval into l_action_group_id
146: from DUAL;
147:
148: ALR_ACTION_GROUPS_PKG.INSERT_ROW(
149: X_ROWID => l_row_id,

Line 148: ALR_ACTION_GROUPS_PKG.INSERT_ROW(

144:
145: select ALR_ACTION_GROUPS_S.nextval into l_action_group_id
146: from DUAL;
147:
148: ALR_ACTION_GROUPS_PKG.INSERT_ROW(
149: X_ROWID => l_row_id,
150: X_APPLICATION_ID => l_app_id,
151: X_ACTION_GROUP_ID => l_action_group_id,
152: X_NAME => X_NAME,

Line 189: from ALR_ACTION_GROUPS

185: DESCRIPTION,
186: GROUP_TYPE,
187: APPLICATION_ID,
188: ACTION_GROUP_ID
189: from ALR_ACTION_GROUPS
190: where APPLICATION_ID = X_APPLICATION_ID
191: and ACTION_GROUP_ID = X_ACTION_GROUP_ID
192: for update of APPLICATION_ID nowait;
193: begin

Line 232: update ALR_ACTION_GROUPS set

228: X_LAST_UPDATED_BY in NUMBER,
229: X_LAST_UPDATE_LOGIN in NUMBER
230: ) is
231: begin
232: update ALR_ACTION_GROUPS set
233: NAME = X_NAME,
234: ALERT_ID = X_ALERT_ID,
235: ACTION_GROUP_TYPE = X_ACTION_GROUP_TYPE,
236: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 258: delete from ALR_ACTION_GROUPS

254: X_APPLICATION_ID in NUMBER,
255: X_ACTION_GROUP_ID in NUMBER
256: ) is
257: begin
258: delete from ALR_ACTION_GROUPS
259: where APPLICATION_ID = X_APPLICATION_ID
260: and ACTION_GROUP_ID = X_ACTION_GROUP_ID;
261:
262: if (sql%notfound) then

Line 268: end ALR_ACTION_GROUPS_PKG;

264: end if;
265:
266: end DELETE_ROW;
267:
268: end ALR_ACTION_GROUPS_PKG;