[Home] [Help]
67: p_application_id in varchar2
68: )
69: Return Varchar2
70: IS
71: l_value_varchar2 AK_ATTRIBUTES.DEFAULT_VALUE_VARCHAR2%TYPE;
72: l_value_number number;
73: l_value_date date;
74:
75: CURSOR C IS
73: l_value_date date;
74:
75: CURSOR C IS
76: SELECT default_value_varchar2, default_value_number, default_value_date
77: FROM ak_Attributes
78: WHERE attribute_application_id = p_application_id
79: AND attribute_code = p_attribute_code;
80:
81: BEGIN