APPS.FV_YE_CLOSE dependencies on GL_PERIODS

Line 26: vp_closing_fyr Gl_Periods.period_year%TYPE ;

22: vp_mode VARCHAR2(1) ;
23: vp_timeframe Fv_Treasury_Symbols.time_frame%TYPE ;
24: vp_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;
25: vp_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
26: vp_closing_fyr Gl_Periods.period_year%TYPE ;
27: --year end process
28: vp_closing_num Gl_Periods.period_num%TYPE ;
29:
30: -- ======================================================================

Line 28: vp_closing_num Gl_Periods.period_num%TYPE ;

24: vp_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;
25: vp_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
26: vp_closing_fyr Gl_Periods.period_year%TYPE ;
27: --year end process
28: vp_closing_num Gl_Periods.period_num%TYPE ;
29:
30: -- ======================================================================
31: -- Other Global Variable Declarations
32: -- ======================================================================

Line 37: vg_start_date Gl_Periods.start_date%TYPE;

33:
34: vg_sob_id Gl_Sets_Of_Books.set_of_books_id%TYPE;
35: vg_coa_id Gl_Sets_Of_Books.chart_of_accounts_id%TYPE;
36: vg_currency Gl_Sets_Of_Books.currency_code%TYPE;
37: vg_start_date Gl_Periods.start_date%TYPE;
38: vg_end_date Gl_Periods.end_date%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;

Line 38: vg_end_date Gl_Periods.end_date%TYPE;

34: vg_sob_id Gl_Sets_Of_Books.set_of_books_id%TYPE;
35: vg_coa_id Gl_Sets_Of_Books.chart_of_accounts_id%TYPE;
36: vg_currency Gl_Sets_Of_Books.currency_code%TYPE;
37: vg_start_date Gl_Periods.start_date%TYPE;
38: vg_end_date Gl_Periods.end_date%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;

Line 40: vg_coy_fyr Gl_Periods.period_year%TYPE;

36: vg_currency Gl_Sets_Of_Books.currency_code%TYPE;
37: vg_start_date Gl_Periods.start_date%TYPE;
38: vg_end_date Gl_Periods.end_date%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;

Line 41: vg_coy_start_date Gl_Periods.start_date%TYPE;

37: vg_start_date Gl_Periods.start_date%TYPE;
38: vg_end_date Gl_Periods.end_date%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);

Line 459: FROM gl_periods glp, gl_sets_of_books gsob

455: -- Get the Start Date and the End Date of the Closing fiscal year for the chosen closing period
456: BEGIN
457: SELECT MIN(start_date), MAX(end_date)
458: INTO vg_start_date, vg_end_date
459: FROM gl_periods glp, gl_sets_of_books gsob
460: WHERE glp.period_year = vp_closing_fyr
461: AND glp.period_set_name = gsob.period_set_name
462: AND gsob.chart_of_accounts_id = vg_coa_id
463: AND gsob.set_of_books_id = vg_sob_id