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_LEDGERS_PUBLIC_V

Line 25: p_ledger_id IN gl_ledgers_public_v.ledger_id%TYPE,

21: END;
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: )

Line 151: p_ledger_id IN gl_ledgers_public_v.ledger_id%TYPE,

147: --* : temporary table fv_factsii_accounts_gt *--
148: --****************************************************************************************--
149: PROCEDURE explode_accounts
150: (
151: p_ledger_id IN gl_ledgers_public_v.ledger_id%TYPE,
152: p_acct_value_set_id IN NUMBER,
153: p_error_code OUT NOCOPY NUMBER,
154: p_error_desc OUT NOCOPY VARCHAR2
155: )

Line 352: p_ledger_id IN gl_ledgers_public_v.ledger_id%TYPE,

348: --* : factsii_tr_dept_id_attribute and factsii_pub_law_code_attribute *--
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,

Line 355: p_chart_of_accounts_id OUT NOCOPY gl_ledgers_public_v.chart_of_accounts_id%TYPE,

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,
359: p_fyr_segment OUT NOCOPY fnd_id_flex_segments.application_column_name%TYPE,

Line 398: FROM gl_ledgers_public_v glp

394: BEGIN
395:
396: SELECT glp.chart_of_accounts_id
397: INTO p_chart_of_accounts_id
398: FROM gl_ledgers_public_v glp
399: WHERE glp.ledger_id = p_ledger_id;
400:
401: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
402: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'p_chart_of_accounts_id='||p_chart_of_accounts_id);

Line 584: p_ledger_id IN gl_ledgers_public_v.ledger_id%TYPE,

580: --* : set of books id and fiscal year.
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: )

Line 756: p_ledger_id IN gl_ledgers_public_v.ledger_id%TYPE,

752: --* Logic : 1.
753: --****************************************************************************************--
754: PROCEDURE start_processing
755: (
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,

Line 1489: l_chart_of_accounts_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;

1485: l_location VARCHAR2(200);
1486: l_acct_segment fnd_id_flex_segments.application_column_name%TYPE;
1487: l_bal_segment fnd_id_flex_segments.application_column_name%TYPE;
1488: l_fyr_segment fnd_id_flex_segments.application_column_name%TYPE;
1489: l_chart_of_accounts_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
1490: l_acct_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
1491: l_last_period_num gl_balances.period_num%TYPE;
1492: l_pub_law_code_col fv_system_parameters.factsii_pub_law_code_attribute%TYPE;
1493: l_advance_type_col fv_system_parameters.factsii_advance_type_attribute%TYPE;