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.CN_CLASSIFICATION_GEN dependencies on DBMS_LOB

Line 353: if (DBMS_LOB.ISTEMPORARY(expr_table(table_index).expr) IS NULL) THEN

349: quote := NULL;
350: first_flag := 'N';
351: table_index := table_index + 1;
352: expr_table(table_index).id := arc.attribute_rule_id;
353: if (DBMS_LOB.ISTEMPORARY(expr_table(table_index).expr) IS NULL) THEN
354: DBMS_LOB.CREATETEMPORARY(expr_table(table_index).expr,FALSE,DBMS_LOB.CALL);
355: END IF;
356: IF (arc.not_flag = 'Y') THEN
357: buffer := ' NOT';

Line 354: DBMS_LOB.CREATETEMPORARY(expr_table(table_index).expr,FALSE,DBMS_LOB.CALL);

350: first_flag := 'N';
351: table_index := table_index + 1;
352: expr_table(table_index).id := arc.attribute_rule_id;
353: if (DBMS_LOB.ISTEMPORARY(expr_table(table_index).expr) IS NULL) THEN
354: DBMS_LOB.CREATETEMPORARY(expr_table(table_index).expr,FALSE,DBMS_LOB.CALL);
355: END IF;
356: IF (arc.not_flag = 'Y') THEN
357: buffer := ' NOT';
358: DBMS_LOB.WRITE(expr_table(table_index).expr,length(buffer),1,buffer);

Line 358: DBMS_LOB.WRITE(expr_table(table_index).expr,length(buffer),1,buffer);

354: DBMS_LOB.CREATETEMPORARY(expr_table(table_index).expr,FALSE,DBMS_LOB.CALL);
355: END IF;
356: IF (arc.not_flag = 'Y') THEN
357: buffer := ' NOT';
358: DBMS_LOB.WRITE(expr_table(table_index).expr,length(buffer),1,buffer);
359: END IF;
360: --expr_table(table_index).expr := expr_table(table_index).expr || '(';
361: buffer:='(';
362: DBMS_LOB.WRITEAPPEND(expr_table(table_index).expr,length(buffer),buffer);

Line 362: DBMS_LOB.WRITEAPPEND(expr_table(table_index).expr,length(buffer),buffer);

358: DBMS_LOB.WRITE(expr_table(table_index).expr,length(buffer),1,buffer);
359: END IF;
360: --expr_table(table_index).expr := expr_table(table_index).expr || '(';
361: buffer:='(';
362: DBMS_LOB.WRITEAPPEND(expr_table(table_index).expr,length(buffer),buffer);
363: IF ((arc.data_type = 'VARCHAR2') OR (arc.data_type = 'DATE')) THEN
364: quote := '''';
365: ELSIF (arc.data_type = 'NUMB') THEN
366: quote := ' ';

Line 389: DBMS_LOB.WRITEAPPEND(expr_table(table_index).expr,length(buffer),buffer);

385: ' = ' || quote || arc.value || quote;
386:
387:
388: END IF ;
389: DBMS_LOB.WRITEAPPEND(expr_table(table_index).expr,length(buffer),buffer);
390: ELSE
391: buffer := 'cn_clsfn_'||ABS(x_ruleset_id)||cached_org_append
392: ||'.is_descendant_of(row.' || arc.column_name
393: || ', ' || quote || arc.value || quote || ', '

Line 395: DBMS_LOB.WRITEAPPEND(expr_table(table_index).expr,length(buffer),buffer);

391: buffer := 'cn_clsfn_'||ABS(x_ruleset_id)||cached_org_append
392: ||'.is_descendant_of(row.' || arc.column_name
393: || ', ' || quote || arc.value || quote || ', '
394: || arc.dimension_hierarchy_id || ', row.processed_date)';
395: DBMS_LOB.WRITEAPPEND(expr_table(table_index).expr,length(buffer),buffer);
396: END IF;
397: ELSIF (arc.high_value IS NOT NULL) THEN
398: IF (arc.low_value IS NOT NULL) THEN
399: IF (arc.data_type = 'DATE' OR arc.datatype = 'DATE') THEN

Line 419: DBMS_LOB.WRITEAPPEND(expr_table(table_index).expr,length(buffer),buffer);

415: || ' BETWEEN ' || quote || arc.low_value || quote || ' AND '
416: || quote || arc.high_value || quote;
417:
418: END IF;
419: DBMS_LOB.WRITEAPPEND(expr_table(table_index).expr,length(buffer),buffer);
420: ELSE
421: IF (arc.data_type = 'DATE' OR arc.datatype = 'DATE') THEN
422: IF arc.datatype = 'DATE' THEN
423: buffer := 'nvl(row.' || arc.column_name || ' , '

Line 434: DBMS_LOB.WRITEAPPEND(expr_table(table_index).expr,length(buffer),buffer);

430: END IF;
431: ELSE
432: buffer := 'nvl(row.' || arc.column_name || ' , ' || quote || l_dummy || quote || ' ) ' || ' <= ' || quote || arc.high_value || quote;
433: END IF;
434: DBMS_LOB.WRITEAPPEND(expr_table(table_index).expr,length(buffer),buffer);
435: END IF;
436: ELSIF (arc.low_value IS NOT NULL) THEN
437: IF (arc.data_type = 'DATE' OR arc.datatype = 'DATE') THEN
438: buffer := 'nvl(TO_DATE(row.' || arc.column_name || ',' || quote || 'DD/MM/RRRR'||quote ||')'|| ' , '

Line 446: DBMS_LOB.WRITEAPPEND(expr_table(table_index).expr,length(buffer),buffer);

442: buffer := 'nvl(row.' || arc.column_name
443: || ' ,' || quote || l_dummy || quote || ' ) '
444: || ' >= ' || quote || arc.low_value || quote;
445: END IF;
446: DBMS_LOB.WRITEAPPEND(expr_table(table_index).expr,length(buffer),buffer);
447: END IF;
448: buffer := ')';
449: DBMS_LOB.WRITEAPPEND(expr_table(table_index).expr,length(buffer),buffer);
450: END LOOP;

Line 449: DBMS_LOB.WRITEAPPEND(expr_table(table_index).expr,length(buffer),buffer);

445: END IF;
446: DBMS_LOB.WRITEAPPEND(expr_table(table_index).expr,length(buffer),buffer);
447: END IF;
448: buffer := ')';
449: DBMS_LOB.WRITEAPPEND(expr_table(table_index).expr,length(buffer),buffer);
450: END LOOP;
451:
452:
453: FOR rae IN rule_attr_expr_cursor LOOP

Line 459: if (DBMS_LOB.ISTEMPORARY(expr_table(table_index).expr) IS NULL) THEN

455: table_index := table_index + 1;
456: expr_table(table_index).id := rae.rule_attr_expression_id;
457: expr_table(table_index).expr_id := rae.operand_expression_id;
458: buffer := '(';
459: if (DBMS_LOB.ISTEMPORARY(expr_table(table_index).expr) IS NULL) THEN
460: DBMS_LOB.CREATETEMPORARY(expr_table(table_index).expr,FALSE,DBMS_LOB.CALL);
461: END IF;
462: DBMS_LOB.WRITE(expr_table(table_index).expr,length(buffer),1,buffer);
463: FOR v_counter IN 1 .. table_index LOOP

Line 460: DBMS_LOB.CREATETEMPORARY(expr_table(table_index).expr,FALSE,DBMS_LOB.CALL);

456: expr_table(table_index).id := rae.rule_attr_expression_id;
457: expr_table(table_index).expr_id := rae.operand_expression_id;
458: buffer := '(';
459: if (DBMS_LOB.ISTEMPORARY(expr_table(table_index).expr) IS NULL) THEN
460: DBMS_LOB.CREATETEMPORARY(expr_table(table_index).expr,FALSE,DBMS_LOB.CALL);
461: END IF;
462: DBMS_LOB.WRITE(expr_table(table_index).expr,length(buffer),1,buffer);
463: FOR v_counter IN 1 .. table_index LOOP
464: IF rae.operand1_ra_rae_flag = 'RA' THEN

Line 462: DBMS_LOB.WRITE(expr_table(table_index).expr,length(buffer),1,buffer);

458: buffer := '(';
459: if (DBMS_LOB.ISTEMPORARY(expr_table(table_index).expr) IS NULL) THEN
460: DBMS_LOB.CREATETEMPORARY(expr_table(table_index).expr,FALSE,DBMS_LOB.CALL);
461: END IF;
462: DBMS_LOB.WRITE(expr_table(table_index).expr,length(buffer),1,buffer);
463: FOR v_counter IN 1 .. table_index LOOP
464: IF rae.operand1_ra_rae_flag = 'RA' THEN
465: IF expr_table(v_counter).id = rae.operand1 THEN
466: DBMS_LOB.APPEND(expr_table(table_index).expr,expr_table(v_counter).expr);

Line 466: DBMS_LOB.APPEND(expr_table(table_index).expr,expr_table(v_counter).expr);

462: DBMS_LOB.WRITE(expr_table(table_index).expr,length(buffer),1,buffer);
463: FOR v_counter IN 1 .. table_index LOOP
464: IF rae.operand1_ra_rae_flag = 'RA' THEN
465: IF expr_table(v_counter).id = rae.operand1 THEN
466: DBMS_LOB.APPEND(expr_table(table_index).expr,expr_table(v_counter).expr);
467: END IF;
468: ELSIF rae.operand1_ra_rae_flag = 'RAE' THEN
469: IF expr_table(v_counter).expr_id = rae.operand1 THEN
470: DBMS_LOB.APPEND(expr_table(table_index).expr,expr_table(v_counter).expr);

Line 470: DBMS_LOB.APPEND(expr_table(table_index).expr,expr_table(v_counter).expr);

466: DBMS_LOB.APPEND(expr_table(table_index).expr,expr_table(v_counter).expr);
467: END IF;
468: ELSIF rae.operand1_ra_rae_flag = 'RAE' THEN
469: IF expr_table(v_counter).expr_id = rae.operand1 THEN
470: DBMS_LOB.APPEND(expr_table(table_index).expr,expr_table(v_counter).expr);
471: END IF;
472: END IF;
473: END LOOP;
474: IF rae.operator = 0 THEN

Line 479: DBMS_LOB.WRITEAPPEND(expr_table(table_index).expr,length(buffer),buffer);

475: buffer:= 'AND';
476: ELSE
477: buffer:= 'OR';
478: END IF;
479: DBMS_LOB.WRITEAPPEND(expr_table(table_index).expr,length(buffer),buffer);
480: FOR v_counter IN 1 .. table_index LOOP
481: IF rae.operand2_ra_rae_flag = 'RA' THEN
482: IF expr_table(v_counter).id = rae.operand2 THEN
483: DBMS_LOB.APPEND(expr_table(table_index).expr,expr_table(v_counter).expr);

Line 483: DBMS_LOB.APPEND(expr_table(table_index).expr,expr_table(v_counter).expr);

479: DBMS_LOB.WRITEAPPEND(expr_table(table_index).expr,length(buffer),buffer);
480: FOR v_counter IN 1 .. table_index LOOP
481: IF rae.operand2_ra_rae_flag = 'RA' THEN
482: IF expr_table(v_counter).id = rae.operand2 THEN
483: DBMS_LOB.APPEND(expr_table(table_index).expr,expr_table(v_counter).expr);
484: END IF;
485: ELSIF rae.operand2_ra_rae_flag = 'RAE' THEN
486: IF expr_table(v_counter).expr_id = rae.operand2 THEN
487: DBMS_LOB.APPEND(expr_table(table_index).expr,expr_table(v_counter).expr);

Line 487: DBMS_LOB.APPEND(expr_table(table_index).expr,expr_table(v_counter).expr);

483: DBMS_LOB.APPEND(expr_table(table_index).expr,expr_table(v_counter).expr);
484: END IF;
485: ELSIF rae.operand2_ra_rae_flag = 'RAE' THEN
486: IF expr_table(v_counter).expr_id = rae.operand2 THEN
487: DBMS_LOB.APPEND(expr_table(table_index).expr,expr_table(v_counter).expr);
488: END IF;
489: END IF;
490: END LOOP;
491: buffer:= ')';

Line 492: DBMS_LOB.WRITEAPPEND(expr_table(table_index).expr,length(buffer),buffer);

488: END IF;
489: END IF;
490: END LOOP;
491: buffer:= ')';
492: DBMS_LOB.WRITEAPPEND(expr_table(table_index).expr,length(buffer),buffer);
493: END LOOP;
494: IF (first_flag = 'Y') THEN
495: -- no attribute rules were found for this rule, so always enable it
496: cn_utils.append(code, 'TRUE)');

Line 504: DBMS_LOB.FREETEMPORARY(expr_table(clob_counter).expr);

500: ELSE
501: cn_utils.append(code, expr_table(table_index).expr, ')');
502: END IF;
503: FOR clob_counter IN 1 .. expr_table.count LOOP
504: DBMS_LOB.FREETEMPORARY(expr_table(clob_counter).expr);
505: END LOOP;
506: cn_debug.print_msg('attribute_rules<<', 1);
507: EXCEPTION
508: WHEN NO_DATA_FOUND THEN

Line 1690: DBMS_LOB.CREATETEMPORARY(spec_code.text,FALSE,DBMS_LOB.CALL);

1686: AND ruleset_id = x_ruleset_id_in;
1687:
1688: BEGIN
1689: cn_utils.set_org_id(x_org_id_in);
1690: DBMS_LOB.CREATETEMPORARY(spec_code.text,FALSE,DBMS_LOB.CALL);
1691: DBMS_LOB.CREATETEMPORARY(body_code.text,FALSE,DBMS_LOB.CALL);
1692: g_ruleset_id := X_ruleset_id_in;
1693: IF (debug_pipe IS NOT NULL) THEN
1694: cn_debug.init_pipe(debug_pipe, debug_level);

Line 1691: DBMS_LOB.CREATETEMPORARY(body_code.text,FALSE,DBMS_LOB.CALL);

1687:
1688: BEGIN
1689: cn_utils.set_org_id(x_org_id_in);
1690: DBMS_LOB.CREATETEMPORARY(spec_code.text,FALSE,DBMS_LOB.CALL);
1691: DBMS_LOB.CREATETEMPORARY(body_code.text,FALSE,DBMS_LOB.CALL);
1692: g_ruleset_id := X_ruleset_id_in;
1693: IF (debug_pipe IS NOT NULL) THEN
1694: cn_debug.init_pipe(debug_pipe, debug_level);
1695: END IF;

Line 1945: DBMS_LOB.FREETEMPORARY(spec_code.text);

1941: spec_code, body_code);
1942:
1943: cn_debug.print_msg('revenue_classes<<', 1);
1944:
1945: DBMS_LOB.FREETEMPORARY(spec_code.text);
1946: DBMS_LOB.FREETEMPORARY(body_code.text);
1947: cn_utils.unset_org_id;
1948: RETURN TRUE;
1949:

Line 1946: DBMS_LOB.FREETEMPORARY(body_code.text);

1942:
1943: cn_debug.print_msg('revenue_classes<<', 1);
1944:
1945: DBMS_LOB.FREETEMPORARY(spec_code.text);
1946: DBMS_LOB.FREETEMPORARY(body_code.text);
1947: cn_utils.unset_org_id;
1948: RETURN TRUE;
1949:
1950: EXCEPTION

Line 1952: DBMS_LOB.FREETEMPORARY(spec_code.text);

1948: RETURN TRUE;
1949:
1950: EXCEPTION
1951: WHEN NO_DATA_FOUND THEN
1952: DBMS_LOB.FREETEMPORARY(spec_code.text);
1953: DBMS_LOB.FREETEMPORARY(body_code.text);
1954: cn_debug.print_msg('revenue_classes: in exception handler for NO_DATA_FOUND', 1);
1955: RETURN FALSE;
1956: END revenue_classes;

Line 1953: DBMS_LOB.FREETEMPORARY(body_code.text);

1949:
1950: EXCEPTION
1951: WHEN NO_DATA_FOUND THEN
1952: DBMS_LOB.FREETEMPORARY(spec_code.text);
1953: DBMS_LOB.FREETEMPORARY(body_code.text);
1954: cn_debug.print_msg('revenue_classes: in exception handler for NO_DATA_FOUND', 1);
1955: RETURN FALSE;
1956: END revenue_classes;
1957: