APPS.ISC_DBI_BACKORDER_SUM_PKG dependencies on DBMS_SQL

Line 117: l_cursor_id := DBMS_SQL.Open_Cursor;

113: ELSE -- l_period_type = 'FII_TIME_WEEK'
114: l_effective_start_date := FII_TIME_API.Cwk_Start(l_as_of_date);
115: END IF;
116:
117: l_cursor_id := DBMS_SQL.Open_Cursor;
118:
119: IF(l_period_type = 'FII_TIME_DAY')
120: THEN
121: l_stmt := '

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

123: FROM ISC_DBI_FM_0007_MV mv
124: WHERE mv.time_snapshot_date_id = :l_as_of_date
125: AND rownum = 1 ';
126:
127: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
128: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
129:
130: ELSE
131: l_stmt := '

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

124: WHERE mv.time_snapshot_date_id = :l_as_of_date
125: AND rownum = 1 ';
126:
127: DBMS_SQL.Parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
128: DBMS_SQL.Bind_Variable(l_cursor_id,':l_as_of_date',l_as_of_date);
129:
130: ELSE
131: l_stmt := '
132: SELECT 1

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: END IF;
142:

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: END IF;
142:
143: l_dummy := DBMS_SQL.Execute(l_cursor_id);

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: END IF;
142:
143: l_dummy := DBMS_SQL.Execute(l_cursor_id);
144:

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

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: END IF;
142:
143: l_dummy := DBMS_SQL.Execute(l_cursor_id);
144:
145: IF DBMS_SQL.Fetch_Rows(l_cursor_id) = 0 -- no snapshot taken
146: THEN l_snapshot_taken := FALSE;
147: ELSE l_snapshot_taken := TRUE;

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

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

Line 150: DBMS_SQL.Close_Cursor(l_cursor_id);

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

Line 154: DBMS_SQL.Close_Cursor(l_cursor_id);

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