144: );
145:
146: PROCEDURE start_date_le_end_date(
147: p_line_id_tbl IN PO_TBL_NUMBER
148: , p_start_date_tbl IN PO_TBL_DATE
149: , p_expiration_date_tbl IN PO_TBL_DATE
150: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
151: , x_result_type OUT NOCOPY VARCHAR2
152: );
145:
146: PROCEDURE start_date_le_end_date(
147: p_line_id_tbl IN PO_TBL_NUMBER
148: , p_start_date_tbl IN PO_TBL_DATE
149: , p_expiration_date_tbl IN PO_TBL_DATE
150: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
151: , x_result_type OUT NOCOPY VARCHAR2
152: );
153:
152: );
153:
154: PROCEDURE otl_invalid_start_date_change(
155: p_line_id_tbl IN PO_TBL_NUMBER
156: , p_start_date_tbl IN PO_TBL_DATE
157: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
158: , x_result_type OUT NOCOPY VARCHAR2
159: );
160:
159: );
160:
161: PROCEDURE otl_invalid_end_date_change(
162: p_line_id_tbl IN PO_TBL_NUMBER
163: , p_expiration_date_tbl IN PO_TBL_DATE
164: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
165: , x_result_type OUT NOCOPY VARCHAR2
166: );
167:
197: );
198:
199: PROCEDURE expiration_ge_blanket_start(
200: p_line_id_tbl IN PO_TBL_NUMBER
201: , p_blanket_start_date_tbl IN PO_TBL_DATE
202: , p_expiration_date_tbl IN PO_TBL_DATE
203: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
204: , x_result_type OUT NOCOPY VARCHAR2
205: );
198:
199: PROCEDURE expiration_ge_blanket_start(
200: p_line_id_tbl IN PO_TBL_NUMBER
201: , p_blanket_start_date_tbl IN PO_TBL_DATE
202: , p_expiration_date_tbl IN PO_TBL_DATE
203: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
204: , x_result_type OUT NOCOPY VARCHAR2
205: );
206:
205: );
206:
207: PROCEDURE expiration_le_blanket_end(
208: p_line_id_tbl IN PO_TBL_NUMBER
209: , p_blanket_end_date_tbl IN PO_TBL_DATE
210: , p_expiration_date_tbl IN PO_TBL_DATE
211: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
212: , x_result_type OUT NOCOPY VARCHAR2
213: );
206:
207: PROCEDURE expiration_le_blanket_end(
208: p_line_id_tbl IN PO_TBL_NUMBER
209: , p_blanket_end_date_tbl IN PO_TBL_DATE
210: , p_expiration_date_tbl IN PO_TBL_DATE
211: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
212: , x_result_type OUT NOCOPY VARCHAR2
213: );
214:
289: );
290:
291: PROCEDURE temp_lbr_start_date_not_null(
292: p_line_id_tbl IN PO_TBL_NUMBER
293: , p_start_date_tbl IN PO_TBL_DATE
294: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
295: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
296: , x_result_type OUT NOCOPY VARCHAR2
297: );