2274: l_no VARCHAR2(1) := 'N';
2275: /* Bug#4958997 End*/
2276:
2277: /* Start bug #4924031 */
2278: l_id_flex_code fnd_id_flex_structures.id_flex_code%TYPE;
2279: l_application_id fnd_id_flex_structures.application_id%TYPE;
2280: l_yes_flag VARCHAR2(1);
2281: /* End bug #4924031 */
2282:
2275: /* Bug#4958997 End*/
2276:
2277: /* Start bug #4924031 */
2278: l_id_flex_code fnd_id_flex_structures.id_flex_code%TYPE;
2279: l_application_id fnd_id_flex_structures.application_id%TYPE;
2280: l_yes_flag VARCHAR2(1);
2281: /* End bug #4924031 */
2282:
2283:
3596:
3597: Cursor C_key_22 is
3598: SELECT fstr.id_flex_num, fseg.application_column_name,
3599: fseg.flex_value_set_id
3600: FROM fnd_id_flex_structures_vl fstr,fnd_id_flex_segments_vl fseg
3601: WHERE fstr.application_id = l_application_id
3602: AND fstr.id_flex_code = l_id_flex_code
3603: AND fstr.id_flex_structure_name = l_definition_table
3604: AND fstr.id_flex_code = fseg.id_flex_code
4597:
4598: Cursor C_key_44 is
4599: SELECT fseg.application_column_name,
4600: fstr.id_flex_num
4601: FROM fnd_id_flex_structures_vl fstr,fnd_id_flex_segments_vl fseg
4602: WHERE fstr.application_id = l_application_id
4603: AND fstr.id_flex_code = l_id_flex_code
4604: AND fstr.id_flex_structure_name = l_definition_table
4605: AND fstr.id_flex_code = fseg.id_flex_code