APPS.OE_AGREEMENT_UTIL dependencies on OE_GLOBALS

Line 31: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.accounting_rule_id,p_old_Agreement_rec.accounting_rule_id)

27: -- every changed attribute clear its dependent fields.
28:
29: IF p_attr_id = FND_API.G_MISS_NUM THEN
30:
31: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.accounting_rule_id,p_old_Agreement_rec.accounting_rule_id)
32: THEN
33: NULL;
34: END IF;
35:

Line 36: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_contact_id,p_old_Agreement_rec.agreement_contact_id)

32: THEN
33: NULL;
34: END IF;
35:
36: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_contact_id,p_old_Agreement_rec.agreement_contact_id)
37: THEN
38: NULL;
39: END IF;
40:

Line 41: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_id,p_old_Agreement_rec.agreement_id)

37: THEN
38: NULL;
39: END IF;
40:
41: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_id,p_old_Agreement_rec.agreement_id)
42: THEN
43: NULL;
44: END IF;
45:

Line 46: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_num,p_old_Agreement_rec.agreement_num)

42: THEN
43: NULL;
44: END IF;
45:
46: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_num,p_old_Agreement_rec.agreement_num)
47: THEN
48: NULL;
49: END IF;
50:

Line 51: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_type_code,p_old_Agreement_rec.agreement_type_code)

47: THEN
48: NULL;
49: END IF;
50:
51: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_type_code,p_old_Agreement_rec.agreement_type_code)
52: THEN
53: NULL;
54: END IF;
55:

Line 56: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute1,p_old_Agreement_rec.attribute1)

52: THEN
53: NULL;
54: END IF;
55:
56: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute1,p_old_Agreement_rec.attribute1)
57: THEN
58: NULL;
59: END IF;
60:

Line 61: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute10,p_old_Agreement_rec.attribute10)

57: THEN
58: NULL;
59: END IF;
60:
61: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute10,p_old_Agreement_rec.attribute10)
62: THEN
63: NULL;
64: END IF;
65:

Line 66: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute11,p_old_Agreement_rec.attribute11)

62: THEN
63: NULL;
64: END IF;
65:
66: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute11,p_old_Agreement_rec.attribute11)
67: THEN
68: NULL;
69: END IF;
70:

Line 71: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute12,p_old_Agreement_rec.attribute12)

67: THEN
68: NULL;
69: END IF;
70:
71: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute12,p_old_Agreement_rec.attribute12)
72: THEN
73: NULL;
74: END IF;
75:

Line 76: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute13,p_old_Agreement_rec.attribute13)

72: THEN
73: NULL;
74: END IF;
75:
76: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute13,p_old_Agreement_rec.attribute13)
77: THEN
78: NULL;
79: END IF;
80:

Line 81: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute14,p_old_Agreement_rec.attribute14)

77: THEN
78: NULL;
79: END IF;
80:
81: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute14,p_old_Agreement_rec.attribute14)
82: THEN
83: NULL;
84: END IF;
85:

Line 86: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute15,p_old_Agreement_rec.attribute15)

82: THEN
83: NULL;
84: END IF;
85:
86: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute15,p_old_Agreement_rec.attribute15)
87: THEN
88: NULL;
89: END IF;
90:

Line 91: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute2,p_old_Agreement_rec.attribute2)

87: THEN
88: NULL;
89: END IF;
90:
91: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute2,p_old_Agreement_rec.attribute2)
92: THEN
93: NULL;
94: END IF;
95:

Line 96: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute3,p_old_Agreement_rec.attribute3)

92: THEN
93: NULL;
94: END IF;
95:
96: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute3,p_old_Agreement_rec.attribute3)
97: THEN
98: NULL;
99: END IF;
100:

Line 101: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute4,p_old_Agreement_rec.attribute4)

97: THEN
98: NULL;
99: END IF;
100:
101: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute4,p_old_Agreement_rec.attribute4)
102: THEN
103: NULL;
104: END IF;
105:

Line 106: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute5,p_old_Agreement_rec.attribute5)

102: THEN
103: NULL;
104: END IF;
105:
106: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute5,p_old_Agreement_rec.attribute5)
107: THEN
108: NULL;
109: END IF;
110:

Line 111: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute6,p_old_Agreement_rec.attribute6)

107: THEN
108: NULL;
109: END IF;
110:
111: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute6,p_old_Agreement_rec.attribute6)
112: THEN
113: NULL;
114: END IF;
115:

Line 116: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute7,p_old_Agreement_rec.attribute7)

