APPS.ALR_VALID_RESPONSES_PKG dependencies on ALR_VALID_RESPONSES

Line 1: package body ALR_VALID_RESPONSES_PKG as

1: package body ALR_VALID_RESPONSES_PKG as
2: /* $Header: ALRVRSPB.pls 120.3.12010000.1 2008/07/27 06:59:05 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_VALID_RESPONSES

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from ALR_VALID_RESPONSES
19: where APPLICATION_ID = X_APPLICATION_ID
20: and ALERT_ID = X_ALERT_ID
21: and RESPONSE_SET_ID = X_RESPONSE_SET_ID
22: and RESPONSE_ID = X_RESPONSE_ID

Line 25: insert into ALR_VALID_RESPONSES (

21: and RESPONSE_SET_ID = X_RESPONSE_SET_ID
22: and RESPONSE_ID = X_RESPONSE_ID
23: ;
24: begin
25: insert into ALR_VALID_RESPONSES (
26: APPLICATION_ID,
27: RESPONSE_ID,
28: LAST_UPDATE_DATE,
29: LAST_UPDATED_BY,

Line 110: select response_id into l_response_id from alr_valid_responses

106: and name = X_RESP_SET_NAME ;
107:
108: /* longs like response_text cannot be used in the where clause */
109: /* response_name can be a null column */
110: select response_id into l_response_id from alr_valid_responses
111: where application_id = l_app_id
112: and alert_id = l_alert_id
113: and response_set_id = l_response_set_id
114: and type = X_TYPE

Line 121: from ALR_VALID_RESPONSES

117: and (response_name = X_RESPONSE_NAME)));
118:
119: select last_updated_by, last_update_date
120: into db_luby, db_ludate
121: from ALR_VALID_RESPONSES
122: where application_id = l_app_id
123: and alert_id = l_alert_id
124: and response_set_id = l_response_set_id
125: and response_id = l_response_id;

Line 130: ALR_VALID_RESPONSES_PKG.UPDATE_ROW(

126:
127: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
128: x_custom_mode)) then
129:
130: ALR_VALID_RESPONSES_PKG.UPDATE_ROW(
131: X_APPLICATION_ID => l_app_id,
132: X_ALERT_ID => l_alert_id,
133: X_RESPONSE_SET_ID => l_response_set_id,
134: X_RESPONSE_ID => l_response_id,

Line 148: select ALR_VALID_RESPONSES_S.nextval into l_response_id from DUAL;

144: exception
145:
146: when NO_DATA_FOUND then
147:
148: select ALR_VALID_RESPONSES_S.nextval into l_response_id from DUAL;
149:
150: ALR_VALID_RESPONSES_PKG.INSERT_ROW(
151: X_ROWID => l_row_id,
152: X_APPLICATION_ID => l_app_id,

Line 150: ALR_VALID_RESPONSES_PKG.INSERT_ROW(

146: when NO_DATA_FOUND then
147:
148: select ALR_VALID_RESPONSES_S.nextval into l_response_id from DUAL;
149:
150: ALR_VALID_RESPONSES_PKG.INSERT_ROW(
151: X_ROWID => l_row_id,
152: X_APPLICATION_ID => l_app_id,
153: X_ALERT_ID => l_alert_id,
154: X_RESPONSE_SET_ID => l_response_set_id,

Line 184: from ALR_VALID_RESPONSES

180: APPLICATION_ID,
181: ALERT_ID,
182: RESPONSE_SET_ID,
183: RESPONSE_ID
184: from ALR_VALID_RESPONSES
185: where APPLICATION_ID = X_APPLICATION_ID
186: and ALERT_ID = X_ALERT_ID
187: and RESPONSE_SET_ID = X_RESPONSE_SET_ID
188: and RESPONSE_ID = X_RESPONSE_ID

Line 224: update ALR_VALID_RESPONSES set

220: X_LAST_UPDATED_BY in NUMBER,
221: X_LAST_UPDATE_LOGIN in NUMBER
222: ) is
223: begin
224: update ALR_VALID_RESPONSES set
225: TYPE = X_TYPE,
226: RESPONSE_TEXT = X_RESPONSE_TEXT,
227: RESPONSE_NAME = X_RESPONSE_NAME,
228: APPLICATION_ID = X_APPLICATION_ID,

Line 252: delete from ALR_VALID_RESPONSES

248: X_RESPONSE_SET_ID in NUMBER,
249: X_RESPONSE_ID in NUMBER
250: ) is
251: begin
252: delete from ALR_VALID_RESPONSES
253: where APPLICATION_ID = X_APPLICATION_ID
254: and ALERT_ID = X_ALERT_ID
255: and RESPONSE_SET_ID = X_RESPONSE_SET_ID
256: and RESPONSE_ID = X_RESPONSE_ID;

Line 264: end ALR_VALID_RESPONSES_PKG;

260: end if;
261:
262: end DELETE_ROW;
263:
264: end ALR_VALID_RESPONSES_PKG;