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

Line 154: l_sqlcursor := DBMS_SQL.OPEN_CURSOR;

150: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
151: IEX_DEBUG_PUB.logMessage('result: ' || l_str_result);
152: END IF;
153:
154: l_sqlcursor := DBMS_SQL.OPEN_CURSOR;
155: BEGIN
156: DBMS_SQL.PARSE(l_sqlcursor, l_str_result, 1);
157: -- DBMS_SQL.BIND_VARIABLE_CHAR(l_sqlcursor,'l_result', '0', 2000); -- bug 5695898 by ehuh 3/2/07
158: DBMS_SQL.BIND_VARIABLE_CHAR(l_sqlcursor,'l_result', '0', 1000); -- bug 5695898 by ehuh 3/2/07

Line 156: DBMS_SQL.PARSE(l_sqlcursor, l_str_result, 1);

152: END IF;
153:
154: l_sqlcursor := DBMS_SQL.OPEN_CURSOR;
155: BEGIN
156: DBMS_SQL.PARSE(l_sqlcursor, l_str_result, 1);
157: -- DBMS_SQL.BIND_VARIABLE_CHAR(l_sqlcursor,'l_result', '0', 2000); -- bug 5695898 by ehuh 3/2/07
158: DBMS_SQL.BIND_VARIABLE_CHAR(l_sqlcursor,'l_result', '0', 1000); -- bug 5695898 by ehuh 3/2/07
159: --DBMS_SQL.DEFINE_COLUMN(l_sqlcursor, 1, l_count);
160:

Line 157: -- DBMS_SQL.BIND_VARIABLE_CHAR(l_sqlcursor,'l_result', '0', 2000); -- bug 5695898 by ehuh 3/2/07

153:
154: l_sqlcursor := DBMS_SQL.OPEN_CURSOR;
155: BEGIN
156: DBMS_SQL.PARSE(l_sqlcursor, l_str_result, 1);
157: -- DBMS_SQL.BIND_VARIABLE_CHAR(l_sqlcursor,'l_result', '0', 2000); -- bug 5695898 by ehuh 3/2/07
158: DBMS_SQL.BIND_VARIABLE_CHAR(l_sqlcursor,'l_result', '0', 1000); -- bug 5695898 by ehuh 3/2/07
159: --DBMS_SQL.DEFINE_COLUMN(l_sqlcursor, 1, l_count);
160:
161: IF p_party_id > 0 THEN

Line 158: DBMS_SQL.BIND_VARIABLE_CHAR(l_sqlcursor,'l_result', '0', 1000); -- bug 5695898 by ehuh 3/2/07

154: l_sqlcursor := DBMS_SQL.OPEN_CURSOR;
155: BEGIN
156: DBMS_SQL.PARSE(l_sqlcursor, l_str_result, 1);
157: -- DBMS_SQL.BIND_VARIABLE_CHAR(l_sqlcursor,'l_result', '0', 2000); -- bug 5695898 by ehuh 3/2/07
158: DBMS_SQL.BIND_VARIABLE_CHAR(l_sqlcursor,'l_result', '0', 1000); -- bug 5695898 by ehuh 3/2/07
159: --DBMS_SQL.DEFINE_COLUMN(l_sqlcursor, 1, l_count);
160:
161: IF p_party_id > 0 THEN
162:

Line 159: --DBMS_SQL.DEFINE_COLUMN(l_sqlcursor, 1, l_count);

155: BEGIN
156: DBMS_SQL.PARSE(l_sqlcursor, l_str_result, 1);
157: -- DBMS_SQL.BIND_VARIABLE_CHAR(l_sqlcursor,'l_result', '0', 2000); -- bug 5695898 by ehuh 3/2/07
158: DBMS_SQL.BIND_VARIABLE_CHAR(l_sqlcursor,'l_result', '0', 1000); -- bug 5695898 by ehuh 3/2/07
159: --DBMS_SQL.DEFINE_COLUMN(l_sqlcursor, 1, l_count);
160:
161: IF p_party_id > 0 THEN
162:
163: FOR i IN 1..l_party_count LOOP

Line 164: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_PARTY_ID_'||i, p_party_id);

160:
161: IF p_party_id > 0 THEN
162:
163: FOR i IN 1..l_party_count LOOP
164: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_PARTY_ID_'||i, p_party_id);
165: END LOOP;
166: END IF;
167:
168: IF p_cust_account_id > 0 THEN

Line 171: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_CUST_ACCOUNT_ID_'||i, p_cust_account_id);

167:
168: IF p_cust_account_id > 0 THEN
169:
170: FOR i IN 1..l_acc_count LOOP
171: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_CUST_ACCOUNT_ID_'||i, p_cust_account_id);
172: END LOOP;
173: END IF;
174:
175: IF p_customer_site_use_id > 0 THEN

Line 178: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_CUSTOMER_SITE_USE_ID_'||i, p_customer_site_use_id);

174:
175: IF p_customer_site_use_id > 0 THEN
176:
177: FOR i IN 1..l_billto_count LOOP
178: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_CUSTOMER_SITE_USE_ID_'||i, p_customer_site_use_id);
179: END LOOP;
180: END IF;
181:
182: IF p_delinquency_id > 0 THEN

Line 185: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_DELINQUENCY_ID_'||i, p_delinquency_id);

181:
182: IF p_delinquency_id > 0 THEN
183:
184: FOR i IN 1..p_del_count LOOP
185: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_DELINQUENCY_ID_'||i, p_delinquency_id);
186: END LOOP;
187: END IF;
188:
189:

Line 193: l_dummy := DBMS_SQL.EXECUTE(l_sqlcursor);

189:
190:
191:
192:
193: l_dummy := DBMS_SQL.EXECUTE(l_sqlcursor);
194:
195: DBMS_SQL.VARIABLE_VALUE_CHAR(l_sqlcursor, 'l_result', l_value);
196: x_metric_value_tbl(l_current_row) := RTRIM(l_value, ' ');
197:

Line 195: DBMS_SQL.VARIABLE_VALUE_CHAR(l_sqlcursor, 'l_result', l_value);

191:
192:
193: l_dummy := DBMS_SQL.EXECUTE(l_sqlcursor);
194:
195: DBMS_SQL.VARIABLE_VALUE_CHAR(l_sqlcursor, 'l_result', l_value);
196: x_metric_value_tbl(l_current_row) := RTRIM(l_value, ' ');
197:
198: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
199: IEX_DEBUG_PUB.logMessage('Metrics value: ' || x_metric_value_tbl(l_current_row));

Line 208: DBMS_SQL.CLOSE_CURSOR(l_sqlcursor);

204: l_current_status := 'E';
205: x_metric_value_tbl(l_current_row) := 'NA';
206:
207: END;
208: DBMS_SQL.CLOSE_CURSOR(l_sqlcursor);
209: ELSE
210: LOOP
211: l_start := NVL(INSTRB(l_str,':',1,1),0);
212: IF l_start > 0 THEN

Line 241: l_sqlcursor := DBMS_SQL.OPEN_CURSOR;

237:
238: EXIT WHEN l_start < 1;
239: END LOOP;
240:
241: l_sqlcursor := DBMS_SQL.OPEN_CURSOR;
242:
243: BEGIN
244: DBMS_SQL.PARSE(l_sqlcursor, l_str_result, 1);
245: DBMS_SQL.DEFINE_COLUMN(l_sqlcursor, 1, l_value, 200);

Line 244: DBMS_SQL.PARSE(l_sqlcursor, l_str_result, 1);

240:
241: l_sqlcursor := DBMS_SQL.OPEN_CURSOR;
242:
243: BEGIN
244: DBMS_SQL.PARSE(l_sqlcursor, l_str_result, 1);
245: DBMS_SQL.DEFINE_COLUMN(l_sqlcursor, 1, l_value, 200);
246:
247: IF p_party_id > 0 THEN
248: FOR i IN 1..l_party_count LOOP

