eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_LINE_SCREDIT_UTIL dependencies on OE_GLOBALS

Line 152: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;

148: G_MISS_OE_AK_LINE_SCREDIT_REC
149: )
150: IS
151: l_index NUMBER :=0;
152: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
153: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
154: --
155: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
156: --

Line 153: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;

149: )
150: IS
151: l_index NUMBER :=0;
152: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
153: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
154: --
155: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
156: --
157: BEGIN

Line 168: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute1,p_old_Line_Scredit_rec.attribute1)

164: -- every changed attribute clear its dependent fields.
165:
166: IF p_attr_id = FND_API.G_MISS_NUM THEN
167:
168: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute1,p_old_Line_Scredit_rec.attribute1)
169: THEN
170: l_index := l_index + 1;
171: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE1;
172: END IF;

Line 174: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute10,p_old_Line_Scredit_rec.attribute10)

170: l_index := l_index + 1;
171: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE1;
172: END IF;
173:
174: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute10,p_old_Line_Scredit_rec.attribute10)
175: THEN
176: l_index := l_index + 1;
177: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE10;
178: END IF;

Line 180: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute11,p_old_Line_Scredit_rec.attribute11)

176: l_index := l_index + 1;
177: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE10;
178: END IF;
179:
180: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute11,p_old_Line_Scredit_rec.attribute11)
181: THEN
182: l_index := l_index + 1;
183: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE11;
184: END IF;

Line 186: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute12,p_old_Line_Scredit_rec.attribute12)

182: l_index := l_index + 1;
183: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE11;
184: END IF;
185:
186: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute12,p_old_Line_Scredit_rec.attribute12)
187: THEN
188: l_index := l_index + 1;
189: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE12;
190: END IF;

Line 192: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute13,p_old_Line_Scredit_rec.attribute13)

188: l_index := l_index + 1;
189: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE12;
190: END IF;
191:
192: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute13,p_old_Line_Scredit_rec.attribute13)
193: THEN
194: l_index := l_index + 1;
195: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE13;
196: END IF;

Line 198: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute14,p_old_Line_Scredit_rec.attribute14)

194: l_index := l_index + 1;
195: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE13;
196: END IF;
197:
198: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute14,p_old_Line_Scredit_rec.attribute14)
199: THEN
200: l_index := l_index + 1;
201: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE14;
202: END IF;

Line 204: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute15,p_old_Line_Scredit_rec.attribute15)

200: l_index := l_index + 1;
201: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE14;
202: END IF;
203:
204: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute15,p_old_Line_Scredit_rec.attribute15)
205: THEN
206: l_index := l_index + 1;
207: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE15;
208: END IF;

Line 210: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute2,p_old_Line_Scredit_rec.attribute2)

206: l_index := l_index + 1;
207: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE15;
208: END IF;
209:
210: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute2,p_old_Line_Scredit_rec.attribute2)
211: THEN
212: l_index := l_index + 1;
213: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE2;
214: END IF;

Line 216: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute3,p_old_Line_Scredit_rec.attribute3)

212: l_index := l_index + 1;
213: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE2;
214: END IF;
215:
216: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute3,p_old_Line_Scredit_rec.attribute3)
217: THEN
218: l_index := l_index + 1;
219: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE3;
220: END IF;

Line 222: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute4,p_old_Line_Scredit_rec.attribute4)

218: l_index := l_index + 1;
219: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE3;
220: END IF;
221:
222: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute4,p_old_Line_Scredit_rec.attribute4)
223: THEN
224: l_index := l_index + 1;
225: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE4;
226: END IF;

Line 228: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute5,p_old_Line_Scredit_rec.attribute5)

224: l_index := l_index + 1;
225: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE4;
226: END IF;
227:
228: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute5,p_old_Line_Scredit_rec.attribute5)
229: THEN
230: l_index := l_index + 1;
231: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE5;
232: END IF;

Line 234: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute6,p_old_Line_Scredit_rec.attribute6)

230: l_index := l_index + 1;
231: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE5;
232: END IF;
233:
234: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute6,p_old_Line_Scredit_rec.attribute6)
235: THEN
236: l_index := l_index + 1;
237: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE6;
238: END IF;

Line 240: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute7,p_old_Line_Scredit_rec.attribute7)

236: l_index := l_index + 1;
237: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE6;
238: END IF;
239:
240: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute7,p_old_Line_Scredit_rec.attribute7)
241: THEN
242: l_index := l_index + 1;
243: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE7;
244: END IF;

Line 246: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute8,p_old_Line_Scredit_rec.attribute8)

242: l_index := l_index + 1;
243: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE7;
244: END IF;
245:
246: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute8,p_old_Line_Scredit_rec.attribute8)
247: THEN
248: l_index := l_index + 1;
249: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE8;
250: END IF;

Line 252: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute9,p_old_Line_Scredit_rec.attribute9)

248: l_index := l_index + 1;
249: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE8;
250: END IF;
251:
252: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute9,p_old_Line_Scredit_rec.attribute9)
253: THEN
254: l_index := l_index + 1;
255: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE9;
256: END IF;

Line 258: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.context,p_old_Line_Scredit_rec.context)

254: l_index := l_index + 1;
255: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE9;
256: END IF;
257:
258: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.context,p_old_Line_Scredit_rec.context)
259: THEN
260: l_index := l_index + 1;
261: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_CONTEXT;
262: END IF;

Line 264: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.created_by,p_old_Line_Scredit_rec.created_by)

260: l_index := l_index + 1;
261: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_CONTEXT;
262: END IF;
263:
264: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.created_by,p_old_Line_Scredit_rec.created_by)
265: THEN
266: l_index := l_index + 1;
267: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_CREATED_BY;
268: END IF;

Line 270: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.creation_date,p_old_Line_Scredit_rec.creation_date)

266: l_index := l_index + 1;
267: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_CREATED_BY;
268: END IF;
269:
270: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.creation_date,p_old_Line_Scredit_rec.creation_date)
271: THEN
272: l_index := l_index + 1;
273: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_CREATION_DATE;
274: END IF;

Line 276: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.dw_update_advice_flag,p_old_Line_Scredit_rec.dw_update_advice_flag)

272: l_index := l_index + 1;
273: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_CREATION_DATE;
274: END IF;
275:
276: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.dw_update_advice_flag,p_old_Line_Scredit_rec.dw_update_advice_flag)
277: THEN
278: l_index := l_index + 1;
279: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_DW_UPDATE_ADVICE;
280: END IF;

Line 282: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.header_id,p_old_Line_Scredit_rec.header_id)

278: l_index := l_index + 1;
279: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_DW_UPDATE_ADVICE;
280: END IF;
281:
282: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.header_id,p_old_Line_Scredit_rec.header_id)
283: THEN
284: l_index := l_index + 1;
285: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_HEADER;
286: END IF;

Line 288: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_updated_by,p_old_Line_Scredit_rec.last_updated_by)

284: l_index := l_index + 1;
285: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_HEADER;
286: END IF;
287:
288: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_updated_by,p_old_Line_Scredit_rec.last_updated_by)
289: THEN
290: l_index := l_index + 1;
291: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATED_BY;
292: END IF;

Line 294: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_update_date,p_old_Line_Scredit_rec.last_update_date)

290: l_index := l_index + 1;
291: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATED_BY;
292: END IF;
293:
294: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_update_date,p_old_Line_Scredit_rec.last_update_date)
295: THEN
296: l_index := l_index + 1;
297: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_DATE;
298: END IF;

Line 300: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_update_login,p_old_Line_Scredit_rec.last_update_login)

296: l_index := l_index + 1;
297: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_DATE;
298: END IF;
299:
300: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_update_login,p_old_Line_Scredit_rec.last_update_login)
301: THEN
302: l_index := l_index + 1;
303: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN;
304: END IF;

Line 306: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.line_id,p_old_Line_Scredit_rec.line_id)

302: l_index := l_index + 1;
303: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN;
304: END IF;
305:
306: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.line_id,p_old_Line_Scredit_rec.line_id)
307: THEN
308: l_index := l_index + 1;
309: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LINE;
310: END IF;

Line 312: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.percent,p_old_Line_Scredit_rec.percent)

308: l_index := l_index + 1;
309: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LINE;
310: END IF;
311:
312: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.percent,p_old_Line_Scredit_rec.percent)
313: THEN
314: l_index := l_index + 1;
315: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_PERCENT;
316: END IF;

Line 319: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.salesrep_id,p_old_Line_Scredit_rec.salesrep_id)

315: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_PERCENT;
316: END IF;
317:
318:
319: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.salesrep_id,p_old_Line_Scredit_rec.salesrep_id)
320: THEN
321: l_index := l_index + 1;
322: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_SALESREP;
323: END IF;

Line 325: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.sales_credit_type_id,p_old_Line_Scredit_rec.sales_credit_type_id)

321: l_index := l_index + 1;
322: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_SALESREP;
323: END IF;
324:
325: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.sales_credit_type_id,p_old_Line_Scredit_rec.sales_credit_type_id)
326: THEN
327: l_index := l_index + 1;
328: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_sales_credit_type;
329: END IF;

Line 331: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.sales_credit_id,p_old_Line_Scredit_rec.sales_credit_id)

327: l_index := l_index + 1;
328: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_sales_credit_type;
329: END IF;
330:
331: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.sales_credit_id,p_old_Line_Scredit_rec.sales_credit_id)
332: THEN
333: l_index := l_index + 1;
334: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_SALES_CREDIT;
335: END IF;

Line 337: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.wh_update_date,p_old_Line_Scredit_rec.wh_update_date)

333: l_index := l_index + 1;
334: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_SALES_CREDIT;
335: END IF;
336:
337: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.wh_update_date,p_old_Line_Scredit_rec.wh_update_date)
338: THEN
339: l_index := l_index + 1;
340: l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_WH_UPDATE_DATE;
341: END IF;

Line 435: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_SCREDIT,

431:
432: If l_src_attr_tbl.COUNT <> 0 THEN
433:
434: OE_Dependencies.Mark_Dependent
435: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_SCREDIT,
436: p_source_attr_tbl => l_src_attr_tbl,
437: p_dep_attr_tbl => l_dep_attr_tbl);
438:
439: FOR I IN 1..l_dep_attr_tbl.COUNT LOOP

Line 562: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute1,p_old_Line_Scredit_rec.attribute1)

558: IF l_debug_level > 0 THEN
559: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.APPLY_ATTRIBUTE_CHANGES' , 1 ) ;
560: END IF;
561:
562: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute1,p_old_Line_Scredit_rec.attribute1)
563: THEN
564: NULL;
565: END IF;
566:

Line 567: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute10,p_old_Line_Scredit_rec.attribute10)

563: THEN
564: NULL;
565: END IF;
566:
567: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute10,p_old_Line_Scredit_rec.attribute10)
568: THEN
569: NULL;
570: END IF;
571:

Line 572: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute11,p_old_Line_Scredit_rec.attribute11)

568: THEN
569: NULL;
570: END IF;
571:
572: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute11,p_old_Line_Scredit_rec.attribute11)
573: THEN
574: NULL;
575: END IF;
576:

