APPS.FV_YE_CARRYFORWARD dependencies on GL_PERIOD_STATUSES

Line 28: vg_closing_period Gl_Period_Statuses.period_name%TYPE;

24: vg_coa_id Gl_Sets_Of_Books.chart_of_accounts_id%TYPE;
25: vg_bal_seg_value varchar2(30);
26: vg_period_set_name Gl_Sets_Of_Books.period_set_name%TYPE;
27: vg_currency Gl_Sets_Of_Books.currency_code%TYPE;
28: vg_closing_period Gl_Period_Statuses.period_name%TYPE;
29: vg_carryfor_period Gl_Period_Statuses.period_name%TYPE;
30: vg_start_date Gl_Period_Statuses.start_date%TYPE;
31: vg_closing_fyr Gl_Periods.period_year%TYPE;
32: vg_jrnl_group_id NUMBER;

Line 29: vg_carryfor_period Gl_Period_Statuses.period_name%TYPE;

25: vg_bal_seg_value varchar2(30);
26: vg_period_set_name Gl_Sets_Of_Books.period_set_name%TYPE;
27: vg_currency Gl_Sets_Of_Books.currency_code%TYPE;
28: vg_closing_period Gl_Period_Statuses.period_name%TYPE;
29: vg_carryfor_period Gl_Period_Statuses.period_name%TYPE;
30: vg_start_date Gl_Period_Statuses.start_date%TYPE;
31: vg_closing_fyr Gl_Periods.period_year%TYPE;
32: vg_jrnl_group_id NUMBER;
33: vg_interface_run_id NUMBER;

Line 30: vg_start_date Gl_Period_Statuses.start_date%TYPE;

26: vg_period_set_name Gl_Sets_Of_Books.period_set_name%TYPE;
27: vg_currency Gl_Sets_Of_Books.currency_code%TYPE;
28: vg_closing_period Gl_Period_Statuses.period_name%TYPE;
29: vg_carryfor_period Gl_Period_Statuses.period_name%TYPE;
30: vg_start_date Gl_Period_Statuses.start_date%TYPE;
31: vg_closing_fyr Gl_Periods.period_year%TYPE;
32: vg_jrnl_group_id NUMBER;
33: vg_interface_run_id NUMBER;
34: vg_bal_seg_val_opt_code VARCHAR2(1);

Line 88: FROM gl_period_statuses

84: END IF;
85:
86: SELECT count(*)
87: INTO l_bc_count
88: FROM gl_period_statuses
89: WHERE application_id = 101
90: AND ledger_id = vp_sob_id
91: AND period_year = vp_carryfor_fyr
92: AND NVL(track_bc_ytd_flag, 'N') = 'Y';

Line 246: vl_adj_flag Gl_Period_Statuses.adjustment_period_flag%TYPE;

242: -- of the carry forward fyr.
243: -- ------------------------------------------------------------------
244: PROCEDURE Get_Period_Details IS
245: l_module_name VARCHAR2(200) ;
246: vl_adj_flag Gl_Period_Statuses.adjustment_period_flag%TYPE;
247: vl_closing_status Gl_Period_Statuses.closing_status%TYPE;
248: BEGIN
249: l_module_name := g_module_name ||
250: 'Get_Period_Details ';

Line 247: vl_closing_status Gl_Period_Statuses.closing_status%TYPE;

243: -- ------------------------------------------------------------------
244: PROCEDURE Get_Period_Details IS
245: l_module_name VARCHAR2(200) ;
246: vl_adj_flag Gl_Period_Statuses.adjustment_period_flag%TYPE;
247: vl_closing_status Gl_Period_Statuses.closing_status%TYPE;
248: BEGIN
249: l_module_name := g_module_name ||
250: 'Get_Period_Details ';
251: -- Get the Closing Fyr

Line 260: FROM Gl_Period_Statuses

256: -- Get the Last Period of the Closing Fyr
257: BEGIN
258: SELECT period_name
259: INTO vg_closing_period
260: FROM Gl_Period_Statuses
261: WHERE ledger_id = vp_sob_id
262: AND application_id = 101
263: AND period_year = vg_closing_fyr
264: AND period_num = (SELECT MAX(period_num)

Line 265: FROM gl_period_statuses

261: WHERE ledger_id = vp_sob_id
262: AND application_id = 101
263: AND period_year = vg_closing_fyr
264: AND period_num = (SELECT MAX(period_num)
265: FROM gl_period_statuses
266: WHERE ledger_id = vp_sob_id
267: AND application_id = 101
268: AND period_year = vg_closing_fyr);
269: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 291: FROM Gl_Period_Statuses

287: SELECT period_name, adjustment_period_flag,
288: closing_status,start_date
289: INTO vg_carryfor_period,vl_adj_flag,
290: vl_closing_status, vg_start_date
291: FROM Gl_Period_Statuses
292: WHERE ledger_id = vp_sob_id
293: AND application_id = 101
294: AND period_year = vp_carryfor_fyr
295: AND period_num = (SELECT MIN(period_num)

Line 296: FROM gl_period_statuses

292: WHERE ledger_id = vp_sob_id
293: AND application_id = 101
294: AND period_year = vp_carryfor_fyr
295: AND period_num = (SELECT MIN(period_num)
296: FROM gl_period_statuses
297: WHERE ledger_id = vp_sob_id
298: AND application_id = 101
299: AND period_year = vp_carryfor_fyr);
300: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN