DBA Data[Home] [Help]

APPS.FV_CFS_PKG dependencies on FND_ID_FLEX_SEGMENTS_VL

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