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 440: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;

436: l_multiRuleResultFlag FUN_RULE_OBJECTS_B.MULTI_RULE_RESULT_FLAG%TYPE;
437: l_useDefaultValueFlag FUN_RULE_OBJECTS_B.USE_DEFAULT_VALUE_FLAG%TYPE;
438:
439: l_param_name FUN_RULE_CRIT_PARAMS_B.PARAM_NAME%TYPE;
440: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
441: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
442: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
443: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
444: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;

Line 441: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;

437: l_useDefaultValueFlag FUN_RULE_OBJECTS_B.USE_DEFAULT_VALUE_FLAG%TYPE;
438:
439: l_param_name FUN_RULE_CRIT_PARAMS_B.PARAM_NAME%TYPE;
440: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
441: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
442: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
443: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
444: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;
445:

Line 443: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;

439: l_param_name FUN_RULE_CRIT_PARAMS_B.PARAM_NAME%TYPE;
440: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
441: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
442: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
443: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
444: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;
445:
446: l_ParamMultiValueList multi_param_value;
447:

Line 444: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;

440: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
441: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
442: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
443: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
444: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;
445:
446: l_ParamMultiValueList multi_param_value;
447:
448: l_return_result VARCHAR2(240);

Line 762: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;

758: l_multiRuleResultFlag FUN_RULE_OBJECTS_B.MULTI_RULE_RESULT_FLAG%TYPE;
759: l_useDefaultValueFlag FUN_RULE_OBJECTS_B.USE_DEFAULT_VALUE_FLAG%TYPE;
760:
761: l_param_name FUN_RULE_CRIT_PARAMS_B.PARAM_NAME%TYPE;
762: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
763: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
764: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
765: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
766: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;

Line 763: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;

759: l_useDefaultValueFlag FUN_RULE_OBJECTS_B.USE_DEFAULT_VALUE_FLAG%TYPE;
760:
761: l_param_name FUN_RULE_CRIT_PARAMS_B.PARAM_NAME%TYPE;
762: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
763: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
764: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
765: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
766: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;
767:

Line 765: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;

761: l_param_name FUN_RULE_CRIT_PARAMS_B.PARAM_NAME%TYPE;
762: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
763: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
764: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
765: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
766: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;
767:
768: l_ParamMultiValueList multi_param_value;
769:

Line 766: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;

762: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
763: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
764: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
765: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
766: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;
767:
768: l_ParamMultiValueList multi_param_value;
769:
770: l_return_result VARCHAR2(240);

Line 2599: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;

2595: l_flexfield_app_short_name FUN_RULE_OBJECTS_B.FLEXFIELD_APP_SHORT_NAME%TYPE;
2596: l_multiRuleResultFlag FUN_RULE_OBJECTS_B.MULTI_RULE_RESULT_FLAG%TYPE;
2597:
2598: l_param_name FUN_RULE_CRIT_PARAMS_B.PARAM_NAME%TYPE;
2599: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
2600: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
2601: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
2602: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
2603: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;

Line 2600: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;

2596: l_multiRuleResultFlag FUN_RULE_OBJECTS_B.MULTI_RULE_RESULT_FLAG%TYPE;
2597:
2598: l_param_name FUN_RULE_CRIT_PARAMS_B.PARAM_NAME%TYPE;
2599: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
2600: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
2601: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
2602: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
2603: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;
2604:

Line 2602: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;

2598: l_param_name FUN_RULE_CRIT_PARAMS_B.PARAM_NAME%TYPE;
2599: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
2600: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
2601: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
2602: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
2603: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;
2604:
2605: l_ParamMultiValueList multi_param_value;
2606:

Line 2603: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;

2599: l_condition FUN_RULE_CRITERIA.CONDITION%TYPE;
2600: l_param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE;
2601: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%TYPE;
2602: l_case_sensitive FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE;
2603: l_criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE;
2604:
2605: l_ParamMultiValueList multi_param_value;
2606:
2607: l_result_value VARCHAR2(1024);

Line 2810: FROM fun_rule_crit_params_b param, fun_rule_criteria criteria

2806: name of the param name to the associated column name
2807: */
2808:
2809: SELECT parameter_type,criteria.criteria_param_id INTO l_param_type,l_criteria_parameter_id
2810: FROM fun_rule_crit_params_b param, fun_rule_criteria criteria
2811: WHERE criteria.criteria_id = l_criteria_id
2812: AND criteria.criteria_param_id = param.criteria_param_id;
2813:
2814: IF (l_param_type = 'CUSTOM') THEN