[Home] [Help]
PACKAGE: APPS.PO_VAL_PRICE_DIFFS
Source
1 PACKAGE PO_VAL_PRICE_DIFFS AUTHID CURRENT_USER AS
2 -- $Header: PO_VAL_PRICE_DIFFS.pls 120.1 2006/08/16 22:46:04 dedelgad noship $
3
4 PROCEDURE max_mul_ge_zero(
5 p_price_differential_id_tbl IN PO_TBL_NUMBER
6 , p_max_multiplier_tbl IN PO_TBL_NUMBER
7 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
8 , x_result_type OUT NOCOPY VARCHAR2
9 );
10
11 PROCEDURE max_mul_ge_min_mul(
12 p_price_differential_id_tbl IN PO_TBL_NUMBER
13 , p_min_multiplier_tbl IN PO_TBL_NUMBER
14 , p_max_multiplier_tbl IN PO_TBL_NUMBER
15 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
16 , x_result_type OUT NOCOPY VARCHAR2
17 );
18
19 PROCEDURE min_mul_ge_zero(
20 p_price_differential_id_tbl IN PO_TBL_NUMBER
21 , p_min_multiplier_tbl IN PO_TBL_NUMBER
22 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
23 , x_result_type OUT NOCOPY VARCHAR2
24 );
25
26 PROCEDURE mul_ge_zero(
27 p_price_differential_id_tbl IN PO_TBL_NUMBER
28 , p_multiplier_tbl IN PO_TBL_NUMBER
29 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
30 , x_result_type OUT NOCOPY VARCHAR2
31 );
32
33 PROCEDURE unique_price_diff_num(
34 p_price_differential_id_tbl IN PO_TBL_NUMBER
35 , p_entity_id_tbl IN PO_TBL_NUMBER
36 , p_entity_type_tbl IN PO_TBL_VARCHAR30
37 , p_price_differential_num_tbl IN PO_TBL_NUMBER
38 , x_result_set_id IN OUT NOCOPY NUMBER
39 , x_result_type OUT NOCOPY VARCHAR2
40 );
41
42 PROCEDURE price_diff_num_gt_zero(
43 p_price_differential_id_tbl IN PO_TBL_NUMBER
44 , p_price_differential_num_tbl IN PO_TBL_NUMBER
45 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
46 , x_result_type OUT NOCOPY VARCHAR2
47 );
48
49 PROCEDURE unique_price_type(
50 p_price_differential_id_tbl IN PO_TBL_NUMBER
51 , p_entity_id_tbl IN PO_TBL_NUMBER
52 , p_entity_type_tbl IN PO_TBL_VARCHAR30
53 , p_price_type_tbl IN PO_TBL_VARCHAR30
54 , x_result_set_id IN OUT NOCOPY NUMBER
55 , x_result_type OUT NOCOPY VARCHAR2
56 );
57
58 PROCEDURE spo_price_type_on_src_doc(
59 p_price_differential_id_tbl IN PO_TBL_NUMBER
60 , p_entity_type_tbl IN PO_TBL_VARCHAR30
61 , p_from_line_location_id_tbl IN PO_TBL_NUMBER
62 , p_from_line_id_tbl IN PO_TBL_NUMBER
63 , p_price_type_tbl IN PO_TBL_VARCHAR30
64 , x_result_set_id IN OUT NOCOPY NUMBER
65 , x_result_type OUT NOCOPY VARCHAR2
66 );
67
68 PROCEDURE spo_mul_btwn_min_max(
69 p_price_differential_id_tbl IN PO_TBL_NUMBER
70 , p_entity_type_tbl IN PO_TBL_VARCHAR30
71 , p_from_line_location_id_tbl IN PO_TBL_NUMBER
72 , p_from_line_id_tbl IN PO_TBL_NUMBER
73 , p_multiplier_tbl IN PO_TBL_NUMBER
74 , p_price_type_tbl IN PO_TBL_VARCHAR30 --Bug 5415284
75 , x_result_set_id IN OUT NOCOPY NUMBER
76 , x_result_type OUT NOCOPY VARCHAR2
77 );
78
79 PROCEDURE spo_mul_ge_min(
80 p_price_differential_id_tbl IN PO_TBL_NUMBER
81 , p_entity_type_tbl IN PO_TBL_VARCHAR30
82 , p_from_line_location_id_tbl IN PO_TBL_NUMBER
83 , p_from_line_id_tbl IN PO_TBL_NUMBER
84 , p_multiplier_tbl IN PO_TBL_NUMBER
85 , p_price_type_tbl IN PO_TBL_VARCHAR30 --Bug 5415284
86 , x_result_set_id IN OUT NOCOPY NUMBER
87 , x_result_type OUT NOCOPY VARCHAR2
88 );
89
90 END PO_VAL_PRICE_DIFFS;