476: p_result OUT NOCOPY VARCHAR2);
477:
478: --ER 1552747 - withdraw expense report
479: PROCEDURE WithdrawExpenseRep(
480: p_rep_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE);
481:
482: PROCEDURE GenerateExpClobLines(document_id IN VARCHAR2,
483: display_type IN VARCHAR2,
484: document IN OUT NOCOPY CLOB,
520:
521: ---------------------------------------------------------
522: PROCEDURE addToMileageArray(
523: p_index IN NUMBER,
524: p_new_dist_number IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
525: p_trip_dist IN AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE,
526: p_daily_distance IN AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE,
527: p_rate IN AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE,
528: p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
521: ---------------------------------------------------------
522: PROCEDURE addToMileageArray(
523: p_index IN NUMBER,
524: p_new_dist_number IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
525: p_trip_dist IN AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE,
526: p_daily_distance IN AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE,
527: p_rate IN AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE,
528: p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
529: p_from_index IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
522: PROCEDURE addToMileageArray(
523: p_index IN NUMBER,
524: p_new_dist_number IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
525: p_trip_dist IN AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE,
526: p_daily_distance IN AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE,
527: p_rate IN AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE,
528: p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
529: p_from_index IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
530: p_mileage_line_array IN OUT NOCOPY AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array);
523: p_index IN NUMBER,
524: p_new_dist_number IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
525: p_trip_dist IN AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE,
526: p_daily_distance IN AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE,
527: p_rate IN AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE,
528: p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
529: p_from_index IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
530: p_mileage_line_array IN OUT NOCOPY AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array);
531:
524: p_new_dist_number IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
525: p_trip_dist IN AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE,
526: p_daily_distance IN AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE,
527: p_rate IN AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE,
528: p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
529: p_from_index IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
530: p_mileage_line_array IN OUT NOCOPY AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array);
531:
532: ---------------------------------------------------------
525: p_trip_dist IN AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE,
526: p_daily_distance IN AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE,
527: p_rate IN AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE,
528: p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
529: p_from_index IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
530: p_mileage_line_array IN OUT NOCOPY AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array);
531:
532: ---------------------------------------------------------
533: PROCEDURE updateNewDistNumber(