APPS.AMW_OPINION_TYPES_PKG dependencies on AMW_OPINION_TYPES_B

Line 17: insert into AMW_OPINION_TYPES_B (

13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: begin
17: insert into AMW_OPINION_TYPES_B (
18: OPINION_TYPE_ID,
19: OPINION_TYPE_CODE,
20: SECURITY_GROUP_ID,
21: OBJECT_VERSION_NUMBER,

Line 83: from AMW_OPINION_TYPES_B

79: cursor c is select
80: OPINION_TYPE_CODE,
81: SECURITY_GROUP_ID,
82: OBJECT_VERSION_NUMBER
83: from AMW_OPINION_TYPES_B
84: where OPINION_TYPE_ID = X_OPINION_TYPE_ID
85: for update of OPINION_TYPE_ID nowait;
86: recinfo c%rowtype;
87:

Line 142: update AMW_OPINION_TYPES_B set

138: X_LAST_UPDATED_BY in NUMBER,
139: X_LAST_UPDATE_LOGIN in NUMBER
140: ) is
141: begin
142: update AMW_OPINION_TYPES_B set
143: OPINION_TYPE_CODE = X_OPINION_TYPE_CODE,
144: SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
145: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
146: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 180: delete from AMW_OPINION_TYPES_B

176: if (sql%notfound) then
177: raise no_data_found;
178: end if;
179:
180: delete from AMW_OPINION_TYPES_B
181: where OPINION_TYPE_ID = X_OPINION_TYPE_ID;
182:
183: if (sql%notfound) then
184: raise no_data_found;

Line 194: from AMW_OPINION_TYPES_B B

190: begin
191: delete from AMW_OPINION_TYPES_TL T
192: where not exists
193: (select NULL
194: from AMW_OPINION_TYPES_B B
195: where B.OPINION_TYPE_ID = T.OPINION_TYPE_ID
196: );
197:
198: update AMW_OPINION_TYPES_TL T set (

Line 274: from AMW_OPINION_TYPES_B

270: -- Translate char last_update_date to date
271: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
272:
273: select last_updated_by, last_update_date into db_luby, db_ludate
274: from AMW_OPINION_TYPES_B
275: where opinion_type_id = X_OPINION_TYPE_ID;
276:
277: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
278: then AMW_OPINION_TYPES_PKG.UPDATE_ROW(