1 PACKAGE QP_Delayed_Requests_UTIL AUTHID CURRENT_USER AS
2 /* $Header: QPXUREQS.pls 120.4.12010000.1 2008/07/28 11:57:47 appldev ship $ */
3
4 Procedure Check_For_Duplicate_Qualifiers
5 ( x_return_status OUT NOCOPY Varchar2
6 , p_qualifier_rule_id IN NUMBER
7 );
8
9 Procedure Validate_lines_For_child
10 ( x_return_status OUT NOCOPY Varchar2
11 , p_list_line_type_code VARCHAR2
12 , p_list_line_id IN NUMBER
13 );
14
15 Procedure Maintain_List_Header_Phases
16 ( p_List_Header_ID IN NUMBER
17 , x_return_status OUT NOCOPY VARCHAR2
18 );
19
20 Procedure Check_For_Overlapping_breaks
21 ( x_return_status OUT NOCOPY Varchar2
22 , p_list_line_id IN NUMBER
23 );
24
25 --Added for continuous Price Breaks validation
26 Procedure Check_Continuous_Price_Breaks
27 ( x_return_status OUT NOCOPY Varchar2
28 , p_list_line_id IN NUMBER
29 );
30
31 --Added for upgrading non-continuous price breaks
32 Procedure Upgrade_Price_Breaks
33 ( x_return_status OUT NOCOPY Varchar2
34 , p_pbh_id IN NUMBER
35 , p_list_line_no IN VARCHAR2
36 , p_product_attribute IN VARCHAR2
37 , p_product_attr_value IN VARCHAR2
38 , p_list_type IN VARCHAR2
39 , p_start_date_active IN VARCHAR2
40 , p_end_date_active IN VARCHAR2
41 );
42
43 Procedure Check_Mult_Price_Break_Attrs
44 ( x_return_status OUT NOCOPY VARCHAR2
45 , p_parent_list_line_id IN NUMBER
46 );
47
48 Procedure Check_Mixed_Qual_Seg_Levels
49 ( x_return_status OUT NOCOPY VARCHAR2
50 , p_qualifier_rule_id IN NUMBER
51 );
52
53 Procedure Check_multiple_prl
54 ( x_return_status OUT NOCOPY Varchar2
55 , p_list_header_id IN NUMBER
56 );
57 -- start bug2091362
58 Procedure Check_Duplicate_Modifier_Lines
59 ( p_Start_Date_Active IN DATE
60 , p_End_Date_Active IN DATE
61 , p_List_Line_ID IN NUMBER
62 , p_List_Header_ID IN NUMBER
63 , p_pricing_attribute_context IN VARCHAR2
64 , p_pricing_attribute IN VARCHAR2
65 , p_Pricing_attr_value IN VARCHAR2
66 , x_return_status OUT NOCOPY VARCHAR2
67 );
68 -- end bug2091362
69
70
71 Procedure Check_Duplicate_List_Lines
72 ( p_Start_Date_Active IN DATE
73 , p_End_Date_Active IN DATE
74 , p_Revision IN VARCHAR2
75 , p_List_Line_ID IN NUMBER
76 , p_List_Header_ID IN NUMBER
77 , x_return_status OUT NOCOPY VARCHAR2
78 , x_dup_sdate OUT NOCOPY DATE
79 , x_dup_edate OUT NOCOPY DATE
80 ) ;
81
82 Procedure Maintain_Qualifier_Den_Cols
83 ( x_return_status OUT NOCOPY Varchar2
84 , p_list_header_id IN NUMBER
85 );
86
87 Procedure Maintain_Factor_List_Attrs
88 ( x_return_status OUT NOCOPY Varchar2
89 , p_list_line_id IN NUMBER
90 );
91
92 Procedure Update_List_Qualification_Ind
93 ( x_return_status OUT NOCOPY Varchar2
94 , p_list_header_id IN NUMBER
95 );
96
97 Procedure Update_Limits_Columns
98 ( p_Limit_Id IN NUMBER
99 ,x_return_status OUT NOCOPY Varchar2
100 );
101
102 Procedure Update_Line_Qualification_Ind
103 ( x_return_status OUT NOCOPY Varchar2
104 , p_list_line_id IN NUMBER
105 );
106
107 Procedure Update_Child_Break_Lines
108 ( x_return_status OUT NOCOPY Varchar2
109 , p_list_line_id IN NUMBER
110 );
111
112
113 /*added by spgopal for including list_header_id and pricing_phase_id in pricing_
114 attributes table for modifiers*/
115
116 Procedure Update_Pricing_Attr_Phase
117 ( x_return_status OUT NOCOPY Varchar2
118 , p_list_line_id IN NUMBER
119 );
120
121 /*added by spgopal for updating denormalised info on pricing_phases about line_group, oid and rltd lines for modifiers in that phase*/
122
123 Procedure Update_Pricing_Phase
124 ( x_return_status OUT NOCOPY Varchar2
125 , p_pricing_phase_id IN NUMBER
126 , p_automatic_flag IN Varchar2 --fix for bug 3756625
127 , p_count IN NUMBER
128 , p_call_from IN NUMBER
129 );
130
131
132 --Essilor Fix bug 2789138
133 Procedure Update_manual_modifier_flag
134 ( x_return_status OUT NOCOPY Varchar2
135 , p_automatic_flag IN Varchar2
136 , p_pricing_phase_id IN NUMBER
137 );
138
139
140 Procedure Validate_Selling_Rounding
141 ( x_return_status OUT NOCOPY Varchar2
142 , p_currency_header_id IN NUMBER
143 , p_to_currency_code IN VARCHAR2
144 );
145
146
147 Procedure Check_Segment_Level_in_Group
148 ( x_return_status OUT NOCOPY Varchar2
149 , p_list_line_id IN NUMBER
150 , p_list_header_id IN NUMBER
151 , p_qualifier_grouping_no IN NUMBER
152 );
153
154 Procedure Check_Line_for_Header_Qual
155 ( x_return_status OUT NOCOPY Varchar2
156 , p_list_line_id IN NUMBER
157 , p_list_header_id IN NUMBER
158 );
159
160 /*included as a fix for bug 1501138 - spgopal*/
161
162 /*
163 Procedure Warn_Same_Qualifier_Group
164 ( x_return_status OUT NOCOPY Varchar2
165 , p_List_Header_ID IN NUMBER
166 , p_List_Line_ID IN NUMBER
167 , p_Qualifier_Grouping_No IN NUMBER
168 , p_Qualifier_Context IN NUMBER
169 , p_Qualifier_Attribute IN NUMBER
170 );
171 */
172
173 --hw
174 procedure update_changed_lines_add (
175 p_list_line_id in number,
176 p_list_header_id in number,
177 p_pricing_phase_id in number,
178 x_return_status out NOCOPY varchar2);
179
180 procedure update_changed_lines_del (
181 p_list_line_id in number,
182 p_list_header_id in number,
183 p_pricing_phase_id in number,
184 p_product_attribute in varchar2,
185 p_product_attr_value in varchar2,
186 x_return_status out NOCOPY varchar2);
187
188 procedure update_changed_lines_ph (
189 p_list_line_id in number,
190 p_list_header_id in number,
191 p_pricing_phase_id in number,
192 p_old_pricing_phase_id in number,
193 x_return_status out NOCOPY varchar2
194 );
195
196 procedure update_changed_lines_act (
197 p_list_header_id in number,
198 p_active_flag varchar2,
199 x_return_status out NOCOPY varchar2
200 );
201
202 Procedure Update_Qualifier_Status(p_list_header_id in NUMBER,
203 p_active_flag in VARCHAR2,
204 x_return_status OUT NOCOPY VARCHAR2);
205
206 Procedure Create_Security_Privilege(p_list_header_id in NUMBER,
207 p_list_type_code in VARCHAR2,
208 x_return_status OUT NOCOPY VARCHAR2);
209
210 Procedure Update_Attribute_Status(p_list_header_id in NUMBER,
211 p_list_line_id in NUMBER,
212 p_context_type in VARCHAR2,
213 p_context_code in VARCHAR2,
214 p_segment_mapping_column VARCHAR2,
215 x_return_status OUT NOCOPY VARCHAR2);
216
217 --pattern
218 Procedure Maintain_header_pattern(p_list_header_id in number,
219 p_qualifier_group in number,
220 p_setup_action in varchar2,
221 x_return_status out NOCOPY varchar2);
222 Procedure Maintain_line_pattern(p_list_header_id in number,
223 p_list_line_id in number,
224 p_qualifier_group in number,
225 p_setup_action in varchar2,
226 x_return_status out NOCOPY varchar2);
227 Procedure Maintain_product_pattern(p_list_header_id in number,
228 p_list_line_id in number,
229 p_setup_action in varchar2,
230 x_return_status out NOCOPY varchar2);
231 --pattern
232
233 PROCEDURE UPDATE_CHILD_PRICING_ATTR
234 ( x_return_status OUT NOCOPY Varchar2
235 , p_list_line_id IN NUMBER);
236
237 Procedure HVOP_Pricing_Setup (x_return_status OUT NOCOPY VARCHAR2);
238
239 -- Hierarchical Categories
240 PROCEDURE Check_Enabled_Func_Areas(p_pte_source_system_id IN NUMBER,
241 x_return_status OUT NOCOPY VARCHAR2);
242
243 END;