112: END;
113: BEGIN
114: SELECT min(days_start), max(days_to)
115: INTO MINDAY, MAXDAY
116: FROM ap_aging_period_lines aapl, ap_aging_periods aap
117: WHERE aapl.aging_period_id = aap.aging_period_id
118: AND upper(aap.period_name) = upper(P_PERIOD_TYPE);
119: C_MINDAYS := MINDAY;
120: C_MAXDAYS := MAXDAY;
459:
460: END;
461:
462: FUNCTION get_period_info RETURN BOOLEAN IS
463: l_period_days_start ap_aging_period_lines.days_start%TYPE;
464: l_period_days_to ap_aging_period_lines.days_to%TYPE;
465: l_period_seq_num ap_aging_period_lines.period_sequence_num%TYPE;
466: l_period_title1 ap_aging_period_lines.report_heading1%TYPE;
467: l_period_title2 ap_aging_period_lines.report_heading2%TYPE;
460: END;
461:
462: FUNCTION get_period_info RETURN BOOLEAN IS
463: l_period_days_start ap_aging_period_lines.days_start%TYPE;
464: l_period_days_to ap_aging_period_lines.days_to%TYPE;
465: l_period_seq_num ap_aging_period_lines.period_sequence_num%TYPE;
466: l_period_title1 ap_aging_period_lines.report_heading1%TYPE;
467: l_period_title2 ap_aging_period_lines.report_heading2%TYPE;
468:
461:
462: FUNCTION get_period_info RETURN BOOLEAN IS
463: l_period_days_start ap_aging_period_lines.days_start%TYPE;
464: l_period_days_to ap_aging_period_lines.days_to%TYPE;
465: l_period_seq_num ap_aging_period_lines.period_sequence_num%TYPE;
466: l_period_title1 ap_aging_period_lines.report_heading1%TYPE;
467: l_period_title2 ap_aging_period_lines.report_heading2%TYPE;
468:
469: cursor period_info is
462: FUNCTION get_period_info RETURN BOOLEAN IS
463: l_period_days_start ap_aging_period_lines.days_start%TYPE;
464: l_period_days_to ap_aging_period_lines.days_to%TYPE;
465: l_period_seq_num ap_aging_period_lines.period_sequence_num%TYPE;
466: l_period_title1 ap_aging_period_lines.report_heading1%TYPE;
467: l_period_title2 ap_aging_period_lines.report_heading2%TYPE;
468:
469: cursor period_info is
470: SELECT lines.days_start,
463: l_period_days_start ap_aging_period_lines.days_start%TYPE;
464: l_period_days_to ap_aging_period_lines.days_to%TYPE;
465: l_period_seq_num ap_aging_period_lines.period_sequence_num%TYPE;
466: l_period_title1 ap_aging_period_lines.report_heading1%TYPE;
467: l_period_title2 ap_aging_period_lines.report_heading2%TYPE;
468:
469: cursor period_info is
470: SELECT lines.days_start,
471: lines.days_to,
471: lines.days_to,
472: lines.period_sequence_num,
473: report_heading1,
474: report_heading2
475: FROM ap_aging_period_lines lines,
476: ap_aging_periods periods
477: WHERE lines.aging_period_id = periods.aging_period_id
478: AND upper(periods.period_name) = upper(p_period_type)
479: ORDER BY lines.period_sequence_num;