eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_GTAS_GL_PKG dependencies on GL_PERIOD_STATUSES

Line 4: gbl_period_name gl_period_statuses.period_name%TYPE;

1: PACKAGE BODY FV_GTAS_GL_PKG AS
2: /* $Header: FVGTJCRB.pls 120.0.12020000.23 2013/03/08 19:50:44 snama noship $ */
3: g_module_name VARCHAR2(100);
4: gbl_period_name gl_period_statuses.period_name%TYPE;
5: gbl_period_year gl_period_statuses.period_year%TYPE;
6: gbl_period_num_low gl_period_statuses.period_num%TYPE;
7: gbl_period_num_high gl_period_statuses.period_num%TYPE;
8: gbl_sob_id gl_ledgers_public_v.ledger_id%TYPE;

Line 5: gbl_period_year gl_period_statuses.period_year%TYPE;

1: PACKAGE BODY FV_GTAS_GL_PKG AS
2: /* $Header: FVGTJCRB.pls 120.0.12020000.23 2013/03/08 19:50:44 snama noship $ */
3: g_module_name VARCHAR2(100);
4: gbl_period_name gl_period_statuses.period_name%TYPE;
5: gbl_period_year gl_period_statuses.period_year%TYPE;
6: gbl_period_num_low gl_period_statuses.period_num%TYPE;
7: gbl_period_num_high gl_period_statuses.period_num%TYPE;
8: gbl_sob_id gl_ledgers_public_v.ledger_id%TYPE;
9: gbl_coa_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;

Line 6: gbl_period_num_low gl_period_statuses.period_num%TYPE;

2: /* $Header: FVGTJCRB.pls 120.0.12020000.23 2013/03/08 19:50:44 snama noship $ */
3: g_module_name VARCHAR2(100);
4: gbl_period_name gl_period_statuses.period_name%TYPE;
5: gbl_period_year gl_period_statuses.period_year%TYPE;
6: gbl_period_num_low gl_period_statuses.period_num%TYPE;
7: gbl_period_num_high gl_period_statuses.period_num%TYPE;
8: gbl_sob_id gl_ledgers_public_v.ledger_id%TYPE;
9: gbl_coa_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
10: gbl_bal_segment VARCHAR2(10);

Line 7: gbl_period_num_high gl_period_statuses.period_num%TYPE;

3: g_module_name VARCHAR2(100);
4: gbl_period_name gl_period_statuses.period_name%TYPE;
5: gbl_period_year gl_period_statuses.period_year%TYPE;
6: gbl_period_num_low gl_period_statuses.period_num%TYPE;
7: gbl_period_num_high gl_period_statuses.period_num%TYPE;
8: gbl_sob_id gl_ledgers_public_v.ledger_id%TYPE;
9: gbl_coa_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
10: gbl_bal_segment VARCHAR2(10);
11: gbl_acc_segment VARCHAR2(10);

Line 252: FROM gl_period_statuses p

248: -- Get the period year for the period parameter passed.
249: l_temp_mesg := 'getting period year.';
250: SELECT period_year
251: INTO gbl_period_year
252: FROM gl_period_statuses p
253: WHERE p.application_id = 101
254: AND p.ledger_id = gbl_sob_id
255: AND p.period_name = gbl_period_name;
256: -- Get the first period of the year

Line 260: FROM gl_period_statuses

256: -- Get the first period of the year
257: l_temp_mesg := 'getting first period number of the year.';
258: SELECT MIN(period_num)
259: INTO gbl_period_num_low
260: FROM gl_period_statuses
261: WHERE period_year = gbl_period_year
262: AND application_id = 101
263: AND closing_status <> 'F'
264: AND closing_status <> 'N'

Line 271: FROM gl_period_statuses p

267: -- Get the period num for the parameter to period
268: l_temp_mesg := 'getting period number of the parameter to period.';
269: SELECT period_num
270: INTO gbl_period_num_high
271: FROM gl_period_statuses p
272: WHERE period_name = gbl_period_name
273: AND p.application_id = 101
274: AND p.ledger_id = gbl_sob_id
275: AND p.period_year = gbl_period_year;

Line 415: TYPE period_num_t IS TABLE OF gl_period_statuses.period_num%TYPE;

411: TYPE agency_id_t IS TABLE OF VARCHAR2(3);
412: TYPE fed_nonfed_code_t IS TABLE OF fv_gtas_attributes.fed_non_fed1%TYPE;
413: TYPE varchar_1_t IS TABLE OF VARCHAR2(1);
414: TYPE record_category_t IS TABLE OF fv_gtas_activity_balances.record_category%TYPE;
415: TYPE period_num_t IS TABLE OF gl_period_statuses.period_num%TYPE;
416: TYPE je_from_sla_flag_t IS TABLE OF VARCHAR2(1);
417: TYPE je_batch_id_t IS TABLE OF gl_je_headers.je_batch_id%TYPE;
418: TYPE authority_type_flag_t IS TABLE OF VARCHAR2(1);
419: TYPE fed_nonfed_flag_list_t IS TABLE OF VARCHAR2(1);

Line 505: FROM gl_period_statuses

501: (je_header_id,set_of_books_id)
502: SELECT gjh.je_header_id, gjh.ledger_id
503: FROM
504: (SELECT period_num,period_name
505: FROM gl_period_statuses
506: WHERE application_id = 101
507: AND ledger_id = gbl_sob_id
508: AND period_num BETWEEN gbl_period_num_low AND gbl_period_num_high
509: AND period_year = gbl_period_year

Line 582: FROM gl_period_statuses ps

578: ' FROM fv_gtas_header_id_gt ftt,
579: gl_je_headers gjh,
580: gl_je_lines gjl,
581: (SELECT period_num, period_name
582: FROM gl_period_statuses ps
583: WHERE application_id = 101
584: AND ledger_id = :gbl_sob_id
585: AND period_num BETWEEN :gbl_period_num_low AND :gbl_period_num_high
586: AND period_year = :gbl_period_year) gps,

Line 2845: FROM gl_period_statuses

2841: FROM gl_je_headers
2842: WHERE ledger_id = gbl_sob_id
2843: AND period_name IN
2844: (SELECT period_name
2845: FROM gl_period_statuses
2846: WHERE ledger_id = gbl_sob_id
2847: AND period_year = gbl_period_year));
2848: log(l_module_name, 'Deleted : '||sql%rowcount||' row/s.');
2849: EXCEPTION WHEN NO_DATA_FOUND THEN