eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.OE_LINE_PATTR_UTIL

Source


1 PACKAGE OE_Line_PAttr_Util AUTHID CURRENT_USER AS
2 /* $Header: OEXULPAS.pls 120.0.12020000.1 2012/06/26 09:38:06 appldev ship $ */
3 
4 G_ATTRIBUTE1                  CONSTANT NUMBER := 1;
5 G_ATTRIBUTE10                 CONSTANT NUMBER := 2;
6 G_ATTRIBUTE11                 CONSTANT NUMBER := 3;
7 G_ATTRIBUTE12                 CONSTANT NUMBER := 4;
8 G_ATTRIBUTE13                 CONSTANT NUMBER := 5;
9 G_ATTRIBUTE14                 CONSTANT NUMBER := 6;
10 G_ATTRIBUTE15                 CONSTANT NUMBER := 7;
11 G_ATTRIBUTE2                  CONSTANT NUMBER := 8;
12 G_ATTRIBUTE3                  CONSTANT NUMBER := 9;
13 G_ATTRIBUTE4                  CONSTANT NUMBER := 10;
14 G_ATTRIBUTE5                  CONSTANT NUMBER := 11;
15 G_ATTRIBUTE6                  CONSTANT NUMBER := 12;
16 G_ATTRIBUTE7                  CONSTANT NUMBER := 13;
17 G_ATTRIBUTE8                  CONSTANT NUMBER := 14;
18 G_ATTRIBUTE9                  CONSTANT NUMBER := 15;
19 G_CONTEXT                     CONSTANT NUMBER := 16;
20 G_CREATED_BY                  CONSTANT NUMBER := 17;
21 G_CREATION_DATE               CONSTANT NUMBER := 18;
22 G_FLEX_TITLE                  CONSTANT NUMBER := 19;
23 G_HEADER                      CONSTANT NUMBER := 20;
24 G_LAST_UPDATED_BY             CONSTANT NUMBER := 21;
25 G_LAST_UPDATE_DATE            CONSTANT NUMBER := 22;
26 G_LAST_UPDATE_LOGIN           CONSTANT NUMBER := 23;
27 G_LINE                        CONSTANT NUMBER := 24;
28 G_ORDER_PRICE_ATTRIB          CONSTANT NUMBER := 25;
29 G_PRICING_ATTRIBUTE1          CONSTANT NUMBER := 26;
30 G_PRICING_ATTRIBUTE10         CONSTANT NUMBER := 27;
31 G_PRICING_ATTRIBUTE100        CONSTANT NUMBER := 28;
32 G_PRICING_ATTRIBUTE11         CONSTANT NUMBER := 29;
33 G_PRICING_ATTRIBUTE12         CONSTANT NUMBER := 30;
34 G_PRICING_ATTRIBUTE13         CONSTANT NUMBER := 31;
35 G_PRICING_ATTRIBUTE14         CONSTANT NUMBER := 32;
36 G_PRICING_ATTRIBUTE15         CONSTANT NUMBER := 33;
37 G_PRICING_ATTRIBUTE16         CONSTANT NUMBER := 34;
38 G_PRICING_ATTRIBUTE17         CONSTANT NUMBER := 35;
39 G_PRICING_ATTRIBUTE18         CONSTANT NUMBER := 36;
40 G_PRICING_ATTRIBUTE19         CONSTANT NUMBER := 37;
41 G_PRICING_ATTRIBUTE2          CONSTANT NUMBER := 38;
42 G_PRICING_ATTRIBUTE20         CONSTANT NUMBER := 39;
43 G_PRICING_ATTRIBUTE21         CONSTANT NUMBER := 40;
44 G_PRICING_ATTRIBUTE22         CONSTANT NUMBER := 41;
45 G_PRICING_ATTRIBUTE23         CONSTANT NUMBER := 42;
46 G_PRICING_ATTRIBUTE24         CONSTANT NUMBER := 43;
47 G_PRICING_ATTRIBUTE25         CONSTANT NUMBER := 44;
48 G_PRICING_ATTRIBUTE26         CONSTANT NUMBER := 45;
49 G_PRICING_ATTRIBUTE27         CONSTANT NUMBER := 46;
50 G_PRICING_ATTRIBUTE28         CONSTANT NUMBER := 47;
51 G_PRICING_ATTRIBUTE29         CONSTANT NUMBER := 48;
52 G_PRICING_ATTRIBUTE3          CONSTANT NUMBER := 49;
53 G_PRICING_ATTRIBUTE30         CONSTANT NUMBER := 50;
54 G_PRICING_ATTRIBUTE31         CONSTANT NUMBER := 51;
55 G_PRICING_ATTRIBUTE32         CONSTANT NUMBER := 52;
56 G_PRICING_ATTRIBUTE33         CONSTANT NUMBER := 53;
57 G_PRICING_ATTRIBUTE34         CONSTANT NUMBER := 54;
58 G_PRICING_ATTRIBUTE35         CONSTANT NUMBER := 55;
59 G_PRICING_ATTRIBUTE36         CONSTANT NUMBER := 56;
60 G_PRICING_ATTRIBUTE37         CONSTANT NUMBER := 57;
61 G_PRICING_ATTRIBUTE38         CONSTANT NUMBER := 58;
62 G_PRICING_ATTRIBUTE39         CONSTANT NUMBER := 59;
63 G_PRICING_ATTRIBUTE4          CONSTANT NUMBER := 60;
64 G_PRICING_ATTRIBUTE40         CONSTANT NUMBER := 61;
65 G_PRICING_ATTRIBUTE41         CONSTANT NUMBER := 62;
66 G_PRICING_ATTRIBUTE42         CONSTANT NUMBER := 63;
67 G_PRICING_ATTRIBUTE43         CONSTANT NUMBER := 64;
68 G_PRICING_ATTRIBUTE44         CONSTANT NUMBER := 65;
69 G_PRICING_ATTRIBUTE45         CONSTANT NUMBER := 66;
70 G_PRICING_ATTRIBUTE46         CONSTANT NUMBER := 67;
71 G_PRICING_ATTRIBUTE47         CONSTANT NUMBER := 68;
72 G_PRICING_ATTRIBUTE48         CONSTANT NUMBER := 69;
73 G_PRICING_ATTRIBUTE49         CONSTANT NUMBER := 70;
74 G_PRICING_ATTRIBUTE5          CONSTANT NUMBER := 71;
75 G_PRICING_ATTRIBUTE50         CONSTANT NUMBER := 72;
76 G_PRICING_ATTRIBUTE51         CONSTANT NUMBER := 73;
77 G_PRICING_ATTRIBUTE52         CONSTANT NUMBER := 74;
78 G_PRICING_ATTRIBUTE53         CONSTANT NUMBER := 75;
79 G_PRICING_ATTRIBUTE54         CONSTANT NUMBER := 76;
80 G_PRICING_ATTRIBUTE55         CONSTANT NUMBER := 77;
81 G_PRICING_ATTRIBUTE56         CONSTANT NUMBER := 78;
82 G_PRICING_ATTRIBUTE57         CONSTANT NUMBER := 79;
83 G_PRICING_ATTRIBUTE58         CONSTANT NUMBER := 80;
84 G_PRICING_ATTRIBUTE59         CONSTANT NUMBER := 81;
85 G_PRICING_ATTRIBUTE6          CONSTANT NUMBER := 82;
86 G_PRICING_ATTRIBUTE60         CONSTANT NUMBER := 83;
87 G_PRICING_ATTRIBUTE61         CONSTANT NUMBER := 84;
88 G_PRICING_ATTRIBUTE62         CONSTANT NUMBER := 85;
89 G_PRICING_ATTRIBUTE63         CONSTANT NUMBER := 86;
90 G_PRICING_ATTRIBUTE64         CONSTANT NUMBER := 87;
91 G_PRICING_ATTRIBUTE65         CONSTANT NUMBER := 88;
92 G_PRICING_ATTRIBUTE66         CONSTANT NUMBER := 89;
93 G_PRICING_ATTRIBUTE67         CONSTANT NUMBER := 90;
94 G_PRICING_ATTRIBUTE68         CONSTANT NUMBER := 91;
95 G_PRICING_ATTRIBUTE69         CONSTANT NUMBER := 92;
96 G_PRICING_ATTRIBUTE7          CONSTANT NUMBER := 93;
97 G_PRICING_ATTRIBUTE70         CONSTANT NUMBER := 94;
98 G_PRICING_ATTRIBUTE71         CONSTANT NUMBER := 95;
99 G_PRICING_ATTRIBUTE72         CONSTANT NUMBER := 96;
100 G_PRICING_ATTRIBUTE73         CONSTANT NUMBER := 97;
101 G_PRICING_ATTRIBUTE74         CONSTANT NUMBER := 98;
102 G_PRICING_ATTRIBUTE75         CONSTANT NUMBER := 99;
103 G_PRICING_ATTRIBUTE76         CONSTANT NUMBER := 100;
104 G_PRICING_ATTRIBUTE77         CONSTANT NUMBER := 101;
105 G_PRICING_ATTRIBUTE78         CONSTANT NUMBER := 102;
106 G_PRICING_ATTRIBUTE79         CONSTANT NUMBER := 103;
107 G_PRICING_ATTRIBUTE8          CONSTANT NUMBER := 104;
108 G_PRICING_ATTRIBUTE80         CONSTANT NUMBER := 105;
109 G_PRICING_ATTRIBUTE81         CONSTANT NUMBER := 106;
110 G_PRICING_ATTRIBUTE82         CONSTANT NUMBER := 107;
111 G_PRICING_ATTRIBUTE83         CONSTANT NUMBER := 108;
112 G_PRICING_ATTRIBUTE84         CONSTANT NUMBER := 109;
113 G_PRICING_ATTRIBUTE85         CONSTANT NUMBER := 110;
114 G_PRICING_ATTRIBUTE86         CONSTANT NUMBER := 111;
115 G_PRICING_ATTRIBUTE87         CONSTANT NUMBER := 112;
116 G_PRICING_ATTRIBUTE88         CONSTANT NUMBER := 113;
117 G_PRICING_ATTRIBUTE89         CONSTANT NUMBER := 114;
118 G_PRICING_ATTRIBUTE9          CONSTANT NUMBER := 115;
119 G_PRICING_ATTRIBUTE90         CONSTANT NUMBER := 116;
120 G_PRICING_ATTRIBUTE91         CONSTANT NUMBER := 117;
121 G_PRICING_ATTRIBUTE92         CONSTANT NUMBER := 118;
122 G_PRICING_ATTRIBUTE93         CONSTANT NUMBER := 119;
123 G_PRICING_ATTRIBUTE94         CONSTANT NUMBER := 120;
124 G_PRICING_ATTRIBUTE95         CONSTANT NUMBER := 121;
125 G_PRICING_ATTRIBUTE96         CONSTANT NUMBER := 122;
126 G_PRICING_ATTRIBUTE97         CONSTANT NUMBER := 123;
127 G_PRICING_ATTRIBUTE98         CONSTANT NUMBER := 124;
128 G_PRICING_ATTRIBUTE99         CONSTANT NUMBER := 125;
129 G_PRICING_CONTEXT             CONSTANT NUMBER := 126;
130 G_PROGRAM_APPLICATION         CONSTANT NUMBER := 127;
131 G_PROGRAM                     CONSTANT NUMBER := 128;
132 G_PROGRAM_UPDATE_DATE         CONSTANT NUMBER := 129;
133 G_REQUEST                     CONSTANT NUMBER := 130;
134 G_OVERRIDE_FLAG               CONSTANT NUMBER := 131;
135 G_MAX_ATTR_ID                 CONSTANT NUMBER := 132;
136 G_ORIG_SYS_ATTS_REF           CONSTANT NUMBER := 133;
137 
138 PROCEDURE Query_Row
139 (   p_order_price_attrib_id        IN  NUMBER
140 ,   x_Line_Price_Att_Rec 		IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
141 );
142 
143 PROCEDURE Query_Rows
144 (   p_order_price_attrib_id        IN  NUMBER :=
145 								FND_API.G_MISS_NUM
146 ,   p_Line_id					IN NUMBER :=
147 								FND_API.G_MISS_NUM
148 ,   x_Line_Price_Att_Tbl 		IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
149 );
150 
151 
152 PROCEDURE Update_Row
153 ( p_Line_price_att_rec			IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
154 );
155 
156 
157 PROCEDURE Delete_Row
158 ( p_order_price_attrib_id 	NUMBER := FND_API.G_MISS_NUM
159 ,   p_line_id                 NUMBER := FND_API.G_MISS_NUM
160 )
161 ;
162 
163 PROCEDURE Insert_Row
164 ( p_Line_price_att_rec		IN OUT NOCOPY	OE_Order_PUB.Line_Price_Att_Rec_Type
165 );
166 
167 PROCEDURE Clear_Dependent_Attr
168 (   p_attr_id                       IN  NUMBER := FND_API.G_MISS_NUM
169 ,   p_x_Line_price_att_rec      IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
170 ,   p_old_Line_price_att_rec    IN  OE_Order_PUB.Line_Price_Att_Rec_Type
171 	:= OE_Order_PUB.G_MISS_LINE_PRICE_ATT_REC
172 -- ,   x_Line_price_att_rec     OUT OE_Order_PUB.Line_Price_Att_Rec_Type
173 );
174 
175 
176 --  Procedure Complete_Record
177 
178 PROCEDURE Complete_Record
179 (   p_x_Line_price_att_rec      IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
180 ,   p_old_Line_price_att_rec    IN  OE_Order_PUB.Line_Price_Att_Rec_Type
181 );
182 
183 
184 --  Procedure Convert_Miss_To_Null
185 
186 PROCEDURE Convert_Miss_To_Null
187 (   p_x_Line_price_att_rec        IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
188 );
189 
190 
191 --  Procedure Apply_Attribute_Changes
192 
193 PROCEDURE Apply_Attribute_Changes
194 (   p_x_Line_price_att_rec      IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
195 ,   p_old_Line_price_att_rec    IN  OE_Order_PUB.Line_Price_Att_Rec_Type := OE_Order_PUB.G_MISS_LINE_PRICE_ATT_REC
196 -- ,   x_Line_price_att_rec     OUT OE_Order_PUB.Line_Price_Att_Rec_Type
197 );
198 
199 PROCEDURE Lock_Row
200 ( x_return_status OUT NOCOPY VARCHAR2
201 
202 ,   p_x_Line_Price_Att_rec      IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
203 ,   p_order_price_attrib_id         IN NUMBER := FND_API.G_MISS_NUM
204 -- ,   x_Line_Price_Att_rec        OUT OE_Order_PUB.Line_Price_Att_Rec_Type
205 );
206 
207 PROCEDURE Lock_Rows
208 (   p_order_price_attrib_id	  IN NUMBER
209 							:= FND_API.G_MISS_NUM
210 ,   p_line_id				  IN NUMBER
211 							:= FND_API.G_MISS_NUM
212 ,   x_Line_Price_Att_tbl        OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
213 , x_return_status OUT NOCOPY VARCHAR2
214 
215 );
216 
217 PROCEDURE copy_pricing_attributes
218 (	p_from_line_id			NUMBER
219 ,	p_to_line_id			NUMBER
220 ,	p_to_header_id			NUMBER
221 , x_return_status OUT NOCOPY VARCHAR2
222 
223 );
224 
225 
226 -- Fixed bug 1857538
227 -- copy_model_pattr now uses the line_id of the
228 -- option/class/kit items to inherit the pricing attributes
229 -- and pricing context from the top model line
230 -- p_model_line_id need not be passed along as a parameter
231 -- to this procedure
232 PROCEDURE copy_model_pattr
233 (
234 --	p_model_line_id		NUMBER
235 	p_to_line_id			NUMBER
236 , x_return_status OUT NOCOPY VARCHAR2
237 
238 );
239 
240 END OE_Line_PAttr_Util;