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

Line 114: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

110: l_gen_xml := 'B';
111: End If;
112: End If;
113: OE_delayed_requests_pvt.log_request
114: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
115: p_entity_id => p_record.header_id,
116: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
117: p_requesting_entity_id => p_record.header_id,
118: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,

Line 116: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

112: End If;
113: OE_delayed_requests_pvt.log_request
114: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
115: p_entity_id => p_record.header_id,
116: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
117: p_requesting_entity_id => p_record.header_id,
118: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,
119: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
120: p_param1 => p_record.header_id,

Line 118: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,

114: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
115: p_entity_id => p_record.header_id,
116: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
117: p_requesting_entity_id => p_record.header_id,
118: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,
119: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
120: p_param1 => p_record.header_id,
121: p_param2 => p_record.order_source_id,
122: p_param3 => p_record.orig_sys_document_ref,

Line 164: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

160: l_gen_xml := 'B';
161: End If;
162: End If;
163: OE_delayed_requests_pvt.log_request
164: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
165: p_entity_id => p_record.header_id,
166: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
167: p_requesting_entity_id => p_record.header_id,
168: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,

Line 166: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

162: End If;
163: OE_delayed_requests_pvt.log_request
164: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
165: p_entity_id => p_record.header_id,
166: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
167: p_requesting_entity_id => p_record.header_id,
168: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,
169: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
170: p_param1 => p_record.header_id,

Line 168: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,

164: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
165: p_entity_id => p_record.header_id,
166: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
167: p_requesting_entity_id => p_record.header_id,
168: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,
169: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
170: p_param1 => p_record.header_id,
171: p_param2 => p_record.order_source_id,
172: p_param3 => p_record.orig_sys_document_ref,

Line 193: not OE_GLOBALS.G_HEADER_CREATED

189: nvl(p_record.transaction_phase_code,'F') = 'F'
190: Then
191: If g_is_caller_defaulting = 'N' And
192: nvl(l_audit_trail_enabled,'D') <> 'D' And
193: not OE_GLOBALS.G_HEADER_CREATED
194: Then
195: If l_audit_trail_enabled = 'B' Then
196: If p_record.booked_flag = 'Y' Then
197: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';

Line 197: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';

193: not OE_GLOBALS.G_HEADER_CREATED
194: Then
195: If l_audit_trail_enabled = 'B' Then
196: If p_record.booked_flag = 'Y' Then
197: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
198: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
199: End If;
200: Else
201: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';

Line 198: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';

194: Then
195: If l_audit_trail_enabled = 'B' Then
196: If p_record.booked_flag = 'Y' Then
197: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
198: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
199: End If;
200: Else
201: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
202: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';

Line 201: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';

197: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
198: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
199: End If;
200: Else
201: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
202: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
203: End IF;
204: End If;
205:

Line 202: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';

198: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
199: End If;
200: Else
201: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
202: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
203: End IF;
204: End If;
205:
206: If p_record.order_source_id = 20 Then

Line 225: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

221: End If;
222: End If;
223:
224: OE_delayed_requests_pvt.log_request
225: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
226: p_entity_id => p_record.header_id,
227: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
228: p_requesting_entity_id => p_record.header_id,
229: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,

Line 227: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

223:
224: OE_delayed_requests_pvt.log_request
225: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
226: p_entity_id => p_record.header_id,
227: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
228: p_requesting_entity_id => p_record.header_id,
229: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,
230: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
231: p_param1 => p_record.header_id,

Line 229: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,

225: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
226: p_entity_id => p_record.header_id,
227: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
228: p_requesting_entity_id => p_record.header_id,
229: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,
230: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
231: p_param1 => p_record.header_id,
232: p_param2 => p_record.order_source_id,
233: p_param3 => p_record.orig_sys_document_ref,

Line 254: not OE_GLOBALS.G_HEADER_CREATED THEN

250: /* Start AuditTrail */
251: IF g_is_caller_defaulting = 'N' THEN
252: IF l_code_level >= '110508' and nvl(l_audit_trail_enabled,'D') <> 'D' and
253: nvl(p_record.transaction_phase_code,'F') = 'F' and
254: not OE_GLOBALS.G_HEADER_CREATED THEN
255: IF l_audit_trail_enabled = 'B' THEN -- capture only for booked orders
256: IF p_record.booked_flag = 'Y' THEN
257: IF l_result = OE_PC_GLOBALS.YES THEN
258: IF x_on_operation_action = 1 THEN

Line 263: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';

259: -- set OUT result to NOT CONSTRAINED
260: IF l_debug_level > 0 THEN
261: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;
262: END IF;
263: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
264: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
265: ELSIF x_on_operation_action = 2 THEN
266: -- set OUT result to NOT CONSTRAINED
267: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then

Line 264: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';

260: IF l_debug_level > 0 THEN
261: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;
262: END IF;
263: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
264: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
265: ELSIF x_on_operation_action = 2 THEN
266: -- set OUT result to NOT CONSTRAINED
267: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
268: IF l_debug_level > 0 THEN

Line 267: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then

263: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
264: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
265: ELSIF x_on_operation_action = 2 THEN
266: -- set OUT result to NOT CONSTRAINED
267: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
268: IF l_debug_level > 0 THEN
269: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;
270: END IF;
271: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

Line 271: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

267: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
268: IF l_debug_level > 0 THEN
269: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;
270: END IF;
271: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
272: END IF;
273: END IF;
274: END IF;
275: END IF;

Line 283: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';

279: -- set OUT result to NOT CONSTRAINED
280: IF l_debug_level > 0 THEN
281: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;
282: END IF;
283: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
284: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
285: ELSIF x_on_operation_action = 2 THEN
286: -- set OUT result to NOT CONSTRAINED
287: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then

Line 284: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';

280: IF l_debug_level > 0 THEN
281: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;
282: END IF;
283: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
284: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
285: ELSIF x_on_operation_action = 2 THEN
286: -- set OUT result to NOT CONSTRAINED
287: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
288: IF l_debug_level > 0 THEN

