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.JA_CN_UTILITY dependencies on FND_FLEX_VALUES

Line 1414: SELECT Nvl(Fvt.Application_Table_Name, 'FND_FLEX_VALUES'),

1410: --
1411: -- Insert segment values from the balancing flex value set if the BSV option is
1412: -- All (i.e. A)
1413: --
1414: SELECT Nvl(Fvt.Application_Table_Name, 'FND_FLEX_VALUES'),
1415: Nvl(Fvt.Value_Column_Name, 'FLEX_VALUE'),
1416: Fvs.Validation_Type
1417: INTO l_Fv_Table,
1418: l_Fv_Col,

Line 2681: lv_segment_value_desc FND_FLEX_VALUES_TL.Description%TYPE := NULL;

2677: ,pv_flex_value IN VARCHAR2
2678: ,pn_coa_id IN NUMBER)
2679: RETURN VARCHAR2
2680: IS
2681: lv_segment_value_desc FND_FLEX_VALUES_TL.Description%TYPE := NULL;
2682: lv_procedure_name VARCHAR2(40) := 'Get_Segment_Value_Desc';
2683: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2684: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2685:

Line 2692: Fnd_Flex_Values FFV,

2688: IS
2689: SELECT FFV.Flex_Value Segment_Value
2690: ,FFVT.Description Segment_Value_Description
2691: FROM FND_ID_FLEX_SEGMENTS FIFS,
2692: Fnd_Flex_Values FFV,
2693: FND_FLEX_VALUES_TL FFVT
2694: WHERE FIFS.Application_Id = 101
2695: AND FIFS.Application_Column_Name = Get_Attribute_Column(pv_flexfield_code --parameter: pv_flexfield_code
2696: ,101

Line 2693: FND_FLEX_VALUES_TL FFVT

2689: SELECT FFV.Flex_Value Segment_Value
2690: ,FFVT.Description Segment_Value_Description
2691: FROM FND_ID_FLEX_SEGMENTS FIFS,
2692: Fnd_Flex_Values FFV,
2693: FND_FLEX_VALUES_TL FFVT
2694: WHERE FIFS.Application_Id = 101
2695: AND FIFS.Application_Column_Name = Get_Attribute_Column(pv_flexfield_code --parameter: pv_flexfield_code
2696: ,101
2697: ,pn_coa_id) -- parameter: pn_coa_id

Line 2761: lv_atrribute_value Fnd_Flex_Values.ATTRIBUTE1%TYPE := NULL;

2757: ,pv_project_id IN VARCHAR2
2758: ,pn_coa_id IN NUMBER)
2759: RETURN VARCHAR2
2760: IS
2761: lv_atrribute_value Fnd_Flex_Values.ATTRIBUTE1%TYPE := NULL;
2762: lv_procedure_name VARCHAR2(40) := 'Get_Attribute_Value';
2763: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2764: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2765:

Line 2784: lv_cursor_sql := lv_cursor_sql || ' Fnd_Flex_Values FFV';

2780: lv_cursor_sql := 'SELECT FFV.'|| Get_Attribute_Column(pv_flexfield_code
2781: ,0
2782: ,pn_coa_id) || ' Attribute_Value';
2783: lv_cursor_sql := lv_cursor_sql || ' FROM FND_ID_FLEX_SEGMENTS FIFS,' ;
2784: lv_cursor_sql := lv_cursor_sql || ' Fnd_Flex_Values FFV';
2785: lv_cursor_sql := lv_cursor_sql || ' WHERE FIFS.Application_Id = 101';
2786: lv_cursor_sql := lv_cursor_sql || ' AND FIFS.Application_Column_Name = '''||Get_Attribute_Column('CPRO'
2787: ,101
2788: ,pn_coa_id)||'''';

Line 2839: lv_attribute_value_desc FND_FLEX_VALUES_TL.Description%TYPE := NULL;

2835: ,pv_flex_value IN VARCHAR2
2836: ,pn_coa_id IN NUMBER)
2837: RETURN VARCHAR2
2838: IS
2839: lv_attribute_value_desc FND_FLEX_VALUES_TL.Description%TYPE := NULL;
2840: lv_procedure_name VARCHAR2(40) := 'Get_Attribute_Value_Desc';
2841: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2842: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2843:

Line 2849: Fnd_Flex_Values FFV,

2845: IS
2846: SELECT FFV.Flex_Value Attribute_Value
2847: , FFVT.Description Attribute_Value_Desc
2848: FROM FND_DESCR_FLEX_COL_USAGE_VL FUV,
2849: Fnd_Flex_Values FFV,
2850: FND_FLEX_VALUES_TL FFVT
2851: WHERE FUV.Application_Id = 0
2852: AND FUV.Application_Column_Name = Get_Attribute_Column(pv_flexfield_code
2853: ,0

Line 2850: FND_FLEX_VALUES_TL FFVT

2846: SELECT FFV.Flex_Value Attribute_Value
2847: , FFVT.Description Attribute_Value_Desc
2848: FROM FND_DESCR_FLEX_COL_USAGE_VL FUV,
2849: Fnd_Flex_Values FFV,
2850: FND_FLEX_VALUES_TL FFVT
2851: WHERE FUV.Application_Id = 0
2852: AND FUV.Application_Column_Name = Get_Attribute_Column(pv_flexfield_code
2853: ,0
2854: ,pn_coa_id) --Get_Attribute_Column(0,'AFTY'/'ABSO')

Line 2855: AND FUV.Descriptive_FlexField_Name = 'FND_FLEX_VALUES'

2851: WHERE FUV.Application_Id = 0
2852: AND FUV.Application_Column_Name = Get_Attribute_Column(pv_flexfield_code
2853: ,0
2854: ,pn_coa_id) --Get_Attribute_Column(0,'AFTY'/'ABSO')
2855: AND FUV.Descriptive_FlexField_Name = 'FND_FLEX_VALUES'
2856: AND FFV.FLEX_VALUE_SET_ID = FUV.FLEX_VALUE_SET_ID
2857: AND FFV.Flex_Value = pv_flex_value --parameter: pv_flex_value
2858: AND FFVT.Flex_Value_Id = FFV.Flex_Value_Id
2859: AND FFVT.LANGUAGE = userenv('LANG');

Line 3062: lv_budget_type_value Fnd_Flex_Values.Flex_Value%TYPE := NULL;

3058: --==========================================================================
3059: FUNCTION Get_Budget_Type_Value(pn_coa_id IN NUMBER
3060: ,pv_flexfield_code IN VARCHAR2
3061: ) RETURN VARCHAR2 IS
3062: lv_budget_type_value Fnd_Flex_Values.Flex_Value%TYPE := NULL;
3063: lv_procedure_name VARCHAR2(40) := 'Get_Attribute_Value';
3064: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3065: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
3066:

Line 3083: lv_cursor_sql := lv_cursor_sql || ' Fnd_Flex_Values FFV';

3079: END IF; --(ln_proc_level>=ln_dbg_level)
3080:
3081: lv_cursor_sql := 'SELECT FFV.Flex_Value Budget_Type';
3082: lv_cursor_sql := lv_cursor_sql || ' FROM FND_ID_FLEX_SEGMENTS FIFS,';
3083: lv_cursor_sql := lv_cursor_sql || ' Fnd_Flex_Values FFV';
3084: lv_cursor_sql := lv_cursor_sql || ' WHERE FIFS.Application_Id = 101';
3085: lv_cursor_sql := lv_cursor_sql || ' AND FIFS.Application_Column_Name = '''||Get_Attribute_Column('CBTY'
3086: ,101
3087: ,pn_coa_id)||'''';