APPS.OE_LINE_SECURITY dependencies on OE_GLOBALS

Line 25: l_ctr NUMBER := OE_GLOBALS.OE_AUDIT_HISTORY_TBL.count;

21: l_result NUMBER;
22: l_column_name VARCHAR2(30);
23: l_audit_trail_enabled VARCHAR2(1) := OE_SYS_PARAMETERS.VALUE('AUDIT_TRAIL_ENABLE_FLAG');
24: l_code_level VARCHAR2(6) := OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL;
25: l_ctr NUMBER := OE_GLOBALS.OE_AUDIT_HISTORY_TBL.count;
26: l_ind NUMBER;
27: l_history_captured BOOLEAN; -- Is history captured for this line?
28:
29: -- Variables for Integration Event Code

Line 148: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

144: End If;
145: End If;
146:
147: OE_delayed_requests_pvt.log_request
148: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
149: p_entity_id => p_record.header_id,
150: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
151: p_requesting_entity_id => p_record.header_id,
152: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,

Line 150: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

146:
147: OE_delayed_requests_pvt.log_request
148: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
149: p_entity_id => p_record.header_id,
150: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
151: p_requesting_entity_id => p_record.header_id,
152: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,
153: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
154: p_param1 => p_record.header_id,

Line 152: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,

148: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
149: p_entity_id => p_record.header_id,
150: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
151: p_requesting_entity_id => p_record.header_id,
152: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,
153: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
154: p_param1 => p_record.header_id,
155: p_param2 => p_record.order_source_id,
156: p_param3 => p_record.orig_sys_document_ref,

Line 169: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

165: p_param12 => l_gen_xml,
166: x_return_status => l_return_status);
167:
168: OE_delayed_requests_pvt.log_request
169: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
170: p_entity_id => p_record.line_id,
171: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
172: p_requesting_entity_id => p_record.line_id,
173: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_LN,

Line 171: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

167:
168: OE_delayed_requests_pvt.log_request
169: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
170: p_entity_id => p_record.line_id,
171: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
172: p_requesting_entity_id => p_record.line_id,
173: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_LN,
174: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
175: p_param1 => p_record.header_id,

Line 173: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_LN,

169: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
170: p_entity_id => p_record.line_id,
171: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
172: p_requesting_entity_id => p_record.line_id,
173: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_LN,
174: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
175: p_param1 => p_record.header_id,
176: p_param2 => p_record.order_source_id,
177: p_param3 => p_record.orig_sys_document_ref,

Line 217: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

213: l_gen_xml := 'B';
214: End IF;
215: End If;
216: OE_delayed_requests_pvt.log_request
217: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
218: p_entity_id => p_record.header_id,
219: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
220: p_requesting_entity_id => p_record.header_id,
221: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,

Line 219: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

215: End If;
216: OE_delayed_requests_pvt.log_request
217: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
218: p_entity_id => p_record.header_id,
219: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
220: p_requesting_entity_id => p_record.header_id,
221: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,
222: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
223: p_param1 => p_record.header_id,

Line 221: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,

217: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
218: p_entity_id => p_record.header_id,
219: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
220: p_requesting_entity_id => p_record.header_id,
221: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,
222: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
223: p_param1 => p_record.header_id,
224: p_param2 => p_record.order_source_id,
225: p_param3 => p_record.orig_sys_document_ref,

Line 238: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

234: p_param12 => l_gen_xml,
235: x_return_status => l_return_status);
236:
237: OE_delayed_requests_pvt.log_request
238: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
239: p_entity_id => p_record.line_id,
240: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
241: p_requesting_entity_id => p_record.line_id,
242: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_LN,

Line 240: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

236:
237: OE_delayed_requests_pvt.log_request
238: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
239: p_entity_id => p_record.line_id,
240: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
241: p_requesting_entity_id => p_record.line_id,
242: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_LN,
243: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
244: p_param1 => p_record.header_id,

Line 242: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_LN,

238: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
239: p_entity_id => p_record.line_id,
240: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
241: p_requesting_entity_id => p_record.line_id,
242: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_LN,
243: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
244: p_param1 => p_record.header_id,
245: p_param2 => 20,
246: p_param3 => p_record.orig_sys_document_ref,

Line 266: not OE_GLOBALS.G_HEADER_CREATED

262: Then
263:
264: If g_is_caller_defaulting = 'N' And
265: nvl(l_audit_trail_enabled,'D') <> 'D' And
266: not OE_GLOBALS.G_HEADER_CREATED
267: Then
268: If l_audit_trail_enabled = 'B' Then
269: If p_record.booked_flag = 'Y' Then
270: l_history_captured := FALSE;

Line 273: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).LINE_ID = p_record.line_id THEN

269: If p_record.booked_flag = 'Y' Then
270: l_history_captured := FALSE;
271: Begin
272: FOR l_ind in 1..l_ctr LOOP
273: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).LINE_ID = p_record.line_id THEN
274: l_history_captured := TRUE;
275: END IF;
276: END LOOP;
277: EXCEPTION WHEN OTHERS THEN

Line 281: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;

277: EXCEPTION WHEN OTHERS THEN
278: NULL;
279: END;
280: IF NOT l_history_captured THEN
281: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
282: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
283: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
284: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
285: END IF;

Line 282: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';

278: NULL;
279: END;
280: IF NOT l_history_captured THEN
281: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
282: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
283: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
284: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
285: END IF;
286: End If;

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

279: END;
280: IF NOT l_history_captured THEN
281: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
282: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
283: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
284: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
285: END IF;
286: End If;
287: Else

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

280: IF NOT l_history_captured THEN
281: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
282: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
283: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
284: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
285: END IF;
286: End If;
287: Else
288: l_history_captured := FALSE;

Line 291: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).LINE_ID = p_record.line_id THEN

287: Else
288: l_history_captured := FALSE;
289: BEGIN
290: FOR l_ind in 1..l_ctr LOOP
291: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).LINE_ID = p_record.line_id THEN
292: l_history_captured := TRUE;
293: END IF;
294: END LOOP;
295: EXCEPTION WHEN OTHERS THEN

Line 299: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;

295: EXCEPTION WHEN OTHERS THEN
296: NULL;
297: END;
298: IF NOT l_history_captured THEN
299: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
300: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
301: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
302: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
303: END IF;

Line 300: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';

296: NULL;
297: END;
298: IF NOT l_history_captured THEN
299: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
300: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
301: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
302: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
303: END IF;
304: End If;

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

297: END;
298: IF NOT l_history_captured THEN
299: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
300: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
301: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
302: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
303: END IF;
304: End If;
305: End If;

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

298: IF NOT l_history_captured THEN
299: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
300: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
301: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
302: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
303: END IF;
304: End If;
305: End If;
306:

Line 326: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

322: l_gen_xml := 'B';
323: End If;
324: End If;
325: OE_delayed_requests_pvt.log_request
326: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
327: p_entity_id => p_record.header_id,
328: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
329: p_requesting_entity_id => p_record.header_id,
330: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,

Line 328: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

324: End If;
325: OE_delayed_requests_pvt.log_request
326: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
327: p_entity_id => p_record.header_id,
328: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
329: p_requesting_entity_id => p_record.header_id,
330: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,
331: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
332: p_param1 => p_record.header_id,

Line 330: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,

326: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
327: p_entity_id => p_record.header_id,
328: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
329: p_requesting_entity_id => p_record.header_id,
330: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,
331: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
332: p_param1 => p_record.header_id,
333: p_param2 => p_record.order_source_id,
334: p_param3 => p_record.orig_sys_document_ref,

Line 347: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

343: p_param12 => l_gen_xml,
344: x_return_status => l_return_status);
345:
346: OE_delayed_requests_pvt.log_request
347: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
348: p_entity_id => p_record.line_id,
349: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
350: p_requesting_entity_id => p_record.line_id,
351: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_LN,

Line 349: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

345:
346: OE_delayed_requests_pvt.log_request
347: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
348: p_entity_id => p_record.line_id,
349: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
350: p_requesting_entity_id => p_record.line_id,
351: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_LN,
352: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
353: p_param1 => p_record.header_id,

Line 351: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_LN,

347: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
348: p_entity_id => p_record.line_id,
349: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
350: p_requesting_entity_id => p_record.line_id,
351: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_LN,
352: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
353: p_param1 => p_record.header_id,
354: p_param2 => 20,
355: p_param3 => p_record.orig_sys_document_ref,

Line 377: not OE_GLOBALS.G_HEADER_CREATED THEN

373: -- if Audit Trail enabled
374: IF g_is_caller_defaulting='N' THEN
375: IF l_code_level >= '110508' and nvl(l_audit_trail_enabled,'D') <> 'D' and
376: nvl(p_record.transaction_phase_code,'F') = 'F' and
377: not OE_GLOBALS.G_HEADER_CREATED THEN
378: IF l_debug_level > 0 THEN
379: OE_DEBUG_PUB.add('Audit Trail enabled ',5);
380: END IF;
381: IF l_audit_trail_enabled = 'B' THEN -- capture only for booked orders

Line 391: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).LINE_ID = p_record.line_id

387: l_history_captured := FALSE;
388: IF x_on_operation_action = 1 THEN
389: BEGIN
390: FOR l_ind in 1..l_ctr LOOP
391: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).LINE_ID = p_record.line_id
392: AND OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).HISTORY_TYPE = 'R' --5735600
393: THEN
394: l_history_captured := TRUE;
395: END IF;

Line 392: AND OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).HISTORY_TYPE = 'R' --5735600

388: IF x_on_operation_action = 1 THEN
389: BEGIN
390: FOR l_ind in 1..l_ctr LOOP
391: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).LINE_ID = p_record.line_id
392: AND OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).HISTORY_TYPE = 'R' --5735600
393: THEN
394: l_history_captured := TRUE;
395: END IF;
396: END LOOP;

Line 404: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;

400: END IF;
401: NULL;
402: END;
403: IF NOT l_history_captured THEN
404: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
405: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
406: IF l_debug_level > 0 THEN
407: oe_debug_pub.add('Line Security, attribute change requires reason',1);
408: END IF;

Line 405: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';

401: NULL;
402: END;
403: IF NOT l_history_captured THEN
404: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
405: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
406: IF l_debug_level > 0 THEN
407: oe_debug_pub.add('Line Security, attribute change requires reason',1);
408: END IF;
409: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';

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

405: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
406: IF l_debug_level > 0 THEN
407: oe_debug_pub.add('Line Security, attribute change requires reason',1);
408: END IF;
409: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
410: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
411: END IF;
412: ELSIF x_on_operation_action = 2 THEN
413: BEGIN

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

406: IF l_debug_level > 0 THEN
407: oe_debug_pub.add('Line Security, attribute change requires reason',1);
408: END IF;
409: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
410: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
411: END IF;
412: ELSIF x_on_operation_action = 2 THEN
413: BEGIN
414: FOR l_ind in 1..l_ctr LOOP

Line 415: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).LINE_ID = p_record.line_id THEN

411: END IF;
412: ELSIF x_on_operation_action = 2 THEN
413: BEGIN
414: FOR l_ind in 1..l_ctr LOOP
415: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).LINE_ID = p_record.line_id THEN
416: l_history_captured := TRUE;
417: END IF;
418: END LOOP;
419: EXCEPTION WHEN OTHERS THEN

Line 426: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;

422: END IF;
423: NULL;
424: END;
425: IF NOT l_history_captured THEN
426: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
427: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'H';
428: IF l_debug_level > 0 THEN
429: oe_debug_pub.add('Line Security, attribute change requires history',7);
430: END IF;

Line 427: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'H';

423: NULL;
424: END;
425: IF NOT l_history_captured THEN
426: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
427: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'H';
428: IF l_debug_level > 0 THEN
429: oe_debug_pub.add('Line Security, attribute change requires history',7);
430: END IF;
431: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then

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

427: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'H';
428: IF l_debug_level > 0 THEN
429: oe_debug_pub.add('Line Security, attribute change requires history',7);
430: END IF;
431: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
432: IF l_debug_level > 0 THEN
433: oe_debug_pub.add('Line Security, attribute change requires history',7);
434: END IF;
435: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

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

431: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
432: IF l_debug_level > 0 THEN
433: oe_debug_pub.add('Line Security, attribute change requires history',7);
434: END IF;
435: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
436: END IF;
437: END IF;
438: END IF;
439: END IF;

Line 447: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).LINE_ID = p_record.line_id

443: l_history_captured := FALSE;
444: IF x_on_operation_action = 1 THEN
445: BEGIN
446: FOR l_ind in 1..l_ctr LOOP
447: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).LINE_ID = p_record.line_id
448: AND OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).HISTORY_TYPE = 'R' --5735600
449: THEN
450: l_history_captured := TRUE;
451: END IF;

Line 448: AND OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).HISTORY_TYPE = 'R' --5735600

444: IF x_on_operation_action = 1 THEN
445: BEGIN
446: FOR l_ind in 1..l_ctr LOOP
447: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).LINE_ID = p_record.line_id
448: AND OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).HISTORY_TYPE = 'R' --5735600
449: THEN
450: l_history_captured := TRUE;
451: END IF;
452: END LOOP;

Line 460: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;

456: END IF;
457: NULL;
458: END;
459: IF NOT l_history_captured THEN
460: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
461: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
462: IF l_debug_level > 0 THEN
463: oe_debug_pub.add('Line Security, attribute change requires reason',1);
464: END IF;

Line 461: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';

457: NULL;
458: END;
459: IF NOT l_history_captured THEN
460: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
461: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
462: IF l_debug_level > 0 THEN
463: oe_debug_pub.add('Line Security, attribute change requires reason',1);
464: END IF;
465: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';

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

461: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
462: IF l_debug_level > 0 THEN
463: oe_debug_pub.add('Line Security, attribute change requires reason',1);
464: END IF;
465: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
466: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
467: END IF;
468: ELSIF x_on_operation_action = 2 THEN
469: BEGIN

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

462: IF l_debug_level > 0 THEN
463: oe_debug_pub.add('Line Security, attribute change requires reason',1);
464: END IF;
465: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
466: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
467: END IF;
468: ELSIF x_on_operation_action = 2 THEN
469: BEGIN
470: FOR l_ind in 1..l_ctr LOOP

Line 471: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).LINE_ID = p_record.line_id THEN

467: END IF;
468: ELSIF x_on_operation_action = 2 THEN
469: BEGIN
470: FOR l_ind in 1..l_ctr LOOP
471: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).LINE_ID = p_record.line_id THEN
472: l_history_captured := TRUE;
473: END IF;
474: END LOOP;
475: EXCEPTION WHEN OTHERS THEN

Line 482: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;

478: END IF;
479: NULL;
480: END;
481: IF NOT l_history_captured THEN
482: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
483: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'H';
484: IF l_debug_level > 0 THEN
485: oe_debug_pub.add('Line Security, attribute change requires history',7);
486: END IF;

Line 483: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'H';

479: NULL;
480: END;
481: IF NOT l_history_captured THEN
482: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
483: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'H';
484: IF l_debug_level > 0 THEN
485: oe_debug_pub.add('Line Security, attribute change requires history',7);
486: END IF;
487: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then

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

483: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'H';
484: IF l_debug_level > 0 THEN
485: oe_debug_pub.add('Line Security, attribute change requires history',7);
486: END IF;
487: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
488: IF l_debug_level > 0 THEN
489: oe_debug_pub.add('Line Security, attribute change requires history',7);
490: END IF;
491: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

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

487: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
488: IF l_debug_level > 0 THEN
489: oe_debug_pub.add('Line Security, attribute change requires history',7);
490: END IF;
491: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
492: END IF;
493: END IF;
494: END IF;
495: END IF;

Line 3142: IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

3138: IF l_debug_level > 0 THEN
3139: oe_debug_pub.add('hash before create operation');
3140: END IF;
3141:
3142: IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3143:
3144: IF l_debug_level > 0 THEN
3145: oe_debug_pub.add('hash in create operation');
3146: END IF;

Line 3184: --IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

3180: END IF;
3181: l_operation := OE_PC_GLOBALS.CREATE_OP;
3182: END IF; -- end if service
3183:
3184: --IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3185: -- l_operation := OE_PC_GLOBALS.CREATE_OP;
3186: /* end of bug 2922204 */
3187:
3188:

Line 3189: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

3185: -- l_operation := OE_PC_GLOBALS.CREATE_OP;
3186: /* end of bug 2922204 */
3187:
3188:
3189: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3190: l_operation := OE_PC_GLOBALS.UPDATE_OP;
3191: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
3192: l_operation := OE_PC_GLOBALS.DELETE_OP;
3193: ELSE

Line 3191: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

3187:
3188:
3189: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3190: l_operation := OE_PC_GLOBALS.UPDATE_OP;
3191: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
3192: l_operation := OE_PC_GLOBALS.DELETE_OP;
3193: ELSE
3194: IF l_debug_level > 0 THEN
3195: oe_debug_pub.add('Invalid operation',1);

Line 3270: IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

3266: -- Initializing out result to NOT CONSTRAINED
3267: x_result := OE_PC_GLOBALS.NO;
3268:
3269: -- Get the operation code to be passed to the security framework API
3270: IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3271:
3272: -- Bug 2639336 : if the order source is Copy then skip the Attribute
3273: -- level check
3274: -- Bug 3859436 : if the line is being split, skip attribute check.

Line 3275: IF p_LINE_rec.source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_COPY

3271:
3272: -- Bug 2639336 : if the order source is Copy then skip the Attribute
3273: -- level check
3274: -- Bug 3859436 : if the line is being split, skip attribute check.
3275: IF p_LINE_rec.source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_COPY
3276: OR p_line_rec.split_from_line_id <> FND_API.G_MISS_NUM
3277: THEN
3278: RETURN;
3279: ELSE

Line 3296: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

3292: THEN
3293: RETURN;
3294: END IF;
3295:
3296: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3297: l_operation := OE_PC_GLOBALS.UPDATE_OP;
3298: ELSE
3299: IF l_debug_level > 0 THEN
3300: oe_debug_pub.add('Invalid operation',1);

Line 3316: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.accounting_rule_id,p_old_line_rec.accounting_rule_id) THEN

3312: -- Compare the new and old entity records and
3313: -- check constraints for all the changed attributes.
3314:
3315: IF p_line_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN NULL;
3316: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.accounting_rule_id,p_old_line_rec.accounting_rule_id) THEN
3317:
3318: l_result := ACCOUNTING_RULE
3319: (p_operation => l_operation
3320: ,p_record => l_rowtype_rec

Line 3332: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.IB_OWNER,p_old_line_rec.IB_OWNER) THEN

3328:
3329: END IF;
3330:
3331: IF p_line_rec.IB_OWNER = FND_API.G_MISS_CHAR THEN NULL;
3332: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.IB_OWNER,p_old_line_rec.IB_OWNER) THEN
3333:
3334: l_result := IB_OWNER
3335: (p_operation => l_operation
3336: ,p_record => l_rowtype_rec

Line 3347: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.IB_CURRENT_LOCATION,p_old_line_rec.IB_CURRENT_LOCATION) THEN

3343: END IF;
3344:
3345: END IF;
3346: IF p_line_rec.IB_CURRENT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;
3347: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.IB_CURRENT_LOCATION,p_old_line_rec.IB_CURRENT_LOCATION) THEN
3348:
3349: l_result := IB_CURRENT_LOCATION
3350: (p_operation => l_operation
3351: ,p_record => l_rowtype_rec

Line 3362: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.IB_INSTALLED_AT_LOCATION,p_old_line_rec.IB_INSTALLED_AT_LOCATION) THEN

3358: END IF;
3359:
3360: END IF;
3361: IF p_line_rec.IB_INSTALLED_AT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;
3362: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.IB_INSTALLED_AT_LOCATION,p_old_line_rec.IB_INSTALLED_AT_LOCATION) THEN
3363:
3364: l_result := IB_INSTALLED_AT_LOCATION
3365: (p_operation => l_operation
3366: ,p_record => l_rowtype_rec

Line 3377: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.END_CUSTOMER_ID,p_old_line_rec.END_CUSTOMER_ID) THEN

3373: END IF;
3374:
3375: END IF;
3376: IF p_line_rec.END_CUSTOMER_ID = FND_API.G_MISS_NUM THEN NULL;
3377: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.END_CUSTOMER_ID,p_old_line_rec.END_CUSTOMER_ID) THEN
3378:
3379: l_result := END_CUSTOMER
3380: (p_operation => l_operation
3381: ,p_record => l_rowtype_rec

Line 3392: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.END_CUSTOMER_CONTACT_ID,p_old_line_rec.END_CUSTOMER_CONTACT_ID) THEN

3388: END IF;
3389:
3390: END IF;
3391: IF p_line_rec.END_CUSTOMER_CONTACT_ID = FND_API.G_MISS_NUM THEN NULL;
3392: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.END_CUSTOMER_CONTACT_ID,p_old_line_rec.END_CUSTOMER_CONTACT_ID) THEN
3393:
3394: l_result := END_CUSTOMER_CONTACT
3395: (p_operation => l_operation
3396: ,p_record => l_rowtype_rec

Line 3407: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.END_CUSTOMER_SITE_USE_ID,p_old_line_rec.END_CUSTOMER_SITE_USE_ID) THEN

3403: END IF;
3404:
3405: END IF;
3406: IF p_line_rec.END_CUSTOMER_SITE_USE_ID = FND_API.G_MISS_NUM THEN NULL;
3407: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.END_CUSTOMER_SITE_USE_ID,p_old_line_rec.END_CUSTOMER_SITE_USE_ID) THEN
3408:
3409: l_result := END_CUSTOMER_SITE_USE
3410: (p_operation => l_operation
3411: ,p_record => l_rowtype_rec

Line 3423: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.accounting_rule_duration,p_old_line_rec.accounting_rule_duration) THEN

3419:
3420: END IF;
3421:
3422: IF p_line_rec.accounting_rule_duration = FND_API.G_MISS_NUM THEN NULL;
3423: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.accounting_rule_duration,p_old_line_rec.accounting_rule_duration) THEN
3424:
3425: l_result := ACCOUNTING_RULE_DURATION
3426: (p_operation => l_operation
3427: ,p_record => l_rowtype_rec

Line 3439: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.agreement_id,p_old_line_rec.agreement_id) THEN

3435:
3436: END IF;
3437:
3438: IF p_line_rec.agreement_id = FND_API.G_MISS_NUM THEN NULL;
3439: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.agreement_id,p_old_line_rec.agreement_id) THEN
3440:
3441: l_result := AGREEMENT
3442: (p_operation => l_operation
3443: ,p_record => l_rowtype_rec

Line 3455: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.commitment_id,p_old_line_rec.commitment_id) THEN

3451:
3452: END IF;
3453:
3454: IF p_line_rec.commitment_id = FND_API.G_MISS_NUM THEN NULL;
3455: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.commitment_id,p_old_line_rec.commitment_id) THEN
3456:
3457: l_result := COMMITMENT_ID
3458: (p_operation => l_operation
3459: ,p_record => l_rowtype_rec

Line 3471: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.arrival_set_id,p_old_line_rec.arrival_set_id)

3467:
3468: END IF;
3469:
3470: IF p_line_rec.arrival_set_id = FND_API.G_MISS_NUM THEN NULL;
3471: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.arrival_set_id,p_old_line_rec.arrival_set_id)
3472: OR NOT OE_GLOBALS.EQUAL(p_line_rec.arrival_set,p_old_line_rec.arrival_set) THEN
3473:
3474: l_result := ARRIVAL_SET
3475: (p_operation => l_operation

Line 3472: OR NOT OE_GLOBALS.EQUAL(p_line_rec.arrival_set,p_old_line_rec.arrival_set) THEN

3468: END IF;
3469:
3470: IF p_line_rec.arrival_set_id = FND_API.G_MISS_NUM THEN NULL;
3471: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.arrival_set_id,p_old_line_rec.arrival_set_id)
3472: OR NOT OE_GLOBALS.EQUAL(p_line_rec.arrival_set,p_old_line_rec.arrival_set) THEN
3473:
3474: l_result := ARRIVAL_SET
3475: (p_operation => l_operation
3476: ,p_record => l_rowtype_rec

Line 3488: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.authorized_to_ship_flag,p_old_line_rec.authorized_to_ship_flag) THEN

3484:
3485: END IF;
3486:
3487: IF p_line_rec.authorized_to_ship_flag = FND_API.G_MISS_CHAR THEN NULL;
3488: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.authorized_to_ship_flag,p_old_line_rec.authorized_to_ship_flag) THEN
3489:
3490: l_result := AUTHORIZED_TO_SHIP
3491: (p_operation => l_operation
3492: ,p_record => l_rowtype_rec

Line 3504: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.credit_invoice_line_id,p_old_line_rec.credit_invoice_line_id) THEN

3500:
3501: END IF;
3502:
3503: IF p_line_rec.credit_invoice_line_id = FND_API.G_MISS_NUM THEN NULL;
3504: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.credit_invoice_line_id,p_old_line_rec.credit_invoice_line_id) THEN
3505:
3506: l_result := CREDIT_INVOICE_LINE
3507: (p_operation => l_operation
3508: ,p_record => l_rowtype_rec

Line 3520: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.customer_line_number,p_old_line_rec.customer_line_number) THEN

3516:
3517: END IF;
3518:
3519: IF p_line_rec.customer_line_number = FND_API.G_MISS_CHAR THEN NULL;
3520: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.customer_line_number,p_old_line_rec.customer_line_number) THEN
3521:
3522: l_result := CUSTOMER_LINE_NUMBER
3523: (p_operation => l_operation
3524: ,p_record => l_rowtype_rec

Line 3536: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.customer_trx_line_id,p_old_line_rec.customer_trx_line_id) THEN

3532:
3533: END IF;
3534:
3535: IF p_line_rec.customer_trx_line_id = FND_API.G_MISS_NUM THEN NULL;
3536: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.customer_trx_line_id,p_old_line_rec.customer_trx_line_id) THEN
3537:
3538: l_result := CUSTOMER_TRX_LINE
3539: (p_operation => l_operation
3540: ,p_record => l_rowtype_rec

Line 3552: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.cust_po_number,p_old_line_rec.cust_po_number) THEN

3548:
3549: END IF;
3550:
3551: IF p_line_rec.cust_po_number = FND_API.G_MISS_CHAR THEN NULL;
3552: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.cust_po_number,p_old_line_rec.cust_po_number) THEN
3553:
3554: l_result := CUST_PO_NUMBER
3555: (p_operation => l_operation
3556: ,p_record => l_rowtype_rec

Line 3568: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.delivery_lead_time,p_old_line_rec.delivery_lead_time) THEN

3564:
3565: END IF;
3566:
3567: IF p_line_rec.delivery_lead_time = FND_API.G_MISS_NUM THEN NULL;
3568: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.delivery_lead_time,p_old_line_rec.delivery_lead_time) THEN
3569:
3570: l_result := DELIVERY_LEAD_TIME
3571: (p_operation => l_operation
3572: ,p_record => l_rowtype_rec

Line 3584: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.deliver_to_contact_id,p_old_line_rec.deliver_to_contact_id) THEN

3580:
3581: END IF;
3582:
3583: IF p_line_rec.deliver_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
3584: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.deliver_to_contact_id,p_old_line_rec.deliver_to_contact_id) THEN
3585:
3586: l_result := DELIVER_TO_CONTACT
3587: (p_operation => l_operation
3588: ,p_record => l_rowtype_rec

Line 3600: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.deliver_to_org_id,p_old_line_rec.deliver_to_org_id) THEN

