DBA Data[Home] [Help]

APPS.PO_VAL_LINES dependencies on PO_TBL_DATE

Line 156: , p_start_date_tbl IN PO_TBL_DATE

152: );
153:
154: PROCEDURE start_date_le_end_date(
155: p_line_id_tbl IN PO_TBL_NUMBER
156: , p_start_date_tbl IN PO_TBL_DATE
157: , p_expiration_date_tbl IN PO_TBL_DATE
158: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
159: , x_result_type OUT NOCOPY VARCHAR2
160: );

Line 157: , p_expiration_date_tbl IN PO_TBL_DATE

153:
154: PROCEDURE start_date_le_end_date(
155: p_line_id_tbl IN PO_TBL_NUMBER
156: , p_start_date_tbl IN PO_TBL_DATE
157: , p_expiration_date_tbl IN PO_TBL_DATE
158: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
159: , x_result_type OUT NOCOPY VARCHAR2
160: );
161:

Line 164: , p_start_date_tbl IN PO_TBL_DATE

160: );
161:
162: PROCEDURE otl_invalid_start_date_change(
163: p_line_id_tbl IN PO_TBL_NUMBER
164: , p_start_date_tbl IN PO_TBL_DATE
165: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
166: , x_result_type OUT NOCOPY VARCHAR2
167: );
168:

Line 171: , p_expiration_date_tbl IN PO_TBL_DATE

167: );
168:
169: PROCEDURE otl_invalid_end_date_change(
170: p_line_id_tbl IN PO_TBL_NUMBER
171: , p_expiration_date_tbl IN PO_TBL_DATE
172: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
173: , x_result_type OUT NOCOPY VARCHAR2
174: );
175:

Line 211: , p_blanket_start_date_tbl IN PO_TBL_DATE

207: );
208:
209: PROCEDURE expiration_ge_blanket_start(
210: p_line_id_tbl IN PO_TBL_NUMBER
211: , p_blanket_start_date_tbl IN PO_TBL_DATE
212: , p_expiration_date_tbl IN PO_TBL_DATE
213: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
214: , x_result_type OUT NOCOPY VARCHAR2
215: );

Line 212: , p_expiration_date_tbl IN PO_TBL_DATE

208:
209: PROCEDURE expiration_ge_blanket_start(
210: p_line_id_tbl IN PO_TBL_NUMBER
211: , p_blanket_start_date_tbl IN PO_TBL_DATE
212: , p_expiration_date_tbl IN PO_TBL_DATE
213: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
214: , x_result_type OUT NOCOPY VARCHAR2
215: );
216:

Line 219: , p_blanket_end_date_tbl IN PO_TBL_DATE

215: );
216:
217: PROCEDURE expiration_le_blanket_end(
218: p_line_id_tbl IN PO_TBL_NUMBER
219: , p_blanket_end_date_tbl IN PO_TBL_DATE
220: , p_expiration_date_tbl IN PO_TBL_DATE
221: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
222: , x_result_type OUT NOCOPY VARCHAR2
223: );

Line 220: , p_expiration_date_tbl IN PO_TBL_DATE

216:
217: PROCEDURE expiration_le_blanket_end(
218: p_line_id_tbl IN PO_TBL_NUMBER
219: , p_blanket_end_date_tbl IN PO_TBL_DATE
220: , p_expiration_date_tbl IN PO_TBL_DATE
221: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
222: , x_result_type OUT NOCOPY VARCHAR2
223: );
224:

Line 322: , p_start_date_tbl IN PO_TBL_DATE

318: );
319:
320: PROCEDURE temp_lbr_start_date_not_null(
321: p_line_id_tbl IN PO_TBL_NUMBER
322: , p_start_date_tbl IN PO_TBL_DATE
323: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
324: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
325: , x_result_type OUT NOCOPY VARCHAR2
326: );

Line 369: ,p_option_from_date_tbl IN PO_TBL_DATE

365:
366: PROCEDURE option_from_date_not_null (
367: p_line_id_tbl IN PO_TBL_NUMBER
368: , p_option_ind_tbl IN PO_TBL_VARCHAR1
369: ,p_option_from_date_tbl IN PO_TBL_DATE
370: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
371: , x_result_type OUT NOCOPY VARCHAR2
372: );
373:

Line 377: ,p_option_to_Date_tbl IN PO_TBL_DATE

373:
374: PROCEDURE option_to_date_not_null (
375: p_line_id_tbl IN PO_TBL_NUMBER
376: , p_option_ind_tbl IN PO_TBL_VARCHAR1
377: ,p_option_to_Date_tbl IN PO_TBL_DATE
378: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
379: , x_result_type OUT NOCOPY VARCHAR2
380: );
381:

Line 385: ,p_option_from_date_tbl IN PO_TBL_DATE

381:
382: PROCEDURE option_to_date_le_from_date (
383: p_line_id_tbl IN PO_TBL_NUMBER
384: , p_option_ind_tbl IN PO_TBL_VARCHAR1
385: ,p_option_from_date_tbl IN PO_TBL_DATE
386: ,p_option_to_Date_tbl IN PO_TBL_DATE
387: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
388: , x_result_type OUT NOCOPY VARCHAR2
389: );

Line 386: ,p_option_to_Date_tbl IN PO_TBL_DATE

382: PROCEDURE option_to_date_le_from_date (
383: p_line_id_tbl IN PO_TBL_NUMBER
384: , p_option_ind_tbl IN PO_TBL_VARCHAR1
385: ,p_option_from_date_tbl IN PO_TBL_DATE
386: ,p_option_to_Date_tbl IN PO_TBL_DATE
387: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
388: , x_result_type OUT NOCOPY VARCHAR2
389: );
390:

Line 394: ,p_option_from_date_tbl IN PO_TBL_DATE

390:
391: PROCEDURE option_from_date_le_sysdate (
392: p_line_id_tbl IN PO_TBL_NUMBER
393: , p_option_ind_tbl IN PO_TBL_VARCHAR1
394: ,p_option_from_date_tbl IN PO_TBL_DATE
395: , p_draft_id_tbl IN PO_TBL_NUMBER
396: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
397: , x_result_type OUT NOCOPY VARCHAR2
398: );

Line 403: , p_option_from_date_tbl IN PO_TBL_DATE

399:
400: PROCEDURE option_fm_date_le_ex_date (
401: p_line_id_tbl IN PO_TBL_NUMBER
402: , p_exer_flag_tbl IN PO_TBL_VARCHAR1
403: , p_option_from_date_tbl IN PO_TBL_DATE
404: , p_option_exer_date_tbl IN PO_TBL_DATE
405: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
406: , x_result_type OUT NOCOPY VARCHAR2
407: );

Line 404: , p_option_exer_date_tbl IN PO_TBL_DATE

400: PROCEDURE option_fm_date_le_ex_date (
401: p_line_id_tbl IN PO_TBL_NUMBER
402: , p_exer_flag_tbl IN PO_TBL_VARCHAR1
403: , p_option_from_date_tbl IN PO_TBL_DATE
404: , p_option_exer_date_tbl IN PO_TBL_DATE
405: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
406: , x_result_type OUT NOCOPY VARCHAR2
407: );
408:

Line 432: , p_start_date_tbl IN PO_TBL_DATE

428: -- For Fed Fileds CLM
429: PROCEDURE order_start_date_le_end_date
430: (
431: p_line_id_tbl IN PO_TBL_NUMBER
432: , p_start_date_tbl IN PO_TBL_DATE
433: , p_expiration_date_tbl IN PO_TBL_DATE
434: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
435: , x_result_type OUT NOCOPY VARCHAR2
436: );

Line 433: , p_expiration_date_tbl IN PO_TBL_DATE

429: PROCEDURE order_start_date_le_end_date
430: (
431: p_line_id_tbl IN PO_TBL_NUMBER
432: , p_start_date_tbl IN PO_TBL_DATE
433: , p_expiration_date_tbl IN PO_TBL_DATE
434: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
435: , x_result_type OUT NOCOPY VARCHAR2
436: );
437:

Line 441: , p_order_from_date_tbl IN PO_TBL_DATE

437:
438: PROCEDURE order_start_date_gt_sysdate
439: (
440: p_line_id_tbl IN PO_TBL_NUMBER
441: , p_order_from_date_tbl IN PO_TBL_DATE
442: , p_draft_id_tbl IN PO_TBL_NUMBER
443: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
444: , x_result_type OUT NOCOPY VARCHAR2
445: );