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 FV_SYSTEM_PARAMETERS

Line 337: --* : fv_system_parameters SELECT *--

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 *--
341: --* : id and get the GL_ACCOUNT segment name *--

Line 346: --* : 5. From fv_system_parameters get the following attributes. *--

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 *--
349: --****************************************************************************************--
350: PROCEDURE initialize_program_variables

Line 360: p_pub_law_code_col OUT NOCOPY fv_system_parameters.factsii_pub_law_code_attribute%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,
360: p_pub_law_code_col OUT NOCOPY fv_system_parameters.factsii_pub_law_code_attribute%TYPE,
361: p_advance_type_col OUT NOCOPY fv_system_parameters.factsii_advance_type_attribute%TYPE,
362: p_tr_main_acct_col OUT NOCOPY fv_system_parameters.factsii_tr_main_acct_attribute%TYPE,
363: p_tr_dept_id_col OUT NOCOPY fv_system_parameters.factsii_tr_dept_id_attribute%TYPE,
364: p_error_code OUT NOCOPY NUMBER,

Line 361: p_advance_type_col OUT NOCOPY fv_system_parameters.factsii_advance_type_attribute%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,
360: p_pub_law_code_col OUT NOCOPY fv_system_parameters.factsii_pub_law_code_attribute%TYPE,
361: p_advance_type_col OUT NOCOPY fv_system_parameters.factsii_advance_type_attribute%TYPE,
362: p_tr_main_acct_col OUT NOCOPY fv_system_parameters.factsii_tr_main_acct_attribute%TYPE,
363: p_tr_dept_id_col OUT NOCOPY fv_system_parameters.factsii_tr_dept_id_attribute%TYPE,
364: p_error_code OUT NOCOPY NUMBER,
365: p_error_desc OUT NOCOPY VARCHAR2

Line 362: p_tr_main_acct_col OUT NOCOPY fv_system_parameters.factsii_tr_main_acct_attribute%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,
360: p_pub_law_code_col OUT NOCOPY fv_system_parameters.factsii_pub_law_code_attribute%TYPE,
361: p_advance_type_col OUT NOCOPY fv_system_parameters.factsii_advance_type_attribute%TYPE,
362: p_tr_main_acct_col OUT NOCOPY fv_system_parameters.factsii_tr_main_acct_attribute%TYPE,
363: p_tr_dept_id_col OUT NOCOPY fv_system_parameters.factsii_tr_dept_id_attribute%TYPE,
364: p_error_code OUT NOCOPY NUMBER,
365: p_error_desc OUT NOCOPY VARCHAR2
366: )

Line 363: p_tr_dept_id_col OUT NOCOPY fv_system_parameters.factsii_tr_dept_id_attribute%TYPE,

359: p_fyr_segment OUT NOCOPY fnd_id_flex_segments.application_column_name%TYPE,
360: p_pub_law_code_col OUT NOCOPY fv_system_parameters.factsii_pub_law_code_attribute%TYPE,
361: p_advance_type_col OUT NOCOPY fv_system_parameters.factsii_advance_type_attribute%TYPE,
362: p_tr_main_acct_col OUT NOCOPY fv_system_parameters.factsii_tr_main_acct_attribute%TYPE,
363: p_tr_dept_id_col OUT NOCOPY fv_system_parameters.factsii_tr_dept_id_attribute%TYPE,
364: p_error_code OUT NOCOPY NUMBER,
365: p_error_desc OUT NOCOPY VARCHAR2
366: )
367: IS

Line 518: FROM fv_system_parameters;

514: INTO p_pub_law_code_col,
515: p_advance_type_col,
516: p_tr_main_acct_col,
517: p_tr_dept_id_col
518: FROM fv_system_parameters;
519: EXCEPTION
520: WHEN OTHERS THEN
521: p_error_code := g_FAILURE;
522: p_error_desc := SQLERRM;

Line 762: p_pub_law_code_col IN fv_system_parameters.factsii_pub_law_code_attribute%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,
765: p_tr_dept_id_col IN fv_system_parameters.factsii_tr_dept_id_attribute%TYPE,
766: p_error_code OUT NOCOPY NUMBER,

Line 763: p_advance_type_col IN fv_system_parameters.factsii_advance_type_attribute%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,
765: p_tr_dept_id_col IN fv_system_parameters.factsii_tr_dept_id_attribute%TYPE,
766: p_error_code OUT NOCOPY NUMBER,
767: p_error_desc OUT NOCOPY VARCHAR2

Line 764: p_tr_main_acct_col IN fv_system_parameters.factsii_tr_main_acct_attribute%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,
765: p_tr_dept_id_col IN fv_system_parameters.factsii_tr_dept_id_attribute%TYPE,
766: p_error_code OUT NOCOPY NUMBER,
767: p_error_desc OUT NOCOPY VARCHAR2
768: )

Line 765: p_tr_dept_id_col IN fv_system_parameters.factsii_tr_dept_id_attribute%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,
765: p_tr_dept_id_col IN fv_system_parameters.factsii_tr_dept_id_attribute%TYPE,
766: p_error_code OUT NOCOPY NUMBER,
767: p_error_desc OUT NOCOPY VARCHAR2
768: )
769: IS

Line 1492: l_pub_law_code_col fv_system_parameters.factsii_pub_law_code_attribute%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;
1494: l_tr_main_acct_col fv_system_parameters.factsii_tr_main_acct_attribute%TYPE;
1495: l_tr_dept_id_col fv_system_parameters.factsii_tr_dept_id_attribute%TYPE;
1496: BEGIN

Line 1493: l_advance_type_col fv_system_parameters.factsii_advance_type_attribute%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;
1494: l_tr_main_acct_col fv_system_parameters.factsii_tr_main_acct_attribute%TYPE;
1495: l_tr_dept_id_col fv_system_parameters.factsii_tr_dept_id_attribute%TYPE;
1496: BEGIN
1497: l_module_name := g_module_name || 'derive_balances';

Line 1494: l_tr_main_acct_col fv_system_parameters.factsii_tr_main_acct_attribute%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;
1494: l_tr_main_acct_col fv_system_parameters.factsii_tr_main_acct_attribute%TYPE;
1495: l_tr_dept_id_col fv_system_parameters.factsii_tr_dept_id_attribute%TYPE;
1496: BEGIN
1497: l_module_name := g_module_name || 'derive_balances';
1498: p_retcode := g_SUCCESS;

Line 1495: l_tr_dept_id_col fv_system_parameters.factsii_tr_dept_id_attribute%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;
1494: l_tr_main_acct_col fv_system_parameters.factsii_tr_main_acct_attribute%TYPE;
1495: l_tr_dept_id_col fv_system_parameters.factsii_tr_dept_id_attribute%TYPE;
1496: BEGIN
1497: l_module_name := g_module_name || 'derive_balances';
1498: p_retcode := g_SUCCESS;
1499: