APPS.AMW_OPINION_COMPONTS_PKG dependencies on AMW_OPINION_COMPONTS_B

Line 19: insert into AMW_OPINION_COMPONTS_B (

15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: begin
19: insert into AMW_OPINION_COMPONTS_B (
20: OPINION_COMPONENT_ID,
21: OPINION_COMPONENT_CODE,
22: OBJECT_OPINION_TYPE_ID,
23: PAGE_ORDER,

Line 93: from AMW_OPINION_COMPONTS_B

89: OBJECT_OPINION_TYPE_ID,
90: PAGE_ORDER,
91: SECURITY_GROUP_ID,
92: OBJECT_VERSION_NUMBER
93: from AMW_OPINION_COMPONTS_B
94: where OPINION_COMPONENT_ID = X_OPINION_COMPONENT_ID
95: for update of OPINION_COMPONENT_ID nowait;
96: recinfo c%rowtype;
97:

Line 156: update AMW_OPINION_COMPONTS_B set

152: X_LAST_UPDATED_BY in NUMBER,
153: X_LAST_UPDATE_LOGIN in NUMBER
154: ) is
155: begin
156: update AMW_OPINION_COMPONTS_B set
157: OPINION_COMPONENT_CODE = X_OPINION_COMPONENT_CODE,
158: OBJECT_OPINION_TYPE_ID = X_OBJECT_OPINION_TYPE_ID,
159: PAGE_ORDER = X_PAGE_ORDER,
160: SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,

Line 196: delete from AMW_OPINION_COMPONTS_B

192: if (sql%notfound) then
193: raise no_data_found;
194: end if;
195:
196: delete from AMW_OPINION_COMPONTS_B
197: where OPINION_COMPONENT_ID = X_OPINION_COMPONENT_ID;
198:
199: if (sql%notfound) then
200: raise no_data_found;

Line 210: from AMW_OPINION_COMPONTS_B B

206: begin
207: delete from AMW_OPINION_COMPONTS_TL T
208: where not exists
209: (select NULL
210: from AMW_OPINION_COMPONTS_B B
211: where B.OPINION_COMPONENT_ID = T.OPINION_COMPONENT_ID
212: );
213:
214: update AMW_OPINION_COMPONTS_TL T set (

Line 292: from AMW_OPINION_COMPONTS_B

288: -- Translate char last_update_date to date
289: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
290:
291: select last_updated_by, last_update_date into db_luby, db_ludate
292: from AMW_OPINION_COMPONTS_B
293: where opinion_component_id = X_OPINION_COMPONENT_ID;
294:
295: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
296: then AMW_OPINION_COMPONTS_PKG.UPDATE_ROW(