APPS.FV_YE_CLOSE dependencies on FND_ID_FLEX_SEGMENTS

Line 40: vg_bal_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;

36: vg_closing_period Gl_Period_Statuses.period_name%TYPE;
37: vg_coy_fyr Gl_Periods.period_year%TYPE;
38: vg_coy_start_date Gl_Periods.start_date%TYPE;
39: vg_coy_period Gl_Period_Statuses.period_name%TYPE;
40: vg_bal_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;
41: vg_acct_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;
42: vg_acct_segnum NUMBER(4);
43: vg_bal_seg_val_opt_code gl_ledgers_public_v.bal_seg_value_option_code%TYPE;
44: vg_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;

Line 41: vg_acct_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;

37: vg_coy_fyr Gl_Periods.period_year%TYPE;
38: vg_coy_start_date Gl_Periods.start_date%TYPE;
39: vg_coy_period Gl_Period_Statuses.period_name%TYPE;
40: vg_bal_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;
41: vg_acct_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;
42: vg_acct_segnum NUMBER(4);
43: vg_bal_seg_val_opt_code gl_ledgers_public_v.bal_seg_value_option_code%TYPE;
44: vg_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
45: vg_trsymbol_id Fv_Treasury_Symbols.treasury_symbol_id%TYPE;

Line 591: FROM fnd_id_flex_segments

587: vl_errcode BOOLEAN;
588: l_module_name VARCHAR2(200) ;
589: CURSOR flex_fields IS
590: SELECT application_column_name
591: FROM fnd_id_flex_segments
592: WHERE id_flex_code = 'GL#'
593: AND id_flex_num = vg_coa_id
594: ORDER BY segment_num;
595:

Line 598: l_column_name fnd_id_flex_segments.application_column_name%TYPE;

594: ORDER BY segment_num;
595:
596: l_n_segments NUMBER(4) := 0;
597: vl_acct_segnum number(4);
598: l_column_name fnd_id_flex_segments.application_column_name%TYPE;
599: BEGIN
600:
601: l_module_name := g_module_name ||
602: 'Get_Balance_Account_Segments ';

Line 651: FROM Fnd_Id_Flex_Segments

647: -- Get the Account Flex Value set ID
648: BEGIN
649: SELECT flex_value_set_id
650: INTO vg_acct_val_set_id
651: FROM Fnd_Id_Flex_Segments
652: WHERE application_column_name = vg_acct_segment
653: AND application_id = 101
654: AND id_flex_code = 'GL#'
655: AND id_flex_num = vg_coa_id

Line 674: FROM Fnd_Id_Flex_Segments

670: -- Get the Number of segments in the chart of accounts
671: BEGIN
672: SELECT COUNT(*)
673: INTO vg_num_segs
674: FROM Fnd_Id_Flex_Segments
675: WHERE application_id = 101
676: AND id_flex_code = 'GL#'
677: AND id_flex_num = vg_coa_id
678: AND enabled_flag = 'Y';

Line 2245: FROM fnd_id_flex_segments fifs

2241: (
2242: c_coa_id NUMBER
2243: ) IS
2244: SELECT fifs.application_column_name
2245: FROM fnd_id_flex_segments fifs
2246: WHERE fifs.application_id = 101
2247: AND fifs.id_flex_code = 'GL#'
2248: AND fifs.id_flex_num = c_coa_id
2249: AND fifs.enabled_flag = 'Y'

Line 2645: FROM fnd_id_flex_segments

2641: segs Fnd_Flex_Ext.SegmentArray) IS
2642:
2643: CURSOR flex_fields IS
2644: SELECT application_column_name
2645: FROM fnd_id_flex_segments
2646: WHERE id_flex_code = 'GL#'
2647: AND id_flex_num = vg_coa_id
2648: AND enabled_flag = 'Y'
2649: ORDER BY segment_num;

Line 2657: l_column_name fnd_id_flex_segments.application_column_name%TYPE;

2653: vl_period_cr NUMBER;
2654: l_module_name VARCHAR2(200) ;
2655: vl_segments Fnd_Flex_Ext.SegmentArray;
2656: vl_segnum NUMBER;
2657: l_column_name fnd_id_flex_segments.application_column_name%TYPE;
2658: l_n_segments NUMBER ;
2659:
2660: BEGIN
2661: l_module_name := g_module_name || 'Insert_Balances ';