456: ) RETURN NUMBER IS
457:
458: CURSOR csr_value_set_id IS
459: SELECT flex_value_set_id
460: FROM fnd_flex_value_sets
461: WHERE flex_value_set_name = p_value_set_name;
462:
463: l_flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE ;
464:
459: SELECT flex_value_set_id
460: FROM fnd_flex_value_sets
461: WHERE flex_value_set_name = p_value_set_name;
462:
463: l_flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE ;
464:
465: BEGIN
466:
467: OPEN csr_value_set_id;
5678: fvs.flex_value_set_id OBJECT_VALUE_SET_ID,
5679: fvs.validation_type,
5680: fvs.longlist_flag
5681: FROM OKC_XPRT_RULE_CONDITIONS RuleCond,
5682: fnd_flex_value_sets fvs
5683: where rtrim(RuleCond.OBJECT_VALUE_SET_NAME) = fvs.flex_value_set_name(+)
5684: and rule_condition_id=p_rule_condition_id;
5685:
5686: l_value VARCHAR2(1000) := null;
5728: fvs.flex_value_set_id OBJECT_VALUE_SET_ID,
5729: fvs.validation_type,
5730: fvs.longlist_flag
5731: FROM OKC_XPRT_RULE_CONDITIONS RuleCond,
5732: fnd_flex_value_sets fvs
5733: where RuleCond.OBJECT_VALUE_SET_NAME = fvs.flex_value_set_name(+)
5734: and rule_condition_id=p_rule_condition_id;
5735:
5736: l_value VARCHAR2(1000) := null;