8: p_calling_sequence IN varchar2) IS
9: CURSOR c IS
10: SELECT calendar
11: FROM ap_terms,
12: ap_terms_lines
13: WHERE ap_terms.term_id = ap_terms_lines.term_id
14: AND ap_terms.name = p_terms_name
15: AND ap_terms_lines.calendar is not null;
16:
9: CURSOR c IS
10: SELECT calendar
11: FROM ap_terms,
12: ap_terms_lines
13: WHERE ap_terms.term_id = ap_terms_lines.term_id
14: AND ap_terms.name = p_terms_name
15: AND ap_terms_lines.calendar is not null;
16:
17: l_calendar VARCHAR2(30);
11: FROM ap_terms,
12: ap_terms_lines
13: WHERE ap_terms.term_id = ap_terms_lines.term_id
14: AND ap_terms.name = p_terms_name
15: AND ap_terms_lines.calendar is not null;
16:
17: l_calendar VARCHAR2(30);
18: l_cal_exists VARCHAR2(1);
19: l_debug_info VARCHAR2(100);