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_DETAILS

Line 33: FROM FUN_RULE_DETAILS FRD , FUN_RULE_OBJECTS_VL FRO

29:
30: g_sRuleDetailSql VARCHAR2(2000) := 'SELECT FRO.RESULT_TYPE, FRD.RULE_DETAIL_ID, FRD.OPERATOR ,
31: FRD.RULE_OBJECT_ID,FRO.FLEXFIELD_NAME , FRO.FLEXFIELD_APP_SHORT_NAME,
32: UPPER(NVL(FRO.MULTI_RULE_RESULT_FLAG, ''N'')), UPPER(USE_DEFAULT_VALUE_FLAG)
33: FROM FUN_RULE_DETAILS FRD , FUN_RULE_OBJECTS_VL FRO
34: WHERE FRO.RULE_OBJECT_ID = FRD.RULE_OBJECT_ID
35: AND FRO.RULE_OBJECT_NAME=:1
36: AND FRO.APPLICATION_ID = :2
37: AND NVL(FRD.ENABLED_FLAG,''N'') = ''Y''

Line 43: FROM FUN_RULE_DETAILS FRD , FUN_RULE_OBJECTS_VL FRO

39:
40: g_sRuleDetailMOACSql VARCHAR2(2000) := 'SELECT FRO.RESULT_TYPE, FRD.RULE_DETAIL_ID, FRD.OPERATOR ,
41: FRD.RULE_OBJECT_ID,FRO.FLEXFIELD_NAME , FRO.FLEXFIELD_APP_SHORT_NAME,
42: UPPER(NVL(FRO.MULTI_RULE_RESULT_FLAG, ''N'')), UPPER(USE_DEFAULT_VALUE_FLAG)
43: FROM FUN_RULE_DETAILS FRD , FUN_RULE_OBJECTS_VL FRO
44: WHERE FRO.RULE_OBJECT_ID = FRD.RULE_OBJECT_ID
45: AND FRO.RULE_OBJECT_NAME=:1
46: AND FRO.APPLICATION_ID = :2
47: AND NVL(FRD.ENABLED_FLAG,''N'') = ''Y''

Line 105: FROM FUN_RULE_DETAILS WHERE RULE_DETAIL_ID = :1' ;

101: (ORG_ID IS NOT NULL AND :6 IS NOT NULL AND ORG_ID = :7))';
102:
103:
104: g_sResultValuesSql VARCHAR2(1000) := 'SELECT RULE_DETAIL_ID , RESULT_VALUE , RESULT_APPLICATION_ID , RULE_NAME
105: FROM FUN_RULE_DETAILS WHERE RULE_DETAIL_ID = :1' ;
106:
107:
108: g_sDefaultValuesSql varchar2(1000) := 'SELECT DEFAULT_VALUE , DEFAULT_APPLICATION_ID FROM FUN_RULE_OBJ_ATTRIBUTES
109: WHERE RULE_OBJECT_ID = :1 ';

Line 430: l_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;

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

Line 431: l_prev_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;

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;
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;

Line 432: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;

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;
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;

Line 433: l_rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE;

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;
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;

Line 752: l_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;

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

Line 753: l_prev_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;

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;
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;

Line 754: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;

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;
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;

Line 755: l_rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE;

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;
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;

Line 1511: FROM '|| sDFFTableName ||' DFF , FUN_RULE_DETAILS FRD

1507: 'SELECT DFF.RULE_DETAIL_ID, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2,
1508: ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7,
1509: ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
1510: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15 , RULE_NAME , RESULT_APPLICATION_ID
1511: FROM '|| sDFFTableName ||' DFF , FUN_RULE_DETAILS FRD
1512: WHERE DFF.RULE_DETAIL_ID = :1 AND DFF.RULE_OBJECT_ID = :2 AND DFF.RULE_DETAIL_ID = FRD.RULE_DETAIL_ID'
1513: , DBMS_SQL.native);
1514: else
1515: DBMS_SQL.PARSE(source_cursor,

Line 1520: FROM '|| sDFFTableName ||' DFF , FUN_RULE_DETAILS FRD

1516: 'SELECT DFF.RULE_DETAIL_ID, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2,
1517: ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7,
1518: ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
1519: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15 , RULE_NAME , RESULT_APPLICATION_ID
1520: FROM '|| sDFFTableName ||' DFF , FUN_RULE_DETAILS FRD
1521: WHERE DFF.RULE_DETAIL_ID = :1 AND DFF.RULE_DETAIL_ID = FRD.RULE_DETAIL_ID'
1522: , DBMS_SQL.native);
1523: end if;
1524:

Line 2590: l_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;

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

Line 2591: l_prev_rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE;

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;
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;

Line 2592: l_operator FUN_RULE_DETAILS.OPERATOR%TYPE;

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;
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;

Line 2593: l_rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE;

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