APPS.JA_CN_UTILITY dependencies on FND_FLEX_VALUES_TL

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 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 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 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')