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_UTIL dependencies on OE_GLOBALS

Line 19: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;

15: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
20: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
21: BEGIN
22:
23: -- Load out record

Line 20: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;

16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
20: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
21: BEGIN
22:
23: -- Load out record
24:

Line 32: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute1,p_old_PRICE_LIST_rec.attribute1)

28: -- every changed attribute clear its dependent fields.
29:
30: IF p_attr_id = FND_API.G_MISS_NUM THEN
31:
32: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute1,p_old_PRICE_LIST_rec.attribute1)
33: THEN
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE1;
36: END IF;

Line 38: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute10,p_old_PRICE_LIST_rec.attribute10)

34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE1;
36: END IF;
37:
38: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute10,p_old_PRICE_LIST_rec.attribute10)
39: THEN
40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE10;
42: END IF;

Line 44: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute11,p_old_PRICE_LIST_rec.attribute11)

40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE10;
42: END IF;
43:
44: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute11,p_old_PRICE_LIST_rec.attribute11)
45: THEN
46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE11;
48: END IF;

Line 50: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute12,p_old_PRICE_LIST_rec.attribute12)

46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE11;
48: END IF;
49:
50: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute12,p_old_PRICE_LIST_rec.attribute12)
51: THEN
52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE12;
54: END IF;

Line 56: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute13,p_old_PRICE_LIST_rec.attribute13)

52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE12;
54: END IF;
55:
56: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute13,p_old_PRICE_LIST_rec.attribute13)
57: THEN
58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE13;
60: END IF;

Line 62: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute14,p_old_PRICE_LIST_rec.attribute14)

58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE13;
60: END IF;
61:
62: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute14,p_old_PRICE_LIST_rec.attribute14)
63: THEN
64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE14;
66: END IF;

Line 68: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute15,p_old_PRICE_LIST_rec.attribute15)

64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE14;
66: END IF;
67:
68: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute15,p_old_PRICE_LIST_rec.attribute15)
69: THEN
70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE15;
72: END IF;

Line 74: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute2,p_old_PRICE_LIST_rec.attribute2)

70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE15;
72: END IF;
73:
74: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute2,p_old_PRICE_LIST_rec.attribute2)
75: THEN
76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE2;
78: END IF;

Line 80: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute3,p_old_PRICE_LIST_rec.attribute3)

76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE2;
78: END IF;
79:
80: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute3,p_old_PRICE_LIST_rec.attribute3)
81: THEN
82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE3;
84: END IF;

Line 86: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute4,p_old_PRICE_LIST_rec.attribute4)

82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE3;
84: END IF;
85:
86: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute4,p_old_PRICE_LIST_rec.attribute4)
87: THEN
88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE4;
90: END IF;

Line 92: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute5,p_old_PRICE_LIST_rec.attribute5)

88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE4;
90: END IF;
91:
92: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute5,p_old_PRICE_LIST_rec.attribute5)
93: THEN
94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE5;
96: END IF;

Line 98: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute6,p_old_PRICE_LIST_rec.attribute6)

94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE5;
96: END IF;
97:
98: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute6,p_old_PRICE_LIST_rec.attribute6)
99: THEN
100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE6;
102: END IF;

Line 104: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute7,p_old_PRICE_LIST_rec.attribute7)

100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE6;
102: END IF;
103:
104: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute7,p_old_PRICE_LIST_rec.attribute7)
105: THEN
106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE7;
108: END IF;

Line 110: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute8,p_old_PRICE_LIST_rec.attribute8)

106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE7;
108: END IF;
109:
110: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute8,p_old_PRICE_LIST_rec.attribute8)
111: THEN
112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE8;
114: END IF;

Line 116: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute9,p_old_PRICE_LIST_rec.attribute9)

112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE8;
114: END IF;
115:
116: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute9,p_old_PRICE_LIST_rec.attribute9)
117: THEN
118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE9;
120: END IF;

Line 122: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.comments,p_old_PRICE_LIST_rec.comments)

118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ATTRIBUTE9;
120: END IF;
121:
122: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.comments,p_old_PRICE_LIST_rec.comments)
123: THEN
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_COMMENTS;
126: END IF;

Line 128: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.context,p_old_PRICE_LIST_rec.context)

124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_COMMENTS;
126: END IF;
127:
128: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.context,p_old_PRICE_LIST_rec.context)
129: THEN
130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_CONTEXT;
132: END IF;

Line 134: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.created_by,p_old_PRICE_LIST_rec.created_by)

130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_CONTEXT;
132: END IF;
133:
134: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.created_by,p_old_PRICE_LIST_rec.created_by)
135: THEN
136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_CREATED_BY;
138: END IF;

Line 140: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.creation_date,p_old_PRICE_LIST_rec.creation_date)

136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_CREATED_BY;
138: END IF;
139:
140: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.creation_date,p_old_PRICE_LIST_rec.creation_date)
141: THEN
142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_CREATION_DATE;
144: END IF;

Line 146: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,p_old_PRICE_LIST_rec.currency_code)

142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_CREATION_DATE;
144: END IF;
145:
146: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,p_old_PRICE_LIST_rec.currency_code)
147: THEN
148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_CURRENCY;
150: END IF;

Line 152: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.description,p_old_PRICE_LIST_rec.description)

148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_CURRENCY;
150: END IF;
151:
152: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.description,p_old_PRICE_LIST_rec.description)
153: THEN
154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_DESCRIPTION;
156: END IF;

Line 158: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.end_date_active,p_old_PRICE_LIST_rec.end_date_active)

154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_DESCRIPTION;
156: END IF;
157:
158: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.end_date_active,p_old_PRICE_LIST_rec.end_date_active)
159: THEN
160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_END_DATE_ACTIVE;
162: END IF;

Line 164: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,p_old_PRICE_LIST_rec.freight_terms_code)

160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_END_DATE_ACTIVE;
162: END IF;
163:
164: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,p_old_PRICE_LIST_rec.freight_terms_code)
165: THEN
166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_FREIGHT_TERMS;
168: END IF;

Line 170: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,p_old_PRICE_LIST_rec.last_updated_by)

166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_FREIGHT_TERMS;
168: END IF;
169:
170: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,p_old_PRICE_LIST_rec.last_updated_by)
171: THEN
172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_LAST_UPDATED_BY;
174: END IF;

Line 176: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,p_old_PRICE_LIST_rec.last_update_date)

172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_LAST_UPDATED_BY;
174: END IF;
175:
176: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,p_old_PRICE_LIST_rec.last_update_date)
177: THEN
178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_LAST_UPDATE_DATE;
180: END IF;

Line 182: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,p_old_PRICE_LIST_rec.last_update_login)

178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_LAST_UPDATE_DATE;
180: END IF;
181:
182: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,p_old_PRICE_LIST_rec.last_update_login)
183: THEN
184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_LAST_UPDATE_LOGIN;
186: END IF;

Line 188: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.name,p_old_PRICE_LIST_rec.name)

184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_LAST_UPDATE_LOGIN;
186: END IF;
187:
188: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.name,p_old_PRICE_LIST_rec.name)
189: THEN
190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_NAME;
192: END IF;

Line 194: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.price_list_id,p_old_PRICE_LIST_rec.price_list_id)

190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_NAME;
192: END IF;
193:
194: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.price_list_id,p_old_PRICE_LIST_rec.price_list_id)
195: THEN
196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_PRICE_LIST;
198: END IF;

Line 200: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.program_application_id,p_old_PRICE_LIST_rec.program_application_id)

196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_PRICE_LIST;
198: END IF;
199:
200: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.program_application_id,p_old_PRICE_LIST_rec.program_application_id)
201: THEN
202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_PROGRAM_APPLICATION;
204: END IF;

Line 206: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.program_id,p_old_PRICE_LIST_rec.program_id)

