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