APPS.FV_GTAS_TBAL_TRX_PKG dependencies on GL_PERIOD_STATUSES

Line 6: gbl_period_name gl_period_statuses.period_name%TYPE;

2: /* $Header: FVGTATBB.pls 120.1.12020000.10 2013/02/21 21:18:49 snama noship $ */
3:
4: g_module VARCHAR2(200);
5: gbl_set_of_books_id gl_ledgers_public_v.ledger_id%TYPE;
6: gbl_period_name gl_period_statuses.period_name%TYPE;
7: gbl_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE;
8: gbl_error_code NUMBER;
9: gbl_error_buf VARCHAR2(300);
10: gbl_fiscal_year gl_period_statuses.period_year%TYPE;

Line 10: gbl_fiscal_year gl_period_statuses.period_year%TYPE;

6: gbl_period_name gl_period_statuses.period_name%TYPE;
7: gbl_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE;
8: gbl_error_code NUMBER;
9: gbl_error_buf VARCHAR2(300);
10: gbl_fiscal_year gl_period_statuses.period_year%TYPE;
11:
12: gbl_period_num_low gl_period_statuses.period_num%TYPE;
13: gbl_period_num_high gl_period_statuses.period_num%TYPE;
14: gbl_bal_segment_name VARCHAR2(10);

Line 12: gbl_period_num_low gl_period_statuses.period_num%TYPE;

8: gbl_error_code NUMBER;
9: gbl_error_buf VARCHAR2(300);
10: gbl_fiscal_year gl_period_statuses.period_year%TYPE;
11:
12: gbl_period_num_low gl_period_statuses.period_num%TYPE;
13: gbl_period_num_high gl_period_statuses.period_num%TYPE;
14: gbl_bal_segment_name VARCHAR2(10);
15: gbl_acc_segment_name VARCHAR2(10);
16: gbl_acc_value_set_id NUMBER;

Line 13: gbl_period_num_high gl_period_statuses.period_num%TYPE;

9: gbl_error_buf VARCHAR2(300);
10: gbl_fiscal_year gl_period_statuses.period_year%TYPE;
11:
12: gbl_period_num_low gl_period_statuses.period_num%TYPE;
13: gbl_period_num_high gl_period_statuses.period_num%TYPE;
14: gbl_bal_segment_name VARCHAR2(10);
15: gbl_acc_segment_name VARCHAR2(10);
16: gbl_acc_value_set_id NUMBER;
17: gbl_aid_clause varchar2(100);

Line 35: gbl_period_year gl_period_statuses.period_year%TYPE;

31: PROCEDURE rollup_process;
32:
33: -- Global Variables for Trial Balance processing
34: gbl_period_num Gl_Balances.period_num%TYPE;
35: gbl_period_year gl_period_statuses.period_year%TYPE;
36: --------------------------------------------------------------------------------
37: -- Get balancing and accounting segments
38: --------------------------------------------------------------------------------
39: PROCEDURE GET_SEGMENT_NAMES

Line 207: FROM gl_period_statuses

203: --Getting the period number
204: BEGIN
205: SELECT period_num, period_year
206: INTO gbl_period_num_high, gbl_fiscal_year
207: FROM gl_period_statuses
208: WHERE period_name = p_period
209: AND application_id = 101
210: AND closing_status NOT IN ('F','N')
211: AND ledger_id = gbl_set_of_books_id;

Line 218: FROM gl_period_statuses

214: gbl_period_year := gbl_fiscal_year;
215:
216: SELECT MIN(period_num)
217: INTO gbl_period_num_low
218: FROM gl_period_statuses
219: WHERE period_year = gbl_fiscal_year
220: AND application_id = 101
221: AND closing_status <> 'F'
222: AND closing_status <> 'N'