APPS.ISC_DBI_PDUE_PRM_SUM_PKG dependencies on DBMS_SQL

Line 206: l_cursor_id := DBMS_SQL.Open_Cursor;

202: ELSE -- l_period_type = 'FII_TIME_WEEK'
203: l_effective_start_date := FII_TIME_API.Cwk_Start(l_as_of_date);
204: END IF;
205:
206: l_cursor_id := DBMS_SQL.Open_Cursor;
207: l_stmt := '
208: SELECT 1
209: FROM ISC_DBI_CFM_008_MV fact
210: WHERE fact.time_snapshot_date_id BETWEEN :l_effective_start_date

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

210: WHERE fact.time_snapshot_date_id BETWEEN :l_effective_start_date
211: AND :l_as_of_date
212: AND rownum = 1 ';
213:
214: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
215: DBMS_SQL.Bind_Variable(l_cursor_id,':l_effective_start_date',l_effective_start_date);
216: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
217:
218: l_dummy := DBMS_SQL.Execute(l_cursor_id);

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

211: AND :l_as_of_date
212: AND rownum = 1 ';
213:
214: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
215: DBMS_SQL.Bind_Variable(l_cursor_id,':l_effective_start_date',l_effective_start_date);
216: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
217:
218: l_dummy := DBMS_SQL.Execute(l_cursor_id);
219:

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

212: AND rownum = 1 ';
213:
214: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
215: DBMS_SQL.Bind_Variable(l_cursor_id,':l_effective_start_date',l_effective_start_date);
216: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
217:
218: l_dummy := DBMS_SQL.Execute(l_cursor_id);
219:
220: IF DBMS_SQL.Fetch_Rows(l_cursor_id) = 0 -- no snapshot taken

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

214: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
215: DBMS_SQL.Bind_Variable(l_cursor_id,':l_effective_start_date',l_effective_start_date);
216: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
217:
218: l_dummy := DBMS_SQL.Execute(l_cursor_id);
219:
220: IF DBMS_SQL.Fetch_Rows(l_cursor_id) = 0 -- no snapshot taken
221: THEN l_snapshot_taken := FALSE;
222: ELSE l_snapshot_taken := TRUE;

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

216: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
217:
218: l_dummy := DBMS_SQL.Execute(l_cursor_id);
219:
220: IF DBMS_SQL.Fetch_Rows(l_cursor_id) = 0 -- no snapshot taken
221: THEN l_snapshot_taken := FALSE;
222: ELSE l_snapshot_taken := TRUE;
223: END IF;
224:

Line 225: DBMS_SQL.Close_Cursor(l_cursor_id);

221: THEN l_snapshot_taken := FALSE;
222: ELSE l_snapshot_taken := TRUE;
223: END IF;
224:
225: DBMS_SQL.Close_Cursor(l_cursor_id);
226:
227: EXCEPTION WHEN OTHERS
228: THEN
229: DBMS_SQL.Close_Cursor(l_cursor_id);

Line 229: DBMS_SQL.Close_Cursor(l_cursor_id);

225: DBMS_SQL.Close_Cursor(l_cursor_id);
226:
227: EXCEPTION WHEN OTHERS
228: THEN
229: DBMS_SQL.Close_Cursor(l_cursor_id);
230: l_snapshot_taken := TRUE;
231:
232: END;
233: