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

Line 156: l_cursor_id := DBMS_SQL.Open_Cursor;

152: ELSE -- l_period_type = 'FII_TIME_WEEK'
153: l_effective_start_date := FII_TIME_API.Cwk_Start(l_as_of_date);
154: END IF;
155:
156: l_cursor_id := DBMS_SQL.Open_Cursor;
157: l_stmt := '
158: SELECT 1
159: FROM ISC_DBI_CFM_008_MV fact
160: WHERE fact.time_snapshot_date_id BETWEEN :l_effective_start_date

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

160: WHERE fact.time_snapshot_date_id BETWEEN :l_effective_start_date
161: AND :l_as_of_date
162: AND rownum = 1 ';
163:
164: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
165: DBMS_SQL.Bind_Variable(l_cursor_id,':l_effective_start_date',l_effective_start_date);
166: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
167:
168: l_dummy := DBMS_SQL.Execute(l_cursor_id);

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

161: AND :l_as_of_date
162: AND rownum = 1 ';
163:
164: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
165: DBMS_SQL.Bind_Variable(l_cursor_id,':l_effective_start_date',l_effective_start_date);
166: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
167:
168: l_dummy := DBMS_SQL.Execute(l_cursor_id);
169:

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

162: AND rownum = 1 ';
163:
164: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
165: DBMS_SQL.Bind_Variable(l_cursor_id,':l_effective_start_date',l_effective_start_date);
166: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
167:
168: l_dummy := DBMS_SQL.Execute(l_cursor_id);
169:
170: IF DBMS_SQL.Fetch_Rows(l_cursor_id) = 0 -- no snapshot taken

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

164: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
165: DBMS_SQL.Bind_Variable(l_cursor_id,':l_effective_start_date',l_effective_start_date);
166: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
167:
168: l_dummy := DBMS_SQL.Execute(l_cursor_id);
169:
170: IF DBMS_SQL.Fetch_Rows(l_cursor_id) = 0 -- no snapshot taken
171: THEN l_snapshot_taken := FALSE;
172: ELSE l_snapshot_taken := TRUE;

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

166: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
167:
168: l_dummy := DBMS_SQL.Execute(l_cursor_id);
169:
170: IF DBMS_SQL.Fetch_Rows(l_cursor_id) = 0 -- no snapshot taken
171: THEN l_snapshot_taken := FALSE;
172: ELSE l_snapshot_taken := TRUE;
173: END IF;
174:

Line 175: DBMS_SQL.Close_Cursor(l_cursor_id);

171: THEN l_snapshot_taken := FALSE;
172: ELSE l_snapshot_taken := TRUE;
173: END IF;
174:
175: DBMS_SQL.Close_Cursor(l_cursor_id);
176:
177: EXCEPTION WHEN OTHERS
178: THEN
179: DBMS_SQL.Close_Cursor(l_cursor_id);

Line 179: DBMS_SQL.Close_Cursor(l_cursor_id);

175: DBMS_SQL.Close_Cursor(l_cursor_id);
176:
177: EXCEPTION WHEN OTHERS
178: THEN
179: DBMS_SQL.Close_Cursor(l_cursor_id);
180: l_snapshot_taken := TRUE;
181:
182: END;
183: