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

Line 163: DBMS_LOB.CREATETEMPORARY(x_stmt_rule, FALSE, DBMS_LOB.CALL);

159: x_return_status := FND_API.G_RET_STS_SUCCESS;
160:
161: -- 8i 9i compatibility issue
162: -- initialize the CLOB
163: DBMS_LOB.CREATETEMPORARY(x_stmt_rule, FALSE, DBMS_LOB.CALL);
164:
165: OPEN csr_rule_dtls;
166: FETCH csr_rule_dtls INTO l_org_id, l_intent, l_condition_expr_code,l_rule_type;
167: CLOSE csr_rule_dtls;

Line 276: IF DBMS_LOB.getlength(x_stmt_rule) > 0 THEN

272:
273:
274:
275: -- IF x_stmt_rule IS NOT NULL THEN
276: IF DBMS_LOB.getlength(x_stmt_rule) > 0 THEN
277: -- x_stmt_rule := x_stmt_rule||' '||l_condition_expr_code;
278: -- 8i 9i backward compatibility issue with clob
279: l_temp_string := ' '||l_condition_expr_code;
280: DBMS_LOB.WRITEAPPEND(x_stmt_rule,length(l_temp_string) , l_temp_string);

Line 280: DBMS_LOB.WRITEAPPEND(x_stmt_rule,length(l_temp_string) , l_temp_string);

276: IF DBMS_LOB.getlength(x_stmt_rule) > 0 THEN
277: -- x_stmt_rule := x_stmt_rule||' '||l_condition_expr_code;
278: -- 8i 9i backward compatibility issue with clob
279: l_temp_string := ' '||l_condition_expr_code;
280: DBMS_LOB.WRITEAPPEND(x_stmt_rule,length(l_temp_string) , l_temp_string);
281: --
282: END IF;
283:
284: -- Boolen is treated as Character or LOV

Line 291: DBMS_LOB.WRITEAPPEND(x_stmt_rule,length(l_temp_string) , l_temp_string);

287: IF l_operator = 'ANYTRUE' THEN
288: -- x_stmt_rule:= x_stmt_rule||' '||l_operator||' '||'(';
289: -- 8i 9i backward compatibility issue with clob
290: l_temp_string := ' '||l_operator||' '||'(';
291: DBMS_LOB.WRITEAPPEND(x_stmt_rule,length(l_temp_string) , l_temp_string);
292: --
293: ELSE
294: -- l_operator is NOTTRUE
295: --x_stmt_rule:= x_stmt_rule||' '||'(';

Line 298: DBMS_LOB.WRITEAPPEND(x_stmt_rule,length(l_temp_string) , l_temp_string);

294: -- l_operator is NOTTRUE
295: --x_stmt_rule:= x_stmt_rule||' '||'(';
296: -- 8i 9i backward compatibility issue with clob
297: l_temp_string := ' '||'(';
298: DBMS_LOB.WRITEAPPEND(x_stmt_rule,length(l_temp_string) , l_temp_string);
299: --
300: END IF; -- l_operator
301: /*
302: ELSIF l_object_code_datatype = 'B' THEN

Line 317: DBMS_LOB.WRITEAPPEND(x_stmt_rule,length(l_temp_string) , l_temp_string);

313: -- Numeric
314: --x_stmt_rule:= x_stmt_rule||' '||'(';
315: -- 8i 9i backward compatibility issue with clob
316: l_temp_string := ' '||'(';
317: DBMS_LOB.WRITEAPPEND(x_stmt_rule,length(l_temp_string) , l_temp_string);
318: --
319: END IF;
320:
321: -- initialize l_condition_stmt

Line 323: DBMS_LOB.CREATETEMPORARY(l_condition_stmt, FALSE, DBMS_LOB.CALL);

319: END IF;
320:
321: -- initialize l_condition_stmt
322: -- l_condition_stmt := '';
323: DBMS_LOB.CREATETEMPORARY(l_condition_stmt, FALSE, DBMS_LOB.CALL);
324:
325: -- For Each Condition Get the Values and create the statement
326: OPEN csr_rule_cond_vals(p_rule_condition_id => l_rule_condition_id);
327: LOOP

Line 346: IF DBMS_LOB.getlength(l_condition_stmt) = 0 THEN

342: IF l_object_type = 'CLAUSE' THEN
343: -- RHS is also CLAUSE
344: IF l_operator = 'ANYTRUE' THEN
345: --IF l_condition_stmt IS NULL THEN
346: IF DBMS_LOB.getlength(l_condition_stmt) = 0 THEN
347: -- l_condition_stmt := l_clause_prefix||''''||l_object_value_code||'''';
348: l_temp_string := l_clause_prefix||''''||l_object_value_code||'''';
349: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);
350: ELSE

Line 349: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);

345: --IF l_condition_stmt IS NULL THEN
346: IF DBMS_LOB.getlength(l_condition_stmt) = 0 THEN
347: -- l_condition_stmt := l_clause_prefix||''''||l_object_value_code||'''';
348: l_temp_string := l_clause_prefix||''''||l_object_value_code||'''';
349: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);
350: ELSE
351: -- l_condition_stmt := l_condition_stmt||','||l_clause_prefix||''''||l_object_value_code||'''';
352: l_temp_string := ','||l_clause_prefix||''''||l_object_value_code||'''';
353: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);

Line 353: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);

349: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);
350: ELSE
351: -- l_condition_stmt := l_condition_stmt||','||l_clause_prefix||''''||l_object_value_code||'''';
352: l_temp_string := ','||l_clause_prefix||''''||l_object_value_code||'''';
353: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);
354: END IF; -- l_condition_stmt
355: ELSE
356: -- l_operator = NOTTRUE
357: --IF l_condition_stmt IS NULL THEN

Line 358: IF DBMS_LOB.getlength(l_condition_stmt) = 0 THEN

354: END IF; -- l_condition_stmt
355: ELSE
356: -- l_operator = NOTTRUE
357: --IF l_condition_stmt IS NULL THEN
358: IF DBMS_LOB.getlength(l_condition_stmt) = 0 THEN
359: --l_condition_stmt := 'NOTTRUE('||l_clause_prefix||''''||l_object_value_code||''''||')';
360: l_temp_string := 'NOTTRUE('||l_clause_prefix||''''||l_object_value_code||''''||')';
361: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);
362: ELSE

Line 361: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);

357: --IF l_condition_stmt IS NULL THEN
358: IF DBMS_LOB.getlength(l_condition_stmt) = 0 THEN
359: --l_condition_stmt := 'NOTTRUE('||l_clause_prefix||''''||l_object_value_code||''''||')';
360: l_temp_string := 'NOTTRUE('||l_clause_prefix||''''||l_object_value_code||''''||')';
361: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);
362: ELSE
363: --l_condition_stmt := l_condition_stmt||' AND NOTTRUE('||l_clause_prefix||''''||l_object_value_code||''''||')';
364: l_temp_string := ' AND NOTTRUE('||l_clause_prefix||''''||l_object_value_code||''''||')';
365: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);

Line 365: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);

361: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);
362: ELSE
363: --l_condition_stmt := l_condition_stmt||' AND NOTTRUE('||l_clause_prefix||''''||l_object_value_code||''''||')';
364: l_temp_string := ' AND NOTTRUE('||l_clause_prefix||''''||l_object_value_code||''''||')';
365: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);
366: END IF; -- l_condition_stmt
367: END IF; -- l_operator
368:
369: ELSIF l_object_type = 'VARIABLE' THEN

Line 379: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);

375: --l_condition_stmt := l_system_var_prefix||''''||l_object_code||''''||l_operator||
376: -- l_question_prefix||''''||l_object_value_code||'''';
377: l_temp_string := l_system_var_prefix||''''||l_object_code||''''||l_operator||
378: l_question_prefix||''''||l_object_value_code||'''';
379: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);
380: ELSE
381: -- RHS is Numeric System Variable or Constant
382: --l_condition_stmt := l_system_var_prefix||''''||l_object_code||''''||l_operator||
383: -- l_system_var_prefix||''''||l_object_value_code||'''';

Line 386: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);

382: --l_condition_stmt := l_system_var_prefix||''''||l_object_code||''''||l_operator||
383: -- l_system_var_prefix||''''||l_object_value_code||'''';
384: l_temp_string := l_system_var_prefix||''''||l_object_code||''''||l_operator||
385: l_system_var_prefix||''''||l_object_value_code||'''';
386: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);
387:
388: END IF; -- RHS for Numeric LHS Variable
389:
390: ELSIF l_object_code_datatype IN ('V','L') THEN

Line 394: IF DBMS_LOB.getlength(l_condition_stmt) = 0 THEN

390: ELSIF l_object_code_datatype IN ('V','L') THEN
391: -- RHS Can ONLY be Character System Variable Value
392: IF l_operator = 'ANYTRUE' THEN
393: --IF l_condition_stmt IS NULL THEN
394: IF DBMS_LOB.getlength(l_condition_stmt) = 0 THEN
395: --l_condition_stmt := l_system_var_prefix||''''||l_object_code||''''||'.'||
396: -- ''''||l_object_value_code||'''';
397: l_temp_string := l_system_var_prefix||''''||l_object_code||''''||'.'||
398: ''''||l_object_value_code||'''';

Line 399: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);

395: --l_condition_stmt := l_system_var_prefix||''''||l_object_code||''''||'.'||
396: -- ''''||l_object_value_code||'''';
397: l_temp_string := l_system_var_prefix||''''||l_object_code||''''||'.'||
398: ''''||l_object_value_code||'''';
399: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);
400: ELSE
401: --l_condition_stmt := l_condition_stmt||','||l_system_var_prefix||''''||l_object_code||
402: -- ''''||'.'||''''||l_object_value_code||'''';
403: l_temp_string := ','||l_system_var_prefix||''''||l_object_code||

Line 405: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);

401: --l_condition_stmt := l_condition_stmt||','||l_system_var_prefix||''''||l_object_code||
402: -- ''''||'.'||''''||l_object_value_code||'''';
403: l_temp_string := ','||l_system_var_prefix||''''||l_object_code||
404: ''''||'.'||''''||l_object_value_code||'''';
405: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);
406: END IF; -- l_condition_stmt IS NULL
407: ELSE
408: -- l_operator = 'NOTTRUE'
409: --IF l_condition_stmt IS NULL THEN

Line 410: IF DBMS_LOB.getlength(l_condition_stmt) = 0 THEN

406: END IF; -- l_condition_stmt IS NULL
407: ELSE
408: -- l_operator = 'NOTTRUE'
409: --IF l_condition_stmt IS NULL THEN
410: IF DBMS_LOB.getlength(l_condition_stmt) = 0 THEN
411: --l_condition_stmt := 'NOTTRUE('||l_system_var_prefix||''''||l_object_code||
412: -- ''''||'.'||''''||l_object_value_code||''''||')';
413: l_temp_string := 'NOTTRUE('||l_system_var_prefix||''''||l_object_code||
414: ''''||'.'||''''||l_object_value_code||''''||')';

Line 415: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);

411: --l_condition_stmt := 'NOTTRUE('||l_system_var_prefix||''''||l_object_code||
412: -- ''''||'.'||''''||l_object_value_code||''''||')';
413: l_temp_string := 'NOTTRUE('||l_system_var_prefix||''''||l_object_code||
414: ''''||'.'||''''||l_object_value_code||''''||')';
415: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);
416:
417: ELSE
418: --l_condition_stmt := l_condition_stmt||' AND NOTTRUE('||l_system_var_prefix||
419: -- ''''||l_object_code||''''||'.'||''''||l_object_value_code||''''||')';

Line 422: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);

418: --l_condition_stmt := l_condition_stmt||' AND NOTTRUE('||l_system_var_prefix||
419: -- ''''||l_object_code||''''||'.'||''''||l_object_value_code||''''||')';
420: l_temp_string := ' AND NOTTRUE('||l_system_var_prefix||
421: ''''||l_object_code||''''||'.'||''''||l_object_value_code||''''||')';
422: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);
423:
424: END IF; -- l_condition_stmt
425:
426: END IF; -- l_operator

Line 441: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);

437: -- l_condition_stmt := l_question_prefix||''''||l_object_code||''''||l_operator||
438: -- l_question_prefix||''''||l_object_value_code||'''';
439: l_temp_string:= l_question_prefix||''''||l_object_code||''''||l_operator||
440: l_question_prefix||''''||l_object_value_code||'''';
441: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);
442: ELSE
443: -- RHS is Numeric System Variable or Constant
444: -- l_condition_stmt := l_question_prefix||''''||l_object_code||''''||l_operator||
445: -- l_system_var_prefix||''''||l_object_value_code||'''';

Line 448: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);

444: -- l_condition_stmt := l_question_prefix||''''||l_object_code||''''||l_operator||
445: -- l_system_var_prefix||''''||l_object_value_code||'''';
446: l_temp_string := l_question_prefix||''''||l_object_code||''''||l_operator||
447: l_system_var_prefix||''''||l_object_value_code||'''';
448: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);
449: END IF; -- RHS for Numeric LHS Variable
450:
451: /*
452: ELSIF l_object_code_datatype = 'B' THEN

Line 460: IF DBMS_LOB.getlength(l_condition_stmt) = 0 THEN

456:
457: ELSIF l_object_code_datatype IN ('V','L','B') THEN
458: IF l_operator = 'ANYTRUE' THEN
459: --IF l_condition_stmt IS NULL THEN
460: IF DBMS_LOB.getlength(l_condition_stmt) = 0 THEN
461:
462: -- l_condition_stmt := l_question_prefix||''''||l_object_code||''''||'.'||
463: -- ''''||l_object_value_code||'''';
464: l_temp_string := l_question_prefix||''''||l_object_code||''''||'.'||

Line 466: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);

462: -- l_condition_stmt := l_question_prefix||''''||l_object_code||''''||'.'||
463: -- ''''||l_object_value_code||'''';
464: l_temp_string := l_question_prefix||''''||l_object_code||''''||'.'||
465: ''''||l_object_value_code||'''';
466: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);
467: ELSE
468: -- l_condition_stmt := l_condition_stmt||','||l_question_prefix||''''||l_object_code||
469: -- ''''||'.'||''''||l_object_value_code||'''';
470: l_temp_string := ','||l_question_prefix||''''||l_object_code||

Line 472: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);

468: -- l_condition_stmt := l_condition_stmt||','||l_question_prefix||''''||l_object_code||
469: -- ''''||'.'||''''||l_object_value_code||'''';
470: l_temp_string := ','||l_question_prefix||''''||l_object_code||
471: ''''||'.'||''''||l_object_value_code||'''';
472: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);
473:
474: END IF; -- l_condition_stmt IS NULL
475: ELSE
476: -- l_operator = 'NOTTRUE'

Line 478: IF DBMS_LOB.getlength(l_condition_stmt) = 0 THEN

474: END IF; -- l_condition_stmt IS NULL
475: ELSE
476: -- l_operator = 'NOTTRUE'
477: --IF l_condition_stmt IS NULL THEN
478: IF DBMS_LOB.getlength(l_condition_stmt) = 0 THEN
479: -- l_condition_stmt := 'NOTTRUE('||l_question_prefix||''''||l_object_code||''''||'.'||
480: -- ''''||l_object_value_code||''''||')';
481: l_temp_string := 'NOTTRUE('||l_question_prefix||''''||l_object_code||''''||'.'||
482: ''''||l_object_value_code||''''||')';

Line 483: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);

479: -- l_condition_stmt := 'NOTTRUE('||l_question_prefix||''''||l_object_code||''''||'.'||
480: -- ''''||l_object_value_code||''''||')';
481: l_temp_string := 'NOTTRUE('||l_question_prefix||''''||l_object_code||''''||'.'||
482: ''''||l_object_value_code||''''||')';
483: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);
484: ELSE
485: -- l_condition_stmt := l_condition_stmt||' AND NOTTRUE('||l_question_prefix||
486: -- ''''||l_object_code||''''||'.'||''''||l_object_value_code||''''||')';
487: l_temp_string := ' AND NOTTRUE('||l_question_prefix||

Line 489: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);

485: -- l_condition_stmt := l_condition_stmt||' AND NOTTRUE('||l_question_prefix||
486: -- ''''||l_object_code||''''||'.'||''''||l_object_value_code||''''||')';
487: l_temp_string := ' AND NOTTRUE('||l_question_prefix||
488: ''''||l_object_code||''''||'.'||''''||l_object_value_code||''''||')';
489: DBMS_LOB.WRITEAPPEND(l_condition_stmt,length(l_temp_string) , l_temp_string);
490: END IF; -- l_condition_stmt
491:
492: END IF; -- l_operator
493:

Line 505: --DBMS_LOB.WRITEAPPEND(x_stmt_rule,length(l_temp_string) , l_temp_string);

501:
502: -- x_stmt_rule:= x_stmt_rule||l_condition_stmt||')';
503: -- 8i 9i backward compatibility issue with clob
504: --l_temp_string := l_condition_stmt||')';
505: --DBMS_LOB.WRITEAPPEND(x_stmt_rule,length(l_temp_string) , l_temp_string);
506:
507: DBMS_LOB.APPEND(x_stmt_rule,l_condition_stmt);
508: DBMS_LOB.FREETEMPORARY(l_condition_stmt);
509: l_temp_string := ')';

Line 507: DBMS_LOB.APPEND(x_stmt_rule,l_condition_stmt);

503: -- 8i 9i backward compatibility issue with clob
504: --l_temp_string := l_condition_stmt||')';
505: --DBMS_LOB.WRITEAPPEND(x_stmt_rule,length(l_temp_string) , l_temp_string);
506:
507: DBMS_LOB.APPEND(x_stmt_rule,l_condition_stmt);
508: DBMS_LOB.FREETEMPORARY(l_condition_stmt);
509: l_temp_string := ')';
510: DBMS_LOB.WRITEAPPEND(x_stmt_rule,length(l_temp_string) , l_temp_string);
511:

Line 508: DBMS_LOB.FREETEMPORARY(l_condition_stmt);

504: --l_temp_string := l_condition_stmt||')';
505: --DBMS_LOB.WRITEAPPEND(x_stmt_rule,length(l_temp_string) , l_temp_string);
506:
507: DBMS_LOB.APPEND(x_stmt_rule,l_condition_stmt);
508: DBMS_LOB.FREETEMPORARY(l_condition_stmt);
509: l_temp_string := ')';
510: DBMS_LOB.WRITEAPPEND(x_stmt_rule,length(l_temp_string) , l_temp_string);
511:
512:

Line 510: DBMS_LOB.WRITEAPPEND(x_stmt_rule,length(l_temp_string) , l_temp_string);

506:
507: DBMS_LOB.APPEND(x_stmt_rule,l_condition_stmt);
508: DBMS_LOB.FREETEMPORARY(l_condition_stmt);
509: l_temp_string := ')';
510: DBMS_LOB.WRITEAPPEND(x_stmt_rule,length(l_temp_string) , l_temp_string);
511:
512:
513: --
514:

Line 531: DBMS_LOB.CREATETEMPORARY(l_outcome_stmt, FALSE, DBMS_LOB.CALL);

527: -- Build the Outcome String
528:
529: -- initialize l_condition_stmt
530: --l_outcome_stmt := '';
531: DBMS_LOB.CREATETEMPORARY(l_outcome_stmt, FALSE, DBMS_LOB.CALL);
532:
533: IF l_rule_type = 'TERM_DEVIATION' THEN
534: l_object_value_id := p_rule_id;
535: -- Outcome is Deviation

Line 536: IF DBMS_LOB.getlength(l_outcome_stmt) = 0 THEN

532:
533: IF l_rule_type = 'TERM_DEVIATION' THEN
534: l_object_value_id := p_rule_id;
535: -- Outcome is Deviation
536: IF DBMS_LOB.getlength(l_outcome_stmt) = 0 THEN
537:
538: l_temp_string := l_deviation_prefix||''''||l_object_value_id||'''';
539: DBMS_LOB.WRITEAPPEND(l_outcome_stmt,length(l_temp_string) , l_temp_string);
540: ELSE

Line 539: DBMS_LOB.WRITEAPPEND(l_outcome_stmt,length(l_temp_string) , l_temp_string);

535: -- Outcome is Deviation
536: IF DBMS_LOB.getlength(l_outcome_stmt) = 0 THEN
537:
538: l_temp_string := l_deviation_prefix||''''||l_object_value_id||'''';
539: DBMS_LOB.WRITEAPPEND(l_outcome_stmt,length(l_temp_string) , l_temp_string);
540: ELSE
541: l_temp_string := ','||l_deviation_prefix||''''||l_object_value_id||'''';
542: DBMS_LOB.WRITEAPPEND(l_outcome_stmt,length(l_temp_string) , l_temp_string);
543: END IF;

Line 542: DBMS_LOB.WRITEAPPEND(l_outcome_stmt,length(l_temp_string) , l_temp_string);

538: l_temp_string := l_deviation_prefix||''''||l_object_value_id||'''';
539: DBMS_LOB.WRITEAPPEND(l_outcome_stmt,length(l_temp_string) , l_temp_string);
540: ELSE
541: l_temp_string := ','||l_deviation_prefix||''''||l_object_value_id||'''';
542: DBMS_LOB.WRITEAPPEND(l_outcome_stmt,length(l_temp_string) , l_temp_string);
543: END IF;
544: ELSE
545: -- l_rule_type is CLAUSE_SELECTION
546: OPEN csr_rule_outcomes;

Line 553: IF DBMS_LOB.getlength(l_outcome_stmt) = 0 THEN

549: EXIT WHEN csr_rule_outcomes%NOTFOUND;
550: IF l_object_type_outcome = 'CLAUSE' THEN
551:
552: --IF l_outcome_stmt IS NULL THEN
553: IF DBMS_LOB.getlength(l_outcome_stmt) = 0 THEN
554:
555: --l_outcome_stmt := l_clause_prefix||''''||l_object_value_id||'''';
556: l_temp_string := l_clause_prefix||''''||l_object_value_id||'''';
557: DBMS_LOB.WRITEAPPEND(l_outcome_stmt,length(l_temp_string) , l_temp_string);

Line 557: DBMS_LOB.WRITEAPPEND(l_outcome_stmt,length(l_temp_string) , l_temp_string);

553: IF DBMS_LOB.getlength(l_outcome_stmt) = 0 THEN
554:
555: --l_outcome_stmt := l_clause_prefix||''''||l_object_value_id||'''';
556: l_temp_string := l_clause_prefix||''''||l_object_value_id||'''';
557: DBMS_LOB.WRITEAPPEND(l_outcome_stmt,length(l_temp_string) , l_temp_string);
558:
559: ELSE
560: -- l_outcome_stmt := l_outcome_stmt||','||l_clause_prefix||''''||l_object_value_id||'''';
561: l_temp_string := ','||l_clause_prefix||''''||l_object_value_id||'''';

Line 562: DBMS_LOB.WRITEAPPEND(l_outcome_stmt,length(l_temp_string) , l_temp_string);

558:
559: ELSE
560: -- l_outcome_stmt := l_outcome_stmt||','||l_clause_prefix||''''||l_object_value_id||'''';
561: l_temp_string := ','||l_clause_prefix||''''||l_object_value_id||'''';
562: DBMS_LOB.WRITEAPPEND(l_outcome_stmt,length(l_temp_string) , l_temp_string);
563: END IF;
564:
565: ELSE
566: -- Outcome is Question

Line 568: IF DBMS_LOB.getlength(l_outcome_stmt) = 0 THEN

564:
565: ELSE
566: -- Outcome is Question
567: --IF l_outcome_stmt IS NULL THEN
568: IF DBMS_LOB.getlength(l_outcome_stmt) = 0 THEN
569:
570: --l_outcome_stmt := l_question_prefix||''''||l_object_value_id||'''';
571: l_temp_string := l_question_prefix||''''||l_object_value_id||'''';
572: DBMS_LOB.WRITEAPPEND(l_outcome_stmt,length(l_temp_string) , l_temp_string);

Line 572: DBMS_LOB.WRITEAPPEND(l_outcome_stmt,length(l_temp_string) , l_temp_string);

568: IF DBMS_LOB.getlength(l_outcome_stmt) = 0 THEN
569:
570: --l_outcome_stmt := l_question_prefix||''''||l_object_value_id||'''';
571: l_temp_string := l_question_prefix||''''||l_object_value_id||'''';
572: DBMS_LOB.WRITEAPPEND(l_outcome_stmt,length(l_temp_string) , l_temp_string);
573: ELSE
574: --l_outcome_stmt := l_outcome_stmt||','||l_question_prefix||''''||l_object_value_id||'''';
575: l_temp_string := ','||l_question_prefix||''''||l_object_value_id||'''';
576: DBMS_LOB.WRITEAPPEND(l_outcome_stmt,length(l_temp_string) , l_temp_string);

Line 576: DBMS_LOB.WRITEAPPEND(l_outcome_stmt,length(l_temp_string) , l_temp_string);

572: DBMS_LOB.WRITEAPPEND(l_outcome_stmt,length(l_temp_string) , l_temp_string);
573: ELSE
574: --l_outcome_stmt := l_outcome_stmt||','||l_question_prefix||''''||l_object_value_id||'''';
575: l_temp_string := ','||l_question_prefix||''''||l_object_value_id||'''';
576: DBMS_LOB.WRITEAPPEND(l_outcome_stmt,length(l_temp_string) , l_temp_string);
577:
578: END IF;
579:
580: END IF;

Line 610: DBMS_LOB.WRITEAPPEND(x_stmt_rule,length(l_temp_string) , l_temp_string);

606: --x_stmt_rule:= x_stmt_rule||' '||'IMPLIES ALLTRUE'||' '||'('||l_outcome_stmt||')';
607: -- 8i 9i backward compatibility issue with clob
608: -- l_temp_string := ' '||'IMPLIES ALLTRUE'||' '||'(';
609: l_temp_string := ' '||'REQUIRES ALLTRUE'||' '||'(';
610: DBMS_LOB.WRITEAPPEND(x_stmt_rule,length(l_temp_string) , l_temp_string);
611:
612: DBMS_LOB.APPEND(x_stmt_rule,l_outcome_stmt);
613: DBMS_LOB.FREETEMPORARY(l_outcome_stmt);
614: l_temp_string := ')';

Line 612: DBMS_LOB.APPEND(x_stmt_rule,l_outcome_stmt);

608: -- l_temp_string := ' '||'IMPLIES ALLTRUE'||' '||'(';
609: l_temp_string := ' '||'REQUIRES ALLTRUE'||' '||'(';
610: DBMS_LOB.WRITEAPPEND(x_stmt_rule,length(l_temp_string) , l_temp_string);
611:
612: DBMS_LOB.APPEND(x_stmt_rule,l_outcome_stmt);
613: DBMS_LOB.FREETEMPORARY(l_outcome_stmt);
614: l_temp_string := ')';
615: DBMS_LOB.WRITEAPPEND(x_stmt_rule,length(l_temp_string) , l_temp_string);
616:

Line 613: DBMS_LOB.FREETEMPORARY(l_outcome_stmt);

609: l_temp_string := ' '||'REQUIRES ALLTRUE'||' '||'(';
610: DBMS_LOB.WRITEAPPEND(x_stmt_rule,length(l_temp_string) , l_temp_string);
611:
612: DBMS_LOB.APPEND(x_stmt_rule,l_outcome_stmt);
613: DBMS_LOB.FREETEMPORARY(l_outcome_stmt);
614: l_temp_string := ')';
615: DBMS_LOB.WRITEAPPEND(x_stmt_rule,length(l_temp_string) , l_temp_string);
616:
617:

Line 615: DBMS_LOB.WRITEAPPEND(x_stmt_rule,length(l_temp_string) , l_temp_string);

611:
612: DBMS_LOB.APPEND(x_stmt_rule,l_outcome_stmt);
613: DBMS_LOB.FREETEMPORARY(l_outcome_stmt);
614: l_temp_string := ')';
615: DBMS_LOB.WRITEAPPEND(x_stmt_rule,length(l_temp_string) , l_temp_string);
616:
617:
618: --
619:

Line 867: DBMS_LOB.CREATETEMPORARY(l_rule_text, FALSE, DBMS_LOB.CALL);

863:
864: -- For Rules to be deleted, rule text is NOT required
865: IF l_deleted_flag = '1' THEN
866: -- l_rule_text := NULL;
867: DBMS_LOB.CREATETEMPORARY(l_rule_text, FALSE, DBMS_LOB.CALL);
868: ELSE
869:
870:
871: -- Generate the Rule Text for this Rule Id

Line 1160: DBMS_LOB.FREETEMPORARY(l_rule_text);

1156:
1157:
1158:
1159: -- Free the CLOB Memory now
1160: DBMS_LOB.FREETEMPORARY(l_rule_text);
1161:
1162: -- Standard call to get message count and if count is 1, get message info.
1163: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1164: