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_CFS_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 20: v_acct_flex_value_set_id fnd_id_flex_segments_vl.flex_value_set_id%TYPE;

16: v_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
17: v_currency_code gl_sets_of_books.currency_code%TYPE;
18: v_bal_seg_name VARCHAR2(20);
19: v_acc_seg_name VARCHAR2(20);
20: v_acct_flex_value_set_id fnd_id_flex_segments_vl.flex_value_set_id%TYPE;
21: v_bal_flex_value_set_id fnd_id_flex_segments_vl.flex_value_set_id%TYPE;
22: v_line_id fv_cfs_rep_lines.line_id%TYPE;
23: v_line_details_id fv_cfs_rep_line_dtl.line_detail_id%TYPE;
24: v_line_type fv_cfs_rep_lines.line_type%TYPE;

Line 21: v_bal_flex_value_set_id fnd_id_flex_segments_vl.flex_value_set_id%TYPE;

17: v_currency_code gl_sets_of_books.currency_code%TYPE;
18: v_bal_seg_name VARCHAR2(20);
19: v_acc_seg_name VARCHAR2(20);
20: v_acct_flex_value_set_id fnd_id_flex_segments_vl.flex_value_set_id%TYPE;
21: v_bal_flex_value_set_id fnd_id_flex_segments_vl.flex_value_set_id%TYPE;
22: v_line_id fv_cfs_rep_lines.line_id%TYPE;
23: v_line_details_id fv_cfs_rep_line_dtl.line_detail_id%TYPE;
24: v_line_type fv_cfs_rep_lines.line_type%TYPE;
25: v_line_label fv_cfs_rep_lines.line_label%TYPE;

Line 135: c_segment_name fnd_id_flex_segments.segment_name%TYPE;

131: -- New Variables declared by Narsimha Balakkari.
132: c_resource_type fv_treasury_symbols.resource_type%TYPE;
133: c_rescission_flag VARCHAR2(10);
134: -- ---------- Flex Segment Name Cursor Variables ---------
135: c_segment_name fnd_id_flex_segments.segment_name%TYPE;
136: c_flex_column_name fnd_id_flex_segments.application_column_name%TYPE;
137: --
138: v_balance_column_name fnd_id_flex_segments.application_column_name%TYPE;
139: g_seg_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;

Line 136: c_flex_column_name fnd_id_flex_segments.application_column_name%TYPE;

132: c_resource_type fv_treasury_symbols.resource_type%TYPE;
133: c_rescission_flag VARCHAR2(10);
134: -- ---------- Flex Segment Name Cursor Variables ---------
135: c_segment_name fnd_id_flex_segments.segment_name%TYPE;
136: c_flex_column_name fnd_id_flex_segments.application_column_name%TYPE;
137: --
138: v_balance_column_name fnd_id_flex_segments.application_column_name%TYPE;
139: g_seg_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
140: -- ---------- Treasury Symbol Report Line Cursor Vaiables -----------

Line 138: v_balance_column_name fnd_id_flex_segments.application_column_name%TYPE;

134: -- ---------- Flex Segment Name Cursor Variables ---------
135: c_segment_name fnd_id_flex_segments.segment_name%TYPE;
136: c_flex_column_name fnd_id_flex_segments.application_column_name%TYPE;
137: --
138: v_balance_column_name fnd_id_flex_segments.application_column_name%TYPE;
139: g_seg_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
140: -- ---------- Treasury Symbol Report Line Cursor Vaiables -----------
141: c_sbr_ts_value gl_code_combinations.segment1%TYPE;
142: c_sbr_line_id fv_sbr_definitions_lines.sbr_line_id%TYPE;

Line 587: FROM fnd_id_flex_segments_vl

583: IF(num_boolean) THEN
584: num_boolean := FND_FLEX_APIS.GET_SEGMENT_INFO (apps_id, flex_code, v_chart_of_accounts_id, seg_number, v_acc_seg_name, seg_app_name, seg_prompt, seg_value_set_name);
585: SELECT flex_value_set_id
586: INTO v_acct_flex_value_set_id
587: FROM fnd_id_flex_segments_vl
588: WHERE application_id = 101
589: AND id_flex_code = 'GL#'
590: AND id_flex_num = v_chart_of_accounts_id
591: AND enabled_flag = 'Y'

Line 602: FROM fnd_id_flex_segments_vl

598: IF(num_boolean) THEN
599: num_boolean := FND_FLEX_APIS.GET_SEGMENT_INFO (apps_id, flex_code, v_chart_of_accounts_id, seg_number, v_bal_seg_name, seg_app_name, seg_prompt, seg_value_set_name);
600: SELECT flex_value_set_id
601: INTO v_bal_flex_value_set_id
602: FROM fnd_id_flex_segments_vl
603: WHERE application_id = 101
604: AND id_flex_code = 'GL#'
605: AND id_flex_num = v_chart_of_accounts_id
606: AND enabled_flag = 'Y'

Line 644: FROM fnd_id_flex_segments

640: CURSOR flex
641: IS
642: SELECT application_column_name ,
643: flex_value_set_id
644: FROM fnd_id_flex_segments
645: WHERE id_flex_code = 'GL#'
646: AND application_id = 101
647: AND id_flex_num = v_chart_of_accounts_id;
648: CURSOR child_value(seg VARCHAR2,sid NUMBER)

Line 971: FROM fnd_id_flex_segments glflex

967: CURSOR flex_columns_cursor
968: IS
969: SELECT UPPER(glflex.application_column_name) column_name,
970: flex_value_set_id
971: FROM fnd_id_flex_segments glflex
972: WHERE glflex.application_id = 101
973: AND glflex.id_flex_num = v_chart_of_accounts_id
974: AND glflex.id_flex_code = 'GL#'
975: ORDER BY glflex.application_column_name;

Line 977: l_flex_column_name fnd_id_flex_segments.application_column_name%TYPE;

973: AND glflex.id_flex_num = v_chart_of_accounts_id
974: AND glflex.id_flex_code = 'GL#'
975: ORDER BY glflex.application_column_name;
976:
977: l_flex_column_name fnd_id_flex_segments.application_column_name%TYPE;
978: l_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
979: l_temp1 VARCHAR2(8000) DEFAULT '';
980: l_temp2 VARCHAR2(8000) DEFAULT '';
981: l_table_name VARCHAR2(50);

Line 978: l_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;

974: AND glflex.id_flex_code = 'GL#'
975: ORDER BY glflex.application_column_name;
976:
977: l_flex_column_name fnd_id_flex_segments.application_column_name%TYPE;
978: l_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
979: l_temp1 VARCHAR2(8000) DEFAULT '';
980: l_temp2 VARCHAR2(8000) DEFAULT '';
981: l_table_name VARCHAR2(50);
982: l_period_name_where VARCHAR2(500);

Line 3587: FROM fnd_id_flex_segments glflex

3583: CURSOR flex_columns_cursor
3584: IS
3585: SELECT UPPER(glflex.application_column_name) column_name,
3586: flex_value_set_id
3587: FROM fnd_id_flex_segments glflex
3588: WHERE glflex.application_id = 101
3589: AND glflex.id_flex_num = v_chart_of_accounts_id
3590: AND glflex.id_flex_code = 'GL#'
3591: ORDER BY glflex.application_column_name;

Line 3593: l_flex_column_name fnd_id_flex_segments.application_column_name%TYPE;

3589: AND glflex.id_flex_num = v_chart_of_accounts_id
3590: AND glflex.id_flex_code = 'GL#'
3591: ORDER BY glflex.application_column_name;
3592:
3593: l_flex_column_name fnd_id_flex_segments.application_column_name%TYPE;
3594: l_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
3595: l_temp1 VARCHAR2(8000) DEFAULT '';
3596: l_temp2 VARCHAR2(8000) DEFAULT '';
3597: l_table_name VARCHAR2(50);

Line 3594: l_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;

3590: AND glflex.id_flex_code = 'GL#'
3591: ORDER BY glflex.application_column_name;
3592:
3593: l_flex_column_name fnd_id_flex_segments.application_column_name%TYPE;
3594: l_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
3595: l_temp1 VARCHAR2(8000) DEFAULT '';
3596: l_temp2 VARCHAR2(8000) DEFAULT '';
3597: l_table_name VARCHAR2(50);
3598: l_period_name_where VARCHAR2(500);