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_CRIT_PARAMS_B

Line 58: FROM FUN_RULE_CRIT_PARAMS_B FRCP,

54:
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

Line 67: FUN_RULE_CRIT_PARAMS_B FRCP,

63: SELECT LOOKUP_CODE,
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

Line 439: l_param_name FUN_RULE_CRIT_PARAMS_B.PARAM_NAME%TYPE;

435: l_flexfield_app_short_name FUN_RULE_OBJECTS_B.FLEXFIELD_APP_SHORT_NAME%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;

Line 442: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%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:
446: l_ParamMultiValueList multi_param_value;

Line 761: l_param_name FUN_RULE_CRIT_PARAMS_B.PARAM_NAME%TYPE;

757: l_flexfield_app_short_name FUN_RULE_OBJECTS_B.FLEXFIELD_APP_SHORT_NAME%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;

Line 764: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%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:
768: l_ParamMultiValueList multi_param_value;

Line 2598: l_param_name FUN_RULE_CRIT_PARAMS_B.PARAM_NAME%TYPE;

2594: l_flexfield_name FUN_RULE_OBJECTS_B.FLEXFIELD_NAME%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;

Line 2601: l_data_type FUN_RULE_CRIT_PARAMS_B.DATA_TYPE%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:
2605: l_ParamMultiValueList multi_param_value;

Line 2629: l_criteria_parameter_id FUN_RULE_CRIT_PARAMS_B.CRITERIA_PARAM_ID%TYPE;

2625: l_old_moac_access_mode VARCHAR2(1);
2626: l_old_org_id NUMBER;
2627: l_date_format VARCHAR2(50) := 'YYYY/MM/DD HH24:MI:SS';
2628: l_param_type VARCHAR2(20);
2629: l_criteria_parameter_id FUN_RULE_CRIT_PARAMS_B.CRITERIA_PARAM_ID%TYPE;
2630:
2631: BEGIN
2632: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2633: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.apply_rule_bulk', FALSE);

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

Line 2816: FROM FUN_RULE_CRIT_PARAMS_B

2812: AND criteria.criteria_param_id = param.criteria_param_id;
2813:
2814: IF (l_param_type = 'CUSTOM') THEN
2815: SELECT COLUMN_NAME into l_param_name
2816: FROM FUN_RULE_CRIT_PARAMS_B
2817: WHERE criteria_param_id = l_criteria_parameter_id;
2818: END IF;
2819: /*END: RULES ENGINE ENHANCEMNT FOR CUSTOM PARAMETERS*/
2820: