1 PACKAGE OZF_VOLUME_OFFER_ADJ AS
2 /* $Header: ozfvvads.pls 120.1 2006/03/29 17:58 rssharma noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_VOLUME_OFFER_ADJ
7 -- Purpose
8 --
9 -- History
10 -- Tue Mar 14 2006:4/40 PM RSSHARMA Created
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15 PROCEDURE adjust_old_discounts
16 (
17 x_return_status OUT NOCOPY VARCHAR2
18 ,x_msg_count OUT NOCOPY NUMBER
19 ,x_msg_data OUT NOCOPY VARCHAR2
20 ,p_offerAdjustmentId IN NUMBER
21 );
22
23 PROCEDURE adjust_new_products
24 (
25 x_return_status OUT NOCOPY VARCHAR2
26 ,x_msg_count OUT NOCOPY NUMBER
27 ,x_msg_data OUT NOCOPY VARCHAR2
28 ,p_offerAdjustmentId IN NUMBER
29 );
30
31 PROCEDURE process_vo_adjustments
32 (
33 p_init_msg_list IN VARCHAR2 := FND_API.g_false
34 ,p_api_version IN NUMBER
35 ,p_commit IN VARCHAR2 := FND_API.g_false
36 ,x_return_status OUT NOCOPY VARCHAR2
37 ,x_msg_count OUT NOCOPY NUMBER
38 ,x_msg_data OUT NOCOPY VARCHAR2
39 ,p_offerAdjustmentId IN NUMBER
40 );
41 ----------------------------------------New temp procedures to ber deleted
42 PROCEDURE update_adj_vo_tiers
43 (
44 x_return_status OUT NOCOPY VARCHAR2
45 ,x_msg_count OUT NOCOPY NUMBER
46 ,x_msg_data OUT NOCOPY VARCHAR2
47 ,p_offerAdjustmentId IN NUMBER
48 );
49 PROCEDURE end_date_qp_lines
50 (
51 x_return_status OUT NOCOPY VARCHAR2
52 ,x_msg_count OUT NOCOPY NUMBER
53 ,x_msg_data OUT NOCOPY VARCHAR2
54 ,p_offerAdjustmentId IN NUMBER
55 );
56 PROCEDURE end_qp_line
57 (
58 x_return_status OUT NOCOPY VARCHAR2
59 ,x_msg_count OUT NOCOPY NUMBER
60 ,x_msg_data OUT NOCOPY VARCHAR2
61 ,p_listLineId IN NUMBER
62 ,p_offerAdjustmentId IN NUMBER
63 );
64
65 PROCEDURE populate_modifier_lines
66 (
67 x_return_status OUT NOCOPY VARCHAR2
68 , x_msg_count OUT NOCOPY NUMBER
69 , x_msg_data OUT NOCOPY VARCHAR2
70 , p_listLineId IN NUMBER
71 , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
72 , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
73 , p_offerAdjustmentId IN NUMBER
74 );
75
76 PROCEDURE create_new_qp_lines
77 (
78 x_return_status OUT NOCOPY VARCHAR2
79 ,x_msg_count OUT NOCOPY NUMBER
80 ,x_msg_data OUT NOCOPY VARCHAR2
81 ,p_offerAdjustmentId IN NUMBER
82 , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
83 , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
84 );
85 PROCEDURE create_modifier_from_line
86 (
87 x_return_status OUT NOCOPY VARCHAR2
88 , x_msg_count OUT NOCOPY NUMBER
89 , x_msg_data OUT NOCOPY VARCHAR2
90 , p_offerAdjustmentId IN NUMBER
91 , p_listLineId IN NUMBER
92 , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
93 , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
94 );
95 PROCEDURE create_new_products
96 (
97 x_return_status OUT NOCOPY VARCHAR2
98 ,x_msg_count OUT NOCOPY NUMBER
99 ,x_msg_data OUT NOCOPY VARCHAR2
100 ,p_offerAdjustmentId IN NUMBER
101 );
102 PROCEDURE create_new_qp_products
103 (
104 x_return_status OUT NOCOPY VARCHAR2
105 ,x_msg_count OUT NOCOPY NUMBER
106 ,x_msg_data OUT NOCOPY VARCHAR2
107 ,p_offerAdjustmentId IN NUMBER
108 , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
109 , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
110 );
111
112 PROCEDURE create_new_exclusions
113 (
114 p_offDiscountProductId IN NUMBER
115 , x_return_status OUT NOCOPY VARCHAR2
116 , x_msg_count OUT NOCOPY NUMBER
117 , x_msg_data OUT NOCOPY VARCHAR2
118 );
119 PROCEDURE relate_lines
120 (
121 p_from_list_line_id IN NUMBER
122 , p_to_list_line_id IN NUMBER
123 , p_offer_adjustment_id IN NUMBER
124 , x_return_status OUT NOCOPY VARCHAR2
125 , x_msg_count OUT NOCOPY NUMBER
126 , x_msg_data OUT NOCOPY VARCHAR2
127 );
128 PROCEDURE populate_discounts
129 (
130 x_modifiers_rec IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type
131 , p_list_line_id IN NUMBER
132 );
133 PROCEDURE populate_pricing_attributes
134 (
135 x_pricing_attr_tbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
136 , p_list_line_id IN NUMBER
137 , p_index IN NUMBER
138 );
139 PROCEDURE merge_pricing_attributes
140 (
141 px_to_pricing_attr_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
142 , p_from_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
143 );
144 PROCEDURE merge_modifiers
145 (
146 px_to_modifier_line_tbl IN OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
147 , p_from_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
148 );
149 PROCEDURE populate_pbh_line
150 (
151 x_return_status OUT NOCOPY VARCHAR2
152 , x_msg_count OUT NOCOPY NUMBER
153 , x_msg_data OUT NOCOPY VARCHAR2
154 , p_listLineId IN NUMBER
155 , x_modifier_line_tbl OUT NOCOPY QP_MODIFIERS_PUB.Modifiers_Tbl_Type
156 , x_pricing_attr_tbl OUT NOCOPY QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
157 );
158 PROCEDURE relate_lines
159 (
160 p_modifiers_tbl IN qp_modifiers_pub.modifiers_tbl_type
161 , p_offer_adjustment_id IN NUMBER
162 , x_return_status OUT NOCOPY VARCHAR2
163 , x_msg_count OUT NOCOPY NUMBER
164 , x_msg_data OUT NOCOPY VARCHAR2
165 );
166 END OZF_VOLUME_OFFER_ADJ;
167