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

APPS.OE_HEADER_SCREDIT_UTIL dependencies on OE_GLOBALS

Line 153: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;

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

Line 154: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;

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

Line 169: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute1,p_old_Header_Scredit_rec.attribute1)

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

Line 175: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute10,p_old_Header_Scredit_rec.attribute10)

171: l_index := l_index + 1;
172: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE1;
173: END IF;
174:
175: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute10,p_old_Header_Scredit_rec.attribute10)
176: THEN
177: l_index := l_index + 1;
178: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE10;
179: END IF;

Line 181: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute11,p_old_Header_Scredit_rec.attribute11)

177: l_index := l_index + 1;
178: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE10;
179: END IF;
180:
181: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute11,p_old_Header_Scredit_rec.attribute11)
182: THEN
183: l_index := l_index + 1;
184: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE11;
185: END IF;

Line 187: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute12,p_old_Header_Scredit_rec.attribute12)

183: l_index := l_index + 1;
184: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE11;
185: END IF;
186:
187: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute12,p_old_Header_Scredit_rec.attribute12)
188: THEN
189: l_index := l_index + 1;
190: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE12;
191: END IF;

Line 193: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute13,p_old_Header_Scredit_rec.attribute13)

189: l_index := l_index + 1;
190: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE12;
191: END IF;
192:
193: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute13,p_old_Header_Scredit_rec.attribute13)
194: THEN
195: l_index := l_index + 1;
196: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE13;
197: END IF;

Line 199: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute14,p_old_Header_Scredit_rec.attribute14)

195: l_index := l_index + 1;
196: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE13;
197: END IF;
198:
199: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute14,p_old_Header_Scredit_rec.attribute14)
200: THEN
201: l_index := l_index + 1;
202: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE14;
203: END IF;

Line 205: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute15,p_old_Header_Scredit_rec.attribute15)

201: l_index := l_index + 1;
202: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE14;
203: END IF;
204:
205: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute15,p_old_Header_Scredit_rec.attribute15)
206: THEN
207: l_index := l_index + 1;
208: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE15;
209: END IF;

Line 211: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute2,p_old_Header_Scredit_rec.attribute2)

207: l_index := l_index + 1;
208: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE15;
209: END IF;
210:
211: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute2,p_old_Header_Scredit_rec.attribute2)
212: THEN
213: l_index := l_index + 1;
214: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE2;
215: END IF;

Line 217: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute3,p_old_Header_Scredit_rec.attribute3)

213: l_index := l_index + 1;
214: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE2;
215: END IF;
216:
217: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute3,p_old_Header_Scredit_rec.attribute3)
218: THEN
219: l_index := l_index + 1;
220: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE3;
221: END IF;

Line 223: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute4,p_old_Header_Scredit_rec.attribute4)

219: l_index := l_index + 1;
220: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE3;
221: END IF;
222:
223: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute4,p_old_Header_Scredit_rec.attribute4)
224: THEN
225: l_index := l_index + 1;
226: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE4;
227: END IF;

Line 229: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute5,p_old_Header_Scredit_rec.attribute5)

225: l_index := l_index + 1;
226: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE4;
227: END IF;
228:
229: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute5,p_old_Header_Scredit_rec.attribute5)
230: THEN
231: l_index := l_index + 1;
232: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE5;
233: END IF;

Line 235: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute6,p_old_Header_Scredit_rec.attribute6)

231: l_index := l_index + 1;
232: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE5;
233: END IF;
234:
235: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute6,p_old_Header_Scredit_rec.attribute6)
236: THEN
237: l_index := l_index + 1;
238: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE6;
239: END IF;

Line 241: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute7,p_old_Header_Scredit_rec.attribute7)

237: l_index := l_index + 1;
238: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE6;
239: END IF;
240:
241: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute7,p_old_Header_Scredit_rec.attribute7)
242: THEN
243: l_index := l_index + 1;
244: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE7;
245: END IF;

Line 247: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute8,p_old_Header_Scredit_rec.attribute8)

243: l_index := l_index + 1;
244: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE7;
245: END IF;
246:
247: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute8,p_old_Header_Scredit_rec.attribute8)
248: THEN
249: l_index := l_index + 1;
250: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE8;
251: END IF;

Line 253: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute9,p_old_Header_Scredit_rec.attribute9)

249: l_index := l_index + 1;
250: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE8;
251: END IF;
252:
253: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute9,p_old_Header_Scredit_rec.attribute9)
254: THEN
255: l_index := l_index + 1;
256: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE9;
257: END IF;

Line 259: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.context,p_old_Header_Scredit_rec.context)

255: l_index := l_index + 1;
256: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE9;
257: END IF;
258:
259: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.context,p_old_Header_Scredit_rec.context)
260: THEN
261: l_index := l_index + 1;
262: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_CONTEXT;
263: END IF;

Line 265: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.created_by,p_old_Header_Scredit_rec.created_by)

261: l_index := l_index + 1;
262: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_CONTEXT;
263: END IF;
264:
265: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.created_by,p_old_Header_Scredit_rec.created_by)
266: THEN
267: l_index := l_index + 1;
268: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_CREATED_BY;
269: END IF;

Line 271: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.creation_date,p_old_Header_Scredit_rec.creation_date)

267: l_index := l_index + 1;
268: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_CREATED_BY;
269: END IF;
270:
271: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.creation_date,p_old_Header_Scredit_rec.creation_date)
272: THEN
273: l_index := l_index + 1;
274: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_CREATION_DATE;
275: END IF;

Line 277: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.dw_update_advice_flag,p_old_Header_Scredit_rec.dw_update_advice_flag)

273: l_index := l_index + 1;
274: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_CREATION_DATE;
275: END IF;
276:
277: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.dw_update_advice_flag,p_old_Header_Scredit_rec.dw_update_advice_flag)
278: THEN
279: l_index := l_index + 1;
280: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_DW_UPDATE_ADVICE;
281: END IF;

Line 283: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.header_id,p_old_Header_Scredit_rec.header_id)

279: l_index := l_index + 1;
280: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_DW_UPDATE_ADVICE;
281: END IF;
282:
283: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.header_id,p_old_Header_Scredit_rec.header_id)
284: THEN
285: l_index := l_index + 1;
286: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_HEADER;
287: END IF;

Line 289: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.last_updated_by,p_old_Header_Scredit_rec.last_updated_by)

285: l_index := l_index + 1;
286: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_HEADER;
287: END IF;
288:
289: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.last_updated_by,p_old_Header_Scredit_rec.last_updated_by)
290: THEN
291: l_index := l_index + 1;
292: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATED_BY;
293: END IF;

Line 295: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.last_update_date,p_old_Header_Scredit_rec.last_update_date)

291: l_index := l_index + 1;
292: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATED_BY;
293: END IF;
294:
295: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.last_update_date,p_old_Header_Scredit_rec.last_update_date)
296: THEN
297: l_index := l_index + 1;
298: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATE_DATE;
299: END IF;

Line 301: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.last_update_login,p_old_Header_Scredit_rec.last_update_login)

297: l_index := l_index + 1;
298: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATE_DATE;
299: END IF;
300:
301: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.last_update_login,p_old_Header_Scredit_rec.last_update_login)
302: THEN
303: l_index := l_index + 1;
304: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN;
305: END IF;

Line 307: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.line_id,p_old_Header_Scredit_rec.line_id)

303: l_index := l_index + 1;
304: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN;
305: END IF;
306:
307: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.line_id,p_old_Header_Scredit_rec.line_id)
308: THEN
309: l_index := l_index + 1;
310: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_LINE;
311: END IF;

Line 313: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.percent,p_old_Header_Scredit_rec.percent)

309: l_index := l_index + 1;
310: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_LINE;
311: END IF;
312:
313: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.percent,p_old_Header_Scredit_rec.percent)
314: THEN
315: l_index := l_index + 1;
316: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_PERCENT;
317: END IF;

Line 320: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.salesrep_id,p_old_Header_Scredit_rec.salesrep_id)

316: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_PERCENT;
317: END IF;
318:
319:
320: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.salesrep_id,p_old_Header_Scredit_rec.salesrep_id)
321: THEN
322: l_index := l_index + 1;
323: l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_SALESREP;
324: END IF;

Line 325: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.sales_credit_type_id,p_old_Header_Scredit_rec.sales_credit_type_id)

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

Line 331: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.sales_credit_id,p_old_Header_Scredit_rec.sales_credit_id)

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

Line 337: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.wh_update_date,p_old_Header_Scredit_rec.wh_update_date)

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

Line 435: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_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_HEADER_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 552: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute1,p_old_Header_Scredit_rec.attribute1)

548:
549: -- Load out record
550:
551:
552: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute1,p_old_Header_Scredit_rec.attribute1)
553: THEN
554: NULL;
555: END IF;
556:

Line 557: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute10,p_old_Header_Scredit_rec.attribute10)

553: THEN
554: NULL;
555: END IF;
556:
557: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute10,p_old_Header_Scredit_rec.attribute10)
558: THEN
559: NULL;
560: END IF;
561:

Line 562: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute11,p_old_Header_Scredit_rec.attribute11)

558: THEN
559: NULL;
560: END IF;
561:
562: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute11,p_old_Header_Scredit_rec.attribute11)
563: THEN
564: NULL;
565: END IF;
566:

Line 567: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute12,p_old_Header_Scredit_rec.attribute12)

563: THEN
564: NULL;
565: END IF;
566:
567: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute12,p_old_Header_Scredit_rec.attribute12)
568: THEN
569: NULL;
570: END IF;
571:

Line 572: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute13,p_old_Header_Scredit_rec.attribute13)

568: THEN
569: NULL;
570: END IF;
571:
572: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute13,p_old_Header_Scredit_rec.attribute13)
573: THEN
574: NULL;
575: END IF;
576:

Line 577: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute14,p_old_Header_Scredit_rec.attribute14)

573: THEN
574: NULL;
575: END IF;
576:
577: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute14,p_old_Header_Scredit_rec.attribute14)
578: THEN
579: NULL;
580: END IF;
581:

Line 582: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute15,p_old_Header_Scredit_rec.attribute15)

578: THEN
579: NULL;
580: END IF;
581:
582: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute15,p_old_Header_Scredit_rec.attribute15)
583: THEN
584: NULL;
585: END IF;
586:

Line 587: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute2,p_old_Header_Scredit_rec.attribute2)

583: THEN
584: NULL;
585: END IF;
586:
587: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute2,p_old_Header_Scredit_rec.attribute2)
588: THEN
589: NULL;
590: END IF;
591:

Line 592: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute3,p_old_Header_Scredit_rec.attribute3)

588: THEN
589: NULL;
590: END IF;
591:
592: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute3,p_old_Header_Scredit_rec.attribute3)
593: THEN
594: NULL;
595: END IF;
596:

Line 597: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute4,p_old_Header_Scredit_rec.attribute4)

593: THEN
594: NULL;
595: END IF;
596:
597: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute4,p_old_Header_Scredit_rec.attribute4)
598: THEN
599: NULL;
600: END IF;
601:

Line 602: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute5,p_old_Header_Scredit_rec.attribute5)

598: THEN
599: NULL;
600: END IF;
601:
602: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute5,p_old_Header_Scredit_rec.attribute5)
603: THEN
604: NULL;
605: END IF;
606:

Line 607: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute6,p_old_Header_Scredit_rec.attribute6)

603: THEN
604: NULL;
605: END IF;
606:
607: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute6,p_old_Header_Scredit_rec.attribute6)
608: THEN
609: NULL;
610: END IF;
611:

Line 612: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute7,p_old_Header_Scredit_rec.attribute7)

608: THEN
609: NULL;
610: END IF;
611:
612: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute7,p_old_Header_Scredit_rec.attribute7)
613: THEN
614: NULL;
615: END IF;
616:

Line 617: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute8,p_old_Header_Scredit_rec.attribute8)

613: THEN
614: NULL;
615: END IF;
616:
617: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute8,p_old_Header_Scredit_rec.attribute8)
618: THEN
619: NULL;
620: END IF;
621:

Line 622: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute9,p_old_Header_Scredit_rec.attribute9)

618: THEN
619: NULL;
620: END IF;
621:
622: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute9,p_old_Header_Scredit_rec.attribute9)
623: THEN
624: NULL;
625: END IF;
626:

Line 627: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.context,p_old_Header_Scredit_rec.context)

623: THEN
624: NULL;
625: END IF;
626:
627: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.context,p_old_Header_Scredit_rec.context)
628: THEN
629: NULL;
630: END IF;
631:

Line 632: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.created_by,p_old_Header_Scredit_rec.created_by)

628: THEN
629: NULL;
630: END IF;
631:
632: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.created_by,p_old_Header_Scredit_rec.created_by)
633: THEN
634: NULL;
635: END IF;
636:

Line 637: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.creation_date,p_old_Header_Scredit_rec.creation_date)

633: THEN
634: NULL;
635: END IF;
636:
637: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.creation_date,p_old_Header_Scredit_rec.creation_date)
638: THEN
639: NULL;
640: END IF;
641:

Line 642: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.dw_update_advice_flag,p_old_Header_Scredit_rec.dw_update_advice_flag)

638: THEN
639: NULL;
640: END IF;
641:
642: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.dw_update_advice_flag,p_old_Header_Scredit_rec.dw_update_advice_flag)
643: THEN
644: NULL;
645: END IF;
646:

Line 647: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.header_id,p_old_Header_Scredit_rec.header_id)

643: THEN
644: NULL;
645: END IF;
646:
647: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.header_id,p_old_Header_Scredit_rec.header_id)
648: THEN
649: NULL;
650: END IF;
651:

Line 652: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.last_updated_by,p_old_Header_Scredit_rec.last_updated_by)

648: THEN
649: NULL;
650: END IF;
651:
652: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.last_updated_by,p_old_Header_Scredit_rec.last_updated_by)
653: THEN
654: NULL;
655: END IF;
656:

Line 657: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.last_update_date,p_old_Header_Scredit_rec.last_update_date)

