28: -- IN OUT p_gl_flex_values_tbl
29: --
30:
31: -- OUT p_gl_flex_values_status
32: -- This parameter returns the import status of Fnd Flex Values table
33:
34:
35: -- Version: Current Version 1.0
36: -- Previous Version
38: -- End of Comments
39:
40:
41:
42: /**********************fnd_flex_values Record Type ************/
43: TYPE gl_flex_values_rec_type IS RECORD (
44: value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE ,
45: flex_value fnd_flex_values.flex_value%TYPE,
46: flex_desc fnd_flex_values_tl.description%TYPE,
41:
42: /**********************fnd_flex_values Record Type ************/
43: TYPE gl_flex_values_rec_type IS RECORD (
44: value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE ,
45: flex_value fnd_flex_values.flex_value%TYPE,
46: flex_desc fnd_flex_values_tl.description%TYPE,
47: parent_flex_value fnd_flex_values.parent_flex_value_low%TYPE,
48: summary_flag fnd_flex_values.summary_flag%TYPE,
49: roll_up_group fnd_flex_hierarchies.hierarchy_code%TYPE,
42: /**********************fnd_flex_values Record Type ************/
43: TYPE gl_flex_values_rec_type IS RECORD (
44: value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE ,
45: flex_value fnd_flex_values.flex_value%TYPE,
46: flex_desc fnd_flex_values_tl.description%TYPE,
47: parent_flex_value fnd_flex_values.parent_flex_value_low%TYPE,
48: summary_flag fnd_flex_values.summary_flag%TYPE,
49: roll_up_group fnd_flex_hierarchies.hierarchy_code%TYPE,
50: hierarchy_level fnd_flex_values.hierarchy_level%TYPE,
43: TYPE gl_flex_values_rec_type IS RECORD (
44: value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE ,
45: flex_value fnd_flex_values.flex_value%TYPE,
46: flex_desc fnd_flex_values_tl.description%TYPE,
47: parent_flex_value fnd_flex_values.parent_flex_value_low%TYPE,
48: summary_flag fnd_flex_values.summary_flag%TYPE,
49: roll_up_group fnd_flex_hierarchies.hierarchy_code%TYPE,
50: hierarchy_level fnd_flex_values.hierarchy_level%TYPE,
51: allow_budgeting VARCHAR2(1),
44: value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE ,
45: flex_value fnd_flex_values.flex_value%TYPE,
46: flex_desc fnd_flex_values_tl.description%TYPE,
47: parent_flex_value fnd_flex_values.parent_flex_value_low%TYPE,
48: summary_flag fnd_flex_values.summary_flag%TYPE,
49: roll_up_group fnd_flex_hierarchies.hierarchy_code%TYPE,
50: hierarchy_level fnd_flex_values.hierarchy_level%TYPE,
51: allow_budgeting VARCHAR2(1),
52: allow_posting VARCHAR2(1),
46: flex_desc fnd_flex_values_tl.description%TYPE,
47: parent_flex_value fnd_flex_values.parent_flex_value_low%TYPE,
48: summary_flag fnd_flex_values.summary_flag%TYPE,
49: roll_up_group fnd_flex_hierarchies.hierarchy_code%TYPE,
50: hierarchy_level fnd_flex_values.hierarchy_level%TYPE,
51: allow_budgeting VARCHAR2(1),
52: allow_posting VARCHAR2(1),
53: account_type VARCHAR2(1),
54: reconcile VARCHAR2(1),
53: account_type VARCHAR2(1),
54: reconcile VARCHAR2(1),
55: third_party_control_account VARCHAR2(10), /* DRM Change */
56: /*third_party_control_account VARCHAR2(1),*/
57: enabled_flag fnd_flex_values.enabled_flag%TYPE,
58: effective_from DATE,
59: effective_to DATE,
60: msg_from NUMBER(6),
61: msg_to NUMBER(6),