APPS.FND_FLEX_KEY_API dependencies on FND_FLEX_VALUE_SETS

Line 29: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE;

25:
26: /* ---------- WHO INFORMATION ---------- */
27:
28: who_mode VARCHAR2(1000) := NULL; /* whether customer_data or seed_data */
29: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE;
30: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;
31: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;
32: creation_date_i fnd_flex_value_sets.creation_date%TYPE;
33: created_by_i fnd_flex_value_sets.created_by%TYPE;

Line 30: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;

26: /* ---------- WHO INFORMATION ---------- */
27:
28: who_mode VARCHAR2(1000) := NULL; /* whether customer_data or seed_data */
29: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE;
30: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;
31: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;
32: creation_date_i fnd_flex_value_sets.creation_date%TYPE;
33: created_by_i fnd_flex_value_sets.created_by%TYPE;
34:

Line 31: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;

27:
28: who_mode VARCHAR2(1000) := NULL; /* whether customer_data or seed_data */
29: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE;
30: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;
31: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;
32: creation_date_i fnd_flex_value_sets.creation_date%TYPE;
33: created_by_i fnd_flex_value_sets.created_by%TYPE;
34:
35: --

Line 32: creation_date_i fnd_flex_value_sets.creation_date%TYPE;

28: who_mode VARCHAR2(1000) := NULL; /* whether customer_data or seed_data */
29: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE;
30: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;
31: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;
32: creation_date_i fnd_flex_value_sets.creation_date%TYPE;
33: created_by_i fnd_flex_value_sets.created_by%TYPE;
34:
35: --
36: -- ERROR constants

Line 33: created_by_i fnd_flex_value_sets.created_by%TYPE;

29: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE;
30: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;
31: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;
32: creation_date_i fnd_flex_value_sets.creation_date%TYPE;
33: created_by_i fnd_flex_value_sets.created_by%TYPE;
34:
35: --
36: -- ERROR constants
37: --

Line 490: FROM fnd_flex_value_sets v,

486: END;
487:
488: SELECT NULL
489: INTO dummy
490: FROM fnd_flex_value_sets v,
491: fnd_flex_validation_tables t
492: WHERE v.flex_value_set_id = vset
493: AND v.flex_value_set_id = t.flex_value_set_id (+)
494: AND (flexfield.allow_id_value_sets = 'Y'

Line 787: RETURN fnd_flex_value_sets.flex_value_set_id%TYPE

783: END;
784:
785: /* ------------------------------------------------------------ */
786: FUNCTION value_set_id_f(value_set_name IN VARCHAR2)
787: RETURN fnd_flex_value_sets.flex_value_set_id%TYPE
788: IS
789: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
790: BEGIN
791: IF(value_set_name IS NULL) THEN

Line 789: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

785: /* ------------------------------------------------------------ */
786: FUNCTION value_set_id_f(value_set_name IN VARCHAR2)
787: RETURN fnd_flex_value_sets.flex_value_set_id%TYPE
788: IS
789: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
790: BEGIN
791: IF(value_set_name IS NULL) THEN
792: RETURN NULL;
793: END IF;

Line 797: FROM fnd_flex_value_sets

793: END IF;
794:
795: SELECT flex_value_set_id
796: INTO value_set_id
797: FROM fnd_flex_value_sets
798: WHERE flex_value_set_name = value_set_name
799: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
800: RETURN value_set_id;
801: EXCEPTION