Line 287: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then

283: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
284: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
285: ELSIF x_on_operation_action = 2 THEN
286: -- set OUT result to NOT CONSTRAINED
287: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
288: IF l_debug_level > 0 THEN
289: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;
290: END IF;
291: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

Line 291: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

287: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
288: IF l_debug_level > 0 THEN
289: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;
290: END IF;
291: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
292: END IF;
293: END IF;
294: END IF;
295: END IF;

Line 2371: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

2367:
2368: -- Initializing return status to SUCCESS
2369: x_return_status := FND_API.G_RET_STS_SUCCESS;
2370:
2371: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2372: l_operation := OE_PC_GLOBALS.CREATE_OP;
2373: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2374: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2375: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

Line 2373: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

2369: x_return_status := FND_API.G_RET_STS_SUCCESS;
2370:
2371: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2372: l_operation := OE_PC_GLOBALS.CREATE_OP;
2373: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2374: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2375: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
2376: l_operation := OE_PC_GLOBALS.DELETE_OP;
2377: ELSE

Line 2375: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

2371: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2372: l_operation := OE_PC_GLOBALS.CREATE_OP;
2373: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2374: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2375: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
2376: l_operation := OE_PC_GLOBALS.DELETE_OP;
2377: ELSE
2378: IF l_debug_level > 0 THEN
2379: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;

Line 2443: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

2439: -- Initializing out result to NOT CONSTRAINED
2440: x_result := OE_PC_GLOBALS.NO;
2441:
2442: -- Get the operation code to be passed to the security framework API
2443: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2444: -- Bug 1987983 : if the order source is Copy then skip the Attribute
2445: -- level check
2446: IF p_HEADER_rec.source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_COPY
2447: THEN

Line 2446: IF p_HEADER_rec.source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_COPY

2442: -- Get the operation code to be passed to the security framework API
2443: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2444: -- Bug 1987983 : if the order source is Copy then skip the Attribute
2445: -- level check
2446: IF p_HEADER_rec.source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_COPY
2447: THEN
2448: RETURN;
2449: ELSE
2450: l_operation := OE_PC_GLOBALS.CREATE_OP;

Line 2465: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

2461: THEN
2462: RETURN;
2463: END IF;
2464:
2465: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2466: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2467: ELSE
2468: IF l_debug_level > 0 THEN
2469: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;

Line 2483: AND NOT OE_GLOBALS.Equal(p_header_rec.cancelled_flag,

2479: -- Compare the new and old entity records and
2480: -- check constraints for all the changed attributes.
2481:
2482: IF p_header_rec.cancelled_flag <> FND_API.G_MISS_CHAR
2483: AND NOT OE_GLOBALS.Equal(p_header_rec.cancelled_flag,
2484: p_old_header_rec.cancelled_flag)
2485: THEN
2486: IF p_header_rec.cancelled_flag = 'Y' THEN
2487: l_result := CANCELLED

Line 2502: AND (NOT oe_globals.equal(p_header_rec.price_list_id,

2498:
2499: END IF;
2500:
2501: IF ((p_header_rec.price_list_id IS NOT NULL)
2502: AND (NOT oe_globals.equal(p_header_rec.price_list_id,
2503: p_old_HEADER_rec.price_list_id))
2504: AND (p_header_rec.order_category_code IS NOT NULL)
2505: AND (p_header_rec.order_category_code <>
2506: Oe_Globals.G_RETURN_CATEGORY_CODE)) THEN

Line 2506: Oe_Globals.G_RETURN_CATEGORY_CODE)) THEN

2502: AND (NOT oe_globals.equal(p_header_rec.price_list_id,
2503: p_old_HEADER_rec.price_list_id))
2504: AND (p_header_rec.order_category_code IS NOT NULL)
2505: AND (p_header_rec.order_category_code <>
2506: Oe_Globals.G_RETURN_CATEGORY_CODE)) THEN
2507: BEGIN
2508: SELECT active_flag
2509: INTO l_active_flag
2510: FROM qp_List_headers_vl

Line 2527: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.accounting_rule_id,p_old_header_rec.accounting_rule_id) THEN

2523: END;
2524: END IF;
2525:
2526: IF p_header_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN NULL;
2527: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.accounting_rule_id,p_old_header_rec.accounting_rule_id) THEN
2528:
2529: l_result := ACCOUNTING_RULE
2530: (p_operation => l_operation
2531: ,p_record => l_rowtype_rec

Line 2543: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.IB_OWNER,p_old_header_rec.IB_OWNER) THEN

2539:
2540: END IF;
2541:
2542: IF p_header_rec.IB_OWNER = FND_API.G_MISS_CHAR THEN NULL;
2543: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.IB_OWNER,p_old_header_rec.IB_OWNER) THEN
2544:
2545: l_result := IB_OWNER
2546: (p_operation => l_operation
2547: ,p_record => l_rowtype_rec

Line 2558: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.IB_INSTALLED_AT_LOCATION,p_old_header_rec.IB_INSTALLED_AT_LOCATION) THEN

2554: END IF;
2555:
2556: END IF;
2557: IF p_header_rec.IB_INSTALLED_AT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;
2558: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.IB_INSTALLED_AT_LOCATION,p_old_header_rec.IB_INSTALLED_AT_LOCATION) THEN
2559:
2560: l_result := IB_INSTALLED_AT_LOCATION
2561: (p_operation => l_operation
2562: ,p_record => l_rowtype_rec

Line 2573: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.IB_CURRENT_LOCATION,p_old_header_rec.IB_CURRENT_LOCATION) THEN

2569: END IF;
2570:
2571: END IF;
2572: IF p_header_rec.IB_CURRENT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;
2573: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.IB_CURRENT_LOCATION,p_old_header_rec.IB_CURRENT_LOCATION) THEN
2574:
2575: l_result := IB_CURRENT_LOCATION
2576: (p_operation => l_operation
2577: ,p_record => l_rowtype_rec

Line 2588: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.END_CUSTOMER_ID,p_old_header_rec.END_CUSTOMER_ID) THEN

2584: END IF;
2585:
2586: END IF;
2587: IF p_header_rec.END_CUSTOMER_ID = FND_API.G_MISS_NUM THEN NULL;
2588: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.END_CUSTOMER_ID,p_old_header_rec.END_CUSTOMER_ID) THEN
2589:
2590: l_result := END_CUSTOMER
2591: (p_operation => l_operation
2592: ,p_record => l_rowtype_rec

Line 2603: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.END_CUSTOMER_SITE_USE_ID,p_old_header_rec.END_CUSTOMER_SITE_USE_ID) THEN

2599: END IF;
2600:
2601: END IF;
2602: IF p_header_rec.END_CUSTOMER_SITE_USE_ID = FND_API.G_MISS_NUM THEN NULL;
2603: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.END_CUSTOMER_SITE_USE_ID,p_old_header_rec.END_CUSTOMER_SITE_USE_ID) THEN
2604:
2605: l_result := END_CUSTOMER_SITE_USE
2606: (p_operation => l_operation
2607: ,p_record => l_rowtype_rec

Line 2618: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.END_CUSTOMER_CONTACT_ID,p_old_header_rec.END_CUSTOMER_CONTACT_ID) THEN

2614: END IF;
2615:
2616: END IF;
2617: IF p_header_rec.END_CUSTOMER_CONTACT_ID = FND_API.G_MISS_NUM THEN NULL;
2618: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.END_CUSTOMER_CONTACT_ID,p_old_header_rec.END_CUSTOMER_CONTACT_ID) THEN
2619:
2620: l_result := END_CUSTOMER_CONTACT
2621: (p_operation => l_operation
2622: ,p_record => l_rowtype_rec

Line 2634: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.accounting_rule_duration,p_old_header_rec.accounting_rule_duration) THEN

2630:
2631: END IF;
2632:
2633: IF p_header_rec.accounting_rule_duration = FND_API.G_MISS_NUM THEN NULL;
2634: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.accounting_rule_duration,p_old_header_rec.accounting_rule_duration) THEN
2635:
2636: l_result := ACCOUNTING_RULE_DURATION
2637: (p_operation => l_operation
2638: ,p_record => l_rowtype_rec

Line 2650: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.agreement_id,p_old_header_rec.agreement_id) THEN

2646:
2647: END IF;
2648:
2649: IF p_header_rec.agreement_id = FND_API.G_MISS_NUM THEN NULL;
2650: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.agreement_id,p_old_header_rec.agreement_id) THEN
2651:
2652: l_result := AGREEMENT
2653: (p_operation => l_operation
2654: ,p_record => l_rowtype_rec

Line 2666: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.conversion_rate,p_old_header_rec.conversion_rate) THEN

2662:
2663: END IF;
2664:
2665: IF p_header_rec.conversion_rate = FND_API.G_MISS_NUM THEN NULL;
2666: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.conversion_rate,p_old_header_rec.conversion_rate) THEN
2667:
2668: l_result := CONVERSION_RATE
2669: (p_operation => l_operation
2670: ,p_record => l_rowtype_rec

Line 2682: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.conversion_rate_date,p_old_header_rec.conversion_rate_date) THEN

2678:
2679: END IF;
2680:
2681: IF p_header_rec.conversion_rate_date = FND_API.G_MISS_DATE THEN NULL;
2682: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.conversion_rate_date,p_old_header_rec.conversion_rate_date) THEN
2683:
2684: l_result := CONVERSION_RATE_DATE
2685: (p_operation => l_operation
2686: ,p_record => l_rowtype_rec

Line 2698: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.conversion_type_code,p_old_header_rec.conversion_type_code) THEN

2694:
2695: END IF;
2696:
2697: IF p_header_rec.conversion_type_code = FND_API.G_MISS_CHAR THEN NULL;
2698: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.conversion_type_code,p_old_header_rec.conversion_type_code) THEN
2699:
2700: l_result := CONVERSION_TYPE
2701: (p_operation => l_operation
2702: ,p_record => l_rowtype_rec

Line 2714: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.created_by,p_old_header_rec.created_by) THEN

2710:
2711: END IF;
2712:
2713: IF p_header_rec.created_by = FND_API.G_MISS_NUM THEN NULL;
2714: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.created_by,p_old_header_rec.created_by) THEN
2715:
2716: l_result := CREATED_BY
2717: (p_operation => l_operation
2718: ,p_record => l_rowtype_rec

Line 2730: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.cust_po_number,p_old_header_rec.cust_po_number) THEN

2726:
2727: END IF;
2728:
2729: IF p_header_rec.cust_po_number = FND_API.G_MISS_CHAR THEN NULL;
2730: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.cust_po_number,p_old_header_rec.cust_po_number) THEN
2731:
2732: l_result := CUST_PO_NUMBER
2733: (p_operation => l_operation
2734: ,p_record => l_rowtype_rec

Line 2746: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_contact_id,p_old_header_rec.deliver_to_contact_id) THEN

2742:
2743: END IF;
2744:
2745: IF p_header_rec.deliver_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
2746: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_contact_id,p_old_header_rec.deliver_to_contact_id) THEN
2747:
2748: l_result := DELIVER_TO_CONTACT
2749: (p_operation => l_operation
2750: ,p_record => l_rowtype_rec

Line 2762: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id,p_old_header_rec.deliver_to_org_id) THEN

2758:
2759: END IF;
2760:
2761: IF p_header_rec.deliver_to_org_id = FND_API.G_MISS_NUM THEN NULL;
2762: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id,p_old_header_rec.deliver_to_org_id) THEN
2763:
2764: l_result := DELIVER_TO_ORG
2765: (p_operation => l_operation
2766: ,p_record => l_rowtype_rec

Line 2778: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.demand_class_code,p_old_header_rec.demand_class_code) THEN

2774:
2775: END IF;
2776:
2777: IF p_header_rec.demand_class_code = FND_API.G_MISS_CHAR THEN NULL;
2778: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.demand_class_code,p_old_header_rec.demand_class_code) THEN
2779:
2780: l_result := DEMAND_CLASS
2781: (p_operation => l_operation
2782: ,p_record => l_rowtype_rec

Line 2794: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.earliest_schedule_limit,p_old_header_rec.earliest_schedule_limit) THEN

2790:
2791: END IF;
2792:
2793: IF p_header_rec.earliest_schedule_limit = FND_API.G_MISS_NUM THEN NULL;
2794: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.earliest_schedule_limit,p_old_header_rec.earliest_schedule_limit) THEN
2795:
2796: l_result := EARLIEST_SCHEDULE_LIMIT
2797: (p_operation => l_operation
2798: ,p_record => l_rowtype_rec

Line 2810: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.fob_point_code,p_old_header_rec.fob_point_code) THEN

2806:
2807: END IF;
2808:
2809: IF p_header_rec.fob_point_code = FND_API.G_MISS_CHAR THEN NULL;
2810: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.fob_point_code,p_old_header_rec.fob_point_code) THEN
2811:
2812: l_result := FOB_POINT
2813: (p_operation => l_operation
2814: ,p_record => l_rowtype_rec

Line 2826: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.freight_terms_code,p_old_header_rec.freight_terms_code) THEN

2822:
2823: END IF;
2824:
2825: IF p_header_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN NULL;
2826: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.freight_terms_code,p_old_header_rec.freight_terms_code) THEN
2827:
2828: l_result := FREIGHT_TERMS
2829: (p_operation => l_operation
2830: ,p_record => l_rowtype_rec

Line 2842: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_contact_id,p_old_header_rec.invoice_to_contact_id) THEN

2838:
2839: END IF;
2840:
2841: IF p_header_rec.invoice_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
2842: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_contact_id,p_old_header_rec.invoice_to_contact_id) THEN
2843:
2844: l_result := INVOICE_TO_CONTACT
2845: (p_operation => l_operation
2846: ,p_record => l_rowtype_rec

Line 2858: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id,p_old_header_rec.invoice_to_org_id) THEN

2854:
2855: END IF;
2856:
2857: IF p_header_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN NULL;
2858: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id,p_old_header_rec.invoice_to_org_id) THEN
2859:
2860: l_result := INVOICE_TO_ORG
2861: (p_operation => l_operation
2862: ,p_record => l_rowtype_rec

Line 2874: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.invoicing_rule_id,p_old_header_rec.invoicing_rule_id) THEN

2870:
2871: END IF;
2872:
2873: IF p_header_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN NULL;
2874: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.invoicing_rule_id,p_old_header_rec.invoicing_rule_id) THEN
2875:
2876: l_result := INVOICING_RULE
2877: (p_operation => l_operation
2878: ,p_record => l_rowtype_rec

Line 2890: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.latest_schedule_limit,p_old_header_rec.latest_schedule_limit) THEN

2886:
2887: END IF;
2888:
2889: IF p_header_rec.latest_schedule_limit = FND_API.G_MISS_NUM THEN NULL;
2890: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.latest_schedule_limit,p_old_header_rec.latest_schedule_limit) THEN
2891:
2892: l_result := LATEST_SCHEDULE_LIMIT
2893: (p_operation => l_operation
2894: ,p_record => l_rowtype_rec

Line 2906: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ordered_date,p_old_header_rec.ordered_date) THEN

2902:
2903: END IF;
2904:
2905: IF p_header_rec.ordered_date = FND_API.G_MISS_DATE THEN NULL;
2906: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ordered_date,p_old_header_rec.ordered_date) THEN
2907:
2908: l_result := ORDERED_DATE
2909: (p_operation => l_operation
2910: ,p_record => l_rowtype_rec

Line 2922: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.order_date_type_code,p_old_header_rec.order_date_type_code) THEN

2918:
2919: END IF;
2920:
2921: IF p_header_rec.order_date_type_code = FND_API.G_MISS_CHAR THEN NULL;
2922: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.order_date_type_code,p_old_header_rec.order_date_type_code) THEN
2923:
2924: l_result := ORDER_DATE_TYPE_CODE
2925: (p_operation => l_operation
2926: ,p_record => l_rowtype_rec

Line 2938: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.order_number,p_old_header_rec.order_number) THEN

2934:
2935: END IF;
2936:
2937: IF p_header_rec.order_number = FND_API.G_MISS_NUM THEN NULL;
2938: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.order_number,p_old_header_rec.order_number) THEN
2939:
2940: l_result := ORDER_NUMBER
2941: (p_operation => l_operation
2942: ,p_record => l_rowtype_rec

Line 2954: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.order_type_id,p_old_header_rec.order_type_id) THEN

2950:
2951: END IF;
2952:
2953: IF p_header_rec.order_type_id = FND_API.G_MISS_NUM THEN NULL;
2954: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.order_type_id,p_old_header_rec.order_type_id) THEN
2955:
2956: l_result := ORDER_TYPE
2957: (p_operation => l_operation
2958: ,p_record => l_rowtype_rec

Line 2970: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.packing_instructions,p_old_header_rec.packing_instructions) THEN

2966:
2967: END IF;
2968:
2969: IF p_header_rec.packing_instructions = FND_API.G_MISS_CHAR THEN NULL;
2970: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.packing_instructions,p_old_header_rec.packing_instructions) THEN
2971:
2972: l_result := PACKING_INSTRUCTIONS
2973: (p_operation => l_operation
2974: ,p_record => l_rowtype_rec

Line 2986: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.payment_term_id,p_old_header_rec.payment_term_id) THEN

2982:
2983: END IF;
2984:
2985: IF p_header_rec.payment_term_id = FND_API.G_MISS_NUM THEN NULL;
2986: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.payment_term_id,p_old_header_rec.payment_term_id) THEN
2987:
2988: l_result := PAYMENT_TERM
2989: (p_operation => l_operation
2990: ,p_record => l_rowtype_rec

Line 3002: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.price_list_id,p_old_header_rec.price_list_id) THEN

