APPS.ALR_RESPONSE_VARIABLES_PKG dependencies on ALR_RESPONSE_VARIABLES

Line 1: package body ALR_RESPONSE_VARIABLES_PKG as

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

Line 21: cursor C is select ROWID from ALR_RESPONSE_VARIABLES

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from ALR_RESPONSE_VARIABLES
22: where APPLICATION_ID = X_APPLICATION_ID
23: and ALERT_ID = X_ALERT_ID
24: and RESPONSE_SET_ID = X_RESPONSE_SET_ID
25: and VARIABLE_NUMBER = X_VARIABLE_NUMBER

Line 28: insert into ALR_RESPONSE_VARIABLES (

24: and RESPONSE_SET_ID = X_RESPONSE_SET_ID
25: and VARIABLE_NUMBER = X_VARIABLE_NUMBER
26: ;
27: begin
28: insert into ALR_RESPONSE_VARIABLES (
29: LAST_UPDATE_DATE,
30: LAST_UPDATED_BY,
31: CREATION_DATE,
32: CREATED_BY,

Line 122: from alr_response_variables

118: and alert_id = l_alert_id
119: and name = X_RESP_SET_NAME ;
120:
121: select variable_number into l_variable_number
122: from alr_response_variables
123: where application_id = l_app_id
124: and alert_id = l_alert_id
125: and response_set_id = l_response_set_id
126: and name = X_RESP_VAR_NAME ;

Line 130: from ALR_RESPONSE_VARIABLES

126: and name = X_RESP_VAR_NAME ;
127:
128: select last_updated_by, last_update_date
129: into db_luby, db_ludate
130: from ALR_RESPONSE_VARIABLES
131: where application_id = l_app_id
132: and alert_id = l_alert_id
133: and response_set_id = l_response_set_id
134: and variable_number = l_variable_number;

Line 139: ALR_RESPONSE_VARIABLES_PKG.UPDATE_ROW(

135:
136: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
137: x_custom_mode)) then
138:
139: ALR_RESPONSE_VARIABLES_PKG.UPDATE_ROW(
140: X_APPLICATION_ID => l_app_id,
141: X_ALERT_ID => l_alert_id,
142: X_RESPONSE_SET_ID => l_response_set_id,
143: X_VARIABLE_NUMBER => l_variable_number,

Line 160: select ALR_RESPONSE_VARIABLES_S.nextval into l_variable_number from dual;

156: exception
157:
158: when NO_DATA_FOUND then
159:
160: select ALR_RESPONSE_VARIABLES_S.nextval into l_variable_number from dual;
161:
162: ALR_RESPONSE_VARIABLES_PKG.INSERT_ROW(
163: X_ROWID => l_row_id,
164: X_APPLICATION_ID => l_app_id,

Line 162: ALR_RESPONSE_VARIABLES_PKG.INSERT_ROW(

158: when NO_DATA_FOUND then
159:
160: select ALR_RESPONSE_VARIABLES_S.nextval into l_variable_number from dual;
161:
162: ALR_RESPONSE_VARIABLES_PKG.INSERT_ROW(
163: X_ROWID => l_row_id,
164: X_APPLICATION_ID => l_app_id,
165: X_ALERT_ID => l_alert_id,
166: X_RESPONSE_SET_ID => l_response_set_id,

Line 205: from ALR_RESPONSE_VARIABLES

201: APPLICATION_ID,
202: ALERT_ID,
203: RESPONSE_SET_ID,
204: VARIABLE_NUMBER
205: from ALR_RESPONSE_VARIABLES
206: where APPLICATION_ID = X_APPLICATION_ID
207: and ALERT_ID = X_ALERT_ID
208: and RESPONSE_SET_ID = X_RESPONSE_SET_ID
209: and VARIABLE_NUMBER = X_VARIABLE_NUMBER

Line 256: update ALR_RESPONSE_VARIABLES set

252: X_LAST_UPDATED_BY in NUMBER,
253: X_LAST_UPDATE_LOGIN in NUMBER
254: ) is
255: begin
256: update ALR_RESPONSE_VARIABLES set
257: TYPE = X_TYPE,
258: DEFAULT_VALUE = X_DEFAULT_VALUE,
259: DATA_TYPE = X_DATA_TYPE,
260: DETAIL_MAX_LEN = X_DETAIL_MAX_LEN,

Line 287: delete from ALR_RESPONSE_VARIABLES

283: X_RESPONSE_SET_ID in NUMBER,
284: X_VARIABLE_NUMBER in NUMBER
285: ) is
286: begin
287: delete from ALR_RESPONSE_VARIABLES
288: where APPLICATION_ID = X_APPLICATION_ID
289: and ALERT_ID = X_ALERT_ID
290: and RESPONSE_SET_ID = X_RESPONSE_SET_ID
291: and VARIABLE_NUMBER = X_VARIABLE_NUMBER;

Line 300: end ALR_RESPONSE_VARIABLES_PKG;

296:
297: end DELETE_ROW;
298:
299:
300: end ALR_RESPONSE_VARIABLES_PKG;