APPS.ALR_ACTION_GROUP_MEMBERS_PKG dependencies on ALR_ACTION_GROUP_MEMBERS

Line 1: package body ALR_ACTION_GROUP_MEMBERS_PKG as

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

Line 19: cursor C is select ROWID from ALR_ACTION_GROUP_MEMBERS

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from ALR_ACTION_GROUP_MEMBERS
20: where APPLICATION_ID = X_APPLICATION_ID
21: and ACTION_GROUP_MEMBER_ID = X_ACTION_GROUP_MEMBER_ID
22: ;
23: begin

Line 24: insert into ALR_ACTION_GROUP_MEMBERS (

20: where APPLICATION_ID = X_APPLICATION_ID
21: and ACTION_GROUP_MEMBER_ID = X_ACTION_GROUP_MEMBER_ID
22: ;
23: begin
24: insert into ALR_ACTION_GROUP_MEMBERS (
25: APPLICATION_ID,
26: ACTION_GROUP_MEMBER_ID,
27: ACTION_GROUP_ID,
28: ACTION_ID,

Line 126: from ALR_ACTION_GROUP_MEMBERS

122: and NAME = X_NAME
123: and GROUP_TYPE = X_GROUP_TYPE;
124:
125: select ACTION_GROUP_MEMBER_ID into l_action_group_member_id
126: from ALR_ACTION_GROUP_MEMBERS
127: where APPLICATION_ID = l_app_id
128: and ACTION_GROUP_ID = l_action_group_id
129: and ACTION_ID = l_action_id
130: and ALERT_ID = l_alert_id

Line 145: from ALR_ACTION_GROUP_MEMBERS

141: to_date(X_END_DATE_ACTIVE,'YYYY/MM/DD HH24:MI:SS'))));
142:
143: select last_updated_by, last_update_date
144: into db_luby, db_ludate
145: from ALR_ACTION_GROUP_MEMBERS
146: where application_id = l_app_id
147: and action_group_member_id = l_action_group_member_id;
148:
149: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,

Line 152: ALR_ACTION_GROUP_MEMBERS_PKG.UPDATE_ROW(

148:
149: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
150: x_custom_mode)) then
151:
152: ALR_ACTION_GROUP_MEMBERS_PKG.UPDATE_ROW(
153: X_APPLICATION_ID => l_app_id,
154: X_ACTION_GROUP_MEMBER_ID => l_action_group_member_id,
155: X_ACTION_GROUP_ID => l_action_group_id,
156: X_ACTION_ID => l_action_id,

Line 171: select ALR_ACTION_GROUP_MEMBERS_S.nextval into l_action_group_member_id

167:
168: when NO_DATA_FOUND then
169:
170:
171: select ALR_ACTION_GROUP_MEMBERS_S.nextval into l_action_group_member_id
172: from dual;
173:
174: ALR_ACTION_GROUP_MEMBERS_PKG.INSERT_ROW(
175: X_ROWID => l_row_id,

Line 174: ALR_ACTION_GROUP_MEMBERS_PKG.INSERT_ROW(

170:
171: select ALR_ACTION_GROUP_MEMBERS_S.nextval into l_action_group_member_id
172: from dual;
173:
174: ALR_ACTION_GROUP_MEMBERS_PKG.INSERT_ROW(
175: X_ROWID => l_row_id,
176: X_APPLICATION_ID => l_app_id,
177: X_ACTION_GROUP_MEMBER_ID => l_action_group_member_id,
178: X_ACTION_GROUP_ID => l_action_group_id,

Line 211: from ALR_ACTION_GROUP_MEMBERS

207: ENABLED_FLAG,
208: ACTION_LEVEL,
209: APPLICATION_ID,
210: ACTION_GROUP_MEMBER_ID
211: from ALR_ACTION_GROUP_MEMBERS
212: where APPLICATION_ID = X_APPLICATION_ID
213: and ACTION_GROUP_MEMBER_ID = X_ACTION_GROUP_MEMBER_ID
214: for update of APPLICATION_ID nowait;
215: begin

Line 252: update ALR_ACTION_GROUP_MEMBERS set

248: X_LAST_UPDATED_BY in NUMBER,
249: X_LAST_UPDATE_LOGIN in NUMBER
250: ) is
251: begin
252: update ALR_ACTION_GROUP_MEMBERS set
253: ACTION_GROUP_ID = X_ACTION_GROUP_ID,
254: ACTION_ID = X_ACTION_ID,
255: ALERT_ID = X_ALERT_ID,
256: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 277: delete from ALR_ACTION_GROUP_MEMBERS

273: X_APPLICATION_ID in NUMBER,
274: X_ACTION_GROUP_MEMBER_ID in NUMBER
275: ) is
276: begin
277: delete from ALR_ACTION_GROUP_MEMBERS
278: where APPLICATION_ID = X_APPLICATION_ID
279: and ACTION_GROUP_MEMBER_ID = X_ACTION_GROUP_MEMBER_ID;
280:
281: if (sql%notfound) then

Line 288: end ALR_ACTION_GROUP_MEMBERS_PKG;

284:
285: end DELETE_ROW;
286:
287:
288: end ALR_ACTION_GROUP_MEMBERS_PKG;