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 150: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

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

Line 152: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

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

Line 154: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,

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

Line 171: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

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

Line 173: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

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

Line 175: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_LN,

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

Line 219: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

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

Line 221: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

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

Line 223: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,

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

Line 240: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

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

Line 242: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

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

Line 244: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_LN,

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

Line 268: not OE_GLOBALS.G_HEADER_CREATED

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 328: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

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

Line 330: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

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

Line 332: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,

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

Line 349: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

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

Line 351: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

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

Line 353: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_LN,

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

Line 379: not OE_GLOBALS.G_HEADER_CREATED THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3310: IF l_debug_level > 0 THEN
3311: oe_debug_pub.add('hash before create operation');
3312: END IF;
3313:
3314: IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3315:
3316: IF l_debug_level > 0 THEN
3317: oe_debug_pub.add('hash in create operation');
3318: END IF;

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

3352: END IF;
3353: l_operation := OE_PC_GLOBALS.CREATE_OP;
3354: END IF; -- end if service
3355:
3356: --IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3357: -- l_operation := OE_PC_GLOBALS.CREATE_OP;
3358: /* end of bug 2922204 */
3359:
3360:

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

3357: -- l_operation := OE_PC_GLOBALS.CREATE_OP;
3358: /* end of bug 2922204 */
3359:
3360:
3361: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3362: l_operation := OE_PC_GLOBALS.UPDATE_OP;
3363: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
3364: l_operation := OE_PC_GLOBALS.DELETE_OP;
3365: ELSE

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

3359:
3360:
3361: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3362: l_operation := OE_PC_GLOBALS.UPDATE_OP;
3363: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
3364: l_operation := OE_PC_GLOBALS.DELETE_OP;
3365: ELSE
3366: IF l_debug_level > 0 THEN
3367: oe_debug_pub.add('Invalid operation',1);

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

3444: -- Initializing out result to NOT CONSTRAINED
3445: x_result := OE_PC_GLOBALS.NO;
3446:
3447: -- Get the operation code to be passed to the security framework API
3448: IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3449:
3450: -- Bug 2639336 : if the order source is Copy then skip the Attribute
3451: -- level check
3452: -- Bug 3859436 : if the line is being split, skip attribute check.

Line 3453: IF p_LINE_rec.source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_COPY

3449:
3450: -- Bug 2639336 : if the order source is Copy then skip the Attribute
3451: -- level check
3452: -- Bug 3859436 : if the line is being split, skip attribute check.
3453: IF p_LINE_rec.source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_COPY
3454: OR p_line_rec.split_from_line_id <> FND_API.G_MISS_NUM
3455: THEN
3456: RETURN;
3457: ELSE

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

3470: THEN
3471: RETURN;
3472: END IF;
3473:
3474: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3475: l_operation := OE_PC_GLOBALS.UPDATE_OP;
3476: ELSE
3477: IF l_debug_level > 0 THEN
3478: oe_debug_pub.add('Invalid operation',1);

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

3490: -- Compare the new and old entity records and
3491: -- check constraints for all the changed attributes.
3492:
3493: IF p_line_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN NULL;
3494: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.accounting_rule_id,p_old_line_rec.accounting_rule_id) THEN
3495:
3496: l_result := ACCOUNTING_RULE
3497: (p_operation => l_operation
3498: ,p_record => l_rowtype_rec

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

3506:
3507: END IF;
3508:
3509: IF p_line_rec.IB_OWNER = FND_API.G_MISS_CHAR THEN NULL;
3510: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.IB_OWNER,p_old_line_rec.IB_OWNER) THEN
3511:
3512: l_result := IB_OWNER
3513: (p_operation => l_operation
3514: ,p_record => l_rowtype_rec

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

3521: END IF;
3522:
3523: END IF;
3524: IF p_line_rec.IB_CURRENT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;
3525: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.IB_CURRENT_LOCATION,p_old_line_rec.IB_CURRENT_LOCATION) THEN
3526:
3527: l_result := IB_CURRENT_LOCATION
3528: (p_operation => l_operation
3529: ,p_record => l_rowtype_rec

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

3536: END IF;
3537:
3538: END IF;
3539: IF p_line_rec.IB_INSTALLED_AT_LOCATION = FND_API.G_MISS_CHAR THEN NULL;
3540: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.IB_INSTALLED_AT_LOCATION,p_old_line_rec.IB_INSTALLED_AT_LOCATION) THEN
3541:
3542: l_result := IB_INSTALLED_AT_LOCATION
3543: (p_operation => l_operation
3544: ,p_record => l_rowtype_rec

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

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

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

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

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

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

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

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

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

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

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

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

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

3645:
3646: END IF;
3647:
3648: IF p_line_rec.arrival_set_id = FND_API.G_MISS_NUM THEN NULL;
3649: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.arrival_set_id,p_old_line_rec.arrival_set_id)
3650: OR NOT OE_GLOBALS.EQUAL(p_line_rec.arrival_set,p_old_line_rec.arrival_set) THEN
3651:
3652: l_result := ARRIVAL_SET
3653: (p_operation => l_operation

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

3646: END IF;
3647:
3648: IF p_line_rec.arrival_set_id = FND_API.G_MISS_NUM THEN NULL;
3649: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.arrival_set_id,p_old_line_rec.arrival_set_id)
3650: OR NOT OE_GLOBALS.EQUAL(p_line_rec.arrival_set,p_old_line_rec.arrival_set) THEN
3651:
3652: l_result := ARRIVAL_SET
3653: (p_operation => l_operation
3654: ,p_record => l_rowtype_rec

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

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

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

3678:
3679: END IF;
3680:
3681: IF p_line_rec.credit_invoice_line_id = FND_API.G_MISS_NUM THEN NULL;
3682: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.credit_invoice_line_id,p_old_line_rec.credit_invoice_line_id) THEN
3683:
3684: l_result := CREDIT_INVOICE_LINE
3685: (p_operation => l_operation
3686: ,p_record => l_rowtype_rec

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

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

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

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

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

3726:
3727: END IF;
3728:
3729: IF p_line_rec.cust_po_number = FND_API.G_MISS_CHAR THEN NULL;
3730: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.cust_po_number,p_old_line_rec.cust_po_number) THEN
3731:
3732: l_result := CUST_PO_NUMBER
3733: (p_operation => l_operation
3734: ,p_record => l_rowtype_rec

Line 3747: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.customer_job,p_old_line_rec.customer_job) THEN

3743: END IF;
3744:
3745: -- Added for bug #7608170
3746: IF p_line_rec.customer_job = FND_API.G_MISS_CHAR THEN NULL;
3747: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.customer_job,p_old_line_rec.customer_job) THEN
3748:
3749: l_result := CUSTOMER_JOB
3750: (p_operation => l_operation
3751: ,p_record => l_rowtype_rec

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

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

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

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

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

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

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

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

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

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

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

3839:
3840: END IF;
3841:
3842: IF p_line_rec.earliest_acceptable_date = FND_API.G_MISS_DATE THEN NULL;
3843: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.earliest_acceptable_date,p_old_line_rec.earliest_acceptable_date) THEN
3844:
3845: l_result := EARLIEST_ACCEPTABLE_DATE
3846: (p_operation => l_operation
3847: ,p_record => l_rowtype_rec

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

3855:
3856: END IF;
3857:
3858: IF p_line_rec.end_item_unit_number = FND_API.G_MISS_CHAR THEN NULL;
3859: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.end_item_unit_number,p_old_line_rec.end_item_unit_number) THEN
3860:
3861: l_result := END_ITEM_UNIT_NUMBER
3862: (p_operation => l_operation
3863: ,p_record => l_rowtype_rec

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

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

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

3887:
3888: END IF;
3889:
3890: IF p_line_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN NULL;
3891: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.freight_terms_code,p_old_line_rec.freight_terms_code) THEN
3892:
3893: l_result := FREIGHT_TERMS
3894: (p_operation => l_operation
3895: ,p_record => l_rowtype_rec

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

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

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

3920: END IF;
3921:
3922: -- INVCONV
3923: IF p_line_rec.fulfilled_quantity2 = FND_API.G_MISS_NUM THEN NULL;
3924: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.fulfilled_quantity2,p_old_line_rec.fulfilled_quantity2) THEN
3925:
3926: l_result := FULFILLED_QUANTITY2
3927: (p_operation => l_operation
3928: ,p_record => l_rowtype_rec

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

3936:
3937: END IF;
3938:
3939: IF p_line_rec.inventory_item_id = FND_API.G_MISS_NUM THEN NULL;
3940: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id) THEN
3941:
3942: l_result := INVENTORY_ITEM
3943: (p_operation => l_operation
3944: ,p_record => l_rowtype_rec

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

3952:
3953: END IF;
3954:
3955: IF p_line_rec.invoice_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
3956: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_contact_id,p_old_line_rec.invoice_to_contact_id) THEN
3957:
3958: l_result := INVOICE_TO_CONTACT
3959: (p_operation => l_operation
3960: ,p_record => l_rowtype_rec

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

4129: END IF;
4130:
4131: -- OPM 1857167 start
4132: IF p_line_rec.ordered_quantity2 = FND_API.G_MISS_NUM THEN NULL;
4133: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ordered_quantity2,p_old_line_rec.ordered_quantity2) THEN
4134:
4135: l_result := ORDERED_QUANTITY2
4136: (p_operation => l_operation
4137: ,p_record => l_rowtype_rec

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

4148:
4149:
4150:
4151: IF p_line_rec.order_quantity_uom = FND_API.G_MISS_CHAR THEN NULL;
4152: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom) THEN
4153:
4154: l_result := ORDER_QUANTITY_UOM
4155: (p_operation => l_operation
4156: ,p_record => l_rowtype_rec

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

4164:
4165: END IF;
4166:
4167: IF p_line_rec.over_ship_reason_code = FND_API.G_MISS_CHAR THEN NULL;
4168: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.over_ship_reason_code,p_old_line_rec.over_ship_reason_code) THEN
4169:
4170: l_result := OVER_SHIP_REASON
4171: (p_operation => l_operation
4172: ,p_record => l_rowtype_rec

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

4180:
4181: END IF;
4182:
4183: IF p_line_rec.over_ship_resolved_flag = FND_API.G_MISS_CHAR THEN NULL;
4184: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.over_ship_resolved_flag,p_old_line_rec.over_ship_resolved_flag) THEN
4185:
4186: l_result := OVER_SHIP_RESOLVED
4187: (p_operation => l_operation
4188: ,p_record => l_rowtype_rec

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

4196:
4197: END IF;
4198:
4199: IF p_line_rec.packing_instructions = FND_API.G_MISS_CHAR THEN NULL;
4200: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.packing_instructions,p_old_line_rec.packing_instructions) THEN
4201:
4202: l_result := PACKING_INSTRUCTIONS
4203: (p_operation => l_operation
4204: ,p_record => l_rowtype_rec

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

4212:
4213: END IF;
4214:
4215: IF p_line_rec.payment_term_id = FND_API.G_MISS_NUM THEN NULL;
4216: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.payment_term_id,p_old_line_rec.payment_term_id) THEN
4217:
4218: l_result := PAYMENT_TERM
4219: (p_operation => l_operation
4220: ,p_record => l_rowtype_rec

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

4228:
4229: END IF;
4230:
4231: IF p_line_rec.planning_priority = FND_API.G_MISS_NUM THEN NULL;
4232: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.planning_priority,p_old_line_rec.planning_priority) THEN
4233:
4234: l_result := PLANNING_PRIORITY
4235: (p_operation => l_operation
4236: ,p_record => l_rowtype_rec

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

4244:
4245: END IF;
4246:
4247: IF p_line_rec.price_list_id = FND_API.G_MISS_NUM THEN NULL;
4248: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.price_list_id,p_old_line_rec.price_list_id) THEN
4249:
4250: l_result := PRICE_LIST
4251: (p_operation => l_operation
4252: ,p_record => l_rowtype_rec

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

4260:
4261: END IF;
4262:
4263: IF p_line_rec.pricing_date = FND_API.G_MISS_DATE THEN NULL;
4264: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.pricing_date,p_old_line_rec.pricing_date) THEN
4265:
4266: l_result := PRICING_DATE
4267: (p_operation => l_operation
4268: ,p_record => l_rowtype_rec

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

4276:
4277: END IF;
4278:
4279: IF p_line_rec.pricing_quantity = FND_API.G_MISS_NUM THEN NULL;
4280: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.pricing_quantity,p_old_line_rec.pricing_quantity) THEN
4281:
4282: l_result := PRICING_QUANTITY
4283: (p_operation => l_operation
4284: ,p_record => l_rowtype_rec

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

4471: /* Fix to bug 2205900: Added constraints functions for
4472: some missing SERVICE fields */
4473:
4474: IF p_line_rec.service_coterminate_flag = FND_API.G_MISS_CHAR THEN NULL;
4475: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_coterminate_flag,p_old_line_rec.service_coterminate_flag) THEN
4476:
4477: l_result := SERVICE_COTERMINATE
4478: (p_operation => l_operation
4479: ,p_record => l_rowtype_rec

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

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

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

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

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

4519:
4520: END IF;
4521:
4522: IF p_line_rec.service_period = FND_API.G_MISS_CHAR THEN NULL;
4523: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_period,p_old_line_rec.service_period) THEN
4524:
4525: l_result := SERVICE_PERIOD
4526: (p_operation => l_operation
4527: ,p_record => l_rowtype_rec

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

4535:
4536: END IF;
4537:
4538: IF p_line_rec.service_start_date = FND_API.G_MISS_DATE THEN NULL;
4539: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_start_date,p_old_line_rec.service_start_date) THEN
4540:
4541: l_result := SERVICE_START_DATE
4542: (p_operation => l_operation
4543: ,p_record => l_rowtype_rec

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

4551:
4552: END IF;
4553:
4554: IF p_line_rec.service_txn_comments = FND_API.G_MISS_CHAR THEN NULL;
4555: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_txn_comments,p_old_line_rec.service_txn_comments) THEN
4556:
4557: l_result := SERVICE_TXN_COMMENTS
4558: (p_operation => l_operation
4559: ,p_record => l_rowtype_rec

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

4567:
4568: END IF;
4569:
4570: IF p_line_rec.service_txn_reason_code = FND_API.G_MISS_CHAR THEN NULL;
4571: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_txn_reason_code,p_old_line_rec.service_txn_reason_code) THEN
4572:
4573: l_result := SERVICE_TXN_REASON
4574: (p_operation => l_operation
4575: ,p_record => l_rowtype_rec

Line 4589: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_bill_profile_id,p_old_line_rec.service_bill_profile_id) THEN

4585:
4586: --sol_ord_er #16014165 start
4587: IF p_line_rec.service_bill_profile_id = FND_API.G_MISS_NUM THEN
4588: NULL;
4589: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_bill_profile_id,p_old_line_rec.service_bill_profile_id) THEN
4590: l_result := SERVICE_BILLING_PROFILE
4591: (p_operation => l_operation
4592: ,p_record => l_rowtype_rec
4593: ,x_on_operation_action => l_on_operation_action

Line 4603: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_bill_option_code,p_old_line_rec.service_bill_option_code) THEN

4599: END IF;
4600:
4601: IF p_line_rec.service_bill_option_code = FND_API.G_MISS_CHAR THEN
4602: NULL;
4603: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_bill_option_code,p_old_line_rec.service_bill_option_code) THEN
4604: l_result := SERVICE_BILLING_OPTION
4605: (p_operation => l_operation
4606: ,p_record => l_rowtype_rec
4607: ,x_on_operation_action => l_on_operation_action

Line 4617: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_cov_template_id,p_old_line_rec.service_cov_template_id) THEN

4613: END IF;
4614:
4615: IF p_line_rec.service_cov_template_id = FND_API.G_MISS_NUM THEN
4616: NULL;
4617: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_cov_template_id,p_old_line_rec.service_cov_template_id) THEN
4618: l_result := SERVICE_COVERAGE_TEMPLATE
4619: (p_operation => l_operation
4620: ,p_record => l_rowtype_rec
4621: ,x_on_operation_action => l_on_operation_action

Line 4631: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_subs_template_id,p_old_line_rec.service_subs_template_id) THEN

4627: END IF;
4628:
4629: IF p_line_rec.service_subs_template_id = FND_API.G_MISS_NUM THEN
4630: NULL;
4631: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.service_subs_template_id,p_old_line_rec.service_subs_template_id) THEN
4632: l_result := SERVICE_SUBSCRIPTION_TEMPLATE
4633: (p_operation => l_operation
4634: ,p_record => l_rowtype_rec
4635: ,x_on_operation_action => l_on_operation_action

Line 4645: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.SUBSCRIPTION_ENABLE_FLAG,p_old_line_rec.SUBSCRIPTION_ENABLE_FLAG) THEN

4641: END IF;
4642:
4643: IF p_line_rec.SUBSCRIPTION_ENABLE_FLAG = FND_API.G_MISS_CHAR THEN
4644: NULL;
4645: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.SUBSCRIPTION_ENABLE_FLAG,p_old_line_rec.SUBSCRIPTION_ENABLE_FLAG) THEN
4646: l_result := SUBSCRIPTION_ENABLE_FLAG
4647: (p_operation => l_operation
4648: ,p_record => l_rowtype_rec
4649: ,x_on_operation_action => l_on_operation_action

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

4655: END IF;
4656: --sol_ord_er #16014165 end
4657:
4658: IF p_line_rec.shipment_number = FND_API.G_MISS_NUM THEN NULL;
4659: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipment_number,p_old_line_rec.shipment_number) THEN
4660:
4661: l_result := SHIPMENT_NUMBER
4662: (p_operation => l_operation
4663: ,p_record => l_rowtype_rec

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

4671:
4672: END IF;
4673:
4674: IF p_line_rec.shipment_priority_code = FND_API.G_MISS_CHAR THEN NULL;
4675: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipment_priority_code,p_old_line_rec.shipment_priority_code) THEN
4676:
4677: l_result := SHIPMENT_PRIORITY
4678: (p_operation => l_operation
4679: ,p_record => l_rowtype_rec

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

4687:
4688: END IF;
4689:
4690: IF p_line_rec.shipped_quantity = FND_API.G_MISS_NUM THEN NULL;
4691: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipped_quantity,p_old_line_rec.shipped_quantity) THEN
4692:
4693: l_result := SHIPPED_QUANTITY
4694: (p_operation => l_operation
4695: ,p_record => l_rowtype_rec

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

4704: END IF;
4705:
4706: -- INVCONV
4707: IF p_line_rec.shipped_quantity2 = FND_API.G_MISS_NUM THEN NULL;
4708: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipped_quantity2,p_old_line_rec.shipped_quantity2) THEN
4709:
4710: l_result := SHIPPED_QUANTITY2
4711: (p_operation => l_operation
4712: ,p_record => l_rowtype_rec

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

4721: END IF;
4722:
4723:
4724: IF p_line_rec.shipping_instructions = FND_API.G_MISS_CHAR THEN NULL;
4725: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_instructions,p_old_line_rec.shipping_instructions) THEN
4726:
4727: l_result := SHIPPING_INSTRUCTIONS
4728: (p_operation => l_operation
4729: ,p_record => l_rowtype_rec

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

4737:
4738: END IF;
4739:
4740: IF p_line_rec.shipping_method_code = FND_API.G_MISS_CHAR THEN NULL;
4741: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_method_code,p_old_line_rec.shipping_method_code) THEN
4742:
4743: l_result := SHIPPING_METHOD
4744: (p_operation => l_operation
4745: ,p_record => l_rowtype_rec

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

4753:
4754: END IF;
4755:
4756: IF p_line_rec.shipping_quantity = FND_API.G_MISS_NUM THEN NULL;
4757: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_quantity,p_old_line_rec.shipping_quantity) THEN
4758:
4759: l_result := SHIPPING_QUANTITY
4760: (p_operation => l_operation
4761: ,p_record => l_rowtype_rec

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

4770: END IF;
4771:
4772: -- INVCONV
4773: IF p_line_rec.shipping_quantity2 = FND_API.G_MISS_NUM THEN NULL;
4774: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_quantity2,p_old_line_rec.shipping_quantity2) THEN
4775:
4776: l_result := SHIPPING_QUANTITY2
4777: (p_operation => l_operation
4778: ,p_record => l_rowtype_rec

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

4788:
4789:
4790:
4791: IF p_line_rec.shipping_quantity_uom = FND_API.G_MISS_CHAR THEN NULL;
4792: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_quantity_uom,p_old_line_rec.shipping_quantity_uom) THEN
4793:
4794: l_result := SHIPPING_QUANTITY_UOM
4795: (p_operation => l_operation
4796: ,p_record => l_rowtype_rec

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

4805: END IF;
4806:
4807: -- INVCONV
4808: IF p_line_rec.shipping_quantity_uom2 = FND_API.G_MISS_CHAR THEN NULL;
4809: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_quantity_uom2,p_old_line_rec.shipping_quantity_uom2) THEN
4810:
4811: l_result := SHIPPING_QUANTITY_UOM2
4812: (p_operation => l_operation
4813: ,p_record => l_rowtype_rec

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

4822: END IF;
4823:
4824:
4825: IF p_line_rec.ship_from_org_id = FND_API.G_MISS_NUM THEN NULL;
4826: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_from_org_id,p_old_line_rec.ship_from_org_id) THEN
4827:
4828: l_result := SHIP_FROM_ORG
4829: (p_operation => l_operation
4830: ,p_record => l_rowtype_rec

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

4838:
4839: END IF;
4840:
4841: IF p_line_rec.ship_model_complete_flag = FND_API.G_MISS_CHAR THEN NULL;
4842: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_model_complete_flag,p_old_line_rec.ship_model_complete_flag) THEN
4843:
4844: l_result := SHIP_MODEL_COMPLETE
4845: (p_operation => l_operation
4846: ,p_record => l_rowtype_rec

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

4854:
4855: END IF;
4856:
4857: IF p_line_rec.ship_set_id = FND_API.G_MISS_NUM THEN NULL;
4858: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_set_id,p_old_line_rec.ship_set_id)
4859: OR NOT OE_GLOBALS.EQUAL(p_line_rec.ship_set,p_old_line_rec.ship_set) THEN
4860:
4861: l_result := SHIP_SET
4862: (p_operation => l_operation

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

4855: END IF;
4856:
4857: IF p_line_rec.ship_set_id = FND_API.G_MISS_NUM THEN NULL;
4858: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_set_id,p_old_line_rec.ship_set_id)
4859: OR NOT OE_GLOBALS.EQUAL(p_line_rec.ship_set,p_old_line_rec.ship_set) THEN
4860:
4861: l_result := SHIP_SET
4862: (p_operation => l_operation
4863: ,p_record => l_rowtype_rec

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

4871:
4872: END IF;
4873:
4874: IF p_line_rec.ship_tolerance_above = FND_API.G_MISS_NUM THEN NULL;
4875: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_tolerance_above,p_old_line_rec.ship_tolerance_above) THEN
4876:
4877: l_result := SHIP_TOLERANCE_ABOVE
4878: (p_operation => l_operation
4879: ,p_record => l_rowtype_rec

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

4887:
4888: END IF;
4889:
4890: IF p_line_rec.ship_tolerance_below = FND_API.G_MISS_NUM THEN NULL;
4891: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_tolerance_below,p_old_line_rec.ship_tolerance_below) THEN
4892:
4893: l_result := SHIP_TOLERANCE_BELOW
4894: (p_operation => l_operation
4895: ,p_record => l_rowtype_rec

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

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

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

4919:
4920: END IF;
4921:
4922: IF p_line_rec.ship_to_org_id = FND_API.G_MISS_NUM THEN NULL;
4923: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id) THEN
4924:
4925: l_result := SHIP_TO_ORG
4926: (p_operation => l_operation
4927: ,p_record => l_rowtype_rec

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

4935:
4936: END IF;
4937:
4938: IF p_line_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN NULL;
4939: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id) THEN
4940:
4941: l_result := SOLD_TO_ORG
4942: (p_operation => l_operation
4943: ,p_record => l_rowtype_rec

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

5079:
5080: END IF;
5081:
5082: IF p_line_rec.unit_list_price = FND_API.G_MISS_NUM THEN NULL;
5083: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.unit_list_price,p_old_line_rec.unit_list_price) THEN
5084:
5085: l_result := UNIT_LIST_PRICE
5086: (p_operation => l_operation
5087: ,p_record => l_rowtype_rec

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

5095:
5096: END IF;
5097:
5098: IF p_line_rec.unit_selling_price = FND_API.G_MISS_NUM THEN NULL;
5099: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.unit_selling_price,p_old_line_rec.unit_selling_price) THEN
5100:
5101: l_result := UNIT_SELLING_PRICE
5102: (p_operation => l_operation
5103: ,p_record => l_rowtype_rec

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

5112: END IF;
5113:
5114: -- BEGIN: Blankets Code Merge
5115: IF p_line_rec.blanket_number = FND_API.G_MISS_NUM THEN NULL;
5116: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.blanket_number,p_old_line_rec.blanket_number) THEN
5117:
5118: l_result := BLANKET_NUMBER
5119: (p_operation => l_operation
5120: ,p_record => l_rowtype_rec

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

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

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

5146: -- END: Blankets Code Merge
5147:
5148: IF ((nvl(p_line_rec.calculate_price_flag,'N')='Y') AND
5149: (p_line_rec.price_list_id IS NOT NULL) AND
5150: (NOT OE_GLOBALS.Equal(p_line_rec.price_list_id,
5151: p_old_line_rec.price_list_id)) ) THEN
5152: BEGIN
5153: SELECT active_flag
5154: INTO l_active_flag

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

5169: END IF;
5170:
5171: IF p_line_rec.calculate_price_flag = FND_API.G_MISS_CHAR THEN
5172: NULL;
5173: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.calculate_price_flag
5174: ,p_old_line_rec.calculate_price_flag) THEN
5175:
5176: l_result := calculate_price_flag(p_operation => l_operation
5177: ,p_record => l_rowtype_rec

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

5184: END IF;
5185:
5186: IF p_line_rec.customer_shipment_number = FND_API.G_MISS_CHAR THEN
5187: NULL;
5188: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.customer_shipment_number,p_old_line_rec.customer_shipment_number) THEN
5189:
5190: l_result := CUSTOMER_SHIPMENT_NUMBER
5191: (p_operation => l_operation
5192: ,p_record => l_rowtype_rec

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

5218: g_check_all_cols_constraint := 'N';
5219: END IF;
5220:
5221: IF p_line_rec.context = FND_API.G_MISS_CHAR THEN NULL;
5222: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.context,p_old_line_rec.context) THEN
5223:
5224: l_result := CONTEXT
5225: (p_operation => l_operation
5226: ,p_record => l_rowtype_rec

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

5234:
5235: END IF;
5236:
5237: IF p_line_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;
5238: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute1,p_old_line_rec.attribute1) THEN
5239:
5240: l_result := ATTRIBUTE1
5241: (p_operation => l_operation
5242: ,p_record => l_rowtype_rec

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

5250:
5251: END IF;
5252:
5253: IF p_line_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;
5254: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute10,p_old_line_rec.attribute10) THEN
5255:
5256: l_result := ATTRIBUTE10
5257: (p_operation => l_operation
5258: ,p_record => l_rowtype_rec

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

5266:
5267: END IF;
5268:
5269: IF p_line_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;
5270: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute11,p_old_line_rec.attribute11) THEN
5271:
5272: l_result := ATTRIBUTE11
5273: (p_operation => l_operation
5274: ,p_record => l_rowtype_rec

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

5282:
5283: END IF;
5284:
5285: IF p_line_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;
5286: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute12,p_old_line_rec.attribute12) THEN
5287:
5288: l_result := ATTRIBUTE12
5289: (p_operation => l_operation
5290: ,p_record => l_rowtype_rec

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

5298:
5299: END IF;
5300:
5301: IF p_line_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;
5302: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute13,p_old_line_rec.attribute13) THEN
5303:
5304: l_result := ATTRIBUTE13
5305: (p_operation => l_operation
5306: ,p_record => l_rowtype_rec

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

5314:
5315: END IF;
5316:
5317: IF p_line_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;
5318: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute14,p_old_line_rec.attribute14) THEN
5319:
5320: l_result := ATTRIBUTE14
5321: (p_operation => l_operation
5322: ,p_record => l_rowtype_rec

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

5330:
5331: END IF;
5332:
5333: IF p_line_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;
5334: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute15,p_old_line_rec.attribute15) THEN
5335:
5336: l_result := ATTRIBUTE15
5337: (p_operation => l_operation
5338: ,p_record => l_rowtype_rec

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

5348:
5349: -- For bug 2184255
5350:
5351: IF p_line_rec.attribute16 = FND_API.G_MISS_CHAR THEN NULL;
5352: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute16,p_old_line_rec.attribute16) THEN
5353:
5354: l_result := ATTRIBUTE16
5355: (p_operation => l_operation
5356: ,p_record => l_rowtype_rec

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

5364:
5365: END IF;
5366:
5367: IF p_line_rec.attribute17 = FND_API.G_MISS_CHAR THEN NULL;
5368: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute17,p_old_line_rec.attribute17) THEN
5369:
5370: l_result := ATTRIBUTE17
5371: (p_operation => l_operation
5372: ,p_record => l_rowtype_rec

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

5380:
5381: END IF;
5382:
5383: IF p_line_rec.attribute18 = FND_API.G_MISS_CHAR THEN NULL;
5384: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute18,p_old_line_rec.attribute18) THEN
5385:
5386: l_result := ATTRIBUTE18
5387: (p_operation => l_operation
5388: ,p_record => l_rowtype_rec

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

5396:
5397: END IF;
5398:
5399: IF p_line_rec.attribute19 = FND_API.G_MISS_CHAR THEN NULL;
5400: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute19,p_old_line_rec.attribute19) THEN
5401:
5402: l_result := ATTRIBUTE19
5403: (p_operation => l_operation
5404: ,p_record => l_rowtype_rec

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

5412:
5413: END IF;
5414:
5415: IF p_line_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;
5416: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute2,p_old_line_rec.attribute2) THEN
5417:
5418: l_result := ATTRIBUTE2
5419: (p_operation => l_operation
5420: ,p_record => l_rowtype_rec

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

5429: END IF;
5430:
5431:
5432: IF p_line_rec.attribute20 = FND_API.G_MISS_CHAR THEN NULL;
5433: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute20,p_old_line_rec.attribute20) THEN
5434:
5435: l_result := ATTRIBUTE20
5436: (p_operation => l_operation
5437: ,p_record => l_rowtype_rec

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

5447:
5448: -- End bug 2184255
5449:
5450: IF p_line_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;
5451: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute3,p_old_line_rec.attribute3) THEN
5452:
5453: l_result := ATTRIBUTE3
5454: (p_operation => l_operation
5455: ,p_record => l_rowtype_rec

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

5463:
5464: END IF;
5465:
5466: IF p_line_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;
5467: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute4,p_old_line_rec.attribute4) THEN
5468:
5469: l_result := ATTRIBUTE4
5470: (p_operation => l_operation
5471: ,p_record => l_rowtype_rec

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

5479:
5480: END IF;
5481:
5482: IF p_line_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;
5483: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute5,p_old_line_rec.attribute5) THEN
5484:
5485: l_result := ATTRIBUTE5
5486: (p_operation => l_operation
5487: ,p_record => l_rowtype_rec

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

5495:
5496: END IF;
5497:
5498: IF p_line_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;
5499: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute6,p_old_line_rec.attribute6) THEN
5500:
5501: l_result := ATTRIBUTE6
5502: (p_operation => l_operation
5503: ,p_record => l_rowtype_rec

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

5511:
5512: END IF;
5513:
5514: IF p_line_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;
5515: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute7,p_old_line_rec.attribute7) THEN
5516:
5517: l_result := ATTRIBUTE7
5518: (p_operation => l_operation
5519: ,p_record => l_rowtype_rec

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

5527:
5528: END IF;
5529:
5530: IF p_line_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;
5531: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute8,p_old_line_rec.attribute8) THEN
5532:
5533: l_result := ATTRIBUTE8
5534: (p_operation => l_operation
5535: ,p_record => l_rowtype_rec

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

5543:
5544: END IF;
5545:
5546: IF p_line_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;
5547: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.attribute9,p_old_line_rec.attribute9) THEN
5548:
5549: l_result := ATTRIBUTE9
5550: (p_operation => l_operation
5551: ,p_record => l_rowtype_rec

Line 5564: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.return_context,p_old_line_rec.return_context) THEN

5560: END IF;
5561:
5562: ---Start bug 14272033
5563: IF p_line_rec.return_context = FND_API.G_MISS_CHAR THEN NULL;
5564: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.return_context,p_old_line_rec.return_context) THEN
5565:
5566: l_result := return_context
5567: (p_operation => l_operation
5568: ,p_record => l_rowtype_rec

Line 5580: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.return_attribute1,p_old_line_rec.return_attribute1) THEN

5576:
5577: END IF;
5578:
5579: IF p_line_rec.return_attribute1 = FND_API.G_MISS_CHAR THEN NULL;
5580: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.return_attribute1,p_old_line_rec.return_attribute1) THEN
5581:
5582: l_result := return_attribute1
5583: (p_operation => l_operation
5584: ,p_record => l_rowtype_rec

Line 5596: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.return_attribute2,p_old_line_rec.return_attribute2) THEN

5592:
5593: END IF;
5594:
5595: IF p_line_rec.return_attribute2 = FND_API.G_MISS_CHAR THEN NULL;
5596: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.return_attribute2,p_old_line_rec.return_attribute2) THEN
5597:
5598: l_result := return_attribute2
5599: (p_operation => l_operation
5600: ,p_record => l_rowtype_rec

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

5609: END IF;
5610: ---END 14272033
5611:
5612: IF p_line_rec.user_item_description = FND_API.G_MISS_CHAR THEN NULL;
5613: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.user_item_description, p_old_line_rec.user_item_description) THEN
5614:
5615: l_result := USER_ITEM_DESCRIPTION
5616: (p_operation => l_operation
5617: ,p_record => l_rowtype_rec

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

5626: END IF;
5627:
5628: /* Customer Acceptance - Start */
5629: IF p_line_rec.contingency_id = FND_API.G_MISS_NUM THEN NULL;
5630: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.contingency_id,p_old_line_rec.contingency_id) THEN
5631:
5632: l_result := CONTINGENCY
5633: (p_operation => l_operation
5634: ,p_record => l_rowtype_rec

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

5642:
5643: END IF;
5644:
5645: IF p_line_rec.revrec_expiration_days = FND_API.G_MISS_NUM THEN NULL;
5646: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.revrec_expiration_days,p_old_line_rec.revrec_expiration_days) THEN
5647:
5648: l_result := REVREC_EXPIRATION_DAYS
5649: (p_operation => l_operation
5650: ,p_record => l_rowtype_rec