653: THEN
654: NULL;
655: END IF;
656:
657: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.last_update_date,p_old_Header_Scredit_rec.last_update_date)
658: THEN
659: NULL;
660: END IF;
661:

Line 662: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.last_update_login,p_old_Header_Scredit_rec.last_update_login)

658: THEN
659: NULL;
660: END IF;
661:
662: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.last_update_login,p_old_Header_Scredit_rec.last_update_login)
663: THEN
664: NULL;
665: END IF;
666:

Line 667: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.line_id,p_old_Header_Scredit_rec.line_id)

663: THEN
664: NULL;
665: END IF;
666:
667: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.line_id,p_old_Header_Scredit_rec.line_id)
668: THEN
669: NULL;
670: END IF;
671:

Line 672: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.percent,p_old_Header_Scredit_rec.percent)

668: THEN
669: NULL;
670: END IF;
671:
672: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.percent,p_old_Header_Scredit_rec.percent)
673: THEN
674: -- Add delayed request to validate quota percent sums up to 100
675: OE_Delayed_Requests_Pvt.Log_Request
676: (p_entity_code=>OE_GLOBALS.G_ENTITY_Header_Scredit

Line 676: (p_entity_code=>OE_GLOBALS.G_ENTITY_Header_Scredit

672: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.percent,p_old_Header_Scredit_rec.percent)
673: THEN
674: -- Add delayed request to validate quota percent sums up to 100
675: OE_Delayed_Requests_Pvt.Log_Request
676: (p_entity_code=>OE_GLOBALS.G_ENTITY_Header_Scredit
677: ,p_entity_id=>p_x_Header_Scredit_rec.sales_credit_id
678: , p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Header_Scredit
679: ,p_requesting_entity_id=>p_x_Header_Scredit_rec.sales_credit_id
680: ,p_request_type=>OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL

Line 678: , p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Header_Scredit

674: -- Add delayed request to validate quota percent sums up to 100
675: OE_Delayed_Requests_Pvt.Log_Request
676: (p_entity_code=>OE_GLOBALS.G_ENTITY_Header_Scredit
677: ,p_entity_id=>p_x_Header_Scredit_rec.sales_credit_id
678: , p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Header_Scredit
679: ,p_requesting_entity_id=>p_x_Header_Scredit_rec.sales_credit_id
680: ,p_request_type=>OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
681: ,p_param1 => to_char(p_x_Header_Scredit_rec.header_id)
682: ,x_return_status =>l_return_status);

Line 680: ,p_request_type=>OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL

676: (p_entity_code=>OE_GLOBALS.G_ENTITY_Header_Scredit
677: ,p_entity_id=>p_x_Header_Scredit_rec.sales_credit_id
678: , p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Header_Scredit
679: ,p_requesting_entity_id=>p_x_Header_Scredit_rec.sales_credit_id
680: ,p_request_type=>OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
681: ,p_param1 => to_char(p_x_Header_Scredit_rec.header_id)
682: ,x_return_status =>l_return_status);
683: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 690: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.sales_credit_type_id,p_old_Header_Scredit_rec.sales_credit_type_id)

686: RAISE FND_API.G_EXC_ERROR;
687: END IF;
688: END IF;
689:
690: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.sales_credit_type_id,p_old_Header_Scredit_rec.sales_credit_type_id)
691: THEN
692: -- Add delayed request to validate quota percent sums up to 100
693: OE_Delayed_Requests_Pvt.Log_Request
694: (p_entity_code=>OE_GLOBALS.G_ENTITY_Header_Scredit

Line 694: (p_entity_code=>OE_GLOBALS.G_ENTITY_Header_Scredit

690: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.sales_credit_type_id,p_old_Header_Scredit_rec.sales_credit_type_id)
691: THEN
692: -- Add delayed request to validate quota percent sums up to 100
693: OE_Delayed_Requests_Pvt.Log_Request
694: (p_entity_code=>OE_GLOBALS.G_ENTITY_Header_Scredit
695: ,p_entity_id=>p_x_Header_Scredit_rec.sales_credit_id
696: , p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Header_Scredit
697: ,p_requesting_entity_id=>p_x_Header_Scredit_rec.sales_credit_id
698: ,p_request_type=>OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL

Line 696: , p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Header_Scredit

692: -- Add delayed request to validate quota percent sums up to 100
693: OE_Delayed_Requests_Pvt.Log_Request
694: (p_entity_code=>OE_GLOBALS.G_ENTITY_Header_Scredit
695: ,p_entity_id=>p_x_Header_Scredit_rec.sales_credit_id
696: , p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Header_Scredit
697: ,p_requesting_entity_id=>p_x_Header_Scredit_rec.sales_credit_id
698: ,p_request_type=>OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
699: ,p_param1 => to_char(p_x_Header_Scredit_rec.header_id)
700: ,x_return_status =>l_return_status);

Line 698: ,p_request_type=>OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL

694: (p_entity_code=>OE_GLOBALS.G_ENTITY_Header_Scredit
695: ,p_entity_id=>p_x_Header_Scredit_rec.sales_credit_id
696: , p_requesting_entity_code=>OE_GLOBALS.G_ENTITY_Header_Scredit
697: ,p_requesting_entity_id=>p_x_Header_Scredit_rec.sales_credit_id
698: ,p_request_type=>OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
699: ,p_param1 => to_char(p_x_Header_Scredit_rec.header_id)
700: ,x_return_status =>l_return_status);
701: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 708: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.salesrep_id,p_old_Header_Scredit_rec.salesrep_id)

704: RAISE FND_API.G_EXC_ERROR;
705: END IF;
706: END IF;
707:
708: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.salesrep_id,p_old_Header_Scredit_rec.salesrep_id)
709: THEN
710: NULL;
711: --SG{
712:

Line 772: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.sales_credit_type_id,p_old_Header_Scredit_rec.sales_credit_type_id)

768: END IF;
769: --SG}
770:
771:
772: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.sales_credit_type_id,p_old_Header_Scredit_rec.sales_credit_type_id)
773: THEN
774: NULL;
775: END IF;
776:

Line 777: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.sales_credit_id,p_old_Header_Scredit_rec.sales_credit_id)

773: THEN
774: NULL;
775: END IF;
776:
777: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.sales_credit_id,p_old_Header_Scredit_rec.sales_credit_id)
778: THEN
779: NULL;
780: END IF;
781:

Line 782: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.wh_update_date,p_old_Header_Scredit_rec.wh_update_date)

778: THEN
779: NULL;
780: END IF;
781:
782: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.wh_update_date,p_old_Header_Scredit_rec.wh_update_date)
783: THEN
784: NULL;
785: END IF;
786:

Line 1350: l_new_header_scredit_rec.operation := OE_GLOBALS.G_OPR_DELETE;

1346: --added notification framework
1347: --check code release level first. Notification framework is at Pack H level
1348: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
1349: /* Set the operation on the record so that globals are updated as well */
1350: l_new_header_scredit_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1351: l_new_header_scredit_rec.sales_credit_id := l_scr.sales_credit_id;
1352:
1353: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
1354: p_Hdr_scr_rec =>l_new_header_scredit_rec,

Line 1382: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_SCREDIT,

1378: END IF; /*code_release_level*/
1379: -- notification framework end
1380:
1381: OE_Delayed_Requests_Pvt.Delete_Reqs_for_deleted_entity(
1382: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_SCREDIT,
1383: p_entity_id => l_scr.sales_credit_id,
1384: x_return_status => l_return_status
1385: );
1386: END LOOP;

Line 1400: l_new_header_scredit_rec.operation := OE_GLOBALS.G_OPR_DELETE;

1396: --added notification framework
1397: --check code release level first. Notification framework is at Pack H level
1398: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
1399: /* Set the operation on the record so that globals are updated as well */
1400: l_new_header_scredit_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1401: l_new_header_scredit_rec.sales_credit_id := p_sales_credit_id;
1402: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
1403: p_Hdr_scr_rec =>l_new_header_scredit_rec,
1404: p_hdr_scr_id => p_sales_credit_id,

Line 1432: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_SCREDIT,

1428: END IF; /*code_release_level*/
1429: -- notification framework end
1430:
1431: OE_Delayed_Requests_Pvt.Delete_Reqs_for_deleted_entity(
1432: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_SCREDIT,
1433: p_entity_id => p_sales_credit_id,
1434: x_return_status => l_return_status
1435: );
1436:

Line 1782: IF OE_GLOBALS.Equal(p_x_Header_Scredit_rec.lock_control,

1778:
1779: -- Row locked. If the whole record is passed, then
1780: -- Compare IN attributes to DB attributes.
1781:
1782: IF OE_GLOBALS.Equal(p_x_Header_Scredit_rec.lock_control,
1783: l_lock_control)
1784: THEN
1785:
1786: -- Row has not changed. Set out parameter.

Line 2007: NOT OE_GLOBALS.Equal(p_Header_Scredit_rec.salesrep_id,

2003: BEGIN
2004:
2005: IF (p_Header_Scredit_rec.salesrep_id IS NULL OR
2006: p_Header_Scredit_rec.salesrep_id <> FND_API.G_MISS_NUM) AND
2007: NOT OE_GLOBALS.Equal(p_Header_Scredit_rec.salesrep_id,
2008: p_old_Header_Scredit_rec.salesrep_id)
2009: THEN
2010: l_Header_Scredit_val_rec.salesrep := OE_Id_To_Value.Salesrep
2011: ( p_salesrep_id => p_Header_Scredit_rec.salesrep_id

Line 2017: NOT OE_GLOBALS.Equal(p_Header_Scredit_rec.sales_credit_type_id,

2013: END IF;
2014:
2015: IF (p_Header_Scredit_rec.sales_credit_type_id IS NULL OR
2016: p_Header_Scredit_rec.sales_credit_type_id <> FND_API.G_MISS_NUM) AND
2017: NOT OE_GLOBALS.Equal(p_Header_Scredit_rec.sales_credit_type_id,
2018: p_old_Header_Scredit_rec.sales_credit_type_id)
2019: THEN
2020: l_Header_Scredit_val_rec.sales_credit_type := OE_Id_To_Value.sales_credit_type
2021: ( p_sales_credit_type_id => p_Header_Scredit_rec.sales_credit_type_id

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

2141: BEGIN
2142:
2143: --11.5.10 Versioning/Audit Trail updates
2144: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
2145: OE_GLOBALS.G_ROLL_VERSION <> 'N' THEN
2146: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
2147: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
2148: IF p_x_header_scredit_rec.change_reason <> FND_API.G_MISS_CHAR THEN
2149: OE_GLOBALS.G_REASON_CODE := p_x_header_scredit_rec.change_reason;

Line 2146: IF OE_GLOBALS.G_REASON_CODE IS NULL AND

2142:
2143: --11.5.10 Versioning/Audit Trail updates
2144: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
2145: OE_GLOBALS.G_ROLL_VERSION <> 'N' THEN
2146: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
2147: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
2148: IF p_x_header_scredit_rec.change_reason <> FND_API.G_MISS_CHAR THEN
2149: OE_GLOBALS.G_REASON_CODE := p_x_header_scredit_rec.change_reason;
2150: OE_GLOBALS.G_REASON_COMMENTS := p_x_header_scredit_rec.change_comments;

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

2143: --11.5.10 Versioning/Audit Trail updates
2144: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
2145: OE_GLOBALS.G_ROLL_VERSION <> 'N' THEN
2146: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
2147: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
2148: IF p_x_header_scredit_rec.change_reason <> FND_API.G_MISS_CHAR THEN
2149: OE_GLOBALS.G_REASON_CODE := p_x_header_scredit_rec.change_reason;
2150: OE_GLOBALS.G_REASON_COMMENTS := p_x_header_scredit_rec.change_comments;
2151: OE_GLOBALS.G_CAPTURED_REASON := 'Y';

Line 2149: OE_GLOBALS.G_REASON_CODE := p_x_header_scredit_rec.change_reason;

2145: OE_GLOBALS.G_ROLL_VERSION <> 'N' THEN
2146: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
2147: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
2148: IF p_x_header_scredit_rec.change_reason <> FND_API.G_MISS_CHAR THEN
2149: OE_GLOBALS.G_REASON_CODE := p_x_header_scredit_rec.change_reason;
2150: OE_GLOBALS.G_REASON_COMMENTS := p_x_header_scredit_rec.change_comments;
2151: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
2152: ELSE
2153: IF l_debug_level > 0 THEN

Line 2150: OE_GLOBALS.G_REASON_COMMENTS := p_x_header_scredit_rec.change_comments;

2146: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
2147: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
2148: IF p_x_header_scredit_rec.change_reason <> FND_API.G_MISS_CHAR THEN
2149: OE_GLOBALS.G_REASON_CODE := p_x_header_scredit_rec.change_reason;
2150: OE_GLOBALS.G_REASON_COMMENTS := p_x_header_scredit_rec.change_comments;
2151: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
2152: ELSE
2153: IF l_debug_level > 0 THEN
2154: OE_DEBUG_PUB.add('Reason code missing for versioning', 1);

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

2147: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
2148: IF p_x_header_scredit_rec.change_reason <> FND_API.G_MISS_CHAR THEN
2149: OE_GLOBALS.G_REASON_CODE := p_x_header_scredit_rec.change_reason;
2150: OE_GLOBALS.G_REASON_COMMENTS := p_x_header_scredit_rec.change_comments;
2151: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
2152: ELSE
2153: IF l_debug_level > 0 THEN
2154: OE_DEBUG_PUB.add('Reason code missing for versioning', 1);
2155: END IF;

Line 2156: IF OE_GLOBALS.G_UI_FLAG THEN

2152: ELSE
2153: IF l_debug_level > 0 THEN
2154: OE_DEBUG_PUB.add('Reason code missing for versioning', 1);
2155: END IF;
2156: IF OE_GLOBALS.G_UI_FLAG THEN
2157: raise FND_API.G_EXC_ERROR;
2158: END IF;
2159: END IF;
2160: END IF;

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

2162: --log delayed request
2163: IF l_debug_level > 0 THEN
2164: oe_debug_pub.add('log versioning request',1);
2165: END IF;
2166: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2167: p_entity_id => p_x_header_scredit_rec.header_id,
2168: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_SCREDIT,
2169: p_requesting_entity_id => p_x_header_scredit_rec.sales_credit_id,
2170: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,

Line 2168: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_SCREDIT,

2164: oe_debug_pub.add('log versioning request',1);
2165: END IF;
2166: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2167: p_entity_id => p_x_header_scredit_rec.header_id,
2168: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_SCREDIT,
2169: p_requesting_entity_id => p_x_header_scredit_rec.sales_credit_id,
2170: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
2171: x_return_status => l_return_status);
2172: END IF;

Line 2170: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,

2166: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2167: p_entity_id => p_x_header_scredit_rec.header_id,
2168: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_SCREDIT,
2169: p_requesting_entity_id => p_x_header_scredit_rec.sales_credit_id,
2170: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
2171: x_return_status => l_return_status);
2172: END IF;
2173:
2174: IF (p_x_header_scredit_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN

Line 2174: IF (p_x_header_scredit_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN

2170: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
2171: x_return_status => l_return_status);
2172: END IF;
2173:
2174: IF (p_x_header_scredit_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
2175:
2176: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN
2177: IF l_debug_level > 0 THEN
2178: oe_debug_pub.add( 'AUDIT TRAIL , CHANGE ATTRIBUTE REQUIRES REASON' , 1 ) ;

Line 2176: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN

2172: END IF;
2173:
2174: IF (p_x_header_scredit_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
2175:
2176: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN
2177: IF l_debug_level > 0 THEN
2178: oe_debug_pub.add( 'AUDIT TRAIL , CHANGE ATTRIBUTE REQUIRES REASON' , 1 ) ;
2179: END IF;
2180: IF (p_x_header_scredit_rec.change_reason IS NULL OR

Line 2184: IF OE_GLOBALS.G_DEFAULT_REASON THEN

2180: IF (p_x_header_scredit_rec.change_reason IS NULL OR
2181: p_x_header_scredit_rec.change_reason = FND_API.G_MISS_CHAR OR
2182: NOT OE_Validate.Change_Reason_Code(p_x_header_scredit_rec.change_reason)) THEN
2183: -- bug 3636884, defaulting reason from group API
2184: IF OE_GLOBALS.G_DEFAULT_REASON THEN
2185: if l_debug_level > 0 then
2186: oe_debug_pub.add('Defaulting Audit Reason for Order Sales Credit', 1);
2187: end if;
2188: p_x_header_scredit_rec.change_reason := 'SYSTEM';

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

2196: raise FND_API.G_EXC_ERROR;
2197: END IF;
2198: END IF;
2199: END IF;
2200: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' OR
2201: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG = 'Y' THEN
2202: IF l_debug_level > 0 THEN
2203: oe_debug_pub.add( 'OEXUHSCB:Calling oe_order_chg_pvt.recordhscredithist') ;
2204: END IF;

Line 2201: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG = 'Y' THEN

2197: END IF;
2198: END IF;
2199: END IF;
2200: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' OR
2201: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG = 'Y' THEN
2202: IF l_debug_level > 0 THEN
2203: oe_debug_pub.add( 'OEXUHSCB:Calling oe_order_chg_pvt.recordhscredithist') ;
2204: END IF;
2205: --11.5.10 Versioning/Audit Trail updates

Line 2207: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_SCREDIT,

2203: oe_debug_pub.add( 'OEXUHSCB:Calling oe_order_chg_pvt.recordhscredithist') ;
2204: END IF;
2205: --11.5.10 Versioning/Audit Trail updates
2206: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
2207: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_SCREDIT,
2208: p_entity_id => p_x_header_scredit_rec.sales_credit_id,
2209: p_hist_type_code => 'UPDATE');
2210: --log delayed request
2211: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

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

2207: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_SCREDIT,
2208: p_entity_id => p_x_header_scredit_rec.sales_credit_id,
2209: p_hist_type_code => 'UPDATE');
2210: --log delayed request
2211: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2212: p_entity_id => p_x_header_scredit_rec.header_id,
2213: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_SCREDIT,
2214: p_requesting_entity_id => p_x_header_scredit_rec.sales_credit_id,
2215: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,

Line 2213: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_SCREDIT,

2209: p_hist_type_code => 'UPDATE');
2210: --log delayed request
2211: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2212: p_entity_id => p_x_header_scredit_rec.header_id,
2213: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_SCREDIT,
2214: p_requesting_entity_id => p_x_header_scredit_rec.sales_credit_id,
2215: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
2216: x_return_status => l_return_status);
2217:

Line 2215: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,

2211: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2212: p_entity_id => p_x_header_scredit_rec.header_id,
2213: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_SCREDIT,
2214: p_requesting_entity_id => p_x_header_scredit_rec.sales_credit_id,
2215: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
2216: x_return_status => l_return_status);
2217:
2218: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
2219: ELSE

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

2214: p_requesting_entity_id => p_x_header_scredit_rec.sales_credit_id,
2215: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
2216: x_return_status => l_return_status);
2217:
2218: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
2219: ELSE
2220: OE_CHG_ORDER_PVT.RecordHScreditHist
2221: (p_header_scredit_id => p_x_header_scredit_rec.sales_credit_id,
2222: p_header_scredit_rec => null,

Line 2320: l_control_rec OE_GLOBALS.Control_Rec_Type;

2316: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2317: l_old_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2318: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2319: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2320: l_control_rec OE_GLOBALS.Control_Rec_Type;
2321: l_return_status VARCHAR2(30);
2322: x_msg_count NUMBER;
2323: x_msg_data VARCHAR2(2000);
2324: l_header_id NUMBER;

Line 2390: l_Header_Scredit_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;

2386:
2387: l_Header_Scredit_tbl(1) := l_Header_Scredit_rec;
2388:
2389: -- Set Operation. to update existing row
2390: l_Header_Scredit_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
2391:
2392: l_old_Header_Scredit_tbl := l_Header_Scredit_tbl;
2393:
2394: -- Update the row with new sales rep

Line 2433: l_Header_Scredit_rec.operation := OE_GLOBALS.G_OPR_CREATE;

2429: l_control_rec.clear_api_cache := FALSE;
2430: l_control_rec.clear_api_requests := FALSE;
2431:
2432: l_Header_Scredit_rec := OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC;
2433: l_Header_Scredit_rec.operation := OE_GLOBALS.G_OPR_CREATE;
2434: l_Header_Scredit_rec.Header_id := p_header_id;
2435: l_Header_Scredit_rec.SalesRep_Id := p_salesrep_id;
2436: l_Header_Scredit_rec.Sales_credit_type_id := l_scredit_type_id;
2437:

Line 2439: --G_ACTIVATE_ORCL_CUSTOMIZATION = 'Y' and OE_GLOBALS.G_UI_FLAG Then

2435: l_Header_Scredit_rec.SalesRep_Id := p_salesrep_id;
2436: l_Header_Scredit_rec.Sales_credit_type_id := l_scredit_type_id;
2437:
2438: --code removed under direction from jgould. Oralce It has cancel this project
2439: --G_ACTIVATE_ORCL_CUSTOMIZATION = 'Y' and OE_GLOBALS.G_UI_FLAG Then
2440: --l_Header_Scredit_rec.percent := 0;
2441: --Else
2442: l_Header_Scredit_rec.percent := 100;
2443: --End If;

Line 2453: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';

2449: -- at this stage its either a insert or update
2450: -- Call OE_Order_PVT.Process_order
2451:
2452: -- Set recursion mode.
2453: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';
2454:
2455: OE_ORDER_PVT.Header_Scredits
2456: (p_validation_level => FND_API.G_VALID_LEVEL_FULL
2457: ,p_control_rec => l_control_rec

Line 2463: -- OE_GLOBALS.G_RECURSION_MODE := 'N';

2459: ,p_x_old_Header_Scredit_tbl => l_old_Header_Scredit_tbl
2460: ,x_return_status => l_return_status);
2461:
2462: -- Reset recursion mode.
2463: -- OE_GLOBALS.G_RECURSION_MODE := 'N';
2464:
2465: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2467: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2529: G_ORG_ID := OE_GLOBALS.G_ORG_ID;

2525: Begin
2526: x_return_status:=FND_API.G_RET_STS_SUCCESS;
2527:
2528:
2529: G_ORG_ID := OE_GLOBALS.G_ORG_ID;
2530:
2531: IF G_ORG_ID IS NULL THEN
2532: oe_debug_pub.add('OE_GLOBALS.G_ORG_ID IS null');
2533: END IF;

Line 2532: oe_debug_pub.add('OE_GLOBALS.G_ORG_ID IS null');

2528:
2529: G_ORG_ID := OE_GLOBALS.G_ORG_ID;
2530:
2531: IF G_ORG_ID IS NULL THEN
2532: oe_debug_pub.add('OE_GLOBALS.G_ORG_ID IS null');
2533: END IF;
2534:
2535: Begin
2536: x_sales_group_id:=jtf_rs_integration_pub.get_default_sales_group(p_sales_rep_id,g_org_id,p_date);

Line 2562: l_sales_credit_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;

2558: From OE_SALES_CREDITS
2559: Where Sales_Group_Updated_Flag = 'N'
2560: And header_id = p_header_id;
2561:
2562: l_sales_credit_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
2563: l_sales_group_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
2564:
2565: j number:=1;
2566: l_status Varchar2(30);

Line 2563: l_sales_group_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;

2559: Where Sales_Group_Updated_Flag = 'N'
2560: And header_id = p_header_id;
2561:
2562: l_sales_credit_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
2563: l_sales_group_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
2564:
2565: j number:=1;
2566: l_status Varchar2(30);
2567: l_sales_group_id Number;