APPS.ALR_ACTION_SET_INPUTS_PKG dependencies on ALR_ACTION_SET_INPUTS

Line 1: package body ALR_ACTION_SET_INPUTS_PKG as

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

Line 16: cursor C is select ROWID from ALR_ACTION_SET_INPUTS

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from ALR_ACTION_SET_INPUTS
17: where APPLICATION_ID = X_APPLICATION_ID
18: and ALERT_ID = X_ALERT_ID
19: and ACTION_SET_ID = X_ACTION_SET_ID
20: and NAME = X_NAME

Line 23: insert into ALR_ACTION_SET_INPUTS (

19: and ACTION_SET_ID = X_ACTION_SET_ID
20: and NAME = X_NAME
21: ;
22: begin
23: insert into ALR_ACTION_SET_INPUTS (
24: LAST_UPDATE_DATE,
25: LAST_UPDATED_BY,
26: CREATION_DATE,
27: CREATED_BY,

Line 103: from ALR_ACTION_SET_INPUTS

99: and name = X_NAME;
100:
101: select last_updated_by, last_update_date
102: into db_luby, db_ludate
103: from ALR_ACTION_SET_INPUTS
104: where application_id = l_app_id
105: and alert_id = l_alert_id
106: and action_set_id = l_action_set_id
107: and name = X_ACTION_SET_INPUT_NAME;

Line 112: ALR_ACTION_SET_INPUTS_PKG.UPDATE_ROW(

108:
109: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
110: x_custom_mode)) then
111:
112: ALR_ACTION_SET_INPUTS_PKG.UPDATE_ROW(
113: X_APPLICATION_ID => l_app_id,
114: X_ALERT_ID => l_alert_id,
115: X_ACTION_SET_ID => l_action_set_id,
116: X_NAME => X_ACTION_SET_INPUT_NAME,

Line 128: ALR_ACTION_SET_INPUTS_PKG.INSERT_ROW(

124: exception
125:
126: when NO_DATA_FOUND then
127:
128: ALR_ACTION_SET_INPUTS_PKG.INSERT_ROW(
129: X_ROWID => l_row_id,
130: X_APPLICATION_ID => l_app_id,
131: X_ALERT_ID => l_alert_id,
132: X_ACTION_SET_ID => l_action_set_id,

Line 156: from ALR_ACTION_SET_INPUTS

152: APPLICATION_ID,
153: ALERT_ID,
154: ACTION_SET_ID,
155: NAME
156: from ALR_ACTION_SET_INPUTS
157: where APPLICATION_ID = X_APPLICATION_ID
158: and ALERT_ID = X_ALERT_ID
159: and ACTION_SET_ID = X_ACTION_SET_ID
160: and NAME = X_NAME

Line 191: update ALR_ACTION_SET_INPUTS set

187: X_LAST_UPDATED_BY in NUMBER,
188: X_LAST_UPDATE_LOGIN in NUMBER
189: ) is
190: begin
191: update ALR_ACTION_SET_INPUTS set
192: VALUE = X_VALUE,
193: APPLICATION_ID = X_APPLICATION_ID,
194: ALERT_ID = X_ALERT_ID,
195: ACTION_SET_ID = X_ACTION_SET_ID,

Line 217: delete from ALR_ACTION_SET_INPUTS

213: X_ACTION_SET_ID in NUMBER,
214: X_NAME in VARCHAR2
215: ) is
216: begin
217: delete from ALR_ACTION_SET_INPUTS
218: where APPLICATION_ID = X_APPLICATION_ID
219: and ALERT_ID = X_ALERT_ID
220: and ACTION_SET_ID = X_ACTION_SET_ID
221: and NAME = X_NAME;

Line 230: end ALR_ACTION_SET_INPUTS_PKG;

226:
227: end DELETE_ROW;
228:
229:
230: end ALR_ACTION_SET_INPUTS_PKG;