[Home] [Help]
PACKAGE: APPS.QP_PRICE_LIST_LINE_UTIL
Source
1 PACKAGE QP_Price_List_Line_Util AUTHID CURRENT_USER AS
2 /* $Header: QPXUPLLS.pls 120.3.12010000.1 2008/07/28 11:57:13 appldev ship $ */
3
4 -- Attributes global constants
5
6 G_ACCRUAL_QTY CONSTANT NUMBER := 1;
7 G_ACCRUAL_TYPE CONSTANT NUMBER := 2;
8 G_ACCRUAL_UOM CONSTANT NUMBER := 3;
9 G_ACCUM_TO_ACCR_CONV_RATE CONSTANT NUMBER := 4;
10 G_ARITHMETIC_OPERATOR CONSTANT NUMBER := 5;
11 G_ATTRIBUTE1 CONSTANT NUMBER := 6;
12 G_ATTRIBUTE10 CONSTANT NUMBER := 7;
13 G_ATTRIBUTE11 CONSTANT NUMBER := 8;
14 G_ATTRIBUTE12 CONSTANT NUMBER := 9;
15 G_ATTRIBUTE13 CONSTANT NUMBER := 10;
16 G_ATTRIBUTE14 CONSTANT NUMBER := 11;
17 G_ATTRIBUTE15 CONSTANT NUMBER := 12;
18 G_ATTRIBUTE2 CONSTANT NUMBER := 13;
19 G_ATTRIBUTE3 CONSTANT NUMBER := 14;
20 G_ATTRIBUTE4 CONSTANT NUMBER := 15;
21 G_ATTRIBUTE5 CONSTANT NUMBER := 16;
22 G_ATTRIBUTE6 CONSTANT NUMBER := 17;
23 G_ATTRIBUTE7 CONSTANT NUMBER := 18;
24 G_ATTRIBUTE8 CONSTANT NUMBER := 19;
25 G_ATTRIBUTE9 CONSTANT NUMBER := 20;
26 G_AUTOMATIC CONSTANT NUMBER := 21;
27 G_BASE_QTY CONSTANT NUMBER := 22;
28 G_BASE_UOM CONSTANT NUMBER := 23;
29 G_COMMENTS CONSTANT NUMBER := 24;
30 G_CONTEXT CONSTANT NUMBER := 25;
31 G_CREATED_BY CONSTANT NUMBER := 26;
32 G_CREATION_DATE CONSTANT NUMBER := 27;
33 G_EFFECTIVE_PERIOD_UOM CONSTANT NUMBER := 28;
34 G_END_DATE_ACTIVE CONSTANT NUMBER := 29;
35 G_ESTIM_ACCRUAL_RATE CONSTANT NUMBER := 30;
36 G_GENERATE_USING_FORMULA CONSTANT NUMBER := 31;
37 G_GL_CLASS CONSTANT NUMBER := 32;
38 G_INVENTORY_ITEM CONSTANT NUMBER := 33;
39 G_LAST_UPDATED_BY CONSTANT NUMBER := 34;
40 G_LAST_UPDATE_DATE CONSTANT NUMBER := 35;
41 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 36;
42 G_LIST_HEADER CONSTANT NUMBER := 37;
43 G_LIST_LINE CONSTANT NUMBER := 38;
44 G_LIST_LINE_TYPE CONSTANT NUMBER := 39;
45 G_LIST_PRICE CONSTANT NUMBER := 40;
46 G_LIST_PRICE_UOM CONSTANT NUMBER := 41;
47 G_MODIFIER_LEVEL CONSTANT NUMBER := 42;
48 G_NEW_PRICE CONSTANT NUMBER := 43;
49 G_NUMBER_EFFECTIVE_PERIODS CONSTANT NUMBER := 44;
50 G_OPERAND CONSTANT NUMBER := 45;
51 G_ORGANIZATION CONSTANT NUMBER := 46;
52 G_OVERRIDE CONSTANT NUMBER := 47;
53 G_PERCENT_PRICE CONSTANT NUMBER := 48;
54 G_PRICE_BREAK_TYPE CONSTANT NUMBER := 49;
55 G_PRICE_BY_FORMULA CONSTANT NUMBER := 50;
56 G_PRIMARY_UOM CONSTANT NUMBER := 51;
57 G_PRINT_ON_INVOICE CONSTANT NUMBER := 52;
58 G_PROGRAM_APPLICATION CONSTANT NUMBER := 53;
59 G_PROGRAM CONSTANT NUMBER := 54;
60 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 55;
61 G_REBATE_SUBTYPE CONSTANT NUMBER := 56;
62 G_REBATE_TRANSACTION_TYPE CONSTANT NUMBER := 57;
63 G_RELATED_ITEM CONSTANT NUMBER := 58;
64 G_RELATIONSHIP_TYPE CONSTANT NUMBER := 59;
65 G_REPRICE CONSTANT NUMBER := 60;
66 G_REQUEST CONSTANT NUMBER := 61;
67 G_REVISION CONSTANT NUMBER := 62;
68 G_REVISION_DATE CONSTANT NUMBER := 63;
69 G_REVISION_REASON CONSTANT NUMBER := 64;
70 G_START_DATE_ACTIVE CONSTANT NUMBER := 65;
71 G_SUBSTITUTION_ATTRIBUTE CONSTANT NUMBER := 66;
72 G_SUBSTITUTION_CONTEXT CONSTANT NUMBER := 67;
73 G_SUBSTITUTION_VALUE CONSTANT NUMBER := 68;
74 G_FROM_RLTD_MODIFIER CONSTANT NUMBER := 69;
75 G_RLTD_MODIFIER_GROUP_NO CONSTANT NUMBER := 70;
76 G_PRODUCT_PRECEDENCE CONSTANT NUMBER := 71;
77 G_QUALIFICATION_IND CONSTANT NUMBER := 72;
78 G_MAX_ATTR_ID CONSTANT NUMBER := 73;
79 G_RECURRING_VALUE CONSTANT NUMBER := 74; -- block pricing
80 G_CUSTOMER_ITEM_ID CONSTANT NUMBER := 75;
81 G_BREAK_UOM_CODE CONSTANT NUMBER := 76; -- OKS proration
82 G_BREAK_UOM_CONTEXT CONSTANT NUMBER := 77; -- OKS PRORATION
83 G_BREAK_UOM_ATTRIBUTE CONSTANT NUMBER := 78; -- OKS proration
84 G_CONTINUOUS_PRICE_BREAK_FLAG CONSTANT NUMBER := 79; -- Continuous Price Breaks
85
86 -- Procedure Clear_Dependent_Attr
87
88 PROCEDURE Clear_Dependent_Attr
89 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
90 , p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
91 , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
92 QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
93 , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
94 );
95
96 -- Procedure Apply_Attribute_Changes
97
98 PROCEDURE Apply_Attribute_Changes
99 ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
100 , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
101 QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
102 , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
103 );
104
105 -- Function Complete_Record
106
107 FUNCTION Complete_Record
108 ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
109 , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
110 ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type;
111
112 -- Function Convert_Miss_To_Null
113
114 FUNCTION Convert_Miss_To_Null
115 ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
116 ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type;
117
118 -- Procedure Update_Row
119
120 PROCEDURE Update_Row
121 ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
122 );
123
124 -- Procedure Insert_Row
125
126 PROCEDURE Insert_Row
127 ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
128 );
129
130 -- Procedure Delete_Row
131
132 PROCEDURE Delete_Row
133 ( p_list_line_id IN NUMBER
134 );
135
136 -- Function Query_Row
137
138 FUNCTION Query_Row
139 ( p_list_line_id IN NUMBER
140 ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type;
141
142 -- Function Query_Rows
143
144 --
145
146 FUNCTION Query_Rows
147 ( p_list_line_id IN NUMBER :=
148 FND_API.G_MISS_NUM
149 , p_list_header_id IN NUMBER :=
150 FND_API.G_MISS_NUM
151 ) RETURN QP_Price_List_PUB.Price_List_Line_Tbl_Type;
152
153 -- Procedure lock_Row
154 --
155
156 PROCEDURE Lock_Row
157 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
158 , p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
159 , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
160 );
161
162 -- Function Get_Values
163
164 FUNCTION Get_Values
165 ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
166 , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
167 QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
168 ) RETURN QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
169
170 -- Function Get_Ids
171
172 FUNCTION Get_Ids
173 ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
174 , p_PRICE_LIST_LINE_val_rec IN QP_Price_List_PUB.Price_List_Line_Val_Rec_Type
175 ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type;
176
177 Procedure Print_Price_List_Line
178 (p_PRICE_LIST_LINE_rec IN QP_PRICE_LIST_PUB.PRICE_LIST_LINE_REC_TYPE,
179 p_counter IN NUMBER);
180
181 FUNCTION get_qualifier_attr_value(p_qual_attr_value in varchar2)
182 return varchar2;
183
184 FUNCTION Get_Context(p_FlexField_Name IN VARCHAR2
185 ,p_context IN VARCHAR2)RETURN VARCHAR2;
186
187
188 FUNCTION Get_Attribute_Code(p_FlexField_Name IN VARCHAR2
189 ,p_Context_Name IN VARCHAR2
190 ,p_attribute IN VARCHAR2
191 ) return VARCHAR2;
192
193
194 FUNCTION Get_Item_Validate_Org_Value(p_pricing_attribute IN VARCHAR2
195 ,p_attr_value IN VARCHAR2
196 ) RETURN VARCHAR2;
197
198 FUNCTION Get_Attribute_Value(p_FlexField_Name IN VARCHAR2
199 ,p_Context_Name IN VARCHAR2
200 ,p_segment_name IN VARCHAR2
201 ,p_attr_value IN VARCHAR2
202 ) RETURN VARCHAR2;
203
204 FUNCTION Get_Product_Value(p_FlexField_Name IN VARCHAR2
205 ,p_Context_Name IN VARCHAR2
206 ,p_attribute_name IN VARCHAR2
207 ,p_attr_value IN VARCHAR2
208 ) RETURN VARCHAR2;
209
210 FUNCTION Get_Segment_Name(p_FlexField_Name IN VARCHAR2
211 ,p_Context_Name IN VARCHAR2
212 ,p_attribute IN VARCHAR2
213 ) return VARCHAR2;
214
215 FUNCTION Get_Product_Id(p_FlexField_Name IN VARCHAR2
216 ,p_Context_Name IN VARCHAR2
217 ,p_attribute IN VARCHAR2
218 ,p_attr_value IN VARCHAR2) RETURN NUMBER;
219
220
221 END QP_Price_List_Line_Util;