APPS.EDW_SOURCE_INSTANCES_PKG dependencies on EDW_MISC_UTIL

Line 25: edw_misc_util.globalNamesOff;

21: /* return false if entry exists in remote db
22: return true if entry does not exist */
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);

Line 337: edw_misc_util.globalNamesOff;

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

Line 498: edw_misc_util.globalNamesOff;

494: cid NUMBER;
495: remote_date date;
496:
497: BEGIN
498: edw_misc_util.globalNamesOff;
499:
500: cid := DBMS_SQL.open_cursor;
501: DBMS_SQL.PARSE(cid, 'SELECT sysdate FROM dual@'||X_WAREHOUSE_TO_INSTANCE_LINK, dbms_sql.native);
502: dbms_sql.define_column(cid, 1, remote_date);

Line 581: edw_misc_util.globalNamesOff;

577: v_sql_stmt VARCHAR2(240);
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);