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.OPI_UOM_WH_PUSH_PKG dependencies on DBMS_SQL

Line 15: cid := DBMS_SQL.open_cursor;

11: cid NUMBER := 0;
12: bRunning BOOLEAN := TRUE;
13: BEGIN
14: edw_misc_util.globalNamesOff;
15: cid := DBMS_SQL.open_cursor;
16: BEGIN
17: dbms_sql.parse(cid, 'SELECT 1 FROM dual@'||p_db_link, dbms_sql.native);
18: Exception
19: WHEN OTHERS THEN

Line 17: dbms_sql.parse(cid, 'SELECT 1 FROM dual@'||p_db_link, dbms_sql.native);

13: BEGIN
14: edw_misc_util.globalNamesOff;
15: cid := DBMS_SQL.open_cursor;
16: BEGIN
17: dbms_sql.parse(cid, 'SELECT 1 FROM dual@'||p_db_link, dbms_sql.native);
18: Exception
19: WHEN OTHERS THEN
20:
21: bRunning := FALSE;

Line 25: dbms_sql.close_cursor(cid);

21: bRunning := FALSE;
22: edw_owb_collection_util.write_to_log_file('Instance not running: '|| p_db_link || ' : '||SQLERRM);
23: END;
24:
25: dbms_sql.close_cursor(cid);
26:
27: IF (p_mode = 1) THEN
28: IF (bRunning = FALSE) THEN
29: fnd_message.set_name('BIS', 'EDW_BAD_DBLINK');

Line 51: cid := DBMS_SQL.open_cursor;

47: edw_misc_util.globalNamesOff;
48: SAVEPOINT start_push_to_source;
49:
50: l_progress := '010';
51: cid := DBMS_SQL.open_cursor;
52: --open instances;
53: open sources;
54: LOOP
55: l_progress := '020';

Line 78: DBMS_SQL.PARSE(cid, 'DELETE EDW_MTL_LOCAL_UOM_M@'||l_db_link, dbms_sql.native);

74:
75: IF p_object_name = 'EDW_MTL_UOM_M' then
76:
77: l_progress := '030';
78: DBMS_SQL.PARSE(cid, 'DELETE EDW_MTL_LOCAL_UOM_M@'||l_db_link, dbms_sql.native);
79: l_dummy := dbms_sql.execute(cid);
80: l_progress := '040';
81: l_stmt := 'INSERT INTO EDW_MTL_LOCAL_UOM_M@'||l_db_link||' (UOM_EDW_UOM_PK, UOM_GLOBAL_FLAG,UOM_EDW_BASE_UOM, UOM_CONVERSION_RATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN)';
82: l_stmt := l_stmt || ' SELECT UOM_EDW_UOM_PK, UOM_GLOBAL_FLAG, UOM_EDW_BASE_UOM, UOM_CONVERSION_RATE, SYSDATE, -1, SYSDATE, -1, -1 FROM EDW_MTL_UOM_M';

Line 79: l_dummy := dbms_sql.execute(cid);

75: IF p_object_name = 'EDW_MTL_UOM_M' then
76:
77: l_progress := '030';
78: DBMS_SQL.PARSE(cid, 'DELETE EDW_MTL_LOCAL_UOM_M@'||l_db_link, dbms_sql.native);
79: l_dummy := dbms_sql.execute(cid);
80: l_progress := '040';
81: l_stmt := 'INSERT INTO EDW_MTL_LOCAL_UOM_M@'||l_db_link||' (UOM_EDW_UOM_PK, UOM_GLOBAL_FLAG,UOM_EDW_BASE_UOM, UOM_CONVERSION_RATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN)';
82: l_stmt := l_stmt || ' SELECT UOM_EDW_UOM_PK, UOM_GLOBAL_FLAG, UOM_EDW_BASE_UOM, UOM_CONVERSION_RATE, SYSDATE, -1, SYSDATE, -1, -1 FROM EDW_MTL_UOM_M';
83: l_progress := '050';

Line 84: DBMS_SQL.PARSE(cid, l_stmt, dbms_sql.native);

80: l_progress := '040';
81: l_stmt := 'INSERT INTO EDW_MTL_LOCAL_UOM_M@'||l_db_link||' (UOM_EDW_UOM_PK, UOM_GLOBAL_FLAG,UOM_EDW_BASE_UOM, UOM_CONVERSION_RATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN)';
82: l_stmt := l_stmt || ' SELECT UOM_EDW_UOM_PK, UOM_GLOBAL_FLAG, UOM_EDW_BASE_UOM, UOM_CONVERSION_RATE, SYSDATE, -1, SYSDATE, -1, -1 FROM EDW_MTL_UOM_M';
83: l_progress := '050';
84: DBMS_SQL.PARSE(cid, l_stmt, dbms_sql.native);
85: l_dummy := dbms_sql.execute(cid);
86: l_progress := '060';
87:
88: ELSIF p_object_name = 'OPI_EDW_UOM_CONV_F' then

Line 85: l_dummy := dbms_sql.execute(cid);

81: l_stmt := 'INSERT INTO EDW_MTL_LOCAL_UOM_M@'||l_db_link||' (UOM_EDW_UOM_PK, UOM_GLOBAL_FLAG,UOM_EDW_BASE_UOM, UOM_CONVERSION_RATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN)';
82: l_stmt := l_stmt || ' SELECT UOM_EDW_UOM_PK, UOM_GLOBAL_FLAG, UOM_EDW_BASE_UOM, UOM_CONVERSION_RATE, SYSDATE, -1, SYSDATE, -1, -1 FROM EDW_MTL_UOM_M';
83: l_progress := '050';
84: DBMS_SQL.PARSE(cid, l_stmt, dbms_sql.native);
85: l_dummy := dbms_sql.execute(cid);
86: l_progress := '060';
87:
88: ELSIF p_object_name = 'OPI_EDW_UOM_CONV_F' then
89:

Line 91: DBMS_SQL.PARSE(cid, 'DELETE OPI_EDW_LOCAL_UOM_CONV_F@'||l_db_link, dbms_sql.native);

87:
88: ELSIF p_object_name = 'OPI_EDW_UOM_CONV_F' then
89:
90: l_progress := '070';
91: DBMS_SQL.PARSE(cid, 'DELETE OPI_EDW_LOCAL_UOM_CONV_F@'||l_db_link, dbms_sql.native);
92: l_dummy := dbms_sql.execute(cid);
93:
94: l_progress := '080';
95:

Line 92: l_dummy := dbms_sql.execute(cid);

88: ELSIF p_object_name = 'OPI_EDW_UOM_CONV_F' then
89:
90: l_progress := '070';
91: DBMS_SQL.PARSE(cid, 'DELETE OPI_EDW_LOCAL_UOM_CONV_F@'||l_db_link, dbms_sql.native);
92: l_dummy := dbms_sql.execute(cid);
93:
94: l_progress := '080';
95:
96: l_stmt := 'INSERT INTO OPI_EDW_LOCAL_UOM_CONV_F@'||l_db_link||' (UOM_CONV_PK, EDW_BASE_UOM_FK, EDW_UOM_FK, EDW_CONVERSION_RATE,CLASS_CONVERSION_FLAG, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN)';

Line 100: DBMS_SQL.PARSE(cid, l_stmt, dbms_sql.native);

96: l_stmt := 'INSERT INTO OPI_EDW_LOCAL_UOM_CONV_F@'||l_db_link||' (UOM_CONV_PK, EDW_BASE_UOM_FK, EDW_UOM_FK, EDW_CONVERSION_RATE,CLASS_CONVERSION_FLAG, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN)';
97: l_stmt := l_stmt || ' SELECT UOM_CONV_PK, EDW_BASE_UOM_FK, EDW_UOM_FK, EDW_CONVERSION_RATE, CLASS_CONVERSION_FLAG, SYSDATE, -1, SYSDATE, -1, -1 FROM OPI_EDW_UOM_CONV_F';
98: l_progress := '090';
99:
100: DBMS_SQL.PARSE(cid, l_stmt, dbms_sql.native);
101: l_dummy := dbms_sql.execute(cid);
102: l_progress := '100';
103: END IF;
104: END IF;

Line 101: l_dummy := dbms_sql.execute(cid);

97: l_stmt := l_stmt || ' SELECT UOM_CONV_PK, EDW_BASE_UOM_FK, EDW_UOM_FK, EDW_CONVERSION_RATE, CLASS_CONVERSION_FLAG, SYSDATE, -1, SYSDATE, -1, -1 FROM OPI_EDW_UOM_CONV_F';
98: l_progress := '090';
99:
100: DBMS_SQL.PARSE(cid, l_stmt, dbms_sql.native);
101: l_dummy := dbms_sql.execute(cid);
102: l_progress := '100';
103: END IF;
104: END IF;
105:

Line 108: DBMS_SQL.close_cursor(cid);

104: END IF;
105:
106: END LOOP;
107:
108: DBMS_SQL.close_cursor(cid);
109:
110: close sources;
111: COMMIT;
112:

Line 118: DBMS_SQL.close_cursor(cid);

114: when others then
115:
116: ROLLBACK TO start_push_to_source;
117: close sources;
118: DBMS_SQL.close_cursor(cid);
119: edw_owb_collection_util.write_to_log_file('push_to_source: '||l_progress|| ' : '||SQLERRM);
120: raise;
121:
122: END pushToSource;