DBA Data[Home] [Help]

PACKAGE: APPS.PO_VAL_PRICE_BREAKS

Source


1 PACKAGE PO_VAL_PRICE_BREAKS 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
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 
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 
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 
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 
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 
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 
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 
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 
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 
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 
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 
92 END PO_VAL_PRICE_BREAKS;