APPS.EDW_SOURCE_INSTANCES_PKG dependencies on EDW_LOCAL_INSTANCE_TL

Line 333: -- After this, copy records to EDW_LOCAL_INSTANCE_TL at each instance.

329: where T.INSTANCE_CODE = B.INSTANCE_CODE
330: and T.LANGUAGE = L.LANGUAGE_CODE);
331:
332: ---------------------------------------------------------------------
333: -- After this, copy records to EDW_LOCAL_INSTANCE_TL at each instance.
334: -- This is for the fix of bug 2125924
335: ---------------------------------------------------------------------
336:
337: edw_misc_util.globalNamesOff;

Line 341: v_sql_stmt := 'delete from EDW_LOCAL_INSTANCE_TL@' || v_db_link;

337: edw_misc_util.globalNamesOff;
338:
339: FOR db_link_to_local IN db_links LOOP
340: v_db_link := db_link_to_local.WAREHOUSE_TO_INSTANCE_LINK;
341: v_sql_stmt := 'delete from EDW_LOCAL_INSTANCE_TL@' || v_db_link;
342:
343: BEGIN
344: EXECUTE IMMEDIATE v_sql_stmt;
345:

Line 346: v_sql_stmt := 'insert into EDW_LOCAL_INSTANCE_TL@' || v_db_link ||

342:
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 ' ||

Line 361: -- so we repeat the above for EDW_LOCAL_INSTANCE_TL in the warehouse.

357: END LOOP;
358:
359:
360: -- we also need to consider the case that no db_link pointing to warehouse itself,
361: -- so we repeat the above for EDW_LOCAL_INSTANCE_TL in the warehouse.
362:
363: BEGIN
364: delete from EDW_LOCAL_INSTANCE_TL;
365:

Line 364: delete from EDW_LOCAL_INSTANCE_TL;

360: -- we also need to consider the case that no db_link pointing to warehouse itself,
361: -- so we repeat the above for EDW_LOCAL_INSTANCE_TL in the warehouse.
362:
363: BEGIN
364: delete from EDW_LOCAL_INSTANCE_TL;
365:
366: insert into EDW_LOCAL_INSTANCE_TL(
367: INSTANCE_CODE,
368: NAME,

Line 366: insert into EDW_LOCAL_INSTANCE_TL(

362:
363: BEGIN
364: delete from EDW_LOCAL_INSTANCE_TL;
365:
366: insert into EDW_LOCAL_INSTANCE_TL(
367: INSTANCE_CODE,
368: NAME,
369: DESCRIPTION,
370: CREATION_DATE,

Line 533: v_sql_stmt := 'insert into EDW_LOCAL_INSTANCE_TL@' ||

529:
530: SELECT userenv('LANG') INTO v_source_lang
531: FROM dual;
532:
533: v_sql_stmt := 'insert into EDW_LOCAL_INSTANCE_TL@' ||
534: x_warehouse_to_instance_link ||
535: '(INSTANCE_CODE, NAME, DESCRIPTION, CREATION_DATE, CREATED_BY,
536: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, LAST_UPDATED_BY, LANGUAGE,
537: SOURCE_LANG) select :x1, :x2, :x3, :x4, :x5, :x6, :x7, :x8,

Line 541: and not exists (select NULL from EDW_LOCAL_INSTANCE_TL@' ||

537: SOURCE_LANG) select :x1, :x2, :x3, :x4, :x5, :x6, :x7, :x8,
538: L.LANGUAGE_CODE, :x9 from FND_LANGUAGES@' ||
539: x_warehouse_to_instance_link ||
540: ' L where L.INSTALLED_FLAG in (''I'', ''B'')
541: and not exists (select NULL from EDW_LOCAL_INSTANCE_TL@' ||
542: x_warehouse_to_instance_link ||
543: ' T where T.INSTANCE_CODE = :x1 and T.LANGUAGE = L.LANGUAGE_CODE)';
544:
545: v_cursor_id := dbms_sql.open_cursor;

Line 590: v_sql_stmt := 'delete from EDW_LOCAL_INSTANCE_TL@' ||

586: --dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);
587: v_ret_code := dbms_sql.execute(v_cursor_id);
588: dbms_sql.close_cursor(v_cursor_id);
589:
590: v_sql_stmt := 'delete from EDW_LOCAL_INSTANCE_TL@' ||
591: x_warehouse_to_instance_link ;
592: v_cursor_id := dbms_sql.open_cursor;
593: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
594: --dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);