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

Line 26: p_fiscal_year IN gl_period_statuses.period_year%TYPE,

22:
23: PROCEDURE generate_output_report
24: (
25: p_ledger_id IN gl_ledgers_public_v.ledger_id%TYPE,
26: p_fiscal_year IN gl_period_statuses.period_year%TYPE,
27: p_error_code OUT NOCOPY NUMBER,
28: p_error_desc OUT NOCOPY VARCHAR2
29: )
30: IS

Line 336: --* : gl_period_statuses SELECT *--

332: --* : fv_utility.log_mesg *--
333: --* : fnd_flex_apis.get_segment_column *--
334: --* Tables Used : gl_sets_of_books SELECT *--
335: --* : fnd_id_flex_segments SELECT *--
336: --* : gl_period_statuses SELECT *--
337: --* : fv_system_parameters SELECT *--
338: --* Logic : 1. Get the chart of accounts id from gl_sets_of_books using the *--
339: --* : set of books id. *--
340: --* : 2. Call fnd_flex_apis.get_segment_column with the chart of accounts *--

Line 344: --* : 4. From gl_period_statuses get the last non adjusting period for the *--

340: --* : 2. Call fnd_flex_apis.get_segment_column with the chart of accounts *--
341: --* : id and get the GL_ACCOUNT segment name *--
342: --* : 3. From fnd_id_flex_segments using the chart of acconts id and the *--
343: --* : accounting segment name, get the Account value set id *--
344: --* : 4. From gl_period_statuses get the last non adjusting period for the *--
345: --* : Fiscal year and set of books id. *--
346: --* : 5. From fv_system_parameters get the following attributes. *--
347: --* : factsii_advance_type_attribute,factsii_tr_main_acct_attribute, *--
348: --* : factsii_tr_dept_id_attribute and factsii_pub_law_code_attribute *--

Line 353: p_fiscal_year IN gl_period_statuses.period_year%TYPE,

349: --****************************************************************************************--
350: PROCEDURE initialize_program_variables
351: (
352: p_ledger_id IN gl_ledgers_public_v.ledger_id%TYPE,
353: p_fiscal_year IN gl_period_statuses.period_year%TYPE,
354: p_last_period_num OUT NOCOPY gl_period_statuses.period_num%TYPE,
355: p_chart_of_accounts_id OUT NOCOPY gl_ledgers_public_v.chart_of_accounts_id%TYPE,
356: p_acct_segment OUT NOCOPY fnd_id_flex_segments.application_column_name%TYPE,
357: p_acct_value_set_id OUT NOCOPY fnd_id_flex_segments.flex_value_set_id%TYPE,

Line 354: p_last_period_num OUT NOCOPY gl_period_statuses.period_num%TYPE,

350: PROCEDURE initialize_program_variables
351: (
352: p_ledger_id IN gl_ledgers_public_v.ledger_id%TYPE,
353: p_fiscal_year IN gl_period_statuses.period_year%TYPE,
354: p_last_period_num OUT NOCOPY gl_period_statuses.period_num%TYPE,
355: p_chart_of_accounts_id OUT NOCOPY gl_ledgers_public_v.chart_of_accounts_id%TYPE,
356: p_acct_segment OUT NOCOPY fnd_id_flex_segments.application_column_name%TYPE,
357: p_acct_value_set_id OUT NOCOPY fnd_id_flex_segments.flex_value_set_id%TYPE,
358: p_bal_segment OUT NOCOPY fnd_id_flex_segments.application_column_name%TYPE,

Line 494: FROM gl_period_statuses gps

490: IF (p_error_code = g_SUCCESS) THEN
491: BEGIN
492: SELECT MAX(period_num)
493: INTO p_last_period_num
494: FROM gl_period_statuses gps
495: WHERE gps.ledger_id = p_ledger_id
496: AND gps.application_id = l_application_id
497: AND gps.period_year = p_fiscal_year;
498: EXCEPTION

Line 502: l_location := l_module_name||'select_gl_period_statuses';

498: EXCEPTION
499: WHEN OTHERS THEN
500: p_error_code := g_FAILURE;
501: p_error_desc := SQLERRM;
502: l_location := l_module_name||'select_gl_period_statuses';
503: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
504: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
505: END;
506: END IF;

Line 523: l_location := l_module_name||'select_gl_period_statuses';

519: EXCEPTION
520: WHEN OTHERS THEN
521: p_error_code := g_FAILURE;
522: p_error_desc := SQLERRM;
523: l_location := l_module_name||'select_gl_period_statuses';
524: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
525: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
526: END;
527: END IF;

Line 585: p_fiscal_year IN gl_period_statuses.period_year%TYPE,

581: --****************************************************************************************--
582: PROCEDURE purge_balances
583: (
584: p_ledger_id IN gl_ledgers_public_v.ledger_id%TYPE,
585: p_fiscal_year IN gl_period_statuses.period_year%TYPE,
586: p_error_code OUT NOCOPY NUMBER,
587: p_error_desc OUT NOCOPY VARCHAR2
588: )
589: IS

Line 747: --* : gl_period_statuses gps SELECT *--

743: --* : fv_utility.log_mesg *--
744: --* Tables Used : fv_factsii_ending_balances INSERT *--
745: --* : gl_je_lines gll SELECT *--
746: --* : gl_je_headers gjh SELECT *--
747: --* : gl_period_statuses gps SELECT *--
748: --* : fv_be_trx_dtls SELECT *--
749: --* : gl_balances glbal SELECT *--
750: --* : gl_code_combinations gcc SELECT *--
751: --* : fv_factsii_accounts_gt SELECT *--

Line 760: p_fiscal_year IN gl_period_statuses.period_year%TYPE,

756: p_ledger_id IN gl_ledgers_public_v.ledger_id%TYPE,
757: p_acct_segment IN fnd_id_flex_segments.application_column_name%TYPE,
758: p_bal_segment IN fnd_id_flex_segments.application_column_name%TYPE,
759: p_fyr_segment IN fnd_id_flex_segments.application_column_name%TYPE,
760: p_fiscal_year IN gl_period_statuses.period_year%TYPE,
761: p_last_period_num IN NUMBER,
762: p_pub_law_code_col IN fv_system_parameters.factsii_pub_law_code_attribute%TYPE,
763: p_advance_type_col IN fv_system_parameters.factsii_advance_type_attribute%TYPE,
764: p_tr_main_acct_col IN fv_system_parameters.factsii_tr_main_acct_attribute%TYPE,

Line 913: gl_period_statuses gps,

909: :b_request_id,
910: :b_treasury_symbol_id
911: FROM gl_je_lines gll,
912: gl_je_headers gjh,
913: gl_period_statuses gps,
914: fv_be_trx_dtls be
915: WHERE gjh.ledger_id = gps.ledger_id
916: AND gll.code_combination_id = :b_code_combination_id
917: AND gjh.status=''P''

Line 954: gl_period_statuses gps,

950: FROM gl_je_lines gll,
951: gl_je_headers gjh,
952: xla_ae_lines xl ,
953: xla_distribution_links xdl,
954: gl_period_statuses gps,
955: fv_be_trx_dtls be,
956: gl_import_references glir
957: WHERE xl.code_combination_id = :b_code_combination_id
958: AND xl.ae_header_id = xdl.ae_header_id