3596:
3597: END IF;
3598:
3599: IF p_line_rec.deliver_to_org_id = FND_API.G_MISS_NUM THEN NULL;
3600: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.deliver_to_org_id,p_old_line_rec.deliver_to_org_id) THEN
3601:
3602: l_result := DELIVER_TO_ORG
3603: (p_operation => l_operation
3604: ,p_record => l_rowtype_rec

Line 3616: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.demand_class_code,p_old_line_rec.demand_class_code) THEN

3612:
3613: END IF;
3614:
3615: IF p_line_rec.demand_class_code = FND_API.G_MISS_CHAR THEN NULL;
3616: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.demand_class_code,p_old_line_rec.demand_class_code) THEN
3617:
3618: l_result := DEMAND_CLASS
3619: (p_operation => l_operation
3620: ,p_record => l_rowtype_rec

Line 3632: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.dep_plan_required_flag,p_old_line_rec.dep_plan_required_flag) THEN

3628:
3629: END IF;
3630:
3631: IF p_line_rec.dep_plan_required_flag = FND_API.G_MISS_CHAR THEN NULL;
3632: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.dep_plan_required_flag,p_old_line_rec.dep_plan_required_flag) THEN
3633:
3634: l_result := DEP_PLAN_REQUIRED
3635: (p_operation => l_operation
3636: ,p_record => l_rowtype_rec

Line 3648: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.earliest_acceptable_date,p_old_line_rec.earliest_acceptable_date) THEN

3644:
3645: END IF;
3646:
3647: IF p_line_rec.earliest_acceptable_date = FND_API.G_MISS_DATE THEN NULL;
3648: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.earliest_acceptable_date,p_old_line_rec.earliest_acceptable_date) THEN
3649:
3650: l_result := EARLIEST_ACCEPTABLE_DATE
3651: (p_operation => l_operation
3652: ,p_record => l_rowtype_rec

Line 3664: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.end_item_unit_number,p_old_line_rec.end_item_unit_number) THEN

3660:
3661: END IF;
3662:
3663: IF p_line_rec.end_item_unit_number = FND_API.G_MISS_CHAR THEN NULL;
3664: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.end_item_unit_number,p_old_line_rec.end_item_unit_number) THEN
3665:
3666: l_result := END_ITEM_UNIT_NUMBER
3667: (p_operation => l_operation
3668: ,p_record => l_rowtype_rec

Line 3680: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.fob_point_code,p_old_line_rec.fob_point_code) THEN

3676:
3677: END IF;
3678:
3679: IF p_line_rec.fob_point_code = FND_API.G_MISS_CHAR THEN NULL;
3680: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.fob_point_code,p_old_line_rec.fob_point_code) THEN
3681:
3682: l_result := FOB_POINT
3683: (p_operation => l_operation
3684: ,p_record => l_rowtype_rec

Line 3696: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.freight_terms_code,p_old_line_rec.freight_terms_code) THEN

3692:
3693: END IF;
3694:
3695: IF p_line_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN NULL;
3696: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.freight_terms_code,p_old_line_rec.freight_terms_code) THEN
3697:
3698: l_result := FREIGHT_TERMS
3699: (p_operation => l_operation
3700: ,p_record => l_rowtype_rec

Line 3712: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.fulfilled_quantity,p_old_line_rec.fulfilled_quantity) THEN

3708:
3709: END IF;
3710:
3711: IF p_line_rec.fulfilled_quantity = FND_API.G_MISS_NUM THEN NULL;
3712: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.fulfilled_quantity,p_old_line_rec.fulfilled_quantity) THEN
3713:
3714: l_result := FULFILLED_QUANTITY
3715: (p_operation => l_operation
3716: ,p_record => l_rowtype_rec

Line 3729: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.fulfilled_quantity2,p_old_line_rec.fulfilled_quantity2) THEN

3725: END IF;
3726:
3727: -- INVCONV
3728: IF p_line_rec.fulfilled_quantity2 = FND_API.G_MISS_NUM THEN NULL;
3729: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.fulfilled_quantity2,p_old_line_rec.fulfilled_quantity2) THEN
3730:
3731: l_result := FULFILLED_QUANTITY2
3732: (p_operation => l_operation
3733: ,p_record => l_rowtype_rec

Line 3745: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id) THEN

3741:
3742: END IF;
3743:
3744: IF p_line_rec.inventory_item_id = FND_API.G_MISS_NUM THEN NULL;
3745: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id) THEN
3746:
3747: l_result := INVENTORY_ITEM
3748: (p_operation => l_operation
3749: ,p_record => l_rowtype_rec

Line 3761: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_contact_id,p_old_line_rec.invoice_to_contact_id) THEN

3757:
3758: END IF;
3759:
3760: IF p_line_rec.invoice_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
3761: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_contact_id,p_old_line_rec.invoice_to_contact_id) THEN
3762:
3763: l_result := INVOICE_TO_CONTACT
3764: (p_operation => l_operation
3765: ,p_record => l_rowtype_rec

Line 3777: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_org_id,p_old_line_rec.invoice_to_org_id) THEN

3773:
3774: END IF;
3775:
3776: IF p_line_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN NULL;
3777: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_org_id,p_old_line_rec.invoice_to_org_id) THEN
3778:
3779: l_result := INVOICE_TO_ORG
3780: (p_operation => l_operation
3781: ,p_record => l_rowtype_rec

Line 3793: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.invoicing_rule_id,p_old_line_rec.invoicing_rule_id) THEN

3789:
3790: END IF;
3791:
3792: IF p_line_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN NULL;
3793: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.invoicing_rule_id,p_old_line_rec.invoicing_rule_id) THEN
3794:
3795: l_result := INVOICING_RULE
3796: (p_operation => l_operation
3797: ,p_record => l_rowtype_rec

Line 3809: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.item_identifier_type,p_old_line_rec.item_identifier_type) THEN

3805:
3806: END IF;
3807:
3808: IF p_line_rec.item_identifier_type = FND_API.G_MISS_CHAR THEN NULL;
3809: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.item_identifier_type,p_old_line_rec.item_identifier_type) THEN
3810:
3811: l_result := ITEM_IDENTIFIER_TYPE
3812: (p_operation => l_operation
3813: ,p_record => l_rowtype_rec

Line 3825: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.item_revision,p_old_line_rec.item_revision) THEN

3821:
3822: END IF;
3823:
3824: IF p_line_rec.item_revision = FND_API.G_MISS_CHAR THEN NULL;
3825: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.item_revision,p_old_line_rec.item_revision) THEN
3826:
3827: l_result := ITEM_REVISION
3828: (p_operation => l_operation
3829: ,p_record => l_rowtype_rec

Line 3841: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.item_type_code,p_old_line_rec.item_type_code) THEN

3837:
3838: END IF;
3839:
3840: IF p_line_rec.item_type_code = FND_API.G_MISS_CHAR THEN NULL;
3841: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.item_type_code,p_old_line_rec.item_type_code) THEN
3842:
3843: l_result := ITEM_TYPE
3844: (p_operation => l_operation
3845: ,p_record => l_rowtype_rec

Line 3857: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.latest_acceptable_date,p_old_line_rec.latest_acceptable_date) THEN

3853:
3854: END IF;
3855:
3856: IF p_line_rec.latest_acceptable_date = FND_API.G_MISS_DATE THEN NULL;
3857: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.latest_acceptable_date,p_old_line_rec.latest_acceptable_date) THEN
3858:
3859: l_result := LATEST_ACCEPTABLE_DATE
3860: (p_operation => l_operation
3861: ,p_record => l_rowtype_rec

Line 3873: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.line_category_code,p_old_line_rec.line_category_code) THEN

3869:
3870: END IF;
3871:
3872: IF p_line_rec.line_category_code = FND_API.G_MISS_CHAR THEN NULL;
3873: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.line_category_code,p_old_line_rec.line_category_code) THEN
3874:
3875: l_result := LINE_CATEGORY
3876: (p_operation => l_operation
3877: ,p_record => l_rowtype_rec

Line 3889: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.line_number,p_old_line_rec.line_number) THEN

3885:
3886: END IF;
3887:
3888: IF p_line_rec.line_number = FND_API.G_MISS_NUM THEN NULL;
3889: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.line_number,p_old_line_rec.line_number) THEN
3890:
3891: l_result := LINE_NUMBER
3892: (p_operation => l_operation
3893: ,p_record => l_rowtype_rec

Line 3905: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.line_type_id,p_old_line_rec.line_type_id) THEN

3901:
3902: END IF;
3903:
3904: IF p_line_rec.line_type_id = FND_API.G_MISS_NUM THEN NULL;
3905: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.line_type_id,p_old_line_rec.line_type_id) THEN
3906:
3907: l_result := LINE_TYPE
3908: (p_operation => l_operation
3909: ,p_record => l_rowtype_rec

Line 3921: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity) THEN

3917:
3918: END IF;
3919:
3920: IF p_line_rec.ordered_quantity = FND_API.G_MISS_NUM THEN NULL;
3921: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity) THEN
3922:
3923: l_result := ORDERED_QUANTITY
3924: (p_operation => l_operation
3925: ,p_record => l_rowtype_rec

Line 3938: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ordered_quantity2,p_old_line_rec.ordered_quantity2) THEN

3934: END IF;
3935:
3936: -- OPM 1857167 start
3937: IF p_line_rec.ordered_quantity2 = FND_API.G_MISS_NUM THEN NULL;
3938: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ordered_quantity2,p_old_line_rec.ordered_quantity2) THEN
3939:
3940: l_result := ORDERED_QUANTITY2
3941: (p_operation => l_operation
3942: ,p_record => l_rowtype_rec

Line 3957: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom) THEN

3953:
3954:
3955:
3956: IF p_line_rec.order_quantity_uom = FND_API.G_MISS_CHAR THEN NULL;
3957: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom) THEN
3958:
3959: l_result := ORDER_QUANTITY_UOM
3960: (p_operation => l_operation
3961: ,p_record => l_rowtype_rec

Line 3973: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.over_ship_reason_code,p_old_line_rec.over_ship_reason_code) THEN

3969:
3970: END IF;
3971:
3972: IF p_line_rec.over_ship_reason_code = FND_API.G_MISS_CHAR THEN NULL;
3973: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.over_ship_reason_code,p_old_line_rec.over_ship_reason_code) THEN
3974:
3975: l_result := OVER_SHIP_REASON
3976: (p_operation => l_operation
3977: ,p_record => l_rowtype_rec

Line 3989: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.over_ship_resolved_flag,p_old_line_rec.over_ship_resolved_flag) THEN

3985:
3986: END IF;
3987:
3988: IF p_line_rec.over_ship_resolved_flag = FND_API.G_MISS_CHAR THEN NULL;
3989: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.over_ship_resolved_flag,p_old_line_rec.over_ship_resolved_flag) THEN
3990:
3991: l_result := OVER_SHIP_RESOLVED
3992: (p_operation => l_operation
3993: ,p_record => l_rowtype_rec

Line 4005: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.packing_instructions,p_old_line_rec.packing_instructions) THEN

4001:
4002: END IF;
4003:
4004: IF p_line_rec.packing_instructions = FND_API.G_MISS_CHAR THEN NULL;
4005: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.packing_instructions,p_old_line_rec.packing_instructions) THEN
4006:
4007: l_result := PACKING_INSTRUCTIONS
4008: (p_operation => l_operation
4009: ,p_record => l_rowtype_rec

Line 4021: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.payment_term_id,p_old_line_rec.payment_term_id) THEN

4017:
4018: END IF;
4019:
4020: IF p_line_rec.payment_term_id = FND_API.G_MISS_NUM THEN NULL;
4021: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.payment_term_id,p_old_line_rec.payment_term_id) THEN
4022:
4023: l_result := PAYMENT_TERM
4024: (p_operation => l_operation
4025: ,p_record => l_rowtype_rec

Line 4037: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.planning_priority,p_old_line_rec.planning_priority) THEN

4033:
4034: END IF;
4035:
4036: IF p_line_rec.planning_priority = FND_API.G_MISS_NUM THEN NULL;
4037: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.planning_priority,p_old_line_rec.planning_priority) THEN
4038:
4039: l_result := PLANNING_PRIORITY
4040: (p_operation => l_operation
4041: ,p_record => l_rowtype_rec

Line 4053: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.price_list_id,p_old_line_rec.price_list_id) THEN

4049:
4050: END IF;
4051:
4052: IF p_line_rec.price_list_id = FND_API.G_MISS_NUM THEN NULL;
4053: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.price_list_id,p_old_line_rec.price_list_id) THEN
4054:
4055: l_result := PRICE_LIST
4056: (p_operation => l_operation
4057: ,p_record => l_rowtype_rec

Line 4069: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.pricing_date,p_old_line_rec.pricing_date) THEN

4065:
4066: END IF;
4067:
4068: IF p_line_rec.pricing_date = FND_API.G_MISS_DATE THEN NULL;
4069: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.pricing_date,p_old_line_rec.pricing_date) THEN
4070:
4071: l_result := PRICING_DATE
4072: (p_operation => l_operation
4073: ,p_record => l_rowtype_rec

Line 4085: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.pricing_quantity,p_old_line_rec.pricing_quantity) THEN

4081:
4082: END IF;
4083:
4084: IF p_line_rec.pricing_quantity = FND_API.G_MISS_NUM THEN NULL;
4085: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.pricing_quantity,p_old_line_rec.pricing_quantity) THEN
4086:
4087: l_result := PRICING_QUANTITY
4088: (p_operation => l_operation
4089: ,p_record => l_rowtype_rec

Line 4101: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.pricing_quantity_uom,p_old_line_rec.pricing_quantity_uom) THEN

4097:
4098: END IF;
4099:
4100: IF p_line_rec.pricing_quantity_uom = FND_API.G_MISS_CHAR THEN NULL;
4101: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.pricing_quantity_uom,p_old_line_rec.pricing_quantity_uom) THEN
4102:
4103: l_result := PRICING_QUANTITY_UOM
4104: (p_operation => l_operation
4105: ,p_record => l_rowtype_rec

Line 4117: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.project_id,p_old_line_rec.project_id) THEN

4113:
4114: END IF;
4115:
4116: IF p_line_rec.project_id = FND_API.G_MISS_NUM THEN NULL;
4117: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.project_id,p_old_line_rec.project_id) THEN
4118:
4119: l_result := PROJECT
4120: (p_operation => l_operation
4121: ,p_record => l_rowtype_rec

Line 4133: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.promise_date,p_old_line_rec.promise_date) THEN

4129:
4130: END IF;
4131:
4132: IF p_line_rec.promise_date = FND_API.G_MISS_DATE THEN NULL;
4133: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.promise_date,p_old_line_rec.promise_date) THEN
4134:
4135: l_result := PROMISE_DATE
4136: (p_operation => l_operation
4137: ,p_record => l_rowtype_rec

Line 4149: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.request_date,p_old_line_rec.request_date) THEN

4145:
4146: END IF;
4147:
4148: IF p_line_rec.request_date = FND_API.G_MISS_DATE THEN NULL;
4149: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.request_date,p_old_line_rec.request_date) THEN
4150:
4151: l_result := REQUEST_DATE
4152: (p_operation => l_operation
4153: ,p_record => l_rowtype_rec

Line 4165: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.return_reason_code,p_old_line_rec.return_reason_code) THEN

4161:
4162: END IF;
4163:
4164: IF p_line_rec.return_reason_code = FND_API.G_MISS_CHAR THEN NULL;
4165: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.return_reason_code,p_old_line_rec.return_reason_code) THEN
4166:
4167: l_result := RETURN_REASON
4168: (p_operation => l_operation
4169: ,p_record => l_rowtype_rec

Line 4181: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.salesrep_id,p_old_line_rec.salesrep_id) THEN

4177:
4178: END IF;
4179:
4180: IF p_line_rec.salesrep_id = FND_API.G_MISS_NUM THEN NULL;
4181: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.salesrep_id,p_old_line_rec.salesrep_id) THEN
4182:
4183: l_result := SALESREP
4184: (p_operation => l_operation
4185: ,p_record => l_rowtype_rec

Line 4197: ELSIF NOT OE_GLOBALS.EQUAL(trunc(p_line_rec.schedule_arrival_date),trunc(p_old_line_rec.schedule_arrival_date)) THEN

4193:
4194: END IF;
4195:
4196: IF p_line_rec.schedule_arrival_date = FND_API.G_MISS_DATE THEN NULL;
4197: ELSIF NOT OE_GLOBALS.EQUAL(trunc(p_line_rec.schedule_arrival_date),trunc(p_old_line_rec.schedule_arrival_date)) THEN
4198:
4199: l_result := SCHEDULE_ARRIVAL_DATE
4200: (p_operation => l_operation
4201: ,p_record => l_rowtype_rec

Line 4213: ELSIF NOT OE_GLOBALS.EQUAL(trunc(p_line_rec.schedule_ship_date),trunc(p_old_line_rec.schedule_ship_date)) THEN

4209:
4210: END IF;
4211:
4212: IF p_line_rec.schedule_ship_date = FND_API.G_MISS_DATE THEN NULL;
4213: ELSIF NOT OE_GLOBALS.EQUAL(trunc(p_line_rec.schedule_ship_date),trunc(p_old_line_rec.schedule_ship_date)) THEN
4214:
4215: l_result := SCHEDULE_SHIP_DATE
4216: (p_operation => l_operation
4217: ,p_record => l_rowtype_rec

Line 4229: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_reference_line_id,p_old_line_rec.service_reference_line_id) THEN

4225:
4226: END IF;
4227:
4228: IF p_line_rec.service_reference_line_id = FND_API.G_MISS_NUM THEN NULL;
4229: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_reference_line_id,p_old_line_rec.service_reference_line_id) THEN
4230:
4231: l_result := SERVICE_REFERENCE_LINE
4232: (p_operation => l_operation
4233: ,p_record => l_rowtype_rec

Line 4245: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_reference_system_id,p_old_line_rec.service_reference_system_id) THEN

4241:
4242: END IF;
4243:
4244: IF p_line_rec.service_reference_system_id = FND_API.G_MISS_NUM THEN NULL;
4245: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_reference_system_id,p_old_line_rec.service_reference_system_id) THEN
4246:
4247: l_result := SERVICE_REFERENCE_SYSTEM
4248: (p_operation => l_operation
4249: ,p_record => l_rowtype_rec

Line 4261: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_reference_type_code,p_old_line_rec.service_reference_type_code) THEN

4257:
4258: END IF;
4259:
4260: IF p_line_rec.service_reference_type_code = FND_API.G_MISS_CHAR THEN NULL;
4261: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_reference_type_code,p_old_line_rec.service_reference_type_code) THEN
4262:
4263: l_result := SERVICE_REFERENCE_TYPE
4264: (p_operation => l_operation
4265: ,p_record => l_rowtype_rec

Line 4280: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_coterminate_flag,p_old_line_rec.service_coterminate_flag) THEN

4276: /* Fix to bug 2205900: Added constraints functions for
4277: some missing SERVICE fields */
4278:
4279: IF p_line_rec.service_coterminate_flag = FND_API.G_MISS_CHAR THEN NULL;
4280: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_coterminate_flag,p_old_line_rec.service_coterminate_flag) THEN
4281:
4282: l_result := SERVICE_COTERMINATE
4283: (p_operation => l_operation
4284: ,p_record => l_rowtype_rec

Line 4296: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_duration,p_old_line_rec.service_duration) THEN

4292:
4293: END IF;
4294:
4295: IF p_line_rec.service_duration = FND_API.G_MISS_NUM THEN NULL;
4296: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_duration,p_old_line_rec.service_duration) THEN
4297:
4298: l_result := SERVICE_DURATION
4299: (p_operation => l_operation
4300: ,p_record => l_rowtype_rec

Line 4312: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_end_date,p_old_line_rec.service_end_date) THEN

4308:
4309: END IF;
4310:
4311: IF p_line_rec.service_end_date = FND_API.G_MISS_DATE THEN NULL;
4312: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_end_date,p_old_line_rec.service_end_date) THEN
4313:
4314: l_result := SERVICE_END_DATE
4315: (p_operation => l_operation
4316: ,p_record => l_rowtype_rec

Line 4328: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_period,p_old_line_rec.service_period) THEN

4324:
4325: END IF;
4326:
4327: IF p_line_rec.service_period = FND_API.G_MISS_CHAR THEN NULL;
4328: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_period,p_old_line_rec.service_period) THEN
4329:
4330: l_result := SERVICE_PERIOD
4331: (p_operation => l_operation
4332: ,p_record => l_rowtype_rec

Line 4344: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_start_date,p_old_line_rec.service_start_date) THEN

4340:
4341: END IF;
4342:
4343: IF p_line_rec.service_start_date = FND_API.G_MISS_DATE THEN NULL;
4344: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_start_date,p_old_line_rec.service_start_date) THEN
4345:
4346: l_result := SERVICE_START_DATE
4347: (p_operation => l_operation
4348: ,p_record => l_rowtype_rec

Line 4360: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_txn_comments,p_old_line_rec.service_txn_comments) THEN

4356:
4357: END IF;
4358:
4359: IF p_line_rec.service_txn_comments = FND_API.G_MISS_CHAR THEN NULL;
4360: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_txn_comments,p_old_line_rec.service_txn_comments) THEN
4361:
4362: l_result := SERVICE_TXN_COMMENTS
4363: (p_operation => l_operation
4364: ,p_record => l_rowtype_rec

Line 4376: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_txn_reason_code,p_old_line_rec.service_txn_reason_code) THEN

4372:
4373: END IF;
4374:
4375: IF p_line_rec.service_txn_reason_code = FND_API.G_MISS_CHAR THEN NULL;
4376: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_txn_reason_code,p_old_line_rec.service_txn_reason_code) THEN
4377:
4378: l_result := SERVICE_TXN_REASON
4379: (p_operation => l_operation
4380: ,p_record => l_rowtype_rec

Line 4392: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipment_number,p_old_line_rec.shipment_number) THEN

4388:
4389: END IF;
4390:
4391: IF p_line_rec.shipment_number = FND_API.G_MISS_NUM THEN NULL;
4392: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipment_number,p_old_line_rec.shipment_number) THEN
4393:
4394: l_result := SHIPMENT_NUMBER
4395: (p_operation => l_operation
4396: ,p_record => l_rowtype_rec

Line 4408: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipment_priority_code,p_old_line_rec.shipment_priority_code) THEN

4404:
4405: END IF;
4406:
4407: IF p_line_rec.shipment_priority_code = FND_API.G_MISS_CHAR THEN NULL;
4408: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipment_priority_code,p_old_line_rec.shipment_priority_code) THEN
4409:
4410: l_result := SHIPMENT_PRIORITY
4411: (p_operation => l_operation
4412: ,p_record => l_rowtype_rec

Line 4424: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipped_quantity,p_old_line_rec.shipped_quantity) THEN

4420:
4421: END IF;
4422:
4423: IF p_line_rec.shipped_quantity = FND_API.G_MISS_NUM THEN NULL;
4424: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipped_quantity,p_old_line_rec.shipped_quantity) THEN
4425:
4426: l_result := SHIPPED_QUANTITY
4427: (p_operation => l_operation
4428: ,p_record => l_rowtype_rec

Line 4441: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipped_quantity2,p_old_line_rec.shipped_quantity2) THEN

4437: END IF;
4438:
4439: -- INVCONV
4440: IF p_line_rec.shipped_quantity2 = FND_API.G_MISS_NUM THEN NULL;
4441: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipped_quantity2,p_old_line_rec.shipped_quantity2) THEN
4442:
4443: l_result := SHIPPED_QUANTITY2
4444: (p_operation => l_operation
4445: ,p_record => l_rowtype_rec

Line 4458: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_instructions,p_old_line_rec.shipping_instructions) THEN

4454: END IF;
4455:
4456:
4457: IF p_line_rec.shipping_instructions = FND_API.G_MISS_CHAR THEN NULL;
4458: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_instructions,p_old_line_rec.shipping_instructions) THEN
4459:
4460: l_result := SHIPPING_INSTRUCTIONS
4461: (p_operation => l_operation
4462: ,p_record => l_rowtype_rec

Line 4474: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_method_code,p_old_line_rec.shipping_method_code) THEN

4470:
4471: END IF;
4472:
4473: IF p_line_rec.shipping_method_code = FND_API.G_MISS_CHAR THEN NULL;
4474: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_method_code,p_old_line_rec.shipping_method_code) THEN
4475:
4476: l_result := SHIPPING_METHOD
4477: (p_operation => l_operation
4478: ,p_record => l_rowtype_rec

Line 4490: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_quantity,p_old_line_rec.shipping_quantity) THEN

4486:
4487: END IF;
4488:
4489: IF p_line_rec.shipping_quantity = FND_API.G_MISS_NUM THEN NULL;
4490: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_quantity,p_old_line_rec.shipping_quantity) THEN
4491:
4492: l_result := SHIPPING_QUANTITY
4493: (p_operation => l_operation
4494: ,p_record => l_rowtype_rec

Line 4507: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_quantity2,p_old_line_rec.shipping_quantity2) THEN

4503: END IF;
4504:
4505: -- INVCONV
4506: IF p_line_rec.shipping_quantity2 = FND_API.G_MISS_NUM THEN NULL;
4507: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_quantity2,p_old_line_rec.shipping_quantity2) THEN
4508:
4509: l_result := SHIPPING_QUANTITY2
4510: (p_operation => l_operation
4511: ,p_record => l_rowtype_rec

Line 4525: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_quantity_uom,p_old_line_rec.shipping_quantity_uom) THEN

4521:
4522:
4523:
4524: IF p_line_rec.shipping_quantity_uom = FND_API.G_MISS_CHAR THEN NULL;
4525: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_quantity_uom,p_old_line_rec.shipping_quantity_uom) THEN
4526:
4527: l_result := SHIPPING_QUANTITY_UOM
4528: (p_operation => l_operation
4529: ,p_record => l_rowtype_rec

Line 4542: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_quantity_uom2,p_old_line_rec.shipping_quantity_uom2) THEN

4538: END IF;
4539:
4540: -- INVCONV
4541: IF p_line_rec.shipping_quantity_uom2 = FND_API.G_MISS_CHAR THEN NULL;
4542: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_quantity_uom2,p_old_line_rec.shipping_quantity_uom2) THEN
4543:
4544: l_result := SHIPPING_QUANTITY_UOM2
4545: (p_operation => l_operation
4546: ,p_record => l_rowtype_rec

Line 4559: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_from_org_id,p_old_line_rec.ship_from_org_id) THEN

4555: END IF;
4556:
4557:
4558: IF p_line_rec.ship_from_org_id = FND_API.G_MISS_NUM THEN NULL;
4559: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_from_org_id,p_old_line_rec.ship_from_org_id) THEN
4560:
4561: l_result := SHIP_FROM_ORG
4562: (p_operation => l_operation
4563: ,p_record => l_rowtype_rec

Line 4575: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_model_complete_flag,p_old_line_rec.ship_model_complete_flag) THEN

4571:
4572: END IF;
4573:
4574: IF p_line_rec.ship_model_complete_flag = FND_API.G_MISS_CHAR THEN NULL;
4575: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_model_complete_flag,p_old_line_rec.ship_model_complete_flag) THEN
4576:
4577: l_result := SHIP_MODEL_COMPLETE
4578: (p_operation => l_operation
4579: ,p_record => l_rowtype_rec

Line 4591: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_set_id,p_old_line_rec.ship_set_id)

4587:
4588: END IF;
4589:
4590: IF p_line_rec.ship_set_id = FND_API.G_MISS_NUM THEN NULL;
4591: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_set_id,p_old_line_rec.ship_set_id)
4592: OR NOT OE_GLOBALS.EQUAL(p_line_rec.ship_set,p_old_line_rec.ship_set) THEN
4593:
4594: l_result := SHIP_SET
4595: (p_operation => l_operation

Line 4592: OR NOT OE_GLOBALS.EQUAL(p_line_rec.ship_set,p_old_line_rec.ship_set) THEN

4588: END IF;
4589:
4590: IF p_line_rec.ship_set_id = FND_API.G_MISS_NUM THEN NULL;
4591: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_set_id,p_old_line_rec.ship_set_id)
4592: OR NOT OE_GLOBALS.EQUAL(p_line_rec.ship_set,p_old_line_rec.ship_set) THEN
4593:
4594: l_result := SHIP_SET
4595: (p_operation => l_operation
4596: ,p_record => l_rowtype_rec

Line 4608: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_tolerance_above,p_old_line_rec.ship_tolerance_above) THEN

4604:
4605: END IF;
4606:
4607: IF p_line_rec.ship_tolerance_above = FND_API.G_MISS_NUM THEN NULL;
4608: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_tolerance_above,p_old_line_rec.ship_tolerance_above) THEN
4609:
4610: l_result := SHIP_TOLERANCE_ABOVE
4611: (p_operation => l_operation
4612: ,p_record => l_rowtype_rec

Line 4624: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_tolerance_below,p_old_line_rec.ship_tolerance_below) THEN

4620:
4621: END IF;
4622:
4623: IF p_line_rec.ship_tolerance_below = FND_API.G_MISS_NUM THEN NULL;
4624: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_tolerance_below,p_old_line_rec.ship_tolerance_below) THEN
4625:
4626: l_result := SHIP_TOLERANCE_BELOW
4627: (p_operation => l_operation
4628: ,p_record => l_rowtype_rec

Line 4640: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_contact_id,p_old_line_rec.ship_to_contact_id) THEN

4636:
4637: END IF;
4638:
4639: IF p_line_rec.ship_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
4640: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_contact_id,p_old_line_rec.ship_to_contact_id) THEN
4641:
4642: l_result := SHIP_TO_CONTACT
4643: (p_operation => l_operation
4644: ,p_record => l_rowtype_rec

Line 4656: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id) THEN

4652:
4653: END IF;
4654:
4655: IF p_line_rec.ship_to_org_id = FND_API.G_MISS_NUM THEN NULL;
4656: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id) THEN
4657:
4658: l_result := SHIP_TO_ORG
4659: (p_operation => l_operation
4660: ,p_record => l_rowtype_rec

Line 4672: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id) THEN

4668:
4669: END IF;
4670:
4671: IF p_line_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN NULL;
4672: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id) THEN
4673:
4674: l_result := SOLD_TO_ORG
4675: (p_operation => l_operation
4676: ,p_record => l_rowtype_rec

Line 4688: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.source_type_code,p_old_line_rec.source_type_code) THEN

4684:
4685: END IF;
4686:
4687: IF p_line_rec.source_type_code = FND_API.G_MISS_CHAR THEN NULL;
4688: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.source_type_code,p_old_line_rec.source_type_code) THEN
4689:
4690: l_result := SOURCE_TYPE
4691: (p_operation => l_operation
4692: ,p_record => l_rowtype_rec

Line 4704: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.subinventory,p_old_line_rec.subinventory) THEN

4700:
4701: END IF;
4702:
4703: IF p_line_rec.subinventory = FND_API.G_MISS_CHAR THEN NULL;
4704: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.subinventory,p_old_line_rec.subinventory) THEN
4705:
4706: l_result := SUBINVENTORY
4707: (p_operation => l_operation
4708: ,p_record => l_rowtype_rec

Line 4720: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.task_id,p_old_line_rec.task_id) THEN

4716:
4717: END IF;
4718:
4719: IF p_line_rec.task_id = FND_API.G_MISS_NUM THEN NULL;
4720: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.task_id,p_old_line_rec.task_id) THEN
4721:
4722: l_result := TASK
4723: (p_operation => l_operation
4724: ,p_record => l_rowtype_rec

Line 4736: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.tax_code,p_old_line_rec.tax_code) THEN

4732:
4733: END IF;
4734:
4735: IF p_line_rec.tax_code = FND_API.G_MISS_CHAR THEN NULL;
4736: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.tax_code,p_old_line_rec.tax_code) THEN
4737:
4738: l_result := TAX
4739: (p_operation => l_operation
4740: ,p_record => l_rowtype_rec

Line 4752: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.tax_date,p_old_line_rec.tax_date) THEN

4748:
4749: END IF;
4750:
4751: IF p_line_rec.tax_date = FND_API.G_MISS_DATE THEN NULL;
4752: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.tax_date,p_old_line_rec.tax_date) THEN
4753:
4754: l_result := TAX_DATE
4755: (p_operation => l_operation
4756: ,p_record => l_rowtype_rec

Line 4768: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.tax_exempt_flag,p_old_line_rec.tax_exempt_flag) THEN

4764:
4765: END IF;
4766:
4767: IF p_line_rec.tax_exempt_flag = FND_API.G_MISS_CHAR THEN NULL;
4768: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.tax_exempt_flag,p_old_line_rec.tax_exempt_flag) THEN
4769:
4770: l_result := TAX_EXEMPT
4771: (p_operation => l_operation
4772: ,p_record => l_rowtype_rec

Line 4784: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.tax_exempt_number,p_old_line_rec.tax_exempt_number) THEN

4780:
4781: END IF;
4782:
4783: IF p_line_rec.tax_exempt_number = FND_API.G_MISS_CHAR THEN NULL;
4784: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.tax_exempt_number,p_old_line_rec.tax_exempt_number) THEN
4785:
4786: l_result := TAX_EXEMPT_NUMBER
4787: (p_operation => l_operation
4788: ,p_record => l_rowtype_rec

Line 4800: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.tax_exempt_reason_code,p_old_line_rec.tax_exempt_reason_code) THEN

4796:
4797: END IF;
4798:
4799: IF p_line_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR THEN NULL;
4800: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.tax_exempt_reason_code,p_old_line_rec.tax_exempt_reason_code) THEN
4801:
4802: l_result := TAX_EXEMPT_REASON
4803: (p_operation => l_operation
4804: ,p_record => l_rowtype_rec

Line 4816: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.unit_list_price,p_old_line_rec.unit_list_price) THEN

4812:
4813: END IF;
4814:
4815: IF p_line_rec.unit_list_price = FND_API.G_MISS_NUM THEN NULL;
4816: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.unit_list_price,p_old_line_rec.unit_list_price) THEN
4817:
4818: l_result := UNIT_LIST_PRICE
4819: (p_operation => l_operation
4820: ,p_record => l_rowtype_rec

Line 4832: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.unit_selling_price,p_old_line_rec.unit_selling_price) THEN

4828:
4829: END IF;
4830:
4831: IF p_line_rec.unit_selling_price = FND_API.G_MISS_NUM THEN NULL;
4832: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.unit_selling_price,p_old_line_rec.unit_selling_price) THEN
4833:
4834: l_result := UNIT_SELLING_PRICE
4835: (p_operation => l_operation
4836: ,p_record => l_rowtype_rec

Line 4849: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.blanket_number,p_old_line_rec.blanket_number) THEN

4845: END IF;
4846:
4847: -- BEGIN: Blankets Code Merge
4848: IF p_line_rec.blanket_number = FND_API.G_MISS_NUM THEN NULL;
4849: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.blanket_number,p_old_line_rec.blanket_number) THEN
4850:
4851: l_result := BLANKET_NUMBER
4852: (p_operation => l_operation
4853: ,p_record => l_rowtype_rec

Line 4865: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.blanket_line_number,p_old_line_rec.blanket_line_number) THEN

4861:
4862: END IF;
4863:
4864: IF p_line_rec.blanket_line_number = FND_API.G_MISS_NUM THEN NULL;
4865: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.blanket_line_number,p_old_line_rec.blanket_line_number) THEN
4866:
4867: l_result := BLANKET_LINE_NUMBER
4868: (p_operation => l_operation
4869: ,p_record => l_rowtype_rec

Line 4883: (NOT OE_GLOBALS.Equal(p_line_rec.price_list_id,

4879: -- END: Blankets Code Merge
4880:
4881: IF ((nvl(p_line_rec.calculate_price_flag,'N')='Y') AND
4882: (p_line_rec.price_list_id IS NOT NULL) AND
4883: (NOT OE_GLOBALS.Equal(p_line_rec.price_list_id,
4884: p_old_line_rec.price_list_id)) ) THEN
4885: BEGIN
4886: SELECT active_flag
4887: INTO l_active_flag

Line 4906: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.calculate_price_flag

4902: END IF;
4903:
4904: IF p_line_rec.calculate_price_flag = FND_API.G_MISS_CHAR THEN
4905: NULL;
4906: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.calculate_price_flag
4907: ,p_old_line_rec.calculate_price_flag) THEN
4908:
4909: l_result := calculate_price_flag(p_operation => l_operation
4910: ,p_record => l_rowtype_rec

Line 4921: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.customer_shipment_number,p_old_line_rec.customer_shipment_number) THEN

4917: END IF;
4918:
4919: IF p_line_rec.customer_shipment_number = FND_API.G_MISS_CHAR THEN
4920: NULL;
4921: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.customer_shipment_number,p_old_line_rec.customer_shipment_number) THEN
4922:
4923: l_result := CUSTOMER_SHIPMENT_NUMBER
4924: (p_operation => l_operation
4925: ,p_record => l_rowtype_rec

Line 4955: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.context,p_old_line_rec.context) THEN

4951: g_check_all_cols_constraint := 'N';
4952: END IF;
4953:
4954: IF p_line_rec.context = FND_API.G_MISS_CHAR THEN NULL;
4955: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.context,p_old_line_rec.context) THEN
4956:
4957: l_result := CONTEXT
4958: (p_operation => l_operation
4959: ,p_record => l_rowtype_rec

Line 4971: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute1,p_old_line_rec.attribute1) THEN

4967:
4968: END IF;
4969:
4970: IF p_line_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;
4971: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute1,p_old_line_rec.attribute1) THEN
4972:
4973: l_result := ATTRIBUTE1
4974: (p_operation => l_operation
4975: ,p_record => l_rowtype_rec

Line 4987: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute10,p_old_line_rec.attribute10) THEN

4983:
4984: END IF;
4985:
4986: IF p_line_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;
4987: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute10,p_old_line_rec.attribute10) THEN
4988:
4989: l_result := ATTRIBUTE10
4990: (p_operation => l_operation
4991: ,p_record => l_rowtype_rec

Line 5003: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute11,p_old_line_rec.attribute11) THEN

4999:
5000: END IF;
5001:
5002: IF p_line_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;
5003: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute11,p_old_line_rec.attribute11) THEN
5004:
5005: l_result := ATTRIBUTE11
5006: (p_operation => l_operation
5007: ,p_record => l_rowtype_rec

Line 5019: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute12,p_old_line_rec.attribute12) THEN

5015:
5016: END IF;
5017:
5018: IF p_line_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;
5019: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute12,p_old_line_rec.attribute12) THEN
5020:
5021: l_result := ATTRIBUTE12
5022: (p_operation => l_operation
5023: ,p_record => l_rowtype_rec

Line 5035: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute13,p_old_line_rec.attribute13) THEN

5031:
5032: END IF;
5033:
5034: IF p_line_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;
5035: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute13,p_old_line_rec.attribute13) THEN
5036:
5037: l_result := ATTRIBUTE13
5038: (p_operation => l_operation
5039: ,p_record => l_rowtype_rec

Line 5051: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute14,p_old_line_rec.attribute14) THEN

5047:
5048: END IF;
5049:
5050: IF p_line_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;
5051: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute14,p_old_line_rec.attribute14) THEN
5052:
5053: l_result := ATTRIBUTE14
5054: (p_operation => l_operation
5055: ,p_record => l_rowtype_rec

Line 5067: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute15,p_old_line_rec.attribute15) THEN

5063:
5064: END IF;
5065:
5066: IF p_line_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;
5067: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute15,p_old_line_rec.attribute15) THEN
5068:
5069: l_result := ATTRIBUTE15
5070: (p_operation => l_operation
5071: ,p_record => l_rowtype_rec

Line 5085: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute16,p_old_line_rec.attribute16) THEN

5081:
5082: -- For bug 2184255
5083:
5084: IF p_line_rec.attribute16 = FND_API.G_MISS_CHAR THEN NULL;
5085: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute16,p_old_line_rec.attribute16) THEN
5086:
5087: l_result := ATTRIBUTE16
5088: (p_operation => l_operation
5089: ,p_record => l_rowtype_rec

Line 5101: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute17,p_old_line_rec.attribute17) THEN

5097:
5098: END IF;
5099:
5100: IF p_line_rec.attribute17 = FND_API.G_MISS_CHAR THEN NULL;
5101: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute17,p_old_line_rec.attribute17) THEN
5102:
5103: l_result := ATTRIBUTE17
5104: (p_operation => l_operation
5105: ,p_record => l_rowtype_rec

Line 5117: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute18,p_old_line_rec.attribute18) THEN

5113:
5114: END IF;
5115:
5116: IF p_line_rec.attribute18 = FND_API.G_MISS_CHAR THEN NULL;
5117: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute18,p_old_line_rec.attribute18) THEN
5118:
5119: l_result := ATTRIBUTE18
5120: (p_operation => l_operation
5121: ,p_record => l_rowtype_rec

Line 5133: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute19,p_old_line_rec.attribute19) THEN

5129:
5130: END IF;
5131:
5132: IF p_line_rec.attribute19 = FND_API.G_MISS_CHAR THEN NULL;
5133: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute19,p_old_line_rec.attribute19) THEN
5134:
5135: l_result := ATTRIBUTE19
5136: (p_operation => l_operation
5137: ,p_record => l_rowtype_rec

Line 5149: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute2,p_old_line_rec.attribute2) THEN

5145:
5146: END IF;
5147:
5148: IF p_line_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;
5149: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute2,p_old_line_rec.attribute2) THEN
5150:
5151: l_result := ATTRIBUTE2
5152: (p_operation => l_operation
5153: ,p_record => l_rowtype_rec

Line 5166: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute20,p_old_line_rec.attribute20) THEN

5162: END IF;
5163:
5164:
5165: IF p_line_rec.attribute20 = FND_API.G_MISS_CHAR THEN NULL;
5166: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute20,p_old_line_rec.attribute20) THEN
5167:
5168: l_result := ATTRIBUTE20
5169: (p_operation => l_operation
5170: ,p_record => l_rowtype_rec

Line 5184: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute3,p_old_line_rec.attribute3) THEN

5180:
5181: -- End bug 2184255
5182:
5183: IF p_line_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;
5184: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute3,p_old_line_rec.attribute3) THEN
5185:
5186: l_result := ATTRIBUTE3
5187: (p_operation => l_operation
5188: ,p_record => l_rowtype_rec

Line 5200: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute4,p_old_line_rec.attribute4) THEN

5196:
5197: END IF;
5198:
5199: IF p_line_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;
5200: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute4,p_old_line_rec.attribute4) THEN
5201:
5202: l_result := ATTRIBUTE4
5203: (p_operation => l_operation
5204: ,p_record => l_rowtype_rec

Line 5216: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute5,p_old_line_rec.attribute5) THEN

5212:
5213: END IF;
5214:
5215: IF p_line_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;
5216: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute5,p_old_line_rec.attribute5) THEN
5217:
5218: l_result := ATTRIBUTE5
5219: (p_operation => l_operation
5220: ,p_record => l_rowtype_rec

Line 5232: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute6,p_old_line_rec.attribute6) THEN

5228:
5229: END IF;
5230:
5231: IF p_line_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;
5232: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute6,p_old_line_rec.attribute6) THEN
5233:
5234: l_result := ATTRIBUTE6
5235: (p_operation => l_operation
5236: ,p_record => l_rowtype_rec

Line 5248: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute7,p_old_line_rec.attribute7) THEN

5244:
5245: END IF;
5246:
5247: IF p_line_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;
5248: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute7,p_old_line_rec.attribute7) THEN
5249:
5250: l_result := ATTRIBUTE7
5251: (p_operation => l_operation
5252: ,p_record => l_rowtype_rec

Line 5264: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute8,p_old_line_rec.attribute8) THEN

5260:
5261: END IF;
5262:
5263: IF p_line_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;
5264: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute8,p_old_line_rec.attribute8) THEN
5265:
5266: l_result := ATTRIBUTE8
5267: (p_operation => l_operation
5268: ,p_record => l_rowtype_rec

Line 5280: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute9,p_old_line_rec.attribute9) THEN

5276:
5277: END IF;
5278:
5279: IF p_line_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;
5280: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute9,p_old_line_rec.attribute9) THEN
5281:
5282: l_result := ATTRIBUTE9
5283: (p_operation => l_operation
5284: ,p_record => l_rowtype_rec

Line 5296: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.user_item_description, p_old_line_rec.user_item_description) THEN

5292:
5293: END IF;
5294:
5295: IF p_line_rec.user_item_description = FND_API.G_MISS_CHAR THEN NULL;
5296: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.user_item_description, p_old_line_rec.user_item_description) THEN
5297:
5298: l_result := USER_ITEM_DESCRIPTION
5299: (p_operation => l_operation
5300: ,p_record => l_rowtype_rec

Line 5313: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.contingency_id,p_old_line_rec.contingency_id) THEN

5309: END IF;
5310:
5311: /* Customer Acceptance - Start */
5312: IF p_line_rec.contingency_id = FND_API.G_MISS_NUM THEN NULL;
5313: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.contingency_id,p_old_line_rec.contingency_id) THEN
5314:
5315: l_result := CONTINGENCY
5316: (p_operation => l_operation
5317: ,p_record => l_rowtype_rec

Line 5329: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.revrec_expiration_days,p_old_line_rec.revrec_expiration_days) THEN

5325:
5326: END IF;
5327:
5328: IF p_line_rec.revrec_expiration_days = FND_API.G_MISS_NUM THEN NULL;
5329: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.revrec_expiration_days,p_old_line_rec.revrec_expiration_days) THEN
5330:
5331: l_result := REVREC_EXPIRATION_DAYS
5332: (p_operation => l_operation
5333: ,p_record => l_rowtype_rec