125: --
126: --
127: procedure get_username_policy_desc
128: (x_policy_code out nocopy FND_LOOKUP_TYPES.LOOKUP_TYPE%TYPE,
129: x_description out nocopy FND_LOOKUP_VALUES.MEANING%TYPE,
130: x_prompt out nocopy FND_LOOKUP_VALUES.MEANING%TYPE,
131: x_hint out nocopy FND_LOOKUP_VALUES.MEANING%TYPE) is
132:
133: cursor getPolicyDesc (p_lookup_type in varchar2) is
126: --
127: procedure get_username_policy_desc
128: (x_policy_code out nocopy FND_LOOKUP_TYPES.LOOKUP_TYPE%TYPE,
129: x_description out nocopy FND_LOOKUP_VALUES.MEANING%TYPE,
130: x_prompt out nocopy FND_LOOKUP_VALUES.MEANING%TYPE,
131: x_hint out nocopy FND_LOOKUP_VALUES.MEANING%TYPE) is
132:
133: cursor getPolicyDesc (p_lookup_type in varchar2) is
134: select lookup_code, meaning
127: procedure get_username_policy_desc
128: (x_policy_code out nocopy FND_LOOKUP_TYPES.LOOKUP_TYPE%TYPE,
129: x_description out nocopy FND_LOOKUP_VALUES.MEANING%TYPE,
130: x_prompt out nocopy FND_LOOKUP_VALUES.MEANING%TYPE,
131: x_hint out nocopy FND_LOOKUP_VALUES.MEANING%TYPE) is
132:
133: cursor getPolicyDesc (p_lookup_type in varchar2) is
134: select lookup_code, meaning
135: from fnd_lookups