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 FND_ID_FLEX_SEGMENTS

Line 335: --* : fnd_id_flex_segments SELECT *--

331: --* Calls : fv_utility.debug_mesg *--
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. *--

Line 342: --* : 3. From fnd_id_flex_segments using the chart of acconts id and the *--

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 *--
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. *--

Line 356: p_acct_segment OUT NOCOPY fnd_id_flex_segments.application_column_name%TYPE,

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,
360: p_pub_law_code_col OUT NOCOPY fv_system_parameters.factsii_pub_law_code_attribute%TYPE,

Line 357: p_acct_value_set_id OUT NOCOPY fnd_id_flex_segments.flex_value_set_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,
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,

Line 358: p_bal_segment OUT NOCOPY fnd_id_flex_segments.application_column_name%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,
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,

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

Line 474: FROM fnd_id_flex_segments

470: IF (p_error_code = g_SUCCESS) THEN
471: BEGIN
472: SELECT flex_value_set_id
473: INTO p_acct_value_set_id
474: FROM fnd_id_flex_segments
475: WHERE application_column_name = p_acct_segment
476: AND application_id = l_application_id
477: AND id_flex_code = l_id_flex_code
478: AND id_flex_num = p_chart_of_accounts_id

Line 484: l_location := l_module_name||'select_fnd_id_flex_segments';

480: EXCEPTION
481: WHEN OTHERS THEN
482: p_error_code := g_FAILURE;
483: p_error_desc := SQLERRM;
484: l_location := l_module_name||'select_fnd_id_flex_segments';
485: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
486: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
487: END;
488: END IF;

Line 757: p_acct_segment IN fnd_id_flex_segments.application_column_name%TYPE,

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,
761: p_last_period_num IN NUMBER,

Line 758: p_bal_segment IN fnd_id_flex_segments.application_column_name%TYPE,

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,
761: p_last_period_num IN NUMBER,
762: p_pub_law_code_col IN fv_system_parameters.factsii_pub_law_code_attribute%TYPE,

Line 759: p_fyr_segment IN fnd_id_flex_segments.application_column_name%TYPE,

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,
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,

Line 790: l_cohort_segment fnd_id_flex_segments.application_column_name%TYPE;

786: l_system_date DATE := SYSDATE;
787: l_public_law_code VARCHAR2(1);
788: l_advance_flag VARCHAR2(1);
789: l_transfer_flag VARCHAR2(1);
790: l_cohort_segment fnd_id_flex_segments.application_column_name%TYPE;
791: l_cohort VARCHAR2(30);
792: TYPE l_segment_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
793: l_segment l_segment_type;
794: l_treasury_symbol_id NUMBER;

Line 1486: l_acct_segment fnd_id_flex_segments.application_column_name%TYPE;

1482: )
1483: IS
1484: l_module_name VARCHAR2(200);
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;

Line 1487: l_bal_segment fnd_id_flex_segments.application_column_name%TYPE;

1483: IS
1484: l_module_name VARCHAR2(200);
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;

Line 1488: l_fyr_segment fnd_id_flex_segments.application_column_name%TYPE;

1484: l_module_name VARCHAR2(200);
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;

Line 1490: l_acct_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;

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;
1494: l_tr_main_acct_col fv_system_parameters.factsii_tr_main_acct_attribute%TYPE;