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

Line 6: gbl_period_name gl_period_statuses.period_name%TYPE;

2: /* $Header: FVFCFIPB.pls 120.14 2011/05/13 06:26:52 yanasing ship $ */
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_type 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_type VARCHAR2(1);
11: gbl_fiscal_year gl_period_statuses.period_year%TYPE;
12: gbl_upd_begin_bal VARCHAR2(1);
13: gbl_period_num_low gl_period_statuses.period_num%TYPE;
14: gbl_period_num_high gl_period_statuses.period_num%TYPE;
15: gbl_bal_segment_name VARCHAR2(10);

Line 13: gbl_period_num_low gl_period_statuses.period_num%TYPE;

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

Line 14: gbl_period_num_high gl_period_statuses.period_num%TYPE;

10: gbl_run_type VARCHAR2(1);
11: gbl_fiscal_year gl_period_statuses.period_year%TYPE;
12: gbl_upd_begin_bal VARCHAR2(1);
13: gbl_period_num_low gl_period_statuses.period_num%TYPE;
14: gbl_period_num_high gl_period_statuses.period_num%TYPE;
15: gbl_bal_segment_name VARCHAR2(10);
16: gbl_acc_segment_name VARCHAR2(10);
17: gbl_acc_value_set_id NUMBER;
18: gbl_update_end_balance VARCHAR2(1);

Line 20: gbl_low_period_name gl_period_statuses.period_name%TYPE;

16: gbl_acc_segment_name VARCHAR2(10);
17: gbl_acc_value_set_id NUMBER;
18: gbl_update_end_balance VARCHAR2(1);
19: gbl_currency_code gl_sets_of_books.currency_code%TYPE;
20: gbl_low_period_name gl_period_statuses.period_name%TYPE;
21: gbl_prev_acct fv_facts_report_t2.account_number%TYPE;
22: gbl_bal_segment fv_facts_report_t2.fund_value%TYPE;
23: gbl_sgl_acct_num VARCHAR2(4);
24: gbl_govt_non_govt_ind fv_facts1_period_attributes.g_ng_indicator%TYPE;

Line 114: gbl_period_year gl_period_statuses.period_year%TYPE;

110: gbl_treasury_symbol_id FV_Treasury_Symbols.treasury_symbol_id%TYPE;
111: gbl_fund_range_low FV_Fund_Parameters.fund_value%TYPE;
112: gbl_fund_range_high FV_Fund_Parameters.fund_value%TYPE;
113: gbl_period_num Gl_Balances.period_num%TYPE;
114: gbl_period_year gl_period_statuses.period_year%TYPE;
115:
116: -- Global Variable for RXi
117: gbl_report_id FA_RX_Reports_V.report_id%TYPE;
118: gbl_attribute_set FA_RX_Rep_Columns_B.attribute_set%TYPE;

Line 535: FROM gl_period_statuses

531:
532: l_temp_mesg := ' getting first period of the year. ';
533: SELECT MIN(period_num)
534: INTO gbl_period_num_low
535: FROM gl_period_statuses
536: WHERE period_year = gbl_fiscal_year
537: AND application_id = 101
538: AND closing_status <> 'F'
539: AND closing_status <> 'N'

Line 550: FROM gl_period_statuses

546:
547: l_temp_mesg := ' getting last period of the year. ';
548: SELECT MAX(period_num)
549: INTO gbl_period_num_high
550: FROM gl_period_statuses
551: WHERE period_year = gbl_fiscal_year
552: AND application_id = 101
553: AND closing_status <> 'F'
554: AND closing_status <> 'N'

Line 564: FROM gl_period_statuses

560:
561: l_temp_mesg := ' getting period name for last period of the year. ';
562: SELECT period_name
563: INTO gbl_period_name
564: FROM gl_period_statuses
565: WHERE period_num = gbl_period_num_high
566: AND period_year = gbl_fiscal_year
567: AND application_id = 101
568: AND ledger_id = gbl_set_of_books_id;

Line 577: FROM gl_period_statuses

573: -- the period number.
574: l_temp_mesg := ' getting period num/fiscal year for the period passed. ';
575: SELECT period_num, period_year, closing_status
576: INTO gbl_period_num_high, gbl_fiscal_year, l_closing_status
577: FROM gl_period_statuses
578: WHERE period_name = gbl_period_name
579: AND application_id = 101
580: AND ledger_id = gbl_set_of_books_id;
581:

