APPS.FV_GTAS_INTERFACE dependencies on GL_PERIOD_STATUSES

Line 6: gbl_period_name gl_period_statuses.period_name%TYPE;

2: /* $Header: FVGTINTB.pls 120.30.12020000.1 2013/02/12 20:00:19 appldev noship $ */
3: ---------------------------------- ----------------------------------------------
4: g_module_name 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_run_reports VARCHAR2(1);

Line 11: gbl_fiscal_year gl_period_statuses.period_year%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_run_reports VARCHAR2(1);
11: gbl_fiscal_year gl_period_statuses.period_year%TYPE;
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);

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_run_reports VARCHAR2(1);
11: gbl_fiscal_year gl_period_statuses.period_year%TYPE;
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_run_reports VARCHAR2(1);
11: gbl_fiscal_year gl_period_statuses.period_year%TYPE;
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_currency_code gl_sets_of_books.currency_code%TYPE;

Line 151: gbl_period_year gl_period_statuses.period_year%TYPE;

147:
148: gbl_fund_range_low FV_Fund_Parameters.fund_value%TYPE;
149: gbl_fund_range_high FV_Fund_Parameters.fund_value%TYPE;
150: gbl_period_num Gl_Balances.period_num%TYPE;
151: gbl_period_year gl_period_statuses.period_year%TYPE;
152:
153: g_Treasury_Symbol_Low_id number(15);
154: g_Treasury_Symbol_high_id number(15);
155:

Line 173: FROM gl_period_statuses p

169: -- Get the period year for the period parameter passed.
170: l_temp_mesg := 'getting period year.';
171: SELECT period_year
172: INTO gbl_period_year
173: FROM gl_period_statuses p
174: WHERE p.application_id = 101
175: AND p.ledger_id = gbl_set_of_books_id
176: AND p.period_name = gbl_period_name;
177: -- Get the first period of the year

Line 181: FROM gl_period_statuses

177: -- Get the first period of the year
178: l_temp_mesg := 'getting first period number of the year.';
179: SELECT MIN(period_num)
180: INTO gbl_period_num_low
181: FROM gl_period_statuses
182: WHERE period_year = gbl_period_year
183: AND application_id = 101
184: AND closing_status <> 'F'
185: AND closing_status <> 'N'

Line 197: FROM gl_period_statuses p

193: WHEN to_char(end_date, 'MM')between 1 and 9 then (to_char(end_date, 'MM')+3)
194: WHEN to_char(end_date, 'MM')between 10 and 12 then (to_char(end_date, 'MM')-9)
195: END
196: INTO gbl_period_num_high, gbl_reporting_period
197: FROM gl_period_statuses p
198: WHERE period_name = gbl_period_name
199: AND p.application_id = 101
200: AND p.ledger_id = gbl_set_of_books_id
201: AND p.period_year = gbl_period_year;