2998:
2999: END IF;
3000:
3001: IF p_header_rec.price_list_id = FND_API.G_MISS_NUM THEN NULL;
3002: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.price_list_id,p_old_header_rec.price_list_id) THEN
3003:
3004: l_result := PRICE_LIST
3005: (p_operation => l_operation
3006: ,p_record => l_rowtype_rec

Line 3018: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.pricing_date,p_old_header_rec.pricing_date) THEN

3014:
3015: END IF;
3016:
3017: IF p_header_rec.pricing_date = FND_API.G_MISS_DATE THEN NULL;
3018: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.pricing_date,p_old_header_rec.pricing_date) THEN
3019:
3020: l_result := PRICING_DATE
3021: (p_operation => l_operation
3022: ,p_record => l_rowtype_rec

Line 3034: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.request_date,p_old_header_rec.request_date) THEN

3030:
3031: END IF;
3032:
3033: IF p_header_rec.request_date = FND_API.G_MISS_DATE THEN NULL;
3034: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.request_date,p_old_header_rec.request_date) THEN
3035:
3036: l_result := REQUEST_DATE
3037: (p_operation => l_operation
3038: ,p_record => l_rowtype_rec

Line 3050: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.return_reason_code,p_old_header_rec.return_reason_code) THEN

3046:
3047: END IF;
3048:
3049: IF p_header_rec.return_reason_code = FND_API.G_MISS_CHAR THEN NULL;
3050: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.return_reason_code,p_old_header_rec.return_reason_code) THEN
3051:
3052: l_result := RETURN_REASON
3053: (p_operation => l_operation
3054: ,p_record => l_rowtype_rec

Line 3066: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.salesrep_id,p_old_header_rec.salesrep_id) THEN

3062:
3063: END IF;
3064:
3065: IF p_header_rec.salesrep_id = FND_API.G_MISS_NUM THEN NULL;
3066: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.salesrep_id,p_old_header_rec.salesrep_id) THEN
3067:
3068: l_result := SALESREP
3069: (p_operation => l_operation
3070: ,p_record => l_rowtype_rec

Line 3082: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sales_channel_code,p_old_header_rec.sales_channel_code) THEN

3078:
3079: END IF;
3080:
3081: IF p_header_rec.sales_channel_code = FND_API.G_MISS_CHAR THEN NULL;
3082: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sales_channel_code,p_old_header_rec.sales_channel_code) THEN
3083:
3084: l_result := SALES_CHANNEL_CODE
3085: (p_operation => l_operation
3086: ,p_record => l_rowtype_rec

Line 3099: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.payment_type_code, p_old_header_rec.payment_type_code) THEN

3095: END IF;
3096:
3097: /* START PREPAYMENT */
3098: IF p_header_rec.payment_type_code = FND_API.G_MISS_CHAR THEN NULL;
3099: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.payment_type_code, p_old_header_rec.payment_type_code) THEN
3100:
3101: l_result := PAYMENT_TYPE
3102: (p_operation => l_operation
3103: ,p_record => l_rowtype_rec

Line 3114: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_holder_name, p_old_header_rec.credit_card_holder_name) THEN

3110:
3111: END IF;
3112:
3113: IF p_header_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN NULL;
3114: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_holder_name, p_old_header_rec.credit_card_holder_name) THEN
3115:
3116: l_result := CREDIT_CARD_HOLDER_NAME
3117: (p_operation => l_operation
3118: ,p_record => l_rowtype_rec

Line 3129: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_code, p_old_header_rec.credit_card_code) THEN

3125:
3126: END IF;
3127:
3128: IF p_header_rec.credit_card_code = FND_API.G_MISS_CHAR THEN NULL;
3129: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_code, p_old_header_rec.credit_card_code) THEN
3130:
3131: l_result := CREDIT_CARD
3132: (p_operation => l_operation
3133: ,p_record => l_rowtype_rec

Line 3148: ELSIF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_header_rec.credit_card_number,

3144: --R12 CC Encryption
3145: --Since the credit card numbers are encrypted, calling
3146: --the function same credit card to determine whether the old
3147: --and new card numbers are equal.
3148: ELSIF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_header_rec.credit_card_number,
3149: p_header_rec.credit_card_number,
3150: p_old_header_rec.cc_instrument_id,
3151: p_header_rec.cc_instrument_id) THEN
3152: l_result := CREDIT_CARD_NUMBER

Line 3165: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_expiration_date, p_old_header_rec.credit_card_expiration_date) THEN

3161:
3162: END IF;
3163:
3164: IF p_header_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN NULL;
3165: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_expiration_date, p_old_header_rec.credit_card_expiration_date) THEN
3166:
3167: l_result := CREDIT_CARD_EXPIRATION_DATE
3168: (p_operation => l_operation
3169: ,p_record => l_rowtype_rec

Line 3181: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.shipment_priority_code,p_old_header_rec.shipment_priority_code) THEN

3177: END IF;
3178: /* END PREPAYMENT */
3179:
3180: IF p_header_rec.shipment_priority_code = FND_API.G_MISS_CHAR THEN NULL;
3181: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.shipment_priority_code,p_old_header_rec.shipment_priority_code) THEN
3182:
3183: l_result := SHIPMENT_PRIORITY
3184: (p_operation => l_operation
3185: ,p_record => l_rowtype_rec

Line 3197: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.shipping_instructions,p_old_header_rec.shipping_instructions) THEN

3193:
3194: END IF;
3195:
3196: IF p_header_rec.shipping_instructions = FND_API.G_MISS_CHAR THEN NULL;
3197: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.shipping_instructions,p_old_header_rec.shipping_instructions) THEN
3198:
3199: l_result := SHIPPING_INSTRUCTIONS
3200: (p_operation => l_operation
3201: ,p_record => l_rowtype_rec

Line 3213: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.shipping_method_code,p_old_header_rec.shipping_method_code) THEN

3209:
3210: END IF;
3211:
3212: IF p_header_rec.shipping_method_code = FND_API.G_MISS_CHAR THEN NULL;
3213: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.shipping_method_code,p_old_header_rec.shipping_method_code) THEN
3214:
3215: l_result := SHIPPING_METHOD
3216: (p_operation => l_operation
3217: ,p_record => l_rowtype_rec

Line 3229: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_from_org_id,p_old_header_rec.ship_from_org_id) THEN

3225:
3226: END IF;
3227:
3228: IF p_header_rec.ship_from_org_id = FND_API.G_MISS_NUM THEN NULL;
3229: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_from_org_id,p_old_header_rec.ship_from_org_id) THEN
3230:
3231: l_result := SHIP_FROM_ORG
3232: (p_operation => l_operation
3233: ,p_record => l_rowtype_rec

Line 3245: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_tolerance_above,p_old_header_rec.ship_tolerance_above) THEN

3241:
3242: END IF;
3243:
3244: IF p_header_rec.ship_tolerance_above = FND_API.G_MISS_NUM THEN NULL;
3245: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_tolerance_above,p_old_header_rec.ship_tolerance_above) THEN
3246:
3247: l_result := SHIP_TOLERANCE_ABOVE
3248: (p_operation => l_operation
3249: ,p_record => l_rowtype_rec

Line 3261: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_tolerance_below,p_old_header_rec.ship_tolerance_below) THEN

3257:
3258: END IF;
3259:
3260: IF p_header_rec.ship_tolerance_below = FND_API.G_MISS_NUM THEN NULL;
3261: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_tolerance_below,p_old_header_rec.ship_tolerance_below) THEN
3262:
3263: l_result := SHIP_TOLERANCE_BELOW
3264: (p_operation => l_operation
3265: ,p_record => l_rowtype_rec

Line 3277: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_contact_id,p_old_header_rec.ship_to_contact_id) THEN

3273:
3274: END IF;
3275:
3276: IF p_header_rec.ship_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
3277: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_contact_id,p_old_header_rec.ship_to_contact_id) THEN
3278:
3279: l_result := SHIP_TO_CONTACT
3280: (p_operation => l_operation
3281: ,p_record => l_rowtype_rec

Line 3293: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id,p_old_header_rec.ship_to_org_id) THEN

3289:
3290: END IF;
3291:
3292: IF p_header_rec.ship_to_org_id = FND_API.G_MISS_NUM THEN NULL;
3293: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id,p_old_header_rec.ship_to_org_id) THEN
3294:
3295: l_result := SHIP_TO_ORG
3296: (p_operation => l_operation
3297: ,p_record => l_rowtype_rec

Line 3309: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_contact_id,p_old_header_rec.sold_to_contact_id) THEN

3305:
3306: END IF;
3307:
3308: IF p_header_rec.sold_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
3309: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_contact_id,p_old_header_rec.sold_to_contact_id) THEN
3310:
3311: l_result := SOLD_TO_CONTACT
3312: (p_operation => l_operation
3313: ,p_record => l_rowtype_rec

Line 3325: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id,p_old_header_rec.sold_to_org_id) THEN

3321:
3322: END IF;
3323:
3324: IF p_header_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN NULL;
3325: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id,p_old_header_rec.sold_to_org_id) THEN
3326:
3327: l_result := SOLD_TO_ORG
3328: (p_operation => l_operation
3329: ,p_record => l_rowtype_rec

Line 3341: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_flag,p_old_header_rec.tax_exempt_flag) THEN

3337:
3338: END IF;
3339:
3340: IF p_header_rec.tax_exempt_flag = FND_API.G_MISS_CHAR THEN NULL;
3341: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_flag,p_old_header_rec.tax_exempt_flag) THEN
3342:
3343: l_result := TAX_EXEMPT
3344: (p_operation => l_operation
3345: ,p_record => l_rowtype_rec

Line 3357: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_number,p_old_header_rec.tax_exempt_number) THEN

3353:
3354: END IF;
3355:
3356: IF p_header_rec.tax_exempt_number = FND_API.G_MISS_CHAR THEN NULL;
3357: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_number,p_old_header_rec.tax_exempt_number) THEN
3358:
3359: l_result := TAX_EXEMPT_NUMBER
3360: (p_operation => l_operation
3361: ,p_record => l_rowtype_rec

Line 3373: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_reason_code,p_old_header_rec.tax_exempt_reason_code) THEN

3369:
3370: END IF;
3371:
3372: IF p_header_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR THEN NULL;
3373: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_reason_code,p_old_header_rec.tax_exempt_reason_code) THEN
3374:
3375: l_result := TAX_EXEMPT_REASON
3376: (p_operation => l_operation
3377: ,p_record => l_rowtype_rec

Line 3389: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.transactional_curr_code,p_old_header_rec.transactional_curr_code) THEN

3385:
3386: END IF;
3387:
3388: IF p_header_rec.transactional_curr_code = FND_API.G_MISS_CHAR THEN NULL;
3389: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.transactional_curr_code,p_old_header_rec.transactional_curr_code) THEN
3390:
3391: l_result := TRANSACTIONAL_CURR
3392: (p_operation => l_operation
3393: ,p_record => l_rowtype_rec

Line 3406: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.payment_amount,p_old_header_rec.payment_amount) THEN

3402: END IF;
3403:
3404: -- for bug 2395032
3405: IF p_header_rec.payment_amount = FND_API.G_MISS_NUM THEN NULL;
3406: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.payment_amount,p_old_header_rec.payment_amount) THEN
3407:
3408: l_result := PAYMENT_AMOUNT
3409: (p_operation => l_operation
3410: ,p_record => l_rowtype_rec

Line 3422: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.check_number,p_old_header_rec.check_number) THEN

3418:
3419: END IF;
3420:
3421: IF p_header_rec.check_number = FND_API.G_MISS_CHAR THEN NULL;
3422: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.check_number,p_old_header_rec.check_number) THEN
3423:
3424: l_result := CHECK_NUMBER
3425: (p_operation => l_operation
3426: ,p_record => l_rowtype_rec

Line 3440: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_number,p_old_header_rec.blanket_number) THEN

3436: -- end 2395032
3437:
3438: -- BEGIN: Blankets Code Merge
3439: IF p_header_rec.blanket_number = FND_API.G_MISS_NUM THEN NULL;
3440: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_number,p_old_header_rec.blanket_number) THEN
3441:
3442: l_result := BLANKET_NUMBER
3443: (p_operation => l_operation
3444: ,p_record => l_rowtype_rec

Line 3459: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.quote_number,p_old_header_rec.quote_number) THEN

3455:
3456: -- Quoting Changes Start
3457:
3458: IF p_header_rec.quote_number = FND_API.G_MISS_NUM THEN NULL;
3459: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.quote_number,p_old_header_rec.quote_number) THEN
3460:
3461: l_result := QUOTE_NUMBER
3462: (p_operation => l_operation
3463: ,p_record => l_rowtype_rec

Line 3475: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.quote_date,p_old_header_rec.quote_date) THEN

3471:
3472: END IF;
3473:
3474: IF p_header_rec.quote_date = FND_API.G_MISS_DATE THEN NULL;
3475: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.quote_date,p_old_header_rec.quote_date) THEN
3476:
3477: l_result := QUOTE_DATE
3478: (p_operation => l_operation
3479: ,p_record => l_rowtype_rec

Line 3491: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sales_document_name,p_old_header_rec.sales_document_name) THEN

3487:
3488: END IF;
3489:
3490: IF p_header_rec.sales_document_name = FND_API.G_MISS_CHAR THEN NULL;
3491: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sales_document_name,p_old_header_rec.sales_document_name) THEN
3492:
3493: l_result := SALES_DOCUMENT_NAME
3494: (p_operation => l_operation
3495: ,p_record => l_rowtype_rec

Line 3507: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.transaction_phase_code,p_old_header_rec.transaction_phase_code) THEN

3503:
3504: END IF;
3505:
3506: IF p_header_rec.transaction_phase_code = FND_API.G_MISS_CHAR THEN NULL;
3507: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.transaction_phase_code,p_old_header_rec.transaction_phase_code) THEN
3508:
3509: l_result := TRANSACTION_PHASE
3510: (p_operation => l_operation
3511: ,p_record => l_rowtype_rec

Line 3523: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.user_status_code,p_old_header_rec.user_status_code) THEN

3519:
3520: END IF;
3521:
3522: IF p_header_rec.user_status_code = FND_API.G_MISS_CHAR THEN NULL;
3523: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.user_status_code,p_old_header_rec.user_status_code) THEN
3524:
3525: l_result := USER_STATUS
3526: (p_operation => l_operation
3527: ,p_record => l_rowtype_rec

Line 3539: ELSIF NOT OE_GLOBALS.EQUAL(trunc(p_header_rec.expiration_date),trunc(p_old_header_rec.expiration_date)) THEN

3535:
3536: END IF;
3537:
3538: IF p_header_rec.expiration_date = FND_API.G_MISS_DATE THEN NULL;
3539: ELSIF NOT OE_GLOBALS.EQUAL(trunc(p_header_rec.expiration_date),trunc(p_old_header_rec.expiration_date)) THEN
3540:
3541: l_result := EXPIRATION_DATE
3542: (p_operation => l_operation
3543: ,p_record => l_rowtype_rec

Line 3555: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.version_number,p_old_header_rec.version_number) THEN

3551:
3552: END IF;
3553:
3554: IF p_header_rec.version_number = FND_API.G_MISS_NUM THEN NULL;
3555: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.version_number,p_old_header_rec.version_number) THEN
3556:
3557: l_result := VERSION_NUMBER
3558: (p_operation => l_operation
3559: ,p_record => l_rowtype_rec

Line 3571: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id,p_old_header_rec.sold_to_site_use_id) THEN

3567:
3568: END IF;
3569:
3570: IF p_header_rec.sold_to_site_use_id = FND_API.G_MISS_NUM THEN NULL;
3571: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id,p_old_header_rec.sold_to_site_use_id) THEN
3572:
3573: l_result := SOLD_TO_SITE_USE
3574: (p_operation => l_operation
3575: ,p_record => l_rowtype_rec

Line 3605: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.context,p_old_header_rec.context) THEN

3601: g_check_all_cols_constraint := 'N';
3602: END IF;
3603:
3604: IF p_header_rec.context = FND_API.G_MISS_CHAR THEN NULL;
3605: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.context,p_old_header_rec.context) THEN
3606:
3607: l_result := CONTEXT
3608: (p_operation => l_operation
3609: ,p_record => l_rowtype_rec

Line 3621: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute1,p_old_header_rec.attribute1) THEN

3617:
3618: END IF;
3619:
3620: IF p_header_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;
3621: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute1,p_old_header_rec.attribute1) THEN
3622:
3623: l_result := ATTRIBUTE1
3624: (p_operation => l_operation
3625: ,p_record => l_rowtype_rec

Line 3637: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute10,p_old_header_rec.attribute10) THEN

3633:
3634: END IF;
3635:
3636: IF p_header_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;
3637: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute10,p_old_header_rec.attribute10) THEN
3638:
3639: l_result := ATTRIBUTE10
3640: (p_operation => l_operation
3641: ,p_record => l_rowtype_rec

Line 3653: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute11,p_old_header_rec.attribute11) THEN

3649:
3650: END IF;
3651:
3652: IF p_header_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;
3653: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute11,p_old_header_rec.attribute11) THEN
3654:
3655: l_result := ATTRIBUTE11
3656: (p_operation => l_operation
3657: ,p_record => l_rowtype_rec

Line 3669: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute12,p_old_header_rec.attribute12) THEN

3665:
3666: END IF;
3667:
3668: IF p_header_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;
3669: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute12,p_old_header_rec.attribute12) THEN
3670:
3671: l_result := ATTRIBUTE12
3672: (p_operation => l_operation
3673: ,p_record => l_rowtype_rec

Line 3685: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute13,p_old_header_rec.attribute13) THEN

3681:
3682: END IF;
3683:
3684: IF p_header_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;
3685: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute13,p_old_header_rec.attribute13) THEN
3686:
3687: l_result := ATTRIBUTE13
3688: (p_operation => l_operation
3689: ,p_record => l_rowtype_rec

Line 3701: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute14,p_old_header_rec.attribute14) THEN

3697:
3698: END IF;
3699:
3700: IF p_header_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;
3701: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute14,p_old_header_rec.attribute14) THEN
3702:
3703: l_result := ATTRIBUTE14
3704: (p_operation => l_operation
3705: ,p_record => l_rowtype_rec

Line 3717: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute15,p_old_header_rec.attribute15) THEN

3713:
3714: END IF;
3715:
3716: IF p_header_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;
3717: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute15,p_old_header_rec.attribute15) THEN
3718:
3719: l_result := ATTRIBUTE15
3720: (p_operation => l_operation
3721: ,p_record => l_rowtype_rec

Line 3734: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute16,p_old_header_rec.attribute16) THEN

3730: END IF;
3731:
3732: --For bug 2184255
3733: IF p_header_rec.attribute16 = FND_API.G_MISS_CHAR THEN NULL;
3734: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute16,p_old_header_rec.attribute16) THEN
3735:
3736: l_result := ATTRIBUTE16
3737: (p_operation => l_operation
3738: ,p_record => l_rowtype_rec

Line 3750: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute17,p_old_header_rec.attribute17) THEN

3746:
3747: END IF;
3748:
3749: IF p_header_rec.attribute17 = FND_API.G_MISS_CHAR THEN NULL;
3750: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute17,p_old_header_rec.attribute17) THEN
3751:
3752: l_result := ATTRIBUTE17
3753: (p_operation => l_operation
3754: ,p_record => l_rowtype_rec

Line 3766: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute18,p_old_header_rec.attribute18) THEN

3762:
3763: END IF;
3764:
3765: IF p_header_rec.attribute18 = FND_API.G_MISS_CHAR THEN NULL;
3766: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute18,p_old_header_rec.attribute18) THEN
3767:
3768: l_result := ATTRIBUTE18
3769: (p_operation => l_operation
3770: ,p_record => l_rowtype_rec

Line 3782: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute19,p_old_header_rec.attribute19) THEN

3778:
3779: END IF;
3780:
3781: IF p_header_rec.attribute19 = FND_API.G_MISS_CHAR THEN NULL;
3782: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute19,p_old_header_rec.attribute19) THEN
3783:
3784: l_result := ATTRIBUTE19
3785: (p_operation => l_operation
3786: ,p_record => l_rowtype_rec

Line 3798: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute2,p_old_header_rec.attribute2) THEN

3794:
3795: END IF;
3796:
3797: IF p_header_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;
3798: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute2,p_old_header_rec.attribute2) THEN
3799:
3800: l_result := ATTRIBUTE2
3801: (p_operation => l_operation
3802: ,p_record => l_rowtype_rec

Line 3814: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute20,p_old_header_rec.attribute20) THEN

3810:
3811: END IF;
3812:
3813: IF p_header_rec.attribute20 = FND_API.G_MISS_CHAR THEN NULL;
3814: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute20,p_old_header_rec.attribute20) THEN
3815:
3816: l_result := ATTRIBUTE20
3817: (p_operation => l_operation
3818: ,p_record => l_rowtype_rec

Line 3832: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute3,p_old_header_rec.attribute3) THEN

3828:
3829: --End bug 2184255
3830:
3831: IF p_header_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;
3832: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute3,p_old_header_rec.attribute3) THEN
3833:
3834: l_result := ATTRIBUTE3
3835: (p_operation => l_operation
3836: ,p_record => l_rowtype_rec

Line 3848: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute4,p_old_header_rec.attribute4) THEN

3844:
3845: END IF;
3846:
3847: IF p_header_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;
3848: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute4,p_old_header_rec.attribute4) THEN
3849:
3850: l_result := ATTRIBUTE4
3851: (p_operation => l_operation
3852: ,p_record => l_rowtype_rec

Line 3864: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute5,p_old_header_rec.attribute5) THEN

3860:
3861: END IF;
3862:
3863: IF p_header_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;
3864: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute5,p_old_header_rec.attribute5) THEN
3865:
3866: l_result := ATTRIBUTE5
3867: (p_operation => l_operation
3868: ,p_record => l_rowtype_rec

Line 3880: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute6,p_old_header_rec.attribute6) THEN

3876:
3877: END IF;
3878:
3879: IF p_header_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;
3880: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute6,p_old_header_rec.attribute6) THEN
3881:
3882: l_result := ATTRIBUTE6
3883: (p_operation => l_operation
3884: ,p_record => l_rowtype_rec

Line 3896: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute7,p_old_header_rec.attribute7) THEN

3892:
3893: END IF;
3894:
3895: IF p_header_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;
3896: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute7,p_old_header_rec.attribute7) THEN
3897:
3898: l_result := ATTRIBUTE7
3899: (p_operation => l_operation
3900: ,p_record => l_rowtype_rec

Line 3912: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute8,p_old_header_rec.attribute8) THEN

3908:
3909: END IF;
3910:
3911: IF p_header_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;
3912: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute8,p_old_header_rec.attribute8) THEN
3913:
3914: l_result := ATTRIBUTE8
3915: (p_operation => l_operation
3916: ,p_record => l_rowtype_rec

Line 3928: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute9,p_old_header_rec.attribute9) THEN

3924:
3925: END IF;
3926:
3927: IF p_header_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;
3928: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute9,p_old_header_rec.attribute9) THEN
3929:
3930: l_result := ATTRIBUTE9
3931: (p_operation => l_operation
3932: ,p_record => l_rowtype_rec