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.2.12000000.5 2007/07/31 14:21:45 sasukuma 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 1855: FROM gl_period_statuses

1851: --Getting the period number
1852: BEGIN
1853: SELECT period_num, period_year
1854: INTO gbl_period_num_high, gbl_fiscal_year
1855: FROM gl_period_statuses
1856: WHERE period_name = p_period_name
1857: AND application_id = 101
1858: AND closing_status NOT IN ('F','N')
1859: AND ledger_id = gbl_set_of_books_id;

Line 1866: FROM gl_period_statuses

1862: gbl_period_year := gbl_fiscal_year;
1863:
1864: SELECT MIN(period_num)
1865: INTO gbl_period_num_low
1866: FROM gl_period_statuses
1867: WHERE period_year = gbl_fiscal_year
1868: AND application_id = 101
1869: AND closing_status <> 'F'
1870: AND closing_status <> 'N'

Line 2274: FROM gl_period_statuses

2270: /*
2271: IF gbl_trial_balance_type = 'F' then
2272: SELECT MAX(period_num)
2273: INTO l_period_num_high
2274: FROM gl_period_statuses
2275: WHERE period_year = p_period_year
2276: AND application_id = 101
2277: AND closing_status <> 'F'
2278: AND closing_status <> 'N'

Line 2283: FROM gl_period_statuses

2279: AND ledger_id = gbl_set_of_books_id;
2280:
2281: SELECT MIN(period_num)
2282: INTO l_period_num_low
2283: FROM gl_period_statuses
2284: WHERE period_year = p_period_year
2285: AND application_id = 101
2286: AND closing_status <> 'F'
2287: AND closing_status <> 'N'

Line 2293: FROM gl_period_statuses

2289: AND ledger_id = gbl_set_of_books_id;
2290:
2291: SELECT period_name
2292: INTO gbl_period_name
2293: FROM gl_period_statuses
2294: WHERE period_year = p_period_year
2295: AND application_id = 101
2296: AND period_num = l_period_num_high
2297: AND ledger_id = gbl_set_of_books_id;

Line 3041: FROM gl_period_statuses g2

3037: into l_je_header_id
3038: from gl_je_headers h
3039: WHERE ledger_id = gbl_set_of_books_id
3040: and exists (select'x'
3041: FROM gl_period_statuses g2
3042: WHERE g2.period_year = p_period_year
3043: AND g2.ledger_id = p_set_of_books_id
3044: AND g2.application_id = 101
3045: and g2.period_name = h.period_name);

Line 3335: from gl_period_statuses

3331:
3332: if l_no_new_accounts > 0 then
3333:
3334: select period_name into gbl_period_name
3335: from gl_period_statuses
3336: where ledger_id = gbl_set_of_books_id
3337: AND period_year = gbl_fiscal_year
3338: and application_id = 101
3339: and period_num = l_period_num;