4922: p_calling_sequence IN varchar2) IS
4923:
4924: CURSOR c IS
4925: SELECT calendar
4926: FROM ap_terms,
4927: ap_terms_lines
4928: WHERE ap_terms.term_id = ap_terms_lines.term_id
4929: AND ap_terms.term_id = p_terms_id
4930: AND ap_terms_lines.calendar is not null;
4923:
4924: CURSOR c IS
4925: SELECT calendar
4926: FROM ap_terms,
4927: ap_terms_lines
4928: WHERE ap_terms.term_id = ap_terms_lines.term_id
4929: AND ap_terms.term_id = p_terms_id
4930: AND ap_terms_lines.calendar is not null;
4931:
4924: CURSOR c IS
4925: SELECT calendar
4926: FROM ap_terms,
4927: ap_terms_lines
4928: WHERE ap_terms.term_id = ap_terms_lines.term_id
4929: AND ap_terms.term_id = p_terms_id
4930: AND ap_terms_lines.calendar is not null;
4931:
4932: l_calendar VARCHAR2(30);
4925: SELECT calendar
4926: FROM ap_terms,
4927: ap_terms_lines
4928: WHERE ap_terms.term_id = ap_terms_lines.term_id
4929: AND ap_terms.term_id = p_terms_id
4930: AND ap_terms_lines.calendar is not null;
4931:
4932: l_calendar VARCHAR2(30);
4933: l_cal_exists VARCHAR2(1);
4926: FROM ap_terms,
4927: ap_terms_lines
4928: WHERE ap_terms.term_id = ap_terms_lines.term_id
4929: AND ap_terms.term_id = p_terms_id
4930: AND ap_terms_lines.calendar is not null;
4931:
4932: l_calendar VARCHAR2(30);
4933: l_cal_exists VARCHAR2(1);
4934: l_debug_info VARCHAR2(100);