Line 591: FROM gl_period_statuses

587: IF l_closing_status IN ('F' , 'N') THEN
588: l_temp_mesg := ' getting lower period number for the period passed. ';
589: SELECT Max(period_num)
590: INTO gbl_period_num_high
591: FROM gl_period_statuses
592: WHERE period_year = gbl_fiscal_year
593: AND application_id = 101
594: AND closing_status <> 'F'
595: AND closing_status <> 'N'

Line 603: FROM gl_period_statuses

599:
600: l_temp_mesg := ' getting first period of the year. ';
601: SELECT MIN(period_num)
602: INTO gbl_period_num_low
603: FROM gl_period_statuses
604: WHERE period_year = gbl_fiscal_year
605: AND application_id = 101
606: AND adjustment_period_flag = 'N'
607: AND ledger_id = gbl_set_of_books_id;

Line 616: FROM gl_period_statuses

612:
613: l_temp_mesg := ' getting last period of the year. ';
614: SELECT MAX(period_num)
615: INTO l_end_period_num
616: FROM gl_period_statuses
617: WHERE period_year = gbl_fiscal_year
618: AND application_id = 101
619: AND ledger_id = gbl_set_of_books_id;
620:

Line 644: FROM gl_period_statuses

640:
641: l_temp_mesg := ' getting period name of first period of the year. ';
642: SELECT period_name
643: INTO gbl_low_period_name
644: FROM gl_period_statuses
645: WHERE period_num = gbl_period_num_low
646: AND period_year = gbl_fiscal_year
647: AND application_id = 101
648: AND ledger_id = gbl_set_of_books_id;

Line 1897: FROM gl_period_statuses

1893: --Getting the period number
1894: BEGIN
1895: SELECT period_num, period_year
1896: INTO gbl_period_num_high, gbl_fiscal_year
1897: FROM gl_period_statuses
1898: WHERE period_name = p_period_name
1899: AND application_id = 101
1900: AND closing_status NOT IN ('F','N')
1901: AND ledger_id = gbl_set_of_books_id;

Line 1908: FROM gl_period_statuses

1904: gbl_period_year := gbl_fiscal_year;
1905:
1906: SELECT MIN(period_num)
1907: INTO gbl_period_num_low
1908: FROM gl_period_statuses
1909: WHERE period_year = gbl_fiscal_year
1910: AND application_id = 101
1911: AND closing_status <> 'F'
1912: AND closing_status <> 'N'

Line 2328: FROM gl_period_statuses

2324: /*
2325: IF gbl_trial_balance_type = 'F' then
2326: SELECT MAX(period_num)
2327: INTO l_period_num_high
2328: FROM gl_period_statuses
2329: WHERE period_year = p_period_year
2330: AND application_id = 101
2331: AND closing_status <> 'F'
2332: AND closing_status <> 'N'

Line 2337: FROM gl_period_statuses

2333: AND ledger_id = gbl_set_of_books_id;
2334:
2335: SELECT MIN(period_num)
2336: INTO l_period_num_low
2337: FROM gl_period_statuses
2338: WHERE period_year = p_period_year
2339: AND application_id = 101
2340: AND closing_status <> 'F'
2341: AND closing_status <> 'N'

Line 2347: FROM gl_period_statuses

2343: AND ledger_id = gbl_set_of_books_id;
2344:
2345: SELECT period_name
2346: INTO gbl_period_name
2347: FROM gl_period_statuses
2348: WHERE period_year = p_period_year
2349: AND application_id = 101
2350: AND period_num = l_period_num_high
2351: AND ledger_id = gbl_set_of_books_id;

Line 3119: FROM gl_period_statuses g2

3115: into l_je_header_id
3116: from gl_je_headers h
3117: WHERE ledger_id = gbl_set_of_books_id
3118: and exists (select'x'
3119: FROM gl_period_statuses g2
3120: WHERE g2.period_year = p_period_year
3121: AND g2.ledger_id = p_set_of_books_id
3122: AND g2.application_id = 101
3123: and g2.period_name = h.period_name);

Line 3413: from gl_period_statuses

3409:
3410: if l_no_new_accounts > 0 then
3411:
3412: select period_name into gbl_period_name
3413: from gl_period_statuses
3414: where ledger_id = gbl_set_of_books_id
3415: AND period_year = gbl_fiscal_year
3416: and application_id = 101
3417: and period_num = l_period_num;