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 480: destination_cursor := DBMS_SQL.OPEN_CURSOR;

476: IF(l_application_id IS NULL) THEN
477: l_application_id := FND_GLOBAL.RESP_APPL_ID;
478: END IF;
479:
480: destination_cursor := DBMS_SQL.OPEN_CURSOR;
481:
482:
483: --IF Instance Context is set, then append the where clause with an extra bind variable i.e
484: --AND INSTANCE_LABEL = :3

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

492: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
493: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'apply_rule :->g_sRuleDetailSql='||g_sRuleDetailSql, FALSE);
494: end if;
495:
496: DBMS_SQL.PARSE(destination_cursor, g_sRuleDetailSql,DBMS_SQL.native);
497: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);
498: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
499:
500: IF (m_instance_context = 'Y') THEN

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

493: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'apply_rule :->g_sRuleDetailSql='||g_sRuleDetailSql, FALSE);
494: end if;
495:
496: DBMS_SQL.PARSE(destination_cursor, g_sRuleDetailSql,DBMS_SQL.native);
497: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);
498: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
499:
500: IF (m_instance_context = 'Y') THEN
501: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);

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

494: end if;
495:
496: DBMS_SQL.PARSE(destination_cursor, g_sRuleDetailSql,DBMS_SQL.native);
497: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);
498: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
499:
500: IF (m_instance_context = 'Y') THEN
501: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
502: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);

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

497: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);
498: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
499:
500: IF (m_instance_context = 'Y') THEN
501: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
502: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
503: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
504:
505: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);

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

498: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
499:
500: IF (m_instance_context = 'Y') THEN
501: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
502: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
503: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
504:
505: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
506: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);

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

499:
500: IF (m_instance_context = 'Y') THEN
501: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
502: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
503: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
504:
505: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
506: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
507: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);

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

501: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
502: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
503: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
504:
505: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
506: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
507: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
508: END IF;
509:

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

502: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
503: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
504:
505: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
506: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
507: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
508: END IF;
509:
510: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);

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

503: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
504:
505: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
506: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
507: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
508: END IF;
509:
510: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
511: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);

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

506: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
507: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
508: END IF;
509:
510: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
511: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
512: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
513: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
514: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);

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

507: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
508: END IF;
509:
510: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
511: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
512: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
513: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
514: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
515: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);

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

508: END IF;
509:
510: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
511: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
512: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
513: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
514: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
515: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
516: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);

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

509:
510: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
511: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
512: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
513: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
514: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
515: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
516: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
517: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);

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

510: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
511: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
512: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
513: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
514: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
515: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
516: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
517: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);
518:

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

511: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
512: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
513: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
514: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
515: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
516: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
517: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);
518:
519: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);

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

512: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
513: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
514: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
515: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
516: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
517: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);
518:
519: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);
520:

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

513: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
514: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
515: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
516: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
517: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);
518:
519: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);
520:
521: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop

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

515: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
516: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
517: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);
518:
519: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);
520:
521: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop
522: l_isAnyActiveRule := true; --i.e Atleast one Rule is present.
523:

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

517: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);
518:
519: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);
520:
521: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop
522: l_isAnyActiveRule := true; --i.e Atleast one Rule is present.
523:
524: dbms_sql.column_value(destination_cursor, 1, l_result_type);
525: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );

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

520:
521: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop
522: l_isAnyActiveRule := true; --i.e Atleast one Rule is present.
523:
524: dbms_sql.column_value(destination_cursor, 1, l_result_type);
525: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
526: dbms_sql.column_value(destination_cursor, 3, l_operator);
527: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
528: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);

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

521: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop
522: l_isAnyActiveRule := true; --i.e Atleast one Rule is present.
523:
524: dbms_sql.column_value(destination_cursor, 1, l_result_type);
525: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
526: dbms_sql.column_value(destination_cursor, 3, l_operator);
527: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
528: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
529: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);

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

522: l_isAnyActiveRule := true; --i.e Atleast one Rule is present.
523:
524: dbms_sql.column_value(destination_cursor, 1, l_result_type);
525: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
526: dbms_sql.column_value(destination_cursor, 3, l_operator);
527: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
528: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
529: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
530: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);

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

523:
524: dbms_sql.column_value(destination_cursor, 1, l_result_type);
525: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
526: dbms_sql.column_value(destination_cursor, 3, l_operator);
527: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
528: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
529: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
530: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
531: dbms_sql.column_value(destination_cursor, 8, l_useDefaultValueFlag);

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

524: dbms_sql.column_value(destination_cursor, 1, l_result_type);
525: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
526: dbms_sql.column_value(destination_cursor, 3, l_operator);
527: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
528: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
529: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
530: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
531: dbms_sql.column_value(destination_cursor, 8, l_useDefaultValueFlag);
532: m_multiRuleResultFlag := l_multiRuleResultFlag;

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

525: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
526: dbms_sql.column_value(destination_cursor, 3, l_operator);
527: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
528: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
529: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
530: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
531: dbms_sql.column_value(destination_cursor, 8, l_useDefaultValueFlag);
532: m_multiRuleResultFlag := l_multiRuleResultFlag;
533: m_useDefaultValueFlag := l_useDefaultValueFlag;

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

526: dbms_sql.column_value(destination_cursor, 3, l_operator);
527: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
528: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
529: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
530: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
531: dbms_sql.column_value(destination_cursor, 8, l_useDefaultValueFlag);
532: m_multiRuleResultFlag := l_multiRuleResultFlag;
533: m_useDefaultValueFlag := l_useDefaultValueFlag;
534:

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

527: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
528: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
529: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
530: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
531: dbms_sql.column_value(destination_cursor, 8, l_useDefaultValueFlag);
532: m_multiRuleResultFlag := l_multiRuleResultFlag;
533: m_useDefaultValueFlag := l_useDefaultValueFlag;
534:
535:

Line 542: params_cursor := DBMS_SQL.OPEN_CURSOR;

538: ELSE
539: l_ret_val := true;
540: END IF;
541:
542: params_cursor := DBMS_SQL.OPEN_CURSOR;
543:
544: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
545: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'apply_rule :->g_sCriteriaParamSql='||g_sCriteriaParamSql, FALSE);
546: end if;

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

544: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
545: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'apply_rule :->g_sCriteriaParamSql='||g_sCriteriaParamSql, FALSE);
546: end if;
547:
548: DBMS_SQL.PARSE(params_cursor, g_sCriteriaParamSql,DBMS_SQL.native);
549: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
550: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
551:
552: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);

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

545: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'apply_rule :->g_sCriteriaParamSql='||g_sCriteriaParamSql, FALSE);
546: end if;
547:
548: DBMS_SQL.PARSE(params_cursor, g_sCriteriaParamSql,DBMS_SQL.native);
549: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
550: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
551:
552: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
553: dbms_sql.define_column(params_cursor, 2, l_condition , 15);

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

546: end if;
547:
548: DBMS_SQL.PARSE(params_cursor, g_sCriteriaParamSql,DBMS_SQL.native);
549: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
550: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
551:
552: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
553: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
554: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);

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

548: DBMS_SQL.PARSE(params_cursor, g_sCriteriaParamSql,DBMS_SQL.native);
549: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
550: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
551:
552: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
553: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
554: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
555: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
556: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);

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

549: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
550: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
551:
552: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
553: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
554: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
555: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
556: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
557: dbms_sql.define_column(params_cursor, 6, l_criteria_id);

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

550: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
551:
552: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
553: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
554: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
555: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
556: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
557: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
558:

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

551:
552: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
553: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
554: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
555: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
556: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
557: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
558:
559: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);

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

552: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
553: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
554: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
555: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
556: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
557: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
558:
559: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
560:

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

553: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
554: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
555: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
556: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
557: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
558:
559: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
560:
561: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop

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

555: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
556: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
557: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
558:
559: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
560:
561: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
562: dbms_sql.column_value(params_cursor, 1, l_param_name );
563: dbms_sql.column_value(params_cursor, 2, l_condition );

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

557: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
558:
559: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
560:
561: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
562: dbms_sql.column_value(params_cursor, 1, l_param_name );
563: dbms_sql.column_value(params_cursor, 2, l_condition );
564: dbms_sql.column_value(params_cursor, 3, l_param_value);
565: dbms_sql.column_value(params_cursor, 4, l_data_type);

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

558:
559: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
560:
561: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
562: dbms_sql.column_value(params_cursor, 1, l_param_name );
563: dbms_sql.column_value(params_cursor, 2, l_condition );
564: dbms_sql.column_value(params_cursor, 3, l_param_value);
565: dbms_sql.column_value(params_cursor, 4, l_data_type);
566: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);

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

559: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
560:
561: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
562: dbms_sql.column_value(params_cursor, 1, l_param_name );
563: dbms_sql.column_value(params_cursor, 2, l_condition );
564: dbms_sql.column_value(params_cursor, 3, l_param_value);
565: dbms_sql.column_value(params_cursor, 4, l_data_type);
566: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
567: dbms_sql.column_value(params_cursor, 6, l_criteria_id);

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

560:
561: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
562: dbms_sql.column_value(params_cursor, 1, l_param_name );
563: dbms_sql.column_value(params_cursor, 2, l_condition );
564: dbms_sql.column_value(params_cursor, 3, l_param_value);
565: dbms_sql.column_value(params_cursor, 4, l_data_type);
566: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
567: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
568:

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

561: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
562: dbms_sql.column_value(params_cursor, 1, l_param_name );
563: dbms_sql.column_value(params_cursor, 2, l_condition );
564: dbms_sql.column_value(params_cursor, 3, l_param_value);
565: dbms_sql.column_value(params_cursor, 4, l_data_type);
566: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
567: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
568:
569:

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

562: dbms_sql.column_value(params_cursor, 1, l_param_name );
563: dbms_sql.column_value(params_cursor, 2, l_condition );
564: dbms_sql.column_value(params_cursor, 3, l_param_value);
565: dbms_sql.column_value(params_cursor, 4, l_data_type);
566: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
567: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
568:
569:
570: if(l_param_name = 'APPLICATION') then

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

563: dbms_sql.column_value(params_cursor, 2, l_condition );
564: dbms_sql.column_value(params_cursor, 3, l_param_value);
565: dbms_sql.column_value(params_cursor, 4, l_data_type);
566: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
567: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
568:
569:
570: if(l_param_name = 'APPLICATION') then
571: if(NOT containsKey(g_parameter_list,'APPLICATION')) then

Line 616: DBMS_SQL.CLOSE_CURSOR(params_cursor);

612: l_ret_val := matchCriteria(l_param_name, l_condition, l_ParamMultiValueList,
613: l_data_type, g_parameter_list, l_case_sensitive) OR l_ret_val ;
614: END IF;
615: end loop;
616: DBMS_SQL.CLOSE_CURSOR(params_cursor);
617:
618: l_all_rule_retval := l_all_rule_retval OR l_ret_val;
619:
620: setResultValues(l_ret_val,

Line 643: DBMS_SQL.CLOSE_CURSOR(destination_cursor);

639: end if;
640:
641: end loop;
642:
643: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
644:
645: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
646: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'apply_rule :->Before calling setResultValues', FALSE);
647: end if;

Line 716: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN

712: fnd_message.set_name('FUN','NO_DEFAULT_VALUE_EXCEPTION');
713: app_exception.raise_exception;
714:
715: WHEN OTHERS THEN
716: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
717: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
718: END IF;
719: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
720: DBMS_SQL.CLOSE_CURSOR(params_cursor);

Line 717: DBMS_SQL.CLOSE_CURSOR(destination_cursor);

713: app_exception.raise_exception;
714:
715: WHEN OTHERS THEN
716: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
717: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
718: END IF;
719: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
720: DBMS_SQL.CLOSE_CURSOR(params_cursor);
721: END IF;

Line 719: IF DBMS_SQL.IS_OPEN(params_cursor) THEN

715: WHEN OTHERS THEN
716: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
717: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
718: END IF;
719: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
720: DBMS_SQL.CLOSE_CURSOR(params_cursor);
721: END IF;
722: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
723: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.APLY_RULE:->'||SQLERRM, FALSE);

Line 720: DBMS_SQL.CLOSE_CURSOR(params_cursor);

716: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
717: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
718: END IF;
719: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
720: DBMS_SQL.CLOSE_CURSOR(params_cursor);
721: END IF;
722: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
723: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.APLY_RULE:->'||SQLERRM, FALSE);
724: END IF;

Line 800: destination_cursor := DBMS_SQL.OPEN_CURSOR;

796: IF(l_application_id IS NULL) THEN
797: l_application_id := FND_GLOBAL.RESP_APPL_ID;
798: END IF;
799:
800: destination_cursor := DBMS_SQL.OPEN_CURSOR;
801:
802: --IF Instance Context is set, then append the where clause with an extra bind variable i.e
803: --AND INSTANCE_LABEL = :3
804:

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

811: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
812: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.APPLY_RULE Boolean:->g_sRuleDetailSql='||g_sRuleDetailSql, FALSE);
813: end if;
814:
815: DBMS_SQL.PARSE(destination_cursor, g_sRuleDetailSql,DBMS_SQL.native);
816: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);
817: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
818:
819: IF (m_instance_context = 'Y') THEN

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

812: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.APPLY_RULE Boolean:->g_sRuleDetailSql='||g_sRuleDetailSql, FALSE);
813: end if;
814:
815: DBMS_SQL.PARSE(destination_cursor, g_sRuleDetailSql,DBMS_SQL.native);
816: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);
817: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
818:
819: IF (m_instance_context = 'Y') THEN
820: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);

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

813: end if;
814:
815: DBMS_SQL.PARSE(destination_cursor, g_sRuleDetailSql,DBMS_SQL.native);
816: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);
817: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
818:
819: IF (m_instance_context = 'Y') THEN
820: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
821: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);

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

816: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);
817: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
818:
819: IF (m_instance_context = 'Y') THEN
820: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
821: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
822: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
823:
824: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);

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

817: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
818:
819: IF (m_instance_context = 'Y') THEN
820: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
821: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
822: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
823:
824: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
825: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);

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

818:
819: IF (m_instance_context = 'Y') THEN
820: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
821: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
822: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
823:
824: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
825: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
826: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);

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

820: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
821: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
822: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
823:
824: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
825: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
826: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
827:
828: END IF;

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

821: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
822: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
823:
824: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
825: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
826: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
827:
828: END IF;
829:

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

822: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
823:
824: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
825: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
826: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
827:
828: END IF;
829:
830:

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

827:
828: END IF;
829:
830:
831: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
832: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
833: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
834: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
835: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);

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

828: END IF;
829:
830:
831: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
832: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
833: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
834: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
835: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
836: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);

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

829:
830:
831: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
832: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
833: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
834: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
835: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
836: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
837: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);

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

830:
831: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
832: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
833: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
834: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
835: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
836: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
837: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
838: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);

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

831: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
832: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
833: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
834: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
835: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
836: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
837: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
838: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);
839:

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

832: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
833: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
834: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
835: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
836: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
837: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
838: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);
839:
840: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);

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

833: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
834: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
835: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
836: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
837: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
838: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);
839:
840: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);
841:

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

834: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
835: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
836: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
837: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
838: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);
839:
840: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);
841:
842: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop

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

836: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
837: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
838: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);
839:
840: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);
841:
842: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop
843: l_isAnyActiveRule := true; --i.e Atleast one Rule is present.
844:

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

838: dbms_sql.define_column(destination_cursor, 8, l_useDefaultValueFlag , 10);
839:
840: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);
841:
842: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop
843: l_isAnyActiveRule := true; --i.e Atleast one Rule is present.
844:
845: dbms_sql.column_value(destination_cursor, 1, l_result_type);
846: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );

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

841:
842: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop
843: l_isAnyActiveRule := true; --i.e Atleast one Rule is present.
844:
845: dbms_sql.column_value(destination_cursor, 1, l_result_type);
846: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
847: dbms_sql.column_value(destination_cursor, 3, l_operator);
848: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
849: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);

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

842: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop
843: l_isAnyActiveRule := true; --i.e Atleast one Rule is present.
844:
845: dbms_sql.column_value(destination_cursor, 1, l_result_type);
846: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
847: dbms_sql.column_value(destination_cursor, 3, l_operator);
848: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
849: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
850: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);

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

843: l_isAnyActiveRule := true; --i.e Atleast one Rule is present.
844:
845: dbms_sql.column_value(destination_cursor, 1, l_result_type);
846: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
847: dbms_sql.column_value(destination_cursor, 3, l_operator);
848: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
849: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
850: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
851: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);

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

844:
845: dbms_sql.column_value(destination_cursor, 1, l_result_type);
846: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
847: dbms_sql.column_value(destination_cursor, 3, l_operator);
848: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
849: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
850: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
851: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
852: dbms_sql.column_value(destination_cursor, 8, l_useDefaultValueFlag);

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

845: dbms_sql.column_value(destination_cursor, 1, l_result_type);
846: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
847: dbms_sql.column_value(destination_cursor, 3, l_operator);
848: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
849: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
850: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
851: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
852: dbms_sql.column_value(destination_cursor, 8, l_useDefaultValueFlag);
853: m_multiRuleResultFlag := l_multiRuleResultFlag;

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

846: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
847: dbms_sql.column_value(destination_cursor, 3, l_operator);
848: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
849: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
850: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
851: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
852: dbms_sql.column_value(destination_cursor, 8, l_useDefaultValueFlag);
853: m_multiRuleResultFlag := l_multiRuleResultFlag;
854: m_useDefaultValueFlag := l_useDefaultValueFlag;

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

847: dbms_sql.column_value(destination_cursor, 3, l_operator);
848: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
849: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
850: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
851: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
852: dbms_sql.column_value(destination_cursor, 8, l_useDefaultValueFlag);
853: m_multiRuleResultFlag := l_multiRuleResultFlag;
854: m_useDefaultValueFlag := l_useDefaultValueFlag;
855:

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

848: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
849: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
850: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
851: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
852: dbms_sql.column_value(destination_cursor, 8, l_useDefaultValueFlag);
853: m_multiRuleResultFlag := l_multiRuleResultFlag;
854: m_useDefaultValueFlag := l_useDefaultValueFlag;
855:
856: IF (L_OPERATOR = C_OR) THEN

Line 862: params_cursor := DBMS_SQL.OPEN_CURSOR;

858: ELSE
859: l_ret_val := true;
860: END IF;
861:
862: params_cursor := DBMS_SQL.OPEN_CURSOR;
863:
864: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
865: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.APPLY_RULE Boolean:->g_sCriteriaParamSql='||g_sCriteriaParamSql, FALSE);
866: end if;

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

864: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
865: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.APPLY_RULE Boolean:->g_sCriteriaParamSql='||g_sCriteriaParamSql, FALSE);
866: end if;
867:
868: DBMS_SQL.PARSE(params_cursor, g_sCriteriaParamSql,DBMS_SQL.native);
869: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
870: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
871:
872: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);

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

865: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.APPLY_RULE Boolean:->g_sCriteriaParamSql='||g_sCriteriaParamSql, FALSE);
866: end if;
867:
868: DBMS_SQL.PARSE(params_cursor, g_sCriteriaParamSql,DBMS_SQL.native);
869: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
870: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
871:
872: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
873: dbms_sql.define_column(params_cursor, 2, l_condition , 15);

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

866: end if;
867:
868: DBMS_SQL.PARSE(params_cursor, g_sCriteriaParamSql,DBMS_SQL.native);
869: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
870: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
871:
872: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
873: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
874: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);

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

868: DBMS_SQL.PARSE(params_cursor, g_sCriteriaParamSql,DBMS_SQL.native);
869: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
870: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
871:
872: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
873: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
874: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
875: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
876: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);

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

869: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
870: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
871:
872: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
873: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
874: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
875: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
876: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
877: dbms_sql.define_column(params_cursor, 6, l_criteria_id);

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

870: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
871:
872: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
873: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
874: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
875: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
876: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
877: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
878:

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

871:
872: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
873: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
874: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
875: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
876: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
877: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
878:
879: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);

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

872: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
873: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
874: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
875: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
876: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
877: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
878:
879: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
880:

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

873: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
874: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
875: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
876: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
877: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
878:
879: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
880:
881: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop

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

875: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
876: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
877: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
878:
879: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
880:
881: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
882: dbms_sql.column_value(params_cursor, 1, l_param_name );
883: dbms_sql.column_value(params_cursor, 2, l_condition );

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

877: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
878:
879: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
880:
881: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
882: dbms_sql.column_value(params_cursor, 1, l_param_name );
883: dbms_sql.column_value(params_cursor, 2, l_condition );
884: dbms_sql.column_value(params_cursor, 3, l_param_value);
885: dbms_sql.column_value(params_cursor, 4, l_data_type);

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

878:
879: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
880:
881: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
882: dbms_sql.column_value(params_cursor, 1, l_param_name );
883: dbms_sql.column_value(params_cursor, 2, l_condition );
884: dbms_sql.column_value(params_cursor, 3, l_param_value);
885: dbms_sql.column_value(params_cursor, 4, l_data_type);
886: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);

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

879: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
880:
881: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
882: dbms_sql.column_value(params_cursor, 1, l_param_name );
883: dbms_sql.column_value(params_cursor, 2, l_condition );
884: dbms_sql.column_value(params_cursor, 3, l_param_value);
885: dbms_sql.column_value(params_cursor, 4, l_data_type);
886: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
887: dbms_sql.column_value(params_cursor, 6, l_criteria_id);

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

880:
881: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
882: dbms_sql.column_value(params_cursor, 1, l_param_name );
883: dbms_sql.column_value(params_cursor, 2, l_condition );
884: dbms_sql.column_value(params_cursor, 3, l_param_value);
885: dbms_sql.column_value(params_cursor, 4, l_data_type);
886: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
887: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
888:

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

881: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
882: dbms_sql.column_value(params_cursor, 1, l_param_name );
883: dbms_sql.column_value(params_cursor, 2, l_condition );
884: dbms_sql.column_value(params_cursor, 3, l_param_value);
885: dbms_sql.column_value(params_cursor, 4, l_data_type);
886: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
887: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
888:
889: if(l_param_name = 'APPLICATION') then

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

882: dbms_sql.column_value(params_cursor, 1, l_param_name );
883: dbms_sql.column_value(params_cursor, 2, l_condition );
884: dbms_sql.column_value(params_cursor, 3, l_param_value);
885: dbms_sql.column_value(params_cursor, 4, l_data_type);
886: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
887: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
888:
889: if(l_param_name = 'APPLICATION') then
890: if(NOT containsKey(g_parameter_list,'APPLICATION')) then

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

883: dbms_sql.column_value(params_cursor, 2, l_condition );
884: dbms_sql.column_value(params_cursor, 3, l_param_value);
885: dbms_sql.column_value(params_cursor, 4, l_data_type);
886: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
887: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
888:
889: if(l_param_name = 'APPLICATION') then
890: if(NOT containsKey(g_parameter_list,'APPLICATION')) then
891: add_parameter('APPLICATION' , FND_GLOBAL.RESP_APPL_ID);

Line 935: DBMS_SQL.CLOSE_CURSOR(params_cursor);

931: l_ret_val := matchCriteria(l_param_name, l_condition, l_ParamMultiValueList,
932: l_data_type, g_parameter_list, l_case_sensitive) OR l_ret_val ;
933: END IF;
934: end loop;
935: DBMS_SQL.CLOSE_CURSOR(params_cursor);
936:
937: l_all_rule_retval := l_all_rule_retval OR l_ret_val;
938:
939: setResultValues(l_ret_val,

Line 962: DBMS_SQL.CLOSE_CURSOR(destination_cursor);

958: end if;
959:
960: end loop;
961:
962: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
963:
964: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
965: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.APPLY_RULE Boolean:->before setResultValues', FALSE);
966: end if;

Line 1033: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN

1029:
1030: RAISE;
1031:
1032: WHEN OTHERS THEN
1033: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
1034: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
1035: END IF;
1036: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
1037: DBMS_SQL.CLOSE_CURSOR(params_cursor);

Line 1034: DBMS_SQL.CLOSE_CURSOR(destination_cursor);

1030: RAISE;
1031:
1032: WHEN OTHERS THEN
1033: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
1034: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
1035: END IF;
1036: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
1037: DBMS_SQL.CLOSE_CURSOR(params_cursor);
1038: END IF;

Line 1036: IF DBMS_SQL.IS_OPEN(params_cursor) THEN

1032: WHEN OTHERS THEN
1033: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
1034: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
1035: END IF;
1036: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
1037: DBMS_SQL.CLOSE_CURSOR(params_cursor);
1038: END IF;
1039: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1040: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.APLY_RULE Boolean:->'||SQLERRM, FALSE);

Line 1037: DBMS_SQL.CLOSE_CURSOR(params_cursor);

1033: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
1034: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
1035: END IF;
1036: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
1037: DBMS_SQL.CLOSE_CURSOR(params_cursor);
1038: END IF;
1039: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1040: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.APLY_RULE Boolean:->'||SQLERRM, FALSE);
1041: END IF;

Line 1318: params_cursor := DBMS_SQL.OPEN_CURSOR;

1314: return C_STRINGS;
1315:
1316: elsif (C_VALUESET = p_ObjectType) then
1317:
1318: params_cursor := DBMS_SQL.OPEN_CURSOR;
1319: DBMS_SQL.PARSE(params_cursor, g_sValueSetSql,DBMS_SQL.native);
1320: dbms_sql.bind_variable(params_cursor , '1' , p_RuleObjectId);
1321:
1322: dbms_sql.define_column(params_cursor, 1, l_ValueSetType , 10);

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

1315:
1316: elsif (C_VALUESET = p_ObjectType) then
1317:
1318: params_cursor := DBMS_SQL.OPEN_CURSOR;
1319: DBMS_SQL.PARSE(params_cursor, g_sValueSetSql,DBMS_SQL.native);
1320: dbms_sql.bind_variable(params_cursor , '1' , p_RuleObjectId);
1321:
1322: dbms_sql.define_column(params_cursor, 1, l_ValueSetType , 10);
1323:

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

1316: elsif (C_VALUESET = p_ObjectType) then
1317:
1318: params_cursor := DBMS_SQL.OPEN_CURSOR;
1319: DBMS_SQL.PARSE(params_cursor, g_sValueSetSql,DBMS_SQL.native);
1320: dbms_sql.bind_variable(params_cursor , '1' , p_RuleObjectId);
1321:
1322: dbms_sql.define_column(params_cursor, 1, l_ValueSetType , 10);
1323:
1324: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);

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

1318: params_cursor := DBMS_SQL.OPEN_CURSOR;
1319: DBMS_SQL.PARSE(params_cursor, g_sValueSetSql,DBMS_SQL.native);
1320: dbms_sql.bind_variable(params_cursor , '1' , p_RuleObjectId);
1321:
1322: dbms_sql.define_column(params_cursor, 1, l_ValueSetType , 10);
1323:
1324: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
1325:
1326: if(dbms_sql.fetch_rows(params_cursor) > 0 ) then

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

1320: dbms_sql.bind_variable(params_cursor , '1' , p_RuleObjectId);
1321:
1322: dbms_sql.define_column(params_cursor, 1, l_ValueSetType , 10);
1323:
1324: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
1325:
1326: if(dbms_sql.fetch_rows(params_cursor) > 0 ) then
1327: dbms_sql.column_value(params_cursor, 1, l_ValueSetType );
1328: end if;

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

1322: dbms_sql.define_column(params_cursor, 1, l_ValueSetType , 10);
1323:
1324: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
1325:
1326: if(dbms_sql.fetch_rows(params_cursor) > 0 ) then
1327: dbms_sql.column_value(params_cursor, 1, l_ValueSetType );
1328: end if;
1329: end if;
1330:

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

1323:
1324: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
1325:
1326: if(dbms_sql.fetch_rows(params_cursor) > 0 ) then
1327: dbms_sql.column_value(params_cursor, 1, l_ValueSetType );
1328: end if;
1329: end if;
1330:
1331: DBMS_SQL.CLOSE_CURSOR(params_cursor);

Line 1331: DBMS_SQL.CLOSE_CURSOR(params_cursor);

1327: dbms_sql.column_value(params_cursor, 1, l_ValueSetType );
1328: end if;
1329: end if;
1330:
1331: DBMS_SQL.CLOSE_CURSOR(params_cursor);
1332:
1333: if( l_ValueSetType = 'C' ) then return C_STRINGS;
1334: elsif ( l_ValueSetType = 'N' ) then return C_NUMERIC;
1335: elsif ( l_ValueSetType = 'D' OR l_ValueSetType = 'T' OR l_ValueSetType = 't' OR l_ValueSetType = 'X') then return C_DATE;

Line 1354: IF DBMS_SQL.IS_OPEN(params_cursor) THEN

1350:
1351: RAISE;
1352:
1353: WHEN OTHERS THEN
1354: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
1355: DBMS_SQL.CLOSE_CURSOR(params_cursor);
1356: END IF;
1357: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1358: fnd_log.message(FND_LOG.LEVEL_EXCEPTION, 'FUN_RULE_PUB.getResultValueDataType:->g_sValueSetSql='||g_sValueSetSql, FALSE);

Line 1355: DBMS_SQL.CLOSE_CURSOR(params_cursor);

1351: RAISE;
1352:
1353: WHEN OTHERS THEN
1354: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
1355: DBMS_SQL.CLOSE_CURSOR(params_cursor);
1356: END IF;
1357: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1358: fnd_log.message(FND_LOG.LEVEL_EXCEPTION, 'FUN_RULE_PUB.getResultValueDataType:->g_sValueSetSql='||g_sValueSetSql, FALSE);
1359: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getResultValueDataType:->'||SQLERRM, FALSE);

Line 1382: params_cursor := DBMS_SQL.OPEN_CURSOR;

1378: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1379: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.getMultiValueParamsArray', FALSE);
1380: end if;
1381:
1382: params_cursor := DBMS_SQL.OPEN_CURSOR;
1383: DBMS_SQL.PARSE(params_cursor, g_sMultiCriteriaParamValueSql,DBMS_SQL.native);
1384: dbms_sql.bind_variable(params_cursor , '1' , p_rule_detail_id);
1385: dbms_sql.bind_variable(params_cursor , '2' , p_rule_criteria_id);
1386:

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

1379: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.getMultiValueParamsArray', FALSE);
1380: end if;
1381:
1382: params_cursor := DBMS_SQL.OPEN_CURSOR;
1383: DBMS_SQL.PARSE(params_cursor, g_sMultiCriteriaParamValueSql,DBMS_SQL.native);
1384: dbms_sql.bind_variable(params_cursor , '1' , p_rule_detail_id);
1385: dbms_sql.bind_variable(params_cursor , '2' , p_rule_criteria_id);
1386:
1387: dbms_sql.define_column(params_cursor, 1, l_param_value , 1024);

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

1380: end if;
1381:
1382: params_cursor := DBMS_SQL.OPEN_CURSOR;
1383: DBMS_SQL.PARSE(params_cursor, g_sMultiCriteriaParamValueSql,DBMS_SQL.native);
1384: dbms_sql.bind_variable(params_cursor , '1' , p_rule_detail_id);
1385: dbms_sql.bind_variable(params_cursor , '2' , p_rule_criteria_id);
1386:
1387: dbms_sql.define_column(params_cursor, 1, l_param_value , 1024);
1388:

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

1381:
1382: params_cursor := DBMS_SQL.OPEN_CURSOR;
1383: DBMS_SQL.PARSE(params_cursor, g_sMultiCriteriaParamValueSql,DBMS_SQL.native);
1384: dbms_sql.bind_variable(params_cursor , '1' , p_rule_detail_id);
1385: dbms_sql.bind_variable(params_cursor , '2' , p_rule_criteria_id);
1386:
1387: dbms_sql.define_column(params_cursor, 1, l_param_value , 1024);
1388:
1389: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);

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

1383: DBMS_SQL.PARSE(params_cursor, g_sMultiCriteriaParamValueSql,DBMS_SQL.native);
1384: dbms_sql.bind_variable(params_cursor , '1' , p_rule_detail_id);
1385: dbms_sql.bind_variable(params_cursor , '2' , p_rule_criteria_id);
1386:
1387: dbms_sql.define_column(params_cursor, 1, l_param_value , 1024);
1388:
1389: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
1390:
1391: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop

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

1385: dbms_sql.bind_variable(params_cursor , '2' , p_rule_criteria_id);
1386:
1387: dbms_sql.define_column(params_cursor, 1, l_param_value , 1024);
1388:
1389: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
1390:
1391: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
1392: dbms_sql.column_value(params_cursor, 1, l_param_value );
1393: p_multi_param_value(l_counter) := l_param_value;

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

1387: dbms_sql.define_column(params_cursor, 1, l_param_value , 1024);
1388:
1389: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
1390:
1391: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
1392: dbms_sql.column_value(params_cursor, 1, l_param_value );
1393: p_multi_param_value(l_counter) := l_param_value;
1394: l_counter := l_counter + 1;
1395: end loop;

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

1388:
1389: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
1390:
1391: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
1392: dbms_sql.column_value(params_cursor, 1, l_param_value );
1393: p_multi_param_value(l_counter) := l_param_value;
1394: l_counter := l_counter + 1;
1395: end loop;
1396:

Line 1397: DBMS_SQL.CLOSE_CURSOR(params_cursor);

1393: p_multi_param_value(l_counter) := l_param_value;
1394: l_counter := l_counter + 1;
1395: end loop;
1396:
1397: DBMS_SQL.CLOSE_CURSOR(params_cursor);
1398:
1399: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1400: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_PUB.getMultiValueParamsArray', FALSE);
1401: end if;

Line 1413: IF DBMS_SQL.IS_OPEN(params_cursor) THEN

1409:
1410: RAISE;
1411:
1412: WHEN OTHERS THEN
1413: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
1414: DBMS_SQL.CLOSE_CURSOR(params_cursor);
1415: END IF;
1416: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1417: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getMultiValueParamsArray:->g_sMultiCriteriaParamValueSql='||g_sMultiCriteriaParamValueSql, FALSE);

Line 1414: DBMS_SQL.CLOSE_CURSOR(params_cursor);

1410: RAISE;
1411:
1412: WHEN OTHERS THEN
1413: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
1414: DBMS_SQL.CLOSE_CURSOR(params_cursor);
1415: END IF;
1416: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1417: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getMultiValueParamsArray:->g_sMultiCriteriaParamValueSql='||g_sMultiCriteriaParamValueSql, FALSE);
1418: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getMultiValueParamsArray:->'||SQLERRM, FALSE);

Line 1493: source_cursor := dbms_sql.open_cursor;

1489: sDFFTableName := i.application_table_name;
1490: end loop;
1491:
1492: -- Prepare a cursor to select from the source table:
1493: source_cursor := dbms_sql.open_cursor;
1494:
1495: /*If the Rule Object is an instance, then query the DFF table with RULE_OBJECT_ID as well.*/
1496:
1497: if(m_instance_context = 'Y') then

Line 1498: DBMS_SQL.PARSE(source_cursor,

1494:
1495: /*If the Rule Object is an instance, then query the DFF table with RULE_OBJECT_ID as well.*/
1496:
1497: if(m_instance_context = 'Y') then
1498: DBMS_SQL.PARSE(source_cursor,
1499: 'SELECT DFF.RULE_DETAIL_ID, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2,
1500: ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7,
1501: ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
1502: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15 , RULE_NAME , RESULT_APPLICATION_ID

Line 1505: , DBMS_SQL.native);

1501: ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
1502: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15 , RULE_NAME , RESULT_APPLICATION_ID
1503: FROM '|| sDFFTableName ||' DFF , FUN_RULE_DETAILS FRD
1504: WHERE DFF.RULE_DETAIL_ID = :1 AND DFF.RULE_OBJECT_ID = :2 AND DFF.RULE_DETAIL_ID = FRD.RULE_DETAIL_ID'
1505: , DBMS_SQL.native);
1506: else
1507: DBMS_SQL.PARSE(source_cursor,
1508: 'SELECT DFF.RULE_DETAIL_ID, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2,
1509: ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7,

Line 1507: DBMS_SQL.PARSE(source_cursor,

1503: FROM '|| sDFFTableName ||' DFF , FUN_RULE_DETAILS FRD
1504: WHERE DFF.RULE_DETAIL_ID = :1 AND DFF.RULE_OBJECT_ID = :2 AND DFF.RULE_DETAIL_ID = FRD.RULE_DETAIL_ID'
1505: , DBMS_SQL.native);
1506: else
1507: DBMS_SQL.PARSE(source_cursor,
1508: 'SELECT DFF.RULE_DETAIL_ID, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2,
1509: ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7,
1510: ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
1511: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15 , RULE_NAME , RESULT_APPLICATION_ID

Line 1514: , DBMS_SQL.native);

1510: ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
1511: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15 , RULE_NAME , RESULT_APPLICATION_ID
1512: FROM '|| sDFFTableName ||' DFF , FUN_RULE_DETAILS FRD
1513: WHERE DFF.RULE_DETAIL_ID = :1 AND DFF.RULE_DETAIL_ID = FRD.RULE_DETAIL_ID'
1514: , DBMS_SQL.native);
1515: end if;
1516:
1517: dbms_sql.bind_variable(source_cursor , '1' , p_RuleDetailId);
1518:

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

1513: WHERE DFF.RULE_DETAIL_ID = :1 AND DFF.RULE_DETAIL_ID = FRD.RULE_DETAIL_ID'
1514: , DBMS_SQL.native);
1515: end if;
1516:
1517: dbms_sql.bind_variable(source_cursor , '1' , p_RuleDetailId);
1518:
1519: if(m_instance_context = 'Y') then
1520: dbms_sql.bind_variable(source_cursor , '2' , m_ruleObjectId);
1521: end if;

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

1516:
1517: dbms_sql.bind_variable(source_cursor , '1' , p_RuleDetailId);
1518:
1519: if(m_instance_context = 'Y') then
1520: dbms_sql.bind_variable(source_cursor , '2' , m_ruleObjectId);
1521: end if;
1522:
1523: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);
1524: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);

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

1519: if(m_instance_context = 'Y') then
1520: dbms_sql.bind_variable(source_cursor , '2' , m_ruleObjectId);
1521: end if;
1522:
1523: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);
1524: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);
1525: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1526: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1527: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);

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

1520: dbms_sql.bind_variable(source_cursor , '2' , m_ruleObjectId);
1521: end if;
1522:
1523: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);
1524: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);
1525: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1526: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1527: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1528: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);

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

1521: end if;
1522:
1523: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);
1524: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);
1525: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1526: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1527: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1528: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1529: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);

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

1522:
1523: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);
1524: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);
1525: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1526: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1527: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1528: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1529: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1530: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);

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

1523: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);
1524: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);
1525: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1526: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1527: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1528: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1529: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1530: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1531: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);

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

1524: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);
1525: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1526: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1527: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1528: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1529: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1530: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1531: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);
1532: DBMS_SQL.DEFINE_COLUMN(source_cursor, 18, m_ruleName , 80);

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

1525: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1526: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1527: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1528: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1529: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1530: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1531: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);
1532: DBMS_SQL.DEFINE_COLUMN(source_cursor, 18, m_ruleName , 80);
1533: DBMS_SQL.DEFINE_COLUMN(source_cursor, 19, m_resultApplicationId);

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

1526: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1527: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1528: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1529: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1530: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1531: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);
1532: DBMS_SQL.DEFINE_COLUMN(source_cursor, 18, m_ruleName , 80);
1533: DBMS_SQL.DEFINE_COLUMN(source_cursor, 19, m_resultApplicationId);
1534:

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

1527: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1528: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1529: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1530: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1531: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);
1532: DBMS_SQL.DEFINE_COLUMN(source_cursor, 18, m_ruleName , 80);
1533: DBMS_SQL.DEFINE_COLUMN(source_cursor, 19, m_resultApplicationId);
1534:
1535:

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

1528: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1529: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1530: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1531: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);
1532: DBMS_SQL.DEFINE_COLUMN(source_cursor, 18, m_ruleName , 80);
1533: DBMS_SQL.DEFINE_COLUMN(source_cursor, 19, m_resultApplicationId);
1534:
1535:
1536: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);

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

1529: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1530: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1531: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);
1532: DBMS_SQL.DEFINE_COLUMN(source_cursor, 18, m_ruleName , 80);
1533: DBMS_SQL.DEFINE_COLUMN(source_cursor, 19, m_resultApplicationId);
1534:
1535:
1536: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1537:

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

1532: DBMS_SQL.DEFINE_COLUMN(source_cursor, 18, m_ruleName , 80);
1533: DBMS_SQL.DEFINE_COLUMN(source_cursor, 19, m_resultApplicationId);
1534:
1535:
1536: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1537:
1538: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1539: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1540: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);

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

1534:
1535:
1536: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1537:
1538: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1539: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1540: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1541: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1542: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);

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

1535:
1536: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1537:
1538: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1539: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1540: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1541: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1542: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1543: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);

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

1536: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1537:
1538: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1539: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1540: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1541: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1542: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1543: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1544: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);

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

1537:
1538: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1539: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1540: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1541: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1542: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1543: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1544: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1545: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);

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

1538: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1539: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1540: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1541: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1542: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1543: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1544: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1545: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1546: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);

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

1539: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1540: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1541: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1542: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1543: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1544: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1545: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1546: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);
1547: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);

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

1540: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1541: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1542: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1543: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1544: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1545: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1546: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);
1547: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);
1548: DBMS_SQL.column_value(source_cursor, 18, m_ruleName);

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

1541: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1542: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1543: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1544: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1545: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1546: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);
1547: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);
1548: DBMS_SQL.column_value(source_cursor, 18, m_ruleName);
1549: DBMS_SQL.column_value(source_cursor, 19, m_resultApplicationId);

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

1542: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1543: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1544: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1545: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1546: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);
1547: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);
1548: DBMS_SQL.column_value(source_cursor, 18, m_ruleName);
1549: DBMS_SQL.column_value(source_cursor, 19, m_resultApplicationId);
1550:

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

1543: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1544: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1545: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1546: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);
1547: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);
1548: DBMS_SQL.column_value(source_cursor, 18, m_ruleName);
1549: DBMS_SQL.column_value(source_cursor, 19, m_resultApplicationId);
1550:
1551: m_ruleDetailId := l_RuleDetailId;

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

1544: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1545: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1546: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);
1547: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);
1548: DBMS_SQL.column_value(source_cursor, 18, m_ruleName);
1549: DBMS_SQL.column_value(source_cursor, 19, m_resultApplicationId);
1550:
1551: m_ruleDetailId := l_RuleDetailId;
1552: -- m_resultValue := m_attributeCategory;

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

1545: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1546: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);
1547: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);
1548: DBMS_SQL.column_value(source_cursor, 18, m_ruleName);
1549: DBMS_SQL.column_value(source_cursor, 19, m_resultApplicationId);
1550:
1551: m_ruleDetailId := l_RuleDetailId;
1552: -- m_resultValue := m_attributeCategory;
1553: fnd_flex_descval.set_column_value('ATTRIBUTE_CATEGORY', m_attributeCategory);

Line 1581: DBMS_SQL.CLOSE_CURSOR(source_cursor);

1577: END IF;
1578:
1579: end loop;
1580:
1581: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1582:
1583: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1584: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_PUB.getDFFResultValue', FALSE);
1585: end if;

Line 1599: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

1595:
1596: RAISE;
1597:
1598: WHEN OTHERS THEN
1599: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
1600: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1601: END IF;
1602: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1603: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getDFFResultValue:->'||SQLERRM, FALSE);

Line 1600: DBMS_SQL.CLOSE_CURSOR(source_cursor);

1596: RAISE;
1597:
1598: WHEN OTHERS THEN
1599: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
1600: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1601: END IF;
1602: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1603: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getDFFResultValue:->'||SQLERRM, FALSE);
1604: END IF;

Line 1644: source_cursor := dbms_sql.open_cursor;

1640: sDFFTableName := i.application_table_name;
1641: end loop;
1642:
1643: -- Prepare a cursor to select from the source table:
1644: source_cursor := dbms_sql.open_cursor;
1645:
1646: /*If the Rule Object is an instance, then query the DFF table with RULE_OBJECT_ID as well.*/
1647:
1648: if(m_instance_context = 'Y') then

Line 1649: DBMS_SQL.PARSE(source_cursor,

1645:
1646: /*If the Rule Object is an instance, then query the DFF table with RULE_OBJECT_ID as well.*/
1647:
1648: if(m_instance_context = 'Y') then
1649: DBMS_SQL.PARSE(source_cursor,
1650: 'SELECT DFF.RULE_DETAIL_ID, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2,
1651: ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7,
1652: ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
1653: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15

Line 1656: , DBMS_SQL.native);

1652: ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
1653: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15
1654: FROM '|| sDFFTableName ||' DFF
1655: WHERE DFF.RULE_DETAIL_ID = -99 AND RULE_OBJECT_ID = :1'
1656: , DBMS_SQL.native);
1657: else
1658: DBMS_SQL.PARSE(source_cursor,
1659: 'SELECT DFF.RULE_DETAIL_ID, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2,
1660: ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7,

Line 1658: DBMS_SQL.PARSE(source_cursor,

1654: FROM '|| sDFFTableName ||' DFF
1655: WHERE DFF.RULE_DETAIL_ID = -99 AND RULE_OBJECT_ID = :1'
1656: , DBMS_SQL.native);
1657: else
1658: DBMS_SQL.PARSE(source_cursor,
1659: 'SELECT DFF.RULE_DETAIL_ID, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2,
1660: ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7,
1661: ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
1662: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15

Line 1665: , DBMS_SQL.native);

1661: ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
1662: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15
1663: FROM '|| sDFFTableName ||' DFF
1664: WHERE DFF.RULE_DETAIL_ID = -99 '
1665: , DBMS_SQL.native);
1666:
1667: end if;
1668:
1669: if(m_instance_context = 'Y') then

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

1666:
1667: end if;
1668:
1669: if(m_instance_context = 'Y') then
1670: dbms_sql.bind_variable(source_cursor , '1' , m_ruleObjectId);
1671: end if;
1672:
1673:
1674: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);

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

1670: dbms_sql.bind_variable(source_cursor , '1' , m_ruleObjectId);
1671: end if;
1672:
1673:
1674: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);
1675: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);
1676: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1677: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1678: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);

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

1671: end if;
1672:
1673:
1674: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);
1675: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);
1676: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1677: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1678: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1679: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);

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

1672:
1673:
1674: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);
1675: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);
1676: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1677: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1678: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1679: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1680: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);

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

1673:
1674: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);
1675: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);
1676: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1677: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1678: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1679: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1680: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1681: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);

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

1674: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_RuleDetailId); DBMS_SQL.DEFINE_COLUMN(source_cursor, 2, m_attributeCategory, 150);
1675: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);
1676: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1677: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1678: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1679: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1680: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1681: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1682: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);

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

1675: DBMS_SQL.DEFINE_COLUMN(source_cursor, 3, m_attribute1 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 4, m_attribute2 , 150);
1676: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1677: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1678: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1679: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1680: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1681: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1682: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);
1683:

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

1676: DBMS_SQL.DEFINE_COLUMN(source_cursor, 5, m_attribute3 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 6, m_attribute4 , 150);
1677: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1678: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1679: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1680: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1681: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1682: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);
1683:
1684: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);

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

1677: DBMS_SQL.DEFINE_COLUMN(source_cursor, 7, m_attribute5 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 8, m_attribute6 , 150);
1678: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1679: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1680: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1681: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1682: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);
1683:
1684: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1685:

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

1678: DBMS_SQL.DEFINE_COLUMN(source_cursor, 9, m_attribute7 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 10, m_attribute8 , 150);
1679: DBMS_SQL.DEFINE_COLUMN(source_cursor, 11, m_attribute9 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 12, m_attribute10 , 150);
1680: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1681: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1682: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);
1683:
1684: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1685:
1686: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop

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

1680: DBMS_SQL.DEFINE_COLUMN(source_cursor, 13, m_attribute11 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 14, m_attribute12 , 150);
1681: DBMS_SQL.DEFINE_COLUMN(source_cursor, 15, m_attribute13 , 150); DBMS_SQL.DEFINE_COLUMN(source_cursor, 16, m_attribute14 , 150);
1682: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);
1683:
1684: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1685:
1686: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1687: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1688: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);

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

1682: DBMS_SQL.DEFINE_COLUMN(source_cursor, 17, m_attribute15 , 150);
1683:
1684: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1685:
1686: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1687: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1688: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1689: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1690: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);

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

1683:
1684: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1685:
1686: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1687: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1688: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1689: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1690: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1691: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);

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

1684: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1685:
1686: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1687: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1688: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1689: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1690: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1691: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1692: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);

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

1685:
1686: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1687: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1688: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1689: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1690: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1691: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1692: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1693: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);

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

1686: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1687: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1688: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1689: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1690: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1691: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1692: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1693: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1694: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);

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

1687: DBMS_SQL.column_value(source_cursor, 1, l_RuleDetailId); DBMS_SQL.column_value(source_cursor, 2, m_attributeCategory);
1688: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1689: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1690: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1691: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1692: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1693: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1694: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);
1695: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);

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

1688: DBMS_SQL.column_value(source_cursor, 3, m_attribute1); DBMS_SQL.column_value(source_cursor, 4, m_attribute2);
1689: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1690: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1691: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1692: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1693: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1694: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);
1695: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);
1696:

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

1689: DBMS_SQL.column_value(source_cursor, 5, m_attribute3); DBMS_SQL.column_value(source_cursor, 6, m_attribute4);
1690: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1691: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1692: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1693: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1694: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);
1695: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);
1696:
1697: m_ruleDetailId := -99;

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

1690: DBMS_SQL.column_value(source_cursor, 7, m_attribute5); DBMS_SQL.column_value(source_cursor, 8, m_attribute6);
1691: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1692: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1693: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1694: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);
1695: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);
1696:
1697: m_ruleDetailId := -99;
1698: m_ruleName := 'Default Result';

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

1691: DBMS_SQL.column_value(source_cursor, 9, m_attribute7); DBMS_SQL.column_value(source_cursor, 10, m_attribute8);
1692: DBMS_SQL.column_value(source_cursor, 11, m_attribute9); DBMS_SQL.column_value(source_cursor, 12, m_attribute10);
1693: DBMS_SQL.column_value(source_cursor, 13, m_attribute11); DBMS_SQL.column_value(source_cursor, 14, m_attribute12);
1694: DBMS_SQL.column_value(source_cursor, 15, m_attribute13); DBMS_SQL.column_value(source_cursor, 16, m_attribute14);
1695: DBMS_SQL.column_value(source_cursor, 17, m_attribute15);
1696:
1697: m_ruleDetailId := -99;
1698: m_ruleName := 'Default Result';
1699: -- m_resultValue := m_attributeCategory;

Line 1727: DBMS_SQL.CLOSE_CURSOR(source_cursor);

1723: END IF;
1724:
1725: end loop;
1726:
1727: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1728:
1729: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1730: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_PUB.getDFFDefaultValue', FALSE);
1731: end if;

Line 1737: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

1733: return m_resultValue;
1734:
1735: EXCEPTION
1736: WHEN OTHERS THEN
1737: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
1738: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1739: END IF;
1740: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1741: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getDFFDefaultValue:->'||SQLERRM, FALSE);

Line 1738: DBMS_SQL.CLOSE_CURSOR(source_cursor);

1734:
1735: EXCEPTION
1736: WHEN OTHERS THEN
1737: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
1738: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1739: END IF;
1740: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1741: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getDFFDefaultValue:->'||SQLERRM, FALSE);
1742: END IF;

Line 1764: source_cursor := DBMS_SQL.OPEN_CURSOR;

1760: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1761: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.getResultValue:->p_ruleDetailId='||to_char(p_ruleDetailId)||'***p_ObjectType='||p_ObjectType, FALSE);
1762: end if;
1763:
1764: source_cursor := DBMS_SQL.OPEN_CURSOR;
1765:
1766: DBMS_SQL.PARSE(source_cursor, g_sResultValuesSql, DBMS_SQL.native);
1767: dbms_sql.bind_variable(source_cursor , '1' , p_ruleDetailId);
1768:

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

1762: end if;
1763:
1764: source_cursor := DBMS_SQL.OPEN_CURSOR;
1765:
1766: DBMS_SQL.PARSE(source_cursor, g_sResultValuesSql, DBMS_SQL.native);
1767: dbms_sql.bind_variable(source_cursor , '1' , p_ruleDetailId);
1768:
1769: dbms_sql.define_column(source_cursor, 1, l_rule_detail_id);
1770: dbms_sql.define_column(source_cursor, 2, l_result_value , 1024);

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

1763:
1764: source_cursor := DBMS_SQL.OPEN_CURSOR;
1765:
1766: DBMS_SQL.PARSE(source_cursor, g_sResultValuesSql, DBMS_SQL.native);
1767: dbms_sql.bind_variable(source_cursor , '1' , p_ruleDetailId);
1768:
1769: dbms_sql.define_column(source_cursor, 1, l_rule_detail_id);
1770: dbms_sql.define_column(source_cursor, 2, l_result_value , 1024);
1771: dbms_sql.define_column(source_cursor, 3, l_result_application_id);

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

1765:
1766: DBMS_SQL.PARSE(source_cursor, g_sResultValuesSql, DBMS_SQL.native);
1767: dbms_sql.bind_variable(source_cursor , '1' , p_ruleDetailId);
1768:
1769: dbms_sql.define_column(source_cursor, 1, l_rule_detail_id);
1770: dbms_sql.define_column(source_cursor, 2, l_result_value , 1024);
1771: dbms_sql.define_column(source_cursor, 3, l_result_application_id);
1772: dbms_sql.define_column(source_cursor, 4, l_rule_name , 30);
1773:

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

1766: DBMS_SQL.PARSE(source_cursor, g_sResultValuesSql, DBMS_SQL.native);
1767: dbms_sql.bind_variable(source_cursor , '1' , p_ruleDetailId);
1768:
1769: dbms_sql.define_column(source_cursor, 1, l_rule_detail_id);
1770: dbms_sql.define_column(source_cursor, 2, l_result_value , 1024);
1771: dbms_sql.define_column(source_cursor, 3, l_result_application_id);
1772: dbms_sql.define_column(source_cursor, 4, l_rule_name , 30);
1773:
1774: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);

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

1767: dbms_sql.bind_variable(source_cursor , '1' , p_ruleDetailId);
1768:
1769: dbms_sql.define_column(source_cursor, 1, l_rule_detail_id);
1770: dbms_sql.define_column(source_cursor, 2, l_result_value , 1024);
1771: dbms_sql.define_column(source_cursor, 3, l_result_application_id);
1772: dbms_sql.define_column(source_cursor, 4, l_rule_name , 30);
1773:
1774: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1775:

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

1768:
1769: dbms_sql.define_column(source_cursor, 1, l_rule_detail_id);
1770: dbms_sql.define_column(source_cursor, 2, l_result_value , 1024);
1771: dbms_sql.define_column(source_cursor, 3, l_result_application_id);
1772: dbms_sql.define_column(source_cursor, 4, l_rule_name , 30);
1773:
1774: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1775:
1776: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop

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

1770: dbms_sql.define_column(source_cursor, 2, l_result_value , 1024);
1771: dbms_sql.define_column(source_cursor, 3, l_result_application_id);
1772: dbms_sql.define_column(source_cursor, 4, l_rule_name , 30);
1773:
1774: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1775:
1776: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1777: dbms_sql.column_value(source_cursor, 1, l_rule_detail_id);
1778: dbms_sql.column_value(source_cursor, 2, l_result_value);

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

1772: dbms_sql.define_column(source_cursor, 4, l_rule_name , 30);
1773:
1774: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1775:
1776: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1777: dbms_sql.column_value(source_cursor, 1, l_rule_detail_id);
1778: dbms_sql.column_value(source_cursor, 2, l_result_value);
1779: dbms_sql.column_value(source_cursor, 3, l_result_application_id);
1780: dbms_sql.column_value(source_cursor, 4, l_rule_name);

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

1773:
1774: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1775:
1776: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1777: dbms_sql.column_value(source_cursor, 1, l_rule_detail_id);
1778: dbms_sql.column_value(source_cursor, 2, l_result_value);
1779: dbms_sql.column_value(source_cursor, 3, l_result_application_id);
1780: dbms_sql.column_value(source_cursor, 4, l_rule_name);
1781:

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

1774: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1775:
1776: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1777: dbms_sql.column_value(source_cursor, 1, l_rule_detail_id);
1778: dbms_sql.column_value(source_cursor, 2, l_result_value);
1779: dbms_sql.column_value(source_cursor, 3, l_result_application_id);
1780: dbms_sql.column_value(source_cursor, 4, l_rule_name);
1781:
1782: m_ruleDetailId := l_rule_detail_id;

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

1775:
1776: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1777: dbms_sql.column_value(source_cursor, 1, l_rule_detail_id);
1778: dbms_sql.column_value(source_cursor, 2, l_result_value);
1779: dbms_sql.column_value(source_cursor, 3, l_result_application_id);
1780: dbms_sql.column_value(source_cursor, 4, l_rule_name);
1781:
1782: m_ruleDetailId := l_rule_detail_id;
1783: m_resultApplicationId := l_result_application_id;

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

1776: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1777: dbms_sql.column_value(source_cursor, 1, l_rule_detail_id);
1778: dbms_sql.column_value(source_cursor, 2, l_result_value);
1779: dbms_sql.column_value(source_cursor, 3, l_result_application_id);
1780: dbms_sql.column_value(source_cursor, 4, l_rule_name);
1781:
1782: m_ruleDetailId := l_rule_detail_id;
1783: m_resultApplicationId := l_result_application_id;
1784: m_resultValue := l_result_value;

Line 1789: DBMS_SQL.CLOSE_CURSOR(source_cursor);

1785: m_ruleName := l_rule_name;
1786: exit;
1787: end loop;
1788:
1789: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1790:
1791: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1792: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_PUB.getResultValue', FALSE);
1793: end if;

Line 1806: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

1802:
1803: RAISE;
1804:
1805: WHEN OTHERS THEN
1806: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
1807: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1808: END IF;
1809: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1810: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getResultValue:->'||SQLERRM, FALSE);

Line 1807: DBMS_SQL.CLOSE_CURSOR(source_cursor);

1803: RAISE;
1804:
1805: WHEN OTHERS THEN
1806: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
1807: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1808: END IF;
1809: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1810: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getResultValue:->'||SQLERRM, FALSE);
1811: END IF;

Line 1837: source_cursor := DBMS_SQL.OPEN_CURSOR;

1833: /*Assumption : For default value, Rule_Detail_Id = -99
1834: * Rule name = "Default Result"
1835: */
1836:
1837: source_cursor := DBMS_SQL.OPEN_CURSOR;
1838:
1839: DBMS_SQL.PARSE(source_cursor, g_sDefaultValuesSql, DBMS_SQL.native);
1840: dbms_sql.bind_variable(source_cursor , '1' , p_ruleObjectId);
1841:

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

1835: */
1836:
1837: source_cursor := DBMS_SQL.OPEN_CURSOR;
1838:
1839: DBMS_SQL.PARSE(source_cursor, g_sDefaultValuesSql, DBMS_SQL.native);
1840: dbms_sql.bind_variable(source_cursor , '1' , p_ruleObjectId);
1841:
1842: dbms_sql.define_column(source_cursor, 1, l_default_value , 1024);
1843: dbms_sql.define_column(source_cursor, 2, l_default_application_id);

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

1836:
1837: source_cursor := DBMS_SQL.OPEN_CURSOR;
1838:
1839: DBMS_SQL.PARSE(source_cursor, g_sDefaultValuesSql, DBMS_SQL.native);
1840: dbms_sql.bind_variable(source_cursor , '1' , p_ruleObjectId);
1841:
1842: dbms_sql.define_column(source_cursor, 1, l_default_value , 1024);
1843: dbms_sql.define_column(source_cursor, 2, l_default_application_id);
1844:

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

1838:
1839: DBMS_SQL.PARSE(source_cursor, g_sDefaultValuesSql, DBMS_SQL.native);
1840: dbms_sql.bind_variable(source_cursor , '1' , p_ruleObjectId);
1841:
1842: dbms_sql.define_column(source_cursor, 1, l_default_value , 1024);
1843: dbms_sql.define_column(source_cursor, 2, l_default_application_id);
1844:
1845: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1846:

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

1839: DBMS_SQL.PARSE(source_cursor, g_sDefaultValuesSql, DBMS_SQL.native);
1840: dbms_sql.bind_variable(source_cursor , '1' , p_ruleObjectId);
1841:
1842: dbms_sql.define_column(source_cursor, 1, l_default_value , 1024);
1843: dbms_sql.define_column(source_cursor, 2, l_default_application_id);
1844:
1845: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1846:
1847: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop

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

1841:
1842: dbms_sql.define_column(source_cursor, 1, l_default_value , 1024);
1843: dbms_sql.define_column(source_cursor, 2, l_default_application_id);
1844:
1845: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1846:
1847: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1848: dbms_sql.column_value(source_cursor, 1, l_default_value);
1849: dbms_sql.column_value(source_cursor, 2, l_default_application_id);

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

1843: dbms_sql.define_column(source_cursor, 2, l_default_application_id);
1844:
1845: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1846:
1847: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1848: dbms_sql.column_value(source_cursor, 1, l_default_value);
1849: dbms_sql.column_value(source_cursor, 2, l_default_application_id);
1850:
1851: m_ruleDetailId := -99;

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

1844:
1845: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1846:
1847: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1848: dbms_sql.column_value(source_cursor, 1, l_default_value);
1849: dbms_sql.column_value(source_cursor, 2, l_default_application_id);
1850:
1851: m_ruleDetailId := -99;
1852: m_resultApplicationId := l_default_application_id;

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

1845: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1846:
1847: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1848: dbms_sql.column_value(source_cursor, 1, l_default_value);
1849: dbms_sql.column_value(source_cursor, 2, l_default_application_id);
1850:
1851: m_ruleDetailId := -99;
1852: m_resultApplicationId := l_default_application_id;
1853: m_resultValue := l_default_value;

Line 1858: DBMS_SQL.CLOSE_CURSOR(source_cursor);

1854: m_ruleName := 'Default Result';
1855: exit;
1856: end loop;
1857:
1858: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1859: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1860: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_PUB.getDefaultValue', FALSE);
1861: end if;
1862:

Line 1875: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

1871:
1872: RAISE;
1873:
1874: WHEN OTHERS THEN
1875: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
1876: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1877: END IF;
1878: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1879: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getDefaultValue:->'||SQLERRM, FALSE);

Line 1876: DBMS_SQL.CLOSE_CURSOR(source_cursor);

1872: RAISE;
1873:
1874: WHEN OTHERS THEN
1875: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
1876: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1877: END IF;
1878: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1879: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getDefaultValue:->'||SQLERRM, FALSE);
1880: END IF;

Line 1910: source_cursor := DBMS_SQL.OPEN_CURSOR;

1906: m_ruleObjectId := 0;
1907: m_flexFieldName := null;
1908: m_flexFieldAppShortName := null;
1909:
1910: source_cursor := DBMS_SQL.OPEN_CURSOR;
1911:
1912: DBMS_SQL.PARSE(source_cursor, g_sRuleObjectSql, DBMS_SQL.native);
1913: dbms_sql.bind_variable(source_cursor , '1' , p_RuleObjectName);
1914:

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

1908: m_flexFieldAppShortName := null;
1909:
1910: source_cursor := DBMS_SQL.OPEN_CURSOR;
1911:
1912: DBMS_SQL.PARSE(source_cursor, g_sRuleObjectSql, DBMS_SQL.native);
1913: dbms_sql.bind_variable(source_cursor , '1' , p_RuleObjectName);
1914:
1915: IF (m_instance_context = 'Y') THEN
1916: dbms_sql.bind_variable(source_cursor , '2' , m_instance_label);

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

1909:
1910: source_cursor := DBMS_SQL.OPEN_CURSOR;
1911:
1912: DBMS_SQL.PARSE(source_cursor, g_sRuleObjectSql, DBMS_SQL.native);
1913: dbms_sql.bind_variable(source_cursor , '1' , p_RuleObjectName);
1914:
1915: IF (m_instance_context = 'Y') THEN
1916: dbms_sql.bind_variable(source_cursor , '2' , m_instance_label);
1917: dbms_sql.bind_variable(source_cursor , '3' , m_instance_label);

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

1912: DBMS_SQL.PARSE(source_cursor, g_sRuleObjectSql, DBMS_SQL.native);
1913: dbms_sql.bind_variable(source_cursor , '1' , p_RuleObjectName);
1914:
1915: IF (m_instance_context = 'Y') THEN
1916: dbms_sql.bind_variable(source_cursor , '2' , m_instance_label);
1917: dbms_sql.bind_variable(source_cursor , '3' , m_instance_label);
1918: dbms_sql.bind_variable(source_cursor , '4' , m_instance_label);
1919:
1920: dbms_sql.bind_variable(source_cursor , '5' , m_org_id);

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

1913: dbms_sql.bind_variable(source_cursor , '1' , p_RuleObjectName);
1914:
1915: IF (m_instance_context = 'Y') THEN
1916: dbms_sql.bind_variable(source_cursor , '2' , m_instance_label);
1917: dbms_sql.bind_variable(source_cursor , '3' , m_instance_label);
1918: dbms_sql.bind_variable(source_cursor , '4' , m_instance_label);
1919:
1920: dbms_sql.bind_variable(source_cursor , '5' , m_org_id);
1921: dbms_sql.bind_variable(source_cursor , '6' , m_org_id);

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

1914:
1915: IF (m_instance_context = 'Y') THEN
1916: dbms_sql.bind_variable(source_cursor , '2' , m_instance_label);
1917: dbms_sql.bind_variable(source_cursor , '3' , m_instance_label);
1918: dbms_sql.bind_variable(source_cursor , '4' , m_instance_label);
1919:
1920: dbms_sql.bind_variable(source_cursor , '5' , m_org_id);
1921: dbms_sql.bind_variable(source_cursor , '6' , m_org_id);
1922: dbms_sql.bind_variable(source_cursor , '7' , m_org_id);

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

1916: dbms_sql.bind_variable(source_cursor , '2' , m_instance_label);
1917: dbms_sql.bind_variable(source_cursor , '3' , m_instance_label);
1918: dbms_sql.bind_variable(source_cursor , '4' , m_instance_label);
1919:
1920: dbms_sql.bind_variable(source_cursor , '5' , m_org_id);
1921: dbms_sql.bind_variable(source_cursor , '6' , m_org_id);
1922: dbms_sql.bind_variable(source_cursor , '7' , m_org_id);
1923: END IF;
1924:

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

1917: dbms_sql.bind_variable(source_cursor , '3' , m_instance_label);
1918: dbms_sql.bind_variable(source_cursor , '4' , m_instance_label);
1919:
1920: dbms_sql.bind_variable(source_cursor , '5' , m_org_id);
1921: dbms_sql.bind_variable(source_cursor , '6' , m_org_id);
1922: dbms_sql.bind_variable(source_cursor , '7' , m_org_id);
1923: END IF;
1924:
1925: dbms_sql.define_column(source_cursor, 1, m_ruleObjectType , 15);

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

1918: dbms_sql.bind_variable(source_cursor , '4' , m_instance_label);
1919:
1920: dbms_sql.bind_variable(source_cursor , '5' , m_org_id);
1921: dbms_sql.bind_variable(source_cursor , '6' , m_org_id);
1922: dbms_sql.bind_variable(source_cursor , '7' , m_org_id);
1923: END IF;
1924:
1925: dbms_sql.define_column(source_cursor, 1, m_ruleObjectType , 15);
1926: dbms_sql.define_column(source_cursor, 2, m_ruleObjectId);

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

1921: dbms_sql.bind_variable(source_cursor , '6' , m_org_id);
1922: dbms_sql.bind_variable(source_cursor , '7' , m_org_id);
1923: END IF;
1924:
1925: dbms_sql.define_column(source_cursor, 1, m_ruleObjectType , 15);
1926: dbms_sql.define_column(source_cursor, 2, m_ruleObjectId);
1927: dbms_sql.define_column(source_cursor, 3, m_flexFieldName , 30);
1928: dbms_sql.define_column(source_cursor, 4, m_flexFieldAppShortName , 10);
1929:

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

1922: dbms_sql.bind_variable(source_cursor , '7' , m_org_id);
1923: END IF;
1924:
1925: dbms_sql.define_column(source_cursor, 1, m_ruleObjectType , 15);
1926: dbms_sql.define_column(source_cursor, 2, m_ruleObjectId);
1927: dbms_sql.define_column(source_cursor, 3, m_flexFieldName , 30);
1928: dbms_sql.define_column(source_cursor, 4, m_flexFieldAppShortName , 10);
1929:
1930: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);

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

1923: END IF;
1924:
1925: dbms_sql.define_column(source_cursor, 1, m_ruleObjectType , 15);
1926: dbms_sql.define_column(source_cursor, 2, m_ruleObjectId);
1927: dbms_sql.define_column(source_cursor, 3, m_flexFieldName , 30);
1928: dbms_sql.define_column(source_cursor, 4, m_flexFieldAppShortName , 10);
1929:
1930: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1931:

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

1924:
1925: dbms_sql.define_column(source_cursor, 1, m_ruleObjectType , 15);
1926: dbms_sql.define_column(source_cursor, 2, m_ruleObjectId);
1927: dbms_sql.define_column(source_cursor, 3, m_flexFieldName , 30);
1928: dbms_sql.define_column(source_cursor, 4, m_flexFieldAppShortName , 10);
1929:
1930: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1931:
1932: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop

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

1926: dbms_sql.define_column(source_cursor, 2, m_ruleObjectId);
1927: dbms_sql.define_column(source_cursor, 3, m_flexFieldName , 30);
1928: dbms_sql.define_column(source_cursor, 4, m_flexFieldAppShortName , 10);
1929:
1930: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1931:
1932: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1933: dbms_sql.column_value(source_cursor, 1, m_ruleObjectType);
1934: dbms_sql.column_value(source_cursor, 2, m_ruleObjectId);

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

1928: dbms_sql.define_column(source_cursor, 4, m_flexFieldAppShortName , 10);
1929:
1930: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1931:
1932: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1933: dbms_sql.column_value(source_cursor, 1, m_ruleObjectType);
1934: dbms_sql.column_value(source_cursor, 2, m_ruleObjectId);
1935: dbms_sql.column_value(source_cursor, 3, m_flexFieldName);
1936: dbms_sql.column_value(source_cursor, 4, m_flexFieldAppShortName);

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

1929:
1930: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1931:
1932: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1933: dbms_sql.column_value(source_cursor, 1, m_ruleObjectType);
1934: dbms_sql.column_value(source_cursor, 2, m_ruleObjectId);
1935: dbms_sql.column_value(source_cursor, 3, m_flexFieldName);
1936: dbms_sql.column_value(source_cursor, 4, m_flexFieldAppShortName);
1937:

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

1930: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
1931:
1932: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1933: dbms_sql.column_value(source_cursor, 1, m_ruleObjectType);
1934: dbms_sql.column_value(source_cursor, 2, m_ruleObjectId);
1935: dbms_sql.column_value(source_cursor, 3, m_flexFieldName);
1936: dbms_sql.column_value(source_cursor, 4, m_flexFieldAppShortName);
1937:
1938: exit;

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

1931:
1932: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1933: dbms_sql.column_value(source_cursor, 1, m_ruleObjectType);
1934: dbms_sql.column_value(source_cursor, 2, m_ruleObjectId);
1935: dbms_sql.column_value(source_cursor, 3, m_flexFieldName);
1936: dbms_sql.column_value(source_cursor, 4, m_flexFieldAppShortName);
1937:
1938: exit;
1939: end loop;

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

1932: while(dbms_sql.fetch_rows(source_cursor) > 0 ) loop
1933: dbms_sql.column_value(source_cursor, 1, m_ruleObjectType);
1934: dbms_sql.column_value(source_cursor, 2, m_ruleObjectId);
1935: dbms_sql.column_value(source_cursor, 3, m_flexFieldName);
1936: dbms_sql.column_value(source_cursor, 4, m_flexFieldAppShortName);
1937:
1938: exit;
1939: end loop;
1940:

Line 1941: DBMS_SQL.CLOSE_CURSOR(source_cursor);

1937:
1938: exit;
1939: end loop;
1940:
1941: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1942:
1943: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1944: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_PUB.getRuleObjectInfo', FALSE);
1945: end if;

Line 1958: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

1954:
1955: RAISE;
1956:
1957: WHEN OTHERS THEN
1958: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
1959: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1960: END IF;
1961: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1962: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getRuleObjectInfo:->g_sRuleObjectSql='||g_sRuleObjectSql, FALSE);

Line 1959: DBMS_SQL.CLOSE_CURSOR(source_cursor);

1955: RAISE;
1956:
1957: WHEN OTHERS THEN
1958: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
1959: DBMS_SQL.CLOSE_CURSOR(source_cursor);
1960: END IF;
1961: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1962: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getRuleObjectInfo:->g_sRuleObjectSql='||g_sRuleObjectSql, FALSE);
1963: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.getRuleObjectInfo:->'||SQLERRM, FALSE);

Line 2570: l_descTbl DBMS_SQL.DESC_TAB;

2566: l_theCursor INTEGER;
2567: l_stringToParse VARCHAR2(20000);
2568: l_colValue VARCHAR2(4000);
2569: l_counter PLS_INTEGER := 0;
2570: l_descTbl DBMS_SQL.DESC_TAB;
2571: l_numColumns INTEGER;
2572:
2573: source_cursor INTEGER;
2574: l_num_rows_processed INTEGER;

Line 2689: l_theCursor := dbms_sql.open_cursor;

2685: l_stringToParse := 'select * from ' || p_param_view_name || ' where ' || p_additional_where_clause || ' AND ROWNUM = 1';
2686: END IF;
2687:
2688:
2689: l_theCursor := dbms_sql.open_cursor;
2690: dbms_sql.parse( c => l_theCursor,
2691: statement => l_stringToParse,
2692: language_flag => dbms_sql.native);
2693:

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

2686: END IF;
2687:
2688:
2689: l_theCursor := dbms_sql.open_cursor;
2690: dbms_sql.parse( c => l_theCursor,
2691: statement => l_stringToParse,
2692: language_flag => dbms_sql.native);
2693:
2694: dbms_sql.describe_columns(l_theCursor, l_numColumns, l_descTbl);

Line 2692: language_flag => dbms_sql.native);

2688:
2689: l_theCursor := dbms_sql.open_cursor;
2690: dbms_sql.parse( c => l_theCursor,
2691: statement => l_stringToParse,
2692: language_flag => dbms_sql.native);
2693:
2694: dbms_sql.describe_columns(l_theCursor, l_numColumns, l_descTbl);
2695:
2696:

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

2690: dbms_sql.parse( c => l_theCursor,
2691: statement => l_stringToParse,
2692: language_flag => dbms_sql.native);
2693:
2694: dbms_sql.describe_columns(l_theCursor, l_numColumns, l_descTbl);
2695:
2696:
2697: destination_cursor := DBMS_SQL.OPEN_CURSOR;
2698:

Line 2697: destination_cursor := DBMS_SQL.OPEN_CURSOR;

2693:
2694: dbms_sql.describe_columns(l_theCursor, l_numColumns, l_descTbl);
2695:
2696:
2697: destination_cursor := DBMS_SQL.OPEN_CURSOR;
2698:
2699: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2700: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.apply_rule_bulk:->g_sRuleDetailSql='||g_sRuleDetailSql, FALSE);
2701: end if;

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

2709: g_sRuleDetailSql := g_sRuleDetailSql_orig;
2710: END IF;
2711:
2712:
2713: DBMS_SQL.PARSE(destination_cursor, g_sRuleDetailSql,DBMS_SQL.native);
2714: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);
2715: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
2716:
2717: IF (m_instance_context = 'Y') THEN

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

2710: END IF;
2711:
2712:
2713: DBMS_SQL.PARSE(destination_cursor, g_sRuleDetailSql,DBMS_SQL.native);
2714: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);
2715: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
2716:
2717: IF (m_instance_context = 'Y') THEN
2718: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);

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

2711:
2712:
2713: DBMS_SQL.PARSE(destination_cursor, g_sRuleDetailSql,DBMS_SQL.native);
2714: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);
2715: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
2716:
2717: IF (m_instance_context = 'Y') THEN
2718: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
2719: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);

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

2714: dbms_sql.bind_variable(destination_cursor , '1' , p_rule_object_name);
2715: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
2716:
2717: IF (m_instance_context = 'Y') THEN
2718: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
2719: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
2720: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
2721:
2722: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);

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

2715: dbms_sql.bind_variable(destination_cursor , '2' , l_application_id);
2716:
2717: IF (m_instance_context = 'Y') THEN
2718: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
2719: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
2720: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
2721:
2722: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
2723: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);

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

2716:
2717: IF (m_instance_context = 'Y') THEN
2718: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
2719: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
2720: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
2721:
2722: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
2723: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
2724: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);

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

2718: dbms_sql.bind_variable(destination_cursor , '3' , m_instance_label);
2719: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
2720: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
2721:
2722: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
2723: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
2724: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
2725: END IF;
2726:

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

2719: dbms_sql.bind_variable(destination_cursor , '4' , m_instance_label);
2720: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
2721:
2722: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
2723: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
2724: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
2725: END IF;
2726:
2727: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);

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

2720: dbms_sql.bind_variable(destination_cursor , '5' , m_instance_label);
2721:
2722: dbms_sql.bind_variable(destination_cursor , '6' , m_org_id);
2723: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
2724: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
2725: END IF;
2726:
2727: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
2728: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);

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

2723: dbms_sql.bind_variable(destination_cursor , '7' , m_org_id);
2724: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
2725: END IF;
2726:
2727: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
2728: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
2729: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
2730: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
2731: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);

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

2724: dbms_sql.bind_variable(destination_cursor , '8' , m_org_id);
2725: END IF;
2726:
2727: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
2728: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
2729: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
2730: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
2731: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
2732: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);

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

2725: END IF;
2726:
2727: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
2728: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
2729: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
2730: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
2731: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
2732: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
2733: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);

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

2726:
2727: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
2728: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
2729: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
2730: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
2731: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
2732: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
2733: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
2734:

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

2727: dbms_sql.define_column(destination_cursor, 1, l_result_type , 30);
2728: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
2729: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
2730: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
2731: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
2732: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
2733: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
2734:
2735: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);

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

2728: dbms_sql.define_column(destination_cursor, 2, l_rule_detail_id);
2729: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
2730: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
2731: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
2732: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
2733: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
2734:
2735: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);
2736:

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

2729: dbms_sql.define_column(destination_cursor, 3, l_operator , 3);
2730: dbms_sql.define_column(destination_cursor, 4, l_rule_object_id);
2731: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
2732: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
2733: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
2734:
2735: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);
2736:
2737: --If No rules active.

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

2731: dbms_sql.define_column(destination_cursor, 5, l_flexfield_name , 80);
2732: dbms_sql.define_column(destination_cursor, 6, l_flexfield_app_short_name , 30);
2733: dbms_sql.define_column(destination_cursor, 7, l_multiRuleResultFlag , 10);
2734:
2735: l_num_rows_processed := DBMS_SQL.EXECUTE(destination_cursor);
2736:
2737: --If No rules active.
2738: if(l_num_rows_processed = 0) then
2739: l_noRuleActive := TRUE;

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

2738: if(l_num_rows_processed = 0) then
2739: l_noRuleActive := TRUE;
2740: end if;
2741:
2742: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop
2743: l_count := 1;
2744: /* Initialize the var l_paramPresent for each rule. If any param matches then make it true
2745: * and insert the record into FUN_RULE_BULK_RESULT_GT table.
2746: */

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

2750: l_select_query := 'SELECT '||p_primary_key_column_name||' , ';
2751: l_where_clause := '';
2752: l_insert_statement := 'insert into FUN_RULE_BULK_RESULT_GT(ID, RESULT_VALUE , RULE_NAME ,RESULT_APPLICATION_ID, RULE_DETAIL_ID ) ';
2753:
2754: dbms_sql.column_value(destination_cursor, 1, l_result_type);
2755: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
2756: dbms_sql.column_value(destination_cursor, 3, l_operator);
2757: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
2758: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);

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

2751: l_where_clause := '';
2752: l_insert_statement := 'insert into FUN_RULE_BULK_RESULT_GT(ID, RESULT_VALUE , RULE_NAME ,RESULT_APPLICATION_ID, RULE_DETAIL_ID ) ';
2753:
2754: dbms_sql.column_value(destination_cursor, 1, l_result_type);
2755: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
2756: dbms_sql.column_value(destination_cursor, 3, l_operator);
2757: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
2758: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
2759: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);

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

2752: l_insert_statement := 'insert into FUN_RULE_BULK_RESULT_GT(ID, RESULT_VALUE , RULE_NAME ,RESULT_APPLICATION_ID, RULE_DETAIL_ID ) ';
2753:
2754: dbms_sql.column_value(destination_cursor, 1, l_result_type);
2755: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
2756: dbms_sql.column_value(destination_cursor, 3, l_operator);
2757: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
2758: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
2759: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
2760: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);

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

2753:
2754: dbms_sql.column_value(destination_cursor, 1, l_result_type);
2755: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
2756: dbms_sql.column_value(destination_cursor, 3, l_operator);
2757: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
2758: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
2759: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
2760: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
2761:

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

2754: dbms_sql.column_value(destination_cursor, 1, l_result_type);
2755: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
2756: dbms_sql.column_value(destination_cursor, 3, l_operator);
2757: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
2758: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
2759: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
2760: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
2761:
2762: params_cursor := DBMS_SQL.OPEN_CURSOR;

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

2755: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
2756: dbms_sql.column_value(destination_cursor, 3, l_operator);
2757: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
2758: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
2759: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
2760: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
2761:
2762: params_cursor := DBMS_SQL.OPEN_CURSOR;
2763:

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

2756: dbms_sql.column_value(destination_cursor, 3, l_operator);
2757: dbms_sql.column_value(destination_cursor, 4, l_rule_object_id);
2758: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
2759: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
2760: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
2761:
2762: params_cursor := DBMS_SQL.OPEN_CURSOR;
2763:
2764: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2762: params_cursor := DBMS_SQL.OPEN_CURSOR;

2758: dbms_sql.column_value(destination_cursor, 5, l_flexfield_name);
2759: dbms_sql.column_value(destination_cursor, 6, l_flexfield_app_short_name);
2760: dbms_sql.column_value(destination_cursor, 7, l_multiRuleResultFlag);
2761:
2762: params_cursor := DBMS_SQL.OPEN_CURSOR;
2763:
2764: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2765: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.apply_rule_bulk:->g_sCriteriaParamSql='||g_sCriteriaParamSql, FALSE);
2766: end if;

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

2764: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2765: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.apply_rule_bulk:->g_sCriteriaParamSql='||g_sCriteriaParamSql, FALSE);
2766: end if;
2767:
2768: DBMS_SQL.PARSE(params_cursor, g_sCriteriaParamSql,DBMS_SQL.native);
2769:
2770: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
2771: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
2772:

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

2766: end if;
2767:
2768: DBMS_SQL.PARSE(params_cursor, g_sCriteriaParamSql,DBMS_SQL.native);
2769:
2770: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
2771: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
2772:
2773: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
2774: dbms_sql.define_column(params_cursor, 2, l_condition , 15);

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

2767:
2768: DBMS_SQL.PARSE(params_cursor, g_sCriteriaParamSql,DBMS_SQL.native);
2769:
2770: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
2771: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
2772:
2773: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
2774: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
2775: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);

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

2769:
2770: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
2771: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
2772:
2773: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
2774: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
2775: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
2776: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
2777: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);

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

2770: dbms_sql.bind_variable(params_cursor , '1' , l_rule_detail_id);
2771: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
2772:
2773: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
2774: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
2775: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
2776: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
2777: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
2778: dbms_sql.define_column(params_cursor, 6, l_criteria_id);

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

2771: dbms_sql.bind_variable(params_cursor , '2' , l_rule_detail_id);
2772:
2773: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
2774: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
2775: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
2776: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
2777: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
2778: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
2779:

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

2772:
2773: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
2774: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
2775: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
2776: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
2777: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
2778: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
2779:
2780: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);

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

2773: dbms_sql.define_column(params_cursor, 1, l_param_name , 30);
2774: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
2775: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
2776: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
2777: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
2778: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
2779:
2780: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
2781:

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

2774: dbms_sql.define_column(params_cursor, 2, l_condition , 15);
2775: dbms_sql.define_column(params_cursor, 3, l_param_value , 1024);
2776: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
2777: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
2778: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
2779:
2780: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
2781:
2782: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop

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

2776: dbms_sql.define_column(params_cursor, 4, l_data_type, 15);
2777: dbms_sql.define_column(params_cursor, 5, l_case_sensitive, 1);
2778: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
2779:
2780: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
2781:
2782: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
2783: dbms_sql.column_value(params_cursor, 1, l_param_name );
2784: dbms_sql.column_value(params_cursor, 2, l_condition );

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

2778: dbms_sql.define_column(params_cursor, 6, l_criteria_id);
2779:
2780: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
2781:
2782: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
2783: dbms_sql.column_value(params_cursor, 1, l_param_name );
2784: dbms_sql.column_value(params_cursor, 2, l_condition );
2785: dbms_sql.column_value(params_cursor, 3, l_param_value);
2786: dbms_sql.column_value(params_cursor, 4, l_data_type);

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

2779:
2780: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
2781:
2782: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
2783: dbms_sql.column_value(params_cursor, 1, l_param_name );
2784: dbms_sql.column_value(params_cursor, 2, l_condition );
2785: dbms_sql.column_value(params_cursor, 3, l_param_value);
2786: dbms_sql.column_value(params_cursor, 4, l_data_type);
2787: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);

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

2780: params_rows_processed := DBMS_SQL.EXECUTE(params_cursor);
2781:
2782: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
2783: dbms_sql.column_value(params_cursor, 1, l_param_name );
2784: dbms_sql.column_value(params_cursor, 2, l_condition );
2785: dbms_sql.column_value(params_cursor, 3, l_param_value);
2786: dbms_sql.column_value(params_cursor, 4, l_data_type);
2787: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
2788: dbms_sql.column_value(params_cursor, 6, l_criteria_id);

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

2781:
2782: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
2783: dbms_sql.column_value(params_cursor, 1, l_param_name );
2784: dbms_sql.column_value(params_cursor, 2, l_condition );
2785: dbms_sql.column_value(params_cursor, 3, l_param_value);
2786: dbms_sql.column_value(params_cursor, 4, l_data_type);
2787: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
2788: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
2789:

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

2782: while(dbms_sql.fetch_rows(params_cursor) > 0 ) loop
2783: dbms_sql.column_value(params_cursor, 1, l_param_name );
2784: dbms_sql.column_value(params_cursor, 2, l_condition );
2785: dbms_sql.column_value(params_cursor, 3, l_param_value);
2786: dbms_sql.column_value(params_cursor, 4, l_data_type);
2787: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
2788: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
2789:
2790: IF (l_data_type = C_DATE) THEN

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

2783: dbms_sql.column_value(params_cursor, 1, l_param_name );
2784: dbms_sql.column_value(params_cursor, 2, l_condition );
2785: dbms_sql.column_value(params_cursor, 3, l_param_value);
2786: dbms_sql.column_value(params_cursor, 4, l_data_type);
2787: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
2788: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
2789:
2790: IF (l_data_type = C_DATE) THEN
2791: l_param_value := fnd_date.canonical_to_date(l_param_value);

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

2784: dbms_sql.column_value(params_cursor, 2, l_condition );
2785: dbms_sql.column_value(params_cursor, 3, l_param_value);
2786: dbms_sql.column_value(params_cursor, 4, l_data_type);
2787: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
2788: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
2789:
2790: IF (l_data_type = C_DATE) THEN
2791: l_param_value := fnd_date.canonical_to_date(l_param_value);
2792: ELSIF (l_data_type = C_NUMERIC) THEN

Line 2801: paramVal_cursor := DBMS_SQL.OPEN_CURSOR;

2797: loop
2798: l_crit_param_name := l_descTbl(i).col_name;
2799: if(l_crit_param_name = l_param_name) then
2800: l_paramPresent := TRUE;
2801: paramVal_cursor := DBMS_SQL.OPEN_CURSOR;
2802:
2803: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2804: fnd_log.message(FND_LOG.LEVEL_STATEMENT,
2805: 'Start FUN_RULE_PUB.apply_rule_bulk:->g_sMultiCriteriaParamValueSql='||g_sMultiCriteriaParamValueSql, FALSE);

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

2804: fnd_log.message(FND_LOG.LEVEL_STATEMENT,
2805: 'Start FUN_RULE_PUB.apply_rule_bulk:->g_sMultiCriteriaParamValueSql='||g_sMultiCriteriaParamValueSql, FALSE);
2806: end if;
2807:
2808: DBMS_SQL.PARSE(paramVal_cursor, g_sMultiCriteriaParamValueSql,DBMS_SQL.native);
2809: dbms_sql.bind_variable(paramVal_cursor , '1' , l_rule_detail_id);
2810: dbms_sql.bind_variable(paramVal_cursor , '2' , l_criteria_id);
2811:
2812: dbms_sql.define_column(paramVal_cursor, 1, l_param_value , 1024);

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

2805: 'Start FUN_RULE_PUB.apply_rule_bulk:->g_sMultiCriteriaParamValueSql='||g_sMultiCriteriaParamValueSql, FALSE);
2806: end if;
2807:
2808: DBMS_SQL.PARSE(paramVal_cursor, g_sMultiCriteriaParamValueSql,DBMS_SQL.native);
2809: dbms_sql.bind_variable(paramVal_cursor , '1' , l_rule_detail_id);
2810: dbms_sql.bind_variable(paramVal_cursor , '2' , l_criteria_id);
2811:
2812: dbms_sql.define_column(paramVal_cursor, 1, l_param_value , 1024);
2813:

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

2806: end if;
2807:
2808: DBMS_SQL.PARSE(paramVal_cursor, g_sMultiCriteriaParamValueSql,DBMS_SQL.native);
2809: dbms_sql.bind_variable(paramVal_cursor , '1' , l_rule_detail_id);
2810: dbms_sql.bind_variable(paramVal_cursor , '2' , l_criteria_id);
2811:
2812: dbms_sql.define_column(paramVal_cursor, 1, l_param_value , 1024);
2813:
2814: paramVal_rows_processed := DBMS_SQL.EXECUTE(paramVal_cursor);

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

2808: DBMS_SQL.PARSE(paramVal_cursor, g_sMultiCriteriaParamValueSql,DBMS_SQL.native);
2809: dbms_sql.bind_variable(paramVal_cursor , '1' , l_rule_detail_id);
2810: dbms_sql.bind_variable(paramVal_cursor , '2' , l_criteria_id);
2811:
2812: dbms_sql.define_column(paramVal_cursor, 1, l_param_value , 1024);
2813:
2814: paramVal_rows_processed := DBMS_SQL.EXECUTE(paramVal_cursor);
2815:
2816: if(l_condition = C_IN) then

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

2810: dbms_sql.bind_variable(paramVal_cursor , '2' , l_criteria_id);
2811:
2812: dbms_sql.define_column(paramVal_cursor, 1, l_param_value , 1024);
2813:
2814: paramVal_rows_processed := DBMS_SQL.EXECUTE(paramVal_cursor);
2815:
2816: if(l_condition = C_IN) then
2817: l_where_clause := l_where_clause || l_param_name || ' IN (';
2818: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop

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

2814: paramVal_rows_processed := DBMS_SQL.EXECUTE(paramVal_cursor);
2815:
2816: if(l_condition = C_IN) then
2817: l_where_clause := l_where_clause || l_param_name || ' IN (';
2818: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2819: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2820: if(l_data_type = C_STRINGS) then
2821: l_where_clause := l_where_clause || ' '''|| l_param_value ||''', ';
2822: elsif(l_data_type = C_DATE) then

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

2815:
2816: if(l_condition = C_IN) then
2817: l_where_clause := l_where_clause || l_param_name || ' IN (';
2818: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2819: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2820: if(l_data_type = C_STRINGS) then
2821: l_where_clause := l_where_clause || ' '''|| l_param_value ||''', ';
2822: elsif(l_data_type = C_DATE) then
2823: l_where_clause := l_where_clause || ' to_date('''|| l_param_value ||''','''|| l_date_format ||''' ), ';

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

2828: l_where_clause := l_where_clause ||')';
2829: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2830: elsif (l_condition = C_NOT_IN) then
2831: l_where_clause := l_where_clause || l_param_name || ' NOT IN (';
2832: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2833: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2834: if(l_data_type = C_STRINGS) then
2835: l_where_clause := l_where_clause || ' '''|| l_param_value ||''', ';
2836: elsif(l_data_type = C_DATE) then

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

2829: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2830: elsif (l_condition = C_NOT_IN) then
2831: l_where_clause := l_where_clause || l_param_name || ' NOT IN (';
2832: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2833: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2834: if(l_data_type = C_STRINGS) then
2835: l_where_clause := l_where_clause || ' '''|| l_param_value ||''', ';
2836: elsif(l_data_type = C_DATE) then
2837: l_where_clause := l_where_clause || ' to_date('''|| l_param_value ||''', '''|| l_date_format ||''' ), ';

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

2842: l_where_clause := l_where_clause ||' ) ';
2843: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2844: elsif (l_condition = C_LIKE OR l_condition = C_CONTAINS) then
2845: l_where_clause := l_where_clause || l_param_name || ' LIKE (';
2846: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2847: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2848: if(l_data_type = C_STRINGS OR l_data_type = C_DATE) then
2849: l_where_clause := l_where_clause || ' '''||'%'|| l_param_value ||'%'||''' ,' ;
2850: NULL;

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

2843: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2844: elsif (l_condition = C_LIKE OR l_condition = C_CONTAINS) then
2845: l_where_clause := l_where_clause || l_param_name || ' LIKE (';
2846: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2847: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2848: if(l_data_type = C_STRINGS OR l_data_type = C_DATE) then
2849: l_where_clause := l_where_clause || ' '''||'%'|| l_param_value ||'%'||''' ,' ;
2850: NULL;
2851: else

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

2855: l_where_clause := l_where_clause ||' ) ';
2856: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2857: elsif (l_condition = C_EQUALS) then
2858: l_where_clause := l_where_clause || l_param_name || ' = (';
2859: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2860: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2861: if(l_data_type = C_STRINGS) then
2862: l_where_clause := l_where_clause || ' '''|| l_param_value ||''', ' ;
2863: elsif(l_data_type = C_DATE) then

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

2856: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2857: elsif (l_condition = C_EQUALS) then
2858: l_where_clause := l_where_clause || l_param_name || ' = (';
2859: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2860: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2861: if(l_data_type = C_STRINGS) then
2862: l_where_clause := l_where_clause || ' '''|| l_param_value ||''', ' ;
2863: elsif(l_data_type = C_DATE) then
2864: l_where_clause := l_where_clause || ' to_date('''|| l_param_value ||''', '''|| l_date_format ||''' ), ';

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

2869: l_where_clause := l_where_clause ||' ) ';
2870: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2871: elsif (l_condition = C_NOT_EQUALS) then
2872: l_where_clause := l_where_clause || l_param_name || ' <> (';
2873: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2874: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2875: if(l_data_type = C_STRINGS) then
2876: l_where_clause := l_where_clause || ' '''|| l_param_value ||''', ' ;
2877: elsif(l_data_type = C_DATE) then

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

2870: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2871: elsif (l_condition = C_NOT_EQUALS) then
2872: l_where_clause := l_where_clause || l_param_name || ' <> (';
2873: while(dbms_sql.fetch_rows(paramVal_cursor) > 0 ) loop
2874: dbms_sql.column_value(paramVal_cursor, 1, l_param_value );
2875: if(l_data_type = C_STRINGS) then
2876: l_where_clause := l_where_clause || ' '''|| l_param_value ||''', ' ;
2877: elsif(l_data_type = C_DATE) then
2878: l_where_clause := l_where_clause || ' to_date('''|| l_param_value ||''', '''|| l_date_format ||''' ), ';

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2943: DBMS_SQL.CLOSE_CURSOR(paramVal_cursor);

2939: l_where_clause := l_where_clause ||' ) ';
2940: l_where_clause := substr(l_where_clause,1,instr(l_where_clause,',',-1)-1) || substr(l_where_clause,instr(l_where_clause,',',-1)+1);
2941: end if;
2942: l_where_clause := l_where_clause || ' ' || l_operator || ' ';
2943: DBMS_SQL.CLOSE_CURSOR(paramVal_cursor);
2944: else
2945: NULL;
2946: end if; --If l_crit_param_name = l_param_name
2947: end loop; --End loop of l_descCol

Line 2998: DBMS_SQL.CLOSE_CURSOR(params_cursor);

2994: IF (p_additional_where_clause IS NOT NULL) THEN
2995: l_select_query := l_select_query || ' AND ' || p_additional_where_clause;
2996: END IF;
2997:
2998: DBMS_SQL.CLOSE_CURSOR(params_cursor);
2999:
3000: if(l_isRuleValid) then
3001: l_insert_statement := l_insert_statement || ' ' || l_select_query ||
3002: ' AND NOT EXISTS(SELECT 1 FROM FUN_RULE_BULK_RESULT_GT WHERE ID='|| p_param_view_name||'.'||p_primary_key_column_name||')';

Line 3057: DBMS_SQL.CLOSE_CURSOR(destination_cursor);

3053:
3054: /* bug 7337383 */
3055: -- end if;
3056:
3057: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
3058:
3059:
3060: /*Rule Object Instance MOAC Changes:
3061: * Revert back the access mode and org id to the l_old_acess_mode and l_old_org_id

Line 3093: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN

3089: FND_MESSAGE.SET_TOKEN('RULE_OBJECT_NAME', p_rule_object_name);
3090: app_exception.raise_exception;
3091:
3092: WHEN OTHERS THEN
3093: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
3094: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
3095: END IF;
3096: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
3097: DBMS_SQL.CLOSE_CURSOR(params_cursor);

Line 3094: DBMS_SQL.CLOSE_CURSOR(destination_cursor);

3090: app_exception.raise_exception;
3091:
3092: WHEN OTHERS THEN
3093: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
3094: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
3095: END IF;
3096: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
3097: DBMS_SQL.CLOSE_CURSOR(params_cursor);
3098: END IF;

Line 3096: IF DBMS_SQL.IS_OPEN(params_cursor) THEN

3092: WHEN OTHERS THEN
3093: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
3094: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
3095: END IF;
3096: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
3097: DBMS_SQL.CLOSE_CURSOR(params_cursor);
3098: END IF;
3099: IF DBMS_SQL.IS_OPEN(paramVal_cursor) THEN
3100: DBMS_SQL.CLOSE_CURSOR(paramVal_cursor);

Line 3097: DBMS_SQL.CLOSE_CURSOR(params_cursor);

3093: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
3094: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
3095: END IF;
3096: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
3097: DBMS_SQL.CLOSE_CURSOR(params_cursor);
3098: END IF;
3099: IF DBMS_SQL.IS_OPEN(paramVal_cursor) THEN
3100: DBMS_SQL.CLOSE_CURSOR(paramVal_cursor);
3101: END IF;

Line 3099: IF DBMS_SQL.IS_OPEN(paramVal_cursor) THEN

3095: END IF;
3096: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
3097: DBMS_SQL.CLOSE_CURSOR(params_cursor);
3098: END IF;
3099: IF DBMS_SQL.IS_OPEN(paramVal_cursor) THEN
3100: DBMS_SQL.CLOSE_CURSOR(paramVal_cursor);
3101: END IF;
3102: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3103: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.apply_rule_bulk Others:->'||SQLERRM, FALSE);

Line 3100: DBMS_SQL.CLOSE_CURSOR(paramVal_cursor);

3096: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
3097: DBMS_SQL.CLOSE_CURSOR(params_cursor);
3098: END IF;
3099: IF DBMS_SQL.IS_OPEN(paramVal_cursor) THEN
3100: DBMS_SQL.CLOSE_CURSOR(paramVal_cursor);
3101: END IF;
3102: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3103: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.apply_rule_bulk Others:->'||SQLERRM, FALSE);
3104: END IF;

Line 3121: source_cursor := DBMS_SQL.OPEN_CURSOR;

3117: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.refreshGTBulkTable', FALSE);
3118: end if;
3119:
3120: -- Prepare a cursor to select from the source table:
3121: source_cursor := DBMS_SQL.OPEN_CURSOR;
3122:
3123: DBMS_SQL.PARSE(source_cursor, 'delete from FUN_RULE_BULK_RESULT_GT', DBMS_SQL.native);
3124:
3125: ignore := DBMS_SQL.EXECUTE(source_cursor);

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

3119:
3120: -- Prepare a cursor to select from the source table:
3121: source_cursor := DBMS_SQL.OPEN_CURSOR;
3122:
3123: DBMS_SQL.PARSE(source_cursor, 'delete from FUN_RULE_BULK_RESULT_GT', DBMS_SQL.native);
3124:
3125: ignore := DBMS_SQL.EXECUTE(source_cursor);
3126:
3127: DBMS_SQL.CLOSE_CURSOR(source_cursor);

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

3121: source_cursor := DBMS_SQL.OPEN_CURSOR;
3122:
3123: DBMS_SQL.PARSE(source_cursor, 'delete from FUN_RULE_BULK_RESULT_GT', DBMS_SQL.native);
3124:
3125: ignore := DBMS_SQL.EXECUTE(source_cursor);
3126:
3127: DBMS_SQL.CLOSE_CURSOR(source_cursor);
3128:
3129: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 3127: DBMS_SQL.CLOSE_CURSOR(source_cursor);

3123: DBMS_SQL.PARSE(source_cursor, 'delete from FUN_RULE_BULK_RESULT_GT', DBMS_SQL.native);
3124:
3125: ignore := DBMS_SQL.EXECUTE(source_cursor);
3126:
3127: DBMS_SQL.CLOSE_CURSOR(source_cursor);
3128:
3129: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3130: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.refreshGTBulkTable', FALSE);
3131: end if;

Line 3135: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

3131: end if;
3132:
3133: EXCEPTION
3134: WHEN NO_DATA_FOUND THEN
3135: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
3136: DBMS_SQL.CLOSE_CURSOR(source_cursor);
3137: END IF;
3138: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3139: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.refreshGTBulkTable:->'||SQLERRM, FALSE);

Line 3136: DBMS_SQL.CLOSE_CURSOR(source_cursor);

3132:
3133: EXCEPTION
3134: WHEN NO_DATA_FOUND THEN
3135: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
3136: DBMS_SQL.CLOSE_CURSOR(source_cursor);
3137: END IF;
3138: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3139: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.refreshGTBulkTable:->'||SQLERRM, FALSE);
3140: END IF;

Line 3144: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

3140: END IF;
3141: --No Need of Raising in this case.
3142:
3143: WHEN OTHERS THEN
3144: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
3145: DBMS_SQL.CLOSE_CURSOR(source_cursor);
3146: END IF;
3147: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3148: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.refreshGTBulkTable:->'||SQLERRM, FALSE);

Line 3145: DBMS_SQL.CLOSE_CURSOR(source_cursor);

3141: --No Need of Raising in this case.
3142:
3143: WHEN OTHERS THEN
3144: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
3145: DBMS_SQL.CLOSE_CURSOR(source_cursor);
3146: END IF;
3147: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3148: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.refreshGTBulkTable:->'||SQLERRM, FALSE);
3149: END IF;

Line 3165: destination_cursor := DBMS_SQL.OPEN_CURSOR;

3161: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.populateGTBulkTable', FALSE);
3162: end if;
3163:
3164: -- Prepare a cursor to insert into the destination table:
3165: destination_cursor := DBMS_SQL.OPEN_CURSOR;
3166:
3167: DBMS_SQL.PARSE(destination_cursor,p_insert_statement,DBMS_SQL.native);
3168:
3169: ignore := DBMS_SQL.EXECUTE(destination_cursor);

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

3163:
3164: -- Prepare a cursor to insert into the destination table:
3165: destination_cursor := DBMS_SQL.OPEN_CURSOR;
3166:
3167: DBMS_SQL.PARSE(destination_cursor,p_insert_statement,DBMS_SQL.native);
3168:
3169: ignore := DBMS_SQL.EXECUTE(destination_cursor);
3170: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
3171:

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

3165: destination_cursor := DBMS_SQL.OPEN_CURSOR;
3166:
3167: DBMS_SQL.PARSE(destination_cursor,p_insert_statement,DBMS_SQL.native);
3168:
3169: ignore := DBMS_SQL.EXECUTE(destination_cursor);
3170: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
3171:
3172: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3173: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_PUB.populateGTBulkTable', FALSE);

Line 3170: DBMS_SQL.CLOSE_CURSOR(destination_cursor);

3166:
3167: DBMS_SQL.PARSE(destination_cursor,p_insert_statement,DBMS_SQL.native);
3168:
3169: ignore := DBMS_SQL.EXECUTE(destination_cursor);
3170: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
3171:
3172: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3173: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_PUB.populateGTBulkTable', FALSE);
3174: end if;

Line 3182: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN

3178: END IF;
3179:
3180: EXCEPTION
3181: WHEN OTHERS THEN
3182: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
3183: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
3184: END IF;
3185: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3186: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.populateGTBulkTable:->'||p_insert_statement, FALSE);

Line 3183: DBMS_SQL.CLOSE_CURSOR(destination_cursor);

3179:
3180: EXCEPTION
3181: WHEN OTHERS THEN
3182: IF DBMS_SQL.IS_OPEN(destination_cursor) THEN
3183: DBMS_SQL.CLOSE_CURSOR(destination_cursor);
3184: END IF;
3185: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3186: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.populateGTBulkTable:->'||p_insert_statement, FALSE);
3187: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.populateGTBulkTable:->'||SQLERRM, FALSE);

Line 3228: source_cursor := DBMS_SQL.OPEN_CURSOR;

3224: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.isRuleValid:->p_param_view_name='||p_param_view_name, FALSE);
3225: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.isRuleValid:->l_where_clause'||x_where_clause, FALSE);
3226: end if;
3227:
3228: source_cursor := DBMS_SQL.OPEN_CURSOR;
3229: DBMS_SQL.PARSE(source_cursor, l_select, DBMS_SQL.native);
3230:
3231: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_num);
3232: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);

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

3225: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.isRuleValid:->l_where_clause'||x_where_clause, FALSE);
3226: end if;
3227:
3228: source_cursor := DBMS_SQL.OPEN_CURSOR;
3229: DBMS_SQL.PARSE(source_cursor, l_select, DBMS_SQL.native);
3230:
3231: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_num);
3232: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
3233:

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

3227:
3228: source_cursor := DBMS_SQL.OPEN_CURSOR;
3229: DBMS_SQL.PARSE(source_cursor, l_select, DBMS_SQL.native);
3230:
3231: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_num);
3232: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
3233:
3234: /*IF its not a valid SQL statement, then here it goes to Exception
3235: *Else return TRUE.

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

3228: source_cursor := DBMS_SQL.OPEN_CURSOR;
3229: DBMS_SQL.PARSE(source_cursor, l_select, DBMS_SQL.native);
3230:
3231: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_num);
3232: l_num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
3233:
3234: /*IF its not a valid SQL statement, then here it goes to Exception
3235: *Else return TRUE.
3236: */

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

3233:
3234: /*IF its not a valid SQL statement, then here it goes to Exception
3235: *Else return TRUE.
3236: */
3237: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
3238: -- get column values of the row
3239: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);
3240: IF(l_num > 0) THEN
3241: l_present := true;

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

3235: *Else return TRUE.
3236: */
3237: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
3238: -- get column values of the row
3239: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);
3240: IF(l_num > 0) THEN
3241: l_present := true;
3242: END IF;
3243: END IF;

Line 3245: DBMS_SQL.CLOSE_CURSOR(source_cursor);

3241: l_present := true;
3242: END IF;
3243: END IF;
3244:
3245: DBMS_SQL.CLOSE_CURSOR(source_cursor);
3246: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3247: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_PUB.isRuleValid', FALSE);
3248: end if;
3249:

Line 3254: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

3250: RETURN l_present;
3251:
3252: EXCEPTION
3253: WHEN OTHERS THEN
3254: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
3255: DBMS_SQL.CLOSE_CURSOR(source_cursor);
3256: END IF;
3257: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3258: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.isRuleValid:->'||SQLERRM, FALSE);

Line 3255: DBMS_SQL.CLOSE_CURSOR(source_cursor);

3251:
3252: EXCEPTION
3253: WHEN OTHERS THEN
3254: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
3255: DBMS_SQL.CLOSE_CURSOR(source_cursor);
3256: END IF;
3257: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3258: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.isRuleValid:->'||SQLERRM, FALSE);
3259: END IF;