APPS.ISC_DBI_PAST_DUE_SUM_PKG dependencies on DBMS_SQL

Line 199: l_cursor_id := DBMS_SQL.Open_Cursor;

195: ELSE -- l_period_type = 'FII_TIME_WEEK'
196: l_effective_start_date := FII_TIME_API.Cwk_Start(l_as_of_date);
197: END IF;
198:
199: l_cursor_id := DBMS_SQL.Open_Cursor;
200: l_stmt := '
201: SELECT 1
202: FROM ISC_BOOK_SUM2_PDUE_F mv
203: WHERE mv.time_snapshot_date_id BETWEEN :l_effective_start_date

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

203: WHERE mv.time_snapshot_date_id BETWEEN :l_effective_start_date
204: AND :l_as_of_date
205: AND rownum = 1 ';
206:
207: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
208: DBMS_SQL.Bind_Variable(l_cursor_id,':l_effective_start_date',l_effective_start_date);
209: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
210:
211: l_dummy := DBMS_SQL.Execute(l_cursor_id);

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

204: AND :l_as_of_date
205: AND rownum = 1 ';
206:
207: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
208: DBMS_SQL.Bind_Variable(l_cursor_id,':l_effective_start_date',l_effective_start_date);
209: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
210:
211: l_dummy := DBMS_SQL.Execute(l_cursor_id);
212:

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

205: AND rownum = 1 ';
206:
207: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
208: DBMS_SQL.Bind_Variable(l_cursor_id,':l_effective_start_date',l_effective_start_date);
209: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
210:
211: l_dummy := DBMS_SQL.Execute(l_cursor_id);
212:
213: IF DBMS_SQL.Fetch_Rows(l_cursor_id) = 0 -- no snapshot taken

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

207: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
208: DBMS_SQL.Bind_Variable(l_cursor_id,':l_effective_start_date',l_effective_start_date);
209: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
210:
211: l_dummy := DBMS_SQL.Execute(l_cursor_id);
212:
213: IF DBMS_SQL.Fetch_Rows(l_cursor_id) = 0 -- no snapshot taken
214: THEN l_snapshot_taken := FALSE;
215: ELSE l_snapshot_taken := TRUE;

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

209: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
210:
211: l_dummy := DBMS_SQL.Execute(l_cursor_id);
212:
213: IF DBMS_SQL.Fetch_Rows(l_cursor_id) = 0 -- no snapshot taken
214: THEN l_snapshot_taken := FALSE;
215: ELSE l_snapshot_taken := TRUE;
216: END IF;
217:

Line 218: DBMS_SQL.Close_Cursor(l_cursor_id);

214: THEN l_snapshot_taken := FALSE;
215: ELSE l_snapshot_taken := TRUE;
216: END IF;
217:
218: DBMS_SQL.Close_Cursor(l_cursor_id);
219:
220: EXCEPTION WHEN OTHERS
221: THEN
222: DBMS_SQL.Close_Cursor(l_cursor_id);

Line 222: DBMS_SQL.Close_Cursor(l_cursor_id);

218: DBMS_SQL.Close_Cursor(l_cursor_id);
219:
220: EXCEPTION WHEN OTHERS
221: THEN
222: DBMS_SQL.Close_Cursor(l_cursor_id);
223: l_snapshot_taken := TRUE;
224:
225: END;
226: