15: -- Expiration date on the line cannot be earlier than the header effective start date and
16: -- cannot be later than header effective end date
17: -------------------------------------------------------------------------
18: PROCEDURE expiration_date_blanket(p_id_tbl IN po_tbl_number,
19: p_expiration_date_tbl IN po_tbl_date,
20: p_header_start_date_tbl IN po_tbl_date,
21: p_header_end_date_tbl IN po_tbl_date,
22: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
23: x_result_type OUT NOCOPY VARCHAR2);
16: -- cannot be later than header effective end date
17: -------------------------------------------------------------------------
18: PROCEDURE expiration_date_blanket(p_id_tbl IN po_tbl_number,
19: p_expiration_date_tbl IN po_tbl_date,
20: p_header_start_date_tbl IN po_tbl_date,
21: p_header_end_date_tbl IN po_tbl_date,
22: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
23: x_result_type OUT NOCOPY VARCHAR2);
24:
17: -------------------------------------------------------------------------
18: PROCEDURE expiration_date_blanket(p_id_tbl IN po_tbl_number,
19: p_expiration_date_tbl IN po_tbl_date,
20: p_header_start_date_tbl IN po_tbl_date,
21: p_header_end_date_tbl IN po_tbl_date,
22: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
23: x_result_type OUT NOCOPY VARCHAR2);
24:
25: -------------------------------------------------------------------------
289: --Expiration date if provided should be later than the start date
290: --If purchase basis is not 'TEMP LABOR', start_date and expiration_date have to be null
291: -------------------------------------------------------------------------
292: PROCEDURE start_date_standard(p_id_tbl IN PO_TBL_NUMBER,
293: p_start_date_tbl IN PO_TBL_DATE,
294: p_expiration_date_tbl IN PO_TBL_DATE,
295: p_purchase_basis_tbl IN PO_TBL_VARCHAR30,
296: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
297: x_result_type OUT NOCOPY VARCHAR2);
290: --If purchase basis is not 'TEMP LABOR', start_date and expiration_date have to be null
291: -------------------------------------------------------------------------
292: PROCEDURE start_date_standard(p_id_tbl IN PO_TBL_NUMBER,
293: p_start_date_tbl IN PO_TBL_DATE,
294: p_expiration_date_tbl IN PO_TBL_DATE,
295: p_purchase_basis_tbl IN PO_TBL_VARCHAR30,
296: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
297: x_result_type OUT NOCOPY VARCHAR2);
298: