[Home] [Help]
266: /* FND_ID_FLEX_SEGMENTS */
267: /* FND_SEGMENT_ATTRIBUTE_VALUES */
268: /* FND_FLEX_HIERARCHIES */
269: /* FND_FLEX_VALUE_HIERARCHIES */
270: /* FND_FLEX_VALUES */
271: /* FND_SEG_RPT_ATTRIBUTES */
272: /* FND_FLEX_VALUE_SETS */
273: /* FND_TABLES */
274: /* FND_FLEX_VALIDATION_TABLES */
1562: sql_stmp := sql_stmp || ' ' ||
1563: 'and (segment' || i || '_type is null ' ||
1564: 'or segment' || i || '_type in (''D'', ''T'') ' ||
1565: 'or segment' || i || '_type in (select fh.hierarchy_name ' ||
1566: 'from gl_code_combinations cc, gl_summary_hierarchies gsh, fnd_flex_values fv, fnd_id_flex_segments fs, ' ||
1567: 'fnd_flex_hierarchies_vl fh ' ||
1568: 'where cc.code_combination_id = :ccid and ' ||
1569: 'cc.segment' || i || ' between gsh.child_flex_value_low and gsh.child_flex_value_high and ' ||
1570: 'gsh.flex_value_set_id = fv.flex_value_set_id and ' ||
2396:
2397: DECLARE
2398: CURSOR c_get_parents IS
2399: SELECT DISTINCT gsh.status_code, fv.flex_value
2400: FROM gl_summary_hierarchies gsh, fnd_flex_values fv
2401: WHERE gsh.flex_value_set_id = fv.flex_value_set_id
2402: AND gsh.parent_flex_value = fv.flex_value
2403: AND (seg_val(rgroup_ind(i)) between gsh.child_flex_value_low
2404: and gsh.child_flex_value_high)
2406: AND fv.flex_value_set_id = val_set(rgroup_ind(i))
2407: AND fv.structured_hierarchy_level = rgroup(rgroup_ind(i))
2408: AND fv.enabled_flag = 'Y';
2409:
2410: l_curr_val fnd_flex_values.flex_value%type;
2411: l_status_code gl_summary_hierarchies.status_code%type;
2412: BEGIN
2413:
2414: -- ========================= FND LOG ===========================
3516: -- definition fnd_flex tables; the SQL will be in this form:
3517: --
3518: -- UPDATE gl_code_combinations glcc set
3519: -- segment_attribute1 = (select attribute2
3520: -- from fnd_flex_values ffval
3521: -- where ffval.flex_value_set_id = 1234
3522: -- and enable_flag = 'Y'
3523: -- and ffval.flex_value = glcc.segment1)
3524: -- segment_attribute2 = (select ....)
3588:
3589: update_cl := update_cl ||
3590: c_RptAttr.aseg_name ||
3591: ' = (select ' || c_RptAttr.attr_name ||
3592: ' from fnd_flex_values ffval '||
3593: ' where ffval.flex_value_set_id = ' || c_RptAttr.vsid ||
3594: ' and enabled_flag = ''Y''' ||
3595: ' and ffval.flex_value = glcc.' || c_RptAttr.seg_name;
3596: