[Home] [Help]
67: lval_format fnd_vset.valueset_dr;
68: ---------------------
69: -- Flags and Counters
70: ---------------------
71: lc_flex_val_set_name fnd_flex_value_sets.flex_value_set_name%type;
72: lc_new_flex_flag varchar2(1):='N';
73: ln_no_of_attributes number;
74: ln_func number;
75: ln_gl_nsegs number;
160: fdu.default_type ,
161: fdu.default_value ,
162: fdu.range_code
163: FROM fnd_seg_rpt_attributes att,
164: fnd_flex_value_sets val ,
165: fnd_descr_flex_column_usages fdu
166: WHERE segment_name = p_seg_name
167: AND att.attr_value_set_id = val.flex_value_set_id
168: AND att.enabled_flag = 'Y'
1109: attr.segment_num,
1110: valset.validation_type,
1111: attr.attr_segment_name
1112: FROM fnd_seg_rpt_attributes attr,
1113: fnd_flex_value_sets valset
1114: WHERE valset.flex_value_set_id = attr.flex_value_set_id
1115: AND attr.id_flex_num = :ln_p_coa_id ';
1116: ELSE
1117: lc_select_stmt:=
1122: attr.segment_name,
1123: attr.segment_num,
1124: valset.validation_type
1125: FROM fnd_seg_rpt_attributes attr,
1126: fnd_flex_value_sets valset
1127: WHERE valset.flex_value_set_id = attr.flex_value_set_id
1128: AND attr.id_flex_num = :ln_p_coa_id '||
1129: 'AND attr.segment_name = :lc_p_segment_name '||
1130: 'AND attr.attr_segment_name = :lc_p_denorm_seg ';
1221: FROM fnd_id_flex_segments
1222: WHERE id_flex_code = 'GLAT'
1223: AND flex_value_set_id =
1224: (SELECT parent_flex_value_set_id
1225: FROM fnd_flex_value_sets
1226: WHERE flex_value_set_id = ln_flex_value_set_id);
1227: --
1228: IF lc_parent_seg_name IS NULL THEN
1229: lc_err_message:='The Parent Seg name is null for the Dependent Value Set';