112: THEN
113: NULL;
114: END IF;
115:
116: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute7,p_old_Agreement_rec.attribute7)
117: THEN
118: NULL;
119: END IF;
120:

Line 121: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute8,p_old_Agreement_rec.attribute8)

117: THEN
118: NULL;
119: END IF;
120:
121: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute8,p_old_Agreement_rec.attribute8)
122: THEN
123: NULL;
124: END IF;
125:

Line 126: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute9,p_old_Agreement_rec.attribute9)

122: THEN
123: NULL;
124: END IF;
125:
126: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute9,p_old_Agreement_rec.attribute9)
127: THEN
128: NULL;
129: END IF;
130:

Line 131: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.context,p_old_Agreement_rec.context)

127: THEN
128: NULL;
129: END IF;
130:
131: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.context,p_old_Agreement_rec.context)
132: THEN
133: NULL;
134: END IF;
135:

Line 136: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.created_by,p_old_Agreement_rec.created_by)

132: THEN
133: NULL;
134: END IF;
135:
136: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.created_by,p_old_Agreement_rec.created_by)
137: THEN
138: NULL;
139: END IF;
140:

Line 141: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.creation_date,p_old_Agreement_rec.creation_date)

137: THEN
138: NULL;
139: END IF;
140:
141: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.creation_date,p_old_Agreement_rec.creation_date)
142: THEN
143: NULL;
144: END IF;
145:

Line 146: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.sold_to_org_id,p_old_Agreement_rec.sold_to_org_id)

142: THEN
143: NULL;
144: END IF;
145:
146: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.sold_to_org_id,p_old_Agreement_rec.sold_to_org_id)
147: THEN
148: NULL;
149: END IF;
150:

Line 151: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.end_date_active,p_old_Agreement_rec.end_date_active)

147: THEN
148: NULL;
149: END IF;
150:
151: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.end_date_active,p_old_Agreement_rec.end_date_active)
152: THEN
153: NULL;
154: END IF;
155:

Line 156: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.freight_terms_code,p_old_Agreement_rec.freight_terms_code)

152: THEN
153: NULL;
154: END IF;
155:
156: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.freight_terms_code,p_old_Agreement_rec.freight_terms_code)
157: THEN
158: NULL;
159: END IF;
160:

Line 161: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.invoice_contact_id,p_old_Agreement_rec.invoice_contact_id)

157: THEN
158: NULL;
159: END IF;
160:
161: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.invoice_contact_id,p_old_Agreement_rec.invoice_contact_id)
162: THEN
163: NULL;
164: END IF;
165:

Line 166: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.invoice_to_org_id,p_old_Agreement_rec.invoice_to_org_id)

162: THEN
163: NULL;
164: END IF;
165:
166: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.invoice_to_org_id,p_old_Agreement_rec.invoice_to_org_id)
167: THEN
168: NULL;
169: END IF;
170:

Line 171: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.invoicing_rule_id,p_old_Agreement_rec.invoicing_rule_id)

167: THEN
168: NULL;
169: END IF;
170:
171: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.invoicing_rule_id,p_old_Agreement_rec.invoicing_rule_id)
172: THEN
173: NULL;
174: END IF;
175:

Line 176: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.last_updated_by,p_old_Agreement_rec.last_updated_by)

172: THEN
173: NULL;
174: END IF;
175:
176: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.last_updated_by,p_old_Agreement_rec.last_updated_by)
177: THEN
178: NULL;
179: END IF;
180:

Line 181: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.last_update_date,p_old_Agreement_rec.last_update_date)

177: THEN
178: NULL;
179: END IF;
180:
181: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.last_update_date,p_old_Agreement_rec.last_update_date)
182: THEN
183: NULL;
184: END IF;
185:

Line 186: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.last_update_login,p_old_Agreement_rec.last_update_login)

182: THEN
183: NULL;
184: END IF;
185:
186: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.last_update_login,p_old_Agreement_rec.last_update_login)
187: THEN
188: NULL;
189: END IF;
190:

Line 191: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.name,p_old_Agreement_rec.name)

187: THEN
188: NULL;
189: END IF;
190:
191: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.name,p_old_Agreement_rec.name)
192: THEN
193: NULL;
194: END IF;
195:

Line 196: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.override_arule_flag,p_old_Agreement_rec.override_arule_flag)

192: THEN
193: NULL;
194: END IF;
195:
196: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.override_arule_flag,p_old_Agreement_rec.override_arule_flag)
197: THEN
198: NULL;
199: END IF;
200:

Line 201: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.override_irule_flag,p_old_Agreement_rec.override_irule_flag)

197: THEN
198: NULL;
199: END IF;
200:
201: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.override_irule_flag,p_old_Agreement_rec.override_irule_flag)
202: THEN
203: NULL;
204: END IF;
205:

Line 206: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.price_list_id,p_old_Agreement_rec.price_list_id)

202: THEN
203: NULL;
204: END IF;
205:
206: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.price_list_id,p_old_Agreement_rec.price_list_id)
207: THEN
208: NULL;
209: END IF;
210:

Line 211: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.purchase_order_num,p_old_Agreement_rec.purchase_order_num)

207: THEN
208: NULL;
209: END IF;
210:
211: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.purchase_order_num,p_old_Agreement_rec.purchase_order_num)
212: THEN
213: NULL;
214: END IF;
215:

Line 216: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.revision,p_old_Agreement_rec.revision)

212: THEN
213: NULL;
214: END IF;
215:
216: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.revision,p_old_Agreement_rec.revision)
217: THEN
218: NULL;
219: END IF;
220:

Line 221: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.revision_date,p_old_Agreement_rec.revision_date)

217: THEN
218: NULL;
219: END IF;
220:
221: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.revision_date,p_old_Agreement_rec.revision_date)
222: THEN
223: NULL;
224: END IF;
225:

Line 226: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.revision_reason_code,p_old_Agreement_rec.revision_reason_code)

222: THEN
223: NULL;
224: END IF;
225:
226: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.revision_reason_code,p_old_Agreement_rec.revision_reason_code)
227: THEN
228: NULL;
229: END IF;
230:

Line 231: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.salesrep_id,p_old_Agreement_rec.salesrep_id)

227: THEN
228: NULL;
229: END IF;
230:
231: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.salesrep_id,p_old_Agreement_rec.salesrep_id)
232: THEN
233: NULL;
234: END IF;
235:

Line 236: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.ship_method_code,p_old_Agreement_rec.ship_method_code)

232: THEN
233: NULL;
234: END IF;
235:
236: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.ship_method_code,p_old_Agreement_rec.ship_method_code)
237: THEN
238: NULL;
239: END IF;
240:

Line 241: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.signature_date,p_old_Agreement_rec.signature_date)

237: THEN
238: NULL;
239: END IF;
240:
241: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.signature_date,p_old_Agreement_rec.signature_date)
242: THEN
243: NULL;
244: END IF;
245:

Line 246: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.start_date_active,p_old_Agreement_rec.start_date_active)

242: THEN
243: NULL;
244: END IF;
245:
246: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.start_date_active,p_old_Agreement_rec.start_date_active)
247: THEN
248: NULL;
249: END IF;
250:

Line 251: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.term_id,p_old_Agreement_rec.term_id)

247: THEN
248: NULL;
249: END IF;
250:
251: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.term_id,p_old_Agreement_rec.term_id)
252: THEN
253: NULL;
254: END IF;
255:

Line 257: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_source_code,p_old_Agreement_rec.agreement_source_code)

253: NULL;
254: END IF;
255:
256: --Begin code added by rchellam for OKC
257: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_source_code,p_old_Agreement_rec.agreement_source_code)
258: THEN
259: NULL;
260: END IF;
261:

Line 262: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.orig_system_agr_id,p_old_Agreement_rec.orig_system_agr_id)

258: THEN
259: NULL;
260: END IF;
261:
262: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.orig_system_agr_id,p_old_Agreement_rec.orig_system_agr_id)
263: THEN
264: NULL;
265: END IF;
266: --End code added by rchellam for OKC

Line 269: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.invoice_to_customer_id,p_old_Agreement_rec.invoice_to_customer_id)

265: END IF;
266: --End code added by rchellam for OKC
267:
268: -- Added for bug#4029589
269: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.invoice_to_customer_id,p_old_Agreement_rec.invoice_to_customer_id)
270: THEN
271: NULL;
272: END IF;
273:

Line 401: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.accounting_rule_id,p_old_Agreement_rec.accounting_rule_id)

397: p_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN
398: x_Agreement_rec.sold_to_org_id := -1;
399: END IF;
400:
401: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.accounting_rule_id,p_old_Agreement_rec.accounting_rule_id)
402: THEN
403: NULL;
404: END IF;
405:

Line 406: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_contact_id,p_old_Agreement_rec.agreement_contact_id)

402: THEN
403: NULL;
404: END IF;
405:
406: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_contact_id,p_old_Agreement_rec.agreement_contact_id)
407: THEN
408: NULL;
409: END IF;
410:

Line 411: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_id,p_old_Agreement_rec.agreement_id)

407: THEN
408: NULL;
409: END IF;
410:
411: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_id,p_old_Agreement_rec.agreement_id)
412: THEN
413: NULL;
414: END IF;
415:

Line 416: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_num,p_old_Agreement_rec.agreement_num)

412: THEN
413: NULL;
414: END IF;
415:
416: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_num,p_old_Agreement_rec.agreement_num)
417: THEN
418: NULL;
419: END IF;
420:

Line 421: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_type_code,p_old_Agreement_rec.agreement_type_code)

417: THEN
418: NULL;
419: END IF;
420:
421: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_type_code,p_old_Agreement_rec.agreement_type_code)
422: THEN
423: NULL;
424: END IF;
425:

Line 426: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute1,p_old_Agreement_rec.attribute1)

422: THEN
423: NULL;
424: END IF;
425:
426: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute1,p_old_Agreement_rec.attribute1)
427: THEN
428: NULL;
429: END IF;
430:

Line 431: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute10,p_old_Agreement_rec.attribute10)

427: THEN
428: NULL;
429: END IF;
430:
431: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute10,p_old_Agreement_rec.attribute10)
432: THEN
433: NULL;
434: END IF;
435:

Line 436: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute11,p_old_Agreement_rec.attribute11)

432: THEN
433: NULL;
434: END IF;
435:
436: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute11,p_old_Agreement_rec.attribute11)
437: THEN
438: NULL;
439: END IF;
440:

Line 441: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute12,p_old_Agreement_rec.attribute12)

437: THEN
438: NULL;
439: END IF;
440:
441: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute12,p_old_Agreement_rec.attribute12)
442: THEN
443: NULL;
444: END IF;
445:

Line 446: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute13,p_old_Agreement_rec.attribute13)

442: THEN
443: NULL;
444: END IF;
445:
446: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute13,p_old_Agreement_rec.attribute13)
447: THEN
448: NULL;
449: END IF;
450:

Line 451: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute14,p_old_Agreement_rec.attribute14)

447: THEN
448: NULL;
449: END IF;
450:
451: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute14,p_old_Agreement_rec.attribute14)
452: THEN
453: NULL;
454: END IF;
455:

Line 456: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute15,p_old_Agreement_rec.attribute15)

452: THEN
453: NULL;
454: END IF;
455:
456: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute15,p_old_Agreement_rec.attribute15)
457: THEN
458: NULL;
459: END IF;
460:

Line 461: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute2,p_old_Agreement_rec.attribute2)

457: THEN
458: NULL;
459: END IF;
460:
461: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute2,p_old_Agreement_rec.attribute2)
462: THEN
463: NULL;
464: END IF;
465:

Line 466: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute3,p_old_Agreement_rec.attribute3)

462: THEN
463: NULL;
464: END IF;
465:
466: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute3,p_old_Agreement_rec.attribute3)
467: THEN
468: NULL;
469: END IF;
470:

Line 471: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute4,p_old_Agreement_rec.attribute4)

467: THEN
468: NULL;
469: END IF;
470:
471: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute4,p_old_Agreement_rec.attribute4)
472: THEN
473: NULL;
474: END IF;
475:

Line 476: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute5,p_old_Agreement_rec.attribute5)

472: THEN
473: NULL;
474: END IF;
475:
476: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute5,p_old_Agreement_rec.attribute5)
477: THEN
478: NULL;
479: END IF;
480:

Line 481: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute6,p_old_Agreement_rec.attribute6)

477: THEN
478: NULL;
479: END IF;
480:
481: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute6,p_old_Agreement_rec.attribute6)
482: THEN
483: NULL;
484: END IF;
485:

Line 486: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute7,p_old_Agreement_rec.attribute7)

482: THEN
483: NULL;
484: END IF;
485:
486: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute7,p_old_Agreement_rec.attribute7)
487: THEN
488: NULL;
489: END IF;
490:

Line 491: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute8,p_old_Agreement_rec.attribute8)

487: THEN
488: NULL;
489: END IF;
490:
491: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute8,p_old_Agreement_rec.attribute8)
492: THEN
493: NULL;
494: END IF;
495:

Line 496: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute9,p_old_Agreement_rec.attribute9)

492: THEN
493: NULL;
494: END IF;
495:
496: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.attribute9,p_old_Agreement_rec.attribute9)
497: THEN
498: NULL;
499: END IF;
500:

Line 501: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.context,p_old_Agreement_rec.context)

497: THEN
498: NULL;
499: END IF;
500:
501: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.context,p_old_Agreement_rec.context)
502: THEN
503: NULL;
504: END IF;
505:

Line 506: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.created_by,p_old_Agreement_rec.created_by)

502: THEN
503: NULL;
504: END IF;
505:
506: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.created_by,p_old_Agreement_rec.created_by)
507: THEN
508: NULL;
509: END IF;
510:

Line 511: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.creation_date,p_old_Agreement_rec.creation_date)

507: THEN
508: NULL;
509: END IF;
510:
511: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.creation_date,p_old_Agreement_rec.creation_date)
512: THEN
513: NULL;
514: END IF;
515:

Line 516: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.sold_to_org_id,p_old_Agreement_rec.sold_to_org_id)

512: THEN
513: NULL;
514: END IF;
515:
516: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.sold_to_org_id,p_old_Agreement_rec.sold_to_org_id)
517: THEN
518: NULL;
519: END IF;
520:

Line 521: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.end_date_active,p_old_Agreement_rec.end_date_active)

517: THEN
518: NULL;
519: END IF;
520:
521: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.end_date_active,p_old_Agreement_rec.end_date_active)
522: THEN
523: NULL;
524: END IF;
525:

Line 526: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.freight_terms_code,p_old_Agreement_rec.freight_terms_code)

522: THEN
523: NULL;
524: END IF;
525:
526: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.freight_terms_code,p_old_Agreement_rec.freight_terms_code)
527: THEN
528: NULL;
529: END IF;
530:

Line 531: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.invoice_contact_id,p_old_Agreement_rec.invoice_contact_id)

527: THEN
528: NULL;
529: END IF;
530:
531: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.invoice_contact_id,p_old_Agreement_rec.invoice_contact_id)
532: THEN
533: NULL;
534: END IF;
535:

Line 536: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.invoice_to_org_id,p_old_Agreement_rec.invoice_to_org_id)

532: THEN
533: NULL;
534: END IF;
535:
536: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.invoice_to_org_id,p_old_Agreement_rec.invoice_to_org_id)
537: THEN
538: NULL;
539: END IF;
540:

Line 541: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.invoicing_rule_id,p_old_Agreement_rec.invoicing_rule_id)

537: THEN
538: NULL;
539: END IF;
540:
541: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.invoicing_rule_id,p_old_Agreement_rec.invoicing_rule_id)
542: THEN
543: NULL;
544: END IF;
545:

Line 546: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.last_updated_by,p_old_Agreement_rec.last_updated_by)

542: THEN
543: NULL;
544: END IF;
545:
546: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.last_updated_by,p_old_Agreement_rec.last_updated_by)
547: THEN
548: NULL;
549: END IF;
550:

Line 551: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.last_update_date,p_old_Agreement_rec.last_update_date)

547: THEN
548: NULL;
549: END IF;
550:
551: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.last_update_date,p_old_Agreement_rec.last_update_date)
552: THEN
553: NULL;
554: END IF;
555:

Line 556: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.last_update_login,p_old_Agreement_rec.last_update_login)

552: THEN
553: NULL;
554: END IF;
555:
556: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.last_update_login,p_old_Agreement_rec.last_update_login)
557: THEN
558: NULL;
559: END IF;
560:

Line 561: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.name,p_old_Agreement_rec.name)

557: THEN
558: NULL;
559: END IF;
560:
561: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.name,p_old_Agreement_rec.name)
562: THEN
563: NULL;
564: END IF;
565:

Line 566: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.override_arule_flag,p_old_Agreement_rec.override_arule_flag)

562: THEN
563: NULL;
564: END IF;
565:
566: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.override_arule_flag,p_old_Agreement_rec.override_arule_flag)
567: THEN
568: NULL;
569: END IF;
570:

Line 571: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.override_irule_flag,p_old_Agreement_rec.override_irule_flag)

567: THEN
568: NULL;
569: END IF;
570:
571: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.override_irule_flag,p_old_Agreement_rec.override_irule_flag)
572: THEN
573: NULL;
574: END IF;
575:

Line 576: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.price_list_id,p_old_Agreement_rec.price_list_id)

572: THEN
573: NULL;
574: END IF;
575:
576: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.price_list_id,p_old_Agreement_rec.price_list_id)
577: THEN
578: NULL;
579: END IF;
580:

Line 581: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.purchase_order_num,p_old_Agreement_rec.purchase_order_num)

577: THEN
578: NULL;
579: END IF;
580:
581: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.purchase_order_num,p_old_Agreement_rec.purchase_order_num)
582: THEN
583: NULL;
584: END IF;
585:

Line 586: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.revision,p_old_Agreement_rec.revision)

582: THEN
583: NULL;
584: END IF;
585:
586: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.revision,p_old_Agreement_rec.revision)
587: THEN
588: NULL;
589: END IF;
590:

Line 591: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.revision_date,p_old_Agreement_rec.revision_date)

587: THEN
588: NULL;
589: END IF;
590:
591: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.revision_date,p_old_Agreement_rec.revision_date)
592: THEN
593: NULL;
594: END IF;
595:

Line 596: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.revision_reason_code,p_old_Agreement_rec.revision_reason_code)

592: THEN
593: NULL;
594: END IF;
595:
596: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.revision_reason_code,p_old_Agreement_rec.revision_reason_code)
597: THEN
598: NULL;
599: END IF;
600:

Line 601: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.salesrep_id,p_old_Agreement_rec.salesrep_id)

597: THEN
598: NULL;
599: END IF;
600:
601: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.salesrep_id,p_old_Agreement_rec.salesrep_id)
602: THEN
603: NULL;
604: END IF;
605:

Line 606: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.ship_method_code,p_old_Agreement_rec.ship_method_code)

602: THEN
603: NULL;
604: END IF;
605:
606: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.ship_method_code,p_old_Agreement_rec.ship_method_code)
607: THEN
608: NULL;
609: END IF;
610:

Line 611: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.signature_date,p_old_Agreement_rec.signature_date)

607: THEN
608: NULL;
609: END IF;
610:
611: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.signature_date,p_old_Agreement_rec.signature_date)
612: THEN
613: NULL;
614: END IF;
615:

Line 616: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.start_date_active,p_old_Agreement_rec.start_date_active)

612: THEN
613: NULL;
614: END IF;
615:
616: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.start_date_active,p_old_Agreement_rec.start_date_active)
617: THEN
618: NULL;
619: END IF;
620:

Line 621: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.term_id,p_old_Agreement_rec.term_id)

617: THEN
618: NULL;
619: END IF;
620:
621: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.term_id,p_old_Agreement_rec.term_id)
622: THEN
623: NULL;
624: END IF;
625:

Line 627: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_source_code,p_old_Agreement_rec.agreement_source_code)

623: NULL;
624: END IF;
625:
626: --Begin code added by rchellam for OKC
627: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_source_code,p_old_Agreement_rec.agreement_source_code)
628: THEN
629: NULL;
630: END IF;
631:

Line 632: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.orig_system_agr_id,p_old_Agreement_rec.orig_system_agr_id)

628: THEN
629: NULL;
630: END IF;
631:
632: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.orig_system_agr_id,p_old_Agreement_rec.orig_system_agr_id)
633: THEN
634: NULL;
635: END IF;
636: --End code added by rchellam for OKC

Line 639: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.invoice_to_customer_id,p_old_Agreement_rec.invoice_to_customer_id)

635: END IF;
636: --End code added by rchellam for OKC
637:
638: -- Added for bug#4029589
639: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.invoice_to_customer_id,p_old_Agreement_rec.invoice_to_customer_id)
640: THEN
641: NULL;
642: END IF;
643: oe_debug_pub.add('Exiting OE_Agreement_Util.Apply_Attribute_Changes');

Line 2281: NOT OE_GLOBALS.Equal(p_Agreement_rec.accounting_rule_id,

2277: oe_debug_pub.add('Entering OE_Agreement_Util.Get_Values');
2278:
2279: IF p_Agreement_rec.accounting_rule_id IS NOT NULL AND
2280: p_Agreement_rec.accounting_rule_id <> FND_API.G_MISS_NUM AND
2281: NOT OE_GLOBALS.Equal(p_Agreement_rec.accounting_rule_id,
2282: p_old_Agreement_rec.accounting_rule_id)
2283: THEN
2284: l_Agreement_val_rec.accounting_rule := QP_Id_To_Value.Accounting_Rule
2285: ( p_accounting_rule_id => p_Agreement_rec.accounting_rule_id

Line 2291: NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_contact_id,

2287: END IF;
2288:
2289: IF p_Agreement_rec.agreement_contact_id IS NOT NULL AND
2290: p_Agreement_rec.agreement_contact_id <> FND_API.G_MISS_NUM AND
2291: NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_contact_id,
2292: p_old_Agreement_rec.agreement_contact_id)
2293: THEN
2294: l_Agreement_val_rec.agreement_contact := QP_Id_To_Value.Agreement_Contact
2295: ( p_agreement_contact_id => p_Agreement_rec.agreement_contact_id

Line 2303: NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_id,

2299: /*changes made by spgopal for 'AGR' fix 08/10/00*/
2300: /*
2301: IF p_Agreement_rec.agreement_id IS NOT NULL AND
2302: p_Agreement_rec.agreement_id <> FND_API.G_MISS_NUM AND
2303: NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_id,
2304: p_old_Agreement_rec.agreement_id)
2305: THEN
2306: l_Agreement_val_rec.agreement := QP_Id_To_Value.Agreement
2307: ( p_agreement_id => p_Agreement_rec.agreement_id

Line 2314: NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_type_code,

2310: */
2311:
2312: IF p_Agreement_rec.agreement_type_code IS NOT NULL AND
2313: p_Agreement_rec.agreement_type_code <> FND_API.G_MISS_CHAR AND
2314: NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_type_code,
2315: p_old_Agreement_rec.agreement_type_code)
2316: THEN
2317: l_Agreement_val_rec.agreement_type := QP_Id_To_Value.Agreement_Type
2318: ( p_agreement_type_code => p_Agreement_rec.agreement_type_code

Line 2324: NOT OE_GLOBALS.Equal(p_Agreement_rec.sold_to_org_id,

2320: END IF;
2321:
2322: IF p_Agreement_rec.sold_to_org_id IS NOT NULL AND
2323: p_Agreement_rec.sold_to_org_id <> FND_API.G_MISS_NUM AND
2324: NOT OE_GLOBALS.Equal(p_Agreement_rec.sold_to_org_id,
2325: p_old_Agreement_rec.sold_to_org_id)
2326: THEN
2327: l_Agreement_val_rec.customer := QP_Id_To_Value.Customer
2328: ( p_sold_to_org_id => p_Agreement_rec.sold_to_org_id

Line 2334: NOT OE_GLOBALS.Equal(p_Agreement_rec.freight_terms_code,

2330: END IF;
2331:
2332: IF p_Agreement_rec.freight_terms_code IS NOT NULL AND
2333: p_Agreement_rec.freight_terms_code <> FND_API.G_MISS_CHAR AND
2334: NOT OE_GLOBALS.Equal(p_Agreement_rec.freight_terms_code,
2335: p_old_Agreement_rec.freight_terms_code)
2336: THEN
2337: l_Agreement_val_rec.freight_terms := QP_Id_To_Value.Freight_Terms
2338: ( p_freight_terms_code => p_Agreement_rec.freight_terms_code

Line 2344: NOT OE_GLOBALS.Equal(p_Agreement_rec.invoice_contact_id,

2340: END IF;
2341:
2342: IF p_Agreement_rec.invoice_contact_id IS NOT NULL AND
2343: p_Agreement_rec.invoice_contact_id <> FND_API.G_MISS_NUM AND
2344: NOT OE_GLOBALS.Equal(p_Agreement_rec.invoice_contact_id,
2345: p_old_Agreement_rec.invoice_contact_id)
2346: THEN
2347: l_Agreement_val_rec.invoice_contact := QP_Id_To_Value.Invoice_Contact
2348: ( p_invoice_contact_id => p_Agreement_rec.invoice_contact_id

Line 2354: NOT OE_GLOBALS.Equal(p_Agreement_rec.invoice_to_org_id,

2350: END IF;
2351:
2352: IF p_Agreement_rec.invoice_to_org_id IS NOT NULL AND
2353: p_Agreement_rec.invoice_to_org_id <> FND_API.G_MISS_NUM AND
2354: NOT OE_GLOBALS.Equal(p_Agreement_rec.invoice_to_org_id,
2355: p_old_Agreement_rec.invoice_to_org_id)
2356: THEN
2357: l_Agreement_val_rec.invoice_to_site_use := QP_Id_To_Value.Invoice_To_Site_Use
2358: ( p_invoice_to_org_id => p_Agreement_rec.invoice_to_org_id

Line 2364: NOT OE_GLOBALS.Equal(p_Agreement_rec.invoicing_rule_id,

2360: END IF;
2361:
2362: IF p_Agreement_rec.invoicing_rule_id IS NOT NULL AND
2363: p_Agreement_rec.invoicing_rule_id <> FND_API.G_MISS_NUM AND
2364: NOT OE_GLOBALS.Equal(p_Agreement_rec.invoicing_rule_id,
2365: p_old_Agreement_rec.invoicing_rule_id)
2366: THEN
2367: l_Agreement_val_rec.invoicing_rule := QP_Id_To_Value.Invoicing_Rule
2368: ( p_invoicing_rule_id => p_Agreement_rec.invoicing_rule_id

Line 2374: NOT OE_GLOBALS.Equal(p_Agreement_rec.override_arule_flag,

2370: END IF;
2371:
2372: IF p_Agreement_rec.override_arule_flag IS NOT NULL AND
2373: p_Agreement_rec.override_arule_flag <> FND_API.G_MISS_CHAR AND
2374: NOT OE_GLOBALS.Equal(p_Agreement_rec.override_arule_flag,
2375: p_old_Agreement_rec.override_arule_flag)
2376: THEN
2377: l_Agreement_val_rec.override_arule := QP_Id_To_Value.Override_Arule
2378: ( p_override_arule_flag => p_Agreement_rec.override_arule_flag

Line 2384: NOT OE_GLOBALS.Equal(p_Agreement_rec.override_irule_flag,

2380: END IF;
2381:
2382: IF p_Agreement_rec.override_irule_flag IS NOT NULL AND
2383: p_Agreement_rec.override_irule_flag <> FND_API.G_MISS_CHAR AND
2384: NOT OE_GLOBALS.Equal(p_Agreement_rec.override_irule_flag,
2385: p_old_Agreement_rec.override_irule_flag)
2386: THEN
2387: l_Agreement_val_rec.override_irule := QP_Id_To_Value.Override_Irule
2388: ( p_override_irule_flag => p_Agreement_rec.override_irule_flag

Line 2394: NOT OE_GLOBALS.Equal(p_Agreement_rec.price_list_id,

2390: END IF;
2391:
2392: IF p_Agreement_rec.price_list_id IS NOT NULL AND
2393: p_Agreement_rec.price_list_id <> FND_API.G_MISS_NUM AND
2394: NOT OE_GLOBALS.Equal(p_Agreement_rec.price_list_id,
2395: p_old_Agreement_rec.price_list_id)
2396: THEN
2397: l_Agreement_val_rec.price_list := QP_Id_To_Value.Price_List
2398: ( p_price_list_id => p_Agreement_rec.price_list_id

Line 2404: NOT OE_GLOBALS.Equal(p_Agreement_rec.revision_reason_code,

2400: END IF;
2401:
2402: IF p_Agreement_rec.revision_reason_code IS NOT NULL AND
2403: p_Agreement_rec.revision_reason_code <> FND_API.G_MISS_CHAR AND
2404: NOT OE_GLOBALS.Equal(p_Agreement_rec.revision_reason_code,
2405: p_old_Agreement_rec.revision_reason_code)
2406: THEN
2407: l_Agreement_val_rec.revision_reason := QP_Id_To_Value.Revision_Reason
2408: ( p_revision_reason_code => p_Agreement_rec.revision_reason_code

Line 2414: NOT OE_GLOBALS.Equal(p_Agreement_rec.salesrep_id,

2410: END IF;
2411:
2412: IF p_Agreement_rec.salesrep_id IS NOT NULL AND
2413: p_Agreement_rec.salesrep_id <> FND_API.G_MISS_NUM AND
2414: NOT OE_GLOBALS.Equal(p_Agreement_rec.salesrep_id,
2415: p_old_Agreement_rec.salesrep_id)
2416: THEN
2417: l_Agreement_val_rec.salesrep := QP_Id_To_Value.Salesrep
2418: ( p_salesrep_id => p_Agreement_rec.salesrep_id

Line 2424: NOT OE_GLOBALS.Equal(p_Agreement_rec.ship_method_code,

2420: END IF;
2421:
2422: IF p_Agreement_rec.ship_method_code IS NOT NULL AND
2423: p_Agreement_rec.ship_method_code <> FND_API.G_MISS_CHAR AND
2424: NOT OE_GLOBALS.Equal(p_Agreement_rec.ship_method_code,
2425: p_old_Agreement_rec.ship_method_code)
2426: THEN
2427: l_Agreement_val_rec.ship_method := QP_Id_To_Value.Ship_Method
2428: ( p_ship_method_code => p_Agreement_rec.ship_method_code

Line 2434: NOT OE_GLOBALS.Equal(p_Agreement_rec.term_id,

2430: END IF;
2431:
2432: IF p_Agreement_rec.term_id IS NOT NULL AND
2433: p_Agreement_rec.term_id <> FND_API.G_MISS_NUM AND
2434: NOT OE_GLOBALS.Equal(p_Agreement_rec.term_id,
2435: p_old_Agreement_rec.term_id)
2436: THEN
2437: l_Agreement_val_rec.term := QP_Id_To_Value.Term
2438: ( p_term_id => p_Agreement_rec.term_id

Line 2445: NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_source_code,

2441:
2442: --Begin code added by rchellam for OKC
2443: IF p_Agreement_rec.agreement_source_code IS NOT NULL AND
2444: p_Agreement_rec.agreement_source_code <> FND_API.G_MISS_CHAR AND
2445: NOT OE_GLOBALS.Equal(p_Agreement_rec.agreement_source_code,
2446: p_old_Agreement_rec.agreement_source_code)
2447: THEN
2448: l_Agreement_val_rec.agreement_source := QP_Id_To_Value.Agreement_Source
2449: ( p_agreement_source_code => p_Agreement_rec.agreement_source_code