202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_PROGRAM_APPLICATION;
204: END IF;
205:
206: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.program_id,p_old_PRICE_LIST_rec.program_id)
207: THEN
208: l_index := l_index + 1;
209: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_PROGRAM;
210: END IF;

Line 212: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,p_old_PRICE_LIST_rec.program_update_date)

208: l_index := l_index + 1;
209: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_PROGRAM;
210: END IF;
211:
212: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,p_old_PRICE_LIST_rec.program_update_date)
213: THEN
214: l_index := l_index + 1;
215: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_PROGRAM_UPDATE_DATE;
216: END IF;

Line 218: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.request_id,p_old_PRICE_LIST_rec.request_id)

214: l_index := l_index + 1;
215: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_PROGRAM_UPDATE_DATE;
216: END IF;
217:
218: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.request_id,p_old_PRICE_LIST_rec.request_id)
219: THEN
220: l_index := l_index + 1;
221: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_REQUEST;
222: END IF;

Line 224: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.rounding_factor,p_old_PRICE_LIST_rec.rounding_factor)

220: l_index := l_index + 1;
221: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_REQUEST;
222: END IF;
223:
224: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.rounding_factor,p_old_PRICE_LIST_rec.rounding_factor)
225: THEN
226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ROUNDING_FACTOR;
228: END IF;

Line 230: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.secondary_price_list_id,p_old_PRICE_LIST_rec.secondary_price_list_id)

226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_ROUNDING_FACTOR;
228: END IF;
229:
230: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.secondary_price_list_id,p_old_PRICE_LIST_rec.secondary_price_list_id)
231: THEN
232: l_index := l_index + 1;
233: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_SECONDARY_PRICE_LIST;
234: END IF;

Line 236: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,p_old_PRICE_LIST_rec.ship_method_code)

232: l_index := l_index + 1;
233: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_SECONDARY_PRICE_LIST;
234: END IF;
235:
236: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,p_old_PRICE_LIST_rec.ship_method_code)
237: THEN
238: l_index := l_index + 1;
239: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_SHIP_METHOD;
240: END IF;

Line 242: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.start_date_active,p_old_PRICE_LIST_rec.start_date_active)

238: l_index := l_index + 1;
239: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_SHIP_METHOD;
240: END IF;
241:
242: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.start_date_active,p_old_PRICE_LIST_rec.start_date_active)
243: THEN
244: l_index := l_index + 1;
245: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_START_DATE_ACTIVE;
246: END IF;

Line 248: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,p_old_PRICE_LIST_rec.terms_id)

244: l_index := l_index + 1;
245: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_START_DATE_ACTIVE;
246: END IF;
247:
248: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,p_old_PRICE_LIST_rec.terms_id)
249: THEN
250: l_index := l_index + 1;
251: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_TERMS;
252: END IF;

Line 384: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute1,p_old_PRICE_LIST_rec.attribute1)

380: -- Load out record
381:
382: x_PRICE_LIST_rec := p_PRICE_LIST_rec;
383:
384: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute1,p_old_PRICE_LIST_rec.attribute1)
385: THEN
386: NULL;
387: END IF;
388:

Line 389: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute10,p_old_PRICE_LIST_rec.attribute10)

385: THEN
386: NULL;
387: END IF;
388:
389: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute10,p_old_PRICE_LIST_rec.attribute10)
390: THEN
391: NULL;
392: END IF;
393:

Line 394: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute11,p_old_PRICE_LIST_rec.attribute11)

390: THEN
391: NULL;
392: END IF;
393:
394: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute11,p_old_PRICE_LIST_rec.attribute11)
395: THEN
396: NULL;
397: END IF;
398:

Line 399: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute12,p_old_PRICE_LIST_rec.attribute12)

395: THEN
396: NULL;
397: END IF;
398:
399: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute12,p_old_PRICE_LIST_rec.attribute12)
400: THEN
401: NULL;
402: END IF;
403:

Line 404: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute13,p_old_PRICE_LIST_rec.attribute13)

400: THEN
401: NULL;
402: END IF;
403:
404: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute13,p_old_PRICE_LIST_rec.attribute13)
405: THEN
406: NULL;
407: END IF;
408:

Line 409: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute14,p_old_PRICE_LIST_rec.attribute14)

405: THEN
406: NULL;
407: END IF;
408:
409: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute14,p_old_PRICE_LIST_rec.attribute14)
410: THEN
411: NULL;
412: END IF;
413:

Line 414: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute15,p_old_PRICE_LIST_rec.attribute15)

410: THEN
411: NULL;
412: END IF;
413:
414: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute15,p_old_PRICE_LIST_rec.attribute15)
415: THEN
416: NULL;
417: END IF;
418:

Line 419: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute2,p_old_PRICE_LIST_rec.attribute2)

415: THEN
416: NULL;
417: END IF;
418:
419: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute2,p_old_PRICE_LIST_rec.attribute2)
420: THEN
421: NULL;
422: END IF;
423:

Line 424: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute3,p_old_PRICE_LIST_rec.attribute3)

420: THEN
421: NULL;
422: END IF;
423:
424: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute3,p_old_PRICE_LIST_rec.attribute3)
425: THEN
426: NULL;
427: END IF;
428:

Line 429: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute4,p_old_PRICE_LIST_rec.attribute4)

425: THEN
426: NULL;
427: END IF;
428:
429: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute4,p_old_PRICE_LIST_rec.attribute4)
430: THEN
431: NULL;
432: END IF;
433:

Line 434: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute5,p_old_PRICE_LIST_rec.attribute5)

430: THEN
431: NULL;
432: END IF;
433:
434: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute5,p_old_PRICE_LIST_rec.attribute5)
435: THEN
436: NULL;
437: END IF;
438:

Line 439: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute6,p_old_PRICE_LIST_rec.attribute6)

435: THEN
436: NULL;
437: END IF;
438:
439: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute6,p_old_PRICE_LIST_rec.attribute6)
440: THEN
441: NULL;
442: END IF;
443:

Line 444: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute7,p_old_PRICE_LIST_rec.attribute7)

440: THEN
441: NULL;
442: END IF;
443:
444: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute7,p_old_PRICE_LIST_rec.attribute7)
445: THEN
446: NULL;
447: END IF;
448:

Line 449: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute8,p_old_PRICE_LIST_rec.attribute8)

445: THEN
446: NULL;
447: END IF;
448:
449: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute8,p_old_PRICE_LIST_rec.attribute8)
450: THEN
451: NULL;
452: END IF;
453:

Line 454: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute9,p_old_PRICE_LIST_rec.attribute9)

450: THEN
451: NULL;
452: END IF;
453:
454: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.attribute9,p_old_PRICE_LIST_rec.attribute9)
455: THEN
456: NULL;
457: END IF;
458:

Line 459: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.comments,p_old_PRICE_LIST_rec.comments)

455: THEN
456: NULL;
457: END IF;
458:
459: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.comments,p_old_PRICE_LIST_rec.comments)
460: THEN
461: NULL;
462: END IF;
463:

Line 464: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.context,p_old_PRICE_LIST_rec.context)

460: THEN
461: NULL;
462: END IF;
463:
464: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.context,p_old_PRICE_LIST_rec.context)
465: THEN
466: NULL;
467: END IF;
468:

Line 469: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.created_by,p_old_PRICE_LIST_rec.created_by)

465: THEN
466: NULL;
467: END IF;
468:
469: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.created_by,p_old_PRICE_LIST_rec.created_by)
470: THEN
471: NULL;
472: END IF;
473:

Line 474: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.creation_date,p_old_PRICE_LIST_rec.creation_date)

470: THEN
471: NULL;
472: END IF;
473:
474: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.creation_date,p_old_PRICE_LIST_rec.creation_date)
475: THEN
476: NULL;
477: END IF;
478:

Line 479: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,p_old_PRICE_LIST_rec.currency_code)

475: THEN
476: NULL;
477: END IF;
478:
479: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,p_old_PRICE_LIST_rec.currency_code)
480: THEN
481: NULL;
482: END IF;
483:

Line 484: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.description,p_old_PRICE_LIST_rec.description)

480: THEN
481: NULL;
482: END IF;
483:
484: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.description,p_old_PRICE_LIST_rec.description)
485: THEN
486: NULL;
487: END IF;
488:

Line 489: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.end_date_active,p_old_PRICE_LIST_rec.end_date_active)

485: THEN
486: NULL;
487: END IF;
488:
489: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.end_date_active,p_old_PRICE_LIST_rec.end_date_active)
490: THEN
491: NULL;
492: END IF;
493:

Line 494: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,p_old_PRICE_LIST_rec.freight_terms_code)

490: THEN
491: NULL;
492: END IF;
493:
494: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,p_old_PRICE_LIST_rec.freight_terms_code)
495: THEN
496: NULL;
497: END IF;
498:

Line 499: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,p_old_PRICE_LIST_rec.last_updated_by)

495: THEN
496: NULL;
497: END IF;
498:
499: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,p_old_PRICE_LIST_rec.last_updated_by)
500: THEN
501: NULL;
502: END IF;
503:

Line 504: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,p_old_PRICE_LIST_rec.last_update_date)

500: THEN
501: NULL;
502: END IF;
503:
504: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,p_old_PRICE_LIST_rec.last_update_date)
505: THEN
506: NULL;
507: END IF;
508:

Line 509: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,p_old_PRICE_LIST_rec.last_update_login)

505: THEN
506: NULL;
507: END IF;
508:
509: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,p_old_PRICE_LIST_rec.last_update_login)
510: THEN
511: NULL;
512: END IF;
513:

Line 514: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.name,p_old_PRICE_LIST_rec.name)

510: THEN
511: NULL;
512: END IF;
513:
514: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.name,p_old_PRICE_LIST_rec.name)
515: THEN
516: NULL;
517: END IF;
518:

Line 519: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.price_list_id,p_old_PRICE_LIST_rec.price_list_id)

515: THEN
516: NULL;
517: END IF;
518:
519: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.price_list_id,p_old_PRICE_LIST_rec.price_list_id)
520: THEN
521: NULL;
522: END IF;
523:

Line 524: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.program_application_id,p_old_PRICE_LIST_rec.program_application_id)

520: THEN
521: NULL;
522: END IF;
523:
524: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.program_application_id,p_old_PRICE_LIST_rec.program_application_id)
525: THEN
526: NULL;
527: END IF;
528:

Line 529: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.program_id,p_old_PRICE_LIST_rec.program_id)

525: THEN
526: NULL;
527: END IF;
528:
529: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.program_id,p_old_PRICE_LIST_rec.program_id)
530: THEN
531: NULL;
532: END IF;
533:

Line 534: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,p_old_PRICE_LIST_rec.program_update_date)

530: THEN
531: NULL;
532: END IF;
533:
534: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,p_old_PRICE_LIST_rec.program_update_date)
535: THEN
536: NULL;
537: END IF;
538:

Line 539: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.request_id,p_old_PRICE_LIST_rec.request_id)

535: THEN
536: NULL;
537: END IF;
538:
539: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.request_id,p_old_PRICE_LIST_rec.request_id)
540: THEN
541: NULL;
542: END IF;
543:

Line 544: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.rounding_factor,p_old_PRICE_LIST_rec.rounding_factor)

540: THEN
541: NULL;
542: END IF;
543:
544: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.rounding_factor,p_old_PRICE_LIST_rec.rounding_factor)
545: THEN
546: NULL;
547: END IF;
548:

Line 549: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.secondary_price_list_id,p_old_PRICE_LIST_rec.secondary_price_list_id)

545: THEN
546: NULL;
547: END IF;
548:
549: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.secondary_price_list_id,p_old_PRICE_LIST_rec.secondary_price_list_id)
550: THEN
551: NULL;
552: END IF;
553:

Line 554: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,p_old_PRICE_LIST_rec.ship_method_code)

550: THEN
551: NULL;
552: END IF;
553:
554: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,p_old_PRICE_LIST_rec.ship_method_code)
555: THEN
556: NULL;
557: END IF;
558:

Line 559: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.start_date_active,p_old_PRICE_LIST_rec.start_date_active)

555: THEN
556: NULL;
557: END IF;
558:
559: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.start_date_active,p_old_PRICE_LIST_rec.start_date_active)
560: THEN
561: NULL;
562: END IF;
563:

Line 564: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,p_old_PRICE_LIST_rec.terms_id)

560: THEN
561: NULL;
562: END IF;
563:
564: IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,p_old_PRICE_LIST_rec.terms_id)
565: THEN
566: NULL;
567: END IF;
568:

Line 1575: NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,

1571: BEGIN
1572:
1573: IF p_PRICE_LIST_rec.currency_code IS NOT NULL AND
1574: p_PRICE_LIST_rec.currency_code <> FND_API.G_MISS_CHAR AND
1575: NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,
1576: p_old_PRICE_LIST_rec.currency_code)
1577: THEN
1578: l_PRICE_LIST_val_rec.currency := OE_Id_To_Value.Currency
1579: ( p_currency_code => p_PRICE_LIST_rec.currency_code

Line 1585: NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,

1581: END IF;
1582:
1583: IF p_PRICE_LIST_rec.freight_terms_code IS NOT NULL AND
1584: p_PRICE_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR AND
1585: NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,
1586: p_old_PRICE_LIST_rec.freight_terms_code)
1587: THEN
1588: l_PRICE_LIST_val_rec.freight_terms := OE_Id_To_Value.Freight_Terms
1589: ( p_freight_terms_code => p_PRICE_LIST_rec.freight_terms_code

Line 1598: NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.price_list_id,

1594: /* no need to do this validation :: OEXLPLHB.pls
1595:
1596: IF p_PRICE_LIST_rec.price_list_id IS NOT NULL AND
1597: p_PRICE_LIST_rec.price_list_id <> FND_API.G_MISS_NUM AND
1598: NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.price_list_id,
1599: p_old_PRICE_LIST_rec.price_list_id)
1600: THEN
1601: l_PRICE_LIST_val_rec.price_list := OE_Id_To_Value.Price_List
1602: ( p_price_list_id => p_PRICE_LIST_rec.price_list_id

Line 1611: NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.secondary_price_list_id,

1607: */
1608:
1609: IF p_PRICE_LIST_rec.secondary_price_list_id IS NOT NULL AND
1610: p_PRICE_LIST_rec.secondary_price_list_id <> FND_API.G_MISS_NUM AND
1611: NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.secondary_price_list_id,
1612: p_old_PRICE_LIST_rec.secondary_price_list_id)
1613: THEN
1614: l_PRICE_LIST_val_rec.secondary_price_list := OE_Id_To_Value.Secondary_Price_List
1615: ( p_secondary_price_list_id => p_PRICE_LIST_rec.secondary_price_list_id

Line 1621: NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,

1617: END IF;
1618:
1619: IF p_PRICE_LIST_rec.ship_method_code IS NOT NULL AND
1620: p_PRICE_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR AND
1621: NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,
1622: p_old_PRICE_LIST_rec.ship_method_code)
1623: THEN
1624: l_PRICE_LIST_val_rec.ship_method := OE_Id_To_Value.Ship_Method
1625: ( p_ship_method_code => p_PRICE_LIST_rec.ship_method_code

Line 1631: NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,

1627: END IF;
1628:
1629: IF p_PRICE_LIST_rec.terms_id IS NOT NULL AND
1630: p_PRICE_LIST_rec.terms_id <> FND_API.G_MISS_NUM AND
1631: NOT OE_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,
1632: p_old_PRICE_LIST_rec.terms_id)
1633: THEN
1634: l_PRICE_LIST_val_rec.terms := OE_Id_To_Value.Terms
1635: ( p_terms_id => p_PRICE_LIST_rec.terms_id