Line 245: DBMS_SQL.DEFINE_COLUMN(l_sqlcursor, 1, l_value, 200);

241: l_sqlcursor := DBMS_SQL.OPEN_CURSOR;
242:
243: BEGIN
244: DBMS_SQL.PARSE(l_sqlcursor, l_str_result, 1);
245: DBMS_SQL.DEFINE_COLUMN(l_sqlcursor, 1, l_value, 200);
246:
247: IF p_party_id > 0 THEN
248: FOR i IN 1..l_party_count LOOP
249: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_PARTY_ID_'||i, p_party_id);

Line 249: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_PARTY_ID_'||i, p_party_id);

245: DBMS_SQL.DEFINE_COLUMN(l_sqlcursor, 1, l_value, 200);
246:
247: IF p_party_id > 0 THEN
248: FOR i IN 1..l_party_count LOOP
249: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_PARTY_ID_'||i, p_party_id);
250: END LOOP;
251: END IF;
252:
253: IF p_cust_account_id > 0 THEN

Line 255: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_CUST_ACCOUNT_ID_'||i, p_cust_account_id);

251: END IF;
252:
253: IF p_cust_account_id > 0 THEN
254: FOR i IN 1..l_acc_count LOOP
255: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_CUST_ACCOUNT_ID_'||i, p_cust_account_id);
256: END LOOP;
257: END IF;
258:
259: IF p_customer_site_use_id > 0 THEN

Line 261: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_CUSTOMER_SITE_USE_ID_'||i, p_customer_site_use_id);

257: END IF;
258:
259: IF p_customer_site_use_id > 0 THEN
260: FOR i IN 1..l_billto_count LOOP
261: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_CUSTOMER_SITE_USE_ID_'||i, p_customer_site_use_id);
262: END LOOP;
263: END IF;
264:
265: IF p_delinquency_id > 0 THEN

Line 267: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_DELINQUENCY_ID_'||i, p_delinquency_id);

263: END IF;
264:
265: IF p_delinquency_id > 0 THEN
266: FOR i IN 1..p_del_count LOOP
267: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_DELINQUENCY_ID_'||i, p_delinquency_id);
268: END LOOP;
269: END IF;
270:
271: l_dummy := DBMS_SQL.EXECUTE(l_sqlcursor);

Line 271: l_dummy := DBMS_SQL.EXECUTE(l_sqlcursor);

267: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_DELINQUENCY_ID_'||i, p_delinquency_id);
268: END LOOP;
269: END IF;
270:
271: l_dummy := DBMS_SQL.EXECUTE(l_sqlcursor);
272:
273: IF DBMS_SQL.FETCH_ROWS(l_sqlcursor) > 0 THEN
274: DBMS_SQL.COLUMN_VALUE(l_sqlcursor,1,l_value);
275: END IF;

Line 273: IF DBMS_SQL.FETCH_ROWS(l_sqlcursor) > 0 THEN

269: END IF;
270:
271: l_dummy := DBMS_SQL.EXECUTE(l_sqlcursor);
272:
273: IF DBMS_SQL.FETCH_ROWS(l_sqlcursor) > 0 THEN
274: DBMS_SQL.COLUMN_VALUE(l_sqlcursor,1,l_value);
275: END IF;
276:
277: x_metric_value_tbl(l_current_row) := l_value;

Line 274: DBMS_SQL.COLUMN_VALUE(l_sqlcursor,1,l_value);

270:
271: l_dummy := DBMS_SQL.EXECUTE(l_sqlcursor);
272:
273: IF DBMS_SQL.FETCH_ROWS(l_sqlcursor) > 0 THEN
274: DBMS_SQL.COLUMN_VALUE(l_sqlcursor,1,l_value);
275: END IF;
276:
277: x_metric_value_tbl(l_current_row) := l_value;
278:

Line 289: DBMS_SQL.CLOSE_CURSOR(l_sqlcursor);

