APPS.FV_FUNDS_AVAIL_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 33: vg_bal_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;

29: vp_units VARCHAR2(30);
30: -- ======================================================================
31: -- Other Global Variable Declarations
32: -- ======================================================================
33: vg_bal_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;
34: vg_acct_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;
35: vg_apps_id Fnd_Id_Flex_Structures.application_id%TYPE;
36: vg_id_flex_code Fnd_Id_Flex_Structures.id_flex_code%TYPE;
37: vg_delimiter Fnd_Id_Flex_Structures.concatenated_segment_delimiter%TYPE ;

Line 34: vg_acct_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;

30: -- ======================================================================
31: -- Other Global Variable Declarations
32: -- ======================================================================
33: vg_bal_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;
34: vg_acct_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;
35: vg_apps_id Fnd_Id_Flex_Structures.application_id%TYPE;
36: vg_id_flex_code Fnd_Id_Flex_Structures.id_flex_code%TYPE;
37: vg_delimiter Fnd_Id_Flex_Structures.concatenated_segment_delimiter%TYPE ;
38: vg_flex_value_id fnd_flex_values.flex_value_id%TYPE;

Line 60: vg_bfy_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;

56: vg_nsegs_high NUMBER ;
57:
58:
59: -- Variables used in the procedure Get_Bfy_Segment
60: vg_bfy_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;
61:
62: -- ------------------------------------------------------------------
63: -- Procedure Main
64: -- ------------------------------------------------------------------

Line 164: FROM fnd_id_flex_segments

160: IS
161: l_module_name VARCHAR2(200);
162: CURSOR flex_value_id_cur IS
163: SELECT flex_value_set_id
164: FROM fnd_id_flex_segments
165: WHERE application_id = 101
166: AND application_column_name =vg_acct_segment
167: AND id_flex_code = vg_id_flex_code
168: AND id_flex_num = vp_coa_id

Line 265: FROM Fnd_Id_Flex_Segments

261: vl_ctr NUMBER;
262:
263: CURSOR seg_names_cur IS
264: SELECT application_column_name
265: FROM Fnd_Id_Flex_Segments
266: WHERE application_id = vg_apps_id
267: AND id_flex_code = vg_id_flex_code
268: AND id_flex_num = vp_coa_id
269: ORDER BY segment_num;

Line 313: FROM Fnd_Id_Flex_Segments

309: IS
310: l_module_name VARCHAR2(200);
311: CURSOR seg_num_cur (p_application_column_name VARCHAR2) IS
312: SELECT segment_num
313: FROM Fnd_Id_Flex_Segments
314: WHERE application_id = vg_apps_id
315: AND id_flex_code = vg_id_flex_code
316: AND id_flex_num = vp_coa_id
317: AND application_column_name=p_application_column_name ;