APPS.FV_YE_CLOSE dependencies on FND_ID_FLEX_SEGMENTS

Line 43: vg_bal_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;

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

Line 44: vg_acct_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;

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

Line 584: FROM fnd_id_flex_segments

580: vl_errcode BOOLEAN;
581: l_module_name VARCHAR2(200) ;
582: CURSOR flex_fields IS
583: SELECT application_column_name
584: FROM fnd_id_flex_segments
585: WHERE id_flex_code = 'GL#'
586: AND id_flex_num = vg_coa_id
587: ORDER BY segment_num;
588:

Line 591: l_column_name fnd_id_flex_segments.application_column_name%TYPE;

587: ORDER BY segment_num;
588:
589: l_n_segments NUMBER(4) := 0;
590: vl_acct_segnum number(4);
591: l_column_name fnd_id_flex_segments.application_column_name%TYPE;
592: BEGIN
593:
594: l_module_name := g_module_name ||
595: 'Get_Balance_Account_Segments ';

Line 644: FROM Fnd_Id_Flex_Segments

640: -- Get the Account Flex Value set ID
641: BEGIN
642: SELECT flex_value_set_id
643: INTO vg_acct_val_set_id
644: FROM Fnd_Id_Flex_Segments
645: WHERE application_column_name = vg_acct_segment
646: AND application_id = 101
647: AND id_flex_code = 'GL#'
648: AND id_flex_num = vg_coa_id

Line 667: FROM Fnd_Id_Flex_Segments

663: -- Get the Number of segments in the chart of accounts
664: BEGIN
665: SELECT COUNT(*)
666: INTO vg_num_segs
667: FROM Fnd_Id_Flex_Segments
668: WHERE application_id = 101
669: AND id_flex_code = 'GL#'
670: AND id_flex_num = vg_coa_id
671: AND enabled_flag = 'Y';

Line 2294: FROM fnd_id_flex_segments fifs

2290: (
2291: c_coa_id NUMBER
2292: ) IS
2293: SELECT fifs.application_column_name
2294: FROM fnd_id_flex_segments fifs
2295: WHERE fifs.application_id = 101
2296: AND fifs.id_flex_code = 'GL#'
2297: AND fifs.id_flex_num = c_coa_id
2298: AND fifs.enabled_flag = 'Y'

Line 2694: FROM fnd_id_flex_segments

2690: segs Fnd_Flex_Ext.SegmentArray) IS
2691:
2692: CURSOR flex_fields IS
2693: SELECT application_column_name
2694: FROM fnd_id_flex_segments
2695: WHERE id_flex_code = 'GL#'
2696: AND id_flex_num = vg_coa_id
2697: AND enabled_flag = 'Y'
2698: ORDER BY segment_num;

Line 2706: l_column_name fnd_id_flex_segments.application_column_name%TYPE;

2702: vl_period_cr NUMBER;
2703: l_module_name VARCHAR2(200) ;
2704: vl_segments Fnd_Flex_Ext.SegmentArray;
2705: vl_segnum NUMBER;
2706: l_column_name fnd_id_flex_segments.application_column_name%TYPE;
2707: l_n_segments NUMBER ;
2708:
2709: BEGIN
2710: l_module_name := g_module_name || 'Insert_Balances ';