Line 577: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute12,p_old_Line_Scredit_rec.attribute12)

573: THEN
574: NULL;
575: END IF;
576:
577: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute12,p_old_Line_Scredit_rec.attribute12)
578: THEN
579: NULL;
580: END IF;
581:

Line 582: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute13,p_old_Line_Scredit_rec.attribute13)

578: THEN
579: NULL;
580: END IF;
581:
582: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute13,p_old_Line_Scredit_rec.attribute13)
583: THEN
584: NULL;
585: END IF;
586:

Line 587: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute14,p_old_Line_Scredit_rec.attribute14)

583: THEN
584: NULL;
585: END IF;
586:
587: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute14,p_old_Line_Scredit_rec.attribute14)
588: THEN
589: NULL;
590: END IF;
591:

Line 592: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute15,p_old_Line_Scredit_rec.attribute15)

588: THEN
589: NULL;
590: END IF;
591:
592: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute15,p_old_Line_Scredit_rec.attribute15)
593: THEN
594: NULL;
595: END IF;
596:

Line 597: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute2,p_old_Line_Scredit_rec.attribute2)

593: THEN
594: NULL;
595: END IF;
596:
597: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute2,p_old_Line_Scredit_rec.attribute2)
598: THEN
599: NULL;
600: END IF;
601:

Line 602: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute3,p_old_Line_Scredit_rec.attribute3)

598: THEN
599: NULL;
600: END IF;
601:
602: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute3,p_old_Line_Scredit_rec.attribute3)
603: THEN
604: NULL;
605: END IF;
606:

Line 607: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute4,p_old_Line_Scredit_rec.attribute4)

603: THEN
604: NULL;
605: END IF;
606:
607: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute4,p_old_Line_Scredit_rec.attribute4)
608: THEN
609: NULL;
610: END IF;
611:

Line 612: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute5,p_old_Line_Scredit_rec.attribute5)

608: THEN
609: NULL;
610: END IF;
611:
612: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute5,p_old_Line_Scredit_rec.attribute5)
613: THEN
614: NULL;
615: END IF;
616:

Line 617: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute6,p_old_Line_Scredit_rec.attribute6)

613: THEN
614: NULL;
615: END IF;
616:
617: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute6,p_old_Line_Scredit_rec.attribute6)
618: THEN
619: NULL;
620: END IF;
621:

Line 622: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute7,p_old_Line_Scredit_rec.attribute7)

618: THEN
619: NULL;
620: END IF;
621:
622: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute7,p_old_Line_Scredit_rec.attribute7)
623: THEN
624: NULL;
625: END IF;
626:

Line 627: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute8,p_old_Line_Scredit_rec.attribute8)

623: THEN
624: NULL;
625: END IF;
626:
627: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute8,p_old_Line_Scredit_rec.attribute8)
628: THEN
629: NULL;
630: END IF;
631:

Line 632: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute9,p_old_Line_Scredit_rec.attribute9)

628: THEN
629: NULL;
630: END IF;
631:
632: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute9,p_old_Line_Scredit_rec.attribute9)
633: THEN
634: NULL;
635: END IF;
636:

Line 637: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.context,p_old_Line_Scredit_rec.context)

633: THEN
634: NULL;
635: END IF;
636:
637: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.context,p_old_Line_Scredit_rec.context)
638: THEN
639: NULL;
640: END IF;
641:

Line 642: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.created_by,p_old_Line_Scredit_rec.created_by)

638: THEN
639: NULL;
640: END IF;
641:
642: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.created_by,p_old_Line_Scredit_rec.created_by)
643: THEN
644: NULL;
645: END IF;
646:

Line 647: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.creation_date,p_old_Line_Scredit_rec.creation_date)

643: THEN
644: NULL;
645: END IF;
646:
647: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.creation_date,p_old_Line_Scredit_rec.creation_date)
648: THEN
649: NULL;
650: END IF;
651:

Line 652: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.dw_update_advice_flag,p_old_Line_Scredit_rec.dw_update_advice_flag)

648: THEN
649: NULL;
650: END IF;
651:
652: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.dw_update_advice_flag,p_old_Line_Scredit_rec.dw_update_advice_flag)
653: THEN
654: NULL;
655: END IF;
656:

Line 657: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.header_id,p_old_Line_Scredit_rec.header_id)

653: THEN
654: NULL;
655: END IF;
656:
657: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.header_id,p_old_Line_Scredit_rec.header_id)
658: THEN
659: NULL;
660: END IF;
661:

Line 662: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_updated_by,p_old_Line_Scredit_rec.last_updated_by)

658: THEN
659: NULL;
660: END IF;
661:
662: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_updated_by,p_old_Line_Scredit_rec.last_updated_by)
663: THEN
664: NULL;
665: END IF;
666:

Line 667: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_update_date,p_old_Line_Scredit_rec.last_update_date)

663: THEN
664: NULL;
665: END IF;
666:
667: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_update_date,p_old_Line_Scredit_rec.last_update_date)
668: THEN
669: NULL;
670: END IF;
671:

Line 672: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_update_login,p_old_Line_Scredit_rec.last_update_login)

668: THEN
669: NULL;
670: END IF;
671:
672: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_update_login,p_old_Line_Scredit_rec.last_update_login)
673: THEN
674: NULL;
675: END IF;
676:

Line 677: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.line_id,p_old_Line_Scredit_rec.line_id)

673: THEN
674: NULL;
675: END IF;
676:
677: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.line_id,p_old_Line_Scredit_rec.line_id)
678: THEN
679: NULL;
680: END IF;
681:

Line 682: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.percent,p_old_Line_Scredit_rec.percent)

678: THEN
679: NULL;
680: END IF;
681:
682: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.percent,p_old_Line_Scredit_rec.percent)
683: THEN
684: -- Add delayed request to validate quota percent sums up to 100
685: OE_Delayed_Requests_Pvt.Log_Request
686: (p_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit

Line 686: (p_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit

682: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.percent,p_old_Line_Scredit_rec.percent)
683: THEN
684: -- Add delayed request to validate quota percent sums up to 100
685: OE_Delayed_Requests_Pvt.Log_Request
686: (p_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
687: ,p_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
688: ,p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
689: ,p_requesting_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
690: ,p_request_type=>OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL

Line 688: ,p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit

684: -- Add delayed request to validate quota percent sums up to 100
685: OE_Delayed_Requests_Pvt.Log_Request
686: (p_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
687: ,p_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
688: ,p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
689: ,p_requesting_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
690: ,p_request_type=>OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL
691: ,p_param1 => to_char(p_x_Line_Scredit_rec.Line_id)
692: ,x_return_status =>l_return_status);

Line 690: ,p_request_type=>OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL

686: (p_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
687: ,p_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
688: ,p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
689: ,p_requesting_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
690: ,p_request_type=>OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL
691: ,p_param1 => to_char(p_x_Line_Scredit_rec.Line_id)
692: ,x_return_status =>l_return_status);
693: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 701: (p_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit

697: END IF;
698:
699: -- Add delayed request to cascade changes to service lines.
700: OE_Delayed_Requests_Pvt.Log_Request
701: (p_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
702: ,p_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
703: ,p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
704: ,p_requesting_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
705: ,p_request_type=>OE_GLOBALS.G_CASCADE_SERVICE_SCREDIT

Line 703: ,p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit

699: -- Add delayed request to cascade changes to service lines.
700: OE_Delayed_Requests_Pvt.Log_Request
701: (p_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
702: ,p_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
703: ,p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
704: ,p_requesting_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
705: ,p_request_type=>OE_GLOBALS.G_CASCADE_SERVICE_SCREDIT
706: ,p_param8 => to_char(p_x_Line_Scredit_rec.Line_id)
707: ,p_param1 => to_char(p_x_Line_Scredit_rec.salesrep_id)

Line 705: ,p_request_type=>OE_GLOBALS.G_CASCADE_SERVICE_SCREDIT

701: (p_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
702: ,p_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
703: ,p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
704: ,p_requesting_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
705: ,p_request_type=>OE_GLOBALS.G_CASCADE_SERVICE_SCREDIT
706: ,p_param8 => to_char(p_x_Line_Scredit_rec.Line_id)
707: ,p_param1 => to_char(p_x_Line_Scredit_rec.salesrep_id)
708: ,p_param2 => to_char(p_old_Line_Scredit_rec.salesrep_id)
709: ,p_param3 => to_char(p_x_Line_Scredit_rec.Sales_credit_type_id)

Line 724: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.sales_credit_type_id,p_old_Line_Scredit_rec.sales_credit_type_id)

720: END IF;
721:
722: END IF;
723:
724: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.sales_credit_type_id,p_old_Line_Scredit_rec.sales_credit_type_id)
725: THEN
726: -- Add delayed request to validate quota percent sums up to 100
727: OE_Delayed_Requests_Pvt.Log_Request
728: (p_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit

Line 728: (p_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit

724: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.sales_credit_type_id,p_old_Line_Scredit_rec.sales_credit_type_id)
725: THEN
726: -- Add delayed request to validate quota percent sums up to 100
727: OE_Delayed_Requests_Pvt.Log_Request
728: (p_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
729: ,p_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
730: ,p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
731: ,p_requesting_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
732: ,p_request_type=>OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL

Line 730: ,p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit

726: -- Add delayed request to validate quota percent sums up to 100
727: OE_Delayed_Requests_Pvt.Log_Request
728: (p_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
729: ,p_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
730: ,p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
731: ,p_requesting_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
732: ,p_request_type=>OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL
733: ,p_param1 => to_char(p_x_Line_Scredit_rec.Line_id)
734: ,x_return_status =>l_return_status);

Line 732: ,p_request_type=>OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL

728: (p_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
729: ,p_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
730: ,p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
731: ,p_requesting_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
732: ,p_request_type=>OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL
733: ,p_param1 => to_char(p_x_Line_Scredit_rec.Line_id)
734: ,x_return_status =>l_return_status);
735: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 744: (p_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit

740: --END IF; Commented of this end if as part of fix for bug#2174201
741:
742: -- Add delayed request to cascade changes to service lines.
743: OE_Delayed_Requests_Pvt.Log_Request
744: (p_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
745: ,p_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
746: ,p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
747: ,p_requesting_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
748: ,p_request_type=>OE_GLOBALS.G_CASCADE_SERVICE_SCREDIT

Line 746: ,p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit

742: -- Add delayed request to cascade changes to service lines.
743: OE_Delayed_Requests_Pvt.Log_Request
744: (p_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
745: ,p_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
746: ,p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
747: ,p_requesting_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
748: ,p_request_type=>OE_GLOBALS.G_CASCADE_SERVICE_SCREDIT
749: ,p_param8 => to_char(p_x_Line_Scredit_rec.Line_id)
750: ,p_param1 => to_char(p_x_Line_Scredit_rec.salesrep_id)

Line 748: ,p_request_type=>OE_GLOBALS.G_CASCADE_SERVICE_SCREDIT

744: (p_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
745: ,p_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
746: ,p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
747: ,p_requesting_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
748: ,p_request_type=>OE_GLOBALS.G_CASCADE_SERVICE_SCREDIT
749: ,p_param8 => to_char(p_x_Line_Scredit_rec.Line_id)
750: ,p_param1 => to_char(p_x_Line_Scredit_rec.salesrep_id)
751: ,p_param2 => to_char(p_old_Line_Scredit_rec.salesrep_id)
752: ,p_param3 => to_char(p_x_Line_Scredit_rec.Sales_credit_type_id)

Line 766: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.salesrep_id,p_old_Line_Scredit_rec.salesrep_id)

762: RAISE FND_API.G_EXC_ERROR;
763: END IF;
764: END IF; --Commented end if moved here as part of fix for bug#2174201
765:
766: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.salesrep_id,p_old_Line_Scredit_rec.salesrep_id)
767: THEN
768: -- Add delayed request to cascade changes to service lines.
769: OE_Delayed_Requests_Pvt.Log_Request
770: (p_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit

Line 770: (p_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit

766: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.salesrep_id,p_old_Line_Scredit_rec.salesrep_id)
767: THEN
768: -- Add delayed request to cascade changes to service lines.
769: OE_Delayed_Requests_Pvt.Log_Request
770: (p_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
771: ,p_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
772: ,p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
773: ,p_requesting_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
774: ,p_request_type=>OE_GLOBALS.G_CASCADE_SERVICE_SCREDIT

Line 772: ,p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit

768: -- Add delayed request to cascade changes to service lines.
769: OE_Delayed_Requests_Pvt.Log_Request
770: (p_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
771: ,p_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
772: ,p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
773: ,p_requesting_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
774: ,p_request_type=>OE_GLOBALS.G_CASCADE_SERVICE_SCREDIT
775: ,p_param8 => to_char(p_x_Line_Scredit_rec.Line_id)
776: ,p_param1 => to_char(p_x_Line_Scredit_rec.salesrep_id)

Line 774: ,p_request_type=>OE_GLOBALS.G_CASCADE_SERVICE_SCREDIT

770: (p_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
771: ,p_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
772: ,p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Line_Scredit
773: ,p_requesting_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
774: ,p_request_type=>OE_GLOBALS.G_CASCADE_SERVICE_SCREDIT
775: ,p_param8 => to_char(p_x_Line_Scredit_rec.Line_id)
776: ,p_param1 => to_char(p_x_Line_Scredit_rec.salesrep_id)
777: ,p_param2 => to_char(p_old_Line_Scredit_rec.salesrep_id)
778: ,p_param3 => to_char(p_x_Line_Scredit_rec.Sales_credit_type_id)

Line 808: IF p_x_line_Scredit_rec.operation = oe_globals.g_opr_create AND

804: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.ordered_date;
805: END IF;
806:
807: --5692017
808: IF p_x_line_Scredit_rec.operation = oe_globals.g_opr_create AND
809: p_x_line_Scredit_rec.sales_group_id IS NOT NULL AND
810: nvl(p_x_line_Scredit_rec.sales_group_updated_flag,'N') = 'Y' THEN
811: oe_debug_pub.add('do not re-default sales group');
812: ELSE

Line 852: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.sales_credit_type_id ,p_old_Line_Scredit_rec.sales_credit_type_id)

848: x_return_status =>l_status);
849: END IF;
850: --SG}
851:
852: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.sales_credit_type_id ,p_old_Line_Scredit_rec.sales_credit_type_id)
853: THEN
854: NULL;
855: END IF;
856:

Line 857: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.sales_credit_id,p_old_Line_Scredit_rec.sales_credit_id)

853: THEN
854: NULL;
855: END IF;
856:
857: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.sales_credit_id,p_old_Line_Scredit_rec.sales_credit_id)
858: THEN
859: NULL;
860: END IF;
861:

Line 862: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.wh_update_date,p_old_Line_Scredit_rec.wh_update_date)

858: THEN
859: NULL;
860: END IF;
861:
862: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.wh_update_date,p_old_Line_Scredit_rec.wh_update_date)
863: THEN
864: NULL;
865: END IF;
866:

Line 1500: l_new_line_scredit_rec.operation := OE_GLOBALS.G_OPR_DELETE;

1496: oe_debug_pub.add( 'IN DELETE ROW , SALES_CREDIT_ID= '|| L_SCR.SALES_CREDIT_ID , 1 ) ;
1497: END IF;
1498:
1499: /* Set the operation on the record so that globals are updated as well */
1500: l_new_line_scredit_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1501: l_new_line_scredit_rec.sales_credit_id := l_scr.sales_credit_id;
1502:
1503: OE_ORDER_UTIL.Update_Global_Picture
1504: (p_Upd_New_Rec_If_Exists =>True,

Line 1538: p_entity_code => OE_GLOBALS.G_ENTITY_LINE_SCREDIT,

1534: END IF; /* code set is pack H or higher */
1535: /* jolin end*/
1536:
1537: OE_Delayed_Requests_Pvt.Delete_Reqs_for_Deleted_Entity(
1538: p_entity_code => OE_GLOBALS.G_ENTITY_LINE_SCREDIT,
1539: p_entity_id => l_scr.sales_credit_id,
1540: x_return_status => l_return_status
1541: );
1542:

Line 1577: l_new_line_scredit_rec.operation := OE_GLOBALS.G_OPR_DELETE;

1573: oe_debug_pub.add( 'IN DELETE ROW , LINE_ID IS G_MISS_NUM , SALES_CREDIT_ID= '|| P_SALES_CREDIT_ID , 1 ) ;
1574: END IF;
1575:
1576: /* Set the operation on the record so that globals are updated as well */
1577: l_new_line_scredit_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1578: l_new_line_scredit_rec.sales_credit_id := p_sales_credit_id;
1579:
1580: OE_ORDER_UTIL.Update_Global_Picture(
1581: p_Upd_New_Rec_If_Exists => True,

Line 1615: p_entity_code => OE_GLOBALS.G_ENTITY_LINE_SCREDIT,

1611: END IF; /* code set is pack H or higher */
1612: /* jolin end*/
1613:
1614: OE_Delayed_Requests_Pvt.Delete_Reqs_for_Deleted_Entity(
1615: p_entity_code => OE_GLOBALS.G_ENTITY_LINE_SCREDIT,
1616: p_entity_id => p_sales_credit_id,
1617: x_return_status => l_return_status
1618: );
1619:

Line 2024: IF OE_GLOBALS.Equal(p_x_Line_Scredit_rec.lock_control,

2020:
2021: -- Row locked. If the whole record is passed, then
2022: -- Compare IN attributes to DB attributes.
2023:
2024: IF OE_GLOBALS.Equal(p_x_Line_Scredit_rec.lock_control,
2025: l_lock_control)
2026: THEN
2027:
2028: -- Set return status

Line 2246: NOT OE_GLOBALS.Equal(p_Line_Scredit_rec.salesrep_id,

2242: BEGIN
2243:
2244: IF (p_Line_Scredit_rec.salesrep_id IS NULL OR
2245: p_Line_Scredit_rec.salesrep_id <> FND_API.G_MISS_NUM) AND
2246: NOT OE_GLOBALS.Equal(p_Line_Scredit_rec.salesrep_id,
2247: p_old_Line_Scredit_rec.salesrep_id)
2248: THEN
2249: l_Line_Scredit_val_rec.salesrep := OE_Id_To_Value.Salesrep
2250: ( p_salesrep_id => p_Line_Scredit_rec.salesrep_id

Line 2255: NOT OE_GLOBALS.Equal(p_Line_Scredit_rec.sales_credit_type_id,

2251: );
2252: END IF;
2253: IF (p_Line_Scredit_rec.sales_credit_type_id IS NULL OR
2254: p_Line_Scredit_rec.sales_credit_type_id <> FND_API.G_MISS_NUM) AND
2255: NOT OE_GLOBALS.Equal(p_Line_Scredit_rec.sales_credit_type_id,
2256: p_old_Line_Scredit_rec.sales_credit_type_id)
2257: THEN
2258: l_Line_Scredit_val_rec.sales_credit_type := OE_Id_To_Value.sales_credit_type
2259: ( p_sales_Credit_type_id => p_Line_Scredit_rec.sales_credit_type_id

Line 2360: l_control_rec OE_GLOBALS.Control_Rec_Type;

2356: p_old_line_rec IN oe_order_pub.line_rec_type)
2357: IS
2358: l_api_name CONSTANT VARCHAR2(30) := 'Create Credit';
2359: l_return_status VARCHAR2(30);
2360: l_control_rec OE_GLOBALS.Control_Rec_Type;
2361: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type ;
2362: l_old_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type ;
2363: l_line_scredit_rec OE_ORDER_PUB.line_scredit_rec_type ;
2364: l_create_flag boolean := FALSE;

Line 2403: IF NOT OE_GLOBALS.EQUAL(G_HEADER_ID,p_line_rec.header_id) or

2399: END IF;
2400: IF l_debug_level > 0 THEN
2401: oe_debug_pub.add( 'HEADER:' ||P_LINE_REC.HEADER_ID ) ;
2402: END IF;
2403: IF NOT OE_GLOBALS.EQUAL(G_HEADER_ID,p_line_rec.header_id) or
2404: G_SALESREP_ID IS NULL Then
2405: --added for bug 4200055
2406: if ((Oe_Order_Cache.g_header_rec.header_id = p_line_rec.header_id)
2407: AND (Oe_Order_Cache.g_header_rec.header_id <> NULL)

Line 2422: IF NOT OE_GLOBALS.EQUAL(l_salesrep_id, p_line_rec.salesrep_id)

2418: -- end bug 4200055
2419: End If;
2420:
2421: l_salesrep_id := G_SALESREP_ID;
2422: IF NOT OE_GLOBALS.EQUAL(l_salesrep_id, p_line_rec.salesrep_id)
2423: OR p_line_rec.salesrep_id IS NULL THEN -- Added condition for bug 6494279
2424:
2425: IF (p_line_rec.operation = oe_globals.g_opr_create AND
2426: p_line_rec.salesrep_id IS NOT NULL AND

Line 2425: IF (p_line_rec.operation = oe_globals.g_opr_create AND

2421: l_salesrep_id := G_SALESREP_ID;
2422: IF NOT OE_GLOBALS.EQUAL(l_salesrep_id, p_line_rec.salesrep_id)
2423: OR p_line_rec.salesrep_id IS NULL THEN -- Added condition for bug 6494279
2424:
2425: IF (p_line_rec.operation = oe_globals.g_opr_create AND
2426: p_line_rec.salesrep_id IS NOT NULL AND
2427: p_line_rec.salesrep_id <> FND_API.G_MISS_NUM) THEN
2428:
2429: l_create_flag := TRUE;

Line 2434: ELSIF (p_line_rec.operation = oe_globals.g_opr_update AND

2430:
2431: IF l_debug_level > 0 THEN
2432: oe_debug_pub.add( 'IN CREATE' ) ;
2433: END IF;
2434: ELSIF (p_line_rec.operation = oe_globals.g_opr_update AND
2435: NOT OE_GLOBALS.EQUAL( p_line_rec.salesrep_id,
2436: p_old_line_rec.salesrep_id)) THEN
2437: IF l_debug_level > 0 THEN
2438: oe_debug_pub.add( 'IN OPERATION UPDATE ' ) ;

Line 2435: NOT OE_GLOBALS.EQUAL( p_line_rec.salesrep_id,

2431: IF l_debug_level > 0 THEN
2432: oe_debug_pub.add( 'IN CREATE' ) ;
2433: END IF;
2434: ELSIF (p_line_rec.operation = oe_globals.g_opr_update AND
2435: NOT OE_GLOBALS.EQUAL( p_line_rec.salesrep_id,
2436: p_old_line_rec.salesrep_id)) THEN
2437: IF l_debug_level > 0 THEN
2438: oe_debug_pub.add( 'IN OPERATION UPDATE ' ) ;
2439: END IF;

Line 2515: l_line_scredit_tbl(1).operation := oe_globals.g_opr_update;

2511:
2512: /* Added the following line to fix the bug 1822931 */
2513: l_line_scredit_tbl(1).sales_credit_type_id := l_scredit_type_id;
2514:
2515: l_line_scredit_tbl(1).operation := oe_globals.g_opr_update;
2516: l_update_flag := TRUE;
2517:
2518: END IF; -- Added for Bug 6445046
2519:

Line 2542: l_line_scredit_tbl(1).operation := oe_globals.g_opr_create;

2538: fetch C_SCRTYPE into l_scredit_Type_id;
2539: close C_SCRTYPE;
2540:
2541: l_line_scredit_tbl(1) := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC;
2542: l_line_scredit_tbl(1).operation := oe_globals.g_opr_create;
2543: l_line_scredit_tbl(1).header_id := p_line_rec.header_id;
2544: l_line_scredit_tbl(1).line_id := p_line_rec.line_id;
2545: l_line_scredit_tbl(1).percent := 100;
2546: l_line_Scredit_tbl(1).Sales_credit_type_id := l_scredit_type_id;

Line 2677: OE_GLOBALS.G_ROLL_VERSION <> 'N' THEN

2673: BEGIN
2674:
2675: --11.5.10 Versioning/Audit Trail updates
2676: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
2677: OE_GLOBALS.G_ROLL_VERSION <> 'N' THEN
2678: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
2679: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
2680: IF p_x_line_scredit_rec.change_reason <> FND_API.G_MISS_CHAR THEN
2681: OE_GLOBALS.G_REASON_CODE := p_x_line_scredit_rec.change_reason;

Line 2678: IF OE_GLOBALS.G_REASON_CODE IS NULL AND

2674:
2675: --11.5.10 Versioning/Audit Trail updates
2676: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
2677: OE_GLOBALS.G_ROLL_VERSION <> 'N' THEN
2678: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
2679: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
2680: IF p_x_line_scredit_rec.change_reason <> FND_API.G_MISS_CHAR THEN
2681: OE_GLOBALS.G_REASON_CODE := p_x_line_scredit_rec.change_reason;
2682: OE_GLOBALS.G_REASON_COMMENTS := p_x_line_scredit_rec.change_comments;

Line 2679: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN

2675: --11.5.10 Versioning/Audit Trail updates
2676: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
2677: OE_GLOBALS.G_ROLL_VERSION <> 'N' THEN
2678: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
2679: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
2680: IF p_x_line_scredit_rec.change_reason <> FND_API.G_MISS_CHAR THEN
2681: OE_GLOBALS.G_REASON_CODE := p_x_line_scredit_rec.change_reason;
2682: OE_GLOBALS.G_REASON_COMMENTS := p_x_line_scredit_rec.change_comments;
2683: OE_GLOBALS.G_CAPTURED_REASON := 'Y';

Line 2681: OE_GLOBALS.G_REASON_CODE := p_x_line_scredit_rec.change_reason;

2677: OE_GLOBALS.G_ROLL_VERSION <> 'N' THEN
2678: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
2679: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
2680: IF p_x_line_scredit_rec.change_reason <> FND_API.G_MISS_CHAR THEN
2681: OE_GLOBALS.G_REASON_CODE := p_x_line_scredit_rec.change_reason;
2682: OE_GLOBALS.G_REASON_COMMENTS := p_x_line_scredit_rec.change_comments;
2683: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
2684: ELSE
2685: IF l_debug_level > 0 THEN

Line 2682: OE_GLOBALS.G_REASON_COMMENTS := p_x_line_scredit_rec.change_comments;

2678: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
2679: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
2680: IF p_x_line_scredit_rec.change_reason <> FND_API.G_MISS_CHAR THEN
2681: OE_GLOBALS.G_REASON_CODE := p_x_line_scredit_rec.change_reason;
2682: OE_GLOBALS.G_REASON_COMMENTS := p_x_line_scredit_rec.change_comments;
2683: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
2684: ELSE
2685: IF l_debug_level > 0 THEN
2686: OE_DEBUG_PUB.add('Reason code for versioning missing', 1);

Line 2683: OE_GLOBALS.G_CAPTURED_REASON := 'Y';

2679: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
2680: IF p_x_line_scredit_rec.change_reason <> FND_API.G_MISS_CHAR THEN
2681: OE_GLOBALS.G_REASON_CODE := p_x_line_scredit_rec.change_reason;
2682: OE_GLOBALS.G_REASON_COMMENTS := p_x_line_scredit_rec.change_comments;
2683: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
2684: ELSE
2685: IF l_debug_level > 0 THEN
2686: OE_DEBUG_PUB.add('Reason code for versioning missing', 1);
2687: END IF;

Line 2688: IF OE_GLOBALS.G_UI_FLAG THEN

2684: ELSE
2685: IF l_debug_level > 0 THEN
2686: OE_DEBUG_PUB.add('Reason code for versioning missing', 1);
2687: END IF;
2688: IF OE_GLOBALS.G_UI_FLAG THEN
2689: raise FND_API.G_EXC_ERROR;
2690: END IF;
2691: END IF;
2692: END IF;

Line 2698: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

2694: --log delayed request
2695: IF l_debug_level > 0 THEN
2696: oe_debug_pub.add('log versioning request',1);
2697: END IF;
2698: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2699: p_entity_id => p_x_line_scredit_rec.header_id,
2700: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_SCREDIT,
2701: p_requesting_entity_id => p_x_line_scredit_rec.sales_credit_id,
2702: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,

Line 2700: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_SCREDIT,

2696: oe_debug_pub.add('log versioning request',1);
2697: END IF;
2698: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2699: p_entity_id => p_x_line_scredit_rec.header_id,
2700: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_SCREDIT,
2701: p_requesting_entity_id => p_x_line_scredit_rec.sales_credit_id,
2702: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
2703: x_return_status => l_return_status);
2704: END IF;

Line 2702: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,

2698: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2699: p_entity_id => p_x_line_scredit_rec.header_id,
2700: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_SCREDIT,
2701: p_requesting_entity_id => p_x_line_scredit_rec.sales_credit_id,
2702: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
2703: x_return_status => l_return_status);
2704: END IF;
2705:
2706: IF (p_x_line_scredit_rec.operation = OE_GLOBALS.G_OPR_UPDATE) then

Line 2706: IF (p_x_line_scredit_rec.operation = OE_GLOBALS.G_OPR_UPDATE) then

2702: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
2703: x_return_status => l_return_status);
2704: END IF;
2705:
2706: IF (p_x_line_scredit_rec.operation = OE_GLOBALS.G_OPR_UPDATE) then
2707:
2708: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG='Y' then
2709: IF l_debug_level > 0 THEN
2710: oe_debug_pub.add( 'OEXULSCB: AUDIT TRAIL - CHANGE REQUIRES REASON' , 2 ) ;

Line 2708: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG='Y' then

2704: END IF;
2705:
2706: IF (p_x_line_scredit_rec.operation = OE_GLOBALS.G_OPR_UPDATE) then
2707:
2708: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG='Y' then
2709: IF l_debug_level > 0 THEN
2710: oe_debug_pub.add( 'OEXULSCB: AUDIT TRAIL - CHANGE REQUIRES REASON' , 2 ) ;
2711: END IF;
2712: IF (p_x_line_scredit_rec.change_reason IS NULL OR

Line 2715: IF OE_GLOBALS.G_DEFAULT_REASON THEN

2711: END IF;
2712: IF (p_x_line_scredit_rec.change_reason IS NULL OR
2713: p_x_line_scredit_rec.change_reason = FND_API.G_MISS_CHAR OR
2714: NOT OE_VALIDATE.Change_Reason_Code(p_x_line_Scredit_rec.Change_Reason)) THEN
2715: IF OE_GLOBALS.G_DEFAULT_REASON THEN
2716: if l_debug_level > 0 then
2717: oe_debug_pub.add('Defaulting Audit Reason for Line Sales Credit', 1);
2718: end if;
2719: p_x_line_scredit_rec.change_reason := 'SYSTEM';

Line 2731: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' OR

2727: raise FND_API.G_EXC_ERROR;
2728: END IF;
2729: END IF;
2730: END IF;
2731: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' OR
2732: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG = 'Y' THEN
2733:
2734: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
2735: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_LINE_SCREDIT,

Line 2732: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG = 'Y' THEN

2728: END IF;
2729: END IF;
2730: END IF;
2731: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' OR
2732: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG = 'Y' THEN
2733:
2734: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
2735: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_LINE_SCREDIT,
2736: p_entity_id => p_x_line_scredit_rec.sales_credit_id,

Line 2735: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_LINE_SCREDIT,

2731: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' OR
2732: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG = 'Y' THEN
2733:
2734: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
2735: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_LINE_SCREDIT,
2736: p_entity_id => p_x_line_scredit_rec.sales_credit_id,
2737: p_hist_type_code => 'UPDATE');
2738: --log delayed request
2739: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

Line 2739: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

2735: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_LINE_SCREDIT,
2736: p_entity_id => p_x_line_scredit_rec.sales_credit_id,
2737: p_hist_type_code => 'UPDATE');
2738: --log delayed request
2739: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2740: p_entity_id => p_x_line_scredit_rec.header_id,
2741: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_SCREDIT,
2742: p_requesting_entity_id => p_x_line_scredit_rec.sales_credit_id,
2743: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,

Line 2741: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_SCREDIT,

2737: p_hist_type_code => 'UPDATE');
2738: --log delayed request
2739: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2740: p_entity_id => p_x_line_scredit_rec.header_id,
2741: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_SCREDIT,
2742: p_requesting_entity_id => p_x_line_scredit_rec.sales_credit_id,
2743: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
2744: x_return_status => l_return_status);
2745: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';

Line 2743: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,

2739: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2740: p_entity_id => p_x_line_scredit_rec.header_id,
2741: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_SCREDIT,
2742: p_requesting_entity_id => p_x_line_scredit_rec.sales_credit_id,
2743: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
2744: x_return_status => l_return_status);
2745: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
2746: ELSE
2747: IF l_debug_level > 0 THEN

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

2741: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_SCREDIT,
2742: p_requesting_entity_id => p_x_line_scredit_rec.sales_credit_id,
2743: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
2744: x_return_status => l_return_status);
2745: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
2746: ELSE
2747: IF l_debug_level > 0 THEN
2748: oe_debug_pub.add( 'OEXULSCB:CALLING OE_ORDER_CHG_PVT.RECORDLSCREDITHIST' , 2 ) ;
2749: END IF;