683:
684: /*
685:
686: PROCEDURE CREATE_DUPLICATE_RULE(
687: p_rule_detail_id IN FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,
688: p_rule_object_id IN FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE
689: ) IS
690:
691: l_next_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;
684: /*
685:
686: PROCEDURE CREATE_DUPLICATE_RULE(
687: p_rule_detail_id IN FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,
688: p_rule_object_id IN FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE
689: ) IS
690:
691: l_next_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;
692: l_next_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;
687: p_rule_detail_id IN FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,
688: p_rule_object_id IN FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE
689: ) IS
690:
691: l_next_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;
692: l_next_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;
693:
694: l_rowid ROWID;
695:
692: l_next_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;
693:
694: l_rowid ROWID;
695:
696: l_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;
697: l_rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE;
698: l_rule_name FUN_RULE_DETAILS.RULE_NAME%TYPE;
699: l_seq FUN_RULE_DETAILS.SEQ%TYPE;
700: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
693:
694: l_rowid ROWID;
695:
696: l_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;
697: l_rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE;
698: l_rule_name FUN_RULE_DETAILS.RULE_NAME%TYPE;
699: l_seq FUN_RULE_DETAILS.SEQ%TYPE;
700: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
701: l_enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%TYPE;
694: l_rowid ROWID;
695:
696: l_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;
697: l_rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE;
698: l_rule_name FUN_RULE_DETAILS.RULE_NAME%TYPE;
699: l_seq FUN_RULE_DETAILS.SEQ%TYPE;
700: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
701: l_enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%TYPE;
702: l_result_application_id FUN_RULE_DETAILS.RESULT_APPLICATION_ID%TYPE;
695:
696: l_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;
697: l_rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE;
698: l_rule_name FUN_RULE_DETAILS.RULE_NAME%TYPE;
699: l_seq FUN_RULE_DETAILS.SEQ%TYPE;
700: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
701: l_enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%TYPE;
702: l_result_application_id FUN_RULE_DETAILS.RESULT_APPLICATION_ID%TYPE;
703: l_result_value FUN_RULE_DETAILS.RESULT_VALUE%TYPE;
696: l_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;
697: l_rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE;
698: l_rule_name FUN_RULE_DETAILS.RULE_NAME%TYPE;
699: l_seq FUN_RULE_DETAILS.SEQ%TYPE;
700: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
701: l_enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%TYPE;
702: l_result_application_id FUN_RULE_DETAILS.RESULT_APPLICATION_ID%TYPE;
703: l_result_value FUN_RULE_DETAILS.RESULT_VALUE%TYPE;
704: l_created_by_module FUN_RULE_DETAILS.CREATED_BY_MODULE%TYPE;
697: l_rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE;
698: l_rule_name FUN_RULE_DETAILS.RULE_NAME%TYPE;
699: l_seq FUN_RULE_DETAILS.SEQ%TYPE;
700: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
701: l_enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%TYPE;
702: l_result_application_id FUN_RULE_DETAILS.RESULT_APPLICATION_ID%TYPE;
703: l_result_value FUN_RULE_DETAILS.RESULT_VALUE%TYPE;
704: l_created_by_module FUN_RULE_DETAILS.CREATED_BY_MODULE%TYPE;
705:
698: l_rule_name FUN_RULE_DETAILS.RULE_NAME%TYPE;
699: l_seq FUN_RULE_DETAILS.SEQ%TYPE;
700: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
701: l_enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%TYPE;
702: l_result_application_id FUN_RULE_DETAILS.RESULT_APPLICATION_ID%TYPE;
703: l_result_value FUN_RULE_DETAILS.RESULT_VALUE%TYPE;
704: l_created_by_module FUN_RULE_DETAILS.CREATED_BY_MODULE%TYPE;
705:
706:
699: l_seq FUN_RULE_DETAILS.SEQ%TYPE;
700: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
701: l_enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%TYPE;
702: l_result_application_id FUN_RULE_DETAILS.RESULT_APPLICATION_ID%TYPE;
703: l_result_value FUN_RULE_DETAILS.RESULT_VALUE%TYPE;
704: l_created_by_module FUN_RULE_DETAILS.CREATED_BY_MODULE%TYPE;
705:
706:
707: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;
700: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
701: l_enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%TYPE;
702: l_result_application_id FUN_RULE_DETAILS.RESULT_APPLICATION_ID%TYPE;
703: l_result_value FUN_RULE_DETAILS.RESULT_VALUE%TYPE;
704: l_created_by_module FUN_RULE_DETAILS.CREATED_BY_MODULE%TYPE;
705:
706:
707: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;
708: l_criteria_param_name FUN_RULE_CRITERIA.CRITERIA_PARAM_NAME%TYPE;
718:
719:
720: BEGIN
721:
722: SELECT FUN_RULE_DETAILS_S.NEXTVAL
723: INTO l_next_rule_detail_id
724: FROM DUAL;
725:
726: SELECT
741: l_result_application_id,
742: l_result_value,
743: l_created_by_module
744:
745: FROM FUN_RULE_DETAILS
746: WHERE RULE_OBJECT_ID = p_rule_object_id
747: AND RULE_DETAIL_ID = p_rule_detail_id;
748:
749: FUN_RULE_DETAILS_PKG.INSERT_ROW (
745: FROM FUN_RULE_DETAILS
746: WHERE RULE_OBJECT_ID = p_rule_object_id
747: AND RULE_DETAIL_ID = p_rule_detail_id;
748:
749: FUN_RULE_DETAILS_PKG.INSERT_ROW (
750: X_ROWID =>l_rowid,
751: X_RULE_DETAIL_ID =>l_next_rule_detail_id,
752: X_RULE_OBJECT_ID =>l_rule_object_id,
753: X_RULE_NAME =>l_rule_name,
795: END CREATE_DUPLICATE_RULE;
796: */
797:
798: FUNCTION GET_MAX_SEQ (
799: P_RULE_OBJECT_ID IN FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE
800: )
801: RETURN NUMBER IS
802:
803: l_max_seq FUN_RULE_DETAILS.SEQ%TYPE;
799: P_RULE_OBJECT_ID IN FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE
800: )
801: RETURN NUMBER IS
802:
803: l_max_seq FUN_RULE_DETAILS.SEQ%TYPE;
804:
805: BEGIN
806: SELECT MAX(SEQ)+1 INTO l_max_seq
807: FROM FUN_RULE_DETAILS
803: l_max_seq FUN_RULE_DETAILS.SEQ%TYPE;
804:
805: BEGIN
806: SELECT MAX(SEQ)+1 INTO l_max_seq
807: FROM FUN_RULE_DETAILS
808: WHERE RULE_OBJECT_ID = P_RULE_OBJECT_ID;
809: RETURN l_max_seq;
810:
811: EXCEPTION