[Home] [Help]
1125: -- Cursor used to check that the value attribute type exist in the value attribute type
1126: -- table.
1127: CURSOR c_check_val_attribute_type IS
1128: SELECT 'Exists'
1129: FROM FND_VALUE_ATTRIBUTE_TYPES
1130: WHERE application_id = v_id_flex_application_id
1131: AND id_flex_code = v_id_flex_code
1132: AND segment_attribute_type = v_segment_attribute_type
1133: AND value_attribute_type = v_value_attribute_type;
1395: CURSOR c_value_attribute_type IS
1396: SELECT vat.required_flag AS required_flag,
1397: vat.lookup_type AS lookup_type,
1398: vat.value_attribute_type AS value_attribute_type
1399: FROM FND_VALUE_ATTRIBUTE_TYPES vat,
1400: FND_FLEX_VALIDATION_QUALIFIERS fvq
1401: WHERE fvq.flex_value_set_id = v_flex_value_set_id
1402: AND vat.id_flex_code = fvq.id_flex_code
1403: AND vat.application_id = fvq.id_flex_application_id
1476: -- Added by ABHJOSHI on 03/31/05
1477: -- Retrieve the count of the value attribute types required for the validation.
1478:
1479: SELECT COUNT(*) INTO v_count_value_attribute_types
1480: FROM FND_VALUE_ATTRIBUTE_TYPES vat,
1481: FND_FLEX_VALIDATION_QUALIFIERS fvq
1482: WHERE fvq.flex_value_set_id = v_flex_value_set_id
1483: AND vat.id_flex_code = fvq.id_flex_code
1484: AND vat.application_id = fvq.id_flex_application_id
2088: sav.segment_attribute_type,
2089: vat.value_attribute_type,
2090: sysdate
2091: FROM fnd_segment_attribute_values sav,
2092: fnd_value_attribute_types vat,
2093: fnd_id_flex_segments seg
2094: WHERE seg.application_id = v_application_id
2095: AND seg.id_flex_code = v_id_flex_code
2096: AND seg.id_flex_num = v_id_flex_num