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.BIS_DIM_LEVEL_VALUE_PVT dependencies on DBMS_SQL

Line 82: l_id1 DBMS_SQL.VARCHAR2_TABLE;

78: l_select_stmt VARCHAR2(32000);
79: l_sql_result INTEGER := 0;
80: l_resp_clause VARCHAR2(10000);
81: --
82: l_id1 DBMS_SQL.VARCHAR2_TABLE;
83: l_value1 DBMS_SQL.VARCHAR2_TABLE;
84: l_size NUMBER := 100000;
85: l_retrieved NUMBER;
86: --

Line 83: l_value1 DBMS_SQL.VARCHAR2_TABLE;

79: l_sql_result INTEGER := 0;
80: l_resp_clause VARCHAR2(10000);
81: --
82: l_id1 DBMS_SQL.VARCHAR2_TABLE;
83: l_value1 DBMS_SQL.VARCHAR2_TABLE;
84: l_size NUMBER := 100000;
85: l_retrieved NUMBER;
86: --
87: BEGIN

Line 121: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

117: l_resp_clause := l_resp_clause || ' ) ';
118: l_resp_clause := l_resp_clause || ' OR RESPONSIBILITY_ID IS NULL ';
119: END IF;
120:
121: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
122: DBMS_SQL.CLOSE_CURSOR(l_cursor);
123: END IF;
124: l_cursor := DBMS_SQL.OPEN_CURSOR;
125: --

Line 122: DBMS_SQL.CLOSE_CURSOR(l_cursor);

118: l_resp_clause := l_resp_clause || ' OR RESPONSIBILITY_ID IS NULL ';
119: END IF;
120:
121: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
122: DBMS_SQL.CLOSE_CURSOR(l_cursor);
123: END IF;
124: l_cursor := DBMS_SQL.OPEN_CURSOR;
125: --
126: IF(p_Responsibility_Tbl.COUNT <> 0) THEN

Line 124: l_cursor := DBMS_SQL.OPEN_CURSOR;

120:
121: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
122: DBMS_SQL.CLOSE_CURSOR(l_cursor);
123: END IF;
124: l_cursor := DBMS_SQL.OPEN_CURSOR;
125: --
126: IF(p_Responsibility_Tbl.COUNT <> 0) THEN
127: l_select_stmt := 'SELECT DISTINCT'
128: || ' ID '

Line 143: DBMS_SQL.PARSE( c => l_cursor

139: || ' FROM '
140: || l_view_name
141: || ' ORDER BY VALUE';
142: END IF;
143: DBMS_SQL.PARSE( c => l_cursor
144: , statement => l_select_stmt
145: , language_flag => DBMS_SQL.NATIVE
146: );
147: FOR l_ind IN 1..p_Responsibility_Tbl.COUNT LOOP

Line 145: , language_flag => DBMS_SQL.NATIVE

141: || ' ORDER BY VALUE';
142: END IF;
143: DBMS_SQL.PARSE( c => l_cursor
144: , statement => l_select_stmt
145: , language_flag => DBMS_SQL.NATIVE
146: );
147: FOR l_ind IN 1..p_Responsibility_Tbl.COUNT LOOP
148: DBMS_SQL.BIND_VARIABLE
149: ( l_cursor

Line 148: DBMS_SQL.BIND_VARIABLE

144: , statement => l_select_stmt
145: , language_flag => DBMS_SQL.NATIVE
146: );
147: FOR l_ind IN 1..p_Responsibility_Tbl.COUNT LOOP
148: DBMS_SQL.BIND_VARIABLE
149: ( l_cursor
150: , ':b_resp' || TO_CHAR(l_ind)
151: , p_Responsibility_Tbl(l_ind).Responsibility_ID
152: );

Line 154: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);

150: , ':b_resp' || TO_CHAR(l_ind)
151: , p_Responsibility_Tbl(l_ind).Responsibility_ID
152: );
153: END LOOP;
154: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);
155: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);
156: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
157: --
158: LOOP

Line 155: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);

151: , p_Responsibility_Tbl(l_ind).Responsibility_ID
152: );
153: END LOOP;
154: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);
155: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);
156: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
157: --
158: LOOP
159: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);

Line 156: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);

152: );
153: END LOOP;
154: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);
155: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);
156: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
157: --
158: LOOP
159: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);
160: EXIT WHEN l_retrieved = 0;

Line 159: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);

155: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);
156: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
157: --
158: LOOP
159: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);
160: EXIT WHEN l_retrieved = 0;
161: --
162: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_id1);
163: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_value1);

Line 162: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_id1);

158: LOOP
159: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);
160: EXIT WHEN l_retrieved = 0;
161: --
162: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_id1);
163: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_value1);
164: --
165: FOR l_ind1 IN 1..l_id1.COUNT LOOP
166: l_ind := l_ind + 1;

Line 163: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_value1);

159: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);
160: EXIT WHEN l_retrieved = 0;
161: --
162: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_id1);
163: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_value1);
164: --
165: FOR l_ind1 IN 1..l_id1.COUNT LOOP
166: l_ind := l_ind + 1;
167: x_Dim_Level_Value_Tbl(l_ind).Dimension_Level_Value_ID

Line 182: DBMS_SQL.CLOSE_CURSOR(l_cursor);

178: --
179: EXIT WHEN l_retrieved < l_size;
180: END LOOP;
181: --
182: DBMS_SQL.CLOSE_CURSOR(l_cursor);
183: ELSE
184: l_ind := l_ind + 1;
185: x_Dim_Level_Value_Tbl(l_ind).Dimension_Level_Value_ID := '-1';
186: x_Dim_Level_Value_Tbl(l_ind).Dimension_Level_Value_Name := l_name;

Line 195: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

191: END IF;
192: --
193: EXCEPTION
194: WHEN NO_DATA_FOUND THEN
195: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
196: DBMS_SQL.CLOSE_CURSOR(l_cursor);
197: END IF;
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 196: DBMS_SQL.CLOSE_CURSOR(l_cursor);

192: --
193: EXCEPTION
194: WHEN NO_DATA_FOUND THEN
195: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
196: DBMS_SQL.CLOSE_CURSOR(l_cursor);
197: END IF;
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
200: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:NO_DATA_FOUND'); htp.para;

Line 204: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

200: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:NO_DATA_FOUND'); htp.para;
201: END IF;
202: RAISE FND_API.G_EXC_ERROR;
203: WHEN FND_API.G_EXC_ERROR THEN
204: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
205: DBMS_SQL.CLOSE_CURSOR(l_cursor);
206: END IF;
207: x_return_status := FND_API.G_RET_STS_ERROR;
208: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 205: DBMS_SQL.CLOSE_CURSOR(l_cursor);

201: END IF;
202: RAISE FND_API.G_EXC_ERROR;
203: WHEN FND_API.G_EXC_ERROR THEN
204: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
205: DBMS_SQL.CLOSE_CURSOR(l_cursor);
206: END IF;
207: x_return_status := FND_API.G_RET_STS_ERROR;
208: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
209: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:G_EXC_ERROR'); htp.para;

Line 213: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

209: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:G_EXC_ERROR'); htp.para;
210: END IF;
211: RAISE;
212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
213: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
214: DBMS_SQL.CLOSE_CURSOR(l_cursor);
215: END IF;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 214: DBMS_SQL.CLOSE_CURSOR(l_cursor);

210: END IF;
211: RAISE;
212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
213: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
214: DBMS_SQL.CLOSE_CURSOR(l_cursor);
215: END IF;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
218: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:G_EXC_UNEXPECTED_ERROR'); htp.para;

Line 222: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

218: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:G_EXC_UNEXPECTED_ERROR'); htp.para;
219: END IF;
220: RAISE;
221: WHEN OTHERS THEN
222: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
223: DBMS_SQL.CLOSE_CURSOR(l_cursor);
224: END IF;
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: BIS_UTILITIES_PVT.Add_Error_Message

Line 223: DBMS_SQL.CLOSE_CURSOR(l_cursor);

219: END IF;
220: RAISE;
221: WHEN OTHERS THEN
222: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
223: DBMS_SQL.CLOSE_CURSOR(l_cursor);
224: END IF;
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: BIS_UTILITIES_PVT.Add_Error_Message
227: ( p_error_table => x_error_Tbl

Line 260: l_id1 DBMS_SQL.VARCHAR2_TABLE;

256: l_value VARCHAR2(250);
257: l_select_stmt VARCHAR2(2000);
258: l_sql_result INTEGER := 0;
259: --
260: l_id1 DBMS_SQL.VARCHAR2_TABLE;
261: l_value1 DBMS_SQL.VARCHAR2_TABLE;
262: l_size NUMBER := 100000;
263: l_retrieved NUMBER;
264: --

Line 261: l_value1 DBMS_SQL.VARCHAR2_TABLE;

257: l_select_stmt VARCHAR2(2000);
258: l_sql_result INTEGER := 0;
259: --
260: l_id1 DBMS_SQL.VARCHAR2_TABLE;
261: l_value1 DBMS_SQL.VARCHAR2_TABLE;
262: l_size NUMBER := 100000;
263: l_retrieved NUMBER;
264: --
265: BEGIN

Line 280: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

276: FROM BISBV_DIMENSION_LEVELS
277: WHERE DIMENSION_LEVEL_ID = p_Dimension_Level_Rec.Dimension_Level_ID;
278: --
279: IF(l_short_name <> 'TOTAL_ORGANIZATIONS') THEN
280: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
281: DBMS_SQL.CLOSE_CURSOR(l_cursor);
282: END IF;
283: l_cursor := DBMS_SQL.OPEN_CURSOR;
284: --

Line 281: DBMS_SQL.CLOSE_CURSOR(l_cursor);

277: WHERE DIMENSION_LEVEL_ID = p_Dimension_Level_Rec.Dimension_Level_ID;
278: --
279: IF(l_short_name <> 'TOTAL_ORGANIZATIONS') THEN
280: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
281: DBMS_SQL.CLOSE_CURSOR(l_cursor);
282: END IF;
283: l_cursor := DBMS_SQL.OPEN_CURSOR;
284: --
285: IF(p_Responsibility_ID IS NOT NULL) THEN

Line 283: l_cursor := DBMS_SQL.OPEN_CURSOR;

279: IF(l_short_name <> 'TOTAL_ORGANIZATIONS') THEN
280: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
281: DBMS_SQL.CLOSE_CURSOR(l_cursor);
282: END IF;
283: l_cursor := DBMS_SQL.OPEN_CURSOR;
284: --
285: IF(p_Responsibility_ID IS NOT NULL) THEN
286: l_select_stmt := 'SELECT '
287: || ' ID '

Line 303: DBMS_SQL.PARSE( c => l_cursor

299: || l_view_name
300: || ' ORDER BY VALUE';
301: END IF;
302:
303: DBMS_SQL.PARSE( c => l_cursor
304: , statement => l_select_stmt
305: , language_flag => DBMS_SQL.NATIVE
306: );
307: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);

Line 305: , language_flag => DBMS_SQL.NATIVE

301: END IF;
302:
303: DBMS_SQL.PARSE( c => l_cursor
304: , statement => l_select_stmt
305: , language_flag => DBMS_SQL.NATIVE
306: );
307: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);
308: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);
309: IF(p_Responsibility_ID IS NOT NULL) THEN

Line 307: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);

303: DBMS_SQL.PARSE( c => l_cursor
304: , statement => l_select_stmt
305: , language_flag => DBMS_SQL.NATIVE
306: );
307: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);
308: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);
309: IF(p_Responsibility_ID IS NOT NULL) THEN
310: DBMS_SQL.BIND_VARIABLE(l_cursor, ':p_Responsibility_ID', p_Responsibility_ID);
311: END IF;

Line 308: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);

304: , statement => l_select_stmt
305: , language_flag => DBMS_SQL.NATIVE
306: );
307: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);
308: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);
309: IF(p_Responsibility_ID IS NOT NULL) THEN
310: DBMS_SQL.BIND_VARIABLE(l_cursor, ':p_Responsibility_ID', p_Responsibility_ID);
311: END IF;
312:

Line 310: DBMS_SQL.BIND_VARIABLE(l_cursor, ':p_Responsibility_ID', p_Responsibility_ID);

306: );
307: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);
308: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);
309: IF(p_Responsibility_ID IS NOT NULL) THEN
310: DBMS_SQL.BIND_VARIABLE(l_cursor, ':p_Responsibility_ID', p_Responsibility_ID);
311: END IF;
312:
313: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
314: --

Line 313: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);

309: IF(p_Responsibility_ID IS NOT NULL) THEN
310: DBMS_SQL.BIND_VARIABLE(l_cursor, ':p_Responsibility_ID', p_Responsibility_ID);
311: END IF;
312:
313: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
314: --
315: LOOP
316: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);
317: EXIT WHEN l_retrieved = 0;

Line 316: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);

312:
313: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
314: --
315: LOOP
316: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);
317: EXIT WHEN l_retrieved = 0;
318: --
319: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_id1);
320: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_value1);

Line 319: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_id1);

315: LOOP
316: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);
317: EXIT WHEN l_retrieved = 0;
318: --
319: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_id1);
320: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_value1);
321: --
322: FOR l_ind1 IN 1..l_id1.COUNT LOOP
323: l_ind := l_ind + 1;

Line 320: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_value1);

316: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);
317: EXIT WHEN l_retrieved = 0;
318: --
319: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_id1);
320: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_value1);
321: --
322: FOR l_ind1 IN 1..l_id1.COUNT LOOP
323: l_ind := l_ind + 1;
324: x_Dim_Level_Value_Tbl(l_ind).Dimension_Level_Value_ID

Line 339: DBMS_SQL.CLOSE_CURSOR(l_cursor);

335: --
336: EXIT WHEN l_retrieved < l_size;
337: END LOOP;
338: --
339: DBMS_SQL.CLOSE_CURSOR(l_cursor);
340: ELSE
341: l_ind := l_ind + 1;
342: x_Dim_Level_Value_Tbl(l_ind).Dimension_Level_Value_ID := '-1';
343: x_Dim_Level_Value_Tbl(l_ind).Dimension_Level_Value_Name := l_name;

Line 352: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

348: END IF;
349: --
350: EXCEPTION
351: WHEN NO_DATA_FOUND THEN
352: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
353: DBMS_SQL.CLOSE_CURSOR(l_cursor);
354: END IF;
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 353: DBMS_SQL.CLOSE_CURSOR(l_cursor);

349: --
350: EXCEPTION
351: WHEN NO_DATA_FOUND THEN
352: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
353: DBMS_SQL.CLOSE_CURSOR(l_cursor);
354: END IF;
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
357: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:NO_DATA_FOUND'); htp.para;

Line 361: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

357: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:NO_DATA_FOUND'); htp.para;
358: END IF;
359: RAISE FND_API.G_EXC_ERROR;
360: WHEN FND_API.G_EXC_ERROR THEN
361: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
362: DBMS_SQL.CLOSE_CURSOR(l_cursor);
363: END IF;
364: x_return_status := FND_API.G_RET_STS_ERROR;
365: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 362: DBMS_SQL.CLOSE_CURSOR(l_cursor);

358: END IF;
359: RAISE FND_API.G_EXC_ERROR;
360: WHEN FND_API.G_EXC_ERROR THEN
361: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
362: DBMS_SQL.CLOSE_CURSOR(l_cursor);
363: END IF;
364: x_return_status := FND_API.G_RET_STS_ERROR;
365: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
366: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:G_EXC_ERROR'); htp.para;

Line 370: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

366: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:G_EXC_ERROR'); htp.para;
367: END IF;
368: RAISE;
369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
370: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
371: DBMS_SQL.CLOSE_CURSOR(l_cursor);
372: END IF;
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
374: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 371: DBMS_SQL.CLOSE_CURSOR(l_cursor);

367: END IF;
368: RAISE;
369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
370: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
371: DBMS_SQL.CLOSE_CURSOR(l_cursor);
372: END IF;
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
374: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
375: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:G_EXC_UNEXPECTED_ERROR'); htp.para;

Line 379: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

375: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:G_EXC_UNEXPECTED_ERROR'); htp.para;
376: END IF;
377: RAISE;
378: WHEN OTHERS THEN
379: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
380: DBMS_SQL.CLOSE_CURSOR(l_cursor);
381: END IF;
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383: BIS_UTILITIES_PVT.Add_Error_Message

Line 380: DBMS_SQL.CLOSE_CURSOR(l_cursor);

376: END IF;
377: RAISE;
378: WHEN OTHERS THEN
379: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
380: DBMS_SQL.CLOSE_CURSOR(l_cursor);
381: END IF;
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383: BIS_UTILITIES_PVT.Add_Error_Message
384: ( p_error_table => x_error_Tbl

Line 416: l_id1 DBMS_SQL.VARCHAR2_TABLE;

412: l_value VARCHAR2(250);
413: l_select_stmt VARCHAR2(2000);
414: l_sql_result INTEGER := 0;
415: --
416: l_id1 DBMS_SQL.VARCHAR2_TABLE;
417: l_value1 DBMS_SQL.VARCHAR2_TABLE;
418: l_size NUMBER := 100000;
419: l_retrieved NUMBER;
420: --

Line 417: l_value1 DBMS_SQL.VARCHAR2_TABLE;

413: l_select_stmt VARCHAR2(2000);
414: l_sql_result INTEGER := 0;
415: --
416: l_id1 DBMS_SQL.VARCHAR2_TABLE;
417: l_value1 DBMS_SQL.VARCHAR2_TABLE;
418: l_size NUMBER := 100000;
419: l_retrieved NUMBER;
420: --
421: BEGIN

Line 436: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

432: FROM BISBV_DIMENSION_LEVELS
433: WHERE DIMENSION_LEVEL_ID = p_Dimension_Level_Rec.Dimension_Level_ID;
434: --
435: IF(l_short_name <> 'TOTAL_ORGANIZATIONS') THEN
436: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
437: DBMS_SQL.CLOSE_CURSOR(l_cursor);
438: END IF;
439: l_cursor := DBMS_SQL.OPEN_CURSOR;
440: --

Line 437: DBMS_SQL.CLOSE_CURSOR(l_cursor);

433: WHERE DIMENSION_LEVEL_ID = p_Dimension_Level_Rec.Dimension_Level_ID;
434: --
435: IF(l_short_name <> 'TOTAL_ORGANIZATIONS') THEN
436: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
437: DBMS_SQL.CLOSE_CURSOR(l_cursor);
438: END IF;
439: l_cursor := DBMS_SQL.OPEN_CURSOR;
440: --
441: l_select_stmt := 'SELECT DISTINCT'

Line 439: l_cursor := DBMS_SQL.OPEN_CURSOR;

435: IF(l_short_name <> 'TOTAL_ORGANIZATIONS') THEN
436: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
437: DBMS_SQL.CLOSE_CURSOR(l_cursor);
438: END IF;
439: l_cursor := DBMS_SQL.OPEN_CURSOR;
440: --
441: l_select_stmt := 'SELECT DISTINCT'
442: || ' ID '
443: || ', VALUE '

Line 448: DBMS_SQL.PARSE( c => l_cursor

444: || ' FROM '
445: || l_view_name
446: || ' ORDER BY VALUE';
447: --
448: DBMS_SQL.PARSE( c => l_cursor
449: , statement => l_select_stmt
450: , language_flag => DBMS_SQL.NATIVE
451: );
452: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);

Line 450: , language_flag => DBMS_SQL.NATIVE

446: || ' ORDER BY VALUE';
447: --
448: DBMS_SQL.PARSE( c => l_cursor
449: , statement => l_select_stmt
450: , language_flag => DBMS_SQL.NATIVE
451: );
452: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);
453: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);
454: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);

Line 452: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);

448: DBMS_SQL.PARSE( c => l_cursor
449: , statement => l_select_stmt
450: , language_flag => DBMS_SQL.NATIVE
451: );
452: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);
453: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);
454: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
455: --
456: LOOP

Line 453: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);

449: , statement => l_select_stmt
450: , language_flag => DBMS_SQL.NATIVE
451: );
452: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);
453: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);
454: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
455: --
456: LOOP
457: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);

Line 454: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);

450: , language_flag => DBMS_SQL.NATIVE
451: );
452: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);
453: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);
454: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
455: --
456: LOOP
457: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);
458: EXIT WHEN l_retrieved = 0;

Line 457: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);

453: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);
454: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
455: --
456: LOOP
457: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);
458: EXIT WHEN l_retrieved = 0;
459: --
460: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_id1);
461: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_value1);

Line 460: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_id1);

456: LOOP
457: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);
458: EXIT WHEN l_retrieved = 0;
459: --
460: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_id1);
461: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_value1);
462: --
463: FOR l_ind1 IN 1..l_id1.COUNT LOOP
464: l_ind := l_ind + 1;

Line 461: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_value1);

457: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);
458: EXIT WHEN l_retrieved = 0;
459: --
460: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_id1);
461: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_value1);
462: --
463: FOR l_ind1 IN 1..l_id1.COUNT LOOP
464: l_ind := l_ind + 1;
465: x_Dim_Level_Value_Tbl(l_ind).Dimension_Level_Value_ID

Line 480: DBMS_SQL.CLOSE_CURSOR(l_cursor);

476: --
477: EXIT WHEN l_retrieved < l_size;
478: END LOOP;
479: --
480: DBMS_SQL.CLOSE_CURSOR(l_cursor);
481: ELSE
482: l_ind := l_ind + 1;
483: x_Dim_Level_Value_Tbl(l_ind).Dimension_Level_Value_ID := '-1';
484: x_Dim_Level_Value_Tbl(l_ind).Dimension_Level_Value_Name := l_name;

Line 493: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

489: END IF;
490: --
491: EXCEPTION
492: WHEN NO_DATA_FOUND THEN
493: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
494: DBMS_SQL.CLOSE_CURSOR(l_cursor);
495: END IF;
496: x_return_status := FND_API.G_RET_STS_ERROR;
497: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 494: DBMS_SQL.CLOSE_CURSOR(l_cursor);

490: --
491: EXCEPTION
492: WHEN NO_DATA_FOUND THEN
493: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
494: DBMS_SQL.CLOSE_CURSOR(l_cursor);
495: END IF;
496: x_return_status := FND_API.G_RET_STS_ERROR;
497: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
498: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:NO_DATA_FOUND'); htp.para;

Line 502: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

498: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:NO_DATA_FOUND'); htp.para;
499: END IF;
500: RAISE FND_API.G_EXC_ERROR;
501: WHEN FND_API.G_EXC_ERROR THEN
502: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
503: DBMS_SQL.CLOSE_CURSOR(l_cursor);
504: END IF;
505: x_return_status := FND_API.G_RET_STS_ERROR;
506: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 503: DBMS_SQL.CLOSE_CURSOR(l_cursor);

499: END IF;
500: RAISE FND_API.G_EXC_ERROR;
501: WHEN FND_API.G_EXC_ERROR THEN
502: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
503: DBMS_SQL.CLOSE_CURSOR(l_cursor);
504: END IF;
505: x_return_status := FND_API.G_RET_STS_ERROR;
506: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
507: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:G_EXC_ERROR'); htp.para;

Line 511: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

507: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:G_EXC_ERROR'); htp.para;
508: END IF;
509: RAISE;
510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
511: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
512: DBMS_SQL.CLOSE_CURSOR(l_cursor);
513: END IF;
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 512: DBMS_SQL.CLOSE_CURSOR(l_cursor);

508: END IF;
509: RAISE;
510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
511: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
512: DBMS_SQL.CLOSE_CURSOR(l_cursor);
513: END IF;
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
516: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:G_EXC_UNEXPECTED_ERROR'); htp.para;

Line 520: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

516: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:G_EXC_UNEXPECTED_ERROR'); htp.para;
517: END IF;
518: RAISE;
519: WHEN OTHERS THEN
520: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
521: DBMS_SQL.CLOSE_CURSOR(l_cursor);
522: END IF;
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
524: BIS_UTILITIES_PVT.Add_Error_Message

Line 521: DBMS_SQL.CLOSE_CURSOR(l_cursor);

517: END IF;
518: RAISE;
519: WHEN OTHERS THEN
520: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
521: DBMS_SQL.CLOSE_CURSOR(l_cursor);
522: END IF;
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
524: BIS_UTILITIES_PVT.Add_Error_Message
525: ( p_error_table => x_error_Tbl

Line 556: l_id1 DBMS_SQL.VARCHAR2_TABLE;

552: l_value VARCHAR2(250);
553: l_select_stmt VARCHAR2(2000);
554: l_sql_result INTEGER := 0;
555: --
556: l_id1 DBMS_SQL.VARCHAR2_TABLE;
557: l_value1 DBMS_SQL.VARCHAR2_TABLE;
558: l_size NUMBER := 100000;
559: l_retrieved NUMBER;
560: --

Line 557: l_value1 DBMS_SQL.VARCHAR2_TABLE;

553: l_select_stmt VARCHAR2(2000);
554: l_sql_result INTEGER := 0;
555: --
556: l_id1 DBMS_SQL.VARCHAR2_TABLE;
557: l_value1 DBMS_SQL.VARCHAR2_TABLE;
558: l_size NUMBER := 100000;
559: l_retrieved NUMBER;
560: --
561: BEGIN

Line 576: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

572: FROM BISBV_DIMENSION_LEVELS
573: WHERE DIMENSION_LEVEL_ID = p_Dimension_Level_Rec.Dimension_Level_ID;
574: --
575: IF(SUBSTR(l_short_name, 1, 5) <> 'TOTAL') THEN
576: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
577: DBMS_SQL.CLOSE_CURSOR(l_cursor);
578: END IF;
579: l_cursor := DBMS_SQL.OPEN_CURSOR;
580: --

Line 577: DBMS_SQL.CLOSE_CURSOR(l_cursor);

573: WHERE DIMENSION_LEVEL_ID = p_Dimension_Level_Rec.Dimension_Level_ID;
574: --
575: IF(SUBSTR(l_short_name, 1, 5) <> 'TOTAL') THEN
576: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
577: DBMS_SQL.CLOSE_CURSOR(l_cursor);
578: END IF;
579: l_cursor := DBMS_SQL.OPEN_CURSOR;
580: --
581: l_select_stmt := 'SELECT DISTINCT '

Line 579: l_cursor := DBMS_SQL.OPEN_CURSOR;

575: IF(SUBSTR(l_short_name, 1, 5) <> 'TOTAL') THEN
576: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
577: DBMS_SQL.CLOSE_CURSOR(l_cursor);
578: END IF;
579: l_cursor := DBMS_SQL.OPEN_CURSOR;
580: --
581: l_select_stmt := 'SELECT DISTINCT '
582: || ' ID '
583: || ', VALUE '

Line 589: DBMS_SQL.PARSE( c => l_cursor

585: || l_view_name
586: || ' ORDER BY VALUE';
587: --
588: -- htp.header(4, 'l_select_stmt = ' || l_select_stmt);
589: DBMS_SQL.PARSE( c => l_cursor
590: , statement => l_select_stmt
591: , language_flag => DBMS_SQL.NATIVE
592: );
593: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);

Line 591: , language_flag => DBMS_SQL.NATIVE

587: --
588: -- htp.header(4, 'l_select_stmt = ' || l_select_stmt);
589: DBMS_SQL.PARSE( c => l_cursor
590: , statement => l_select_stmt
591: , language_flag => DBMS_SQL.NATIVE
592: );
593: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);
594: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);
595: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);

Line 593: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);

589: DBMS_SQL.PARSE( c => l_cursor
590: , statement => l_select_stmt
591: , language_flag => DBMS_SQL.NATIVE
592: );
593: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);
594: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);
595: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
596: --
597: LOOP

Line 594: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);

590: , statement => l_select_stmt
591: , language_flag => DBMS_SQL.NATIVE
592: );
593: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);
594: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);
595: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
596: --
597: LOOP
598: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);

Line 595: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);

591: , language_flag => DBMS_SQL.NATIVE
592: );
593: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);
594: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);
595: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
596: --
597: LOOP
598: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);
599: EXIT WHEN l_retrieved = 0;

Line 598: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);

594: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);
595: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
596: --
597: LOOP
598: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);
599: EXIT WHEN l_retrieved = 0;
600: --
601: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_id1);
602: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_value1);

Line 601: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_id1);

597: LOOP
598: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);
599: EXIT WHEN l_retrieved = 0;
600: --
601: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_id1);
602: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_value1);
603: --
604: FOR l_ind1 IN 1..l_id1.COUNT LOOP
605: l_ind := l_ind + 1;

Line 602: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_value1);

598: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);
599: EXIT WHEN l_retrieved = 0;
600: --
601: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_id1);
602: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_value1);
603: --
604: FOR l_ind1 IN 1..l_id1.COUNT LOOP
605: l_ind := l_ind + 1;
606: x_Dim_Level_Value_Tbl(l_ind).Dimension_Level_Value_ID

Line 621: DBMS_SQL.CLOSE_CURSOR(l_cursor);

617: --
618: EXIT WHEN l_retrieved < l_size;
619: END LOOP;
620: --
621: DBMS_SQL.CLOSE_CURSOR(l_cursor);
622: ELSE
623: l_ind := l_ind + 1;
624: x_Dim_Level_Value_Tbl(l_ind).Dimension_Level_Value_ID := '-1';
625: x_Dim_Level_Value_Tbl(l_ind).Dimension_Level_Value_Name := l_name;

Line 635: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

631:
632: --
633: EXCEPTION
634: WHEN NO_DATA_FOUND THEN
635: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
636: DBMS_SQL.CLOSE_CURSOR(l_cursor);
637: END IF;
638: x_return_status := FND_API.G_RET_STS_ERROR;
639: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 636: DBMS_SQL.CLOSE_CURSOR(l_cursor);

632: --
633: EXCEPTION
634: WHEN NO_DATA_FOUND THEN
635: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
636: DBMS_SQL.CLOSE_CURSOR(l_cursor);
637: END IF;
638: x_return_status := FND_API.G_RET_STS_ERROR;
639: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
640: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_DimensionX_Values:NO_DATA_FOUND'); htp.para;

Line 644: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

640: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_DimensionX_Values:NO_DATA_FOUND'); htp.para;
641: END IF;
642: RAISE FND_API.G_EXC_ERROR;
643: WHEN FND_API.G_EXC_ERROR THEN
644: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
645: DBMS_SQL.CLOSE_CURSOR(l_cursor);
646: END IF;
647: x_return_status := FND_API.G_RET_STS_ERROR;
648: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 645: DBMS_SQL.CLOSE_CURSOR(l_cursor);

641: END IF;
642: RAISE FND_API.G_EXC_ERROR;
643: WHEN FND_API.G_EXC_ERROR THEN
644: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
645: DBMS_SQL.CLOSE_CURSOR(l_cursor);
646: END IF;
647: x_return_status := FND_API.G_RET_STS_ERROR;
648: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
649: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_DimensionX_Values:G_EXC_ERROR'); htp.para;

Line 653: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

649: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_DimensionX_Values:G_EXC_ERROR'); htp.para;
650: END IF;
651: RAISE;
652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
653: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
654: DBMS_SQL.CLOSE_CURSOR(l_cursor);
655: END IF;
656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
657: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 654: DBMS_SQL.CLOSE_CURSOR(l_cursor);

650: END IF;
651: RAISE;
652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
653: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
654: DBMS_SQL.CLOSE_CURSOR(l_cursor);
655: END IF;
656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
657: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
658: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_DimensionX_Values:G_EXC_UNEXPECTED_ERROR'); htp.para;

Line 662: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

658: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_DimensionX_Values:G_EXC_UNEXPECTED_ERROR'); htp.para;
659: END IF;
660: RAISE;
661: WHEN OTHERS THEN
662: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
663: DBMS_SQL.CLOSE_CURSOR(l_cursor);
664: END IF;
665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
666: BIS_UTILITIES_PVT.Add_Error_Message

Line 663: DBMS_SQL.CLOSE_CURSOR(l_cursor);

659: END IF;
660: RAISE;
661: WHEN OTHERS THEN
662: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
663: DBMS_SQL.CLOSE_CURSOR(l_cursor);
664: END IF;
665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
666: BIS_UTILITIES_PVT.Add_Error_Message
667: ( p_error_table => x_error_Tbl

Line 702: l_id1 DBMS_SQL.VARCHAR2_TABLE;

698: l_start_date DATE;
699: l_select_stmt VARCHAR2(2000) := NULL;
700: l_sql_result INTEGER := 0;
701: --
702: l_id1 DBMS_SQL.VARCHAR2_TABLE;
703: l_value1 DBMS_SQL.VARCHAR2_TABLE;
704: l_start_date1 DBMS_SQL.DATE_TABLE;
705: l_size NUMBER := 100000;
706: l_retrieved NUMBER;

Line 703: l_value1 DBMS_SQL.VARCHAR2_TABLE;

699: l_select_stmt VARCHAR2(2000) := NULL;
700: l_sql_result INTEGER := 0;
701: --
702: l_id1 DBMS_SQL.VARCHAR2_TABLE;
703: l_value1 DBMS_SQL.VARCHAR2_TABLE;
704: l_start_date1 DBMS_SQL.DATE_TABLE;
705: l_size NUMBER := 100000;
706: l_retrieved NUMBER;
707: l_Org_Dept BOOLEAN;

Line 704: l_start_date1 DBMS_SQL.DATE_TABLE;

700: l_sql_result INTEGER := 0;
701: --
702: l_id1 DBMS_SQL.VARCHAR2_TABLE;
703: l_value1 DBMS_SQL.VARCHAR2_TABLE;
704: l_start_date1 DBMS_SQL.DATE_TABLE;
705: l_size NUMBER := 100000;
706: l_retrieved NUMBER;
707: l_Org_Dept BOOLEAN;
708: --

Line 747: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

743: || ' FROM '
744: || l_view_name
745: || ' ORDER BY START_DATE';
746: END IF;
747: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
748: DBMS_SQL.CLOSE_CURSOR(l_cursor);
749: END IF;
750: l_cursor := DBMS_SQL.OPEN_CURSOR;
751: DBMS_SQL.PARSE( c => l_cursor

Line 748: DBMS_SQL.CLOSE_CURSOR(l_cursor);

744: || l_view_name
745: || ' ORDER BY START_DATE';
746: END IF;
747: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
748: DBMS_SQL.CLOSE_CURSOR(l_cursor);
749: END IF;
750: l_cursor := DBMS_SQL.OPEN_CURSOR;
751: DBMS_SQL.PARSE( c => l_cursor
752: , statement => l_select_stmt

Line 750: l_cursor := DBMS_SQL.OPEN_CURSOR;

746: END IF;
747: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
748: DBMS_SQL.CLOSE_CURSOR(l_cursor);
749: END IF;
750: l_cursor := DBMS_SQL.OPEN_CURSOR;
751: DBMS_SQL.PARSE( c => l_cursor
752: , statement => l_select_stmt
753: , language_flag => DBMS_SQL.NATIVE
754: );

Line 751: DBMS_SQL.PARSE( c => l_cursor

747: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
748: DBMS_SQL.CLOSE_CURSOR(l_cursor);
749: END IF;
750: l_cursor := DBMS_SQL.OPEN_CURSOR;
751: DBMS_SQL.PARSE( c => l_cursor
752: , statement => l_select_stmt
753: , language_flag => DBMS_SQL.NATIVE
754: );
755: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);

Line 753: , language_flag => DBMS_SQL.NATIVE

749: END IF;
750: l_cursor := DBMS_SQL.OPEN_CURSOR;
751: DBMS_SQL.PARSE( c => l_cursor
752: , statement => l_select_stmt
753: , language_flag => DBMS_SQL.NATIVE
754: );
755: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);
756: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);
757: DBMS_SQL.DEFINE_ARRAY(l_cursor, 3, l_start_date1, l_size, 1);

Line 755: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);

751: DBMS_SQL.PARSE( c => l_cursor
752: , statement => l_select_stmt
753: , language_flag => DBMS_SQL.NATIVE
754: );
755: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);
756: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);
757: DBMS_SQL.DEFINE_ARRAY(l_cursor, 3, l_start_date1, l_size, 1);
758: IF(l_Org_Dept) THEN
759: DBMS_SQL.BIND_VARIABLE(l_cursor, ':org_id', p_Dim_Level_Value_Rec.Dimension_Level_Value_ID);

Line 756: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);

752: , statement => l_select_stmt
753: , language_flag => DBMS_SQL.NATIVE
754: );
755: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);
756: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);
757: DBMS_SQL.DEFINE_ARRAY(l_cursor, 3, l_start_date1, l_size, 1);
758: IF(l_Org_Dept) THEN
759: DBMS_SQL.BIND_VARIABLE(l_cursor, ':org_id', p_Dim_Level_Value_Rec.Dimension_Level_Value_ID);
760: DBMS_SQL.BIND_VARIABLE(l_cursor, ':org_type', p_Dim_Level_Value_Rec.Dimension_Level_Short_Name);

Line 757: DBMS_SQL.DEFINE_ARRAY(l_cursor, 3, l_start_date1, l_size, 1);

753: , language_flag => DBMS_SQL.NATIVE
754: );
755: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);
756: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);
757: DBMS_SQL.DEFINE_ARRAY(l_cursor, 3, l_start_date1, l_size, 1);
758: IF(l_Org_Dept) THEN
759: DBMS_SQL.BIND_VARIABLE(l_cursor, ':org_id', p_Dim_Level_Value_Rec.Dimension_Level_Value_ID);
760: DBMS_SQL.BIND_VARIABLE(l_cursor, ':org_type', p_Dim_Level_Value_Rec.Dimension_Level_Short_Name);
761: END IF;

Line 759: DBMS_SQL.BIND_VARIABLE(l_cursor, ':org_id', p_Dim_Level_Value_Rec.Dimension_Level_Value_ID);

755: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_id1, l_size, 1);
756: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);
757: DBMS_SQL.DEFINE_ARRAY(l_cursor, 3, l_start_date1, l_size, 1);
758: IF(l_Org_Dept) THEN
759: DBMS_SQL.BIND_VARIABLE(l_cursor, ':org_id', p_Dim_Level_Value_Rec.Dimension_Level_Value_ID);
760: DBMS_SQL.BIND_VARIABLE(l_cursor, ':org_type', p_Dim_Level_Value_Rec.Dimension_Level_Short_Name);
761: END IF;
762: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
763: --

Line 760: DBMS_SQL.BIND_VARIABLE(l_cursor, ':org_type', p_Dim_Level_Value_Rec.Dimension_Level_Short_Name);

756: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_value1, l_size, 1);
757: DBMS_SQL.DEFINE_ARRAY(l_cursor, 3, l_start_date1, l_size, 1);
758: IF(l_Org_Dept) THEN
759: DBMS_SQL.BIND_VARIABLE(l_cursor, ':org_id', p_Dim_Level_Value_Rec.Dimension_Level_Value_ID);
760: DBMS_SQL.BIND_VARIABLE(l_cursor, ':org_type', p_Dim_Level_Value_Rec.Dimension_Level_Short_Name);
761: END IF;
762: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
763: --
764: LOOP

Line 762: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);

758: IF(l_Org_Dept) THEN
759: DBMS_SQL.BIND_VARIABLE(l_cursor, ':org_id', p_Dim_Level_Value_Rec.Dimension_Level_Value_ID);
760: DBMS_SQL.BIND_VARIABLE(l_cursor, ':org_type', p_Dim_Level_Value_Rec.Dimension_Level_Short_Name);
761: END IF;
762: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
763: --
764: LOOP
765: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);
766: EXIT WHEN l_retrieved = 0;

Line 765: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);

761: END IF;
762: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
763: --
764: LOOP
765: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);
766: EXIT WHEN l_retrieved = 0;
767: --
768: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_id1);
769: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_value1);

Line 768: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_id1);

764: LOOP
765: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);
766: EXIT WHEN l_retrieved = 0;
767: --
768: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_id1);
769: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_value1);
770: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_start_date1);
771: --
772: FOR l_ind1 IN 1..l_id1.COUNT LOOP

Line 769: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_value1);

765: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);
766: EXIT WHEN l_retrieved = 0;
767: --
768: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_id1);
769: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_value1);
770: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_start_date1);
771: --
772: FOR l_ind1 IN 1..l_id1.COUNT LOOP
773: l_ind := l_ind + 1;

Line 770: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_start_date1);

766: EXIT WHEN l_retrieved = 0;
767: --
768: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_id1);
769: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_value1);
770: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_start_date1);
771: --
772: FOR l_ind1 IN 1..l_id1.COUNT LOOP
773: l_ind := l_ind + 1;
774: x_Dim_Level_Value_Tbl(l_ind).Dimension_Level_Value_ID

Line 789: DBMS_SQL.CLOSE_CURSOR(l_cursor);

785: --
786: EXIT WHEN l_retrieved < l_size;
787: END LOOP;
788: --
789: DBMS_SQL.CLOSE_CURSOR(l_cursor);
790: ELSE
791: l_ind := l_ind + 1;
792: x_Dim_Level_Value_Tbl(l_ind).Dimension_Level_Value_ID := '-1';
793: x_Dim_Level_Value_Tbl(l_ind).Dimension_Level_Value_Name := l_name;

Line 802: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

798: END IF;
799: --
800: EXCEPTION
801: WHEN NO_DATA_FOUND THEN
802: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
803: DBMS_SQL.CLOSE_CURSOR(l_cursor);
804: END IF;
805: x_return_status := FND_API.G_RET_STS_ERROR;
806: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 803: DBMS_SQL.CLOSE_CURSOR(l_cursor);

799: --
800: EXCEPTION
801: WHEN NO_DATA_FOUND THEN
802: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
803: DBMS_SQL.CLOSE_CURSOR(l_cursor);
804: END IF;
805: x_return_status := FND_API.G_RET_STS_ERROR;
806: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
807: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Time_Dim_Values:NO_DATA_FOUND'); htp.para;

Line 811: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

807: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Time_Dim_Values:NO_DATA_FOUND'); htp.para;
808: END IF;
809: RAISE FND_API.G_EXC_ERROR;
810: WHEN FND_API.G_EXC_ERROR THEN
811: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
812: DBMS_SQL.CLOSE_CURSOR(l_cursor);
813: END IF;
814: x_return_status := FND_API.G_RET_STS_ERROR;
815: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 812: DBMS_SQL.CLOSE_CURSOR(l_cursor);

808: END IF;
809: RAISE FND_API.G_EXC_ERROR;
810: WHEN FND_API.G_EXC_ERROR THEN
811: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
812: DBMS_SQL.CLOSE_CURSOR(l_cursor);
813: END IF;
814: x_return_status := FND_API.G_RET_STS_ERROR;
815: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
816: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Time_Dim_Values:G_EXC_ERROR'); htp.para;

Line 820: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

816: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Time_Dim_Values:G_EXC_ERROR'); htp.para;
817: END IF;
818: RAISE;
819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
820: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
821: DBMS_SQL.CLOSE_CURSOR(l_cursor);
822: END IF;
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
824: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 821: DBMS_SQL.CLOSE_CURSOR(l_cursor);

817: END IF;
818: RAISE;
819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
820: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
821: DBMS_SQL.CLOSE_CURSOR(l_cursor);
822: END IF;
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
824: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
825: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Time_Dim_Values:G_EXC_UNEXPECTED_ERROR'); htp.para;

Line 829: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

825: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Time_Dim_Values:G_EXC_UNEXPECTED_ERROR'); htp.para;
826: END IF;
827: RAISE;
828: WHEN OTHERS THEN
829: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
830: DBMS_SQL.CLOSE_CURSOR(l_cursor);
831: END IF;
832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
833: BIS_UTILITIES_PVT.Add_Error_Message

Line 830: DBMS_SQL.CLOSE_CURSOR(l_cursor);

826: END IF;
827: RAISE;
828: WHEN OTHERS THEN
829: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
830: DBMS_SQL.CLOSE_CURSOR(l_cursor);
831: END IF;
832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
833: BIS_UTILITIES_PVT.Add_Error_Message
834: ( p_error_table => x_error_Tbl

Line 939: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

935: FROM BISBV_DIMENSION_LEVELS
936: WHERE DIMENSION_LEVEL_ID = p_Dimension_Level_Rec.Dimension_Level_ID;
937: --
938: --
939: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
940: DBMS_SQL.CLOSE_CURSOR(l_cursor);
941: END IF;
942: l_cursor := DBMS_SQL.OPEN_CURSOR;
943: --

Line 940: DBMS_SQL.CLOSE_CURSOR(l_cursor);

936: WHERE DIMENSION_LEVEL_ID = p_Dimension_Level_Rec.Dimension_Level_ID;
937: --
938: --
939: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
940: DBMS_SQL.CLOSE_CURSOR(l_cursor);
941: END IF;
942: l_cursor := DBMS_SQL.OPEN_CURSOR;
943: --
944: l_select_stmt := 'SELECT DISTINCT '

Line 942: l_cursor := DBMS_SQL.OPEN_CURSOR;

938: --
939: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
940: DBMS_SQL.CLOSE_CURSOR(l_cursor);
941: END IF;
942: l_cursor := DBMS_SQL.OPEN_CURSOR;
943: --
944: l_select_stmt := 'SELECT DISTINCT '
945: || ' START_DATE '
946: || ' FROM '

Line 951: DBMS_SQL.PARSE( c => l_cursor

947: || l_view_name
948: || ' WHERE '
949: || ' ID = :p_start_period ';
950: --
951: DBMS_SQL.PARSE( c => l_cursor
952: , statement => l_select_stmt
953: , language_flag => DBMS_SQL.NATIVE
954: );
955: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_start_date);

Line 953: , language_flag => DBMS_SQL.NATIVE

949: || ' ID = :p_start_period ';
950: --
951: DBMS_SQL.PARSE( c => l_cursor
952: , statement => l_select_stmt
953: , language_flag => DBMS_SQL.NATIVE
954: );
955: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_start_date);
956: DBMS_SQL.BIND_VARIABLE(l_cursor, ':p_start_period', p_start_period);
957: l_sql_result := DBMS_SQL.EXECUTE_AND_FETCH(l_cursor, TRUE);

Line 955: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_start_date);

951: DBMS_SQL.PARSE( c => l_cursor
952: , statement => l_select_stmt
953: , language_flag => DBMS_SQL.NATIVE
954: );
955: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_start_date);
956: DBMS_SQL.BIND_VARIABLE(l_cursor, ':p_start_period', p_start_period);
957: l_sql_result := DBMS_SQL.EXECUTE_AND_FETCH(l_cursor, TRUE);
958: --
959: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_start_date);

Line 956: DBMS_SQL.BIND_VARIABLE(l_cursor, ':p_start_period', p_start_period);

952: , statement => l_select_stmt
953: , language_flag => DBMS_SQL.NATIVE
954: );
955: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_start_date);
956: DBMS_SQL.BIND_VARIABLE(l_cursor, ':p_start_period', p_start_period);
957: l_sql_result := DBMS_SQL.EXECUTE_AND_FETCH(l_cursor, TRUE);
958: --
959: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_start_date);
960: --

Line 957: l_sql_result := DBMS_SQL.EXECUTE_AND_FETCH(l_cursor, TRUE);

953: , language_flag => DBMS_SQL.NATIVE
954: );
955: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_start_date);
956: DBMS_SQL.BIND_VARIABLE(l_cursor, ':p_start_period', p_start_period);
957: l_sql_result := DBMS_SQL.EXECUTE_AND_FETCH(l_cursor, TRUE);
958: --
959: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_start_date);
960: --
961: DBMS_SQL.CLOSE_CURSOR(l_cursor);

Line 959: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_start_date);

955: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_start_date);
956: DBMS_SQL.BIND_VARIABLE(l_cursor, ':p_start_period', p_start_period);
957: l_sql_result := DBMS_SQL.EXECUTE_AND_FETCH(l_cursor, TRUE);
958: --
959: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_start_date);
960: --
961: DBMS_SQL.CLOSE_CURSOR(l_cursor);
962: --
963: x_start_date := l_start_date;

Line 961: DBMS_SQL.CLOSE_CURSOR(l_cursor);

957: l_sql_result := DBMS_SQL.EXECUTE_AND_FETCH(l_cursor, TRUE);
958: --
959: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_start_date);
960: --
961: DBMS_SQL.CLOSE_CURSOR(l_cursor);
962: --
963: x_start_date := l_start_date;
964: --
965: EXCEPTION

Line 967: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

963: x_start_date := l_start_date;
964: --
965: EXCEPTION
966: WHEN NO_DATA_FOUND THEN
967: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
968: DBMS_SQL.CLOSE_CURSOR(l_cursor);
969: END IF;
970: x_return_status := FND_API.G_RET_STS_ERROR;
971: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 968: DBMS_SQL.CLOSE_CURSOR(l_cursor);

964: --
965: EXCEPTION
966: WHEN NO_DATA_FOUND THEN
967: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
968: DBMS_SQL.CLOSE_CURSOR(l_cursor);
969: END IF;
970: x_return_status := FND_API.G_RET_STS_ERROR;
971: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
972: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Start_Date:NO_DATA_FOUND'); htp.para;

Line 976: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

972: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Start_Date:NO_DATA_FOUND'); htp.para;
973: END IF;
974: RAISE FND_API.G_EXC_ERROR;
975: WHEN FND_API.G_EXC_ERROR THEN
976: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
977: DBMS_SQL.CLOSE_CURSOR(l_cursor);
978: END IF;
979: x_return_status := FND_API.G_RET_STS_ERROR;
980: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 977: DBMS_SQL.CLOSE_CURSOR(l_cursor);

973: END IF;
974: RAISE FND_API.G_EXC_ERROR;
975: WHEN FND_API.G_EXC_ERROR THEN
976: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
977: DBMS_SQL.CLOSE_CURSOR(l_cursor);
978: END IF;
979: x_return_status := FND_API.G_RET_STS_ERROR;
980: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
981: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Start_Date:G_EXC_ERROR'); htp.para;

Line 985: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

981: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Start_Date:G_EXC_ERROR'); htp.para;
982: END IF;
983: RAISE;
984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
985: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
986: DBMS_SQL.CLOSE_CURSOR(l_cursor);
987: END IF;
988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
989: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 986: DBMS_SQL.CLOSE_CURSOR(l_cursor);

982: END IF;
983: RAISE;
984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
985: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
986: DBMS_SQL.CLOSE_CURSOR(l_cursor);
987: END IF;
988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
989: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
990: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Start_Date:G_EXC_UNEXPECTED_ERROR'); htp.para;

Line 994: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

990: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Start_Date:G_EXC_UNEXPECTED_ERROR'); htp.para;
991: END IF;
992: RAISE;
993: WHEN OTHERS THEN
994: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
995: DBMS_SQL.CLOSE_CURSOR(l_cursor);
996: END IF;
997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
998: BIS_UTILITIES_PVT.Add_Error_Message