285: l_current_status := 'E';
286: x_metric_value_tbl(l_current_row) := 'NA';
287:
288: END;
289: DBMS_SQL.CLOSE_CURSOR(l_sqlcursor);
290: END IF;
291:
292: IF (l_current_status = 'S') AND (x_metric_value_tbl(l_current_row) <> 'NA') THEN
293: --BEGIN-FIX BUG#4375831-05/18/2005-JYPARK-fix error ORA-06521 because x_metric_value_tbl has charater value so convert to numeric value

Line 438: l_sqlcursor := DBMS_SQL.OPEN_CURSOR;

434: EXIT WHEN l_start < 1;
435: END LOOP;
436: l_str_result := 'BEGIN :l_result := ' || l_str_result;
437:
438: l_sqlcursor := DBMS_SQL.OPEN_CURSOR;
439: BEGIN
440: DBMS_SQL.PARSE(l_sqlcursor, l_str_result, 1);
441: -- Changed value from 2000 to 1000 by nkanchan for bug # 8848670
442: DBMS_SQL.BIND_VARIABLE_CHAR(l_sqlcursor,'l_result', '0', 1000);

Line 440: DBMS_SQL.PARSE(l_sqlcursor, l_str_result, 1);

436: l_str_result := 'BEGIN :l_result := ' || l_str_result;
437:
438: l_sqlcursor := DBMS_SQL.OPEN_CURSOR;
439: BEGIN
440: DBMS_SQL.PARSE(l_sqlcursor, l_str_result, 1);
441: -- Changed value from 2000 to 1000 by nkanchan for bug # 8848670
442: DBMS_SQL.BIND_VARIABLE_CHAR(l_sqlcursor,'l_result', '0', 1000);
443: --DBMS_SQL.DEFINE_COLUMN(l_sqlcursor, 1, l_count);
444:

Line 442: DBMS_SQL.BIND_VARIABLE_CHAR(l_sqlcursor,'l_result', '0', 1000);

438: l_sqlcursor := DBMS_SQL.OPEN_CURSOR;
439: BEGIN
440: DBMS_SQL.PARSE(l_sqlcursor, l_str_result, 1);
441: -- Changed value from 2000 to 1000 by nkanchan for bug # 8848670
442: DBMS_SQL.BIND_VARIABLE_CHAR(l_sqlcursor,'l_result', '0', 1000);
443: --DBMS_SQL.DEFINE_COLUMN(l_sqlcursor, 1, l_count);
444:
445: FOR i IN 1..l_party_count LOOP
446: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_PARTY_ID_'||i, p_filter_id);

Line 443: --DBMS_SQL.DEFINE_COLUMN(l_sqlcursor, 1, l_count);

439: BEGIN
440: DBMS_SQL.PARSE(l_sqlcursor, l_str_result, 1);
441: -- Changed value from 2000 to 1000 by nkanchan for bug # 8848670
442: DBMS_SQL.BIND_VARIABLE_CHAR(l_sqlcursor,'l_result', '0', 1000);
443: --DBMS_SQL.DEFINE_COLUMN(l_sqlcursor, 1, l_count);
444:
445: FOR i IN 1..l_party_count LOOP
446: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_PARTY_ID_'||i, p_filter_id);
447: END LOOP;

Line 446: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_PARTY_ID_'||i, p_filter_id);

442: DBMS_SQL.BIND_VARIABLE_CHAR(l_sqlcursor,'l_result', '0', 1000);
443: --DBMS_SQL.DEFINE_COLUMN(l_sqlcursor, 1, l_count);
444:
445: FOR i IN 1..l_party_count LOOP
446: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_PARTY_ID_'||i, p_filter_id);
447: END LOOP;
448:
449: FOR i IN 1..l_acc_count LOOP
450: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_CUST_ACCOUNT_ID_'||i, p_filter_id);

Line 450: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_CUST_ACCOUNT_ID_'||i, p_filter_id);

446: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_PARTY_ID_'||i, p_filter_id);
447: END LOOP;
448:
449: FOR i IN 1..l_acc_count LOOP
450: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_CUST_ACCOUNT_ID_'||i, p_filter_id);
451: END LOOP;
452:
453: FOR i IN 1..l_billto_count LOOP
454: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_CUSTOMER_SITE_USE_ID_'||i, p_filter_id);

Line 454: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_CUSTOMER_SITE_USE_ID_'||i, p_filter_id);

450: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_CUST_ACCOUNT_ID_'||i, p_filter_id);
451: END LOOP;
452:
453: FOR i IN 1..l_billto_count LOOP
454: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_CUSTOMER_SITE_USE_ID_'||i, p_filter_id);
455: END LOOP;
456:
457: FOR i IN 1..p_del_count LOOP
458: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_DELINQUENCY_ID_'||i, p_filter_id);

Line 458: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_DELINQUENCY_ID_'||i, p_filter_id);

454: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_CUSTOMER_SITE_USE_ID_'||i, p_filter_id);
455: END LOOP;
456:
457: FOR i IN 1..p_del_count LOOP
458: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_DELINQUENCY_ID_'||i, p_filter_id);
459: END LOOP;
460:
461: l_dummy := DBMS_SQL.EXECUTE(l_sqlcursor);
462:

Line 461: l_dummy := DBMS_SQL.EXECUTE(l_sqlcursor);

457: FOR i IN 1..p_del_count LOOP
458: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_DELINQUENCY_ID_'||i, p_filter_id);
459: END LOOP;
460:
461: l_dummy := DBMS_SQL.EXECUTE(l_sqlcursor);
462:
463: DBMS_SQL.VARIABLE_VALUE_CHAR(l_sqlcursor, 'l_result', l_value);
464: x_metric_value := RTRIM(l_value, ' ');
465:

Line 463: DBMS_SQL.VARIABLE_VALUE_CHAR(l_sqlcursor, 'l_result', l_value);

459: END LOOP;
460:
461: l_dummy := DBMS_SQL.EXECUTE(l_sqlcursor);
462:
463: DBMS_SQL.VARIABLE_VALUE_CHAR(l_sqlcursor, 'l_result', l_value);
464: x_metric_value := RTRIM(l_value, ' ');
465:
466:
467: EXCEPTION

Line 475: DBMS_SQL.CLOSE_CURSOR(l_sqlcursor);

471: fnd_message.set_name ('IEX', 'JTF_CHK_UNKNOWN_ERROR');
472: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
473: fnd_msg_pub.add;
474: END;
475: DBMS_SQL.CLOSE_CURSOR(l_sqlcursor);
476: ELSE
477: LOOP
478: l_start := NVL(INSTRB(l_str,':',1,1),0);
479: IF l_start > 0 THEN

Line 504: l_sqlcursor := DBMS_SQL.OPEN_CURSOR;

500: EXIT WHEN l_start < 1;
501: END LOOP;
502:
503:
504: l_sqlcursor := DBMS_SQL.OPEN_CURSOR;
505:
506: BEGIN
507: DBMS_SQL.PARSE(l_sqlcursor, l_str_result, 1);
508: DBMS_SQL.DEFINE_COLUMN(l_sqlcursor, 1, l_value, 200);

Line 507: DBMS_SQL.PARSE(l_sqlcursor, l_str_result, 1);

503:
504: l_sqlcursor := DBMS_SQL.OPEN_CURSOR;
505:
506: BEGIN
507: DBMS_SQL.PARSE(l_sqlcursor, l_str_result, 1);
508: DBMS_SQL.DEFINE_COLUMN(l_sqlcursor, 1, l_value, 200);
509:
510: FOR i IN 1..l_party_count LOOP
511: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_PARTY_ID_'||i, p_filter_id);

Line 508: DBMS_SQL.DEFINE_COLUMN(l_sqlcursor, 1, l_value, 200);

504: l_sqlcursor := DBMS_SQL.OPEN_CURSOR;
505:
506: BEGIN
507: DBMS_SQL.PARSE(l_sqlcursor, l_str_result, 1);
508: DBMS_SQL.DEFINE_COLUMN(l_sqlcursor, 1, l_value, 200);
509:
510: FOR i IN 1..l_party_count LOOP
511: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_PARTY_ID_'||i, p_filter_id);
512: END LOOP;

Line 511: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_PARTY_ID_'||i, p_filter_id);

507: DBMS_SQL.PARSE(l_sqlcursor, l_str_result, 1);
508: DBMS_SQL.DEFINE_COLUMN(l_sqlcursor, 1, l_value, 200);
509:
510: FOR i IN 1..l_party_count LOOP
511: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_PARTY_ID_'||i, p_filter_id);
512: END LOOP;
513:
514: FOR i IN 1..l_acc_count LOOP
515: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_CUST_ACCOUNT_ID_'||i, p_filter_id);

Line 515: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_CUST_ACCOUNT_ID_'||i, p_filter_id);

511: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_PARTY_ID_'||i, p_filter_id);
512: END LOOP;
513:
514: FOR i IN 1..l_acc_count LOOP
515: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_CUST_ACCOUNT_ID_'||i, p_filter_id);
516: END LOOP;
517:
518: FOR i IN 1..l_billto_count LOOP
519: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_CUSTOMER_SITE_USE_ID_'||i, p_filter_id);

Line 519: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_CUSTOMER_SITE_USE_ID_'||i, p_filter_id);

515: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_CUST_ACCOUNT_ID_'||i, p_filter_id);
516: END LOOP;
517:
518: FOR i IN 1..l_billto_count LOOP
519: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_CUSTOMER_SITE_USE_ID_'||i, p_filter_id);
520: END LOOP;
521:
522: FOR i IN 1..p_del_count LOOP
523: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_DELINQUENCY_ID_'||i, p_filter_id);

Line 523: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_DELINQUENCY_ID_'||i, p_filter_id);

519: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_CUSTOMER_SITE_USE_ID_'||i, p_filter_id);
520: END LOOP;
521:
522: FOR i IN 1..p_del_count LOOP
523: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_DELINQUENCY_ID_'||i, p_filter_id);
524: END LOOP;
525:
526: l_dummy := DBMS_SQL.EXECUTE(l_sqlcursor);
527:

Line 526: l_dummy := DBMS_SQL.EXECUTE(l_sqlcursor);

522: FOR i IN 1..p_del_count LOOP
523: DBMS_SQL.BIND_VARIABLE(l_sqlcursor,'B_DELINQUENCY_ID_'||i, p_filter_id);
524: END LOOP;
525:
526: l_dummy := DBMS_SQL.EXECUTE(l_sqlcursor);
527:
528: IF DBMS_SQL.FETCH_ROWS(l_sqlcursor) > 0 THEN
529: DBMS_SQL.COLUMN_VALUE(l_sqlcursor,1,l_value);
530: END IF;

Line 528: IF DBMS_SQL.FETCH_ROWS(l_sqlcursor) > 0 THEN

524: END LOOP;
525:
526: l_dummy := DBMS_SQL.EXECUTE(l_sqlcursor);
527:
528: IF DBMS_SQL.FETCH_ROWS(l_sqlcursor) > 0 THEN
529: DBMS_SQL.COLUMN_VALUE(l_sqlcursor,1,l_value);
530: END IF;
531:
532: x_metric_value := l_value;

Line 529: DBMS_SQL.COLUMN_VALUE(l_sqlcursor,1,l_value);

525:
526: l_dummy := DBMS_SQL.EXECUTE(l_sqlcursor);
527:
528: IF DBMS_SQL.FETCH_ROWS(l_sqlcursor) > 0 THEN
529: DBMS_SQL.COLUMN_VALUE(l_sqlcursor,1,l_value);
530: END IF;
531:
532: x_metric_value := l_value;
533:

Line 542: DBMS_SQL.CLOSE_CURSOR(l_sqlcursor);

538: fnd_message.set_name ('IEX', 'IEX_METRIC_SQL_ERROR');
539: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
540: fnd_msg_pub.add;
541: END;
542: DBMS_SQL.CLOSE_CURSOR(l_sqlcursor);
543: END IF;
544: END IF;
545: CLOSE c_metric;
546: