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_UTILITY_PKG dependencies on FUN_RULE_DETAILS

Line 687: p_rule_detail_id IN FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,

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;

Line 688: p_rule_object_id IN FUN_RULE_DETAILS.RULE_OBJECT_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;

Line 691: l_next_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_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:

Line 696: l_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:
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;

Line 697: l_rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_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;
701: l_enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%TYPE;

Line 698: l_rule_name FUN_RULE_DETAILS.RULE_NAME%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;

Line 699: l_seq FUN_RULE_DETAILS.SEQ%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;

Line 700: l_operator FUN_RULE_DETAILS.OPERATOR%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;

Line 701: l_enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%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:

Line 702: l_result_application_id FUN_RULE_DETAILS.RESULT_APPLICATION_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:
706:

Line 703: l_result_value FUN_RULE_DETAILS.RESULT_VALUE%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:
707: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;

Line 704: l_created_by_module FUN_RULE_DETAILS.CREATED_BY_MODULE%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;

Line 722: SELECT FUN_RULE_DETAILS_S.NEXTVAL

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

Line 745: FROM FUN_RULE_DETAILS

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 (

Line 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,

Line 799: P_RULE_OBJECT_ID IN FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE

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;

Line 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

Line 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