Line 995: DBMS_SQL.CLOSE_CURSOR(l_cursor);

991: END IF;
992: RAISE;
993: WHEN OTHERS THEN
994: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
995: DBMS_SQL.CLOSE_CURSOR(l_cursor);
996: END IF;
997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
998: BIS_UTILITIES_PVT.Add_Error_Message
999: ( p_error_table => x_error_Tbl

Line 1043: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

1039: FROM BISBV_DIMENSION_LEVELS
1040: WHERE DIMENSION_LEVEL_ID = p_Dimension_Level_Rec.Dimension_Level_ID;
1041: --
1042: --
1043: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
1044: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1045: END IF;
1046: l_cursor := DBMS_SQL.OPEN_CURSOR;
1047: --

Line 1044: DBMS_SQL.CLOSE_CURSOR(l_cursor);

1040: WHERE DIMENSION_LEVEL_ID = p_Dimension_Level_Rec.Dimension_Level_ID;
1041: --
1042: --
1043: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
1044: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1045: END IF;
1046: l_cursor := DBMS_SQL.OPEN_CURSOR;
1047: --
1048: l_select_stmt := 'SELECT DISTINCT '

Line 1046: l_cursor := DBMS_SQL.OPEN_CURSOR;

1042: --
1043: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
1044: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1045: END IF;
1046: l_cursor := DBMS_SQL.OPEN_CURSOR;
1047: --
1048: l_select_stmt := 'SELECT DISTINCT '
1049: || ' END_DATE '
1050: || ' FROM '

Line 1055: DBMS_SQL.PARSE( c => l_cursor

1051: || l_view_name
1052: || ' WHERE '
1053: || ' ID = :p_end_period ';
1054: --
1055: DBMS_SQL.PARSE( c => l_cursor
1056: , statement => l_select_stmt
1057: , language_flag => DBMS_SQL.NATIVE
1058: );
1059: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_end_date);

Line 1057: , language_flag => DBMS_SQL.NATIVE

1053: || ' ID = :p_end_period ';
1054: --
1055: DBMS_SQL.PARSE( c => l_cursor
1056: , statement => l_select_stmt
1057: , language_flag => DBMS_SQL.NATIVE
1058: );
1059: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_end_date);
1060: DBMS_SQL.BIND_VARIABLE(l_cursor, ':p_end_period', p_end_period);
1061: l_sql_result := DBMS_SQL.EXECUTE_AND_FETCH(l_cursor, TRUE);

Line 1059: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_end_date);

1055: DBMS_SQL.PARSE( c => l_cursor
1056: , statement => l_select_stmt
1057: , language_flag => DBMS_SQL.NATIVE
1058: );
1059: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_end_date);
1060: DBMS_SQL.BIND_VARIABLE(l_cursor, ':p_end_period', p_end_period);
1061: l_sql_result := DBMS_SQL.EXECUTE_AND_FETCH(l_cursor, TRUE);
1062: --
1063: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_end_date);

Line 1060: DBMS_SQL.BIND_VARIABLE(l_cursor, ':p_end_period', p_end_period);

1056: , statement => l_select_stmt
1057: , language_flag => DBMS_SQL.NATIVE
1058: );
1059: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_end_date);
1060: DBMS_SQL.BIND_VARIABLE(l_cursor, ':p_end_period', p_end_period);
1061: l_sql_result := DBMS_SQL.EXECUTE_AND_FETCH(l_cursor, TRUE);
1062: --
1063: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_end_date);
1064: --

Line 1061: l_sql_result := DBMS_SQL.EXECUTE_AND_FETCH(l_cursor, TRUE);

1057: , language_flag => DBMS_SQL.NATIVE
1058: );
1059: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_end_date);
1060: DBMS_SQL.BIND_VARIABLE(l_cursor, ':p_end_period', p_end_period);
1061: l_sql_result := DBMS_SQL.EXECUTE_AND_FETCH(l_cursor, TRUE);
1062: --
1063: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_end_date);
1064: --
1065: DBMS_SQL.CLOSE_CURSOR(l_cursor);

Line 1063: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_end_date);

1059: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_end_date);
1060: DBMS_SQL.BIND_VARIABLE(l_cursor, ':p_end_period', p_end_period);
1061: l_sql_result := DBMS_SQL.EXECUTE_AND_FETCH(l_cursor, TRUE);
1062: --
1063: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_end_date);
1064: --
1065: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1066: --
1067: x_end_date := l_end_date;

Line 1065: DBMS_SQL.CLOSE_CURSOR(l_cursor);

1061: l_sql_result := DBMS_SQL.EXECUTE_AND_FETCH(l_cursor, TRUE);
1062: --
1063: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_end_date);
1064: --
1065: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1066: --
1067: x_end_date := l_end_date;
1068: --
1069: EXCEPTION

Line 1071: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

1067: x_end_date := l_end_date;
1068: --
1069: EXCEPTION
1070: WHEN NO_DATA_FOUND THEN
1071: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
1072: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1073: END IF;
1074: x_return_status := FND_API.G_RET_STS_ERROR;
1075: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 1072: DBMS_SQL.CLOSE_CURSOR(l_cursor);

1068: --
1069: EXCEPTION
1070: WHEN NO_DATA_FOUND THEN
1071: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
1072: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1073: END IF;
1074: x_return_status := FND_API.G_RET_STS_ERROR;
1075: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1076: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_End_Date:NO_DATA_FOUND'); htp.para;

Line 1080: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

1076: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_End_Date:NO_DATA_FOUND'); htp.para;
1077: END IF;
1078: RAISE FND_API.G_EXC_ERROR;
1079: WHEN FND_API.G_EXC_ERROR THEN
1080: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
1081: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1082: END IF;
1083: x_return_status := FND_API.G_RET_STS_ERROR;
1084: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 1081: DBMS_SQL.CLOSE_CURSOR(l_cursor);

1077: END IF;
1078: RAISE FND_API.G_EXC_ERROR;
1079: WHEN FND_API.G_EXC_ERROR THEN
1080: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
1081: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1082: END IF;
1083: x_return_status := FND_API.G_RET_STS_ERROR;
1084: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1085: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_End_Date:G_EXC_ERROR'); htp.para;

Line 1089: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

1085: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_End_Date:G_EXC_ERROR'); htp.para;
1086: END IF;
1087: RAISE;
1088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1089: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
1090: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1091: END IF;
1092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1093: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

Line 1090: DBMS_SQL.CLOSE_CURSOR(l_cursor);

1086: END IF;
1087: RAISE;
1088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1089: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
1090: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1091: END IF;
1092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1093: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1094: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_End_Date:G_EXC_UNEXPECTED_ERROR'); htp.para;

Line 1098: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

1094: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_End_Date:G_EXC_UNEXPECTED_ERROR'); htp.para;
1095: END IF;
1096: RAISE;
1097: WHEN OTHERS THEN
1098: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
1099: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1100: END IF;
1101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1102: BIS_UTILITIES_PVT.Add_Error_Message

Line 1099: DBMS_SQL.CLOSE_CURSOR(l_cursor);

1095: END IF;
1096: RAISE;
1097: WHEN OTHERS THEN
1098: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
1099: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1100: END IF;
1101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1102: BIS_UTILITIES_PVT.Add_Error_Message
1103: ( p_error_table => x_error_Tbl