1 PACKAGE PO_VAL_PRICE_DIFFS2 AS
2 -- $Header: PO_VAL_PRICE_DIFFS2.pls 120.3 2006/08/02 23:14:24 jinwang noship $
3
4
5 PROCEDURE price_type(p_id_tbl IN PO_TBL_NUMBER,
6 p_price_type_tbl IN PO_TBL_VARCHAR30,
7 x_result_set_id IN OUT NOCOPY NUMBER,
8 x_result_type OUT NOCOPY VARCHAR2);
9
10 PROCEDURE multiple_price_diff(p_id_tbl IN PO_TBL_NUMBER,
11 p_price_type_tbl IN PO_TBL_VARCHAR30,
12 p_entity_type_tbl IN PO_TBL_VARCHAR30,
13 p_entity_id_tbl IN PO_TBL_NUMBER,
14 x_result_set_id IN OUT NOCOPY NUMBER,
15 x_result_type OUT NOCOPY VARCHAR2);
16
17 PROCEDURE entity_type(p_id_tbl IN PO_TBL_NUMBER,
18 p_entity_type_tbl IN PO_TBL_VARCHAR30,
19 p_doc_type IN VARCHAR2,
20 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
21 x_result_type OUT NOCOPY VARCHAR2);
22
23 PROCEDURE multiplier(p_id_tbl IN PO_TBL_NUMBER,
24 p_entity_type_tbl IN PO_TBL_VARCHAR30,
25 p_multiplier_tbl IN PO_TBL_NUMBER,
26 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
27 x_result_type OUT NOCOPY VARCHAR2);
28
29 PROCEDURE min_multiplier(p_id_tbl IN PO_TBL_NUMBER,
30 p_entity_type_tbl IN PO_TBL_VARCHAR30,
31 p_min_multiplier_tbl IN PO_TBL_NUMBER,
32 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
33 x_result_type OUT NOCOPY VARCHAR2);
34
35 PROCEDURE max_multiplier(p_id_tbl IN PO_TBL_NUMBER,
36 p_entity_type_tbl IN PO_TBL_VARCHAR30,
37 p_max_multiplier_tbl IN PO_TBL_NUMBER,
38 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
39 x_result_type OUT NOCOPY VARCHAR2);
40
41 PROCEDURE style_related_info(p_id_tbl IN po_tbl_number,
42 p_style_id_tbl IN po_tbl_number,
43 x_result_set_id IN OUT NOCOPY NUMBER,
44 x_result_type OUT NOCOPY VARCHAR2);
45
46
47 END PO_VAL_PRICE_DIFFS2;