469: p_result OUT NOCOPY VARCHAR2);
470:
471: --ER 1552747 - withdraw expense report
472: PROCEDURE WithdrawExpenseRep(
473: p_rep_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE);
474:
475: PROCEDURE GenerateExpClobLines(document_id IN VARCHAR2,
476: display_type IN VARCHAR2,
477: document IN OUT NOCOPY CLOB,
513:
514: ---------------------------------------------------------
515: PROCEDURE addToMileageArray(
516: p_index IN NUMBER,
517: p_new_dist_number IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
518: p_trip_dist IN AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE,
519: p_daily_distance IN AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE,
520: p_rate IN AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE,
521: p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
514: ---------------------------------------------------------
515: PROCEDURE addToMileageArray(
516: p_index IN NUMBER,
517: p_new_dist_number IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
518: p_trip_dist IN AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE,
519: p_daily_distance IN AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE,
520: p_rate IN AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE,
521: p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
522: p_from_index IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
515: PROCEDURE addToMileageArray(
516: p_index IN NUMBER,
517: p_new_dist_number IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
518: p_trip_dist IN AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE,
519: p_daily_distance IN AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE,
520: p_rate IN AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE,
521: p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
522: p_from_index IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
523: p_mileage_line_array IN OUT NOCOPY AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array);
516: p_index IN NUMBER,
517: p_new_dist_number IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
518: p_trip_dist IN AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE,
519: p_daily_distance IN AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE,
520: p_rate IN AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE,
521: p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
522: p_from_index IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
523: p_mileage_line_array IN OUT NOCOPY AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array);
524:
517: p_new_dist_number IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
518: p_trip_dist IN AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE,
519: p_daily_distance IN AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE,
520: p_rate IN AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE,
521: p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
522: p_from_index IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
523: p_mileage_line_array IN OUT NOCOPY AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array);
524:
525: ---------------------------------------------------------
518: p_trip_dist IN AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE,
519: p_daily_distance IN AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE,
520: p_rate IN AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE,
521: p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
522: p_from_index IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
523: p_mileage_line_array IN OUT NOCOPY AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array);
524:
525: ---------------------------------------------------------
526: PROCEDURE updateNewDistNumber(