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

Line 488: destination_cursor := DBMS_SQL.OPEN_CURSOR;

484: IF(l_application_id IS NULL) THEN
485: l_application_id := FND_GLOBAL.RESP_APPL_ID;
486: END IF;
487:
488: destination_cursor := DBMS_SQL.OPEN_CURSOR;
489:
490:
491: --IF Instance Context is set, then append the where clause with an extra bind variable i.e
492: --AND INSTANCE_LABEL = :3

Line 504: DBMS_SQL.PARSE(destination_cursor, g_sRuleDetailSql,DBMS_SQL.native);

500: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
501: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'apply_rule :->g_sRuleDetailSql='||g_sRuleDetailSql, FALSE);
502: end if;
503:
504: DBMS_SQL.PARSE(destination_cursor, g_sRuleDetailSql,DBMS_SQL.native);
505: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);
506: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
507:
508: IF (m_instance_context = 'Y') THEN

Line 505: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);

501: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'apply_rule :->g_sRuleDetailSql='||g_sRuleDetailSql, FALSE);
502: end if;
503:
504: DBMS_SQL.PARSE(destination_cursor, g_sRuleDetailSql,DBMS_SQL.native);
505: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);
506: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
507:
508: IF (m_instance_context = 'Y') THEN
509: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);

Line 506: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);

502: end if;
503:
504: DBMS_SQL.PARSE(destination_cursor, g_sRuleDetailSql,DBMS_SQL.native);
505: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);
506: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
507:
508: IF (m_instance_context = 'Y') THEN
509: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
510: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);

Line 509: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);

505: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);
506: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
507:
508: IF (m_instance_context = 'Y') THEN
509: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
510: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
511: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
512:
513: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);

Line 510: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);

506: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
507:
508: IF (m_instance_context = 'Y') THEN
509: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
510: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
511: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
512:
513: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
514: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);

Line 511: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);

507:
508: IF (m_instance_context = 'Y') THEN
509: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
510: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
511: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
512:
513: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
514: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
515: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);

Line 513: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);

509: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
510: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
511: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
512:
513: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
514: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
515: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
516: END IF;
517:

Line 514: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);

510: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
511: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
512:
513: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
514: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
515: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
516: END IF;
517:
518: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);

Line 515: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);

511: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
512:
513: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
514: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
515: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
516: END IF;
517:
518: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
519: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);

Line 518: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);

514: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
515: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
516: END IF;
517:
518: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
519: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
520: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
521: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
522: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);

Line 519: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);

515: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
516: END IF;
517:
518: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
519: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
520: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
521: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
522: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
523: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);

Line 520: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);

516: END IF;
517:
518: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
519: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
520: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
521: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
522: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
523: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
524: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);

Line 521: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);

517:
518: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
519: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
520: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
521: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
522: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
523: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
524: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
525: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);

Line 522: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);

518: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
519: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
520: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
521: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
522: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
523: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
524: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
525: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);
526:

Line 523: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);

519: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
520: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
521: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
522: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
523: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
524: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
525: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);
526:
527: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);

Line 524: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);

520: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
521: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
522: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
523: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
524: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
525: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);
526:
527: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);
528:

Line 525: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);

521: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
522: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
523: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
524: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
525: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);
526:
527: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);
528:
529: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop

Line 527: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);

523: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
524: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
525: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);
526:
527: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);
528:
529: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop
530: l_isAnyActiveRule := true; --i.e Atleast one Rule is present.
531:

Line 529: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop

525: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);
526:
527: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);
528:
529: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop
530: l_isAnyActiveRule := true; --i.e Atleast one Rule is present.
531:
532: dbms_sql.column_value(destination_cursor, 1, l_result_type);
533: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );

Line 532: dbms_sql.column_value(destination_cursor, 1, l_result_type);

528:
529: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop
530: l_isAnyActiveRule := true; --i.e Atleast one Rule is present.
531:
532: dbms_sql.column_value(destination_cursor, 1, l_result_type);
533: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
534: dbms_sql.column_value(destination_cursor, 3, l_operator);
535: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
536: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);

Line 533: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );

529: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop
530: l_isAnyActiveRule := true; --i.e Atleast one Rule is present.
531:
532: dbms_sql.column_value(destination_cursor, 1, l_result_type);
533: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
534: dbms_sql.column_value(destination_cursor, 3, l_operator);
535: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
536: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
537: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);

Line 534: dbms_sql.column_value(destination_cursor, 3, l_operator);

530: l_isAnyActiveRule := true; --i.e Atleast one Rule is present.
531:
532: dbms_sql.column_value(destination_cursor, 1, l_result_type);
533: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
534: dbms_sql.column_value(destination_cursor, 3, l_operator);
535: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
536: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
537: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
538: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);

Line 535: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);

531:
532: dbms_sql.column_value(destination_cursor, 1, l_result_type);
533: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
534: dbms_sql.column_value(destination_cursor, 3, l_operator);
535: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
536: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
537: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
538: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
539: dbms_sql.column_value(destination_cursor, 8, l_useDefaultValueFlag);

Line 536: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);

532: dbms_sql.column_value(destination_cursor, 1, l_result_type);
533: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
534: dbms_sql.column_value(destination_cursor, 3, l_operator);
535: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
536: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
537: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
538: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
539: dbms_sql.column_value(destination_cursor, 8, l_useDefaultValueFlag);
540: m_multiRuleResultFlag := l_multiRuleResultFlag;

Line 537: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);

533: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
534: dbms_sql.column_value(destination_cursor, 3, l_operator);
535: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
536: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
537: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
538: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
539: dbms_sql.column_value(destination_cursor, 8, l_useDefaultValueFlag);
540: m_multiRuleResultFlag := l_multiRuleResultFlag;
541: m_useDefaultValueFlag := l_useDefaultValueFlag;

Line 538: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);

534: dbms_sql.column_value(destination_cursor, 3, l_operator);
535: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
536: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
537: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
538: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
539: dbms_sql.column_value(destination_cursor, 8, l_useDefaultValueFlag);
540: m_multiRuleResultFlag := l_multiRuleResultFlag;
541: m_useDefaultValueFlag := l_useDefaultValueFlag;
542:

Line 539: dbms_sql.column_value(destination_cursor, 8, l_useDefaultValueFlag);

535: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
536: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
537: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
538: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
539: dbms_sql.column_value(destination_cursor, 8, l_useDefaultValueFlag);
540: m_multiRuleResultFlag := l_multiRuleResultFlag;
541: m_useDefaultValueFlag := l_useDefaultValueFlag;
542:
543:

Line 550: params_cursor := DBMS_SQL.OPEN_CURSOR;

546: ELSE
547: l_ret_val := true;
548: END IF;
549:
550: params_cursor := DBMS_SQL.OPEN_CURSOR;
551:
552: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
553: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'apply_rule :->g_sCriteriaParamSql='||g_sCriteriaParamSql, FALSE);
554: end if;

Line 556: DBMS_SQL.PARSE(params_cursor, g_sCriteriaParamSql,DBMS_SQL.native);

552: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
553: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'apply_rule :->g_sCriteriaParamSql='||g_sCriteriaParamSql, FALSE);
554: end if;
555:
556: DBMS_SQL.PARSE(params_cursor, g_sCriteriaParamSql,DBMS_SQL.native);
557: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
558: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
559:
560: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);

Line 557: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);

553: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'apply_rule :->g_sCriteriaParamSql='||g_sCriteriaParamSql, FALSE);
554: end if;
555:
556: DBMS_SQL.PARSE(params_cursor, g_sCriteriaParamSql,DBMS_SQL.native);
557: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
558: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
559:
560: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
561: dbms_sql.define_column(params_cursor, 2, l_condition , 15);

Line 558: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);

554: end if;
555:
556: DBMS_SQL.PARSE(params_cursor, g_sCriteriaParamSql,DBMS_SQL.native);
557: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
558: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
559:
560: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
561: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
562: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);

Line 560: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);

556: DBMS_SQL.PARSE(params_cursor, g_sCriteriaParamSql,DBMS_SQL.native);
557: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
558: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
559:
560: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
561: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
562: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
563: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
564: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);

Line 561: dbms_sql.define_column(params_cursor, 2, l_condition , 15);

557: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
558: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
559:
560: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
561: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
562: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
563: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
564: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
565: dbms_sql.define_column(params_cursor, 6, l_criteria_id);

Line 562: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);

558: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
559:
560: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
561: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
562: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
563: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
564: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
565: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
566:

Line 563: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);

559:
560: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
561: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
562: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
563: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
564: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
565: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
566:
567: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);

Line 564: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);

560: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
561: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
562: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
563: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
564: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
565: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
566:
567: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
568:

Line 565: dbms_sql.define_column(params_cursor, 6, l_criteria_id);

561: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
562: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
563: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
564: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
565: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
566:
567: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
568:
569: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop

Line 567: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);

563: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
564: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
565: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
566:
567: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
568:
569: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
570: dbms_sql.column_value(params_cursor, 1, l_param_name );
571: dbms_sql.column_value(params_cursor, 2, l_condition );

Line 569: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop

565: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
566:
567: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
568:
569: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
570: dbms_sql.column_value(params_cursor, 1, l_param_name );
571: dbms_sql.column_value(params_cursor, 2, l_condition );
572: dbms_sql.column_value(params_cursor, 3, l_param_value);
573: dbms_sql.column_value(params_cursor, 4, l_data_type);

Line 570: dbms_sql.column_value(params_cursor, 1, l_param_name );

566:
567: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
568:
569: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
570: dbms_sql.column_value(params_cursor, 1, l_param_name );
571: dbms_sql.column_value(params_cursor, 2, l_condition );
572: dbms_sql.column_value(params_cursor, 3, l_param_value);
573: dbms_sql.column_value(params_cursor, 4, l_data_type);
574: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);

Line 571: dbms_sql.column_value(params_cursor, 2, l_condition );

567: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
568:
569: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
570: dbms_sql.column_value(params_cursor, 1, l_param_name );
571: dbms_sql.column_value(params_cursor, 2, l_condition );
572: dbms_sql.column_value(params_cursor, 3, l_param_value);
573: dbms_sql.column_value(params_cursor, 4, l_data_type);
574: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
575: dbms_sql.column_value(params_cursor, 6, l_criteria_id);

Line 572: dbms_sql.column_value(params_cursor, 3, l_param_value);

568:
569: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
570: dbms_sql.column_value(params_cursor, 1, l_param_name );
571: dbms_sql.column_value(params_cursor, 2, l_condition );
572: dbms_sql.column_value(params_cursor, 3, l_param_value);
573: dbms_sql.column_value(params_cursor, 4, l_data_type);
574: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
575: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
576:

Line 573: dbms_sql.column_value(params_cursor, 4, l_data_type);

569: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
570: dbms_sql.column_value(params_cursor, 1, l_param_name );
571: dbms_sql.column_value(params_cursor, 2, l_condition );
572: dbms_sql.column_value(params_cursor, 3, l_param_value);
573: dbms_sql.column_value(params_cursor, 4, l_data_type);
574: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
575: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
576:
577:

Line 574: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);

570: dbms_sql.column_value(params_cursor, 1, l_param_name );
571: dbms_sql.column_value(params_cursor, 2, l_condition );
572: dbms_sql.column_value(params_cursor, 3, l_param_value);
573: dbms_sql.column_value(params_cursor, 4, l_data_type);
574: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
575: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
576:
577:
578: if(l_param_name = 'APPLICATION') then

Line 575: dbms_sql.column_value(params_cursor, 6, l_criteria_id);

571: dbms_sql.column_value(params_cursor, 2, l_condition );
572: dbms_sql.column_value(params_cursor, 3, l_param_value);
573: dbms_sql.column_value(params_cursor, 4, l_data_type);
574: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
575: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
576:
577:
578: if(l_param_name = 'APPLICATION') then
579: if(NOT containsKey(g_parameter_list,'APPLICATION')) then

Line 624: DBMS_SQL.CLOSE_CURSOR(params_cursor);

620: l_ret_val := matchCriteria(l_param_name, l_condition, l_ParamMultiValueList,
621: l_data_type, g_parameter_list, l_case_sensitive) OR l_ret_val ;
622: END IF;
623: end loop;
624: DBMS_SQL.CLOSE_CURSOR(params_cursor);
625:
626: l_all_rule_retval := l_all_rule_retval OR l_ret_val;
627:
628: setResultValues(l_ret_val,

Line 651: DBMS_SQL.CLOSE_CURSOR(destination_cursor);

647: end if;
648:
649: end loop;
650:
651: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
652:
653: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
654: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'apply_rule :->Before calling setResultValues', FALSE);
655: end if;

Line 724: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN

720: fnd_message.set_name('FUN','NO_DEFAULT_VALUE_EXCEPTION');
721: app_exception.raise_exception;
722:
723: WHEN OTHERS THEN
724: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
725: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
726: END IF;
727: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
728: DBMS_SQL.CLOSE_CURSOR(params_cursor);

Line 725: DBMS_SQL.CLOSE_CURSOR(destination_cursor);

721: app_exception.raise_exception;
722:
723: WHEN OTHERS THEN
724: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
725: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
726: END IF;
727: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
728: DBMS_SQL.CLOSE_CURSOR(params_cursor);
729: END IF;

Line 727: IF DBMS_SQL.IS_OPEN(params_cursor) THEN

723: WHEN OTHERS THEN
724: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
725: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
726: END IF;
727: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
728: DBMS_SQL.CLOSE_CURSOR(params_cursor);
729: END IF;
730: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
731: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.APLY_RULE:->'||SQLERRM, FALSE);

Line 728: DBMS_SQL.CLOSE_CURSOR(params_cursor);

724: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
725: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
726: END IF;
727: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
728: DBMS_SQL.CLOSE_CURSOR(params_cursor);
729: END IF;
730: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
731: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.APLY_RULE:->'||SQLERRM, FALSE);
732: END IF;

Line 808: destination_cursor := DBMS_SQL.OPEN_CURSOR;

804: IF(l_application_id IS NULL) THEN
805: l_application_id := FND_GLOBAL.RESP_APPL_ID;
806: END IF;
807:
808: destination_cursor := DBMS_SQL.OPEN_CURSOR;
809:
810: --IF Instance Context is set, then append the where clause with an extra bind variable i.e
811: --AND INSTANCE_LABEL = :3
812:

Line 823: DBMS_SQL.PARSE(destination_cursor, g_sRuleDetailSql,DBMS_SQL.native);

819: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
820: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.APPLY_RULE Boolean:->g_sRuleDetailSql='||g_sRuleDetailSql, FALSE);
821: end if;
822:
823: DBMS_SQL.PARSE(destination_cursor, g_sRuleDetailSql,DBMS_SQL.native);
824: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);
825: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
826:
827: IF (m_instance_context = 'Y') THEN

Line 824: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);

820: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.APPLY_RULE Boolean:->g_sRuleDetailSql='||g_sRuleDetailSql, FALSE);
821: end if;
822:
823: DBMS_SQL.PARSE(destination_cursor, g_sRuleDetailSql,DBMS_SQL.native);
824: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);
825: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
826:
827: IF (m_instance_context = 'Y') THEN
828: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);

Line 825: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);

