2: -- $Header: PO_VAL_PRICE_BREAKS.pls 120.0 2005/06/02 02:14:33 appldev noship $
3:
4: PROCEDURE at_least_one_required_field(
5: p_line_loc_id_tbl IN PO_TBL_NUMBER
6: , p_start_date_tbl IN PO_TBL_DATE
7: , p_end_date_tbl IN PO_TBL_DATE
8: , p_quantity_tbl IN PO_TBL_NUMBER
9: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
10: , p_ship_to_loc_id_tbl IN PO_TBL_NUMBER
3:
4: PROCEDURE at_least_one_required_field(
5: p_line_loc_id_tbl IN PO_TBL_NUMBER
6: , p_start_date_tbl IN PO_TBL_DATE
7: , p_end_date_tbl IN PO_TBL_DATE
8: , p_quantity_tbl IN PO_TBL_NUMBER
9: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
10: , p_ship_to_loc_id_tbl IN PO_TBL_NUMBER
11: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
34: );
35:
36: PROCEDURE start_date_le_end_date(
37: p_line_loc_id_tbl IN PO_TBL_NUMBER
38: , p_start_date_tbl IN PO_TBL_DATE
39: , p_end_date_tbl IN PO_TBL_DATE
40: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
41: , x_result_type OUT NOCOPY VARCHAR2
42: );
35:
36: PROCEDURE start_date_le_end_date(
37: p_line_loc_id_tbl IN PO_TBL_NUMBER
38: , p_start_date_tbl IN PO_TBL_DATE
39: , p_end_date_tbl IN PO_TBL_DATE
40: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
41: , x_result_type OUT NOCOPY VARCHAR2
42: );
43:
42: );
43:
44: PROCEDURE break_start_ge_blanket_start(
45: p_line_loc_id_tbl IN PO_TBL_NUMBER
46: , p_blanket_start_date_tbl IN PO_TBL_DATE
47: , p_price_break_start_date_tbl IN PO_TBL_DATE
48: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
49: , x_result_type OUT NOCOPY VARCHAR2
50: );
43:
44: PROCEDURE break_start_ge_blanket_start(
45: p_line_loc_id_tbl IN PO_TBL_NUMBER
46: , p_blanket_start_date_tbl IN PO_TBL_DATE
47: , p_price_break_start_date_tbl IN PO_TBL_DATE
48: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
49: , x_result_type OUT NOCOPY VARCHAR2
50: );
51:
50: );
51:
52: PROCEDURE break_start_le_blanket_end(
53: p_line_loc_id_tbl IN PO_TBL_NUMBER
54: , p_blanket_end_date_tbl IN PO_TBL_DATE
55: , p_price_break_start_date_tbl IN PO_TBL_DATE
56: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
57: , x_result_type OUT NOCOPY VARCHAR2
58: );
51:
52: PROCEDURE break_start_le_blanket_end(
53: p_line_loc_id_tbl IN PO_TBL_NUMBER
54: , p_blanket_end_date_tbl IN PO_TBL_DATE
55: , p_price_break_start_date_tbl IN PO_TBL_DATE
56: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
57: , x_result_type OUT NOCOPY VARCHAR2
58: );
59:
58: );
59:
60: PROCEDURE break_start_le_expiration(
61: p_line_loc_id_tbl IN PO_TBL_NUMBER
62: , p_expiration_date_tbl IN PO_TBL_DATE
63: , p_price_break_start_date_tbl IN PO_TBL_DATE
64: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
65: , x_result_type OUT NOCOPY VARCHAR2
66: );
59:
60: PROCEDURE break_start_le_expiration(
61: p_line_loc_id_tbl IN PO_TBL_NUMBER
62: , p_expiration_date_tbl IN PO_TBL_DATE
63: , p_price_break_start_date_tbl IN PO_TBL_DATE
64: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
65: , x_result_type OUT NOCOPY VARCHAR2
66: );
67:
66: );
67:
68: PROCEDURE break_end_le_expiration(
69: p_line_loc_id_tbl IN PO_TBL_NUMBER
70: , p_expiration_date_tbl IN PO_TBL_DATE
71: , p_price_break_end_date_tbl IN PO_TBL_DATE
72: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
73: , x_result_type OUT NOCOPY VARCHAR2
74: );
67:
68: PROCEDURE break_end_le_expiration(
69: p_line_loc_id_tbl IN PO_TBL_NUMBER
70: , p_expiration_date_tbl IN PO_TBL_DATE
71: , p_price_break_end_date_tbl IN PO_TBL_DATE
72: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
73: , x_result_type OUT NOCOPY VARCHAR2
74: );
75:
74: );
75:
76: PROCEDURE break_end_ge_blanket_start(
77: p_line_loc_id_tbl IN PO_TBL_NUMBER
78: , p_blanket_start_date_tbl IN PO_TBL_DATE
79: , p_price_break_end_date_tbl IN PO_TBL_DATE
80: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
81: , x_result_type OUT NOCOPY VARCHAR2
82: );
75:
76: PROCEDURE break_end_ge_blanket_start(
77: p_line_loc_id_tbl IN PO_TBL_NUMBER
78: , p_blanket_start_date_tbl IN PO_TBL_DATE
79: , p_price_break_end_date_tbl IN PO_TBL_DATE
80: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
81: , x_result_type OUT NOCOPY VARCHAR2
82: );
83:
82: );
83:
84: PROCEDURE break_end_le_blanket_end(
85: p_line_loc_id_tbl IN PO_TBL_NUMBER
86: , p_blanket_end_date_tbl IN PO_TBL_DATE
87: , p_price_break_end_date_tbl IN PO_TBL_DATE
88: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
89: , x_result_type OUT NOCOPY VARCHAR2
90: );
83:
84: PROCEDURE break_end_le_blanket_end(
85: p_line_loc_id_tbl IN PO_TBL_NUMBER
86: , p_blanket_end_date_tbl IN PO_TBL_DATE
87: , p_price_break_end_date_tbl IN PO_TBL_DATE
88: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
89: , x_result_type OUT NOCOPY VARCHAR2
90: );
91: