APPS.PO_VAL_PRICE_BREAKS dependencies on PO_TBL_NUMBER

Line 5: p_line_loc_id_tbl IN PO_TBL_NUMBER

1: PACKAGE PO_VAL_PRICE_BREAKS AUTHID CURRENT_USER AS
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

Line 8: , p_quantity_tbl IN PO_TBL_NUMBER

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
12: , x_result_type OUT NOCOPY VARCHAR2

Line 9: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER

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
12: , x_result_type OUT NOCOPY VARCHAR2
13: );

Line 10: , p_ship_to_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
12: , x_result_type OUT NOCOPY VARCHAR2
13: );
14:

Line 16: p_line_loc_id_tbl IN PO_TBL_NUMBER

12: , x_result_type OUT NOCOPY VARCHAR2
13: );
14:
15: PROCEDURE price_discount_in_percent(
16: p_line_loc_id_tbl IN PO_TBL_NUMBER
17: , p_price_discount_tbl IN PO_TBL_NUMBER
18: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
19: , x_result_type OUT NOCOPY VARCHAR2
20: );

Line 17: , p_price_discount_tbl IN PO_TBL_NUMBER

13: );
14:
15: PROCEDURE price_discount_in_percent(
16: p_line_loc_id_tbl IN PO_TBL_NUMBER
17: , p_price_discount_tbl IN PO_TBL_NUMBER
18: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
19: , x_result_type OUT NOCOPY VARCHAR2
20: );
21:

Line 23: p_line_loc_id_tbl IN PO_TBL_NUMBER

19: , x_result_type OUT NOCOPY VARCHAR2
20: );
21:
22: PROCEDURE price_override_gt_zero(
23: p_line_loc_id_tbl IN PO_TBL_NUMBER
24: , p_price_override_tbl IN PO_TBL_NUMBER
25: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
26: , x_result_type OUT NOCOPY VARCHAR2
27: );

Line 24: , p_price_override_tbl IN PO_TBL_NUMBER

20: );
21:
22: PROCEDURE price_override_gt_zero(
23: p_line_loc_id_tbl IN PO_TBL_NUMBER
24: , p_price_override_tbl IN PO_TBL_NUMBER
25: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
26: , x_result_type OUT NOCOPY VARCHAR2
27: );
28:

Line 30: p_line_loc_id_tbl IN PO_TBL_NUMBER

26: , x_result_type OUT NOCOPY VARCHAR2
27: );
28:
29: PROCEDURE quantity_ge_zero(
30: p_line_loc_id_tbl IN PO_TBL_NUMBER
31: , p_quantity_tbl IN PO_TBL_NUMBER
32: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
33: , x_result_type OUT NOCOPY VARCHAR2
34: );

Line 31: , p_quantity_tbl IN PO_TBL_NUMBER

27: );
28:
29: PROCEDURE quantity_ge_zero(
30: p_line_loc_id_tbl IN PO_TBL_NUMBER
31: , p_quantity_tbl IN PO_TBL_NUMBER
32: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
33: , x_result_type OUT NOCOPY VARCHAR2
34: );
35:

Line 37: p_line_loc_id_tbl IN PO_TBL_NUMBER

33: , x_result_type OUT NOCOPY VARCHAR2
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

Line 45: p_line_loc_id_tbl IN PO_TBL_NUMBER

41: , x_result_type OUT NOCOPY VARCHAR2
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

Line 53: p_line_loc_id_tbl IN PO_TBL_NUMBER

49: , x_result_type OUT NOCOPY VARCHAR2
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

Line 61: p_line_loc_id_tbl IN PO_TBL_NUMBER

57: , x_result_type OUT NOCOPY VARCHAR2
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

Line 69: p_line_loc_id_tbl IN PO_TBL_NUMBER

65: , x_result_type OUT NOCOPY VARCHAR2
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

Line 77: p_line_loc_id_tbl IN PO_TBL_NUMBER

73: , x_result_type OUT NOCOPY VARCHAR2
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

Line 85: p_line_loc_id_tbl IN PO_TBL_NUMBER

81: , x_result_type OUT NOCOPY VARCHAR2
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