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 FUN_RULE_CRITERIA

Line 59: FUN_RULE_CRITERIA FRC

55: g_sCriteriaParamSql VARCHAR2(2000) := 'SELECT FRCP.PARAM_NAME,
56: FRC.CONDITION, FRC.PARAM_VALUE, FRCP.DATA_TYPE,
57: FRC.CASE_SENSITIVE_FLAG , FRC.CRITERIA_ID
58: FROM FUN_RULE_CRIT_PARAMS_B FRCP,
59: FUN_RULE_CRITERIA FRC
60: WHERE FRC.RULE_DETAIL_ID = :1
61: AND FRC.CRITERIA_PARAM_ID = FRCP.CRITERIA_PARAM_ID
62: UNION
63: SELECT LOOKUP_CODE,

Line 68: FUN_RULE_CRITERIA FRC

64: FRC.CONDITION, FRC.PARAM_VALUE, ''STRINGS'',
65: FRC.CASE_SENSITIVE_FLAG , FRC.CRITERIA_ID
66: FROM FUN_LOOKUPS FLV,
67: FUN_RULE_CRIT_PARAMS_B FRCP,
68: FUN_RULE_CRITERIA FRC
69: WHERE LOOKUP_TYPE = ''FUN_RULE_SEED_PARAMS''
70: AND FRC.RULE_DETAIL_ID = :2
71: AND FRC.CRITERIA_PARAM_ID = FRCP.CRITERIA_PARAM_ID
72: AND FRCP.PARAM_NAME = FLV.LOOKUP_CODE';

Line 76: FUN_RULE_CRITERIA FRC

72: AND FRCP.PARAM_NAME = FLV.LOOKUP_CODE';
73:
74: g_sMultiCriteriaParamValueSql VARCHAR2(1000) := 'SELECT FRMP.PARAM_VALUE
75: FROM FUN_RULE_PARAM_VALUES FRMP,
76: FUN_RULE_CRITERIA FRC
77: WHERE FRC.RULE_DETAIL_ID = :1
78: AND FRC.CRITERIA_ID = FRMP.CRITERIA_ID
79: AND FRC.CRITERIA_ID = :2 ';
80:

Line 432: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;

428: l_multiRuleResultFlag FUN_RULE_OBJECTS_B.MULTI_RULE_RESULT_FLAG%TYPE;
429: l_useDefaultValueFlag FUN_RULE_OBJECTS_B.USE_DEFAULT_VALUE_FLAG%TYPE;
430:
431: l_param_name FUN_RULE_CRIT_PARAMS_B.PARAM_NAME%TYPE;
432: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
433: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
434: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
435: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
436: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;

Line 433: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;

429: l_useDefaultValueFlag FUN_RULE_OBJECTS_B.USE_DEFAULT_VALUE_FLAG%TYPE;
430:
431: l_param_name FUN_RULE_CRIT_PARAMS_B.PARAM_NAME%TYPE;
432: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
433: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
434: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
435: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
436: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;
437:

Line 435: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;

431: l_param_name FUN_RULE_CRIT_PARAMS_B.PARAM_NAME%TYPE;
432: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
433: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
434: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
435: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
436: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;
437:
438: l_ParamMultiValueList multi_param_value;
439:

Line 436: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;

432: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
433: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
434: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
435: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
436: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;
437:
438: l_ParamMultiValueList multi_param_value;
439:
440: l_return_result VARCHAR2(240);

Line 754: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;

750: l_multiRuleResultFlag FUN_RULE_OBJECTS_B.MULTI_RULE_RESULT_FLAG%TYPE;
751: l_useDefaultValueFlag FUN_RULE_OBJECTS_B.USE_DEFAULT_VALUE_FLAG%TYPE;
752:
753: l_param_name FUN_RULE_CRIT_PARAMS_B.PARAM_NAME%TYPE;
754: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
755: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
756: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
757: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
758: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;

Line 755: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;

751: l_useDefaultValueFlag FUN_RULE_OBJECTS_B.USE_DEFAULT_VALUE_FLAG%TYPE;
752:
753: l_param_name FUN_RULE_CRIT_PARAMS_B.PARAM_NAME%TYPE;
754: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
755: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
756: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
757: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
758: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;
759:

Line 757: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;

753: l_param_name FUN_RULE_CRIT_PARAMS_B.PARAM_NAME%TYPE;
754: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
755: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
756: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
757: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
758: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;
759:
760: l_ParamMultiValueList multi_param_value;
761:

Line 758: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;

754: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
755: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
756: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
757: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
758: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;
759:
760: l_ParamMultiValueList multi_param_value;
761:
762: l_return_result VARCHAR2(240);

Line 2591: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;

2587: l_flexfield_app_short_name FUN_RULE_OBJECTS_B.FLEXFIELD_APP_SHORT_NAME%TYPE;
2588: l_multiRuleResultFlag FUN_RULE_OBJECTS_B.MULTI_RULE_RESULT_FLAG%TYPE;
2589:
2590: l_param_name FUN_RULE_CRIT_PARAMS_B.PARAM_NAME%TYPE;
2591: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
2592: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
2593: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
2594: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
2595: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;

Line 2592: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;

2588: l_multiRuleResultFlag FUN_RULE_OBJECTS_B.MULTI_RULE_RESULT_FLAG%TYPE;
2589:
2590: l_param_name FUN_RULE_CRIT_PARAMS_B.PARAM_NAME%TYPE;
2591: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
2592: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
2593: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
2594: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
2595: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;
2596:

Line 2594: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;

2590: l_param_name FUN_RULE_CRIT_PARAMS_B.PARAM_NAME%TYPE;
2591: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
2592: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
2593: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
2594: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
2595: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;
2596:
2597: l_ParamMultiValueList multi_param_value;
2598:

Line 2595: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;

2591: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
2592: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
2593: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
2594: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
2595: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;
2596:
2597: l_ParamMultiValueList multi_param_value;
2598:
2599: l_result_value VARCHAR2(1024);