8896: l_new_calendar_name := get_ak_attribute_label('PA_SCH_UPDATE_TOP','PA_RESOURCE_CALENDAR');
8897: ELSIF p_new_change_cal_type_code = 'PROJECT' THEN
8898: SELECT calendar_name
8899: INTO l_new_calendar_name
8900: FROM jtf_calendars_vl
8901: WHERE calendar_id = p_new_calendar_id;
8902: -- if Other calendar has been selected
8903: ELSE
8904: IF (p_new_change_calendar_name IS NOT NULL) THEN
8905: l_new_calendar_name := p_new_change_calendar_name;
8906: ELSE
8907: SELECT calendar_name
8908: INTO l_new_calendar_name
8909: FROM jtf_calendars_vl
8910: WHERE calendar_id = p_new_change_calendar_id;
8911: END IF;
8912: END IF;
8913: