1 PACKAGE PO_PRICE_DIFFERENTIALS_PVT AS
2 /* $Header: POXVPDFS.pls 120.1 2005/08/31 06:58:57 arudas noship $*/
3
4 g_pkg_name CONSTANT VARCHAR2(30) := 'PO_PRICE_DIFFERENTIALS_PVT';
5 FUNCTION allows_price_differentials
6 ( p_req_line_id IN NUMBER
7 ) RETURN BOOLEAN;
8
9 FUNCTION check_unique_price_diff_num
10 ( p_row_id IN ROWID
11 , p_entity_type IN VARCHAR2
12 , p_entity_id IN NUMBER
13 , p_price_differential_num IN NUMBER
14 ) RETURN BOOLEAN;
15
16 FUNCTION check_unique_price_type ( p_row_id IN ROWID
17 , p_entity_type IN VARCHAR2
18 , p_entity_id IN NUMBER
19 , p_price_type IN VARCHAR2
20 ) RETURN BOOLEAN;
21
22 PROCEDURE copy_price_differentials( p_from_entity_type IN VARCHAR2
23 , p_from_entity_id IN NUMBER
24 , p_to_entity_type IN VARCHAR2
25 , p_to_entity_id IN NUMBER
26 );
27
28 PROCEDURE create_from_interface ( p_entity_id IN NUMBER
29 , p_interface_line_id IN NUMBER
30 );
31
32 PROCEDURE default_price_differentials
33 ( p_from_entity_type IN VARCHAR2
34 , p_from_entity_id IN NUMBER
35 , p_to_entity_type IN VARCHAR2
36 , p_to_entity_id IN NUMBER
37 );
38
39 PROCEDURE delete_price_differentials
40 ( p_entity_type IN VARCHAR2
41 , p_entity_id IN VARCHAR2
42 );
43
44 PROCEDURE get_context ( p_entity_type IN VARCHAR2
45 , p_entity_id IN NUMBER
46 , x_line_num OUT NOCOPY NUMBER
47 , x_price_break_num OUT NOCOPY NUMBER
48 , x_job_name OUT NOCOPY VARCHAR2
49 , x_job_description OUT NOCOPY VARCHAR2
50 );
51
52 FUNCTION get_max_price_diff_num ( p_entity_type IN VARCHAR2
53 , p_entity_id IN NUMBER
54 ) RETURN NUMBER;
55
56 PROCEDURE get_min_max_multiplier ( p_entity_type IN VARCHAR2
57 , p_entity_id IN NUMBER
58 , p_price_type IN VARCHAR2
59 , x_min_multiplier OUT NOCOPY NUMBER
60 , x_max_multiplier OUT NOCOPY NUMBER
61 );
62
63 FUNCTION has_price_differentials ( p_entity_type IN VARCHAR2
64 , p_entity_id IN NUMBER
65 ) RETURN BOOLEAN;
66
67 FUNCTION is_price_type_enabled ( p_price_type IN VARCHAR2
68 , p_entity_type IN VARCHAR2
69 , p_entity_id IN NUMBER
70 ) RETURN BOOLEAN;
71
72 PROCEDURE setup_interface_table ( p_entity_type IN VARCHAR2
73 , p_interface_header_id IN NUMBER
74 , p_interface_line_id IN NUMBER
75 , p_req_line_id IN NUMBER
76 , p_from_line_id IN NUMBER
77 , p_price_break_id IN NUMBER
78 );
79
80 PROCEDURE validate_price_differentials(
81 p_interface_header_id IN NUMBER,
82 p_interface_line_id IN NUMBER,
83 p_entity_type IN VARCHAR2,
84 p_entity_id IN NUMBER,
85 p_header_processable_flag IN VARCHAR2
86 );
87
88 PROCEDURE get_price_for_price_type
89 (
90 p_entity_id IN NUMBER
91 , p_entity_type IN VARCHAR2
92 , p_price_type IN VARCHAR2
93 , x_price OUT NOCOPY NUMBER
94 );
95
96 --<HTML Agreements R12 Start>
97 FUNCTION get_entity_type( p_doc_level IN VARCHAR2
98 ,p_doc_level_id IN NUMBER)
99 RETURN VARCHAR2;
100 --<HTML Agreements R12 End>
101 END PO_PRICE_DIFFERENTIALS_PVT;