APPS.ISC_DBI_PAST_DUE_PKG dependencies on DBMS_SQL

Line 130: l_cursor_id := DBMS_SQL.Open_Cursor;

126: ELSE -- l_period_type = 'FII_TIME_WEEK'
127: l_effective_start_date := FII_TIME_API.Cwk_Start(l_as_of_date);
128: END IF;
129:
130: l_cursor_id := DBMS_SQL.Open_Cursor;
131: l_stmt := '
132: SELECT 1
133: FROM ISC_BOOK_SUM2_PDUE_F mv
134: WHERE mv.time_snapshot_date_id BETWEEN :l_effective_start_date

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

134: WHERE mv.time_snapshot_date_id BETWEEN :l_effective_start_date
135: AND :l_as_of_date
136: AND rownum = 1';
137:
138: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
139: DBMS_SQL.Bind_Variable(l_cursor_id,':l_effective_start_date',l_effective_start_date);
140: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
141:
142: l_dummy := DBMS_SQL.Execute(l_cursor_id);

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

135: AND :l_as_of_date
136: AND rownum = 1';
137:
138: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
139: DBMS_SQL.Bind_Variable(l_cursor_id,':l_effective_start_date',l_effective_start_date);
140: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
141:
142: l_dummy := DBMS_SQL.Execute(l_cursor_id);
143:

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

136: AND rownum = 1';
137:
138: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
139: DBMS_SQL.Bind_Variable(l_cursor_id,':l_effective_start_date',l_effective_start_date);
140: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
141:
142: l_dummy := DBMS_SQL.Execute(l_cursor_id);
143:
144: IF DBMS_SQL.Fetch_Rows(l_cursor_id) = 0 -- no snapshot taken

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

138: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
139: DBMS_SQL.Bind_Variable(l_cursor_id,':l_effective_start_date',l_effective_start_date);
140: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
141:
142: l_dummy := DBMS_SQL.Execute(l_cursor_id);
143:
144: IF DBMS_SQL.Fetch_Rows(l_cursor_id) = 0 -- no snapshot taken
145: THEN l_snapshot_taken := FALSE;
146: ELSE l_snapshot_taken := TRUE;

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

140: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
141:
142: l_dummy := DBMS_SQL.Execute(l_cursor_id);
143:
144: IF DBMS_SQL.Fetch_Rows(l_cursor_id) = 0 -- no snapshot taken
145: THEN l_snapshot_taken := FALSE;
146: ELSE l_snapshot_taken := TRUE;
147: END IF;
148:

Line 149: DBMS_SQL.Close_Cursor(l_cursor_id);

145: THEN l_snapshot_taken := FALSE;
146: ELSE l_snapshot_taken := TRUE;
147: END IF;
148:
149: DBMS_SQL.Close_Cursor(l_cursor_id);
150:
151: EXCEPTION WHEN OTHERS
152: THEN
153: DBMS_SQL.Close_Cursor(l_cursor_id);

Line 153: DBMS_SQL.Close_Cursor(l_cursor_id);

149: DBMS_SQL.Close_Cursor(l_cursor_id);
150:
151: EXCEPTION WHEN OTHERS
152: THEN
153: DBMS_SQL.Close_Cursor(l_cursor_id);
154: l_snapshot_taken := TRUE;
155:
156: END;
157: