[Home] [Help]
1552: last_updated_by_i,
1553: last_update_login_i);
1554:
1555: -- If there are any segments defined
1556: -- populate fnd_segment_attribute_values table.
1557: -- Similar code exists in FNDFFIIF.SEG.other_inserts.
1558:
1559: INSERT INTO fnd_segment_attribute_values
1560: (application_id,
1555: -- If there are any segments defined
1556: -- populate fnd_segment_attribute_values table.
1557: -- Similar code exists in FNDFFIIF.SEG.other_inserts.
1558:
1559: INSERT INTO fnd_segment_attribute_values
1560: (application_id,
1561: id_flex_code,
1562: id_flex_num,
1563: application_column_name,
1647: s.id_flex_num || '/' ||
1648: s.application_column_name || '/' ||
1649: s.segment_name
1650: INTO l_vc2
1651: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav
1652: WHERE s.application_id = sav.application_id
1653: AND s.id_flex_code = sav.id_flex_code
1654: AND s.id_flex_num = sav.id_flex_num
1655: AND s.application_column_name = sav.application_column_name
1694:
1695: --
1696: -- Delete from SAV
1697: --
1698: DELETE FROM fnd_segment_attribute_values sav
1699: WHERE sav.application_id = flexfield.application_id
1700: AND sav.id_flex_code = flexfield.flex_code
1701: AND sav.segment_attribute_type = qualifier_name
1702: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
1726: l_return NUMBER := 0;
1727: BEGIN
1728: message_init;
1729:
1730: INSERT INTO fnd_segment_attribute_values
1731: (application_id,
1732: id_flex_code,
1733: id_flex_num,
1734: application_column_name,
1757: WHERE sat.application_id = ifsg.application_id
1758: AND sat.id_flex_code = ifsg.id_flex_code
1759: AND NOT exists
1760: (SELECT NULL
1761: FROM fnd_segment_attribute_values sav
1762: WHERE sav.application_id = ifsg.application_id
1763: AND sav.id_flex_code = ifsg.id_flex_code
1764: AND sav.id_flex_num = ifsg.id_flex_num
1765: AND sav.application_column_name = ifsg.application_column_name
1904: flexfield.flex_code,
1905: flex_qualifier,
1906: qualifier_name,
1907: SYSDATE
1908: FROM fnd_segment_attribute_values sav,
1909: fnd_id_flex_segments ifsg
1910: WHERE sav.application_id = flexfield.application_id
1911: AND sav.id_flex_code = flexfield.flex_code
1912: AND sav.segment_attribute_type = flex_qualifier
2809: last_update_login_i);
2810:
2811:
2812: BEGIN
2813: INSERT INTO fnd_segment_attribute_values(id_flex_code,
2814: id_flex_num,
2815: application_column_name,
2816: segment_attribute_type,
2817:
2858: flexfield.flex_code,
2859: sav.segment_attribute_type,
2860: vat.value_attribute_type,
2861: sysdate
2862: FROM fnd_segment_attribute_values sav,
2863: fnd_value_attribute_types vat
2864: WHERE segment.value_set_id IS NOT NULL
2865: AND segment.enabled_flag = 'Y'
2866: AND sav.application_id = flexfield.application_id
2956: check_instantiated(flexfield);
2957: check_instantiated(structure);
2958: check_instantiated(segment);
2959:
2960: UPDATE fnd_segment_attribute_values SET
2961: attribute_value = enable_flag,
2962: last_update_date = last_update_date_i,
2963: last_updated_by = last_updated_by_i,
2964: last_update_login = last_update_login_i
2981: flexfield.flex_code,
2982: sav.segment_attribute_type,
2983: vat.value_attribute_type,
2984: sysdate
2985: FROM fnd_segment_attribute_values sav,
2986: fnd_value_attribute_types vat
2987: WHERE segment.value_set_id IS NOT NULL
2988: AND segment.enabled_flag = 'Y'
2989: AND sav.application_id = flexfield.application_id
3072: AND application_column_name = original.column_name
3073: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
3074:
3075: IF(segment.column_name <> original.column_name) THEN
3076: UPDATE fnd_segment_attribute_values SET
3077: application_column_name = segment.column_name,
3078: last_update_date = last_update_date_i,
3079: last_updated_by = last_updated_by_i,
3080: last_update_login = last_update_login_i
3099: flexfield.flex_code,
3100: sav.segment_attribute_type,
3101: vat.value_attribute_type,
3102: Sysdate
3103: FROM fnd_segment_attribute_values sav,
3104: fnd_value_attribute_types vat
3105: WHERE segment.value_set_id IS NOT NULL
3106: AND segment.enabled_flag = 'Y'
3107: AND sav.application_id = flexfield.application_id
3160: message_init;
3161: --
3162: -- Delete "Flexfield Qualifier - Segment" assignments for this segment.
3163: --
3164: DELETE FROM fnd_segment_attribute_values
3165: WHERE application_id = flexfield.application_id
3166: AND id_flex_code = flexfield.flex_code
3167: AND id_flex_num = structure.structure_number
3168: AND application_column_name = segment.column_name
3500: segment IN segment_type)
3501: IS
3502: CURSOR assignments_c IS
3503: SELECT sav.segment_attribute_type
3504: FROM fnd_segment_attribute_values sav,
3505: fnd_segment_attribute_types sat
3506: WHERE sav.application_id = flexfield.application_id
3507: AND sav.id_flex_code = flexfield.flex_code
3508: AND sav.id_flex_num = structure.structure_number
3864: l_segment_order := g_cache_value.number_1;
3865: ELSE
3866: SELECT s.segment_num
3867: INTO l_segment_num
3868: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
3869: fnd_segment_attribute_types sat
3870: WHERE s.application_id = p_application_id
3871: AND s.id_flex_code = p_id_flex_code
3872: AND s.id_flex_num = p_id_flex_num