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_OBJECTS_B

Line 82: FROM FUN_RULE_OBJECTS_B FRO,

78: AND FRC.CRITERIA_ID = FRMP.CRITERIA_ID
79: AND FRC.CRITERIA_ID = :2 ';
80:
81: g_sValueSetSql VARCHAR2(1000) := 'SELECT FFVS.FORMAT_TYPE
82: FROM FUN_RULE_OBJECTS_B FRO,
83: FND_FLEX_VALUE_SETS FFVS
84: WHERE FRO.FLEX_VALUE_SET_ID = FFVS.FLEX_VALUE_SET_ID
85: AND FRO.RULE_OBJECT_ID = :1 ';
86:

Line 90: FROM FUN_RULE_OBJECTS_B

86:
87:
88: g_sRuleObjectSql VARCHAR2(1000) := 'SELECT RESULT_TYPE, RULE_OBJECT_ID,
89: FLEXFIELD_NAME , FLEXFIELD_APP_SHORT_NAME
90: FROM FUN_RULE_OBJECTS_B
91: WHERE RULE_OBJECT_NAME = :1';
92:
93: g_sRuleObjectMOACSql VARCHAR2(1000) := 'SELECT RESULT_TYPE, RULE_OBJECT_ID,
94: FLEXFIELD_NAME , FLEXFIELD_APP_SHORT_NAME

Line 95: FROM FUN_RULE_OBJECTS_B

91: WHERE RULE_OBJECT_NAME = :1';
92:
93: g_sRuleObjectMOACSql VARCHAR2(1000) := 'SELECT RESULT_TYPE, RULE_OBJECT_ID,
94: FLEXFIELD_NAME , FLEXFIELD_APP_SHORT_NAME
95: FROM FUN_RULE_OBJECTS_B
96: WHERE RULE_OBJECT_NAME = :1
97: AND ( (INSTANCE_LABEL IS NULL AND :2 IS NULL) OR
98: (INSTANCE_LABEL IS NOT NULL AND :3 IS NOT NULL AND INSTANCE_LABEL = :4))
99: AND

Line 313: FUN_RULE_OBJECTS_B FRO, FND_APPLICATION APPL

309: END IF;
310: -- Added for Bug 9025784 - End
311:
312: SELECT 'Y', RULE_OBJECT_ID INTO L_DUMMY, m_ruleObjectId FROM
313: FUN_RULE_OBJECTS_B FRO, FND_APPLICATION APPL
314: WHERE RULE_OBJECT_NAME = p_rule_object_name
315: AND FRO.APPLICATION_ID = APPL.APPLICATION_ID
316: AND APPL.APPLICATION_SHORT_NAME = p_application_short_name
317: AND

Line 429: l_result_type FUN_RULE_OBJECTS_B.RESULT_TYPE%TYPE;

425:
426: l_ret_val boolean := true;
427: l_all_rule_retval boolean := false; --to track at least one rule is satisfied or not.
428:
429: l_result_type FUN_RULE_OBJECTS_B.RESULT_TYPE%TYPE;
430: l_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;
431: l_prev_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;
432: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
433: l_rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE;

Line 434: l_flexfield_name FUN_RULE_OBJECTS_B.FLEXFIELD_NAME%TYPE;

430: l_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;
431: l_prev_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;
432: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
433: l_rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE;
434: l_flexfield_name FUN_RULE_OBJECTS_B.FLEXFIELD_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:

Line 435: l_flexfield_app_short_name FUN_RULE_OBJECTS_B.FLEXFIELD_APP_SHORT_NAME%TYPE;

431: l_prev_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;
432: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
433: l_rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE;
434: l_flexfield_name FUN_RULE_OBJECTS_B.FLEXFIELD_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;

Line 436: l_multiRuleResultFlag FUN_RULE_OBJECTS_B.MULTI_RULE_RESULT_FLAG%TYPE;

432: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
433: l_rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE;
434: l_flexfield_name FUN_RULE_OBJECTS_B.FLEXFIELD_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;

Line 437: l_useDefaultValueFlag FUN_RULE_OBJECTS_B.USE_DEFAULT_VALUE_FLAG%TYPE;

433: l_rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE;
434: l_flexfield_name FUN_RULE_OBJECTS_B.FLEXFIELD_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;

Line 751: l_result_type FUN_RULE_OBJECTS_B.RESULT_TYPE%TYPE;

747:
748: l_ret_val boolean := true;
749: l_all_rule_retval boolean := false; --to track at least one rule is satisfied or not.
750:
751: l_result_type FUN_RULE_OBJECTS_B.RESULT_TYPE%TYPE;
752: l_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;
753: l_prev_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;
754: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
755: l_rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE;

Line 756: l_flexfield_name FUN_RULE_OBJECTS_B.FLEXFIELD_NAME%TYPE;

752: l_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;
753: l_prev_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;
754: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
755: l_rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE;
756: l_flexfield_name FUN_RULE_OBJECTS_B.FLEXFIELD_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:

Line 757: l_flexfield_app_short_name FUN_RULE_OBJECTS_B.FLEXFIELD_APP_SHORT_NAME%TYPE;

753: l_prev_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;
754: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
755: l_rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE;
756: l_flexfield_name FUN_RULE_OBJECTS_B.FLEXFIELD_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;

Line 758: l_multiRuleResultFlag FUN_RULE_OBJECTS_B.MULTI_RULE_RESULT_FLAG%TYPE;

754: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
755: l_rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE;
756: l_flexfield_name FUN_RULE_OBJECTS_B.FLEXFIELD_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;

Line 759: l_useDefaultValueFlag FUN_RULE_OBJECTS_B.USE_DEFAULT_VALUE_FLAG%TYPE;

755: l_rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE;
756: l_flexfield_name FUN_RULE_OBJECTS_B.FLEXFIELD_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;

Line 2589: l_result_type FUN_RULE_OBJECTS_B.RESULT_TYPE%TYPE;

2585: destination_cursor INTEGER;
2586: params_cursor INTEGER;
2587: params_rows_processed INTEGER;
2588:
2589: l_result_type FUN_RULE_OBJECTS_B.RESULT_TYPE%TYPE;
2590: l_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;
2591: l_prev_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;
2592: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
2593: l_rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE;

Line 2594: l_flexfield_name FUN_RULE_OBJECTS_B.FLEXFIELD_NAME%TYPE;

2590: l_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;
2591: l_prev_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;
2592: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
2593: l_rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%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;

Line 2595: l_flexfield_app_short_name FUN_RULE_OBJECTS_B.FLEXFIELD_APP_SHORT_NAME%TYPE;

2591: l_prev_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;
2592: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
2593: l_rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%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;

Line 2596: l_multiRuleResultFlag FUN_RULE_OBJECTS_B.MULTI_RULE_RESULT_FLAG%TYPE;

2592: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;
2593: l_rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%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;