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

Line 33: vp_period_name gl_period_statuses.period_name%type ;

29: vp_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE ;
30: vp_summary_type varchar2(1) ;
31: vp_fund_low fv_fund_parameters.fund_value%type ;
32: vp_fund_high fv_fund_parameters.fund_value%type ;
33: vp_period_name gl_period_statuses.period_name%type ;
34: vp_report_id number;
35: vp_output_format varchar2(30);
36: vp_attribute_set varchar2(80);
37:

Line 106: v_begin_period_name gl_period_statuses.period_name%TYPE ;

102: -- ======================================================================
103: -- ------------------------------
104: -- Period Declarations
105: -- -----------------------------
106: v_begin_period_name gl_period_statuses.period_name%TYPE ;
107: v_begin_period_start_dt date ;
108: v_begin_period_end_dt date ;
109: v_begin_period_num gl_period_statuses.period_num%TYPE ;
110: v_period_name gl_period_statuses.period_name%TYPE ;

Line 109: v_begin_period_num gl_period_statuses.period_num%TYPE ;

105: -- -----------------------------
106: v_begin_period_name gl_period_statuses.period_name%TYPE ;
107: v_begin_period_start_dt date ;
108: v_begin_period_end_dt date ;
109: v_begin_period_num gl_period_statuses.period_num%TYPE ;
110: v_period_name gl_period_statuses.period_name%TYPE ;
111: v_period_start_dt date ;
112: v_period_end_dt date ;
113: v_period_num gl_period_statuses.period_num%TYPE ;

Line 110: v_period_name gl_period_statuses.period_name%TYPE ;

106: v_begin_period_name gl_period_statuses.period_name%TYPE ;
107: v_begin_period_start_dt date ;
108: v_begin_period_end_dt date ;
109: v_begin_period_num gl_period_statuses.period_num%TYPE ;
110: v_period_name gl_period_statuses.period_name%TYPE ;
111: v_period_start_dt date ;
112: v_period_end_dt date ;
113: v_period_num gl_period_statuses.period_num%TYPE ;
114: v_bal_seg_name Varchar2(20) ;

Line 113: v_period_num gl_period_statuses.period_num%TYPE ;

109: v_begin_period_num gl_period_statuses.period_num%TYPE ;
110: v_period_name gl_period_statuses.period_name%TYPE ;
111: v_period_start_dt date ;
112: v_period_end_dt date ;
113: v_period_num gl_period_statuses.period_num%TYPE ;
114: v_bal_seg_name Varchar2(20) ;
115: v_acc_seg_name Varchar2(20) ;
116: v_catb_prg_seg_name Varchar2(20) ;
117: v_prn_prg_seg_name Varchar2(20) ;

Line 455: From gl_period_statuses

451: END IF;
452: Begin
453: Select period_year,period_num,start_date,end_date
454: Into vp_report_fiscal_yr,v_period_num,v_period_start_dt,v_period_end_dt
455: From gl_period_statuses
456: Where ledger_id = vp_set_of_books_id
457: And application_id = 101
458: And period_name = vp_period_name;
459: Exception

Line 477: from gl_period_statuses

473: Into v_begin_period_name,
474: v_begin_period_start_dt,
475: v_begin_period_end_dt,
476: v_begin_period_num
477: from gl_period_statuses
478: where (start_date,period_num) IN (Select MIN(year_start_date),MIN(period_num)
479: from gl_period_statuses
480: where period_year = vp_report_fiscal_yr
481: and ledger_id = vp_set_of_books_id)

Line 479: from gl_period_statuses

475: v_begin_period_end_dt,
476: v_begin_period_num
477: from gl_period_statuses
478: where (start_date,period_num) IN (Select MIN(year_start_date),MIN(period_num)
479: from gl_period_statuses
480: where period_year = vp_report_fiscal_yr
481: and ledger_id = vp_set_of_books_id)
482: and application_id = 101
483: and ledger_id = vp_set_of_books_id ;

Line 598: FROM gl_period_statuses

594: -- Bug 2774542
595:
596: SELECT to_char(count(*) , '09')
597: INTO vl_fiscal_month_count
598: FROM gl_period_statuses
599: WHERE ledger_id = vp_set_of_books_id
600: AND application_id = 101
601: AND period_year = vp_report_fiscal_yr
602: AND adjustment_period_flag = 'N'

Line 1242: FROM gl_period_statuses glp

1238: AND gjh.je_header_id = gjl.je_header_id
1239: AND gjh.currency_code = :currency_code
1240: AND NOT EXISTS
1241: (SELECT ''x''
1242: FROM gl_period_statuses glp
1243: WHERE glp.ledger_id = :set_of_books_id
1244: AND glp.application_id = 101
1245: AND glp.period_name = gjl.period_name
1246: AND glp.period_year = :report_fiscal_yr

Line 1382: FROM gl_period_statuses

1378:
1379:
1380: SELECT adjustment_period_flag, period_num
1381: INTO vl_adj_flag , vl_adj_num
1382: FROM gl_period_statuses
1383: WHERE ledger_id = vp_set_of_books_id
1384: AND application_id = 101
1385: AND period_name = vl_period_name;
1386: