eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_FORMS_JRAD_PVT dependencies on FND_FLEX_VALUE_SETS

Line 69: select decode(fnd_flex_value_sets.longlist_flag, 'X', 'N', 'Y') isLov

65:
66: v_ret_value := 'N';
67:
68: BEGIN
69: select decode(fnd_flex_value_sets.longlist_flag, 'X', 'N', 'Y') isLov
70: into v_ret_value
71: from pon_fields,
72: fnd_flex_value_sets
73: where pon_fields.value_set_name = fnd_flex_value_sets.flex_value_set_name

Line 72: fnd_flex_value_sets

68: BEGIN
69: select decode(fnd_flex_value_sets.longlist_flag, 'X', 'N', 'Y') isLov
70: into v_ret_value
71: from pon_fields,
72: fnd_flex_value_sets
73: where pon_fields.value_set_name = fnd_flex_value_sets.flex_value_set_name
74: and pon_fields.value_set_name is not null
75: and pon_fields.field_code = p_field_code;
76:

Line 73: where pon_fields.value_set_name = fnd_flex_value_sets.flex_value_set_name

69: select decode(fnd_flex_value_sets.longlist_flag, 'X', 'N', 'Y') isLov
70: into v_ret_value
71: from pon_fields,
72: fnd_flex_value_sets
73: where pon_fields.value_set_name = fnd_flex_value_sets.flex_value_set_name
74: and pon_fields.value_set_name is not null
75: and pon_fields.field_code = p_field_code;
76:
77: EXCEPTION

Line 570: SELECT fnd_flex_value_sets.LONGLIST_FLAG, fnd_flex_value_sets.VALIDATION_TYPE

566: || p_mapping_field || ' ' || p_value_set_name);
567:
568: BEGIN
569:
570: SELECT fnd_flex_value_sets.LONGLIST_FLAG, fnd_flex_value_sets.VALIDATION_TYPE
571: INTO v_display_type, v_validation_type
572: FROM fnd_flex_value_sets
573: WHERE fnd_flex_value_sets.FLEX_VALUE_SET_NAME = p_value_set_name;
574:

Line 572: FROM fnd_flex_value_sets

568: BEGIN
569:
570: SELECT fnd_flex_value_sets.LONGLIST_FLAG, fnd_flex_value_sets.VALIDATION_TYPE
571: INTO v_display_type, v_validation_type
572: FROM fnd_flex_value_sets
573: WHERE fnd_flex_value_sets.FLEX_VALUE_SET_NAME = p_value_set_name;
574:
575: EXCEPTION
576: WHEN OTHERS THEN

Line 573: WHERE fnd_flex_value_sets.FLEX_VALUE_SET_NAME = p_value_set_name;

569:
570: SELECT fnd_flex_value_sets.LONGLIST_FLAG, fnd_flex_value_sets.VALIDATION_TYPE
571: INTO v_display_type, v_validation_type
572: FROM fnd_flex_value_sets
573: WHERE fnd_flex_value_sets.FLEX_VALUE_SET_NAME = p_value_set_name;
574:
575: EXCEPTION
576: WHEN OTHERS THEN
577: RAISE FND_FLEX_EXCEPTION;

Line 699: SELECT fnd_flex_value_sets.LONGLIST_FLAG, fnd_flex_value_sets.VALIDATION_TYPE

695: || p_mapping_field || ' ' || p_value_set_name);
696:
697: BEGIN
698:
699: SELECT fnd_flex_value_sets.LONGLIST_FLAG, fnd_flex_value_sets.VALIDATION_TYPE
700: INTO v_display_type, v_validation_type
701: FROM fnd_flex_value_sets
702: WHERE fnd_flex_value_sets.FLEX_VALUE_SET_NAME = p_value_set_name;
703:

Line 701: FROM fnd_flex_value_sets

697: BEGIN
698:
699: SELECT fnd_flex_value_sets.LONGLIST_FLAG, fnd_flex_value_sets.VALIDATION_TYPE
700: INTO v_display_type, v_validation_type
701: FROM fnd_flex_value_sets
702: WHERE fnd_flex_value_sets.FLEX_VALUE_SET_NAME = p_value_set_name;
703:
704: EXCEPTION
705: WHEN OTHERS THEN

Line 702: WHERE fnd_flex_value_sets.FLEX_VALUE_SET_NAME = p_value_set_name;

698:
699: SELECT fnd_flex_value_sets.LONGLIST_FLAG, fnd_flex_value_sets.VALIDATION_TYPE
700: INTO v_display_type, v_validation_type
701: FROM fnd_flex_value_sets
702: WHERE fnd_flex_value_sets.FLEX_VALUE_SET_NAME = p_value_set_name;
703:
704: EXCEPTION
705: WHEN OTHERS THEN
706: RAISE FND_FLEX_EXCEPTION;