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_OTA_UTIL dependencies on OE_GLOBALS

Line 71: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN

67:
68: --IF Get_Product_Status(810) IN ('I','S') THEN
69:
70: -- lkxu, for bug 1701377
71: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN
72: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);
73: END IF;
74:
75: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN

Line 72: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);

68: --IF Get_Product_Status(810) IN ('I','S') THEN
69:
70: -- lkxu, for bug 1701377
71: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN
72: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);
73: END IF;
74:
75: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN
76:

Line 75: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN

71: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN
72: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);
73: END IF;
74:
75: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN
76:
77: -- Call the OTA API
78: l_sql_stat := '
79: Begin

Line 172: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN

168: END IF;
169: -- IF Get_Product_Status(810) IN ('I','S') THEN
170:
171: -- lkxu, for bug 1701377
172: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN
173: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);
174: END IF;
175:
176: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN

Line 173: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);

169: -- IF Get_Product_Status(810) IN ('I','S') THEN
170:
171: -- lkxu, for bug 1701377
172: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN
173: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);
174: END IF;
175:
176: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN
177:

Line 176: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN

172: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN
173: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);
174: END IF;
175:
176: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN
177:
178: -- Call the OTA Enrollment status checking API
179:
180: l_sql_stat := '

Line 246: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN

242: END IF;
243: -- IF Get_Product_Status(810) IN ('I','S') THEN
244:
245: -- lkxu, for bug 1701377
246: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN
247: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);
248: END IF;
249:
250: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN

Line 247: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);

243: -- IF Get_Product_Status(810) IN ('I','S') THEN
244:
245: -- lkxu, for bug 1701377
246: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN
247: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);
248: END IF;
249:
250: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN
251:

Line 250: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN

246: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN
247: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);
248: END IF;
249:
250: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN
251:
252: -- Call the OTA Event status checking API
253:
254: l_sql_stat := '

Line 324: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN

320: END IF;
321: -- IF Get_Product_Status(810) IN ('I','S') THEN
322:
323: -- lkxu, for bug 1701377
324: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN
325: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);
326: END IF;
327:
328: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN

Line 325: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);

321: -- IF Get_Product_Status(810) IN ('I','S') THEN
322:
323: -- lkxu, for bug 1701377
324: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN
325: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);
326: END IF;
327:
328: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN
329:

Line 328: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN

324: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN
325: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);
326: END IF;
327:
328: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN
329:
330: -- Call the OTA API to get the item description to be interfaced
331: -- with AR. The OTA API will also return the sourse end date that will
332: -- need to be interfaced with AR as GL date.

Line 493: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN

489: END IF;
490: -- IF Get_Product_Status(810) IN ('I','S') THEN
491:
492: -- lkxu, for bug 1701377
493: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN
494: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);
495: END IF;
496:
497: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN

Line 494: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);

490: -- IF Get_Product_Status(810) IN ('I','S') THEN
491:
492: -- lkxu, for bug 1701377
493: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN
494: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);
495: END IF;
496:
497: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN
498:

Line 497: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN

493: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN
494: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);
495: END IF;
496:
497: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN
498:
499: -- Call the OTA API to create enrollment
500:
501: l_sql_stat := '

Line 580: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN

576: IF l_debug_level > 0 THEN
577: oe_debug_pub.add( 'ENTERING GET_OTA_EVENT_END_DATE' , 1 ) ;
578: END IF;
579:
580: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN
581: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);
582: END IF;
583:
584: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN

Line 581: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);

577: oe_debug_pub.add( 'ENTERING GET_OTA_EVENT_END_DATE' , 1 ) ;
578: END IF;
579:
580: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN
581: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);
582: END IF;
583:
584: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN
585:

Line 584: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN

580: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN
581: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);
582: END IF;
583:
584: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN
585:
586: l_sql_stat := '
587: Begin
588: OTA_OM_UTIL.Get_Event_Detail(