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_FACTS1_GL_PKG dependencies on GL_PERIOD_STATUSES

Line 12: gbl_period_name gl_period_statuses.period_name%TYPE;

8: gbl_jrnl_attribute VARCHAR2(15);
9: gbl_vend_attribute VARCHAR2(15);
10: gbl_cust_attribute VARCHAR2(15);
11: gbl_currency_code gl_ledgers_public_v.currency_code%TYPE;
12: gbl_period_name gl_period_statuses.period_name%TYPE;
13: gbl_sob_id gl_ledgers_public_v.ledger_id%TYPE;
14: gbl_coa_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
15: gbl_err_code NUMBER := 0;
16: gbl_err_buff VARCHAR2(250);

Line 17: gbl_period_num_low gl_period_statuses.period_num%TYPE;

13: gbl_sob_id gl_ledgers_public_v.ledger_id%TYPE;
14: gbl_coa_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
15: gbl_err_code NUMBER := 0;
16: gbl_err_buff VARCHAR2(250);
17: gbl_period_num_low gl_period_statuses.period_num%TYPE;
18: gbl_period_num_high gl_period_statuses.period_num%TYPE;
19: gbl_period_year gl_period_statuses.period_year%TYPE;
20: gbl_exception_rec_count NUMBER;
21: gbl_called_from_main VARCHAR2(1);

Line 18: gbl_period_num_high gl_period_statuses.period_num%TYPE;

14: gbl_coa_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
15: gbl_err_code NUMBER := 0;
16: gbl_err_buff VARCHAR2(250);
17: gbl_period_num_low gl_period_statuses.period_num%TYPE;
18: gbl_period_num_high gl_period_statuses.period_num%TYPE;
19: gbl_period_year gl_period_statuses.period_year%TYPE;
20: gbl_exception_rec_count NUMBER;
21: gbl_called_from_main VARCHAR2(1);
22: gbl_header_id gl_je_headers.je_header_id%type := 0;

Line 19: gbl_period_year gl_period_statuses.period_year%TYPE;

15: gbl_err_code NUMBER := 0;
16: gbl_err_buff VARCHAR2(250);
17: gbl_period_num_low gl_period_statuses.period_num%TYPE;
18: gbl_period_num_high gl_period_statuses.period_num%TYPE;
19: gbl_period_year gl_period_statuses.period_year%TYPE;
20: gbl_exception_rec_count NUMBER;
21: gbl_called_from_main VARCHAR2(1);
22: gbl_header_id gl_je_headers.je_header_id%type := 0;
23: gbl_trading_partner_att fv_be_trx_dtls.attribute1%TYPE;

Line 118: FROM gl_period_statuses

114: END IF;
115:
116: SELECT period_year
117: INTO l_period_year
118: FROM gl_period_statuses
119: WHERE application_id = 101
120: AND ledger_id = p_sob_id
121: AND period_name = p_period_name;
122:

Line 303: FROM gl_period_statuses p

299: -- Get the period year for the period parameter passed.
300: l_temp_mesg := 'getting period year.';
301: SELECT period_year
302: INTO gbl_period_year
303: FROM gl_period_statuses p
304: WHERE p.application_id = 101
305: AND p.ledger_id = gbl_sob_id
306: AND p.period_name = gbl_period_name;
307:

Line 312: FROM gl_period_statuses

308: -- Get the first period of the year
309: l_temp_mesg := 'getting first period number of the year.';
310: SELECT MIN(period_num)
311: INTO gbl_period_num_low
312: FROM gl_period_statuses
313: WHERE period_year = gbl_period_year
314: AND application_id = 101
315: AND closing_status <> 'F'
316: AND closing_status <> 'N'

Line 324: FROM gl_period_statuses p

320: -- Get the period num for the parameter period
321: l_temp_mesg := 'getting period number of the parameter period.';
322: SELECT period_num
323: INTO gbl_period_num_high
324: FROM gl_period_statuses p
325: WHERE period_name = gbl_period_name
326: AND p.application_id = 101
327: AND p.ledger_id = gbl_sob_id
328: AND p.period_year = gbl_period_year;

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

459: TYPE fed_nonfed_t IS TABLE OF fv_facts1_fed_accounts.fed_non_fed%TYPE;
460: TYPE g_ng_indicator_t IS TABLE OF fv_facts1_line_balances.g_ng_indicator%TYPE;
461: TYPE record_category_t IS TABLE OF fv_facts1_line_balances.record_category%TYPE;
462: TYPE varchar_1_t IS TABLE OF VARCHAR2(1);
463: TYPE period_num_t IS TABLE OF gl_period_statuses.period_num%TYPE;
464: TYPE je_from_sla_flag_t IS TABLE OF VARCHAR2(1);
465: TYPE je_batch_id_t IS TABLE OF gl_je_headers.je_batch_id%TYPE;
466:
467: je_header_id_list_new je_header_id_t;

Line 545: FROM gl_period_statuses

541: INSERT INTO fv_facts1_header_id_gt(je_header_id,set_of_books_id)
542: select gjh.je_header_id , gjh.ledger_id
543: from
544: (SELECT period_num, period_name
545: FROM gl_period_statuses
546: WHERE application_id = 101
547: AND ledger_id = gbl_sob_id
548: AND period_num BETWEEN gbl_period_num_low AND gbl_period_num_high
549: AND period_year = gbl_period_year) gps,

Line 606: FROM gl_period_statuses

602: ' FROM
603: fv_facts1_fed_accounts fff,
604: gl_code_combinations glcc,
605: ( SELECT period_num, period_name
606: FROM gl_period_statuses
607: WHERE application_id = 101
608: AND ledger_id = :gbl_sob_id
609: AND period_num BETWEEN :gbl_period_num_low AND :gbl_period_num_high
610: AND period_year = :gbl_period_year ) gps,

Line 647: FROM gl_period_statuses ps

643: , gl_je_headers gjh
644: , gl_je_lines gjl
645: , (SELECT period_num
646: , period_name
647: FROM gl_period_statuses ps
648: WHERE application_id = 101
649: AND ledger_id = :gbl_sob_id
650: AND period_num BETWEEN :gbl_period_num_low AND :gbl_period_num_high
651: AND period_year = :gbl_period_year) gps