APPS.AMW_OPINION_VALUES_PKG dependencies on AMW_OPINION_VALUES_B

Line 22: cursor C is select ROWID from AMW_OPINION_VALUES_B

18: X_LAST_UPDATE_DATE in DATE,
19: X_LAST_UPDATED_BY in NUMBER,
20: X_LAST_UPDATE_LOGIN in NUMBER
21: ) is
22: cursor C is select ROWID from AMW_OPINION_VALUES_B
23: where OPINION_VALUE_ID = X_OPINION_VALUE_ID
24: ;
25: begin
26: insert into AMW_OPINION_VALUES_B (

Line 26: insert into AMW_OPINION_VALUES_B (

22: cursor C is select ROWID from AMW_OPINION_VALUES_B
23: where OPINION_VALUE_ID = X_OPINION_VALUE_ID
24: ;
25: begin
26: insert into AMW_OPINION_VALUES_B (
27: OPINION_VALUE_ID,
28: OPINION_VALUE_CODE,
29: OPINION_COMPONENT_ID,
30: END_DATE,

Line 121: from AMW_OPINION_VALUES_B

117: IMAGE_FILE_NAME,
118: DISPLAY_ORDER,
119: SECURITY_GROUP_ID,
120: OBJECT_VERSION_NUMBER
121: from AMW_OPINION_VALUES_B
122: where OPINION_VALUE_ID = X_OPINION_VALUE_ID
123: for update of OPINION_VALUE_ID nowait;
124: recinfo c%rowtype;
125:

Line 194: update AMW_OPINION_VALUES_B set

190: X_LAST_UPDATED_BY in NUMBER,
191: X_LAST_UPDATE_LOGIN in NUMBER
192: ) is
193: begin
194: update AMW_OPINION_VALUES_B set
195: OPINION_VALUE_CODE = X_OPINION_VALUE_CODE,
196: OPINION_COMPONENT_ID = X_OPINION_COMPONENT_ID,
197: END_DATE = X_END_DATE,
198: ATTACHMENT_ID = X_ATTACHMENT_ID,

Line 237: delete from AMW_OPINION_VALUES_B

233: if (sql%notfound) then
234: raise no_data_found;
235: end if;
236:
237: delete from AMW_OPINION_VALUES_B
238: where OPINION_VALUE_ID = X_OPINION_VALUE_ID;
239:
240: if (sql%notfound) then
241: raise no_data_found;

Line 251: from AMW_OPINION_VALUES_B B

247: begin
248: delete from AMW_OPINION_VALUES_TL T
249: where not exists
250: (select NULL
251: from AMW_OPINION_VALUES_B B
252: where B.OPINION_VALUE_ID = T.OPINION_VALUE_ID
253: );
254:
255: update AMW_OPINION_VALUES_TL T set (

Line 338: from AMW_OPINION_VALUES_B

334: -- Translate char last_update_date to date
335: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
336:
337: select last_updated_by, last_update_date into db_luby, db_ludate
338: from AMW_OPINION_VALUES_B
339: where opinion_value_id = X_OPINION_VALUE_ID;
340:
341: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
342: then AMW_OPINION_VALUES_PKG.UPDATE_ROW(