[Home] [Help]
97: p_application_id in varchar2
98: )
99: Return Varchar2
100: IS
101: l_value_varchar2 AK_ATTRIBUTES.DEFAULT_VALUE_VARCHAR2%TYPE;
102: l_value_number number;
103: l_value_date date;
104:
105: CURSOR C IS
103: l_value_date date;
104:
105: CURSOR C IS
106: SELECT default_value_varchar2, default_value_number, default_value_date
107: FROM ak_Attributes
108: WHERE attribute_application_id = p_application_id
109: AND attribute_code = p_attribute_code;
110:
111: BEGIN