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_BIS_VIEW_GEN dependencies on DBMS_SQL

Line 58: v_col DBMS_SQL.VARCHAR2_TABLE;

54: Retcode in out NOCOPY Varchar2,
55: p_object_long_name in varchar2 )
56: IS
57: stmt varchar2(300);
58: v_col DBMS_SQL.VARCHAR2_TABLE;
59: l_viewname VARCHAR2(100);
60: cid NUMBER;
61: l_dummy NUMBER;
62: nViewCount NUMBER := 0;

Line 85: cid := DBMS_SQL.OPEN_CURSOR;

81:
82: IF (p_object_long_name is not null) THEN
83: stmt:= 'SELECT relation_name from EDW_RELATIONS_MD_V@' || l_target_link ||
84: ' where relation_long_name = :longname and relation_type in (:fact, :dimension)';
85: cid := DBMS_SQL.OPEN_CURSOR;
86: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
87: DBMS_SQL.BIND_VARIABLE(cid, ':longname', p_object_long_name);
88: DBMS_SQL.BIND_VARIABLE(cid, ':fact', 'CMPWBCube');
89: DBMS_SQL.BIND_VARIABLE(cid, ':dimension', 'CMPWBDimension');

Line 86: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);

82: IF (p_object_long_name is not null) THEN
83: stmt:= 'SELECT relation_name from EDW_RELATIONS_MD_V@' || l_target_link ||
84: ' where relation_long_name = :longname and relation_type in (:fact, :dimension)';
85: cid := DBMS_SQL.OPEN_CURSOR;
86: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
87: DBMS_SQL.BIND_VARIABLE(cid, ':longname', p_object_long_name);
88: DBMS_SQL.BIND_VARIABLE(cid, ':fact', 'CMPWBCube');
89: DBMS_SQL.BIND_VARIABLE(cid, ':dimension', 'CMPWBDimension');
90: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_obj_short_name, 100);

Line 87: DBMS_SQL.BIND_VARIABLE(cid, ':longname', p_object_long_name);

83: stmt:= 'SELECT relation_name from EDW_RELATIONS_MD_V@' || l_target_link ||
84: ' where relation_long_name = :longname and relation_type in (:fact, :dimension)';
85: cid := DBMS_SQL.OPEN_CURSOR;
86: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
87: DBMS_SQL.BIND_VARIABLE(cid, ':longname', p_object_long_name);
88: DBMS_SQL.BIND_VARIABLE(cid, ':fact', 'CMPWBCube');
89: DBMS_SQL.BIND_VARIABLE(cid, ':dimension', 'CMPWBDimension');
90: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_obj_short_name, 100);
91: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);

Line 88: DBMS_SQL.BIND_VARIABLE(cid, ':fact', 'CMPWBCube');

84: ' where relation_long_name = :longname and relation_type in (:fact, :dimension)';
85: cid := DBMS_SQL.OPEN_CURSOR;
86: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
87: DBMS_SQL.BIND_VARIABLE(cid, ':longname', p_object_long_name);
88: DBMS_SQL.BIND_VARIABLE(cid, ':fact', 'CMPWBCube');
89: DBMS_SQL.BIND_VARIABLE(cid, ':dimension', 'CMPWBDimension');
90: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_obj_short_name, 100);
91: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
92: DBMS_SQL.COLUMN_VALUE(cid, 1, l_obj_short_name);

Line 89: DBMS_SQL.BIND_VARIABLE(cid, ':dimension', 'CMPWBDimension');

85: cid := DBMS_SQL.OPEN_CURSOR;
86: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
87: DBMS_SQL.BIND_VARIABLE(cid, ':longname', p_object_long_name);
88: DBMS_SQL.BIND_VARIABLE(cid, ':fact', 'CMPWBCube');
89: DBMS_SQL.BIND_VARIABLE(cid, ':dimension', 'CMPWBDimension');
90: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_obj_short_name, 100);
91: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
92: DBMS_SQL.COLUMN_VALUE(cid, 1, l_obj_short_name);
93: DBMS_SQL.close_cursor(cid);

Line 90: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_obj_short_name, 100);

86: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
87: DBMS_SQL.BIND_VARIABLE(cid, ':longname', p_object_long_name);
88: DBMS_SQL.BIND_VARIABLE(cid, ':fact', 'CMPWBCube');
89: DBMS_SQL.BIND_VARIABLE(cid, ':dimension', 'CMPWBDimension');
90: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_obj_short_name, 100);
91: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
92: DBMS_SQL.COLUMN_VALUE(cid, 1, l_obj_short_name);
93: DBMS_SQL.close_cursor(cid);
94: END IF;

Line 91: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);

87: DBMS_SQL.BIND_VARIABLE(cid, ':longname', p_object_long_name);
88: DBMS_SQL.BIND_VARIABLE(cid, ':fact', 'CMPWBCube');
89: DBMS_SQL.BIND_VARIABLE(cid, ':dimension', 'CMPWBDimension');
90: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_obj_short_name, 100);
91: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
92: DBMS_SQL.COLUMN_VALUE(cid, 1, l_obj_short_name);
93: DBMS_SQL.close_cursor(cid);
94: END IF;
95:

Line 92: DBMS_SQL.COLUMN_VALUE(cid, 1, l_obj_short_name);

88: DBMS_SQL.BIND_VARIABLE(cid, ':fact', 'CMPWBCube');
89: DBMS_SQL.BIND_VARIABLE(cid, ':dimension', 'CMPWBDimension');
90: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_obj_short_name, 100);
91: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
92: DBMS_SQL.COLUMN_VALUE(cid, 1, l_obj_short_name);
93: DBMS_SQL.close_cursor(cid);
94: END IF;
95:
96: l_dir:=fnd_profile.value('UTL_FILE_DIR');

Line 93: DBMS_SQL.close_cursor(cid);

89: DBMS_SQL.BIND_VARIABLE(cid, ':dimension', 'CMPWBDimension');
90: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_obj_short_name, 100);
91: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
92: DBMS_SQL.COLUMN_VALUE(cid, 1, l_obj_short_name);
93: DBMS_SQL.close_cursor(cid);
94: END IF;
95:
96: l_dir:=fnd_profile.value('UTL_FILE_DIR');
97:

Line 114: cid := DBMS_SQL.OPEN_CURSOR;

110: stmt := stmt ||' and object_name = :b_object_name';
111: END IF;
112:
113: fnd_file.put_line(fnd_file.log,l_newline||'Going to Execute : '||stmt);
114: cid := DBMS_SQL.OPEN_CURSOR;
115: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
116: DBMS_SQL.BIND_VARIABLE(cid, ':version', l_version);
117:
118: IF l_obj_short_name is not null THEN

Line 115: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);

111: END IF;
112:
113: fnd_file.put_line(fnd_file.log,l_newline||'Going to Execute : '||stmt);
114: cid := DBMS_SQL.OPEN_CURSOR;
115: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
116: DBMS_SQL.BIND_VARIABLE(cid, ':version', l_version);
117:
118: IF l_obj_short_name is not null THEN
119: DBMS_SQL.BIND_VARIABLE(cid, ':b_object_name', l_obj_short_name);

Line 116: DBMS_SQL.BIND_VARIABLE(cid, ':version', l_version);

112:
113: fnd_file.put_line(fnd_file.log,l_newline||'Going to Execute : '||stmt);
114: cid := DBMS_SQL.OPEN_CURSOR;
115: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
116: DBMS_SQL.BIND_VARIABLE(cid, ':version', l_version);
117:
118: IF l_obj_short_name is not null THEN
119: DBMS_SQL.BIND_VARIABLE(cid, ':b_object_name', l_obj_short_name);
120: END IF;

Line 119: DBMS_SQL.BIND_VARIABLE(cid, ':b_object_name', l_obj_short_name);

115: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
116: DBMS_SQL.BIND_VARIABLE(cid, ':version', l_version);
117:
118: IF l_obj_short_name is not null THEN
119: DBMS_SQL.BIND_VARIABLE(cid, ':b_object_name', l_obj_short_name);
120: END IF;
121:
122: DBMS_SQL.DEFINE_COLUMN(cid, 1, nViewCount);
123: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);

Line 122: DBMS_SQL.DEFINE_COLUMN(cid, 1, nViewCount);

118: IF l_obj_short_name is not null THEN
119: DBMS_SQL.BIND_VARIABLE(cid, ':b_object_name', l_obj_short_name);
120: END IF;
121:
122: DBMS_SQL.DEFINE_COLUMN(cid, 1, nViewCount);
123: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
124: DBMS_SQL.COLUMN_VALUE(cid, 1, nViewCount);
125: DBMS_SQL.close_cursor(cid);
126:

Line 123: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);

119: DBMS_SQL.BIND_VARIABLE(cid, ':b_object_name', l_obj_short_name);
120: END IF;
121:
122: DBMS_SQL.DEFINE_COLUMN(cid, 1, nViewCount);
123: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
124: DBMS_SQL.COLUMN_VALUE(cid, 1, nViewCount);
125: DBMS_SQL.close_cursor(cid);
126:
127: fnd_file.put_line(fnd_file.log,l_newline||'Number of source views found :'|| nViewCount);

Line 124: DBMS_SQL.COLUMN_VALUE(cid, 1, nViewCount);

120: END IF;
121:
122: DBMS_SQL.DEFINE_COLUMN(cid, 1, nViewCount);
123: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
124: DBMS_SQL.COLUMN_VALUE(cid, 1, nViewCount);
125: DBMS_SQL.close_cursor(cid);
126:
127: fnd_file.put_line(fnd_file.log,l_newline||'Number of source views found :'|| nViewCount);
128:

Line 125: DBMS_SQL.close_cursor(cid);

121:
122: DBMS_SQL.DEFINE_COLUMN(cid, 1, nViewCount);
123: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
124: DBMS_SQL.COLUMN_VALUE(cid, 1, nViewCount);
125: DBMS_SQL.close_cursor(cid);
126:
127: fnd_file.put_line(fnd_file.log,l_newline||'Number of source views found :'|| nViewCount);
128:
129: stmt := 'SELECT distinct FLEX_VIEW_NAME FROM edw_source_views@' || l_target_link ||

Line 136: cid := DBMS_SQL.OPEN_CURSOR;

132: IF l_obj_short_name is not null THEN
133: stmt := stmt ||' and object_name = :b_object_name ';
134: END IF;
135:
136: cid := DBMS_SQL.OPEN_CURSOR;
137: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
138: DBMS_SQL.BIND_VARIABLE(cid, ':version', l_version);
139:
140: IF l_obj_short_name is not null THEN

Line 137: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);

133: stmt := stmt ||' and object_name = :b_object_name ';
134: END IF;
135:
136: cid := DBMS_SQL.OPEN_CURSOR;
137: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
138: DBMS_SQL.BIND_VARIABLE(cid, ':version', l_version);
139:
140: IF l_obj_short_name is not null THEN
141: DBMS_SQL.BIND_VARIABLE(cid, ':b_object_name', l_obj_short_name);

Line 138: DBMS_SQL.BIND_VARIABLE(cid, ':version', l_version);

134: END IF;
135:
136: cid := DBMS_SQL.OPEN_CURSOR;
137: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
138: DBMS_SQL.BIND_VARIABLE(cid, ':version', l_version);
139:
140: IF l_obj_short_name is not null THEN
141: DBMS_SQL.BIND_VARIABLE(cid, ':b_object_name', l_obj_short_name);
142: END IF;

Line 141: DBMS_SQL.BIND_VARIABLE(cid, ':b_object_name', l_obj_short_name);

137: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
138: DBMS_SQL.BIND_VARIABLE(cid, ':version', l_version);
139:
140: IF l_obj_short_name is not null THEN
141: DBMS_SQL.BIND_VARIABLE(cid, ':b_object_name', l_obj_short_name);
142: END IF;
143: DBMS_SQL.DEFINE_ARRAY(cid, 1, v_col, nViewCount, 1);
144: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
145: DBMS_SQL.COLUMN_VALUE(cid, 1, v_col);

Line 143: DBMS_SQL.DEFINE_ARRAY(cid, 1, v_col, nViewCount, 1);

139:
140: IF l_obj_short_name is not null THEN
141: DBMS_SQL.BIND_VARIABLE(cid, ':b_object_name', l_obj_short_name);
142: END IF;
143: DBMS_SQL.DEFINE_ARRAY(cid, 1, v_col, nViewCount, 1);
144: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
145: DBMS_SQL.COLUMN_VALUE(cid, 1, v_col);
146: DBMS_SQL.close_cursor(cid);
147:

Line 144: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);

140: IF l_obj_short_name is not null THEN
141: DBMS_SQL.BIND_VARIABLE(cid, ':b_object_name', l_obj_short_name);
142: END IF;
143: DBMS_SQL.DEFINE_ARRAY(cid, 1, v_col, nViewCount, 1);
144: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
145: DBMS_SQL.COLUMN_VALUE(cid, 1, v_col);
146: DBMS_SQL.close_cursor(cid);
147:
148: WHILE (nCount < nViewCount )LOOP

Line 145: DBMS_SQL.COLUMN_VALUE(cid, 1, v_col);

141: DBMS_SQL.BIND_VARIABLE(cid, ':b_object_name', l_obj_short_name);
142: END IF;
143: DBMS_SQL.DEFINE_ARRAY(cid, 1, v_col, nViewCount, 1);
144: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
145: DBMS_SQL.COLUMN_VALUE(cid, 1, v_col);
146: DBMS_SQL.close_cursor(cid);
147:
148: WHILE (nCount < nViewCount )LOOP
149: nCount := nCount + 1;

Line 146: DBMS_SQL.close_cursor(cid);

142: END IF;
143: DBMS_SQL.DEFINE_ARRAY(cid, 1, v_col, nViewCount, 1);
144: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
145: DBMS_SQL.COLUMN_VALUE(cid, 1, v_col);
146: DBMS_SQL.close_cursor(cid);
147:
148: WHILE (nCount < nViewCount )LOOP
149: nCount := nCount + 1;
150: fnd_file.put_line(fnd_file.log, nCount||'. Going to generate '||v_col(nCount));