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 40: vp_period_name gl_period_statuses.period_name%type ;

36: vp_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE ;
37:
38: vp_fund_low fv_fund_parameters.fund_value%type ;
39: vp_fund_high fv_fund_parameters.fund_value%type ;
40: vp_period_name gl_period_statuses.period_name%type ;
41: vp_report_id number;
42: vp_output_format varchar2(30);
43: vp_attribute_set varchar2(80);
44:

Line 121: v_begin_period_name gl_period_statuses.period_name%TYPE ;

117: -- ======================================================================
118: -- ------------------------------
119: -- Period Declarations
120: -- -----------------------------
121: v_begin_period_name gl_period_statuses.period_name%TYPE ;
122: v_begin_period_start_dt date ;
123: v_begin_period_end_dt date ;
124: v_begin_period_num gl_period_statuses.period_num%TYPE ;
125: v_period_name gl_period_statuses.period_name%TYPE ;

Line 124: v_begin_period_num gl_period_statuses.period_num%TYPE ;

120: -- -----------------------------
121: v_begin_period_name gl_period_statuses.period_name%TYPE ;
122: v_begin_period_start_dt date ;
123: v_begin_period_end_dt date ;
124: v_begin_period_num gl_period_statuses.period_num%TYPE ;
125: v_period_name gl_period_statuses.period_name%TYPE ;
126: v_period_start_dt date ;
127: v_period_end_dt date ;
128: v_period_num gl_period_statuses.period_num%TYPE ;

Line 125: v_period_name gl_period_statuses.period_name%TYPE ;

121: v_begin_period_name gl_period_statuses.period_name%TYPE ;
122: v_begin_period_start_dt date ;
123: v_begin_period_end_dt date ;
124: v_begin_period_num gl_period_statuses.period_num%TYPE ;
125: v_period_name gl_period_statuses.period_name%TYPE ;
126: v_period_start_dt date ;
127: v_period_end_dt date ;
128: v_period_num gl_period_statuses.period_num%TYPE ;
129: v_bal_seg_name Varchar2(20) ;

Line 128: v_period_num gl_period_statuses.period_num%TYPE ;

124: v_begin_period_num gl_period_statuses.period_num%TYPE ;
125: v_period_name gl_period_statuses.period_name%TYPE ;
126: v_period_start_dt date ;
127: v_period_end_dt date ;
128: v_period_num gl_period_statuses.period_num%TYPE ;
129: v_bal_seg_name Varchar2(20) ;
130: v_acc_seg_name Varchar2(20) ;
131: v_catb_prg_seg_name Varchar2(20) ;
132: v_prn_prg_seg_name Varchar2(20) ;

Line 511: From gl_period_statuses

507: END IF;
508: Begin
509: Select period_year,period_num,start_date,end_date
510: Into vp_report_fiscal_yr,v_period_num,v_period_start_dt,v_period_end_dt
511: From gl_period_statuses
512: Where ledger_id = vp_set_of_books_id
513: And application_id = 101
514: And period_name = vp_period_name;
515: Exception

Line 533: from gl_period_statuses

529: Into v_begin_period_name,
530: v_begin_period_start_dt,
531: v_begin_period_end_dt,
532: v_begin_period_num
533: from gl_period_statuses
534: where (start_date,period_num) IN (Select MIN(year_start_date),MIN(period_num)
535: from gl_period_statuses
536: where period_year = vp_report_fiscal_yr
537: and ledger_id = vp_set_of_books_id)

Line 535: from gl_period_statuses

531: v_begin_period_end_dt,
532: v_begin_period_num
533: from gl_period_statuses
534: where (start_date,period_num) IN (Select MIN(year_start_date),MIN(period_num)
535: from gl_period_statuses
536: where period_year = vp_report_fiscal_yr
537: and ledger_id = vp_set_of_books_id)
538: and application_id = 101
539: and ledger_id = vp_set_of_books_id ;

Line 663: FROM gl_period_statuses

659: -- Bug 2774542
660:
661: SELECT to_char(count(*) , '09')
662: INTO vl_fiscal_month_count
663: FROM gl_period_statuses
664: WHERE ledger_id = vp_set_of_books_id
665: AND application_id = 101
666: AND period_year = vp_report_fiscal_yr
667: AND adjustment_period_flag = 'N'

Line 1365: FROM gl_period_statuses glp

1361: AND gjh.je_header_id = gjl.je_header_id
1362: AND gjh.currency_code = :currency_code
1363: AND NOT EXISTS
1364: (SELECT ''x''
1365: FROM gl_period_statuses glp
1366: WHERE glp.ledger_id = :set_of_books_id
1367: AND glp.application_id = 101
1368: AND glp.period_name = gjl.period_name
1369: AND glp.period_year = :report_fiscal_yr

Line 1505: FROM gl_period_statuses

1501:
1502:
1503: SELECT adjustment_period_flag, period_num
1504: INTO vl_adj_flag , vl_adj_num
1505: FROM gl_period_statuses
1506: WHERE ledger_id = vp_set_of_books_id
1507: AND application_id = 101
1508: AND period_name = vl_period_name;
1509: