30: );
31:
32: PROCEDURE planned_item_null_date_check (
33: p_line_loc_id_tbl IN PO_TBL_NUMBER
34: , p_need_by_date_tbl IN PO_TBL_DATE
35: , p_promised_date_tbl IN PO_TBL_DATE
36: , p_item_id_tbl IN PO_TBL_NUMBER
37: , x_result_set_id IN OUT NOCOPY NUMBER
38: , x_result_type OUT NOCOPY VARCHAR2
31:
32: PROCEDURE planned_item_null_date_check (
33: p_line_loc_id_tbl IN PO_TBL_NUMBER
34: , p_need_by_date_tbl IN PO_TBL_DATE
35: , p_promised_date_tbl IN PO_TBL_DATE
36: , p_item_id_tbl IN PO_TBL_NUMBER
37: , x_result_set_id IN OUT NOCOPY NUMBER
38: , x_result_type OUT NOCOPY VARCHAR2
39: );
58: --PBWC Message Change Impact: Adding a token
59: PROCEDURE need_by_date_open_period_check(
60: p_line_loc_id_tbl IN PO_TBL_NUMBER
61: , p_line_id_tbl IN PO_TBL_NUMBER
62: , p_need_by_date_tbl IN PO_TBL_DATE
63: , p_org_id_tbl IN PO_TBL_NUMBER
64: , x_result_set_id IN OUT NOCOPY NUMBER
65: , x_result_type OUT NOCOPY VARCHAR2
66: );
68: --PBWC Message Change Impact: Adding a token
69: PROCEDURE promise_date_open_period_check(
70: p_line_loc_id_tbl IN PO_TBL_NUMBER
71: , p_line_id_tbl IN PO_TBL_NUMBER
72: , p_promised_date_tbl IN PO_TBL_DATE
73: , p_org_id_tbl IN PO_TBL_NUMBER
74: , x_result_set_id IN OUT NOCOPY NUMBER
75: , x_result_type OUT NOCOPY VARCHAR2
76: );
210:
211: PROCEDURE pop_date_need_by_date
212: (
213: p_line_id_tbl IN PO_TBL_NUMBER
214: , p_start_date_tbl IN PO_TBL_DATE
215: , p_end_date_tbl IN PO_TBL_DATE
216: , p_need_by_date_tbl IN PO_TBL_DATE
217: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
218: , x_result_type OUT NOCOPY VARCHAR2
211: PROCEDURE pop_date_need_by_date
212: (
213: p_line_id_tbl IN PO_TBL_NUMBER
214: , p_start_date_tbl IN PO_TBL_DATE
215: , p_end_date_tbl IN PO_TBL_DATE
216: , p_need_by_date_tbl IN PO_TBL_DATE
217: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
218: , x_result_type OUT NOCOPY VARCHAR2
219: );
212: (
213: p_line_id_tbl IN PO_TBL_NUMBER
214: , p_start_date_tbl IN PO_TBL_DATE
215: , p_end_date_tbl IN PO_TBL_DATE
216: , p_need_by_date_tbl IN PO_TBL_DATE
217: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
218: , x_result_type OUT NOCOPY VARCHAR2
219: );
220:
220:
221: PROCEDURE pop_start_date_le_end_date
222: (
223: p_line_id_tbl IN PO_TBL_NUMBER
224: , p_start_date_tbl IN PO_TBL_DATE
225: , p_expiration_date_tbl IN PO_TBL_DATE
226: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
227: , x_result_type OUT NOCOPY VARCHAR2
228: );
221: PROCEDURE pop_start_date_le_end_date
222: (
223: p_line_id_tbl IN PO_TBL_NUMBER
224: , p_start_date_tbl IN PO_TBL_DATE
225: , p_expiration_date_tbl IN PO_TBL_DATE
226: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
227: , x_result_type OUT NOCOPY VARCHAR2
228: );
229: