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.

APPS.OE_PRICE_LIST_LINE_UTIL dependencies on OE_PRICE_LIST_LINE_UTIL

Line 1: PACKAGE BODY OE_Price_List_Line_Util AS

1: PACKAGE BODY OE_Price_List_Line_Util AS
2: /* $Header: OEXUPRLB.pls 120.2 2006/03/21 11:21:09 rnayani noship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Price_List_Line_Util';

2: /* $Header: OEXUPRLB.pls 120.2 2006/03/21 11:21:09 rnayani noship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Price_List_Line_Util';
7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr

Line 35: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE1;

31:
32: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute1,p_old_PRICE_LIST_LINE_rec.attribute1)
33: THEN
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE1;
36: END IF;
37:
38: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute10,p_old_PRICE_LIST_LINE_rec.attribute10)
39: THEN

Line 41: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE10;

37:
38: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute10,p_old_PRICE_LIST_LINE_rec.attribute10)
39: THEN
40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE10;
42: END IF;
43:
44: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute11,p_old_PRICE_LIST_LINE_rec.attribute11)
45: THEN

Line 47: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE11;

43:
44: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute11,p_old_PRICE_LIST_LINE_rec.attribute11)
45: THEN
46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE11;
48: END IF;
49:
50: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute12,p_old_PRICE_LIST_LINE_rec.attribute12)
51: THEN

Line 53: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE12;

49:
50: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute12,p_old_PRICE_LIST_LINE_rec.attribute12)
51: THEN
52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE12;
54: END IF;
55:
56: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute13,p_old_PRICE_LIST_LINE_rec.attribute13)
57: THEN

Line 59: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE13;

55:
56: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute13,p_old_PRICE_LIST_LINE_rec.attribute13)
57: THEN
58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE13;
60: END IF;
61:
62: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute14,p_old_PRICE_LIST_LINE_rec.attribute14)
63: THEN

Line 65: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE14;

61:
62: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute14,p_old_PRICE_LIST_LINE_rec.attribute14)
63: THEN
64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE14;
66: END IF;
67:
68: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute15,p_old_PRICE_LIST_LINE_rec.attribute15)
69: THEN

Line 71: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE15;

67:
68: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute15,p_old_PRICE_LIST_LINE_rec.attribute15)
69: THEN
70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE15;
72: END IF;
73:
74: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute2,p_old_PRICE_LIST_LINE_rec.attribute2)
75: THEN

Line 77: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE2;

73:
74: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute2,p_old_PRICE_LIST_LINE_rec.attribute2)
75: THEN
76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE2;
78: END IF;
79:
80: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute3,p_old_PRICE_LIST_LINE_rec.attribute3)
81: THEN

Line 83: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE3;

79:
80: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute3,p_old_PRICE_LIST_LINE_rec.attribute3)
81: THEN
82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE3;
84: END IF;
85:
86: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute4,p_old_PRICE_LIST_LINE_rec.attribute4)
87: THEN

Line 89: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE4;

85:
86: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute4,p_old_PRICE_LIST_LINE_rec.attribute4)
87: THEN
88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE4;
90: END IF;
91:
92: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute5,p_old_PRICE_LIST_LINE_rec.attribute5)
93: THEN

Line 95: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE5;

91:
92: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute5,p_old_PRICE_LIST_LINE_rec.attribute5)
93: THEN
94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE5;
96: END IF;
97:
98: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute6,p_old_PRICE_LIST_LINE_rec.attribute6)
99: THEN

Line 101: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE6;

97:
98: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute6,p_old_PRICE_LIST_LINE_rec.attribute6)
99: THEN
100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE6;
102: END IF;
103:
104: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute7,p_old_PRICE_LIST_LINE_rec.attribute7)
105: THEN

Line 107: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE7;

103:
104: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute7,p_old_PRICE_LIST_LINE_rec.attribute7)
105: THEN
106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE7;
108: END IF;
109:
110: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute8,p_old_PRICE_LIST_LINE_rec.attribute8)
111: THEN

Line 113: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE8;

109:
110: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute8,p_old_PRICE_LIST_LINE_rec.attribute8)
111: THEN
112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE8;
114: END IF;
115:
116: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute9,p_old_PRICE_LIST_LINE_rec.attribute9)
117: THEN

Line 119: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE9;

115:
116: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute9,p_old_PRICE_LIST_LINE_rec.attribute9)
117: THEN
118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE9;
120: END IF;
121:
122: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.comments,p_old_PRICE_LIST_LINE_rec.comments)
123: THEN

Line 125: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_COMMENTS;

121:
122: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.comments,p_old_PRICE_LIST_LINE_rec.comments)
123: THEN
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_COMMENTS;
126: END IF;
127:
128: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.context,p_old_PRICE_LIST_LINE_rec.context)
129: THEN

Line 131: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_CONTEXT;

127:
128: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.context,p_old_PRICE_LIST_LINE_rec.context)
129: THEN
130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_CONTEXT;
132: END IF;
133:
134: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.created_by,p_old_PRICE_LIST_LINE_rec.created_by)
135: THEN

Line 137: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_CREATED_BY;

133:
134: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.created_by,p_old_PRICE_LIST_LINE_rec.created_by)
135: THEN
136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_CREATED_BY;
138: END IF;
139:
140: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.creation_date,p_old_PRICE_LIST_LINE_rec.creation_date)
141: THEN

Line 143: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_CREATION_DATE;

139:
140: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.creation_date,p_old_PRICE_LIST_LINE_rec.creation_date)
141: THEN
142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_CREATION_DATE;
144: END IF;
145:
146: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.customer_item_id,p_old_PRICE_LIST_LINE_rec.customer_item_id)
147: THEN

Line 149: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_CUSTOMER_ITEM;

145:
146: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.customer_item_id,p_old_PRICE_LIST_LINE_rec.customer_item_id)
147: THEN
148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_CUSTOMER_ITEM;
150: END IF;
151:
152: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.end_date_active,p_old_PRICE_LIST_LINE_rec.end_date_active)
153: THEN

Line 155: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_END_DATE_ACTIVE;

151:
152: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.end_date_active,p_old_PRICE_LIST_LINE_rec.end_date_active)
153: THEN
154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_END_DATE_ACTIVE;
156: END IF;
157:
158: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.inventory_item_id,p_old_PRICE_LIST_LINE_rec.inventory_item_id)
159: THEN

Line 161: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_INVENTORY_ITEM;

157:
158: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.inventory_item_id,p_old_PRICE_LIST_LINE_rec.inventory_item_id)
159: THEN
160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_INVENTORY_ITEM;
162: END IF;
163:
164: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_updated_by,p_old_PRICE_LIST_LINE_rec.last_updated_by)
165: THEN

Line 167: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LAST_UPDATED_BY;

163:
164: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_updated_by,p_old_PRICE_LIST_LINE_rec.last_updated_by)
165: THEN
166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LAST_UPDATED_BY;
168: END IF;
169:
170: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_update_date,p_old_PRICE_LIST_LINE_rec.last_update_date)
171: THEN

Line 173: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_DATE;

169:
170: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_update_date,p_old_PRICE_LIST_LINE_rec.last_update_date)
171: THEN
172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_DATE;
174: END IF;
175:
176: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_update_login,p_old_PRICE_LIST_LINE_rec.last_update_login)
177: THEN

Line 179: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_LOGIN;

175:
176: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_update_login,p_old_PRICE_LIST_LINE_rec.last_update_login)
177: THEN
178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_LOGIN;
180: END IF;
181:
182: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_price,p_old_PRICE_LIST_LINE_rec.list_price)
183: THEN

Line 185: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LIST_PRICE;

181:
182: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_price,p_old_PRICE_LIST_LINE_rec.list_price)
183: THEN
184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LIST_PRICE;
186: END IF;
187:
188: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.method_code,p_old_PRICE_LIST_LINE_rec.method_code)
189: THEN

Line 191: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_METHOD;

187:
188: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.method_code,p_old_PRICE_LIST_LINE_rec.method_code)
189: THEN
190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_METHOD;
192: END IF;
193:
194: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_list_id,p_old_PRICE_LIST_LINE_rec.price_list_id)
195: THEN

Line 197: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICE_LIST;

193:
194: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_list_id,p_old_PRICE_LIST_LINE_rec.price_list_id)
195: THEN
196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICE_LIST;
198: END IF;
199:
200: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_list_line_id,p_old_PRICE_LIST_LINE_rec.price_list_line_id)
201: THEN

Line 203: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICE_LIST_LINE;

199:
200: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_list_line_id,p_old_PRICE_LIST_LINE_rec.price_list_line_id)
201: THEN
202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICE_LIST_LINE;
204: END IF;
205:
206: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute1,p_old_PRICE_LIST_LINE_rec.pricing_attribute1)
207: THEN

Line 209: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE1;

205:
206: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute1,p_old_PRICE_LIST_LINE_rec.pricing_attribute1)
207: THEN
208: l_index := l_index + 1;
209: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE1;
210: END IF;
211:
212: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute10,p_old_PRICE_LIST_LINE_rec.pricing_attribute10)
213: THEN

Line 215: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE10;

211:
212: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute10,p_old_PRICE_LIST_LINE_rec.pricing_attribute10)
213: THEN
214: l_index := l_index + 1;
215: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE10;
216: END IF;
217:
218: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute11,p_old_PRICE_LIST_LINE_rec.pricing_attribute11)
219: THEN

Line 221: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE11;

217:
218: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute11,p_old_PRICE_LIST_LINE_rec.pricing_attribute11)
219: THEN
220: l_index := l_index + 1;
221: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE11;
222: END IF;
223:
224: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute12,p_old_PRICE_LIST_LINE_rec.pricing_attribute12)
225: THEN

Line 227: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE12;

223:
224: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute12,p_old_PRICE_LIST_LINE_rec.pricing_attribute12)
225: THEN
226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE12;
228: END IF;
229:
230: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute13,p_old_PRICE_LIST_LINE_rec.pricing_attribute13)
231: THEN

Line 233: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE13;

229:
230: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute13,p_old_PRICE_LIST_LINE_rec.pricing_attribute13)
231: THEN
232: l_index := l_index + 1;
233: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE13;
234: END IF;
235:
236: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute14,p_old_PRICE_LIST_LINE_rec.pricing_attribute14)
237: THEN

Line 239: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE14;

235:
236: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute14,p_old_PRICE_LIST_LINE_rec.pricing_attribute14)
237: THEN
238: l_index := l_index + 1;
239: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE14;
240: END IF;
241:
242: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute15,p_old_PRICE_LIST_LINE_rec.pricing_attribute15)
243: THEN

Line 245: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE15;

241:
242: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute15,p_old_PRICE_LIST_LINE_rec.pricing_attribute15)
243: THEN
244: l_index := l_index + 1;
245: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE15;
246: END IF;
247:
248: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute2,p_old_PRICE_LIST_LINE_rec.pricing_attribute2)
249: THEN

Line 251: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE2;

247:
248: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute2,p_old_PRICE_LIST_LINE_rec.pricing_attribute2)
249: THEN
250: l_index := l_index + 1;
251: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE2;
252: END IF;
253:
254: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute3,p_old_PRICE_LIST_LINE_rec.pricing_attribute3)
255: THEN

Line 257: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE3;

253:
254: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute3,p_old_PRICE_LIST_LINE_rec.pricing_attribute3)
255: THEN
256: l_index := l_index + 1;
257: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE3;
258: END IF;
259:
260: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute4,p_old_PRICE_LIST_LINE_rec.pricing_attribute4)
261: THEN

Line 263: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE4;

259:
260: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute4,p_old_PRICE_LIST_LINE_rec.pricing_attribute4)
261: THEN
262: l_index := l_index + 1;
263: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE4;
264: END IF;
265:
266: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute5,p_old_PRICE_LIST_LINE_rec.pricing_attribute5)
267: THEN

Line 269: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE5;

265:
266: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute5,p_old_PRICE_LIST_LINE_rec.pricing_attribute5)
267: THEN
268: l_index := l_index + 1;
269: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE5;
270: END IF;
271:
272: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute6,p_old_PRICE_LIST_LINE_rec.pricing_attribute6)
273: THEN

Line 275: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE6;

271:
272: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute6,p_old_PRICE_LIST_LINE_rec.pricing_attribute6)
273: THEN
274: l_index := l_index + 1;
275: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE6;
276: END IF;
277:
278: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute7,p_old_PRICE_LIST_LINE_rec.pricing_attribute7)
279: THEN

Line 281: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE7;

277:
278: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute7,p_old_PRICE_LIST_LINE_rec.pricing_attribute7)
279: THEN
280: l_index := l_index + 1;
281: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE7;
282: END IF;
283:
284: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute8,p_old_PRICE_LIST_LINE_rec.pricing_attribute8)
285: THEN

Line 287: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE8;

283:
284: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute8,p_old_PRICE_LIST_LINE_rec.pricing_attribute8)
285: THEN
286: l_index := l_index + 1;
287: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE8;
288: END IF;
289:
290: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute9,p_old_PRICE_LIST_LINE_rec.pricing_attribute9)
291: THEN

Line 293: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE9;

289:
290: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_attribute9,p_old_PRICE_LIST_LINE_rec.pricing_attribute9)
291: THEN
292: l_index := l_index + 1;
293: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE9;
294: END IF;
295:
296: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_context,p_old_PRICE_LIST_LINE_rec.pricing_context)
297: THEN

Line 299: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_CONTEXT;

295:
296: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_context,p_old_PRICE_LIST_LINE_rec.pricing_context)
297: THEN
298: l_index := l_index + 1;
299: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_CONTEXT;
300: END IF;
301:
302: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_rule_id,p_old_PRICE_LIST_LINE_rec.pricing_rule_id)
303: THEN

Line 305: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_RULE;

301:
302: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_rule_id,p_old_PRICE_LIST_LINE_rec.pricing_rule_id)
303: THEN
304: l_index := l_index + 1;
305: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_RULE;
306: END IF;
307:
308: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.primary,p_old_PRICE_LIST_LINE_rec.primary)
309: THEN

Line 311: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRIMARY;

307:
308: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.primary,p_old_PRICE_LIST_LINE_rec.primary)
309: THEN
310: l_index := l_index + 1;
311: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRIMARY;
312: END IF;
313:
314: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_application_id,p_old_PRICE_LIST_LINE_rec.program_application_id)
315: THEN

Line 317: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PROGRAM_APPLICATION;

313:
314: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_application_id,p_old_PRICE_LIST_LINE_rec.program_application_id)
315: THEN
316: l_index := l_index + 1;
317: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PROGRAM_APPLICATION;
318: END IF;
319:
320: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_id,p_old_PRICE_LIST_LINE_rec.program_id)
321: THEN

Line 323: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PROGRAM;

319:
320: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_id,p_old_PRICE_LIST_LINE_rec.program_id)
321: THEN
322: l_index := l_index + 1;
323: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PROGRAM;
324: END IF;
325:
326: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_update_date,p_old_PRICE_LIST_LINE_rec.program_update_date)
327: THEN

Line 329: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PROGRAM_UPDATE_DATE;

325:
326: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_update_date,p_old_PRICE_LIST_LINE_rec.program_update_date)
327: THEN
328: l_index := l_index + 1;
329: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PROGRAM_UPDATE_DATE;
330: END IF;
331:
332: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.reprice_flag,p_old_PRICE_LIST_LINE_rec.reprice_flag)
333: THEN

Line 335: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REPRICE;

331:
332: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.reprice_flag,p_old_PRICE_LIST_LINE_rec.reprice_flag)
333: THEN
334: l_index := l_index + 1;
335: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REPRICE;
336: END IF;
337:
338: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.request_id,p_old_PRICE_LIST_LINE_rec.request_id)
339: THEN

Line 341: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REQUEST;

337:
338: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.request_id,p_old_PRICE_LIST_LINE_rec.request_id)
339: THEN
340: l_index := l_index + 1;
341: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REQUEST;
342: END IF;
343:
344: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision,p_old_PRICE_LIST_LINE_rec.revision)
345: THEN

Line 347: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REVISION;

343:
344: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision,p_old_PRICE_LIST_LINE_rec.revision)
345: THEN
346: l_index := l_index + 1;
347: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REVISION;
348: END IF;
349:
350: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision_date,p_old_PRICE_LIST_LINE_rec.revision_date)
351: THEN

Line 353: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REVISION_DATE;

349:
350: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision_date,p_old_PRICE_LIST_LINE_rec.revision_date)
351: THEN
352: l_index := l_index + 1;
353: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REVISION_DATE;
354: END IF;
355:
356: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision_reason_code,p_old_PRICE_LIST_LINE_rec.revision_reason_code)
357: THEN

Line 359: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REVISION_REASON;

355:
356: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision_reason_code,p_old_PRICE_LIST_LINE_rec.revision_reason_code)
357: THEN
358: l_index := l_index + 1;
359: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REVISION_REASON;
360: END IF;
361:
362: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.start_date_active,p_old_PRICE_LIST_LINE_rec.start_date_active)
363: THEN

Line 365: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_START_DATE_ACTIVE;

361:
362: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.start_date_active,p_old_PRICE_LIST_LINE_rec.start_date_active)
363: THEN
364: l_index := l_index + 1;
365: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_START_DATE_ACTIVE;
366: END IF;
367:
368: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.unit_code,p_old_PRICE_LIST_LINE_rec.unit_code)
369: THEN

Line 371: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_UNIT;

367:
368: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.unit_code,p_old_PRICE_LIST_LINE_rec.unit_code)
369: THEN
370: l_index := l_index + 1;
371: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_UNIT;
372: END IF;
373:
374: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
375: l_index := l_index + 1;

Line 376: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE1;

372: END IF;
373:
374: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
375: l_index := l_index + 1;
376: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE1;
377: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
378: l_index := l_index + 1;
379: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE10;
380: ELSIF p_attr_id = G_ATTRIBUTE11 THEN

Line 379: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE10;

375: l_index := l_index + 1;
376: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE1;
377: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
378: l_index := l_index + 1;
379: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE10;
380: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
381: l_index := l_index + 1;
382: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE11;
383: ELSIF p_attr_id = G_ATTRIBUTE12 THEN

Line 382: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE11;

378: l_index := l_index + 1;
379: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE10;
380: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
381: l_index := l_index + 1;
382: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE11;
383: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE12;
386: ELSIF p_attr_id = G_ATTRIBUTE13 THEN

Line 385: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE12;

381: l_index := l_index + 1;
382: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE11;
383: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE12;
386: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
387: l_index := l_index + 1;
388: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE13;
389: ELSIF p_attr_id = G_ATTRIBUTE14 THEN

Line 388: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE13;

384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE12;
386: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
387: l_index := l_index + 1;
388: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE13;
389: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE14;
392: ELSIF p_attr_id = G_ATTRIBUTE15 THEN

Line 391: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE14;

387: l_index := l_index + 1;
388: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE13;
389: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE14;
392: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
393: l_index := l_index + 1;
394: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE15;
395: ELSIF p_attr_id = G_ATTRIBUTE2 THEN

Line 394: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE15;

390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE14;
392: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
393: l_index := l_index + 1;
394: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE15;
395: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
396: l_index := l_index + 1;
397: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE2;
398: ELSIF p_attr_id = G_ATTRIBUTE3 THEN

Line 397: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE2;

393: l_index := l_index + 1;
394: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE15;
395: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
396: l_index := l_index + 1;
397: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE2;
398: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
399: l_index := l_index + 1;
400: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE3;
401: ELSIF p_attr_id = G_ATTRIBUTE4 THEN

Line 400: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE3;

396: l_index := l_index + 1;
397: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE2;
398: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
399: l_index := l_index + 1;
400: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE3;
401: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
402: l_index := l_index + 1;
403: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE4;
404: ELSIF p_attr_id = G_ATTRIBUTE5 THEN

Line 403: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE4;

399: l_index := l_index + 1;
400: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE3;
401: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
402: l_index := l_index + 1;
403: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE4;
404: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
405: l_index := l_index + 1;
406: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE5;
407: ELSIF p_attr_id = G_ATTRIBUTE6 THEN

Line 406: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE5;

402: l_index := l_index + 1;
403: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE4;
404: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
405: l_index := l_index + 1;
406: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE5;
407: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
408: l_index := l_index + 1;
409: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE6;
410: ELSIF p_attr_id = G_ATTRIBUTE7 THEN

Line 409: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE6;

405: l_index := l_index + 1;
406: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE5;
407: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
408: l_index := l_index + 1;
409: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE6;
410: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
411: l_index := l_index + 1;
412: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE7;
413: ELSIF p_attr_id = G_ATTRIBUTE8 THEN

Line 412: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE7;

408: l_index := l_index + 1;
409: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE6;
410: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
411: l_index := l_index + 1;
412: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE7;
413: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE8;
416: ELSIF p_attr_id = G_ATTRIBUTE9 THEN

Line 415: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE8;

411: l_index := l_index + 1;
412: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE7;
413: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE8;
416: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
417: l_index := l_index + 1;
418: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE9;
419: ELSIF p_attr_id = G_COMMENTS THEN

Line 418: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE9;

414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE8;
416: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
417: l_index := l_index + 1;
418: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE9;
419: ELSIF p_attr_id = G_COMMENTS THEN
420: l_index := l_index + 1;
421: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_COMMENTS;
422: ELSIF p_attr_id = G_CONTEXT THEN

Line 421: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_COMMENTS;

417: l_index := l_index + 1;
418: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE9;
419: ELSIF p_attr_id = G_COMMENTS THEN
420: l_index := l_index + 1;
421: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_COMMENTS;
422: ELSIF p_attr_id = G_CONTEXT THEN
423: l_index := l_index + 1;
424: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_CONTEXT;
425: ELSIF p_attr_id = G_CREATED_BY THEN

Line 424: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_CONTEXT;

420: l_index := l_index + 1;
421: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_COMMENTS;
422: ELSIF p_attr_id = G_CONTEXT THEN
423: l_index := l_index + 1;
424: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_CONTEXT;
425: ELSIF p_attr_id = G_CREATED_BY THEN
426: l_index := l_index + 1;
427: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_CREATED_BY;
428: ELSIF p_attr_id = G_CREATION_DATE THEN

Line 427: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_CREATED_BY;

423: l_index := l_index + 1;
424: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_CONTEXT;
425: ELSIF p_attr_id = G_CREATED_BY THEN
426: l_index := l_index + 1;
427: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_CREATED_BY;
428: ELSIF p_attr_id = G_CREATION_DATE THEN
429: l_index := l_index + 1;
430: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_CREATION_DATE;
431: ELSIF p_attr_id = G_CUSTOMER_ITEM THEN

Line 430: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_CREATION_DATE;

426: l_index := l_index + 1;
427: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_CREATED_BY;
428: ELSIF p_attr_id = G_CREATION_DATE THEN
429: l_index := l_index + 1;
430: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_CREATION_DATE;
431: ELSIF p_attr_id = G_CUSTOMER_ITEM THEN
432: l_index := l_index + 1;
433: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_CUSTOMER_ITEM;
434: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN

Line 433: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_CUSTOMER_ITEM;

429: l_index := l_index + 1;
430: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_CREATION_DATE;
431: ELSIF p_attr_id = G_CUSTOMER_ITEM THEN
432: l_index := l_index + 1;
433: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_CUSTOMER_ITEM;
434: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN
435: l_index := l_index + 1;
436: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_END_DATE_ACTIVE;
437: ELSIF p_attr_id = G_INVENTORY_ITEM THEN

Line 436: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_END_DATE_ACTIVE;

432: l_index := l_index + 1;
433: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_CUSTOMER_ITEM;
434: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN
435: l_index := l_index + 1;
436: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_END_DATE_ACTIVE;
437: ELSIF p_attr_id = G_INVENTORY_ITEM THEN
438: l_index := l_index + 1;
439: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_INVENTORY_ITEM;
440: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN

Line 439: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_INVENTORY_ITEM;

435: l_index := l_index + 1;
436: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_END_DATE_ACTIVE;
437: ELSIF p_attr_id = G_INVENTORY_ITEM THEN
438: l_index := l_index + 1;
439: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_INVENTORY_ITEM;
440: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
441: l_index := l_index + 1;
442: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LAST_UPDATED_BY;
443: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN

Line 442: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LAST_UPDATED_BY;

438: l_index := l_index + 1;
439: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_INVENTORY_ITEM;
440: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
441: l_index := l_index + 1;
442: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LAST_UPDATED_BY;
443: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
444: l_index := l_index + 1;
445: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_DATE;
446: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN

Line 445: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_DATE;

441: l_index := l_index + 1;
442: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LAST_UPDATED_BY;
443: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
444: l_index := l_index + 1;
445: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_DATE;
446: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
447: l_index := l_index + 1;
448: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_LOGIN;
449: ELSIF p_attr_id = G_LIST_PRICE THEN

Line 448: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_LOGIN;

444: l_index := l_index + 1;
445: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_DATE;
446: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
447: l_index := l_index + 1;
448: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_LOGIN;
449: ELSIF p_attr_id = G_LIST_PRICE THEN
450: l_index := l_index + 1;
451: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LIST_PRICE;
452: ELSIF p_attr_id = G_METHOD THEN

Line 451: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LIST_PRICE;

447: l_index := l_index + 1;
448: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_LOGIN;
449: ELSIF p_attr_id = G_LIST_PRICE THEN
450: l_index := l_index + 1;
451: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LIST_PRICE;
452: ELSIF p_attr_id = G_METHOD THEN
453: l_index := l_index + 1;
454: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_METHOD;
455: ELSIF p_attr_id = G_PRICE_LIST THEN

Line 454: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_METHOD;

450: l_index := l_index + 1;
451: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LIST_PRICE;
452: ELSIF p_attr_id = G_METHOD THEN
453: l_index := l_index + 1;
454: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_METHOD;
455: ELSIF p_attr_id = G_PRICE_LIST THEN
456: l_index := l_index + 1;
457: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICE_LIST;
458: ELSIF p_attr_id = G_PRICE_LIST_LINE THEN

Line 457: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICE_LIST;

453: l_index := l_index + 1;
454: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_METHOD;
455: ELSIF p_attr_id = G_PRICE_LIST THEN
456: l_index := l_index + 1;
457: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICE_LIST;
458: ELSIF p_attr_id = G_PRICE_LIST_LINE THEN
459: l_index := l_index + 1;
460: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICE_LIST_LINE;
461: ELSIF p_attr_id = G_PRICING_ATTRIBUTE1 THEN

Line 460: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICE_LIST_LINE;

456: l_index := l_index + 1;
457: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICE_LIST;
458: ELSIF p_attr_id = G_PRICE_LIST_LINE THEN
459: l_index := l_index + 1;
460: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICE_LIST_LINE;
461: ELSIF p_attr_id = G_PRICING_ATTRIBUTE1 THEN
462: l_index := l_index + 1;
463: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE1;
464: ELSIF p_attr_id = G_PRICING_ATTRIBUTE10 THEN

Line 463: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE1;

459: l_index := l_index + 1;
460: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICE_LIST_LINE;
461: ELSIF p_attr_id = G_PRICING_ATTRIBUTE1 THEN
462: l_index := l_index + 1;
463: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE1;
464: ELSIF p_attr_id = G_PRICING_ATTRIBUTE10 THEN
465: l_index := l_index + 1;
466: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE10;
467: ELSIF p_attr_id = G_PRICING_ATTRIBUTE11 THEN

Line 466: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE10;

462: l_index := l_index + 1;
463: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE1;
464: ELSIF p_attr_id = G_PRICING_ATTRIBUTE10 THEN
465: l_index := l_index + 1;
466: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE10;
467: ELSIF p_attr_id = G_PRICING_ATTRIBUTE11 THEN
468: l_index := l_index + 1;
469: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE11;
470: ELSIF p_attr_id = G_PRICING_ATTRIBUTE12 THEN

Line 469: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE11;

465: l_index := l_index + 1;
466: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE10;
467: ELSIF p_attr_id = G_PRICING_ATTRIBUTE11 THEN
468: l_index := l_index + 1;
469: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE11;
470: ELSIF p_attr_id = G_PRICING_ATTRIBUTE12 THEN
471: l_index := l_index + 1;
472: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE12;
473: ELSIF p_attr_id = G_PRICING_ATTRIBUTE13 THEN

Line 472: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE12;

468: l_index := l_index + 1;
469: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE11;
470: ELSIF p_attr_id = G_PRICING_ATTRIBUTE12 THEN
471: l_index := l_index + 1;
472: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE12;
473: ELSIF p_attr_id = G_PRICING_ATTRIBUTE13 THEN
474: l_index := l_index + 1;
475: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE13;
476: ELSIF p_attr_id = G_PRICING_ATTRIBUTE14 THEN

Line 475: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE13;

471: l_index := l_index + 1;
472: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE12;
473: ELSIF p_attr_id = G_PRICING_ATTRIBUTE13 THEN
474: l_index := l_index + 1;
475: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE13;
476: ELSIF p_attr_id = G_PRICING_ATTRIBUTE14 THEN
477: l_index := l_index + 1;
478: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE14;
479: ELSIF p_attr_id = G_PRICING_ATTRIBUTE15 THEN

Line 478: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE14;

474: l_index := l_index + 1;
475: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE13;
476: ELSIF p_attr_id = G_PRICING_ATTRIBUTE14 THEN
477: l_index := l_index + 1;
478: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE14;
479: ELSIF p_attr_id = G_PRICING_ATTRIBUTE15 THEN
480: l_index := l_index + 1;
481: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE15;
482: ELSIF p_attr_id = G_PRICING_ATTRIBUTE2 THEN

Line 481: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE15;

477: l_index := l_index + 1;
478: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE14;
479: ELSIF p_attr_id = G_PRICING_ATTRIBUTE15 THEN
480: l_index := l_index + 1;
481: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE15;
482: ELSIF p_attr_id = G_PRICING_ATTRIBUTE2 THEN
483: l_index := l_index + 1;
484: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE2;
485: ELSIF p_attr_id = G_PRICING_ATTRIBUTE3 THEN

Line 484: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE2;

480: l_index := l_index + 1;
481: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE15;
482: ELSIF p_attr_id = G_PRICING_ATTRIBUTE2 THEN
483: l_index := l_index + 1;
484: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE2;
485: ELSIF p_attr_id = G_PRICING_ATTRIBUTE3 THEN
486: l_index := l_index + 1;
487: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE3;
488: ELSIF p_attr_id = G_PRICING_ATTRIBUTE4 THEN

Line 487: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE3;

483: l_index := l_index + 1;
484: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE2;
485: ELSIF p_attr_id = G_PRICING_ATTRIBUTE3 THEN
486: l_index := l_index + 1;
487: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE3;
488: ELSIF p_attr_id = G_PRICING_ATTRIBUTE4 THEN
489: l_index := l_index + 1;
490: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE4;
491: ELSIF p_attr_id = G_PRICING_ATTRIBUTE5 THEN

Line 490: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE4;

486: l_index := l_index + 1;
487: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE3;
488: ELSIF p_attr_id = G_PRICING_ATTRIBUTE4 THEN
489: l_index := l_index + 1;
490: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE4;
491: ELSIF p_attr_id = G_PRICING_ATTRIBUTE5 THEN
492: l_index := l_index + 1;
493: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE5;
494: ELSIF p_attr_id = G_PRICING_ATTRIBUTE6 THEN

Line 493: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE5;

489: l_index := l_index + 1;
490: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE4;
491: ELSIF p_attr_id = G_PRICING_ATTRIBUTE5 THEN
492: l_index := l_index + 1;
493: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE5;
494: ELSIF p_attr_id = G_PRICING_ATTRIBUTE6 THEN
495: l_index := l_index + 1;
496: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE6;
497: ELSIF p_attr_id = G_PRICING_ATTRIBUTE7 THEN

Line 496: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE6;

492: l_index := l_index + 1;
493: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE5;
494: ELSIF p_attr_id = G_PRICING_ATTRIBUTE6 THEN
495: l_index := l_index + 1;
496: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE6;
497: ELSIF p_attr_id = G_PRICING_ATTRIBUTE7 THEN
498: l_index := l_index + 1;
499: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE7;
500: ELSIF p_attr_id = G_PRICING_ATTRIBUTE8 THEN

Line 499: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE7;

495: l_index := l_index + 1;
496: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE6;
497: ELSIF p_attr_id = G_PRICING_ATTRIBUTE7 THEN
498: l_index := l_index + 1;
499: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE7;
500: ELSIF p_attr_id = G_PRICING_ATTRIBUTE8 THEN
501: l_index := l_index + 1;
502: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE8;
503: ELSIF p_attr_id = G_PRICING_ATTRIBUTE9 THEN

Line 502: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE8;

498: l_index := l_index + 1;
499: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE7;
500: ELSIF p_attr_id = G_PRICING_ATTRIBUTE8 THEN
501: l_index := l_index + 1;
502: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE8;
503: ELSIF p_attr_id = G_PRICING_ATTRIBUTE9 THEN
504: l_index := l_index + 1;
505: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE9;
506: ELSIF p_attr_id = G_PRICING_CONTEXT THEN

Line 505: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE9;

501: l_index := l_index + 1;
502: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE8;
503: ELSIF p_attr_id = G_PRICING_ATTRIBUTE9 THEN
504: l_index := l_index + 1;
505: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE9;
506: ELSIF p_attr_id = G_PRICING_CONTEXT THEN
507: l_index := l_index + 1;
508: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_CONTEXT;
509: ELSIF p_attr_id = G_PRICING_RULE THEN

Line 508: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_CONTEXT;

504: l_index := l_index + 1;
505: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_ATTRIBUTE9;
506: ELSIF p_attr_id = G_PRICING_CONTEXT THEN
507: l_index := l_index + 1;
508: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_CONTEXT;
509: ELSIF p_attr_id = G_PRICING_RULE THEN
510: l_index := l_index + 1;
511: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_RULE;
512: ELSIF p_attr_id = G_PRIMARY THEN

Line 511: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_RULE;

507: l_index := l_index + 1;
508: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_CONTEXT;
509: ELSIF p_attr_id = G_PRICING_RULE THEN
510: l_index := l_index + 1;
511: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_RULE;
512: ELSIF p_attr_id = G_PRIMARY THEN
513: l_index := l_index + 1;
514: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRIMARY;
515: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN

Line 514: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRIMARY;

510: l_index := l_index + 1;
511: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRICING_RULE;
512: ELSIF p_attr_id = G_PRIMARY THEN
513: l_index := l_index + 1;
514: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRIMARY;
515: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
516: l_index := l_index + 1;
517: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PROGRAM_APPLICATION;
518: ELSIF p_attr_id = G_PROGRAM THEN

Line 517: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PROGRAM_APPLICATION;

513: l_index := l_index + 1;
514: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PRIMARY;
515: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
516: l_index := l_index + 1;
517: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PROGRAM_APPLICATION;
518: ELSIF p_attr_id = G_PROGRAM THEN
519: l_index := l_index + 1;
520: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PROGRAM;
521: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN

Line 520: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PROGRAM;

516: l_index := l_index + 1;
517: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PROGRAM_APPLICATION;
518: ELSIF p_attr_id = G_PROGRAM THEN
519: l_index := l_index + 1;
520: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PROGRAM;
521: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
522: l_index := l_index + 1;
523: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PROGRAM_UPDATE_DATE;
524: ELSIF p_attr_id = G_REPRICE THEN

Line 523: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PROGRAM_UPDATE_DATE;

519: l_index := l_index + 1;
520: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PROGRAM;
521: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
522: l_index := l_index + 1;
523: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PROGRAM_UPDATE_DATE;
524: ELSIF p_attr_id = G_REPRICE THEN
525: l_index := l_index + 1;
526: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REPRICE;
527: ELSIF p_attr_id = G_REQUEST THEN

Line 526: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REPRICE;

522: l_index := l_index + 1;
523: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PROGRAM_UPDATE_DATE;
524: ELSIF p_attr_id = G_REPRICE THEN
525: l_index := l_index + 1;
526: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REPRICE;
527: ELSIF p_attr_id = G_REQUEST THEN
528: l_index := l_index + 1;
529: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REQUEST;
530: ELSIF p_attr_id = G_REVISION THEN

Line 529: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REQUEST;

525: l_index := l_index + 1;
526: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REPRICE;
527: ELSIF p_attr_id = G_REQUEST THEN
528: l_index := l_index + 1;
529: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REQUEST;
530: ELSIF p_attr_id = G_REVISION THEN
531: l_index := l_index + 1;
532: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REVISION;
533: ELSIF p_attr_id = G_REVISION_DATE THEN

Line 532: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REVISION;

528: l_index := l_index + 1;
529: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REQUEST;
530: ELSIF p_attr_id = G_REVISION THEN
531: l_index := l_index + 1;
532: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REVISION;
533: ELSIF p_attr_id = G_REVISION_DATE THEN
534: l_index := l_index + 1;
535: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REVISION_DATE;
536: ELSIF p_attr_id = G_REVISION_REASON THEN

Line 535: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REVISION_DATE;

531: l_index := l_index + 1;
532: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REVISION;
533: ELSIF p_attr_id = G_REVISION_DATE THEN
534: l_index := l_index + 1;
535: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REVISION_DATE;
536: ELSIF p_attr_id = G_REVISION_REASON THEN
537: l_index := l_index + 1;
538: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REVISION_REASON;
539: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN

Line 538: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REVISION_REASON;

534: l_index := l_index + 1;
535: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REVISION_DATE;
536: ELSIF p_attr_id = G_REVISION_REASON THEN
537: l_index := l_index + 1;
538: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REVISION_REASON;
539: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN
540: l_index := l_index + 1;
541: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_START_DATE_ACTIVE;
542: ELSIF p_attr_id = G_UNIT THEN

Line 541: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_START_DATE_ACTIVE;

537: l_index := l_index + 1;
538: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_REVISION_REASON;
539: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN
540: l_index := l_index + 1;
541: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_START_DATE_ACTIVE;
542: ELSIF p_attr_id = G_UNIT THEN
543: l_index := l_index + 1;
544: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_UNIT;
545: END IF;

Line 544: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_UNIT;

540: l_index := l_index + 1;
541: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_START_DATE_ACTIVE;
542: ELSIF p_attr_id = G_UNIT THEN
543: l_index := l_index + 1;
544: l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_UNIT;
545: END IF;
546:
547: END Clear_Dependent_Attr;
548:

Line 561: oe_debug_pub.add('Entering OE_Price_List_Line_Util.Apply_Attribute_Changes' || p_Price_List_Line_rec.price_list_id || ' ' || p_PRICE_LIST_LINE_rec.price_list_line_id);

557: IS
558: l_primary_exists BOOLEAN;
559: BEGIN
560:
561: oe_debug_pub.add('Entering OE_Price_List_Line_Util.Apply_Attribute_Changes' || p_Price_List_Line_rec.price_list_id || ' ' || p_PRICE_LIST_LINE_rec.price_list_line_id);
562:
563: -- Load out record
564:
565: x_PRICE_LIST_LINE_rec := p_PRICE_LIST_LINE_rec;

Line 1039: oe_debug_pub.add('Exiting OE_Price_List_Line_Util.Apply_Attribute_Changes');

1035: END IF;
1036:
1037: END IF;
1038:
1039: oe_debug_pub.add('Exiting OE_Price_List_Line_Util.Apply_Attribute_Changes');
1040:
1041: END Apply_Attribute_Changes;
1042:
1043:

Line 3481: END OE_Price_List_Line_Util;

3477:
3478: END Query_Pricing_Attributes;
3479:
3480:
3481: END OE_Price_List_Line_Util;