DBA Data[Home] [Help]

APPS.PO_VAL_SHIPMENTS dependencies on PO_TBL_DATE

Line 34: , p_need_by_date_tbl IN PO_TBL_DATE

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

Line 35: , p_promised_date_tbl IN PO_TBL_DATE

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: );

Line 62: , p_need_by_date_tbl IN PO_TBL_DATE

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: );

Line 72: , p_promised_date_tbl IN PO_TBL_DATE

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: );

Line 214: , p_start_date_tbl IN PO_TBL_DATE

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

Line 215: , p_end_date_tbl IN PO_TBL_DATE

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: );

Line 216: , p_need_by_date_tbl IN PO_TBL_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: );
220:

Line 224: , p_start_date_tbl IN PO_TBL_DATE

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: );

Line 225: , p_expiration_date_tbl IN PO_TBL_DATE

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: