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

Line 187: l_cursor_id := DBMS_SQL.Open_Cursor;

183: ELSE -- l_period_type = 'FII_TIME_WEEK'
184: l_effective_start_date := FII_TIME_API.Cwk_Start(l_as_of_date);
185: END IF;
186:
187: l_cursor_id := DBMS_SQL.Open_Cursor;
188: l_stmt := '
189: SELECT 1
190: FROM ISC_DBI_CFM_013_MV fact
191: WHERE fact.time_snapshot_date_id BETWEEN :l_effective_start_date

Line 195: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.V7);

191: WHERE fact.time_snapshot_date_id BETWEEN :l_effective_start_date
192: AND :l_as_of_date
193: AND rownum = 1 ';
194:
195: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
196: DBMS_SQL.Bind_Variable(l_cursor_id,':l_effective_start_date',l_effective_start_date);
197: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
198:
199: l_dummy := DBMS_SQL.Execute(l_cursor_id);

Line 196: DBMS_SQL.Bind_Variable(l_cursor_id,':l_effective_start_date',l_effective_start_date);

192: AND :l_as_of_date
193: AND rownum = 1 ';
194:
195: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
196: DBMS_SQL.Bind_Variable(l_cursor_id,':l_effective_start_date',l_effective_start_date);
197: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
198:
199: l_dummy := DBMS_SQL.Execute(l_cursor_id);
200:

Line 197: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);

193: AND rownum = 1 ';
194:
195: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
196: DBMS_SQL.Bind_Variable(l_cursor_id,':l_effective_start_date',l_effective_start_date);
197: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
198:
199: l_dummy := DBMS_SQL.Execute(l_cursor_id);
200:
201: IF DBMS_SQL.Fetch_Rows(l_cursor_id) = 0 -- no snapshot taken

Line 199: l_dummy := DBMS_SQL.Execute(l_cursor_id);

195: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
196: DBMS_SQL.Bind_Variable(l_cursor_id,':l_effective_start_date',l_effective_start_date);
197: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
198:
199: l_dummy := DBMS_SQL.Execute(l_cursor_id);
200:
201: IF DBMS_SQL.Fetch_Rows(l_cursor_id) = 0 -- no snapshot taken
202: THEN l_snapshot_taken := FALSE;
203: ELSE l_snapshot_taken := TRUE;

Line 201: IF DBMS_SQL.Fetch_Rows(l_cursor_id) = 0 -- no snapshot taken

197: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
198:
199: l_dummy := DBMS_SQL.Execute(l_cursor_id);
200:
201: IF DBMS_SQL.Fetch_Rows(l_cursor_id) = 0 -- no snapshot taken
202: THEN l_snapshot_taken := FALSE;
203: ELSE l_snapshot_taken := TRUE;
204: END IF;
205:

Line 206: DBMS_SQL.Close_Cursor(l_cursor_id);

202: THEN l_snapshot_taken := FALSE;
203: ELSE l_snapshot_taken := TRUE;
204: END IF;
205:
206: DBMS_SQL.Close_Cursor(l_cursor_id);
207:
208: EXCEPTION WHEN OTHERS
209: THEN
210: DBMS_SQL.Close_Cursor(l_cursor_id);

Line 210: DBMS_SQL.Close_Cursor(l_cursor_id);

206: DBMS_SQL.Close_Cursor(l_cursor_id);
207:
208: EXCEPTION WHEN OTHERS
209: THEN
210: DBMS_SQL.Close_Cursor(l_cursor_id);
211: l_snapshot_taken := TRUE;
212:
213: END;
214: