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 2407: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

2403:
2404: -- Initializing return status to SUCCESS
2405: x_return_status := FND_API.G_RET_STS_SUCCESS;
2406:
2407: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2408: l_operation := OE_PC_GLOBALS.CREATE_OP;
2409: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2410: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2411: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

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

2405: x_return_status := FND_API.G_RET_STS_SUCCESS;
2406:
2407: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2408: l_operation := OE_PC_GLOBALS.CREATE_OP;
2409: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2410: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2411: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
2412: l_operation := OE_PC_GLOBALS.DELETE_OP;
2413: ELSE

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

2407: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2408: l_operation := OE_PC_GLOBALS.CREATE_OP;
2409: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2410: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2411: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
2412: l_operation := OE_PC_GLOBALS.DELETE_OP;
2413: ELSE
2414: IF l_debug_level > 0 THEN
2415: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;

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

2493: -- Initializing out result to NOT CONSTRAINED
2494: x_result := OE_PC_GLOBALS.NO;
2495:
2496: -- Get the operation code to be passed to the security framework API
2497: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2498: -- Bug 1987983 : if the order source is Copy then skip the Attribute
2499: -- level check
2500: IF p_HEADER_rec.source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_COPY
2501: THEN

Line 2500: IF p_HEADER_rec.source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_COPY

2496: -- Get the operation code to be passed to the security framework API
2497: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2498: -- Bug 1987983 : if the order source is Copy then skip the Attribute
2499: -- level check
2500: IF p_HEADER_rec.source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_COPY
2501: THEN
2502: RETURN;
2503: ELSE
2504: l_operation := OE_PC_GLOBALS.CREATE_OP;

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

2515: THEN
2516: RETURN;
2517: END IF;
2518:
2519: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2520: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2521: ELSE
2522: IF l_debug_level > 0 THEN
2523: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;

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

2533: -- Compare the new and old entity records and
2534: -- check constraints for all the changed attributes.
2535:
2536: IF p_header_rec.cancelled_flag <> FND_API.G_MISS_CHAR
2537: AND NOT OE_GLOBALS.Equal(p_header_rec.cancelled_flag,
2538: p_old_header_rec.cancelled_flag)
2539: THEN
2540: IF p_header_rec.cancelled_flag = 'Y' THEN
2541: l_result := CANCELLED

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

2552:
2553: END IF;
2554:
2555: IF ((p_header_rec.price_list_id IS NOT NULL)
2556: AND (NOT oe_globals.equal(p_header_rec.price_list_id,
2557: p_old_HEADER_rec.price_list_id))
2558: AND (p_header_rec.order_category_code IS NOT NULL)
2559: AND (p_header_rec.order_category_code <>
2560: Oe_Globals.G_RETURN_CATEGORY_CODE)) THEN

Line 2560: Oe_Globals.G_RETURN_CATEGORY_CODE)) THEN

2556: AND (NOT oe_globals.equal(p_header_rec.price_list_id,
2557: p_old_HEADER_rec.price_list_id))
2558: AND (p_header_rec.order_category_code IS NOT NULL)
2559: AND (p_header_rec.order_category_code <>
2560: Oe_Globals.G_RETURN_CATEGORY_CODE)) THEN
2561: BEGIN
2562: SELECT active_flag
2563: INTO l_active_flag
2564: FROM qp_List_headers_vl

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

2577: END;
2578: END IF;
2579:
2580: IF p_header_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN NULL;
2581: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.accounting_rule_id,p_old_header_rec.accounting_rule_id) THEN
2582:
2583: l_result := ACCOUNTING_RULE
2584: (p_operation => l_operation
2585: ,p_record => l_rowtype_rec

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

2593:
2594: END IF;
2595:
2596: IF p_header_rec.IB_OWNER = FND_API.G_MISS_CHAR THEN NULL;
2597: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.IB_OWNER,p_old_header_rec.IB_OWNER) THEN
2598:
2599: l_result := IB_OWNER
2600: (p_operation => l_operation
2601: ,p_record => l_rowtype_rec

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

2608: END IF;
2609:
2610: END IF;
2611: IF p_header_rec.IB_INSTALLED_AT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;
2612: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.IB_INSTALLED_AT_LOCATION,p_old_header_rec.IB_INSTALLED_AT_LOCATION) THEN
2613:
2614: l_result := IB_INSTALLED_AT_LOCATION
2615: (p_operation => l_operation
2616: ,p_record => l_rowtype_rec

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

2623: END IF;
2624:
2625: END IF;
2626: IF p_header_rec.IB_CURRENT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;
2627: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.IB_CURRENT_LOCATION,p_old_header_rec.IB_CURRENT_LOCATION) THEN
2628:
2629: l_result := IB_CURRENT_LOCATION
2630: (p_operation => l_operation
2631: ,p_record => l_rowtype_rec

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

2638: END IF;
2639:
2640: END IF;
2641: IF p_header_rec.END_CUSTOMER_ID = FND_API.G_MISS_NUM THEN NULL;
2642: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.END_CUSTOMER_ID,p_old_header_rec.END_CUSTOMER_ID) THEN
2643:
2644: l_result := END_CUSTOMER
2645: (p_operation => l_operation
2646: ,p_record => l_rowtype_rec

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

2653: END IF;
2654:
2655: END IF;
2656: IF p_header_rec.END_CUSTOMER_SITE_USE_ID = FND_API.G_MISS_NUM THEN NULL;
2657: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.END_CUSTOMER_SITE_USE_ID,p_old_header_rec.END_CUSTOMER_SITE_USE_ID) THEN
2658:
2659: l_result := END_CUSTOMER_SITE_USE
2660: (p_operation => l_operation
2661: ,p_record => l_rowtype_rec

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

2668: END IF;
2669:
2670: END IF;
2671: IF p_header_rec.END_CUSTOMER_CONTACT_ID = FND_API.G_MISS_NUM THEN NULL;
2672: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.END_CUSTOMER_CONTACT_ID,p_old_header_rec.END_CUSTOMER_CONTACT_ID) THEN
2673:
2674: l_result := END_CUSTOMER_CONTACT
2675: (p_operation => l_operation
2676: ,p_record => l_rowtype_rec

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

2684:
2685: END IF;
2686:
2687: IF p_header_rec.accounting_rule_duration = FND_API.G_MISS_NUM THEN NULL;
2688: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.accounting_rule_duration,p_old_header_rec.accounting_rule_duration) THEN
2689:
2690: l_result := ACCOUNTING_RULE_DURATION
2691: (p_operation => l_operation
2692: ,p_record => l_rowtype_rec

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

2700:
2701: END IF;
2702:
2703: IF p_header_rec.agreement_id = FND_API.G_MISS_NUM THEN NULL;
2704: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.agreement_id,p_old_header_rec.agreement_id) THEN
2705:
2706: l_result := AGREEMENT
2707: (p_operation => l_operation
2708: ,p_record => l_rowtype_rec

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

2716:
2717: END IF;
2718:
2719: IF p_header_rec.conversion_rate = FND_API.G_MISS_NUM THEN NULL;
2720: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.conversion_rate,p_old_header_rec.conversion_rate) THEN
2721:
2722: l_result := CONVERSION_RATE
2723: (p_operation => l_operation
2724: ,p_record => l_rowtype_rec

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

2732:
2733: END IF;
2734:
2735: IF p_header_rec.conversion_rate_date = FND_API.G_MISS_DATE THEN NULL;
2736: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.conversion_rate_date,p_old_header_rec.conversion_rate_date) THEN
2737:
2738: l_result := CONVERSION_RATE_DATE
2739: (p_operation => l_operation
2740: ,p_record => l_rowtype_rec

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

2748:
2749: END IF;
2750:
2751: IF p_header_rec.conversion_type_code = FND_API.G_MISS_CHAR THEN NULL;
2752: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.conversion_type_code,p_old_header_rec.conversion_type_code) THEN
2753:
2754: l_result := CONVERSION_TYPE
2755: (p_operation => l_operation
2756: ,p_record => l_rowtype_rec

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

2764:
2765: END IF;
2766:
2767: IF p_header_rec.created_by = FND_API.G_MISS_NUM THEN NULL;
2768: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.created_by,p_old_header_rec.created_by) THEN
2769:
2770: l_result := CREATED_BY
2771: (p_operation => l_operation
2772: ,p_record => l_rowtype_rec

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

2780:
2781: END IF;
2782:
2783: IF p_header_rec.cust_po_number = FND_API.G_MISS_CHAR THEN NULL;
2784: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.cust_po_number,p_old_header_rec.cust_po_number) THEN
2785:
2786: l_result := CUST_PO_NUMBER
2787: (p_operation => l_operation
2788: ,p_record => l_rowtype_rec

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

2796:
2797: END IF;
2798:
2799: IF p_header_rec.deliver_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
2800: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_contact_id,p_old_header_rec.deliver_to_contact_id) THEN
2801:
2802: l_result := DELIVER_TO_CONTACT
2803: (p_operation => l_operation
2804: ,p_record => l_rowtype_rec

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

2812:
2813: END IF;
2814:
2815: IF p_header_rec.deliver_to_org_id = FND_API.G_MISS_NUM THEN NULL;
2816: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id,p_old_header_rec.deliver_to_org_id) THEN
2817:
2818: l_result := DELIVER_TO_ORG
2819: (p_operation => l_operation
2820: ,p_record => l_rowtype_rec

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

2828:
2829: END IF;
2830:
2831: IF p_header_rec.demand_class_code = FND_API.G_MISS_CHAR THEN NULL;
2832: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.demand_class_code,p_old_header_rec.demand_class_code) THEN
2833:
2834: l_result := DEMAND_CLASS
2835: (p_operation => l_operation
2836: ,p_record => l_rowtype_rec

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

2844:
2845: END IF;
2846:
2847: IF p_header_rec.earliest_schedule_limit = FND_API.G_MISS_NUM THEN NULL;
2848: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.earliest_schedule_limit,p_old_header_rec.earliest_schedule_limit) THEN
2849:
2850: l_result := EARLIEST_SCHEDULE_LIMIT
2851: (p_operation => l_operation
2852: ,p_record => l_rowtype_rec

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

2860:
2861: END IF;
2862:
2863: IF p_header_rec.fob_point_code = FND_API.G_MISS_CHAR THEN NULL;
2864: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.fob_point_code,p_old_header_rec.fob_point_code) THEN
2865:
2866: l_result := FOB_POINT
2867: (p_operation => l_operation
2868: ,p_record => l_rowtype_rec

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

2876:
2877: END IF;
2878:
2879: IF p_header_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN NULL;
2880: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.freight_terms_code,p_old_header_rec.freight_terms_code) THEN
2881:
2882: l_result := FREIGHT_TERMS
2883: (p_operation => l_operation
2884: ,p_record => l_rowtype_rec

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

2892:
2893: END IF;
2894:
2895: IF p_header_rec.invoice_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
2896: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_contact_id,p_old_header_rec.invoice_to_contact_id) THEN
2897:
2898: l_result := INVOICE_TO_CONTACT
2899: (p_operation => l_operation
2900: ,p_record => l_rowtype_rec

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

2908:
2909: END IF;
2910:
2911: IF p_header_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN NULL;
2912: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id,p_old_header_rec.invoice_to_org_id) THEN
2913:
2914: l_result := INVOICE_TO_ORG
2915: (p_operation => l_operation
2916: ,p_record => l_rowtype_rec

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

2924:
2925: END IF;
2926:
2927: IF p_header_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN NULL;
2928: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.invoicing_rule_id,p_old_header_rec.invoicing_rule_id) THEN
2929:
2930: l_result := INVOICING_RULE
2931: (p_operation => l_operation
2932: ,p_record => l_rowtype_rec

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

2940:
2941: END IF;
2942:
2943: IF p_header_rec.latest_schedule_limit = FND_API.G_MISS_NUM THEN NULL;
2944: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.latest_schedule_limit,p_old_header_rec.latest_schedule_limit) THEN
2945:
2946: l_result := LATEST_SCHEDULE_LIMIT
2947: (p_operation => l_operation
2948: ,p_record => l_rowtype_rec

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

2956:
2957: END IF;
2958:
2959: IF p_header_rec.ordered_date = FND_API.G_MISS_DATE THEN NULL;
2960: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ordered_date,p_old_header_rec.ordered_date) THEN
2961:
2962: l_result := ORDERED_DATE
2963: (p_operation => l_operation
2964: ,p_record => l_rowtype_rec

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

2972:
2973: END IF;
2974:
2975: IF p_header_rec.order_date_type_code = FND_API.G_MISS_CHAR THEN NULL;
2976: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.order_date_type_code,p_old_header_rec.order_date_type_code) THEN
2977:
2978: l_result := ORDER_DATE_TYPE_CODE
2979: (p_operation => l_operation
2980: ,p_record => l_rowtype_rec

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

2988:
2989: END IF;
2990:
2991: IF p_header_rec.order_number = FND_API.G_MISS_NUM THEN NULL;
2992: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.order_number,p_old_header_rec.order_number) THEN
2993:
2994: l_result := ORDER_NUMBER
2995: (p_operation => l_operation
2996: ,p_record => l_rowtype_rec

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

3004:
3005: END IF;
3006:
3007: IF p_header_rec.order_type_id = FND_API.G_MISS_NUM THEN NULL;
3008: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.order_type_id,p_old_header_rec.order_type_id) THEN
3009:
3010: l_result := ORDER_TYPE
3011: (p_operation => l_operation
3012: ,p_record => l_rowtype_rec

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

3020:
3021: END IF;
3022:
3023: IF p_header_rec.packing_instructions = FND_API.G_MISS_CHAR THEN NULL;
3024: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.packing_instructions,p_old_header_rec.packing_instructions) THEN
3025:
3026: l_result := PACKING_INSTRUCTIONS
3027: (p_operation => l_operation
3028: ,p_record => l_rowtype_rec

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

3036:
3037: END IF;
3038:
3039: IF p_header_rec.payment_term_id = FND_API.G_MISS_NUM THEN NULL;
3040: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.payment_term_id,p_old_header_rec.payment_term_id) THEN
3041:
3042: l_result := PAYMENT_TERM
3043: (p_operation => l_operation
3044: ,p_record => l_rowtype_rec

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

3052:
3053: END IF;
3054:
3055: IF p_header_rec.price_list_id = FND_API.G_MISS_NUM THEN NULL;
3056: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.price_list_id,p_old_header_rec.price_list_id) THEN
3057:
3058: l_result := PRICE_LIST
3059: (p_operation => l_operation
3060: ,p_record => l_rowtype_rec

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

3068:
3069: END IF;
3070:
3071: IF p_header_rec.pricing_date = FND_API.G_MISS_DATE THEN NULL;
3072: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.pricing_date,p_old_header_rec.pricing_date) THEN
3073:
3074: l_result := PRICING_DATE
3075: (p_operation => l_operation
3076: ,p_record => l_rowtype_rec

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

3084:
3085: END IF;
3086:
3087: IF p_header_rec.request_date = FND_API.G_MISS_DATE THEN NULL;
3088: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.request_date,p_old_header_rec.request_date) THEN
3089:
3090: l_result := REQUEST_DATE
3091: (p_operation => l_operation
3092: ,p_record => l_rowtype_rec

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

3100:
3101: END IF;
3102:
3103: IF p_header_rec.return_reason_code = FND_API.G_MISS_CHAR THEN NULL;
3104: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.return_reason_code,p_old_header_rec.return_reason_code) THEN
3105:
3106: l_result := RETURN_REASON
3107: (p_operation => l_operation
3108: ,p_record => l_rowtype_rec

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

3116:
3117: END IF;
3118:
3119: IF p_header_rec.salesrep_id = FND_API.G_MISS_NUM THEN NULL;
3120: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.salesrep_id,p_old_header_rec.salesrep_id) THEN
3121:
3122: l_result := SALESREP
3123: (p_operation => l_operation
3124: ,p_record => l_rowtype_rec

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

3132:
3133: END IF;
3134:
3135: IF p_header_rec.sales_channel_code = FND_API.G_MISS_CHAR THEN NULL;
3136: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sales_channel_code,p_old_header_rec.sales_channel_code) THEN
3137:
3138: l_result := SALES_CHANNEL_CODE
3139: (p_operation => l_operation
3140: ,p_record => l_rowtype_rec

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

3149: END IF;
3150:
3151: /* START PREPAYMENT */
3152: IF p_header_rec.payment_type_code = FND_API.G_MISS_CHAR THEN NULL;
3153: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.payment_type_code, p_old_header_rec.payment_type_code) THEN
3154:
3155: l_result := PAYMENT_TYPE
3156: (p_operation => l_operation
3157: ,p_record => l_rowtype_rec

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

3164:
3165: END IF;
3166:
3167: IF p_header_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN NULL;
3168: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_holder_name, p_old_header_rec.credit_card_holder_name) THEN
3169:
3170: l_result := CREDIT_CARD_HOLDER_NAME
3171: (p_operation => l_operation
3172: ,p_record => l_rowtype_rec

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

3179:
3180: END IF;
3181:
3182: IF p_header_rec.credit_card_code = FND_API.G_MISS_CHAR THEN NULL;
3183: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_code, p_old_header_rec.credit_card_code) THEN
3184:
3185: l_result := CREDIT_CARD
3186: (p_operation => l_operation
3187: ,p_record => l_rowtype_rec

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

3198: --R12 CC Encryption
3199: --Since the credit card numbers are encrypted, calling
3200: --the function same credit card to determine whether the old
3201: --and new card numbers are equal.
3202: ELSIF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_header_rec.credit_card_number,
3203: p_header_rec.credit_card_number,
3204: p_old_header_rec.cc_instrument_id,
3205: p_header_rec.cc_instrument_id) THEN
3206: l_result := CREDIT_CARD_NUMBER

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

3215:
3216: END IF;
3217:
3218: IF p_header_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN NULL;
3219: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.credit_card_expiration_date, p_old_header_rec.credit_card_expiration_date) THEN
3220:
3221: l_result := CREDIT_CARD_EXPIRATION_DATE
3222: (p_operation => l_operation
3223: ,p_record => l_rowtype_rec

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

3231: END IF;
3232: /* END PREPAYMENT */
3233:
3234: IF p_header_rec.shipment_priority_code = FND_API.G_MISS_CHAR THEN NULL;
3235: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.shipment_priority_code,p_old_header_rec.shipment_priority_code) THEN
3236:
3237: l_result := SHIPMENT_PRIORITY
3238: (p_operation => l_operation
3239: ,p_record => l_rowtype_rec

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

3247:
3248: END IF;
3249:
3250: IF p_header_rec.shipping_instructions = FND_API.G_MISS_CHAR THEN NULL;
3251: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.shipping_instructions,p_old_header_rec.shipping_instructions) THEN
3252:
3253: l_result := SHIPPING_INSTRUCTIONS
3254: (p_operation => l_operation
3255: ,p_record => l_rowtype_rec

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

3263:
3264: END IF;
3265:
3266: IF p_header_rec.shipping_method_code = FND_API.G_MISS_CHAR THEN NULL;
3267: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.shipping_method_code,p_old_header_rec.shipping_method_code) THEN
3268:
3269: l_result := SHIPPING_METHOD
3270: (p_operation => l_operation
3271: ,p_record => l_rowtype_rec

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

3279:
3280: END IF;
3281:
3282: IF p_header_rec.ship_from_org_id = FND_API.G_MISS_NUM THEN NULL;
3283: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_from_org_id,p_old_header_rec.ship_from_org_id) THEN
3284:
3285: l_result := SHIP_FROM_ORG
3286: (p_operation => l_operation
3287: ,p_record => l_rowtype_rec

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

3295:
3296: END IF;
3297:
3298: IF p_header_rec.ship_tolerance_above = FND_API.G_MISS_NUM THEN NULL;
3299: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_tolerance_above,p_old_header_rec.ship_tolerance_above) THEN
3300:
3301: l_result := SHIP_TOLERANCE_ABOVE
3302: (p_operation => l_operation
3303: ,p_record => l_rowtype_rec

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

3311:
3312: END IF;
3313:
3314: IF p_header_rec.ship_tolerance_below = FND_API.G_MISS_NUM THEN NULL;
3315: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_tolerance_below,p_old_header_rec.ship_tolerance_below) THEN
3316:
3317: l_result := SHIP_TOLERANCE_BELOW
3318: (p_operation => l_operation
3319: ,p_record => l_rowtype_rec

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

3327:
3328: END IF;
3329:
3330: IF p_header_rec.ship_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
3331: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_contact_id,p_old_header_rec.ship_to_contact_id) THEN
3332:
3333: l_result := SHIP_TO_CONTACT
3334: (p_operation => l_operation
3335: ,p_record => l_rowtype_rec

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

3343:
3344: END IF;
3345:
3346: IF p_header_rec.ship_to_org_id = FND_API.G_MISS_NUM THEN NULL;
3347: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id,p_old_header_rec.ship_to_org_id) THEN
3348:
3349: l_result := SHIP_TO_ORG
3350: (p_operation => l_operation
3351: ,p_record => l_rowtype_rec

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

3359:
3360: END IF;
3361:
3362: IF p_header_rec.sold_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
3363: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_contact_id,p_old_header_rec.sold_to_contact_id) THEN
3364:
3365: l_result := SOLD_TO_CONTACT
3366: (p_operation => l_operation
3367: ,p_record => l_rowtype_rec

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

3375:
3376: END IF;
3377:
3378: IF p_header_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN NULL;
3379: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id,p_old_header_rec.sold_to_org_id) THEN
3380:
3381: l_result := SOLD_TO_ORG
3382: (p_operation => l_operation
3383: ,p_record => l_rowtype_rec

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

3391:
3392: END IF;
3393:
3394: IF p_header_rec.tax_exempt_flag = FND_API.G_MISS_CHAR THEN NULL;
3395: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_flag,p_old_header_rec.tax_exempt_flag) THEN
3396:
3397: l_result := TAX_EXEMPT
3398: (p_operation => l_operation
3399: ,p_record => l_rowtype_rec

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

3407:
3408: END IF;
3409:
3410: IF p_header_rec.tax_exempt_number = FND_API.G_MISS_CHAR THEN NULL;
3411: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_number,p_old_header_rec.tax_exempt_number) THEN
3412:
3413: l_result := TAX_EXEMPT_NUMBER
3414: (p_operation => l_operation
3415: ,p_record => l_rowtype_rec

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

3423:
3424: END IF;
3425:
3426: IF p_header_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR THEN NULL;
3427: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.tax_exempt_reason_code,p_old_header_rec.tax_exempt_reason_code) THEN
3428:
3429: l_result := TAX_EXEMPT_REASON
3430: (p_operation => l_operation
3431: ,p_record => l_rowtype_rec

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

3439:
3440: END IF;
3441:
3442: IF p_header_rec.transactional_curr_code = FND_API.G_MISS_CHAR THEN NULL;
3443: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.transactional_curr_code,p_old_header_rec.transactional_curr_code) THEN
3444:
3445: l_result := TRANSACTIONAL_CURR
3446: (p_operation => l_operation
3447: ,p_record => l_rowtype_rec

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

3456: END IF;
3457:
3458: -- for bug 2395032
3459: IF p_header_rec.payment_amount = FND_API.G_MISS_NUM THEN NULL;
3460: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.payment_amount,p_old_header_rec.payment_amount) THEN
3461:
3462: l_result := PAYMENT_AMOUNT
3463: (p_operation => l_operation
3464: ,p_record => l_rowtype_rec

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

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

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

3490: -- end 2395032
3491:
3492: -- BEGIN: Blankets Code Merge
3493: IF p_header_rec.blanket_number = FND_API.G_MISS_NUM THEN NULL;
3494: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_number,p_old_header_rec.blanket_number) THEN
3495:
3496: l_result := BLANKET_NUMBER
3497: (p_operation => l_operation
3498: ,p_record => l_rowtype_rec

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

3509:
3510: -- Quoting Changes Start
3511:
3512: IF p_header_rec.quote_number = FND_API.G_MISS_NUM THEN NULL;
3513: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.quote_number,p_old_header_rec.quote_number) THEN
3514:
3515: l_result := QUOTE_NUMBER
3516: (p_operation => l_operation
3517: ,p_record => l_rowtype_rec

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

3525:
3526: END IF;
3527:
3528: IF p_header_rec.quote_date = FND_API.G_MISS_DATE THEN NULL;
3529: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.quote_date,p_old_header_rec.quote_date) THEN
3530:
3531: l_result := QUOTE_DATE
3532: (p_operation => l_operation
3533: ,p_record => l_rowtype_rec

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

3541:
3542: END IF;
3543:
3544: IF p_header_rec.sales_document_name = FND_API.G_MISS_CHAR THEN NULL;
3545: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sales_document_name,p_old_header_rec.sales_document_name) THEN
3546:
3547: l_result := SALES_DOCUMENT_NAME
3548: (p_operation => l_operation
3549: ,p_record => l_rowtype_rec

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

3557:
3558: END IF;
3559:
3560: IF p_header_rec.transaction_phase_code = FND_API.G_MISS_CHAR THEN NULL;
3561: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.transaction_phase_code,p_old_header_rec.transaction_phase_code) THEN
3562:
3563: l_result := TRANSACTION_PHASE
3564: (p_operation => l_operation
3565: ,p_record => l_rowtype_rec

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

3573:
3574: END IF;
3575:
3576: IF p_header_rec.user_status_code = FND_API.G_MISS_CHAR THEN NULL;
3577: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.user_status_code,p_old_header_rec.user_status_code) THEN
3578:
3579: l_result := USER_STATUS
3580: (p_operation => l_operation
3581: ,p_record => l_rowtype_rec

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

3589:
3590: END IF;
3591:
3592: IF p_header_rec.expiration_date = FND_API.G_MISS_DATE THEN NULL;
3593: ELSIF NOT OE_GLOBALS.EQUAL(trunc(p_header_rec.expiration_date),trunc(p_old_header_rec.expiration_date)) THEN
3594:
3595: l_result := EXPIRATION_DATE
3596: (p_operation => l_operation
3597: ,p_record => l_rowtype_rec

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

3605:
3606: END IF;
3607:
3608: IF p_header_rec.version_number = FND_API.G_MISS_NUM THEN NULL;
3609: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.version_number,p_old_header_rec.version_number) THEN
3610:
3611: l_result := VERSION_NUMBER
3612: (p_operation => l_operation
3613: ,p_record => l_rowtype_rec

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

3621:
3622: END IF;
3623:
3624: IF p_header_rec.sold_to_site_use_id = FND_API.G_MISS_NUM THEN NULL;
3625: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_site_use_id,p_old_header_rec.sold_to_site_use_id) THEN
3626:
3627: l_result := SOLD_TO_SITE_USE
3628: (p_operation => l_operation
3629: ,p_record => l_rowtype_rec

Line 3644: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.DEFAULT_FULFILLMENT_SET,p_old_header_rec.DEFAULT_FULFILLMENT_SET) THEN

3640: -- Quoting Changes END
3641:
3642: -- Bug 8217769 New IF added for Default Fulfillment Set
3643: IF p_header_rec.DEFAULT_FULFILLMENT_SET = FND_API.G_MISS_CHAR THEN NULL;
3644: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.DEFAULT_FULFILLMENT_SET,p_old_header_rec.DEFAULT_FULFILLMENT_SET) THEN
3645:
3646: l_result := DEFAULT_FULFILLMENT_SET
3647: (p_operation => l_operation
3648: ,p_record => l_rowtype_rec

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

3673: g_check_all_cols_constraint := 'N';
3674: END IF;
3675:
3676: IF p_header_rec.context = FND_API.G_MISS_CHAR THEN NULL;
3677: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.context,p_old_header_rec.context) THEN
3678:
3679: l_result := CONTEXT
3680: (p_operation => l_operation
3681: ,p_record => l_rowtype_rec

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

3689:
3690: END IF;
3691:
3692: IF p_header_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;
3693: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute1,p_old_header_rec.attribute1) THEN
3694:
3695: l_result := ATTRIBUTE1
3696: (p_operation => l_operation
3697: ,p_record => l_rowtype_rec

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

3705:
3706: END IF;
3707:
3708: IF p_header_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;
3709: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute10,p_old_header_rec.attribute10) THEN
3710:
3711: l_result := ATTRIBUTE10
3712: (p_operation => l_operation
3713: ,p_record => l_rowtype_rec

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

3721:
3722: END IF;
3723:
3724: IF p_header_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;
3725: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute11,p_old_header_rec.attribute11) THEN
3726:
3727: l_result := ATTRIBUTE11
3728: (p_operation => l_operation
3729: ,p_record => l_rowtype_rec

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

3737:
3738: END IF;
3739:
3740: IF p_header_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;
3741: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute12,p_old_header_rec.attribute12) THEN
3742:
3743: l_result := ATTRIBUTE12
3744: (p_operation => l_operation
3745: ,p_record => l_rowtype_rec

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

3753:
3754: END IF;
3755:
3756: IF p_header_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;
3757: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute13,p_old_header_rec.attribute13) THEN
3758:
3759: l_result := ATTRIBUTE13
3760: (p_operation => l_operation
3761: ,p_record => l_rowtype_rec

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

3769:
3770: END IF;
3771:
3772: IF p_header_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;
3773: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute14,p_old_header_rec.attribute14) THEN
3774:
3775: l_result := ATTRIBUTE14
3776: (p_operation => l_operation
3777: ,p_record => l_rowtype_rec

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

3785:
3786: END IF;
3787:
3788: IF p_header_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;
3789: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute15,p_old_header_rec.attribute15) THEN
3790:
3791: l_result := ATTRIBUTE15
3792: (p_operation => l_operation
3793: ,p_record => l_rowtype_rec

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

3802: END IF;
3803:
3804: --For bug 2184255
3805: IF p_header_rec.attribute16 = FND_API.G_MISS_CHAR THEN NULL;
3806: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute16,p_old_header_rec.attribute16) THEN
3807:
3808: l_result := ATTRIBUTE16
3809: (p_operation => l_operation
3810: ,p_record => l_rowtype_rec

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

3818:
3819: END IF;
3820:
3821: IF p_header_rec.attribute17 = FND_API.G_MISS_CHAR THEN NULL;
3822: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute17,p_old_header_rec.attribute17) THEN
3823:
3824: l_result := ATTRIBUTE17
3825: (p_operation => l_operation
3826: ,p_record => l_rowtype_rec

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

3834:
3835: END IF;
3836:
3837: IF p_header_rec.attribute18 = FND_API.G_MISS_CHAR THEN NULL;
3838: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute18,p_old_header_rec.attribute18) THEN
3839:
3840: l_result := ATTRIBUTE18
3841: (p_operation => l_operation
3842: ,p_record => l_rowtype_rec

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

3850:
3851: END IF;
3852:
3853: IF p_header_rec.attribute19 = FND_API.G_MISS_CHAR THEN NULL;
3854: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute19,p_old_header_rec.attribute19) THEN
3855:
3856: l_result := ATTRIBUTE19
3857: (p_operation => l_operation
3858: ,p_record => l_rowtype_rec

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

3866:
3867: END IF;
3868:
3869: IF p_header_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;
3870: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute2,p_old_header_rec.attribute2) THEN
3871:
3872: l_result := ATTRIBUTE2
3873: (p_operation => l_operation
3874: ,p_record => l_rowtype_rec

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

3882:
3883: END IF;
3884:
3885: IF p_header_rec.attribute20 = FND_API.G_MISS_CHAR THEN NULL;
3886: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute20,p_old_header_rec.attribute20) THEN
3887:
3888: l_result := ATTRIBUTE20
3889: (p_operation => l_operation
3890: ,p_record => l_rowtype_rec

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

3900:
3901: --End bug 2184255
3902:
3903: IF p_header_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;
3904: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute3,p_old_header_rec.attribute3) THEN
3905:
3906: l_result := ATTRIBUTE3
3907: (p_operation => l_operation
3908: ,p_record => l_rowtype_rec

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

3916:
3917: END IF;
3918:
3919: IF p_header_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;
3920: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute4,p_old_header_rec.attribute4) THEN
3921:
3922: l_result := ATTRIBUTE4
3923: (p_operation => l_operation
3924: ,p_record => l_rowtype_rec

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

3932:
3933: END IF;
3934:
3935: IF p_header_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;
3936: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute5,p_old_header_rec.attribute5) THEN
3937:
3938: l_result := ATTRIBUTE5
3939: (p_operation => l_operation
3940: ,p_record => l_rowtype_rec

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

3948:
3949: END IF;
3950:
3951: IF p_header_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;
3952: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute6,p_old_header_rec.attribute6) THEN
3953:
3954: l_result := ATTRIBUTE6
3955: (p_operation => l_operation
3956: ,p_record => l_rowtype_rec

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

3964:
3965: END IF;
3966:
3967: IF p_header_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;
3968: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute7,p_old_header_rec.attribute7) THEN
3969:
3970: l_result := ATTRIBUTE7
3971: (p_operation => l_operation
3972: ,p_record => l_rowtype_rec

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

3980:
3981: END IF;
3982:
3983: IF p_header_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;
3984: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute8,p_old_header_rec.attribute8) THEN
3985:
3986: l_result := ATTRIBUTE8
3987: (p_operation => l_operation
3988: ,p_record => l_rowtype_rec

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

3996:
3997: END IF;
3998:
3999: IF p_header_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;
4000: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.attribute9,p_old_header_rec.attribute9) THEN
4001:
4002: l_result := ATTRIBUTE9
4003: (p_operation => l_operation
4004: ,p_record => l_rowtype_rec