APPS.EDW_SOURCE_INSTANCES_PKG dependencies on EDW_SOURCE_INSTANCES_TL

Line 92: insert into EDW_SOURCE_INSTANCES_TL (

88: X_LAST_UPDATED_BY,
89: X_LAST_UPDATE_LOGIN
90: );
91:
92: insert into EDW_SOURCE_INSTANCES_TL (
93: INSTANCE_CODE,
94: NAME,
95: DESCRIPTION,
96: CREATION_DATE,

Line 118: from EDW_SOURCE_INSTANCES_TL T

114: from FND_LANGUAGES L
115: where L.INSTALLED_FLAG in ('I', 'B')
116: and not exists
117: (select NULL
118: from EDW_SOURCE_INSTANCES_TL T
119: where T.INSTANCE_CODE = X_INSTANCE_CODE
120: and T.LANGUAGE = L.LANGUAGE_CODE);
121:
122: open c;

Line 155: from EDW_SOURCE_INSTANCES_TL

151: cursor c1 is select
152: NAME,
153: DESCRIPTION,
154: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
155: from EDW_SOURCE_INSTANCES_TL
156: where INSTANCE_CODE = X_INSTANCE_CODE
157: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
158: for update of INSTANCE_CODE nowait;
159: begin

Line 225: update EDW_SOURCE_INSTANCES_TL set

221: if (sql%notfound) then
222: raise no_data_found;
223: end if;
224:
225: update EDW_SOURCE_INSTANCES_TL set
226: NAME = X_NAME,
227: DESCRIPTION = X_DESCRIPTION,
228: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
229: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 244: delete from EDW_SOURCE_INSTANCES_TL

240: procedure DELETE_ROW (
241: X_INSTANCE_CODE in VARCHAR2
242: ) is
243: begin
244: delete from EDW_SOURCE_INSTANCES_TL
245: where INSTANCE_CODE = X_INSTANCE_CODE;
246:
247: if (sql%notfound) then
248: raise no_data_found;

Line 268: delete from EDW_SOURCE_INSTANCES_TL T

264: select WAREHOUSE_TO_INSTANCE_LINK
265: from EDW_SOURCE_INSTANCES;
266:
267: begin
268: delete from EDW_SOURCE_INSTANCES_TL T
269: where not exists
270: (select NULL
271: from EDW_SOURCE_INSTANCES B
272: where B.INSTANCE_CODE = T.INSTANCE_CODE

Line 275: update EDW_SOURCE_INSTANCES_TL T set (

271: from EDW_SOURCE_INSTANCES B
272: where B.INSTANCE_CODE = T.INSTANCE_CODE
273: );
274:
275: update EDW_SOURCE_INSTANCES_TL T set (
276: NAME,
277: DESCRIPTION
278: ) = (select
279: B.NAME,

Line 281: from EDW_SOURCE_INSTANCES_TL B

277: DESCRIPTION
278: ) = (select
279: B.NAME,
280: B.DESCRIPTION
281: from EDW_SOURCE_INSTANCES_TL B
282: where B.INSTANCE_CODE = T.INSTANCE_CODE
283: and B.LANGUAGE = T.SOURCE_LANG)
284: where (
285: T.INSTANCE_CODE,

Line 290: from EDW_SOURCE_INSTANCES_TL SUBB, EDW_SOURCE_INSTANCES_TL SUBT

286: T.LANGUAGE
287: ) in (select
288: SUBT.INSTANCE_CODE,
289: SUBT.LANGUAGE
290: from EDW_SOURCE_INSTANCES_TL SUBB, EDW_SOURCE_INSTANCES_TL SUBT
291: where SUBB.INSTANCE_CODE = SUBT.INSTANCE_CODE
292: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
293: and (SUBB.NAME <> SUBT.NAME
294: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 301: insert into EDW_SOURCE_INSTANCES_TL (

297: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
298: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
299: ));
300:
301: insert into EDW_SOURCE_INSTANCES_TL (
302: INSTANCE_CODE,
303: NAME,
304: DESCRIPTION,
305: CREATION_DATE,

Line 323: from EDW_SOURCE_INSTANCES_TL B, FND_LANGUAGES L

319: B.LAST_UPDATE_LOGIN,
320: B.LAST_UPDATED_BY,
321: L.LANGUAGE_CODE,
322: B.SOURCE_LANG
323: from EDW_SOURCE_INSTANCES_TL B, FND_LANGUAGES L
324: where L.INSTALLED_FLAG in ('I', 'B')
325: and B.LANGUAGE = userenv('LANG')
326: and not exists
327: (select NULL

Line 328: from EDW_SOURCE_INSTANCES_TL T

324: where L.INSTALLED_FLAG in ('I', 'B')
325: and B.LANGUAGE = userenv('LANG')
326: and not exists
327: (select NULL
328: from EDW_SOURCE_INSTANCES_TL T
329: where T.INSTANCE_CODE = B.INSTANCE_CODE
330: and T.LANGUAGE = L.LANGUAGE_CODE);
331:
332: ---------------------------------------------------------------------

Line 347: ' select * from EDW_SOURCE_INSTANCES_TL ' ||

343: BEGIN
344: EXECUTE IMMEDIATE v_sql_stmt;
345:
346: v_sql_stmt := 'insert into EDW_LOCAL_INSTANCE_TL@' || v_db_link ||
347: ' select * from EDW_SOURCE_INSTANCES_TL ' ||
348: ' where INSTANCE_CODE = ' ||
349: '(select distinct INSTANCE_CODE ' ||
350: ' from EDW_SOURCE_INSTANCES ' ||
351: ' where WAREHOUSE_TO_INSTANCE_LINK = '''||v_db_link||''')';

Line 388: from EDW_SOURCE_INSTANCES_TL

384: LAST_UPDATE_LOGIN,
385: LAST_UPDATED_BY,
386: LANGUAGE,
387: SOURCE_LANG
388: from EDW_SOURCE_INSTANCES_TL
389: where INSTANCE_CODE =
390: (select distinct INSTANCE_CODE from EDW_LOCAL_INSTANCE);
391:
392: EXCEPTION /* this should not happen */