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.IBY_BEPINFO_PKG dependencies on FND_API

Line 207: -- This wrapper version is to handle FND_API.G_MISS_XXX

203:
204:
205:
206:
207: -- This wrapper version is to handle FND_API.G_MISS_XXX
208: -- Note the validation in createBEPInfo() is not enough
209: -- We should add more to it later. No validation is done
210: -- in this wrapper.
211: -- FZ 5/20/02

Line 266: IF l_bepname = FND_API.G_MISS_CHAR THEN

262:
263: begin
264:
265: l_bepname := i_bepname;
266: IF l_bepname = FND_API.G_MISS_CHAR THEN
267: l_bepname := NULL;
268: END IF;
269:
270: l_bepurl := i_bepurl;

Line 271: IF l_bepurl = FND_API.G_MISS_CHAR THEN

267: l_bepname := NULL;
268: END IF;
269:
270: l_bepurl := i_bepurl;
271: IF l_bepurl = FND_API.G_MISS_CHAR THEN
272: l_bepurl := NULL;
273: END IF;
274:
275: l_bepsuffix := i_bepsuffix;

Line 276: IF l_bepsuffix = FND_API.G_MISS_CHAR THEN

272: l_bepurl := NULL;
273: END IF;
274:
275: l_bepsuffix := i_bepsuffix;
276: IF l_bepsuffix = FND_API.G_MISS_CHAR THEN
277: l_bepsuffix := NULL;
278: END IF;
279:
280: l_bep_type := i_bep_type;

Line 281: IF l_bep_type = FND_API.G_MISS_CHAR THEN

277: l_bepsuffix := NULL;
278: END IF;
279:
280: l_bep_type := i_bep_type;
281: IF l_bep_type = FND_API.G_MISS_CHAR THEN
282: l_bep_type := NULL;
283: END IF;
284:
285: l_bepusername := i_bepusername;

Line 286: IF l_bepusername = FND_API.G_MISS_CHAR THEN

282: l_bep_type := NULL;
283: END IF;
284:
285: l_bepusername := i_bepusername;
286: IF l_bepusername = FND_API.G_MISS_CHAR THEN
287: l_bepusername := NULL;
288: END IF;
289:
290: l_beppassword := i_beppassword;

Line 291: IF l_beppassword = FND_API.G_MISS_CHAR THEN

287: l_bepusername := NULL;
288: END IF;
289:
290: l_beppassword := i_beppassword;
291: IF l_beppassword = FND_API.G_MISS_CHAR THEN
292: l_beppassword := NULL;
293: END IF;
294:
295: l_psusername := i_psusername;

Line 296: IF l_psusername = FND_API.G_MISS_CHAR THEN

292: l_beppassword := NULL;
293: END IF;
294:
295: l_psusername := i_psusername;
296: IF l_psusername = FND_API.G_MISS_CHAR THEN
297: l_psusername := NULL;
298: END IF;
299:
300: l_pspassword := i_pspassword;

Line 301: IF l_pspassword = FND_API.G_MISS_CHAR THEN

297: l_psusername := NULL;
298: END IF;
299:
300: l_pspassword := i_pspassword;
301: IF l_pspassword = FND_API.G_MISS_CHAR THEN
302: l_pspassword := NULL;
303: END IF;
304:
305: l_adminurl := i_adminurl;

Line 306: IF l_adminurl = FND_API.G_MISS_CHAR THEN

302: l_pspassword := NULL;
303: END IF;
304:
305: l_adminurl := i_adminurl;
306: IF l_adminurl = FND_API.G_MISS_CHAR THEN
307: l_adminurl := NULL;
308: END IF;
309:
310: l_login := i_login;

Line 311: IF l_login = FND_API.G_MISS_CHAR THEN

307: l_adminurl := NULL;
308: END IF;
309:
310: l_login := i_login;
311: IF l_login = FND_API.G_MISS_CHAR THEN
312: l_login := NULL;
313: END IF;
314:
315: l_logout := i_logout;

Line 316: IF l_logout = FND_API.G_MISS_CHAR THEN

312: l_login := NULL;
313: END IF;
314:
315: l_logout := i_logout;
316: IF l_logout = FND_API.G_MISS_CHAR THEN
317: l_logout := NULL;
318: END IF;
319:
320: l_supportedop := i_supportedop;

Line 321: IF l_supportedop = FND_API.G_MISS_NUM THEN

317: l_logout := NULL;
318: END IF;
319:
320: l_supportedop := i_supportedop;
321: IF l_supportedop = FND_API.G_MISS_NUM THEN
322: l_supportedop := NULL;
323: END IF;
324:
325: l_leadtime := i_leadtime;

Line 326: IF l_leadtime = FND_API.G_MISS_NUM THEN

322: l_supportedop := NULL;
323: END IF;
324:
325: l_leadtime := i_leadtime;
326: IF l_leadtime = FND_API.G_MISS_NUM THEN
327: l_leadtime := NULL;
328: END IF;
329:
330: l_srvrIdImmed := i_srvrIdImmed;

Line 331: IF l_srvrIdImmed = FND_API.G_MISS_CHAR THEN

327: l_leadtime := NULL;
328: END IF;
329:
330: l_srvrIdImmed := i_srvrIdImmed;
331: IF l_srvrIdImmed = FND_API.G_MISS_CHAR THEN
332: l_srvrIdImmed := NULL;
333: END IF;
334:
335: l_holidayfile := i_holidayfile;

Line 336: IF l_holidayfile = FND_API.G_MISS_CHAR THEN

332: l_srvrIdImmed := NULL;
333: END IF;
334:
335: l_holidayfile := i_holidayfile;
336: IF l_holidayfile = FND_API.G_MISS_CHAR THEN
337: l_holidayfile := NULL;
338: END IF;
339:
340: l_fileSupport := i_fileSupport;

Line 341: IF l_fileSupport = FND_API.G_MISS_CHAR THEN

337: l_holidayfile := NULL;
338: END IF;
339:
340: l_fileSupport := i_fileSupport;
341: IF l_fileSupport = FND_API.G_MISS_CHAR THEN
342: l_fileSupport := NULL;
343: END IF;
344:
345: l_activestatus := i_activestatus;

Line 346: IF l_activestatus = FND_API.G_MISS_CHAR THEN

342: l_fileSupport := NULL;
343: END IF;
344:
345: l_activestatus := i_activestatus;
346: IF l_activestatus = FND_API.G_MISS_CHAR THEN
347: l_activestatus := NULL;
348: END IF;
349:
350: l_securityscheme := i_securityscheme;

Line 351: IF l_securityscheme = FND_API.G_MISS_NUM THEN

347: l_activestatus := NULL;
348: END IF;
349:
350: l_securityscheme := i_securityscheme;
351: IF l_securityscheme = FND_API.G_MISS_NUM THEN
352: l_securityscheme := NULL;
353: END IF;
354:
355: l_partyid := i_partyid;

Line 356: IF l_partyid = FND_API.G_MISS_NUM THEN

352: l_securityscheme := NULL;
353: END IF;
354:
355: l_partyid := i_partyid;
356: IF l_partyid = FND_API.G_MISS_NUM THEN
357: l_partyid := NULL;
358: END IF;
359:
360: l_preNLSLang := i_preNLSLang;

Line 361: IF l_preNLSLang = FND_API.G_MISS_CHAR THEN

357: l_partyid := NULL;
358: END IF;
359:
360: l_preNLSLang := i_preNLSLang;
361: IF l_preNLSLang = FND_API.G_MISS_CHAR THEN
362: l_preNLSLang := NULL;
363: END IF;
364:
365: l_opt1NLSLang := i_opt1NLSLang;

Line 366: IF l_opt1NLSLang = FND_API.G_MISS_CHAR THEN

362: l_preNLSLang := NULL;
363: END IF;
364:
365: l_opt1NLSLang := i_opt1NLSLang;
366: IF l_opt1NLSLang = FND_API.G_MISS_CHAR THEN
367: l_opt1NLSLang := NULL;
368: END IF;
369:
370: l_opt2NLSLang := i_opt2NLSLang;

Line 371: IF l_opt2NLSLang = FND_API.G_MISS_CHAR THEN

367: l_opt1NLSLang := NULL;
368: END IF;
369:
370: l_opt2NLSLang := i_opt2NLSLang;
371: IF l_opt2NLSLang = FND_API.G_MISS_CHAR THEN
372: l_opt2NLSLang := NULL;
373: END IF;
374:
375: IF io_bepid = FND_API.G_MISS_NUM THEN

Line 375: IF io_bepid = FND_API.G_MISS_NUM THEN

371: IF l_opt2NLSLang = FND_API.G_MISS_CHAR THEN
372: l_opt2NLSLang := NULL;
373: END IF;
374:
375: IF io_bepid = FND_API.G_MISS_NUM THEN
376: io_bepid := NULL;
377: END IF;
378:
379: -- forward the call to the base API

Line 527: -- to handle FND_API.G_MISS_XXX

523:
524:
525:
526: -- This is similar to modBEPInfo(), however we add code to
527: -- to handle FND_API.G_MISS_XXX
528: -- As we add this as a new independent API, we also add the
529: -- missing param for IBY_BEPINFO.INSTRTYPE
530: -- FZ 5/20/02
531: procedure update_BEPInfo(

Line 563: -- bepid must not be null or FND_API.G_MISS_NUM

559: l_api_name CONSTANT VARCHAR2(30) := 'update_BEPInfo';
560:
561: begin
562:
563: -- bepid must not be null or FND_API.G_MISS_NUM
564: IF (i_bepid IS NULL) OR (i_bepid = FND_API.G_MISS_NUM) THEN
565: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');
566: fnd_message.set_token('API', g_pkg_name || '.' || l_api_name);
567: fnd_message.set_token('PARAM', 'i_bepid: ' || i_bepid);

Line 564: IF (i_bepid IS NULL) OR (i_bepid = FND_API.G_MISS_NUM) THEN

560:
561: begin
562:
563: -- bepid must not be null or FND_API.G_MISS_NUM
564: IF (i_bepid IS NULL) OR (i_bepid = FND_API.G_MISS_NUM) THEN
565: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');
566: fnd_message.set_token('API', g_pkg_name || '.' || l_api_name);
567: fnd_message.set_token('PARAM', 'i_bepid: ' || i_bepid);
568: fnd_message.set_token('REASON', 'Incorrect param value');

Line 571: RAISE FND_API.G_EXC_ERROR;

567: fnd_message.set_token('PARAM', 'i_bepid: ' || i_bepid);
568: fnd_message.set_token('REASON', 'Incorrect param value');
569: fnd_msg_pub.add;
570:
571: RAISE FND_API.G_EXC_ERROR;
572: END IF;
573:
574: -- object_version_number must not be null or FND_API.G_MISS_NUM
575: -- for update API

Line 574: -- object_version_number must not be null or FND_API.G_MISS_NUM

570:
571: RAISE FND_API.G_EXC_ERROR;
572: END IF;
573:
574: -- object_version_number must not be null or FND_API.G_MISS_NUM
575: -- for update API
576: IF (i_object_version IS NULL) OR (i_object_version = FND_API.G_MISS_NUM) THEN
577: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');
578: fnd_message.set_token('API', g_pkg_name || '.' || l_api_name);

Line 576: IF (i_object_version IS NULL) OR (i_object_version = FND_API.G_MISS_NUM) THEN

572: END IF;
573:
574: -- object_version_number must not be null or FND_API.G_MISS_NUM
575: -- for update API
576: IF (i_object_version IS NULL) OR (i_object_version = FND_API.G_MISS_NUM) THEN
577: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');
578: fnd_message.set_token('API', g_pkg_name || '.' || l_api_name);
579: fnd_message.set_token('PARAM', 'i_object_version: ' || i_object_version);
580: fnd_message.set_token('REASON', 'Incorrect param value');

Line 583: RAISE FND_API.G_EXC_ERROR;

579: fnd_message.set_token('PARAM', 'i_object_version: ' || i_object_version);
580: fnd_message.set_token('REASON', 'Incorrect param value');
581: fnd_msg_pub.add;
582:
583: RAISE FND_API.G_EXC_ERROR;
584: END IF;
585:
586:
587: -- check for the bep name/suffix uniqueness before update

Line 594: -- FND_API.G_MISS_CHAR for these mandatory columns

590: -- clear error messages
591:
592: -- these validation are still valid, keep them
593: -- however they are incomplete - they do not check against
594: -- FND_API.G_MISS_CHAR for these mandatory columns
595: -- we will add additional checks below
596: -- FZ 5/20/02
597: if (bepNameExists(i_bepname, i_bepid)) then
598: --raise_application_error(-20524, 'BEP name already exists...',FALSE);

Line 608: -- by the new App standard, if input is FND_API.G_MISS_CHAR

604: --raise_application_error(-20525, 'Suffix already exists...',FALSE);
605: end if;
606:
607:
608: -- by the new App standard, if input is FND_API.G_MISS_CHAR
609: -- in update API, it means the caller wants to set the field
610: -- to null. However IBY_BEPINFO.NAME is a not null column
611: -- note it's ok for the input param to be null. In that case
612: -- the existing value in db is retained

Line 613: IF i_bepname = FND_API.G_MISS_CHAR THEN

609: -- in update API, it means the caller wants to set the field
610: -- to null. However IBY_BEPINFO.NAME is a not null column
611: -- note it's ok for the input param to be null. In that case
612: -- the existing value in db is retained
613: IF i_bepname = FND_API.G_MISS_CHAR THEN
614: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');
615: fnd_message.set_token('API', g_pkg_name || '.' || l_api_name);
616: fnd_message.set_token('PARAM', 'i_bepname: FND_API.G_MISS_CHAR');
617: fnd_message.set_token('REASON', 'Incorrect param value');

Line 616: fnd_message.set_token('PARAM', 'i_bepname: FND_API.G_MISS_CHAR');

612: -- the existing value in db is retained
613: IF i_bepname = FND_API.G_MISS_CHAR THEN
614: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');
615: fnd_message.set_token('API', g_pkg_name || '.' || l_api_name);
616: fnd_message.set_token('PARAM', 'i_bepname: FND_API.G_MISS_CHAR');
617: fnd_message.set_token('REASON', 'Incorrect param value');
618: fnd_msg_pub.add;
619:
620: RAISE FND_API.G_EXC_ERROR;

Line 620: RAISE FND_API.G_EXC_ERROR;

616: fnd_message.set_token('PARAM', 'i_bepname: FND_API.G_MISS_CHAR');
617: fnd_message.set_token('REASON', 'Incorrect param value');
618: fnd_msg_pub.add;
619:
620: RAISE FND_API.G_EXC_ERROR;
621: END IF;
622:
623: -- by the new App standard, if input is FND_API.G_MISS_CHAR
624: -- in update API, it means the caller wants to set the field

Line 623: -- by the new App standard, if input is FND_API.G_MISS_CHAR

619:
620: RAISE FND_API.G_EXC_ERROR;
621: END IF;
622:
623: -- by the new App standard, if input is FND_API.G_MISS_CHAR
624: -- in update API, it means the caller wants to set the field
625: -- to null. However IBY_BEPINFO.SUFFIX is a not null column
626: -- note it's ok for the input param to be null. In that case
627: -- the existing value in db is retained

Line 628: IF i_bepsuffix = FND_API.G_MISS_CHAR THEN

624: -- in update API, it means the caller wants to set the field
625: -- to null. However IBY_BEPINFO.SUFFIX is a not null column
626: -- note it's ok for the input param to be null. In that case
627: -- the existing value in db is retained
628: IF i_bepsuffix = FND_API.G_MISS_CHAR THEN
629: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');
630: fnd_message.set_token('API', g_pkg_name || '.' || l_api_name);
631: fnd_message.set_token('PARAM', 'i_bepsuffix: FND_API.G_MISS_CHAR');
632: fnd_message.set_token('REASON', 'Incorrect param value');

Line 631: fnd_message.set_token('PARAM', 'i_bepsuffix: FND_API.G_MISS_CHAR');

627: -- the existing value in db is retained
628: IF i_bepsuffix = FND_API.G_MISS_CHAR THEN
629: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');
630: fnd_message.set_token('API', g_pkg_name || '.' || l_api_name);
631: fnd_message.set_token('PARAM', 'i_bepsuffix: FND_API.G_MISS_CHAR');
632: fnd_message.set_token('REASON', 'Incorrect param value');
633: fnd_msg_pub.add;
634:
635: RAISE FND_API.G_EXC_ERROR;

Line 635: RAISE FND_API.G_EXC_ERROR;

631: fnd_message.set_token('PARAM', 'i_bepsuffix: FND_API.G_MISS_CHAR');
632: fnd_message.set_token('REASON', 'Incorrect param value');
633: fnd_msg_pub.add;
634:
635: RAISE FND_API.G_EXC_ERROR;
636: END IF;
637:
638:
639: -- update the row that matches the bepid;

Line 644: bepusername = DECODE(i_bepusername, NULL, bepusername, FND_API.G_MISS_CHAR, NULL, i_bepusername),

640: -- should use OVN based locking
641: UPDATE IBY_BEPINFO SET
642: name = DECODE(i_bepname, NULL, name, i_bepname),
643: suffix = DECODE(i_bepsuffix, NULL, suffix, i_bepsuffix),
644: bepusername = DECODE(i_bepusername, NULL, bepusername, FND_API.G_MISS_CHAR, NULL, i_bepusername),
645: beppassword = DECODE(i_beppassword, NULL, beppassword, FND_API.G_MISS_CHAR, NULL, i_beppassword),
646: psusername = DECODE(i_psusername, NULL, psusername, FND_API.G_MISS_CHAR, NULL, i_psusername),
647: pspassword = DECODE(i_pspassword, NULL, pspassword, FND_API.G_MISS_CHAR, NULL, i_pspassword),
648: baseurl = DECODE(i_bepurl, NULL, baseurl, FND_API.G_MISS_CHAR, NULL, i_bepurl),

Line 645: beppassword = DECODE(i_beppassword, NULL, beppassword, FND_API.G_MISS_CHAR, NULL, i_beppassword),

641: UPDATE IBY_BEPINFO SET
642: name = DECODE(i_bepname, NULL, name, i_bepname),
643: suffix = DECODE(i_bepsuffix, NULL, suffix, i_bepsuffix),
644: bepusername = DECODE(i_bepusername, NULL, bepusername, FND_API.G_MISS_CHAR, NULL, i_bepusername),
645: beppassword = DECODE(i_beppassword, NULL, beppassword, FND_API.G_MISS_CHAR, NULL, i_beppassword),
646: psusername = DECODE(i_psusername, NULL, psusername, FND_API.G_MISS_CHAR, NULL, i_psusername),
647: pspassword = DECODE(i_pspassword, NULL, pspassword, FND_API.G_MISS_CHAR, NULL, i_pspassword),
648: baseurl = DECODE(i_bepurl, NULL, baseurl, FND_API.G_MISS_CHAR, NULL, i_bepurl),
649: bep_type = DECODE(i_bep_type, NULL, bep_type, FND_API.G_MISS_CHAR, NULL, i_bep_type),

Line 646: psusername = DECODE(i_psusername, NULL, psusername, FND_API.G_MISS_CHAR, NULL, i_psusername),

642: name = DECODE(i_bepname, NULL, name, i_bepname),
643: suffix = DECODE(i_bepsuffix, NULL, suffix, i_bepsuffix),
644: bepusername = DECODE(i_bepusername, NULL, bepusername, FND_API.G_MISS_CHAR, NULL, i_bepusername),
645: beppassword = DECODE(i_beppassword, NULL, beppassword, FND_API.G_MISS_CHAR, NULL, i_beppassword),
646: psusername = DECODE(i_psusername, NULL, psusername, FND_API.G_MISS_CHAR, NULL, i_psusername),
647: pspassword = DECODE(i_pspassword, NULL, pspassword, FND_API.G_MISS_CHAR, NULL, i_pspassword),
648: baseurl = DECODE(i_bepurl, NULL, baseurl, FND_API.G_MISS_CHAR, NULL, i_bepurl),
649: bep_type = DECODE(i_bep_type, NULL, bep_type, FND_API.G_MISS_CHAR, NULL, i_bep_type),
650: adminurl = DECODE(i_adminurl, NULL, adminurl, FND_API.G_MISS_CHAR, NULL, i_adminurl),

Line 647: pspassword = DECODE(i_pspassword, NULL, pspassword, FND_API.G_MISS_CHAR, NULL, i_pspassword),

643: suffix = DECODE(i_bepsuffix, NULL, suffix, i_bepsuffix),
644: bepusername = DECODE(i_bepusername, NULL, bepusername, FND_API.G_MISS_CHAR, NULL, i_bepusername),
645: beppassword = DECODE(i_beppassword, NULL, beppassword, FND_API.G_MISS_CHAR, NULL, i_beppassword),
646: psusername = DECODE(i_psusername, NULL, psusername, FND_API.G_MISS_CHAR, NULL, i_psusername),
647: pspassword = DECODE(i_pspassword, NULL, pspassword, FND_API.G_MISS_CHAR, NULL, i_pspassword),
648: baseurl = DECODE(i_bepurl, NULL, baseurl, FND_API.G_MISS_CHAR, NULL, i_bepurl),
649: bep_type = DECODE(i_bep_type, NULL, bep_type, FND_API.G_MISS_CHAR, NULL, i_bep_type),
650: adminurl = DECODE(i_adminurl, NULL, adminurl, FND_API.G_MISS_CHAR, NULL, i_adminurl),
651: loginurl = DECODE(i_login, NULL, loginurl, FND_API.G_MISS_CHAR, NULL, i_login),

Line 648: baseurl = DECODE(i_bepurl, NULL, baseurl, FND_API.G_MISS_CHAR, NULL, i_bepurl),

644: bepusername = DECODE(i_bepusername, NULL, bepusername, FND_API.G_MISS_CHAR, NULL, i_bepusername),
645: beppassword = DECODE(i_beppassword, NULL, beppassword, FND_API.G_MISS_CHAR, NULL, i_beppassword),
646: psusername = DECODE(i_psusername, NULL, psusername, FND_API.G_MISS_CHAR, NULL, i_psusername),
647: pspassword = DECODE(i_pspassword, NULL, pspassword, FND_API.G_MISS_CHAR, NULL, i_pspassword),
648: baseurl = DECODE(i_bepurl, NULL, baseurl, FND_API.G_MISS_CHAR, NULL, i_bepurl),
649: bep_type = DECODE(i_bep_type, NULL, bep_type, FND_API.G_MISS_CHAR, NULL, i_bep_type),
650: adminurl = DECODE(i_adminurl, NULL, adminurl, FND_API.G_MISS_CHAR, NULL, i_adminurl),
651: loginurl = DECODE(i_login, NULL, loginurl, FND_API.G_MISS_CHAR, NULL, i_login),
652: logouturl = DECODE(i_logout, NULL, logouturl, FND_API.G_MISS_CHAR, NULL, i_logout),

Line 649: bep_type = DECODE(i_bep_type, NULL, bep_type, FND_API.G_MISS_CHAR, NULL, i_bep_type),

645: beppassword = DECODE(i_beppassword, NULL, beppassword, FND_API.G_MISS_CHAR, NULL, i_beppassword),
646: psusername = DECODE(i_psusername, NULL, psusername, FND_API.G_MISS_CHAR, NULL, i_psusername),
647: pspassword = DECODE(i_pspassword, NULL, pspassword, FND_API.G_MISS_CHAR, NULL, i_pspassword),
648: baseurl = DECODE(i_bepurl, NULL, baseurl, FND_API.G_MISS_CHAR, NULL, i_bepurl),
649: bep_type = DECODE(i_bep_type, NULL, bep_type, FND_API.G_MISS_CHAR, NULL, i_bep_type),
650: adminurl = DECODE(i_adminurl, NULL, adminurl, FND_API.G_MISS_CHAR, NULL, i_adminurl),
651: loginurl = DECODE(i_login, NULL, loginurl, FND_API.G_MISS_CHAR, NULL, i_login),
652: logouturl = DECODE(i_logout, NULL, logouturl, FND_API.G_MISS_CHAR, NULL, i_logout),
653: supportedop = DECODE(i_supportedop, NULL, supportedop, FND_API.G_MISS_NUM, NULL, i_supportedop),

Line 650: adminurl = DECODE(i_adminurl, NULL, adminurl, FND_API.G_MISS_CHAR, NULL, i_adminurl),

646: psusername = DECODE(i_psusername, NULL, psusername, FND_API.G_MISS_CHAR, NULL, i_psusername),
647: pspassword = DECODE(i_pspassword, NULL, pspassword, FND_API.G_MISS_CHAR, NULL, i_pspassword),
648: baseurl = DECODE(i_bepurl, NULL, baseurl, FND_API.G_MISS_CHAR, NULL, i_bepurl),
649: bep_type = DECODE(i_bep_type, NULL, bep_type, FND_API.G_MISS_CHAR, NULL, i_bep_type),
650: adminurl = DECODE(i_adminurl, NULL, adminurl, FND_API.G_MISS_CHAR, NULL, i_adminurl),
651: loginurl = DECODE(i_login, NULL, loginurl, FND_API.G_MISS_CHAR, NULL, i_login),
652: logouturl = DECODE(i_logout, NULL, logouturl, FND_API.G_MISS_CHAR, NULL, i_logout),
653: supportedop = DECODE(i_supportedop, NULL, supportedop, FND_API.G_MISS_NUM, NULL, i_supportedop),
654: leadtime = DECODE(i_leadtime, NULL, leadtime, FND_API.G_MISS_NUM, NULL, i_leadtime),

Line 651: loginurl = DECODE(i_login, NULL, loginurl, FND_API.G_MISS_CHAR, NULL, i_login),

647: pspassword = DECODE(i_pspassword, NULL, pspassword, FND_API.G_MISS_CHAR, NULL, i_pspassword),
648: baseurl = DECODE(i_bepurl, NULL, baseurl, FND_API.G_MISS_CHAR, NULL, i_bepurl),
649: bep_type = DECODE(i_bep_type, NULL, bep_type, FND_API.G_MISS_CHAR, NULL, i_bep_type),
650: adminurl = DECODE(i_adminurl, NULL, adminurl, FND_API.G_MISS_CHAR, NULL, i_adminurl),
651: loginurl = DECODE(i_login, NULL, loginurl, FND_API.G_MISS_CHAR, NULL, i_login),
652: logouturl = DECODE(i_logout, NULL, logouturl, FND_API.G_MISS_CHAR, NULL, i_logout),
653: supportedop = DECODE(i_supportedop, NULL, supportedop, FND_API.G_MISS_NUM, NULL, i_supportedop),
654: leadtime = DECODE(i_leadtime, NULL, leadtime, FND_API.G_MISS_NUM, NULL, i_leadtime),
655: srvrIdImmed = DECODE(i_srvrIdImmed, NULL, srvrIdImmed, FND_API.G_MISS_CHAR, NULL, i_srvrIdImmed),

Line 652: logouturl = DECODE(i_logout, NULL, logouturl, FND_API.G_MISS_CHAR, NULL, i_logout),

648: baseurl = DECODE(i_bepurl, NULL, baseurl, FND_API.G_MISS_CHAR, NULL, i_bepurl),
649: bep_type = DECODE(i_bep_type, NULL, bep_type, FND_API.G_MISS_CHAR, NULL, i_bep_type),
650: adminurl = DECODE(i_adminurl, NULL, adminurl, FND_API.G_MISS_CHAR, NULL, i_adminurl),
651: loginurl = DECODE(i_login, NULL, loginurl, FND_API.G_MISS_CHAR, NULL, i_login),
652: logouturl = DECODE(i_logout, NULL, logouturl, FND_API.G_MISS_CHAR, NULL, i_logout),
653: supportedop = DECODE(i_supportedop, NULL, supportedop, FND_API.G_MISS_NUM, NULL, i_supportedop),
654: leadtime = DECODE(i_leadtime, NULL, leadtime, FND_API.G_MISS_NUM, NULL, i_leadtime),
655: srvrIdImmed = DECODE(i_srvrIdImmed, NULL, srvrIdImmed, FND_API.G_MISS_CHAR, NULL, i_srvrIdImmed),
656: holidayfile = DECODE(i_holidayfile, NULL, holidayfile, FND_API.G_MISS_CHAR, NULL, i_holidayfile),

Line 653: supportedop = DECODE(i_supportedop, NULL, supportedop, FND_API.G_MISS_NUM, NULL, i_supportedop),

649: bep_type = DECODE(i_bep_type, NULL, bep_type, FND_API.G_MISS_CHAR, NULL, i_bep_type),
650: adminurl = DECODE(i_adminurl, NULL, adminurl, FND_API.G_MISS_CHAR, NULL, i_adminurl),
651: loginurl = DECODE(i_login, NULL, loginurl, FND_API.G_MISS_CHAR, NULL, i_login),
652: logouturl = DECODE(i_logout, NULL, logouturl, FND_API.G_MISS_CHAR, NULL, i_logout),
653: supportedop = DECODE(i_supportedop, NULL, supportedop, FND_API.G_MISS_NUM, NULL, i_supportedop),
654: leadtime = DECODE(i_leadtime, NULL, leadtime, FND_API.G_MISS_NUM, NULL, i_leadtime),
655: srvrIdImmed = DECODE(i_srvrIdImmed, NULL, srvrIdImmed, FND_API.G_MISS_CHAR, NULL, i_srvrIdImmed),
656: holidayfile = DECODE(i_holidayfile, NULL, holidayfile, FND_API.G_MISS_CHAR, NULL, i_holidayfile),
657: filesupport = DECODE(i_fileSupport, NULL, filesupport, FND_API.G_MISS_CHAR, NULL, i_fileSupport),

Line 654: leadtime = DECODE(i_leadtime, NULL, leadtime, FND_API.G_MISS_NUM, NULL, i_leadtime),

650: adminurl = DECODE(i_adminurl, NULL, adminurl, FND_API.G_MISS_CHAR, NULL, i_adminurl),
651: loginurl = DECODE(i_login, NULL, loginurl, FND_API.G_MISS_CHAR, NULL, i_login),
652: logouturl = DECODE(i_logout, NULL, logouturl, FND_API.G_MISS_CHAR, NULL, i_logout),
653: supportedop = DECODE(i_supportedop, NULL, supportedop, FND_API.G_MISS_NUM, NULL, i_supportedop),
654: leadtime = DECODE(i_leadtime, NULL, leadtime, FND_API.G_MISS_NUM, NULL, i_leadtime),
655: srvrIdImmed = DECODE(i_srvrIdImmed, NULL, srvrIdImmed, FND_API.G_MISS_CHAR, NULL, i_srvrIdImmed),
656: holidayfile = DECODE(i_holidayfile, NULL, holidayfile, FND_API.G_MISS_CHAR, NULL, i_holidayfile),
657: filesupport = DECODE(i_fileSupport, NULL, filesupport, FND_API.G_MISS_CHAR, NULL, i_fileSupport),
658: activeStatus = DECODE(i_activeStatus, NULL, activeStatus, FND_API.G_MISS_CHAR, NULL, i_activeStatus),

Line 655: srvrIdImmed = DECODE(i_srvrIdImmed, NULL, srvrIdImmed, FND_API.G_MISS_CHAR, NULL, i_srvrIdImmed),

651: loginurl = DECODE(i_login, NULL, loginurl, FND_API.G_MISS_CHAR, NULL, i_login),
652: logouturl = DECODE(i_logout, NULL, logouturl, FND_API.G_MISS_CHAR, NULL, i_logout),
653: supportedop = DECODE(i_supportedop, NULL, supportedop, FND_API.G_MISS_NUM, NULL, i_supportedop),
654: leadtime = DECODE(i_leadtime, NULL, leadtime, FND_API.G_MISS_NUM, NULL, i_leadtime),
655: srvrIdImmed = DECODE(i_srvrIdImmed, NULL, srvrIdImmed, FND_API.G_MISS_CHAR, NULL, i_srvrIdImmed),
656: holidayfile = DECODE(i_holidayfile, NULL, holidayfile, FND_API.G_MISS_CHAR, NULL, i_holidayfile),
657: filesupport = DECODE(i_fileSupport, NULL, filesupport, FND_API.G_MISS_CHAR, NULL, i_fileSupport),
658: activeStatus = DECODE(i_activeStatus, NULL, activeStatus, FND_API.G_MISS_CHAR, NULL, i_activeStatus),
659: -- instrtype = DECODE(p_instr_type, NULL, instrtype, FND_API.G_MISS_CHAR, NULL, p_instr_type),

Line 656: holidayfile = DECODE(i_holidayfile, NULL, holidayfile, FND_API.G_MISS_CHAR, NULL, i_holidayfile),

652: logouturl = DECODE(i_logout, NULL, logouturl, FND_API.G_MISS_CHAR, NULL, i_logout),
653: supportedop = DECODE(i_supportedop, NULL, supportedop, FND_API.G_MISS_NUM, NULL, i_supportedop),
654: leadtime = DECODE(i_leadtime, NULL, leadtime, FND_API.G_MISS_NUM, NULL, i_leadtime),
655: srvrIdImmed = DECODE(i_srvrIdImmed, NULL, srvrIdImmed, FND_API.G_MISS_CHAR, NULL, i_srvrIdImmed),
656: holidayfile = DECODE(i_holidayfile, NULL, holidayfile, FND_API.G_MISS_CHAR, NULL, i_holidayfile),
657: filesupport = DECODE(i_fileSupport, NULL, filesupport, FND_API.G_MISS_CHAR, NULL, i_fileSupport),
658: activeStatus = DECODE(i_activeStatus, NULL, activeStatus, FND_API.G_MISS_CHAR, NULL, i_activeStatus),
659: -- instrtype = DECODE(p_instr_type, NULL, instrtype, FND_API.G_MISS_CHAR, NULL, p_instr_type),
660: securityscheme = DECODE(i_securityscheme, NULL, securityscheme, FND_API.G_MISS_NUM, NULL, i_securityscheme),

Line 657: filesupport = DECODE(i_fileSupport, NULL, filesupport, FND_API.G_MISS_CHAR, NULL, i_fileSupport),

653: supportedop = DECODE(i_supportedop, NULL, supportedop, FND_API.G_MISS_NUM, NULL, i_supportedop),
654: leadtime = DECODE(i_leadtime, NULL, leadtime, FND_API.G_MISS_NUM, NULL, i_leadtime),
655: srvrIdImmed = DECODE(i_srvrIdImmed, NULL, srvrIdImmed, FND_API.G_MISS_CHAR, NULL, i_srvrIdImmed),
656: holidayfile = DECODE(i_holidayfile, NULL, holidayfile, FND_API.G_MISS_CHAR, NULL, i_holidayfile),
657: filesupport = DECODE(i_fileSupport, NULL, filesupport, FND_API.G_MISS_CHAR, NULL, i_fileSupport),
658: activeStatus = DECODE(i_activeStatus, NULL, activeStatus, FND_API.G_MISS_CHAR, NULL, i_activeStatus),
659: -- instrtype = DECODE(p_instr_type, NULL, instrtype, FND_API.G_MISS_CHAR, NULL, p_instr_type),
660: securityscheme = DECODE(i_securityscheme, NULL, securityscheme, FND_API.G_MISS_NUM, NULL, i_securityscheme),
661: party_id = DECODE(i_partyid, NULL, party_id, FND_API.G_MISS_CHAR, NULL, i_partyid),

Line 658: activeStatus = DECODE(i_activeStatus, NULL, activeStatus, FND_API.G_MISS_CHAR, NULL, i_activeStatus),

654: leadtime = DECODE(i_leadtime, NULL, leadtime, FND_API.G_MISS_NUM, NULL, i_leadtime),
655: srvrIdImmed = DECODE(i_srvrIdImmed, NULL, srvrIdImmed, FND_API.G_MISS_CHAR, NULL, i_srvrIdImmed),
656: holidayfile = DECODE(i_holidayfile, NULL, holidayfile, FND_API.G_MISS_CHAR, NULL, i_holidayfile),
657: filesupport = DECODE(i_fileSupport, NULL, filesupport, FND_API.G_MISS_CHAR, NULL, i_fileSupport),
658: activeStatus = DECODE(i_activeStatus, NULL, activeStatus, FND_API.G_MISS_CHAR, NULL, i_activeStatus),
659: -- instrtype = DECODE(p_instr_type, NULL, instrtype, FND_API.G_MISS_CHAR, NULL, p_instr_type),
660: securityscheme = DECODE(i_securityscheme, NULL, securityscheme, FND_API.G_MISS_NUM, NULL, i_securityscheme),
661: party_id = DECODE(i_partyid, NULL, party_id, FND_API.G_MISS_CHAR, NULL, i_partyid),
662: last_update_date = SYSDATE,

Line 659: -- instrtype = DECODE(p_instr_type, NULL, instrtype, FND_API.G_MISS_CHAR, NULL, p_instr_type),

655: srvrIdImmed = DECODE(i_srvrIdImmed, NULL, srvrIdImmed, FND_API.G_MISS_CHAR, NULL, i_srvrIdImmed),
656: holidayfile = DECODE(i_holidayfile, NULL, holidayfile, FND_API.G_MISS_CHAR, NULL, i_holidayfile),
657: filesupport = DECODE(i_fileSupport, NULL, filesupport, FND_API.G_MISS_CHAR, NULL, i_fileSupport),
658: activeStatus = DECODE(i_activeStatus, NULL, activeStatus, FND_API.G_MISS_CHAR, NULL, i_activeStatus),
659: -- instrtype = DECODE(p_instr_type, NULL, instrtype, FND_API.G_MISS_CHAR, NULL, p_instr_type),
660: securityscheme = DECODE(i_securityscheme, NULL, securityscheme, FND_API.G_MISS_NUM, NULL, i_securityscheme),
661: party_id = DECODE(i_partyid, NULL, party_id, FND_API.G_MISS_CHAR, NULL, i_partyid),
662: last_update_date = SYSDATE,
663: last_updated_by = fnd_global.user_id,

Line 660: securityscheme = DECODE(i_securityscheme, NULL, securityscheme, FND_API.G_MISS_NUM, NULL, i_securityscheme),

656: holidayfile = DECODE(i_holidayfile, NULL, holidayfile, FND_API.G_MISS_CHAR, NULL, i_holidayfile),
657: filesupport = DECODE(i_fileSupport, NULL, filesupport, FND_API.G_MISS_CHAR, NULL, i_fileSupport),
658: activeStatus = DECODE(i_activeStatus, NULL, activeStatus, FND_API.G_MISS_CHAR, NULL, i_activeStatus),
659: -- instrtype = DECODE(p_instr_type, NULL, instrtype, FND_API.G_MISS_CHAR, NULL, p_instr_type),
660: securityscheme = DECODE(i_securityscheme, NULL, securityscheme, FND_API.G_MISS_NUM, NULL, i_securityscheme),
661: party_id = DECODE(i_partyid, NULL, party_id, FND_API.G_MISS_CHAR, NULL, i_partyid),
662: last_update_date = SYSDATE,
663: last_updated_by = fnd_global.user_id,
664: last_update_login = fnd_global.login_id,

Line 661: party_id = DECODE(i_partyid, NULL, party_id, FND_API.G_MISS_CHAR, NULL, i_partyid),

657: filesupport = DECODE(i_fileSupport, NULL, filesupport, FND_API.G_MISS_CHAR, NULL, i_fileSupport),
658: activeStatus = DECODE(i_activeStatus, NULL, activeStatus, FND_API.G_MISS_CHAR, NULL, i_activeStatus),
659: -- instrtype = DECODE(p_instr_type, NULL, instrtype, FND_API.G_MISS_CHAR, NULL, p_instr_type),
660: securityscheme = DECODE(i_securityscheme, NULL, securityscheme, FND_API.G_MISS_NUM, NULL, i_securityscheme),
661: party_id = DECODE(i_partyid, NULL, party_id, FND_API.G_MISS_CHAR, NULL, i_partyid),
662: last_update_date = SYSDATE,
663: last_updated_by = fnd_global.user_id,
664: last_update_login = fnd_global.login_id,
665: object_version_number = object_version_number + 1