eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDW_SOURCE_INSTANCES_PKG dependencies on EDW_LOCAL_INSTANCE

Line 27: DBMS_SQL.PARSE(cid, 'SELECT count(*) FROM edw_local_instance@'||P_DBLINK, dbms_sql.native);

23:
24: begin
25: edw_misc_util.globalNamesOff;
26: cid := DBMS_SQL.open_cursor;
27: DBMS_SQL.PARSE(cid, 'SELECT count(*) FROM edw_local_instance@'||P_DBLINK, dbms_sql.native);
28: dbms_sql.define_column(cid, 1, dummy);
29: l_dummy:=dbms_sql.execute(cid);
30: if dbms_sql.fetch_rows(cid)<>0 then
31: dbms_sql.column_value(cid, 1, dummy);

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 390: (select distinct INSTANCE_CODE from EDW_LOCAL_INSTANCE);

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 */
393: WHEN OTHERS THEN NULL;
394: END;

Line 511: v_sql_stmt := 'INSERT INTO edw_local_instance@' ||

507: DBMS_SQL.close_cursor(cid);
508:
509: delete_row_remote(x_instance_code, X_WAREHOUSE_TO_INSTANCE_LINK);
510:
511: v_sql_stmt := 'INSERT INTO edw_local_instance@' ||
512: x_warehouse_to_instance_link ||
513: '(instance_code, enabled_flag, creation_date, created_by,
514: last_update_date, last_updated_by, last_update_login,
515: warehouse_to_instance_link)

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 582: v_sql_stmt := 'delete from EDW_LOCAL_INSTANCE@' ||

578:
579: BEGIN
580:
581: edw_misc_util.globalNamesOff;
582: v_sql_stmt := 'delete from EDW_LOCAL_INSTANCE@' ||
583: x_warehouse_to_instance_link;
584: v_cursor_id := dbms_sql.open_cursor;
585: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
586: --dbms_sql.bind_variable(v_cursor_id, ':x1', x_instance_code);

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);