821: end if;
822:
823: DBMS_SQL.PARSE(destination_cursor, g_sRuleDetailSql,DBMS_SQL.native);
824: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);
825: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
826:
827: IF (m_instance_context = 'Y') THEN
828: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
829: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);

Line 828: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);

824: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);
825: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
826:
827: IF (m_instance_context = 'Y') THEN
828: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
829: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
830: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
831:
832: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);

Line 829: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);

825: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
826:
827: IF (m_instance_context = 'Y') THEN
828: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
829: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
830: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
831:
832: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
833: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);

Line 830: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);

826:
827: IF (m_instance_context = 'Y') THEN
828: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
829: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
830: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
831:
832: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
833: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
834: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);

Line 832: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);

828: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
829: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
830: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
831:
832: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
833: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
834: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
835:
836: END IF;

Line 833: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);

829: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
830: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
831:
832: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
833: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
834: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
835:
836: END IF;
837:

Line 834: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);

830: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
831:
832: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
833: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
834: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
835:
836: END IF;
837:
838:

Line 839: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);

835:
836: END IF;
837:
838:
839: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
840: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
841: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
842: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
843: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);

Line 840: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);

836: END IF;
837:
838:
839: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
840: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
841: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
842: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
843: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
844: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);

Line 841: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);

837:
838:
839: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
840: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
841: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
842: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
843: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
844: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
845: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);

Line 842: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);

838:
839: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
840: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
841: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
842: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
843: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
844: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
845: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
846: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);

Line 843: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);

839: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
840: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
841: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
842: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
843: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
844: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
845: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
846: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);
847:

Line 844: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);

840: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
841: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
842: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
843: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
844: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
845: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
846: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);
847:
848: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);

Line 845: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);

841: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
842: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
843: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
844: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
845: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
846: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);
847:
848: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);
849:

Line 846: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);

842: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
843: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
844: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
845: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
846: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);
847:
848: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);
849:
850: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop

Line 848: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);

844: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
845: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
846: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);
847:
848: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);
849:
850: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop
851: l_isAnyActiveRule := true; --i.e Atleast one Rule is present.
852:

Line 850: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop

846: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);
847:
848: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);
849:
850: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop
851: l_isAnyActiveRule := true; --i.e Atleast one Rule is present.
852:
853: dbms_sql.column_value(destination_cursor, 1, l_result_type);
854: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );

Line 853: dbms_sql.column_value(destination_cursor, 1, l_result_type);

849:
850: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop
851: l_isAnyActiveRule := true; --i.e Atleast one Rule is present.
852:
853: dbms_sql.column_value(destination_cursor, 1, l_result_type);
854: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
855: dbms_sql.column_value(destination_cursor, 3, l_operator);
856: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
857: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);

Line 854: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );

850: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop
851: l_isAnyActiveRule := true; --i.e Atleast one Rule is present.
852:
853: dbms_sql.column_value(destination_cursor, 1, l_result_type);
854: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
855: dbms_sql.column_value(destination_cursor, 3, l_operator);
856: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
857: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
858: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);

Line 855: dbms_sql.column_value(destination_cursor, 3, l_operator);

851: l_isAnyActiveRule := true; --i.e Atleast one Rule is present.
852:
853: dbms_sql.column_value(destination_cursor, 1, l_result_type);
854: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
855: dbms_sql.column_value(destination_cursor, 3, l_operator);
856: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
857: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
858: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
859: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);

Line 856: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);

852:
853: dbms_sql.column_value(destination_cursor, 1, l_result_type);
854: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
855: dbms_sql.column_value(destination_cursor, 3, l_operator);
856: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
857: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
858: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
859: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
860: dbms_sql.column_value(destination_cursor, 8, l_useDefaultValueFlag);

Line 857: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);

853: dbms_sql.column_value(destination_cursor, 1, l_result_type);
854: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
855: dbms_sql.column_value(destination_cursor, 3, l_operator);
856: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
857: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
858: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
859: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
860: dbms_sql.column_value(destination_cursor, 8, l_useDefaultValueFlag);
861: m_multiRuleResultFlag := l_multiRuleResultFlag;

Line 858: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);

854: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
855: dbms_sql.column_value(destination_cursor, 3, l_operator);
856: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
857: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
858: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
859: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
860: dbms_sql.column_value(destination_cursor, 8, l_useDefaultValueFlag);
861: m_multiRuleResultFlag := l_multiRuleResultFlag;
862: m_useDefaultValueFlag := l_useDefaultValueFlag;

Line 859: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);

855: dbms_sql.column_value(destination_cursor, 3, l_operator);
856: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
857: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
858: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
859: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
860: dbms_sql.column_value(destination_cursor, 8, l_useDefaultValueFlag);
861: m_multiRuleResultFlag := l_multiRuleResultFlag;
862: m_useDefaultValueFlag := l_useDefaultValueFlag;
863:

Line 860: dbms_sql.column_value(destination_cursor, 8, l_useDefaultValueFlag);

856: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
857: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
858: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
859: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
860: dbms_sql.column_value(destination_cursor, 8, l_useDefaultValueFlag);
861: m_multiRuleResultFlag := l_multiRuleResultFlag;
862: m_useDefaultValueFlag := l_useDefaultValueFlag;
863:
864: IF (L_OPERATOR = C_OR) THEN

Line 870: params_cursor := DBMS_SQL.OPEN_CURSOR;

866: ELSE
867: l_ret_val := true;
868: END IF;
869:
870: params_cursor := DBMS_SQL.OPEN_CURSOR;
871:
872: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
873: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.APPLY_RULE Boolean:->g_sCriteriaParamSql='||g_sCriteriaParamSql, FALSE);
874: end if;

Line 876: DBMS_SQL.PARSE(params_cursor, g_sCriteriaParamSql,DBMS_SQL.native);

872: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
873: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.APPLY_RULE Boolean:->g_sCriteriaParamSql='||g_sCriteriaParamSql, FALSE);
874: end if;
875:
876: DBMS_SQL.PARSE(params_cursor, g_sCriteriaParamSql,DBMS_SQL.native);
877: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
878: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
879:
880: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);

Line 877: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);

873: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.APPLY_RULE Boolean:->g_sCriteriaParamSql='||g_sCriteriaParamSql, FALSE);
874: end if;
875:
876: DBMS_SQL.PARSE(params_cursor, g_sCriteriaParamSql,DBMS_SQL.native);
877: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
878: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
879:
880: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
881: dbms_sql.define_column(params_cursor, 2, l_condition , 15);

Line 878: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);

874: end if;
875:
876: DBMS_SQL.PARSE(params_cursor, g_sCriteriaParamSql,DBMS_SQL.native);
877: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
878: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
879:
880: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
881: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
882: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);

Line 880: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);

876: DBMS_SQL.PARSE(params_cursor, g_sCriteriaParamSql,DBMS_SQL.native);
877: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
878: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
879:
880: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
881: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
882: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
883: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
884: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);

Line 881: dbms_sql.define_column(params_cursor, 2, l_condition , 15);

877: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
878: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
879:
880: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
881: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
882: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
883: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
884: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
885: dbms_sql.define_column(params_cursor, 6, l_criteria_id);

Line 882: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);

878: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
879:
880: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
881: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
882: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
883: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
884: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
885: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
886:

Line 883: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);

879:
880: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
881: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
882: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
883: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
884: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
885: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
886:
887: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);

Line 884: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);

880: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
881: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
882: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
883: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
884: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
885: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
886:
887: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
888:

Line 885: dbms_sql.define_column(params_cursor, 6, l_criteria_id);

881: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
882: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
883: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
884: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
885: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
886:
887: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
888:
889: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop

Line 887: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);

883: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
884: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
885: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
886:
887: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
888:
889: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
890: dbms_sql.column_value(params_cursor, 1, l_param_name );
891: dbms_sql.column_value(params_cursor, 2, l_condition );

Line 889: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop

885: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
886:
887: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
888:
889: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
890: dbms_sql.column_value(params_cursor, 1, l_param_name );
891: dbms_sql.column_value(params_cursor, 2, l_condition );
892: dbms_sql.column_value(params_cursor, 3, l_param_value);
893: dbms_sql.column_value(params_cursor, 4, l_data_type);

Line 890: dbms_sql.column_value(params_cursor, 1, l_param_name );

886:
887: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
888:
889: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
890: dbms_sql.column_value(params_cursor, 1, l_param_name );
891: dbms_sql.column_value(params_cursor, 2, l_condition );
892: dbms_sql.column_value(params_cursor, 3, l_param_value);
893: dbms_sql.column_value(params_cursor, 4, l_data_type);
894: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);

Line 891: dbms_sql.column_value(params_cursor, 2, l_condition );

887: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
888:
889: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
890: dbms_sql.column_value(params_cursor, 1, l_param_name );
891: dbms_sql.column_value(params_cursor, 2, l_condition );
892: dbms_sql.column_value(params_cursor, 3, l_param_value);
893: dbms_sql.column_value(params_cursor, 4, l_data_type);
894: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
895: dbms_sql.column_value(params_cursor, 6, l_criteria_id);

Line 892: dbms_sql.column_value(params_cursor, 3, l_param_value);

888:
889: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
890: dbms_sql.column_value(params_cursor, 1, l_param_name );
891: dbms_sql.column_value(params_cursor, 2, l_condition );
892: dbms_sql.column_value(params_cursor, 3, l_param_value);
893: dbms_sql.column_value(params_cursor, 4, l_data_type);
894: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
895: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
896:

Line 893: dbms_sql.column_value(params_cursor, 4, l_data_type);

889: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
890: dbms_sql.column_value(params_cursor, 1, l_param_name );
891: dbms_sql.column_value(params_cursor, 2, l_condition );
892: dbms_sql.column_value(params_cursor, 3, l_param_value);
893: dbms_sql.column_value(params_cursor, 4, l_data_type);
894: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
895: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
896:
897: if(l_param_name = 'APPLICATION') then

Line 894: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);

890: dbms_sql.column_value(params_cursor, 1, l_param_name );
891: dbms_sql.column_value(params_cursor, 2, l_condition );
892: dbms_sql.column_value(params_cursor, 3, l_param_value);
893: dbms_sql.column_value(params_cursor, 4, l_data_type);
894: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
895: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
896:
897: if(l_param_name = 'APPLICATION') then
898: if(NOT containsKey(g_parameter_list,'APPLICATION')) then

Line 895: dbms_sql.column_value(params_cursor, 6, l_criteria_id);

891: dbms_sql.column_value(params_cursor, 2, l_condition );
892: dbms_sql.column_value(params_cursor, 3, l_param_value);
893: dbms_sql.column_value(params_cursor, 4, l_data_type);
894: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
895: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
896:
897: if(l_param_name = 'APPLICATION') then
898: if(NOT containsKey(g_parameter_list,'APPLICATION')) then
899: add_parameter('APPLICATION' , FND_GLOBAL.RESP_APPL_ID);

Line 943: DBMS_SQL.CLOSE_CURSOR(params_cursor);

939: l_ret_val := matchCriteria(l_param_name, l_condition, l_ParamMultiValueList,
940: l_data_type, g_parameter_list, l_case_sensitive) OR l_ret_val ;
941: END IF;
942: end loop;
943: DBMS_SQL.CLOSE_CURSOR(params_cursor);
944:
945: l_all_rule_retval := l_all_rule_retval OR l_ret_val;
946:
947: setResultValues(l_ret_val,

Line 970: DBMS_SQL.CLOSE_CURSOR(destination_cursor);

966: end if;
967:
968: end loop;
969:
970: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
971:
972: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
973: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.APPLY_RULE Boolean:->before setResultValues', FALSE);
974: end if;

Line 1041: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN

1037:
1038: RAISE;
1039:
1040: WHEN OTHERS THEN
1041: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
1042: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
1043: END IF;
1044: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
1045: DBMS_SQL.CLOSE_CURSOR(params_cursor);

Line 1042: DBMS_SQL.CLOSE_CURSOR(destination_cursor);

1038: RAISE;
1039:
1040: WHEN OTHERS THEN
1041: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
1042: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
1043: END IF;
1044: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
1045: DBMS_SQL.CLOSE_CURSOR(params_cursor);
1046: END IF;

Line 1044: IF DBMS_SQL.IS_OPEN(params_cursor) THEN

1040: WHEN OTHERS THEN
1041: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
1042: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
1043: END IF;
1044: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
1045: DBMS_SQL.CLOSE_CURSOR(params_cursor);
1046: END IF;
1047: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1048: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.APLY_RULE Boolean:->'||SQLERRM, FALSE);

Line 1045: DBMS_SQL.CLOSE_CURSOR(params_cursor);

1041: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
1042: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
1043: END IF;
1044: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
1045: DBMS_SQL.CLOSE_CURSOR(params_cursor);
1046: END IF;
1047: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1048: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.APLY_RULE Boolean:->'||SQLERRM, FALSE);
1049: END IF;

Line 1326: params_cursor := DBMS_SQL.OPEN_CURSOR;

1322: return C_STRINGS;
1323:
1324: elsif (C_VALUESET = p_ObjectType) then
1325:
1326: params_cursor := DBMS_SQL.OPEN_CURSOR;
1327: DBMS_SQL.PARSE(params_cursor, g_sValueSetSql,DBMS_SQL.native);
1328: dbms_sql.bind_variable(params_cursor , '1' , p_RuleObjectId);
1329:
1330: dbms_sql.define_column(params_cursor, 1, l_ValueSetType , 10);

Line 1327: DBMS_SQL.PARSE(params_cursor, g_sValueSetSql,DBMS_SQL.native);

1323:
1324: elsif (C_VALUESET = p_ObjectType) then
1325:
1326: params_cursor := DBMS_SQL.OPEN_CURSOR;
1327: DBMS_SQL.PARSE(params_cursor, g_sValueSetSql,DBMS_SQL.native);
1328: dbms_sql.bind_variable(params_cursor , '1' , p_RuleObjectId);
1329:
1330: dbms_sql.define_column(params_cursor, 1, l_ValueSetType , 10);
1331:

Line 1328: dbms_sql.bind_variable(params_cursor , '1' , p_RuleObjectId);

1324: elsif (C_VALUESET = p_ObjectType) then
1325:
1326: params_cursor := DBMS_SQL.OPEN_CURSOR;
1327: DBMS_SQL.PARSE(params_cursor, g_sValueSetSql,DBMS_SQL.native);
1328: dbms_sql.bind_variable(params_cursor , '1' , p_RuleObjectId);
1329:
1330: dbms_sql.define_column(params_cursor, 1, l_ValueSetType , 10);
1331:
1332: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);

Line 1330: dbms_sql.define_column(params_cursor, 1, l_ValueSetType , 10);

1326: params_cursor := DBMS_SQL.OPEN_CURSOR;
1327: DBMS_SQL.PARSE(params_cursor, g_sValueSetSql,DBMS_SQL.native);
1328: dbms_sql.bind_variable(params_cursor , '1' , p_RuleObjectId);
1329:
1330: dbms_sql.define_column(params_cursor, 1, l_ValueSetType , 10);
1331:
1332: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
1333:
1334: if(dbms_sql.fetch_rows(params_cursor) > 0 ) then

Line 1332: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);

1328: dbms_sql.bind_variable(params_cursor , '1' , p_RuleObjectId);
1329:
1330: dbms_sql.define_column(params_cursor, 1, l_ValueSetType , 10);
1331:
1332: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
1333:
1334: if(dbms_sql.fetch_rows(params_cursor) > 0 ) then
1335: dbms_sql.column_value(params_cursor, 1, l_ValueSetType );
1336: end if;

Line 1334: if(dbms_sql.fetch_rows(params_cursor) > 0 ) then

1330: dbms_sql.define_column(params_cursor, 1, l_ValueSetType , 10);
1331:
1332: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
1333:
1334: if(dbms_sql.fetch_rows(params_cursor) > 0 ) then
1335: dbms_sql.column_value(params_cursor, 1, l_ValueSetType );
1336: end if;
1337: end if;
1338:

Line 1335: dbms_sql.column_value(params_cursor, 1, l_ValueSetType );

1331:
1332: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
1333:
1334: if(dbms_sql.fetch_rows(params_cursor) > 0 ) then
1335: dbms_sql.column_value(params_cursor, 1, l_ValueSetType );
1336: end if;
1337: end if;
1338:
1339: DBMS_SQL.CLOSE_CURSOR(params_cursor);

Line 1339: DBMS_SQL.CLOSE_CURSOR(params_cursor);

1335: dbms_sql.column_value(params_cursor, 1, l_ValueSetType );
1336: end if;
1337: end if;
1338:
1339: DBMS_SQL.CLOSE_CURSOR(params_cursor);
1340:
1341: if( l_ValueSetType = 'C' ) then return C_STRINGS;
1342: elsif ( l_ValueSetType = 'N' ) then return C_NUMERIC;
1343: elsif ( l_ValueSetType = 'D' OR l_ValueSetType = 'T' OR l_ValueSetType = 't' OR l_ValueSetType = 'X') then return C_DATE;

Line 1362: IF DBMS_SQL.IS_OPEN(params_cursor) THEN

1358:
1359: RAISE;
1360:
1361: WHEN OTHERS THEN
1362: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
1363: DBMS_SQL.CLOSE_CURSOR(params_cursor);
1364: END IF;
1365: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1366: fnd_log.message(FND_LOG.LEVEL_EXCEPTION, 'FUN_RULE_PUB.getResultValueDataType:->g_sValueSetSql='||g_sValueSetSql, FALSE);

Line 1363: DBMS_SQL.CLOSE_CURSOR(params_cursor);

1359: RAISE;
1360:
1361: WHEN OTHERS THEN
1362: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
1363: DBMS_SQL.CLOSE_CURSOR(params_cursor);
1364: END IF;
1365: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1366: fnd_log.message(FND_LOG.LEVEL_EXCEPTION, 'FUN_RULE_PUB.getResultValueDataType:->g_sValueSetSql='||g_sValueSetSql, FALSE);
1367: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getResultValueDataType:->'||SQLERRM, FALSE);

Line 1390: params_cursor := DBMS_SQL.OPEN_CURSOR;

1386: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1387: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.getMultiValueParamsArray', FALSE);
1388: end if;
1389:
1390: params_cursor := DBMS_SQL.OPEN_CURSOR;
1391: DBMS_SQL.PARSE(params_cursor, g_sMultiCriteriaParamValueSql,DBMS_SQL.native);
1392: dbms_sql.bind_variable(params_cursor , '1' , p_rule_detail_id);
1393: dbms_sql.bind_variable(params_cursor , '2' , p_rule_criteria_id);
1394:

Line 1391: DBMS_SQL.PARSE(params_cursor, g_sMultiCriteriaParamValueSql,DBMS_SQL.native);

1387: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.getMultiValueParamsArray', FALSE);
1388: end if;
1389:
1390: params_cursor := DBMS_SQL.OPEN_CURSOR;
1391: DBMS_SQL.PARSE(params_cursor, g_sMultiCriteriaParamValueSql,DBMS_SQL.native);
1392: dbms_sql.bind_variable(params_cursor , '1' , p_rule_detail_id);
1393: dbms_sql.bind_variable(params_cursor , '2' , p_rule_criteria_id);
1394:
1395: dbms_sql.define_column(params_cursor, 1, l_param_value , 1024);

Line 1392: dbms_sql.bind_variable(params_cursor , '1' , p_rule_detail_id);

1388: end if;
1389:
1390: params_cursor := DBMS_SQL.OPEN_CURSOR;
1391: DBMS_SQL.PARSE(params_cursor, g_sMultiCriteriaParamValueSql,DBMS_SQL.native);
1392: dbms_sql.bind_variable(params_cursor , '1' , p_rule_detail_id);
1393: dbms_sql.bind_variable(params_cursor , '2' , p_rule_criteria_id);
1394:
1395: dbms_sql.define_column(params_cursor, 1, l_param_value , 1024);
1396:

Line 1393: dbms_sql.bind_variable(params_cursor , '2' , p_rule_criteria_id);

1389:
1390: params_cursor := DBMS_SQL.OPEN_CURSOR;
1391: DBMS_SQL.PARSE(params_cursor, g_sMultiCriteriaParamValueSql,DBMS_SQL.native);
1392: dbms_sql.bind_variable(params_cursor , '1' , p_rule_detail_id);
1393: dbms_sql.bind_variable(params_cursor , '2' , p_rule_criteria_id);
1394:
1395: dbms_sql.define_column(params_cursor, 1, l_param_value , 1024);
1396:
1397: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);

Line 1395: dbms_sql.define_column(params_cursor, 1, l_param_value , 1024);

1391: DBMS_SQL.PARSE(params_cursor, g_sMultiCriteriaParamValueSql,DBMS_SQL.native);
1392: dbms_sql.bind_variable(params_cursor , '1' , p_rule_detail_id);
1393: dbms_sql.bind_variable(params_cursor , '2' , p_rule_criteria_id);
1394:
1395: dbms_sql.define_column(params_cursor, 1, l_param_value , 1024);
1396:
1397: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
1398:
1399: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop

Line 1397: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);

1393: dbms_sql.bind_variable(params_cursor , '2' , p_rule_criteria_id);
1394:
1395: dbms_sql.define_column(params_cursor, 1, l_param_value , 1024);
1396:
1397: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
1398:
1399: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
1400: dbms_sql.column_value(params_cursor, 1, l_param_value );
1401: p_multi_param_value(l_counter) := l_param_value;

Line 1399: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop

1395: dbms_sql.define_column(params_cursor, 1, l_param_value , 1024);
1396:
1397: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
1398:
1399: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
1400: dbms_sql.column_value(params_cursor, 1, l_param_value );
1401: p_multi_param_value(l_counter) := l_param_value;
1402: l_counter := l_counter + 1;
1403: end loop;

Line 1400: dbms_sql.column_value(params_cursor, 1, l_param_value );

1396:
1397: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
1398:
1399: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
1400: dbms_sql.column_value(params_cursor, 1, l_param_value );
1401: p_multi_param_value(l_counter) := l_param_value;
1402: l_counter := l_counter + 1;
1403: end loop;
1404:

Line 1405: DBMS_SQL.CLOSE_CURSOR(params_cursor);

1401: p_multi_param_value(l_counter) := l_param_value;
1402: l_counter := l_counter + 1;
1403: end loop;
1404:
1405: DBMS_SQL.CLOSE_CURSOR(params_cursor);
1406:
1407: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1408: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_PUB.getMultiValueParamsArray', FALSE);
1409: end if;

Line 1421: IF DBMS_SQL.IS_OPEN(params_cursor) THEN

1417:
1418: RAISE;
1419:
1420: WHEN OTHERS THEN
1421: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
1422: DBMS_SQL.CLOSE_CURSOR(params_cursor);
1423: END IF;
1424: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1425: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getMultiValueParamsArray:->g_sMultiCriteriaParamValueSql='||g_sMultiCriteriaParamValueSql, FALSE);

Line 1422: DBMS_SQL.CLOSE_CURSOR(params_cursor);

1418: RAISE;
1419:
1420: WHEN OTHERS THEN
1421: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
1422: DBMS_SQL.CLOSE_CURSOR(params_cursor);
1423: END IF;
1424: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1425: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getMultiValueParamsArray:->g_sMultiCriteriaParamValueSql='||g_sMultiCriteriaParamValueSql, FALSE);
1426: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getMultiValueParamsArray:->'||SQLERRM, FALSE);

Line 1501: source_cursor := dbms_sql.open_cursor;

1497: sDFFTableName := i.application_table_name;
1498: end loop;
1499:
1500: -- Prepare a cursor to select from the source table:
1501: source_cursor := dbms_sql.open_cursor;
1502:
1503: /*If the Rule Object is an instance, then query the DFF table with RULE_OBJECT_ID as well.*/
1504:
1505: if(m_instance_context = 'Y') then

Line 1506: DBMS_SQL.PARSE(source_cursor,

1502:
1503: /*If the Rule Object is an instance, then query the DFF table with RULE_OBJECT_ID as well.*/
1504:
1505: if(m_instance_context = 'Y') then
1506: DBMS_SQL.PARSE(source_cursor,
1507: 'SELECT DFF.RULE_DETAIL_ID, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2,
1508: ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7,
1509: ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
1510: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15 , RULE_NAME , RESULT_APPLICATION_ID

Line 1513: , DBMS_SQL.native);

1509: ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
1510: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15 , RULE_NAME , RESULT_APPLICATION_ID
1511: FROM '|| sDFFTableName ||' DFF , FUN_RULE_DETAILS FRD
1512: WHERE DFF.RULE_DETAIL_ID = :1 AND DFF.RULE_OBJECT_ID = :2 AND DFF.RULE_DETAIL_ID = FRD.RULE_DETAIL_ID'
1513: , DBMS_SQL.native);
1514: else
1515: DBMS_SQL.PARSE(source_cursor,
1516: 'SELECT DFF.RULE_DETAIL_ID, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2,
1517: ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7,

Line 1515: DBMS_SQL.PARSE(source_cursor,

1511: FROM '|| sDFFTableName ||' DFF , FUN_RULE_DETAILS FRD
1512: WHERE DFF.RULE_DETAIL_ID = :1 AND DFF.RULE_OBJECT_ID = :2 AND DFF.RULE_DETAIL_ID = FRD.RULE_DETAIL_ID'
1513: , DBMS_SQL.native);
1514: else
1515: DBMS_SQL.PARSE(source_cursor,
1516: 'SELECT DFF.RULE_DETAIL_ID, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2,
1517: ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7,
1518: ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
1519: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15 , RULE_NAME , RESULT_APPLICATION_ID

Line 1522: , DBMS_SQL.native);

1518: ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
1519: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15 , RULE_NAME , RESULT_APPLICATION_ID
1520: FROM '|| sDFFTableName ||' DFF , FUN_RULE_DETAILS FRD
1521: WHERE DFF.RULE_DETAIL_ID = :1 AND DFF.RULE_DETAIL_ID = FRD.RULE_DETAIL_ID'
1522: , DBMS_SQL.native);
1523: end if;
1524:
1525: dbms_sql.bind_variable(source_cursor , '1' , p_RuleDetailId);
1526:

Line 1525: dbms_sql.bind_variable(source_cursor , '1' , p_RuleDetailId);

1521: WHERE DFF.RULE_DETAIL_ID = :1 AND DFF.RULE_DETAIL_ID = FRD.RULE_DETAIL_ID'
1522: , DBMS_SQL.native);
1523: end if;
1524:
1525: dbms_sql.bind_variable(source_cursor , '1' , p_RuleDetailId);
1526:
1527: if(m_instance_context = 'Y') then
1528: dbms_sql.bind_variable(source_cursor , '2' , m_ruleObjectId);
1529: end if;

Line 1528: dbms_sql.bind_variable(source_cursor , '2' , m_ruleObjectId);

1524:
1525: dbms_sql.bind_variable(source_cursor , '1' , p_RuleDetailId);
1526:
1527: if(m_instance_context = 'Y') then
1528: dbms_sql.bind_variable(source_cursor , '2' , m_ruleObjectId);
1529: end if;
1530:
1531: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);
1532: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);

Line 1531: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);

1527: if(m_instance_context = 'Y') then
1528: dbms_sql.bind_variable(source_cursor , '2' , m_ruleObjectId);
1529: end if;
1530:
1531: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);
1532: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);
1533: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1534: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1535: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);

Line 1532: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);

1528: dbms_sql.bind_variable(source_cursor , '2' , m_ruleObjectId);
1529: end if;
1530:
1531: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);
1532: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);
1533: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1534: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1535: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1536: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);

Line 1533: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);

1529: end if;
1530:
1531: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);
1532: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);
1533: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1534: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1535: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1536: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1537: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);

Line 1534: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);

1530:
1531: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);
1532: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);
1533: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1534: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1535: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1536: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1537: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1538: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);

Line 1535: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);

1531: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);
1532: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);
1533: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1534: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1535: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1536: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1537: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1538: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1539: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);

Line 1536: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);

1532: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);
1533: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1534: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1535: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1536: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1537: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1538: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1539: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);
1540: DBMS_SQL.DEFINE_COLUMN(source_cursor, 18, m_ruleName , 80);

Line 1537: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);

1533: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1534: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1535: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1536: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1537: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1538: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1539: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);
1540: DBMS_SQL.DEFINE_COLUMN(source_cursor, 18, m_ruleName , 80);
1541: DBMS_SQL.DEFINE_COLUMN(source_cursor, 19, m_resultApplicationId);

Line 1538: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);

1534: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1535: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1536: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1537: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1538: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1539: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);
1540: DBMS_SQL.DEFINE_COLUMN(source_cursor, 18, m_ruleName , 80);
1541: DBMS_SQL.DEFINE_COLUMN(source_cursor, 19, m_resultApplicationId);
1542:

Line 1539: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);

1535: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1536: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1537: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1538: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1539: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);
1540: DBMS_SQL.DEFINE_COLUMN(source_cursor, 18, m_ruleName , 80);
1541: DBMS_SQL.DEFINE_COLUMN(source_cursor, 19, m_resultApplicationId);
1542:
1543:

Line 1540: DBMS_SQL.DEFINE_COLUMN(source_cursor, 18, m_ruleName , 80);

1536: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1537: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1538: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1539: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);
1540: DBMS_SQL.DEFINE_COLUMN(source_cursor, 18, m_ruleName , 80);
1541: DBMS_SQL.DEFINE_COLUMN(source_cursor, 19, m_resultApplicationId);
1542:
1543:
1544: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);

Line 1541: DBMS_SQL.DEFINE_COLUMN(source_cursor, 19, m_resultApplicationId);

1537: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1538: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1539: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);
1540: DBMS_SQL.DEFINE_COLUMN(source_cursor, 18, m_ruleName , 80);
1541: DBMS_SQL.DEFINE_COLUMN(source_cursor, 19, m_resultApplicationId);
1542:
1543:
1544: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1545:

Line 1544: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);

1540: DBMS_SQL.DEFINE_COLUMN(source_cursor, 18, m_ruleName , 80);
1541: DBMS_SQL.DEFINE_COLUMN(source_cursor, 19, m_resultApplicationId);
1542:
1543:
1544: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1545:
1546: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1547: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1548: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);

Line 1546: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop

1542:
1543:
1544: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1545:
1546: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1547: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1548: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1549: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1550: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);

Line 1547: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);

1543:
1544: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1545:
1546: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1547: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1548: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1549: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1550: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1551: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);

Line 1548: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);

1544: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1545:
1546: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1547: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1548: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1549: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1550: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1551: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1552: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);

Line 1549: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);

1545:
1546: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1547: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1548: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1549: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1550: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1551: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1552: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1553: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);

Line 1550: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);

1546: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1547: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1548: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1549: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1550: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1551: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1552: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1553: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1554: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);

Line 1551: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);

1547: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1548: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1549: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1550: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1551: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1552: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1553: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1554: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);
1555: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);

Line 1552: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);

1548: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1549: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1550: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1551: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1552: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1553: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1554: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);
1555: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);
1556: DBMS_SQL.column_value(source_cursor, 18, m_ruleName);

Line 1553: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);

1549: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1550: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1551: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1552: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1553: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1554: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);
1555: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);
1556: DBMS_SQL.column_value(source_cursor, 18, m_ruleName);
1557: DBMS_SQL.column_value(source_cursor, 19, m_resultApplicationId);

Line 1554: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);

1550: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1551: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1552: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1553: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1554: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);
1555: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);
1556: DBMS_SQL.column_value(source_cursor, 18, m_ruleName);
1557: DBMS_SQL.column_value(source_cursor, 19, m_resultApplicationId);
1558:

Line 1555: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);

1551: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1552: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1553: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1554: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);
1555: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);
1556: DBMS_SQL.column_value(source_cursor, 18, m_ruleName);
1557: DBMS_SQL.column_value(source_cursor, 19, m_resultApplicationId);
1558:
1559: m_ruleDetailId := l_RuleDetailId;

Line 1556: DBMS_SQL.column_value(source_cursor, 18, m_ruleName);

1552: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1553: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1554: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);
1555: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);
1556: DBMS_SQL.column_value(source_cursor, 18, m_ruleName);
1557: DBMS_SQL.column_value(source_cursor, 19, m_resultApplicationId);
1558:
1559: m_ruleDetailId := l_RuleDetailId;
1560: -- m_resultValue := m_attributeCategory;

Line 1557: DBMS_SQL.column_value(source_cursor, 19, m_resultApplicationId);

1553: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1554: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);
1555: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);
1556: DBMS_SQL.column_value(source_cursor, 18, m_ruleName);
1557: DBMS_SQL.column_value(source_cursor, 19, m_resultApplicationId);
1558:
1559: m_ruleDetailId := l_RuleDetailId;
1560: -- m_resultValue := m_attributeCategory;
1561: fnd_flex_descval.set_column_value('ATTRIBUTE_CATEGORY', m_attributeCategory);

Line 1589: DBMS_SQL.CLOSE_CURSOR(source_cursor);

1585: END IF;
1586:
1587: end loop;
1588:
1589: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1590:
1591: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1592: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_PUB.getDFFResultValue', FALSE);
1593: end if;

Line 1607: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

1603:
1604: RAISE;
1605:
1606: WHEN OTHERS THEN
1607: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
1608: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1609: END IF;
1610: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1611: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getDFFResultValue:->'||SQLERRM, FALSE);

Line 1608: DBMS_SQL.CLOSE_CURSOR(source_cursor);

1604: RAISE;
1605:
1606: WHEN OTHERS THEN
1607: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
1608: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1609: END IF;
1610: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1611: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getDFFResultValue:->'||SQLERRM, FALSE);
1612: END IF;

Line 1652: source_cursor := dbms_sql.open_cursor;

1648: sDFFTableName := i.application_table_name;
1649: end loop;
1650:
1651: -- Prepare a cursor to select from the source table:
1652: source_cursor := dbms_sql.open_cursor;
1653:
1654: /*If the Rule Object is an instance, then query the DFF table with RULE_OBJECT_ID as well.*/
1655:
1656: if(m_instance_context = 'Y') then

Line 1657: DBMS_SQL.PARSE(source_cursor,

1653:
1654: /*If the Rule Object is an instance, then query the DFF table with RULE_OBJECT_ID as well.*/
1655:
1656: if(m_instance_context = 'Y') then
1657: DBMS_SQL.PARSE(source_cursor,
1658: 'SELECT DFF.RULE_DETAIL_ID, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2,
1659: ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7,
1660: ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
1661: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15

Line 1664: , DBMS_SQL.native);

1660: ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
1661: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15
1662: FROM '|| sDFFTableName ||' DFF
1663: WHERE DFF.RULE_DETAIL_ID = -99 AND RULE_OBJECT_ID = :1'
1664: , DBMS_SQL.native);
1665: else
1666: DBMS_SQL.PARSE(source_cursor,
1667: 'SELECT DFF.RULE_DETAIL_ID, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2,
1668: ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7,

Line 1666: DBMS_SQL.PARSE(source_cursor,

1662: FROM '|| sDFFTableName ||' DFF
1663: WHERE DFF.RULE_DETAIL_ID = -99 AND RULE_OBJECT_ID = :1'
1664: , DBMS_SQL.native);
1665: else
1666: DBMS_SQL.PARSE(source_cursor,
1667: 'SELECT DFF.RULE_DETAIL_ID, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2,
1668: ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7,
1669: ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
1670: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15

Line 1673: , DBMS_SQL.native);

1669: ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
1670: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15
1671: FROM '|| sDFFTableName ||' DFF
1672: WHERE DFF.RULE_DETAIL_ID = -99 '
1673: , DBMS_SQL.native);
1674:
1675: end if;
1676:
1677: if(m_instance_context = 'Y') then

Line 1678: dbms_sql.bind_variable(source_cursor , '1' , m_ruleObjectId);

1674:
1675: end if;
1676:
1677: if(m_instance_context = 'Y') then
1678: dbms_sql.bind_variable(source_cursor , '1' , m_ruleObjectId);
1679: end if;
1680:
1681:
1682: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);

Line 1682: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);

1678: dbms_sql.bind_variable(source_cursor , '1' , m_ruleObjectId);
1679: end if;
1680:
1681:
1682: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);
1683: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);
1684: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1685: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1686: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);

Line 1683: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);

1679: end if;
1680:
1681:
1682: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);
1683: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);
1684: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1685: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1686: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1687: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);

Line 1684: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);

1680:
1681:
1682: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);
1683: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);
1684: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1685: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1686: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1687: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1688: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);

Line 1685: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);

1681:
1682: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);
1683: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);
1684: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1685: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1686: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1687: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1688: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1689: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);

Line 1686: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);

1682: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);
1683: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);
1684: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1685: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1686: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1687: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1688: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1689: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1690: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);

Line 1687: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);

1683: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);
1684: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1685: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1686: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1687: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1688: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1689: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1690: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);
1691:

Line 1688: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);

1684: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1685: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1686: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1687: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1688: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1689: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1690: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);
1691:
1692: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);

Line 1689: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);

1685: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1686: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1687: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1688: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1689: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1690: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);
1691:
1692: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1693:

Line 1690: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);

1686: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1687: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1688: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1689: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1690: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);
1691:
1692: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1693:
1694: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop

Line 1692: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);

1688: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1689: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1690: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);
1691:
1692: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1693:
1694: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1695: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1696: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);

Line 1694: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop

1690: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);
1691:
1692: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1693:
1694: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1695: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1696: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1697: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1698: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);

Line 1695: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);

1691:
1692: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1693:
1694: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1695: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1696: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1697: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1698: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1699: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);

Line 1696: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);

1692: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1693:
1694: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1695: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1696: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1697: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1698: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1699: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1700: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);

Line 1697: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);

1693:
1694: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1695: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1696: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1697: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1698: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1699: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1700: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1701: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);

Line 1698: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);

1694: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1695: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1696: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1697: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1698: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1699: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1700: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1701: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1702: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);

Line 1699: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);

1695: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1696: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1697: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1698: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1699: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1700: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1701: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1702: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);
1703: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);

Line 1700: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);

1696: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1697: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1698: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1699: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1700: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1701: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1702: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);
1703: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);
1704:

Line 1701: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);

1697: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1698: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1699: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1700: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1701: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1702: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);
1703: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);
1704:
1705: m_ruleDetailId := -99;

Line 1702: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);

1698: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1699: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1700: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1701: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1702: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);
1703: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);
1704:
1705: m_ruleDetailId := -99;
1706: m_ruleName := 'Default Result';

Line 1703: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);

1699: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1700: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1701: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1702: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);
1703: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);
1704:
1705: m_ruleDetailId := -99;
1706: m_ruleName := 'Default Result';
1707: -- m_resultValue := m_attributeCategory;

Line 1735: DBMS_SQL.CLOSE_CURSOR(source_cursor);

1731: END IF;
1732:
1733: end loop;
1734:
1735: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1736:
1737: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1738: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_PUB.getDFFDefaultValue', FALSE);
1739: end if;

Line 1745: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

1741: return m_resultValue;
1742:
1743: EXCEPTION
1744: WHEN OTHERS THEN
1745: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
1746: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1747: END IF;
1748: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1749: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getDFFDefaultValue:->'||SQLERRM, FALSE);

Line 1746: DBMS_SQL.CLOSE_CURSOR(source_cursor);

1742:
1743: EXCEPTION
1744: WHEN OTHERS THEN
1745: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
1746: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1747: END IF;
1748: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1749: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getDFFDefaultValue:->'||SQLERRM, FALSE);
1750: END IF;

Line 1772: source_cursor := DBMS_SQL.OPEN_CURSOR;

1768: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1769: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.getResultValue:->p_ruleDetailId='||to_char(p_ruleDetailId)||'***p_ObjectType='||p_ObjectType, FALSE);
1770: end if;
1771:
1772: source_cursor := DBMS_SQL.OPEN_CURSOR;
1773:
1774: DBMS_SQL.PARSE(source_cursor, g_sResultValuesSql, DBMS_SQL.native);
1775: dbms_sql.bind_variable(source_cursor , '1' , p_ruleDetailId);
1776:

Line 1774: DBMS_SQL.PARSE(source_cursor, g_sResultValuesSql, DBMS_SQL.native);

1770: end if;
1771:
1772: source_cursor := DBMS_SQL.OPEN_CURSOR;
1773:
1774: DBMS_SQL.PARSE(source_cursor, g_sResultValuesSql, DBMS_SQL.native);
1775: dbms_sql.bind_variable(source_cursor , '1' , p_ruleDetailId);
1776:
1777: dbms_sql.define_column(source_cursor, 1, l_rule_detail_id);
1778: dbms_sql.define_column(source_cursor, 2, l_result_value , 1024);

Line 1775: dbms_sql.bind_variable(source_cursor , '1' , p_ruleDetailId);

1771:
1772: source_cursor := DBMS_SQL.OPEN_CURSOR;
1773:
1774: DBMS_SQL.PARSE(source_cursor, g_sResultValuesSql, DBMS_SQL.native);
1775: dbms_sql.bind_variable(source_cursor , '1' , p_ruleDetailId);
1776:
1777: dbms_sql.define_column(source_cursor, 1, l_rule_detail_id);
1778: dbms_sql.define_column(source_cursor, 2, l_result_value , 1024);
1779: dbms_sql.define_column(source_cursor, 3, l_result_application_id);

Line 1777: dbms_sql.define_column(source_cursor, 1, l_rule_detail_id);

1773:
1774: DBMS_SQL.PARSE(source_cursor, g_sResultValuesSql, DBMS_SQL.native);
1775: dbms_sql.bind_variable(source_cursor , '1' , p_ruleDetailId);
1776:
1777: dbms_sql.define_column(source_cursor, 1, l_rule_detail_id);
1778: dbms_sql.define_column(source_cursor, 2, l_result_value , 1024);
1779: dbms_sql.define_column(source_cursor, 3, l_result_application_id);
1780: dbms_sql.define_column(source_cursor, 4, l_rule_name , 30);
1781:

Line 1778: dbms_sql.define_column(source_cursor, 2, l_result_value , 1024);

1774: DBMS_SQL.PARSE(source_cursor, g_sResultValuesSql, DBMS_SQL.native);
1775: dbms_sql.bind_variable(source_cursor , '1' , p_ruleDetailId);
1776:
1777: dbms_sql.define_column(source_cursor, 1, l_rule_detail_id);
1778: dbms_sql.define_column(source_cursor, 2, l_result_value , 1024);
1779: dbms_sql.define_column(source_cursor, 3, l_result_application_id);
1780: dbms_sql.define_column(source_cursor, 4, l_rule_name , 30);
1781:
1782: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);

Line 1779: dbms_sql.define_column(source_cursor, 3, l_result_application_id);

1775: dbms_sql.bind_variable(source_cursor , '1' , p_ruleDetailId);
1776:
1777: dbms_sql.define_column(source_cursor, 1, l_rule_detail_id);
1778: dbms_sql.define_column(source_cursor, 2, l_result_value , 1024);
1779: dbms_sql.define_column(source_cursor, 3, l_result_application_id);
1780: dbms_sql.define_column(source_cursor, 4, l_rule_name , 30);
1781:
1782: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1783:

Line 1780: dbms_sql.define_column(source_cursor, 4, l_rule_name , 30);

1776:
1777: dbms_sql.define_column(source_cursor, 1, l_rule_detail_id);
1778: dbms_sql.define_column(source_cursor, 2, l_result_value , 1024);
1779: dbms_sql.define_column(source_cursor, 3, l_result_application_id);
1780: dbms_sql.define_column(source_cursor, 4, l_rule_name , 30);
1781:
1782: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1783:
1784: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop

Line 1782: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);

1778: dbms_sql.define_column(source_cursor, 2, l_result_value , 1024);
1779: dbms_sql.define_column(source_cursor, 3, l_result_application_id);
1780: dbms_sql.define_column(source_cursor, 4, l_rule_name , 30);
1781:
1782: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1783:
1784: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1785: dbms_sql.column_value(source_cursor, 1, l_rule_detail_id);
1786: dbms_sql.column_value(source_cursor, 2, l_result_value);

Line 1784: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop

1780: dbms_sql.define_column(source_cursor, 4, l_rule_name , 30);
1781:
1782: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1783:
1784: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1785: dbms_sql.column_value(source_cursor, 1, l_rule_detail_id);
1786: dbms_sql.column_value(source_cursor, 2, l_result_value);
1787: dbms_sql.column_value(source_cursor, 3, l_result_application_id);
1788: dbms_sql.column_value(source_cursor, 4, l_rule_name);

Line 1785: dbms_sql.column_value(source_cursor, 1, l_rule_detail_id);

1781:
1782: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1783:
1784: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1785: dbms_sql.column_value(source_cursor, 1, l_rule_detail_id);
1786: dbms_sql.column_value(source_cursor, 2, l_result_value);
1787: dbms_sql.column_value(source_cursor, 3, l_result_application_id);
1788: dbms_sql.column_value(source_cursor, 4, l_rule_name);
1789:

Line 1786: dbms_sql.column_value(source_cursor, 2, l_result_value);

1782: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1783:
1784: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1785: dbms_sql.column_value(source_cursor, 1, l_rule_detail_id);
1786: dbms_sql.column_value(source_cursor, 2, l_result_value);
1787: dbms_sql.column_value(source_cursor, 3, l_result_application_id);
1788: dbms_sql.column_value(source_cursor, 4, l_rule_name);
1789:
1790: m_ruleDetailId := l_rule_detail_id;

Line 1787: dbms_sql.column_value(source_cursor, 3, l_result_application_id);

1783:
1784: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1785: dbms_sql.column_value(source_cursor, 1, l_rule_detail_id);
1786: dbms_sql.column_value(source_cursor, 2, l_result_value);
1787: dbms_sql.column_value(source_cursor, 3, l_result_application_id);
1788: dbms_sql.column_value(source_cursor, 4, l_rule_name);
1789:
1790: m_ruleDetailId := l_rule_detail_id;
1791: m_resultApplicationId := l_result_application_id;

Line 1788: dbms_sql.column_value(source_cursor, 4, l_rule_name);

1784: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1785: dbms_sql.column_value(source_cursor, 1, l_rule_detail_id);
1786: dbms_sql.column_value(source_cursor, 2, l_result_value);
1787: dbms_sql.column_value(source_cursor, 3, l_result_application_id);
1788: dbms_sql.column_value(source_cursor, 4, l_rule_name);
1789:
1790: m_ruleDetailId := l_rule_detail_id;
1791: m_resultApplicationId := l_result_application_id;
1792: m_resultValue := l_result_value;

Line 1797: DBMS_SQL.CLOSE_CURSOR(source_cursor);

1793: m_ruleName := l_rule_name;
1794: exit;
1795: end loop;
1796:
1797: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1798:
1799: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1800: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_PUB.getResultValue', FALSE);
1801: end if;

Line 1814: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

1810:
1811: RAISE;
1812:
1813: WHEN OTHERS THEN
1814: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
1815: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1816: END IF;
1817: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1818: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getResultValue:->'||SQLERRM, FALSE);

Line 1815: DBMS_SQL.CLOSE_CURSOR(source_cursor);

1811: RAISE;
1812:
1813: WHEN OTHERS THEN
1814: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
1815: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1816: END IF;
1817: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1818: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getResultValue:->'||SQLERRM, FALSE);
1819: END IF;

Line 1845: source_cursor := DBMS_SQL.OPEN_CURSOR;

1841: /*Assumption : For default value, Rule_Detail_Id = -99
1842: * Rule name = "Default Result"
1843: */
1844:
1845: source_cursor := DBMS_SQL.OPEN_CURSOR;
1846:
1847: DBMS_SQL.PARSE(source_cursor, g_sDefaultValuesSql, DBMS_SQL.native);
1848: dbms_sql.bind_variable(source_cursor , '1' , p_ruleObjectId);
1849:

Line 1847: DBMS_SQL.PARSE(source_cursor, g_sDefaultValuesSql, DBMS_SQL.native);

1843: */
1844:
1845: source_cursor := DBMS_SQL.OPEN_CURSOR;
1846:
1847: DBMS_SQL.PARSE(source_cursor, g_sDefaultValuesSql, DBMS_SQL.native);
1848: dbms_sql.bind_variable(source_cursor , '1' , p_ruleObjectId);
1849:
1850: dbms_sql.define_column(source_cursor, 1, l_default_value , 1024);
1851: dbms_sql.define_column(source_cursor, 2, l_default_application_id);

Line 1848: dbms_sql.bind_variable(source_cursor , '1' , p_ruleObjectId);

1844:
1845: source_cursor := DBMS_SQL.OPEN_CURSOR;
1846:
1847: DBMS_SQL.PARSE(source_cursor, g_sDefaultValuesSql, DBMS_SQL.native);
1848: dbms_sql.bind_variable(source_cursor , '1' , p_ruleObjectId);
1849:
1850: dbms_sql.define_column(source_cursor, 1, l_default_value , 1024);
1851: dbms_sql.define_column(source_cursor, 2, l_default_application_id);
1852:

Line 1850: dbms_sql.define_column(source_cursor, 1, l_default_value , 1024);

1846:
1847: DBMS_SQL.PARSE(source_cursor, g_sDefaultValuesSql, DBMS_SQL.native);
1848: dbms_sql.bind_variable(source_cursor , '1' , p_ruleObjectId);
1849:
1850: dbms_sql.define_column(source_cursor, 1, l_default_value , 1024);
1851: dbms_sql.define_column(source_cursor, 2, l_default_application_id);
1852:
1853: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1854:

Line 1851: dbms_sql.define_column(source_cursor, 2, l_default_application_id);

1847: DBMS_SQL.PARSE(source_cursor, g_sDefaultValuesSql, DBMS_SQL.native);
1848: dbms_sql.bind_variable(source_cursor , '1' , p_ruleObjectId);
1849:
1850: dbms_sql.define_column(source_cursor, 1, l_default_value , 1024);
1851: dbms_sql.define_column(source_cursor, 2, l_default_application_id);
1852:
1853: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1854:
1855: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop

Line 1853: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);

1849:
1850: dbms_sql.define_column(source_cursor, 1, l_default_value , 1024);
1851: dbms_sql.define_column(source_cursor, 2, l_default_application_id);
1852:
1853: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1854:
1855: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1856: dbms_sql.column_value(source_cursor, 1, l_default_value);
1857: dbms_sql.column_value(source_cursor, 2, l_default_application_id);

Line 1855: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop

1851: dbms_sql.define_column(source_cursor, 2, l_default_application_id);
1852:
1853: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1854:
1855: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1856: dbms_sql.column_value(source_cursor, 1, l_default_value);
1857: dbms_sql.column_value(source_cursor, 2, l_default_application_id);
1858:
1859: m_ruleDetailId := -99;

Line 1856: dbms_sql.column_value(source_cursor, 1, l_default_value);

1852:
1853: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1854:
1855: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1856: dbms_sql.column_value(source_cursor, 1, l_default_value);
1857: dbms_sql.column_value(source_cursor, 2, l_default_application_id);
1858:
1859: m_ruleDetailId := -99;
1860: m_resultApplicationId := l_default_application_id;

Line 1857: dbms_sql.column_value(source_cursor, 2, l_default_application_id);

1853: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1854:
1855: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1856: dbms_sql.column_value(source_cursor, 1, l_default_value);
1857: dbms_sql.column_value(source_cursor, 2, l_default_application_id);
1858:
1859: m_ruleDetailId := -99;
1860: m_resultApplicationId := l_default_application_id;
1861: m_resultValue := l_default_value;

Line 1866: DBMS_SQL.CLOSE_CURSOR(source_cursor);

1862: m_ruleName := 'Default Result';
1863: exit;
1864: end loop;
1865:
1866: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1867: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1868: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_PUB.getDefaultValue', FALSE);
1869: end if;
1870:

Line 1883: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

1879:
1880: RAISE;
1881:
1882: WHEN OTHERS THEN
1883: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
1884: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1885: END IF;
1886: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1887: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getDefaultValue:->'||SQLERRM, FALSE);

Line 1884: DBMS_SQL.CLOSE_CURSOR(source_cursor);

1880: RAISE;
1881:
1882: WHEN OTHERS THEN
1883: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
1884: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1885: END IF;
1886: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1887: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getDefaultValue:->'||SQLERRM, FALSE);
1888: END IF;

Line 1918: source_cursor := DBMS_SQL.OPEN_CURSOR;

1914: m_ruleObjectId := 0;
1915: m_flexFieldName := null;
1916: m_flexFieldAppShortName := null;
1917:
1918: source_cursor := DBMS_SQL.OPEN_CURSOR;
1919:
1920: DBMS_SQL.PARSE(source_cursor, g_sRuleObjectSql, DBMS_SQL.native);
1921: dbms_sql.bind_variable(source_cursor , '1' , p_RuleObjectName);
1922:

Line 1920: DBMS_SQL.PARSE(source_cursor, g_sRuleObjectSql, DBMS_SQL.native);

1916: m_flexFieldAppShortName := null;
1917:
1918: source_cursor := DBMS_SQL.OPEN_CURSOR;
1919:
1920: DBMS_SQL.PARSE(source_cursor, g_sRuleObjectSql, DBMS_SQL.native);
1921: dbms_sql.bind_variable(source_cursor , '1' , p_RuleObjectName);
1922:
1923: IF (m_instance_context = 'Y') THEN
1924: dbms_sql.bind_variable(source_cursor , '2' , m_instance_label);

Line 1921: dbms_sql.bind_variable(source_cursor , '1' , p_RuleObjectName);

1917:
1918: source_cursor := DBMS_SQL.OPEN_CURSOR;
1919:
1920: DBMS_SQL.PARSE(source_cursor, g_sRuleObjectSql, DBMS_SQL.native);
1921: dbms_sql.bind_variable(source_cursor , '1' , p_RuleObjectName);
1922:
1923: IF (m_instance_context = 'Y') THEN
1924: dbms_sql.bind_variable(source_cursor , '2' , m_instance_label);
1925: dbms_sql.bind_variable(source_cursor , '3' , m_instance_label);

Line 1924: dbms_sql.bind_variable(source_cursor , '2' , m_instance_label);

1920: DBMS_SQL.PARSE(source_cursor, g_sRuleObjectSql, DBMS_SQL.native);
1921: dbms_sql.bind_variable(source_cursor , '1' , p_RuleObjectName);
1922:
1923: IF (m_instance_context = 'Y') THEN
1924: dbms_sql.bind_variable(source_cursor , '2' , m_instance_label);
1925: dbms_sql.bind_variable(source_cursor , '3' , m_instance_label);
1926: dbms_sql.bind_variable(source_cursor , '4' , m_instance_label);
1927:
1928: dbms_sql.bind_variable(source_cursor , '5' , m_org_id);

Line 1925: dbms_sql.bind_variable(source_cursor , '3' , m_instance_label);

1921: dbms_sql.bind_variable(source_cursor , '1' , p_RuleObjectName);
1922:
1923: IF (m_instance_context = 'Y') THEN
1924: dbms_sql.bind_variable(source_cursor , '2' , m_instance_label);
1925: dbms_sql.bind_variable(source_cursor , '3' , m_instance_label);
1926: dbms_sql.bind_variable(source_cursor , '4' , m_instance_label);
1927:
1928: dbms_sql.bind_variable(source_cursor , '5' , m_org_id);
1929: dbms_sql.bind_variable(source_cursor , '6' , m_org_id);

Line 1926: dbms_sql.bind_variable(source_cursor , '4' , m_instance_label);

1922:
1923: IF (m_instance_context = 'Y') THEN
1924: dbms_sql.bind_variable(source_cursor , '2' , m_instance_label);
1925: dbms_sql.bind_variable(source_cursor , '3' , m_instance_label);
1926: dbms_sql.bind_variable(source_cursor , '4' , m_instance_label);
1927:
1928: dbms_sql.bind_variable(source_cursor , '5' , m_org_id);
1929: dbms_sql.bind_variable(source_cursor , '6' , m_org_id);
1930: dbms_sql.bind_variable(source_cursor , '7' , m_org_id);

Line 1928: dbms_sql.bind_variable(source_cursor , '5' , m_org_id);

1924: dbms_sql.bind_variable(source_cursor , '2' , m_instance_label);
1925: dbms_sql.bind_variable(source_cursor , '3' , m_instance_label);
1926: dbms_sql.bind_variable(source_cursor , '4' , m_instance_label);
1927:
1928: dbms_sql.bind_variable(source_cursor , '5' , m_org_id);
1929: dbms_sql.bind_variable(source_cursor , '6' , m_org_id);
1930: dbms_sql.bind_variable(source_cursor , '7' , m_org_id);
1931: END IF;
1932:

Line 1929: dbms_sql.bind_variable(source_cursor , '6' , m_org_id);

1925: dbms_sql.bind_variable(source_cursor , '3' , m_instance_label);
1926: dbms_sql.bind_variable(source_cursor , '4' , m_instance_label);
1927:
1928: dbms_sql.bind_variable(source_cursor , '5' , m_org_id);
1929: dbms_sql.bind_variable(source_cursor , '6' , m_org_id);
1930: dbms_sql.bind_variable(source_cursor , '7' , m_org_id);
1931: END IF;
1932:
1933: dbms_sql.define_column(source_cursor, 1, m_ruleObjectType , 15);

Line 1930: dbms_sql.bind_variable(source_cursor , '7' , m_org_id);

1926: dbms_sql.bind_variable(source_cursor , '4' , m_instance_label);
1927:
1928: dbms_sql.bind_variable(source_cursor , '5' , m_org_id);
1929: dbms_sql.bind_variable(source_cursor , '6' , m_org_id);
1930: dbms_sql.bind_variable(source_cursor , '7' , m_org_id);
1931: END IF;
1932:
1933: dbms_sql.define_column(source_cursor, 1, m_ruleObjectType , 15);
1934: dbms_sql.define_column(source_cursor, 2, m_ruleObjectId);

Line 1933: dbms_sql.define_column(source_cursor, 1, m_ruleObjectType , 15);

1929: dbms_sql.bind_variable(source_cursor , '6' , m_org_id);
1930: dbms_sql.bind_variable(source_cursor , '7' , m_org_id);
1931: END IF;
1932:
1933: dbms_sql.define_column(source_cursor, 1, m_ruleObjectType , 15);
1934: dbms_sql.define_column(source_cursor, 2, m_ruleObjectId);
1935: dbms_sql.define_column(source_cursor, 3, m_flexFieldName , 30);
1936: dbms_sql.define_column(source_cursor, 4, m_flexFieldAppShortName , 10);
1937:

Line 1934: dbms_sql.define_column(source_cursor, 2, m_ruleObjectId);

1930: dbms_sql.bind_variable(source_cursor , '7' , m_org_id);
1931: END IF;
1932:
1933: dbms_sql.define_column(source_cursor, 1, m_ruleObjectType , 15);
1934: dbms_sql.define_column(source_cursor, 2, m_ruleObjectId);
1935: dbms_sql.define_column(source_cursor, 3, m_flexFieldName , 30);
1936: dbms_sql.define_column(source_cursor, 4, m_flexFieldAppShortName , 10);
1937:
1938: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);

Line 1935: dbms_sql.define_column(source_cursor, 3, m_flexFieldName , 30);

1931: END IF;
1932:
1933: dbms_sql.define_column(source_cursor, 1, m_ruleObjectType , 15);
1934: dbms_sql.define_column(source_cursor, 2, m_ruleObjectId);
1935: dbms_sql.define_column(source_cursor, 3, m_flexFieldName , 30);
1936: dbms_sql.define_column(source_cursor, 4, m_flexFieldAppShortName , 10);
1937:
1938: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1939:

Line 1936: dbms_sql.define_column(source_cursor, 4, m_flexFieldAppShortName , 10);

1932:
1933: dbms_sql.define_column(source_cursor, 1, m_ruleObjectType , 15);
1934: dbms_sql.define_column(source_cursor, 2, m_ruleObjectId);
1935: dbms_sql.define_column(source_cursor, 3, m_flexFieldName , 30);
1936: dbms_sql.define_column(source_cursor, 4, m_flexFieldAppShortName , 10);
1937:
1938: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1939:
1940: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop

Line 1938: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);

1934: dbms_sql.define_column(source_cursor, 2, m_ruleObjectId);
1935: dbms_sql.define_column(source_cursor, 3, m_flexFieldName , 30);
1936: dbms_sql.define_column(source_cursor, 4, m_flexFieldAppShortName , 10);
1937:
1938: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1939:
1940: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1941: dbms_sql.column_value(source_cursor, 1, m_ruleObjectType);
1942: dbms_sql.column_value(source_cursor, 2, m_ruleObjectId);

Line 1940: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop

1936: dbms_sql.define_column(source_cursor, 4, m_flexFieldAppShortName , 10);
1937:
1938: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1939:
1940: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1941: dbms_sql.column_value(source_cursor, 1, m_ruleObjectType);
1942: dbms_sql.column_value(source_cursor, 2, m_ruleObjectId);
1943: dbms_sql.column_value(source_cursor, 3, m_flexFieldName);
1944: dbms_sql.column_value(source_cursor, 4, m_flexFieldAppShortName);

Line 1941: dbms_sql.column_value(source_cursor, 1, m_ruleObjectType);

1937:
1938: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1939:
1940: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1941: dbms_sql.column_value(source_cursor, 1, m_ruleObjectType);
1942: dbms_sql.column_value(source_cursor, 2, m_ruleObjectId);
1943: dbms_sql.column_value(source_cursor, 3, m_flexFieldName);
1944: dbms_sql.column_value(source_cursor, 4, m_flexFieldAppShortName);
1945:

Line 1942: dbms_sql.column_value(source_cursor, 2, m_ruleObjectId);

1938: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1939:
1940: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1941: dbms_sql.column_value(source_cursor, 1, m_ruleObjectType);
1942: dbms_sql.column_value(source_cursor, 2, m_ruleObjectId);
1943: dbms_sql.column_value(source_cursor, 3, m_flexFieldName);
1944: dbms_sql.column_value(source_cursor, 4, m_flexFieldAppShortName);
1945:
1946: exit;

Line 1943: dbms_sql.column_value(source_cursor, 3, m_flexFieldName);

1939:
1940: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1941: dbms_sql.column_value(source_cursor, 1, m_ruleObjectType);
1942: dbms_sql.column_value(source_cursor, 2, m_ruleObjectId);
1943: dbms_sql.column_value(source_cursor, 3, m_flexFieldName);
1944: dbms_sql.column_value(source_cursor, 4, m_flexFieldAppShortName);
1945:
1946: exit;
1947: end loop;

Line 1944: dbms_sql.column_value(source_cursor, 4, m_flexFieldAppShortName);

1940: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1941: dbms_sql.column_value(source_cursor, 1, m_ruleObjectType);
1942: dbms_sql.column_value(source_cursor, 2, m_ruleObjectId);
1943: dbms_sql.column_value(source_cursor, 3, m_flexFieldName);
1944: dbms_sql.column_value(source_cursor, 4, m_flexFieldAppShortName);
1945:
1946: exit;
1947: end loop;
1948:

Line 1949: DBMS_SQL.CLOSE_CURSOR(source_cursor);

1945:
1946: exit;
1947: end loop;
1948:
1949: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1950:
1951: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1952: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_PUB.getRuleObjectInfo', FALSE);
1953: end if;

Line 1966: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

1962:
1963: RAISE;
1964:
1965: WHEN OTHERS THEN
1966: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
1967: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1968: END IF;
1969: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1970: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getRuleObjectInfo:->g_sRuleObjectSql='||g_sRuleObjectSql, FALSE);

Line 1967: DBMS_SQL.CLOSE_CURSOR(source_cursor);

1963: RAISE;
1964:
1965: WHEN OTHERS THEN
1966: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
1967: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1968: END IF;
1969: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1970: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getRuleObjectInfo:->g_sRuleObjectSql='||g_sRuleObjectSql, FALSE);
1971: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getRuleObjectInfo:->'||SQLERRM, FALSE);

Line 2578: l_descTbl DBMS_SQL.DESC_TAB;

2574: l_theCursor INTEGER;
2575: l_stringToParse VARCHAR2(20000);
2576: l_colValue VARCHAR2(4000);
2577: l_counter PLS_INTEGER := 0;
2578: l_descTbl DBMS_SQL.DESC_TAB;
2579: l_numColumns INTEGER;
2580:
2581: source_cursor INTEGER;
2582: l_num_rows_processed INTEGER;

Line 2699: l_theCursor := dbms_sql.open_cursor;

2695: l_stringToParse := 'select * from ' || p_param_view_name || ' where ' || p_additional_where_clause || ' AND ROWNUM = 1';
2696: END IF;
2697:
2698:
2699: l_theCursor := dbms_sql.open_cursor;
2700: dbms_sql.parse( c => l_theCursor,
2701: statement => l_stringToParse,
2702: language_flag => dbms_sql.native);
2703:

Line 2700: dbms_sql.parse( c => l_theCursor,

2696: END IF;
2697:
2698:
2699: l_theCursor := dbms_sql.open_cursor;
2700: dbms_sql.parse( c => l_theCursor,
2701: statement => l_stringToParse,
2702: language_flag => dbms_sql.native);
2703:
2704: dbms_sql.describe_columns(l_theCursor, l_numColumns, l_descTbl);

Line 2702: language_flag => dbms_sql.native);

2698:
2699: l_theCursor := dbms_sql.open_cursor;
2700: dbms_sql.parse( c => l_theCursor,
2701: statement => l_stringToParse,
2702: language_flag => dbms_sql.native);
2703:
2704: dbms_sql.describe_columns(l_theCursor, l_numColumns, l_descTbl);
2705:
2706:

Line 2704: dbms_sql.describe_columns(l_theCursor, l_numColumns, l_descTbl);

2700: dbms_sql.parse( c => l_theCursor,
2701: statement => l_stringToParse,
2702: language_flag => dbms_sql.native);
2703:
2704: dbms_sql.describe_columns(l_theCursor, l_numColumns, l_descTbl);
2705:
2706:
2707: destination_cursor := DBMS_SQL.OPEN_CURSOR;
2708:

Line 2707: destination_cursor := DBMS_SQL.OPEN_CURSOR;

2703:
2704: dbms_sql.describe_columns(l_theCursor, l_numColumns, l_descTbl);
2705:
2706:
2707: destination_cursor := DBMS_SQL.OPEN_CURSOR;
2708:
2709: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2710: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.apply_rule_bulk:->g_sRuleDetailSql='||g_sRuleDetailSql, FALSE);
2711: end if;

Line 2723: DBMS_SQL.PARSE(destination_cursor, g_sRuleDetailSql,DBMS_SQL.native);

2719: g_sRuleDetailSql := g_sRuleDetailSql_orig;
2720: END IF;
2721:
2722:
2723: DBMS_SQL.PARSE(destination_cursor, g_sRuleDetailSql,DBMS_SQL.native);
2724: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);
2725: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
2726:
2727: IF (m_instance_context = 'Y') THEN

Line 2724: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);

2720: END IF;
2721:
2722:
2723: DBMS_SQL.PARSE(destination_cursor, g_sRuleDetailSql,DBMS_SQL.native);
2724: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);
2725: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
2726:
2727: IF (m_instance_context = 'Y') THEN
2728: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);

Line 2725: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);

2721:
2722:
2723: DBMS_SQL.PARSE(destination_cursor, g_sRuleDetailSql,DBMS_SQL.native);
2724: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);
2725: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
2726:
2727: IF (m_instance_context = 'Y') THEN
2728: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
2729: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);

Line 2728: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);

2724: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);
2725: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
2726:
2727: IF (m_instance_context = 'Y') THEN
2728: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
2729: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
2730: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
2731:
2732: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);

Line 2729: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);

2725: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
2726:
2727: IF (m_instance_context = 'Y') THEN
2728: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
2729: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
2730: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
2731:
2732: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
2733: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);

Line 2730: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);

2726:
2727: IF (m_instance_context = 'Y') THEN
2728: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
2729: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
2730: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
2731:
2732: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
2733: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
2734: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);

Line 2732: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);

2728: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
2729: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
2730: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
2731:
2732: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
2733: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
2734: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
2735: END IF;
2736:

Line 2733: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);

2729: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
2730: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
2731:
2732: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
2733: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
2734: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
2735: END IF;
2736:
2737: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);

Line 2734: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);

2730: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
2731:
2732: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
2733: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
2734: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
2735: END IF;
2736:
2737: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
2738: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);

Line 2737: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);

2733: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
2734: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
2735: END IF;
2736:
2737: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
2738: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
2739: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
2740: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
2741: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);

Line 2738: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);

2734: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
2735: END IF;
2736:
2737: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
2738: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
2739: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
2740: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
2741: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
2742: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);

Line 2739: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);

2735: END IF;
2736:
2737: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
2738: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
2739: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
2740: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
2741: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
2742: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
2743: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);

Line 2740: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);

2736:
2737: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
2738: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
2739: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
2740: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
2741: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
2742: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
2743: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
2744:

Line 2741: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);

2737: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
2738: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
2739: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
2740: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
2741: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
2742: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
2743: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
2744:
2745: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);

Line 2742: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);

2738: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
2739: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
2740: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
2741: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
2742: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
2743: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
2744:
2745: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);
2746:

Line 2743: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);

2739: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
2740: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
2741: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
2742: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
2743: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
2744:
2745: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);
2746:
2747: --If No rules active.

Line 2745: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);

2741: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
2742: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
2743: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
2744:
2745: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);
2746:
2747: --If No rules active.
2748: if(l_num_rows_processed = 0) then
2749: l_noRuleActive := TRUE;

Line 2752: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop

2748: if(l_num_rows_processed = 0) then
2749: l_noRuleActive := TRUE;
2750: end if;
2751:
2752: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop
2753: l_count := 1;
2754: /* Initialize the var l_paramPresent for each rule. If any param matches then make it true
2755: * and insert the record into FUN_RULE_BULK_RESULT_GT table.
2756: */

Line 2764: dbms_sql.column_value(destination_cursor, 1, l_result_type);

2760: l_select_query := 'SELECT '||p_primary_key_column_name||' , ';
2761: l_where_clause := '';
2762: l_insert_statement := 'insert into FUN_RULE_BULK_RESULT_GT(ID, RESULT_VALUE , RULE_NAME ,RESULT_APPLICATION_ID, RULE_DETAIL_ID ) ';
2763:
2764: dbms_sql.column_value(destination_cursor, 1, l_result_type);
2765: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
2766: dbms_sql.column_value(destination_cursor, 3, l_operator);
2767: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
2768: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);

Line 2765: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );

2761: l_where_clause := '';
2762: l_insert_statement := 'insert into FUN_RULE_BULK_RESULT_GT(ID, RESULT_VALUE , RULE_NAME ,RESULT_APPLICATION_ID, RULE_DETAIL_ID ) ';
2763:
2764: dbms_sql.column_value(destination_cursor, 1, l_result_type);
2765: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
2766: dbms_sql.column_value(destination_cursor, 3, l_operator);
2767: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
2768: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
2769: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);

Line 2766: dbms_sql.column_value(destination_cursor, 3, l_operator);

2762: l_insert_statement := 'insert into FUN_RULE_BULK_RESULT_GT(ID, RESULT_VALUE , RULE_NAME ,RESULT_APPLICATION_ID, RULE_DETAIL_ID ) ';
2763:
2764: dbms_sql.column_value(destination_cursor, 1, l_result_type);
2765: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
2766: dbms_sql.column_value(destination_cursor, 3, l_operator);
2767: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
2768: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
2769: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
2770: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);

Line 2767: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);

2763:
2764: dbms_sql.column_value(destination_cursor, 1, l_result_type);
2765: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
2766: dbms_sql.column_value(destination_cursor, 3, l_operator);
2767: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
2768: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
2769: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
2770: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
2771:

Line 2768: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);

2764: dbms_sql.column_value(destination_cursor, 1, l_result_type);
2765: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
2766: dbms_sql.column_value(destination_cursor, 3, l_operator);
2767: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
2768: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
2769: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
2770: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
2771:
2772: params_cursor := DBMS_SQL.OPEN_CURSOR;

Line 2769: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);

2765: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
2766: dbms_sql.column_value(destination_cursor, 3, l_operator);
2767: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
2768: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
2769: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
2770: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
2771:
2772: params_cursor := DBMS_SQL.OPEN_CURSOR;
2773:

Line 2770: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);

2766: dbms_sql.column_value(destination_cursor, 3, l_operator);
2767: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
2768: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
2769: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
2770: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
2771:
2772: params_cursor := DBMS_SQL.OPEN_CURSOR;
2773:
2774: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2772: params_cursor := DBMS_SQL.OPEN_CURSOR;

2768: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
2769: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
2770: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
2771:
2772: params_cursor := DBMS_SQL.OPEN_CURSOR;
2773:
2774: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2775: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.apply_rule_bulk:->g_sCriteriaParamSql='||g_sCriteriaParamSql, FALSE);
2776: end if;

Line 2778: DBMS_SQL.PARSE(params_cursor, g_sCriteriaParamSql,DBMS_SQL.native);

2774: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2775: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.apply_rule_bulk:->g_sCriteriaParamSql='||g_sCriteriaParamSql, FALSE);
2776: end if;
2777:
2778: DBMS_SQL.PARSE(params_cursor, g_sCriteriaParamSql,DBMS_SQL.native);
2779:
2780: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
2781: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
2782:

Line 2780: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);

2776: end if;
2777:
2778: DBMS_SQL.PARSE(params_cursor, g_sCriteriaParamSql,DBMS_SQL.native);
2779:
2780: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
2781: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
2782:
2783: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
2784: dbms_sql.define_column(params_cursor, 2, l_condition , 15);

Line 2781: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);

2777:
2778: DBMS_SQL.PARSE(params_cursor, g_sCriteriaParamSql,DBMS_SQL.native);
2779:
2780: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
2781: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
2782:
2783: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
2784: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
2785: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);

Line 2783: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);

2779:
2780: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
2781: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
2782:
2783: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
2784: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
2785: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
2786: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
2787: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);

Line 2784: dbms_sql.define_column(params_cursor, 2, l_condition , 15);

2780: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
2781: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
2782:
2783: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
2784: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
2785: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
2786: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
2787: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
2788: dbms_sql.define_column(params_cursor, 6, l_criteria_id);

Line 2785: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);

2781: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
2782:
2783: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
2784: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
2785: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
2786: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
2787: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
2788: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
2789:

Line 2786: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);

2782:
2783: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
2784: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
2785: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
2786: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
2787: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
2788: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
2789:
2790: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);

Line 2787: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);

2783: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
2784: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
2785: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
2786: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
2787: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
2788: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
2789:
2790: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
2791:

Line 2788: dbms_sql.define_column(params_cursor, 6, l_criteria_id);

2784: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
2785: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
2786: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
2787: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
2788: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
2789:
2790: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
2791:
2792: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop

Line 2790: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);

2786: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
2787: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
2788: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
2789:
2790: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
2791:
2792: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
2793: dbms_sql.column_value(params_cursor, 1, l_param_name );
2794: dbms_sql.column_value(params_cursor, 2, l_condition );

Line 2792: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop

2788: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
2789:
2790: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
2791:
2792: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
2793: dbms_sql.column_value(params_cursor, 1, l_param_name );
2794: dbms_sql.column_value(params_cursor, 2, l_condition );
2795: dbms_sql.column_value(params_cursor, 3, l_param_value);
2796: dbms_sql.column_value(params_cursor, 4, l_data_type);

Line 2793: dbms_sql.column_value(params_cursor, 1, l_param_name );

2789:
2790: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
2791:
2792: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
2793: dbms_sql.column_value(params_cursor, 1, l_param_name );
2794: dbms_sql.column_value(params_cursor, 2, l_condition );
2795: dbms_sql.column_value(params_cursor, 3, l_param_value);
2796: dbms_sql.column_value(params_cursor, 4, l_data_type);
2797: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);

Line 2794: dbms_sql.column_value(params_cursor, 2, l_condition );

2790: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
2791:
2792: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
2793: dbms_sql.column_value(params_cursor, 1, l_param_name );
2794: dbms_sql.column_value(params_cursor, 2, l_condition );
2795: dbms_sql.column_value(params_cursor, 3, l_param_value);
2796: dbms_sql.column_value(params_cursor, 4, l_data_type);
2797: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
2798: dbms_sql.column_value(params_cursor, 6, l_criteria_id);

Line 2795: dbms_sql.column_value(params_cursor, 3, l_param_value);

2791:
2792: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
2793: dbms_sql.column_value(params_cursor, 1, l_param_name );
2794: dbms_sql.column_value(params_cursor, 2, l_condition );
2795: dbms_sql.column_value(params_cursor, 3, l_param_value);
2796: dbms_sql.column_value(params_cursor, 4, l_data_type);
2797: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
2798: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
2799: /*

Line 2796: dbms_sql.column_value(params_cursor, 4, l_data_type);

2792: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
2793: dbms_sql.column_value(params_cursor, 1, l_param_name );
2794: dbms_sql.column_value(params_cursor, 2, l_condition );
2795: dbms_sql.column_value(params_cursor, 3, l_param_value);
2796: dbms_sql.column_value(params_cursor, 4, l_data_type);
2797: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
2798: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
2799: /*
2800: START: RULES ENGINE ENHANCEMNT FOR CUSTOM PARAMETERS

Line 2797: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);

2793: dbms_sql.column_value(params_cursor, 1, l_param_name );
2794: dbms_sql.column_value(params_cursor, 2, l_condition );
2795: dbms_sql.column_value(params_cursor, 3, l_param_value);
2796: dbms_sql.column_value(params_cursor, 4, l_data_type);
2797: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
2798: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
2799: /*
2800: START: RULES ENGINE ENHANCEMNT FOR CUSTOM PARAMETERS
2801: If the parameter is a custom parameter, then select the

Line 2798: dbms_sql.column_value(params_cursor, 6, l_criteria_id);

2794: dbms_sql.column_value(params_cursor, 2, l_condition );
2795: dbms_sql.column_value(params_cursor, 3, l_param_value);
2796: dbms_sql.column_value(params_cursor, 4, l_data_type);
2797: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
2798: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
2799: /*
2800: START: RULES ENGINE ENHANCEMNT FOR CUSTOM PARAMETERS
2801: If the parameter is a custom parameter, then select the
2802: column name as the param name. Down the line, a query is

Line 2832: paramVal_cursor := DBMS_SQL.OPEN_CURSOR;

2828: loop
2829: l_crit_param_name := l_descTbl(i).col_name;
2830: if(l_crit_param_name = l_param_name) then
2831: l_paramPresent := TRUE;
2832: paramVal_cursor := DBMS_SQL.OPEN_CURSOR;
2833:
2834: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2835: fnd_log.message(FND_LOG.LEVEL_STATEMENT,
2836: 'Start FUN_RULE_PUB.apply_rule_bulk:->g_sMultiCriteriaParamValueSql='||g_sMultiCriteriaParamValueSql, FALSE);

Line 2839: DBMS_SQL.PARSE(paramVal_cursor, g_sMultiCriteriaParamValueSql,DBMS_SQL.native);

2835: fnd_log.message(FND_LOG.LEVEL_STATEMENT,
2836: 'Start FUN_RULE_PUB.apply_rule_bulk:->g_sMultiCriteriaParamValueSql='||g_sMultiCriteriaParamValueSql, FALSE);
2837: end if;
2838:
2839: DBMS_SQL.PARSE(paramVal_cursor, g_sMultiCriteriaParamValueSql,DBMS_SQL.native);
2840: dbms_sql.bind_variable(paramVal_cursor , '1' , l_rule_detail_id);
2841: dbms_sql.bind_variable(paramVal_cursor , '2' , l_criteria_id);
2842:
2843: dbms_sql.define_column(paramVal_cursor, 1, l_param_value , 1024);

Line 2840: dbms_sql.bind_variable(paramVal_cursor , '1' , l_rule_detail_id);

2836: 'Start FUN_RULE_PUB.apply_rule_bulk:->g_sMultiCriteriaParamValueSql='||g_sMultiCriteriaParamValueSql, FALSE);
2837: end if;
2838:
2839: DBMS_SQL.PARSE(paramVal_cursor, g_sMultiCriteriaParamValueSql,DBMS_SQL.native);
2840: dbms_sql.bind_variable(paramVal_cursor , '1' , l_rule_detail_id);
2841: dbms_sql.bind_variable(paramVal_cursor , '2' , l_criteria_id);
2842:
2843: dbms_sql.define_column(paramVal_cursor, 1, l_param_value , 1024);
2844:

Line 2841: dbms_sql.bind_variable(paramVal_cursor , '2' , l_criteria_id);

2837: end if;
2838:
2839: DBMS_SQL.PARSE(paramVal_cursor, g_sMultiCriteriaParamValueSql,DBMS_SQL.native);
2840: dbms_sql.bind_variable(paramVal_cursor , '1' , l_rule_detail_id);
2841: dbms_sql.bind_variable(paramVal_cursor , '2' , l_criteria_id);
2842:
2843: dbms_sql.define_column(paramVal_cursor, 1, l_param_value , 1024);
2844:
2845: paramVal_rows_processed := DBMS_SQL.EXECUTE(paramVal_cursor);

Line 2843: dbms_sql.define_column(paramVal_cursor, 1, l_param_value , 1024);

2839: DBMS_SQL.PARSE(paramVal_cursor, g_sMultiCriteriaParamValueSql,DBMS_SQL.native);
2840: dbms_sql.bind_variable(paramVal_cursor , '1' , l_rule_detail_id);
2841: dbms_sql.bind_variable(paramVal_cursor , '2' , l_criteria_id);
2842:
2843: dbms_sql.define_column(paramVal_cursor, 1, l_param_value , 1024);
2844:
2845: paramVal_rows_processed := DBMS_SQL.EXECUTE(paramVal_cursor);
2846:
2847: if(l_condition = C_IN) then

Line 2845: paramVal_rows_processed := DBMS_SQL.EXECUTE(paramVal_cursor);

2841: dbms_sql.bind_variable(paramVal_cursor , '2' , l_criteria_id);
2842:
2843: dbms_sql.define_column(paramVal_cursor, 1, l_param_value , 1024);
2844:
2845: paramVal_rows_processed := DBMS_SQL.EXECUTE(paramVal_cursor);
2846:
2847: if(l_condition = C_IN) then
2848: l_where_clause := l_where_clause || l_param_name || ' IN (';
2849: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop

Line 2849: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop

2845: paramVal_rows_processed := DBMS_SQL.EXECUTE(paramVal_cursor);
2846:
2847: if(l_condition = C_IN) then
2848: l_where_clause := l_where_clause || l_param_name || ' IN (';
2849: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2850: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2851: if(l_data_type = C_STRINGS) then
2852: l_where_clause := l_where_clause || ' '''|| l_param_value ||''', ';
2853: elsif(l_data_type = C_DATE) then

Line 2850: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );

2846:
2847: if(l_condition = C_IN) then
2848: l_where_clause := l_where_clause || l_param_name || ' IN (';
2849: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2850: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2851: if(l_data_type = C_STRINGS) then
2852: l_where_clause := l_where_clause || ' '''|| l_param_value ||''', ';
2853: elsif(l_data_type = C_DATE) then
2854: l_where_clause := l_where_clause || ' to_date('''|| l_param_value ||''','''|| l_date_format ||''' ), ';

Line 2863: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop

2859: l_where_clause := l_where_clause ||')';
2860: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2861: elsif (l_condition = C_NOT_IN) then
2862: l_where_clause := l_where_clause || l_param_name || ' NOT IN (';
2863: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2864: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2865: if(l_data_type = C_STRINGS) then
2866: l_where_clause := l_where_clause || ' '''|| l_param_value ||''', ';
2867: elsif(l_data_type = C_DATE) then

Line 2864: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );

2860: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2861: elsif (l_condition = C_NOT_IN) then
2862: l_where_clause := l_where_clause || l_param_name || ' NOT IN (';
2863: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2864: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2865: if(l_data_type = C_STRINGS) then
2866: l_where_clause := l_where_clause || ' '''|| l_param_value ||''', ';
2867: elsif(l_data_type = C_DATE) then
2868: l_where_clause := l_where_clause || ' to_date('''|| l_param_value ||''', '''|| l_date_format ||''' ), ';

Line 2877: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop

2873: l_where_clause := l_where_clause ||' ) ';
2874: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2875: elsif (l_condition = C_LIKE OR l_condition = C_CONTAINS) then
2876: l_where_clause := l_where_clause || l_param_name || ' LIKE (';
2877: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2878: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2879: if(l_data_type = C_STRINGS OR l_data_type = C_DATE) then
2880: l_where_clause := l_where_clause || ' '''||'%'|| l_param_value ||'%'||''' ,' ;
2881: NULL;

Line 2878: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );

2874: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2875: elsif (l_condition = C_LIKE OR l_condition = C_CONTAINS) then
2876: l_where_clause := l_where_clause || l_param_name || ' LIKE (';
2877: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2878: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2879: if(l_data_type = C_STRINGS OR l_data_type = C_DATE) then
2880: l_where_clause := l_where_clause || ' '''||'%'|| l_param_value ||'%'||''' ,' ;
2881: NULL;
2882: else

Line 2890: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop

2886: l_where_clause := l_where_clause ||' ) ';
2887: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2888: elsif (l_condition = C_EQUALS) then
2889: l_where_clause := l_where_clause || l_param_name || ' = (';
2890: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2891: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2892: if(l_data_type = C_STRINGS) then
2893: l_where_clause := l_where_clause || ' '''|| l_param_value ||''', ' ;
2894: elsif(l_data_type = C_DATE) then

Line 2891: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );

2887: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2888: elsif (l_condition = C_EQUALS) then
2889: l_where_clause := l_where_clause || l_param_name || ' = (';
2890: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2891: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2892: if(l_data_type = C_STRINGS) then
2893: l_where_clause := l_where_clause || ' '''|| l_param_value ||''', ' ;
2894: elsif(l_data_type = C_DATE) then
2895: l_where_clause := l_where_clause || ' to_date('''|| l_param_value ||''', '''|| l_date_format ||''' ), ';

Line 2904: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop

2900: l_where_clause := l_where_clause ||' ) ';
2901: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2902: elsif (l_condition = C_NOT_EQUALS) then
2903: l_where_clause := l_where_clause || l_param_name || ' <> (';
2904: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2905: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2906: if(l_data_type = C_STRINGS) then
2907: l_where_clause := l_where_clause || ' '''|| l_param_value ||''', ' ;
2908: elsif(l_data_type = C_DATE) then

Line 2905: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );

2901: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2902: elsif (l_condition = C_NOT_EQUALS) then
2903: l_where_clause := l_where_clause || l_param_name || ' <> (';
2904: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2905: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2906: if(l_data_type = C_STRINGS) then
2907: l_where_clause := l_where_clause || ' '''|| l_param_value ||''', ' ;
2908: elsif(l_data_type = C_DATE) then
2909: l_where_clause := l_where_clause || ' to_date('''|| l_param_value ||''', '''|| l_date_format ||''' ), ';

Line 2918: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop

2914: l_where_clause := l_where_clause ||' ) ';
2915: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2916: elsif (l_condition = C_GREATER_THAN) then
2917: l_where_clause := l_where_clause || l_param_name || ' > (';
2918: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2919: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2920: if(l_data_type = C_STRINGS) then
2921: l_where_clause := l_where_clause || ' '''|| l_param_value ||''', ' ;
2922: elsif(l_data_type = C_DATE) then

Line 2919: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );

2915: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2916: elsif (l_condition = C_GREATER_THAN) then
2917: l_where_clause := l_where_clause || l_param_name || ' > (';
2918: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2919: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2920: if(l_data_type = C_STRINGS) then
2921: l_where_clause := l_where_clause || ' '''|| l_param_value ||''', ' ;
2922: elsif(l_data_type = C_DATE) then
2923: l_where_clause := l_where_clause || ' to_date('''|| l_param_value ||''', '''|| l_date_format ||''' ), ';

Line 2932: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop

2928: l_where_clause := l_where_clause ||' ) ';
2929: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2930: elsif (l_condition = C_LESSER_THAN) then
2931: l_where_clause := l_where_clause || l_param_name || ' < (';
2932: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2933: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2934: if(l_data_type = C_STRINGS) then
2935: l_where_clause := l_where_clause || ' '''|| l_param_value ||''', ' ;
2936: elsif(l_data_type = C_DATE) then

Line 2933: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );

2929: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2930: elsif (l_condition = C_LESSER_THAN) then
2931: l_where_clause := l_where_clause || l_param_name || ' < (';
2932: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2933: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2934: if(l_data_type = C_STRINGS) then
2935: l_where_clause := l_where_clause || ' '''|| l_param_value ||''', ' ;
2936: elsif(l_data_type = C_DATE) then
2937: l_where_clause := l_where_clause || ' to_date('''|| l_param_value ||''', '''|| l_date_format ||''' ), ';

Line 2946: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop

2942: l_where_clause := l_where_clause ||' ) ';
2943: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2944: elsif (l_condition = C_GREATER_THAN_EQUAL) then
2945: l_where_clause := l_where_clause || l_param_name || ' >= (';
2946: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2947: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2948: if(l_data_type = C_STRINGS) then
2949: l_where_clause := l_where_clause || ' '''|| l_param_value ||''', ' ;
2950: elsif(l_data_type = C_DATE) then

Line 2947: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );

2943: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2944: elsif (l_condition = C_GREATER_THAN_EQUAL) then
2945: l_where_clause := l_where_clause || l_param_name || ' >= (';
2946: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2947: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2948: if(l_data_type = C_STRINGS) then
2949: l_where_clause := l_where_clause || ' '''|| l_param_value ||''', ' ;
2950: elsif(l_data_type = C_DATE) then
2951: l_where_clause := l_where_clause || ' to_date('''|| l_param_value ||''', '''|| l_date_format ||''' ), ';

Line 2960: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop

2956: l_where_clause := l_where_clause ||' ) ';
2957: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2958: elsif (l_condition = C_LESSER_THAN_EQUAL) then
2959: l_where_clause := l_where_clause || l_param_name || ' <= (';
2960: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2961: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2962: if(l_data_type = C_STRINGS) then
2963: l_where_clause := l_where_clause || ' '''|| l_param_value ||''', ' ;
2964: elsif(l_data_type = C_DATE) then

Line 2961: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );

2957: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2958: elsif (l_condition = C_LESSER_THAN_EQUAL) then
2959: l_where_clause := l_where_clause || l_param_name || ' <= (';
2960: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2961: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2962: if(l_data_type = C_STRINGS) then
2963: l_where_clause := l_where_clause || ' '''|| l_param_value ||''', ' ;
2964: elsif(l_data_type = C_DATE) then
2965: l_where_clause := l_where_clause || ' to_date('''|| l_param_value ||''', '''|| l_date_format ||''' ), ';

Line 2974: DBMS_SQL.CLOSE_CURSOR(paramVal_cursor);

2970: l_where_clause := l_where_clause ||' ) ';
2971: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2972: end if;
2973: l_where_clause := l_where_clause || ' ' || l_operator || ' ';
2974: DBMS_SQL.CLOSE_CURSOR(paramVal_cursor);
2975: else
2976: NULL;
2977: end if; --If l_crit_param_name = l_param_name
2978: end loop; --End loop of l_descCol

Line 3029: DBMS_SQL.CLOSE_CURSOR(params_cursor);

3025: IF (p_additional_where_clause IS NOT NULL) THEN
3026: l_select_query := l_select_query || ' AND ' || p_additional_where_clause;
3027: END IF;
3028:
3029: DBMS_SQL.CLOSE_CURSOR(params_cursor);
3030:
3031: if(l_isRuleValid) then
3032: l_insert_statement := l_insert_statement || ' ' || l_select_query ||
3033: ' AND NOT EXISTS(SELECT 1 FROM FUN_RULE_BULK_RESULT_GT WHERE ID='|| p_param_view_name||'.'||p_primary_key_column_name||')';

Line 3088: DBMS_SQL.CLOSE_CURSOR(destination_cursor);

3084:
3085: /* bug 7337383 */
3086: -- end if;
3087:
3088: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
3089:
3090: -- start bug 7385974
3091: IF DBMS_SQL.IS_OPEN(l_theCursor) THEN
3092: DBMS_SQL.CLOSE_CURSOR(l_theCursor);

Line 3091: IF DBMS_SQL.IS_OPEN(l_theCursor) THEN

3087:
3088: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
3089:
3090: -- start bug 7385974
3091: IF DBMS_SQL.IS_OPEN(l_theCursor) THEN
3092: DBMS_SQL.CLOSE_CURSOR(l_theCursor);
3093: END IF;
3094: -- end bug 7385974
3095:

Line 3092: DBMS_SQL.CLOSE_CURSOR(l_theCursor);

3088: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
3089:
3090: -- start bug 7385974
3091: IF DBMS_SQL.IS_OPEN(l_theCursor) THEN
3092: DBMS_SQL.CLOSE_CURSOR(l_theCursor);
3093: END IF;
3094: -- end bug 7385974
3095:
3096: /*Rule Object Instance MOAC Changes:

Line 3130: IF DBMS_SQL.IS_OPEN(l_theCursor) THEN

3126: app_exception.raise_exception;
3127:
3128: WHEN OTHERS THEN
3129: -- start bug 7385974
3130: IF DBMS_SQL.IS_OPEN(l_theCursor) THEN
3131: DBMS_SQL.CLOSE_CURSOR(l_theCursor);
3132: END IF;
3133: -- end bug 7385974
3134: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN

Line 3131: DBMS_SQL.CLOSE_CURSOR(l_theCursor);

3127:
3128: WHEN OTHERS THEN
3129: -- start bug 7385974
3130: IF DBMS_SQL.IS_OPEN(l_theCursor) THEN
3131: DBMS_SQL.CLOSE_CURSOR(l_theCursor);
3132: END IF;
3133: -- end bug 7385974
3134: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
3135: DBMS_SQL.CLOSE_CURSOR(destination_cursor);

Line 3134: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN

3130: IF DBMS_SQL.IS_OPEN(l_theCursor) THEN
3131: DBMS_SQL.CLOSE_CURSOR(l_theCursor);
3132: END IF;
3133: -- end bug 7385974
3134: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
3135: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
3136: END IF;
3137: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
3138: DBMS_SQL.CLOSE_CURSOR(params_cursor);

Line 3135: DBMS_SQL.CLOSE_CURSOR(destination_cursor);

3131: DBMS_SQL.CLOSE_CURSOR(l_theCursor);
3132: END IF;
3133: -- end bug 7385974
3134: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
3135: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
3136: END IF;
3137: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
3138: DBMS_SQL.CLOSE_CURSOR(params_cursor);
3139: END IF;

Line 3137: IF DBMS_SQL.IS_OPEN(params_cursor) THEN

3133: -- end bug 7385974
3134: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
3135: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
3136: END IF;
3137: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
3138: DBMS_SQL.CLOSE_CURSOR(params_cursor);
3139: END IF;
3140: IF DBMS_SQL.IS_OPEN(paramVal_cursor) THEN
3141: DBMS_SQL.CLOSE_CURSOR(paramVal_cursor);

Line 3138: DBMS_SQL.CLOSE_CURSOR(params_cursor);

3134: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
3135: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
3136: END IF;
3137: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
3138: DBMS_SQL.CLOSE_CURSOR(params_cursor);
3139: END IF;
3140: IF DBMS_SQL.IS_OPEN(paramVal_cursor) THEN
3141: DBMS_SQL.CLOSE_CURSOR(paramVal_cursor);
3142: END IF;

Line 3140: IF DBMS_SQL.IS_OPEN(paramVal_cursor) THEN

3136: END IF;
3137: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
3138: DBMS_SQL.CLOSE_CURSOR(params_cursor);
3139: END IF;
3140: IF DBMS_SQL.IS_OPEN(paramVal_cursor) THEN
3141: DBMS_SQL.CLOSE_CURSOR(paramVal_cursor);
3142: END IF;
3143: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3144: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.apply_rule_bulk Others:->'||SQLERRM, FALSE);

Line 3141: DBMS_SQL.CLOSE_CURSOR(paramVal_cursor);

3137: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
3138: DBMS_SQL.CLOSE_CURSOR(params_cursor);
3139: END IF;
3140: IF DBMS_SQL.IS_OPEN(paramVal_cursor) THEN
3141: DBMS_SQL.CLOSE_CURSOR(paramVal_cursor);
3142: END IF;
3143: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3144: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.apply_rule_bulk Others:->'||SQLERRM, FALSE);
3145: END IF;

Line 3162: source_cursor := DBMS_SQL.OPEN_CURSOR;

3158: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.refreshGTBulkTable', FALSE);
3159: end if;
3160:
3161: -- Prepare a cursor to select from the source table:
3162: source_cursor := DBMS_SQL.OPEN_CURSOR;
3163:
3164: DBMS_SQL.PARSE(source_cursor, 'delete from FUN_RULE_BULK_RESULT_GT', DBMS_SQL.native);
3165:
3166: ignore := DBMS_SQL.EXECUTE(source_cursor);

Line 3164: DBMS_SQL.PARSE(source_cursor, 'delete from FUN_RULE_BULK_RESULT_GT', DBMS_SQL.native);

3160:
3161: -- Prepare a cursor to select from the source table:
3162: source_cursor := DBMS_SQL.OPEN_CURSOR;
3163:
3164: DBMS_SQL.PARSE(source_cursor, 'delete from FUN_RULE_BULK_RESULT_GT', DBMS_SQL.native);
3165:
3166: ignore := DBMS_SQL.EXECUTE(source_cursor);
3167:
3168: DBMS_SQL.CLOSE_CURSOR(source_cursor);

Line 3166: ignore := DBMS_SQL.EXECUTE(source_cursor);

3162: source_cursor := DBMS_SQL.OPEN_CURSOR;
3163:
3164: DBMS_SQL.PARSE(source_cursor, 'delete from FUN_RULE_BULK_RESULT_GT', DBMS_SQL.native);
3165:
3166: ignore := DBMS_SQL.EXECUTE(source_cursor);
3167:
3168: DBMS_SQL.CLOSE_CURSOR(source_cursor);
3169:
3170: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 3168: DBMS_SQL.CLOSE_CURSOR(source_cursor);

3164: DBMS_SQL.PARSE(source_cursor, 'delete from FUN_RULE_BULK_RESULT_GT', DBMS_SQL.native);
3165:
3166: ignore := DBMS_SQL.EXECUTE(source_cursor);
3167:
3168: DBMS_SQL.CLOSE_CURSOR(source_cursor);
3169:
3170: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3171: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.refreshGTBulkTable', FALSE);
3172: end if;

Line 3176: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

3172: end if;
3173:
3174: EXCEPTION
3175: WHEN NO_DATA_FOUND THEN
3176: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
3177: DBMS_SQL.CLOSE_CURSOR(source_cursor);
3178: END IF;
3179: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3180: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.refreshGTBulkTable:->'||SQLERRM, FALSE);

Line 3177: DBMS_SQL.CLOSE_CURSOR(source_cursor);

3173:
3174: EXCEPTION
3175: WHEN NO_DATA_FOUND THEN
3176: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
3177: DBMS_SQL.CLOSE_CURSOR(source_cursor);
3178: END IF;
3179: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3180: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.refreshGTBulkTable:->'||SQLERRM, FALSE);
3181: END IF;

Line 3185: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

3181: END IF;
3182: --No Need of Raising in this case.
3183:
3184: WHEN OTHERS THEN
3185: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
3186: DBMS_SQL.CLOSE_CURSOR(source_cursor);
3187: END IF;
3188: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3189: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.refreshGTBulkTable:->'||SQLERRM, FALSE);

Line 3186: DBMS_SQL.CLOSE_CURSOR(source_cursor);

3182: --No Need of Raising in this case.
3183:
3184: WHEN OTHERS THEN
3185: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
3186: DBMS_SQL.CLOSE_CURSOR(source_cursor);
3187: END IF;
3188: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3189: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.refreshGTBulkTable:->'||SQLERRM, FALSE);
3190: END IF;

Line 3206: destination_cursor := DBMS_SQL.OPEN_CURSOR;

3202: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.populateGTBulkTable', FALSE);
3203: end if;
3204:
3205: -- Prepare a cursor to insert into the destination table:
3206: destination_cursor := DBMS_SQL.OPEN_CURSOR;
3207:
3208: DBMS_SQL.PARSE(destination_cursor,p_insert_statement,DBMS_SQL.native);
3209:
3210: ignore := DBMS_SQL.EXECUTE(destination_cursor);

Line 3208: DBMS_SQL.PARSE(destination_cursor,p_insert_statement,DBMS_SQL.native);

3204:
3205: -- Prepare a cursor to insert into the destination table:
3206: destination_cursor := DBMS_SQL.OPEN_CURSOR;
3207:
3208: DBMS_SQL.PARSE(destination_cursor,p_insert_statement,DBMS_SQL.native);
3209:
3210: ignore := DBMS_SQL.EXECUTE(destination_cursor);
3211: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
3212:

Line 3210: ignore := DBMS_SQL.EXECUTE(destination_cursor);

3206: destination_cursor := DBMS_SQL.OPEN_CURSOR;
3207:
3208: DBMS_SQL.PARSE(destination_cursor,p_insert_statement,DBMS_SQL.native);
3209:
3210: ignore := DBMS_SQL.EXECUTE(destination_cursor);
3211: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
3212:
3213: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3214: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_PUB.populateGTBulkTable', FALSE);

Line 3211: DBMS_SQL.CLOSE_CURSOR(destination_cursor);

3207:
3208: DBMS_SQL.PARSE(destination_cursor,p_insert_statement,DBMS_SQL.native);
3209:
3210: ignore := DBMS_SQL.EXECUTE(destination_cursor);
3211: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
3212:
3213: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3214: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_PUB.populateGTBulkTable', FALSE);
3215: end if;

Line 3223: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN

3219: END IF;
3220:
3221: EXCEPTION
3222: WHEN OTHERS THEN
3223: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
3224: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
3225: END IF;
3226: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3227: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.populateGTBulkTable:->'||p_insert_statement, FALSE);

Line 3224: DBMS_SQL.CLOSE_CURSOR(destination_cursor);

3220:
3221: EXCEPTION
3222: WHEN OTHERS THEN
3223: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
3224: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
3225: END IF;
3226: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3227: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.populateGTBulkTable:->'||p_insert_statement, FALSE);
3228: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.populateGTBulkTable:->'||SQLERRM, FALSE);

Line 3269: source_cursor := DBMS_SQL.OPEN_CURSOR;

3265: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.isRuleValid:->p_param_view_name='||p_param_view_name, FALSE);
3266: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.isRuleValid:->l_where_clause'||x_where_clause, FALSE);
3267: end if;
3268:
3269: source_cursor := DBMS_SQL.OPEN_CURSOR;
3270: DBMS_SQL.PARSE(source_cursor, l_select, DBMS_SQL.native);
3271:
3272: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_num);
3273: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);

Line 3270: DBMS_SQL.PARSE(source_cursor, l_select, DBMS_SQL.native);

3266: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.isRuleValid:->l_where_clause'||x_where_clause, FALSE);
3267: end if;
3268:
3269: source_cursor := DBMS_SQL.OPEN_CURSOR;
3270: DBMS_SQL.PARSE(source_cursor, l_select, DBMS_SQL.native);
3271:
3272: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_num);
3273: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
3274:

Line 3272: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_num);

3268:
3269: source_cursor := DBMS_SQL.OPEN_CURSOR;
3270: DBMS_SQL.PARSE(source_cursor, l_select, DBMS_SQL.native);
3271:
3272: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_num);
3273: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
3274:
3275: /*IF its not a valid SQL statement, then here it goes to Exception
3276: *Else return TRUE.

Line 3273: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);

3269: source_cursor := DBMS_SQL.OPEN_CURSOR;
3270: DBMS_SQL.PARSE(source_cursor, l_select, DBMS_SQL.native);
3271:
3272: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_num);
3273: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
3274:
3275: /*IF its not a valid SQL statement, then here it goes to Exception
3276: *Else return TRUE.
3277: */

Line 3278: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN

3274:
3275: /*IF its not a valid SQL statement, then here it goes to Exception
3276: *Else return TRUE.
3277: */
3278: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
3279: -- get column values of the row
3280: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);
3281: IF(l_num > 0) THEN
3282: l_present := true;

Line 3280: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);

3276: *Else return TRUE.
3277: */
3278: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
3279: -- get column values of the row
3280: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);
3281: IF(l_num > 0) THEN
3282: l_present := true;
3283: END IF;
3284: END IF;

Line 3286: DBMS_SQL.CLOSE_CURSOR(source_cursor);

3282: l_present := true;
3283: END IF;
3284: END IF;
3285:
3286: DBMS_SQL.CLOSE_CURSOR(source_cursor);
3287: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3288: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_PUB.isRuleValid', FALSE);
3289: end if;
3290:

Line 3295: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

3291: RETURN l_present;
3292:
3293: EXCEPTION
3294: WHEN OTHERS THEN
3295: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
3296: DBMS_SQL.CLOSE_CURSOR(source_cursor);
3297: END IF;
3298: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3299: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.isRuleValid:->'||SQLERRM, FALSE);

Line 3296: DBMS_SQL.CLOSE_CURSOR(source_cursor);

3292:
3293: EXCEPTION
3294: WHEN OTHERS THEN
3295: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
3296: DBMS_SQL.CLOSE_CURSOR(source_cursor);
3297: END IF;
3298: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3299: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.isRuleValid:->'||SQLERRM, FALSE);
3300: END IF;