[Home] [Help]
PACKAGE: APPS.OE_HEADER_PATTR_UTIL
Source
1 PACKAGE OE_Header_PAttr_Util AS
2 /* $Header: OEXUHPAS.pls 120.1 2006/03/29 16:46:56 spooruli noship $ */
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
137
138 PROCEDURE Query_Row
139 ( p_order_price_attrib_id IN NUMBER
140 , x_Header_Price_Att_Rec IN OUT NOCOPY OE_Order_PUB.Header_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_header_id IN NUMBER :=
147 FND_API.G_MISS_NUM
148 , x_Header_Price_Att_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type
149 );
150
151 PROCEDURE Clear_Dependent_Attr
152 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
153 , p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
154 , p_old_Header_Price_Att_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
155 := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC
156 -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
157 );
158
159
160 -- Procedure Complete_Record
161
162 PROCEDURE Complete_Record
163 ( p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
164 , p_old_Header_Price_Att_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
165 );
166
167
168 -- Procedure Convert_Miss_To_Null
169
170 PROCEDURE Convert_Miss_To_Null
171 ( p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
172 );
173
174
175 -- Procedure Apply_Attribute_Changes
176
177 PROCEDURE Apply_Attribute_Changes
178 ( p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
179 , p_old_Header_Price_Att_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
180 := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC
181 -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
182 );
183
184
185 PROCEDURE Update_Row
186 ( p_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
187 );
188
189
190 PROCEDURE Delete_Row
191 ( p_order_price_attrib_id NUMBER := FND_API.G_MISS_NUM
192 , p_Header_id NUMBER := FND_API.G_MISS_NUM
193 )
194 ;
195
196 PROCEDURE Insert_Row
197 ( p_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
198 );
199
200 PROCEDURE Lock_Row
201 ( x_return_status OUT NOCOPY VARCHAR2
202
203 , p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
204 , p_order_price_attrib_id IN NUMBER := FND_API.G_MISS_NUM
205 -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
206 )
207 ;
208
209 PROCEDURE Lock_Rows
210 ( p_order_price_attrib_id IN NUMBER
211 := FND_API.G_MISS_NUM
212 , p_header_id IN NUMBER
213 := FND_API.G_MISS_NUM
214 , x_Header_Price_Att_tbl OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type
215 , x_return_status OUT NOCOPY VARCHAR2
216
217 );
218
219 END OE_Header_PAttr_Util;