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.OKC_CHANGE_CONTRACT_PVT dependencies on WF_ENGINE

Line 316: wf_engine.CreateProcess( ItemType => L_WF_NAME,

312: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
313: rollback to BECAUSE_OF_BUG_IN_lock;
314: RAISE OKC_API.G_EXCEPTION_ERROR;
315: END IF;
316: wf_engine.CreateProcess( ItemType => L_WF_NAME,
317: ItemKey => L_KEY,
318: process => L_WF_PROCESS_NAME);
319: wf_engine.SetItemUserKey (ItemType => L_WF_NAME,
320: ItemKey => L_KEY,

Line 319: wf_engine.SetItemUserKey (ItemType => L_WF_NAME,

315: END IF;
316: wf_engine.CreateProcess( ItemType => L_WF_NAME,
317: ItemKey => L_KEY,
318: process => L_WF_PROCESS_NAME);
319: wf_engine.SetItemUserKey (ItemType => L_WF_NAME,
320: ItemKey => L_KEY,
321: UserKey => L_KEY);
322: open defined_parameters_csr;
323: LOOP

Line 331: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

327: L_PAR_VALUE;
328: exit when defined_parameters_csr%NOTFOUND;
329: if L_PAR_TYPE = 'C' then
330: begin
331: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
332: itemkey => L_KEY,
333: aname => L_PAR_NAME,
334: avalue => L_PAR_VALUE);
335: exception

Line 337: wf_engine.AddItemAttr (itemtype => L_WF_NAME,

333: aname => L_PAR_NAME,
334: avalue => L_PAR_VALUE);
335: exception
336: when others then
337: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
338: itemkey => L_KEY,
339: aname => L_PAR_NAME);
340: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
341: itemkey => L_KEY,

Line 340: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

336: when others then
337: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
338: itemkey => L_KEY,
339: aname => L_PAR_NAME);
340: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
341: itemkey => L_KEY,
342: aname => L_PAR_NAME,
343: avalue => L_PAR_VALUE);
344: end;

Line 347: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,

343: avalue => L_PAR_VALUE);
344: end;
345: elsif L_PAR_TYPE = 'N' then
346: begin
347: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
348: itemkey => L_KEY,
349: aname => L_PAR_NAME,
350: avalue => to_number(L_PAR_VALUE));
351: exception

Line 353: wf_engine.AddItemAttr (itemtype => L_WF_NAME,

349: aname => L_PAR_NAME,
350: avalue => to_number(L_PAR_VALUE));
351: exception
352: when others then
353: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
354: itemkey => L_KEY,
355: aname => L_PAR_NAME);
356: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
357: itemkey => L_KEY,

Line 356: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,

352: when others then
353: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
354: itemkey => L_KEY,
355: aname => L_PAR_NAME);
356: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
357: itemkey => L_KEY,
358: aname => L_PAR_NAME,
359: avalue => to_number(L_PAR_VALUE));
360: end;

Line 363: wf_engine.SetItemAttrDate (itemtype => L_WF_NAME,

359: avalue => to_number(L_PAR_VALUE));
360: end;
361: elsif L_PAR_TYPE = 'D' then
362: begin
363: wf_engine.SetItemAttrDate (itemtype => L_WF_NAME,
364: itemkey => L_KEY,
365: aname => L_PAR_NAME,
366: avalue => fnd_date.chardate_to_date(L_PAR_VALUE));
367: exception

Line 369: wf_engine.AddItemAttr (itemtype => L_WF_NAME,

365: aname => L_PAR_NAME,
366: avalue => fnd_date.chardate_to_date(L_PAR_VALUE));
367: exception
368: when others then
369: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
370: itemkey => L_KEY,
371: aname => L_PAR_NAME);
372: wf_engine.SetItemAttrDate (itemtype => L_WF_NAME,
373: itemkey => L_KEY,

Line 372: wf_engine.SetItemAttrDate (itemtype => L_WF_NAME,

368: when others then
369: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
370: itemkey => L_KEY,
371: aname => L_PAR_NAME);
372: wf_engine.SetItemAttrDate (itemtype => L_WF_NAME,
373: itemkey => L_KEY,
374: aname => L_PAR_NAME,
375: avalue => fnd_date.chardate_to_date(L_PAR_VALUE));
376: end;

Line 380: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,

376: end;
377: end if;
378: END LOOP;
379: begin
380: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
381: itemkey => L_KEY,
382: aname => 'CONTRACT_ID',
383: avalue => l_contract_id);
384: exception

Line 386: wf_engine.AddItemAttr (itemtype => L_WF_NAME,

382: aname => 'CONTRACT_ID',
383: avalue => l_contract_id);
384: exception
385: when others then
386: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
387: itemkey => L_KEY,
388: aname => 'CONTRACT_ID');
389: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
390: itemkey => L_KEY,

Line 389: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,

385: when others then
386: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
387: itemkey => L_KEY,
388: aname => 'CONTRACT_ID');
389: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
390: itemkey => L_KEY,
391: aname => 'CONTRACT_ID',
392: avalue => l_contract_id);
393: end;

Line 395: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

391: aname => 'CONTRACT_ID',
392: avalue => l_contract_id);
393: end;
394: begin
395: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
396: itemkey => L_KEY,
397: aname => 'CONTRACT_NUMBER',
398: avalue => l_contract_number);
399: exception

Line 401: wf_engine.AddItemAttr (itemtype => L_WF_NAME,

397: aname => 'CONTRACT_NUMBER',
398: avalue => l_contract_number);
399: exception
400: when others then
401: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
402: itemkey => L_KEY,
403: aname => 'CONTRACT_NUMBER');
404: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
405: itemkey => L_KEY,

Line 404: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

400: when others then
401: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
402: itemkey => L_KEY,
403: aname => 'CONTRACT_NUMBER');
404: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
405: itemkey => L_KEY,
406: aname => 'CONTRACT_NUMBER',
407: avalue => l_contract_number);
408: end;

Line 410: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

406: aname => 'CONTRACT_NUMBER',
407: avalue => l_contract_number);
408: end;
409: begin
410: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
411: itemkey => L_KEY,
412: aname => 'CONTRACT_NUMBER_MODIFIER',
413: avalue => l_contract_number_MODIFIER);
414: exception

Line 416: wf_engine.AddItemAttr (itemtype => L_WF_NAME,

412: aname => 'CONTRACT_NUMBER_MODIFIER',
413: avalue => l_contract_number_MODIFIER);
414: exception
415: when others then
416: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
417: itemkey => L_KEY,
418: aname => 'CONTRACT_NUMBER_MODIFIER');
419: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
420: itemkey => L_KEY,

Line 419: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

415: when others then
416: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
417: itemkey => L_KEY,
418: aname => 'CONTRACT_NUMBER_MODIFIER');
419: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
420: itemkey => L_KEY,
421: aname => 'CONTRACT_NUMBER_MODIFIER',
422: avalue => l_contract_number_MODIFIER);
423: end;

Line 425: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

421: aname => 'CONTRACT_NUMBER_MODIFIER',
422: avalue => l_contract_number_MODIFIER);
423: end;
424: begin
425: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
426: itemkey => L_KEY,
427: aname => 'K_SHORT_DESCRIPTION',
428: avalue => l_k_short_description);
429: exception

Line 431: wf_engine.AddItemAttr (itemtype => L_WF_NAME,

427: aname => 'K_SHORT_DESCRIPTION',
428: avalue => l_k_short_description);
429: exception
430: when others then
431: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
432: itemkey => L_KEY,
433: aname => 'K_SHORT_DESCRIPTION');
434: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
435: itemkey => L_KEY,

Line 434: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

430: when others then
431: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
432: itemkey => L_KEY,
433: aname => 'K_SHORT_DESCRIPTION');
434: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
435: itemkey => L_KEY,
436: aname => 'K_SHORT_DESCRIPTION',
437: avalue => l_k_short_description);
438: end;

Line 440: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,

436: aname => 'K_SHORT_DESCRIPTION',
437: avalue => l_k_short_description);
438: end;
439: begin
440: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
441: itemkey => L_KEY,
442: aname => 'CHANGE_REQUEST_ID',
443: avalue => p_change_request_id);
444: exception

Line 446: wf_engine.AddItemAttr (itemtype => L_WF_NAME,

442: aname => 'CHANGE_REQUEST_ID',
443: avalue => p_change_request_id);
444: exception
445: when others then
446: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
447: itemkey => L_KEY,
448: aname => 'CHANGE_REQUEST_ID');
449: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
450: itemkey => L_KEY,

Line 449: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,

445: when others then
446: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
447: itemkey => L_KEY,
448: aname => 'CHANGE_REQUEST_ID');
449: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
450: itemkey => L_KEY,
451: aname => 'CHANGE_REQUEST_ID',
452: avalue => p_change_request_id);
453: end;

Line 455: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

451: aname => 'CHANGE_REQUEST_ID',
452: avalue => p_change_request_id);
453: end;
454: begin
455: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
456: itemkey => L_KEY,
457: aname => 'CRT_NAME',
458: avalue => l_crt_name);
459: exception

Line 461: wf_engine.AddItemAttr (itemtype => L_WF_NAME,

457: aname => 'CRT_NAME',
458: avalue => l_crt_name);
459: exception
460: when others then
461: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
462: itemkey => L_KEY,
463: aname => 'CRT_NAME');
464: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
465: itemkey => L_KEY,

Line 464: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

460: when others then
461: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
462: itemkey => L_KEY,
463: aname => 'CRT_NAME');
464: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
465: itemkey => L_KEY,
466: aname => 'CRT_NAME',
467: avalue => l_crt_name);
468: end;

Line 470: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

466: aname => 'CRT_NAME',
467: avalue => l_crt_name);
468: end;
469: begin
470: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
471: itemkey => L_KEY,
472: aname => 'CRT_SHORT_DESCRIPTION',
473: avalue => l_crt_short_description);
474: exception

Line 476: wf_engine.AddItemAttr (itemtype => L_WF_NAME,

472: aname => 'CRT_SHORT_DESCRIPTION',
473: avalue => l_crt_short_description);
474: exception
475: when others then
476: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
477: itemkey => L_KEY,
478: aname => 'CRT_SHORT_DESCRIPTION');
479: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
480: itemkey => L_KEY,

Line 479: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

475: when others then
476: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
477: itemkey => L_KEY,
478: aname => 'CRT_SHORT_DESCRIPTION');
479: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
480: itemkey => L_KEY,
481: aname => 'CRT_SHORT_DESCRIPTION',
482: avalue => l_crt_short_description);
483: end;

Line 485: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

481: aname => 'CRT_SHORT_DESCRIPTION',
482: avalue => l_crt_short_description);
483: end;
484: begin
485: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
486: itemkey => L_KEY,
487: aname => 'AUTH_USERNAME',
488: avalue => l_auth_username);
489: exception

Line 491: wf_engine.AddItemAttr (itemtype => L_WF_NAME,

487: aname => 'AUTH_USERNAME',
488: avalue => l_auth_username);
489: exception
490: when others then
491: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
492: itemkey => L_KEY,
493: aname => 'AUTH_USERNAME');
494: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
495: itemkey => L_KEY,

Line 494: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

490: when others then
491: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
492: itemkey => L_KEY,
493: aname => 'AUTH_USERNAME');
494: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
495: itemkey => L_KEY,
496: aname => 'AUTH_USERNAME',
497: avalue => l_auth_username);
498: end;

Line 500: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

496: aname => 'AUTH_USERNAME',
497: avalue => l_auth_username);
498: end;
499: begin
500: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
501: itemkey => L_KEY,
502: aname => 'REQUESTOR',
503: avalue => l_requestor);
504: exception

Line 506: wf_engine.AddItemAttr (itemtype => L_WF_NAME,

502: aname => 'REQUESTOR',
503: avalue => l_requestor);
504: exception
505: when others then
506: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
507: itemkey => L_KEY,
508: aname => 'REQUESTOR');
509: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
510: itemkey => L_KEY,

Line 509: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

505: when others then
506: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
507: itemkey => L_KEY,
508: aname => 'REQUESTOR');
509: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
510: itemkey => L_KEY,
511: aname => 'REQUESTOR',
512: avalue => l_requestor);
513: end;

Line 515: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

511: aname => 'REQUESTOR',
512: avalue => l_requestor);
513: end;
514: begin
515: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
516: itemkey => L_KEY,
517: aname => 'SIGNATURE_REQUIRED_YN',
518: avalue => l_signature_required_yn);
519: exception

Line 521: wf_engine.AddItemAttr (itemtype => L_WF_NAME,

517: aname => 'SIGNATURE_REQUIRED_YN',
518: avalue => l_signature_required_yn);
519: exception
520: when others then
521: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
522: itemkey => L_KEY,
523: aname => 'SIGNATURE_REQUIRED_YN');
524: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
525: itemkey => L_KEY,

Line 524: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

520: when others then
521: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
522: itemkey => L_KEY,
523: aname => 'SIGNATURE_REQUIRED_YN');
524: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
525: itemkey => L_KEY,
526: aname => 'SIGNATURE_REQUIRED_YN',
527: avalue => l_signature_required_yn);
528: end;

Line 530: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,

526: aname => 'SIGNATURE_REQUIRED_YN',
527: avalue => l_signature_required_yn);
528: end;
529: begin
530: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
531: itemkey => L_KEY,
532: aname => 'USER_ID',
533: avalue => fnd_global.user_id);
534: exception

Line 536: wf_engine.AddItemAttr (itemtype => L_WF_NAME,

532: aname => 'USER_ID',
533: avalue => fnd_global.user_id);
534: exception
535: when others then
536: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
537: itemkey => L_KEY,
538: aname => 'USER_ID');
539: wf_engine.SetItemAttrNumber(itemtype => L_WF_NAME,
540: itemkey => L_KEY,

Line 539: wf_engine.SetItemAttrNumber(itemtype => L_WF_NAME,

535: when others then
536: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
537: itemkey => L_KEY,
538: aname => 'USER_ID');
539: wf_engine.SetItemAttrNumber(itemtype => L_WF_NAME,
540: itemkey => L_KEY,
541: aname => 'USER_ID',
542: avalue => fnd_global.user_id);
543: end;

Line 545: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,

541: aname => 'USER_ID',
542: avalue => fnd_global.user_id);
543: end;
544: begin
545: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
546: itemkey => L_KEY,
547: aname => 'RESP_ID',
548: avalue => fnd_global.resp_id);
549: exception

Line 551: wf_engine.AddItemAttr (itemtype => L_WF_NAME,

547: aname => 'RESP_ID',
548: avalue => fnd_global.resp_id);
549: exception
550: when others then
551: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
552: itemkey => L_KEY,
553: aname => 'RESP_ID');
554: wf_engine.SetItemAttrNumber(itemtype => L_WF_NAME,
555: itemkey => L_KEY,

Line 554: wf_engine.SetItemAttrNumber(itemtype => L_WF_NAME,

550: when others then
551: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
552: itemkey => L_KEY,
553: aname => 'RESP_ID');
554: wf_engine.SetItemAttrNumber(itemtype => L_WF_NAME,
555: itemkey => L_KEY,
556: aname => 'RESP_ID',
557: avalue => fnd_global.resp_id);
558: end;

Line 560: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,

556: aname => 'RESP_ID',
557: avalue => fnd_global.resp_id);
558: end;
559: begin
560: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
561: itemkey => L_KEY,
562: aname => 'RESP_APPL_ID',
563: avalue => fnd_global.RESP_APPL_id);
564: exception

Line 566: wf_engine.AddItemAttr (itemtype => L_WF_NAME,

562: aname => 'RESP_APPL_ID',
563: avalue => fnd_global.RESP_APPL_id);
564: exception
565: when others then
566: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
567: itemkey => L_KEY,
568: aname => 'RESP_APPL_ID');
569: wf_engine.SetItemAttrNumber(itemtype => L_WF_NAME,
570: itemkey => L_KEY,

Line 569: wf_engine.SetItemAttrNumber(itemtype => L_WF_NAME,

565: when others then
566: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
567: itemkey => L_KEY,
568: aname => 'RESP_APPL_ID');
569: wf_engine.SetItemAttrNumber(itemtype => L_WF_NAME,
570: itemkey => L_KEY,
571: aname => 'RESP_APPL_ID',
572: avalue => fnd_global.RESP_APPL_id);
573: end;

Line 578: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

574: select value into L_NLS_VALUE
575: from NLS_SESSION_PARAMETERS
576: where PARAMETER='NLS_LANGUAGE';
577: begin
578: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
579: itemkey => L_KEY,
580: aname => 'NLS_LANGUAGE',
581: avalue => L_NLS_VALUE);
582: exception

Line 584: wf_engine.AddItemAttr (itemtype => L_WF_NAME,

580: aname => 'NLS_LANGUAGE',
581: avalue => L_NLS_VALUE);
582: exception
583: when others then
584: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
585: itemkey => L_KEY,
586: aname => 'NLS_LANGUAGE');
587: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
588: itemkey => L_KEY,

Line 587: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

583: when others then
584: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
585: itemkey => L_KEY,
586: aname => 'NLS_LANGUAGE');
587: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
588: itemkey => L_KEY,
589: aname => 'NLS_LANGUAGE',
590: avalue => L_NLS_VALUE);
591: end;

Line 596: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

592: select value into L_NLS_VALUE
593: from NLS_SESSION_PARAMETERS
594: where PARAMETER='NLS_DATE_FORMAT';
595: begin
596: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
597: itemkey => L_KEY,
598: aname => 'NLS_DATE_FORMAT',
599: avalue => L_NLS_VALUE);
600: exception

Line 602: wf_engine.AddItemAttr (itemtype => L_WF_NAME,

598: aname => 'NLS_DATE_FORMAT',
599: avalue => L_NLS_VALUE);
600: exception
601: when others then
602: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
603: itemkey => L_KEY,
604: aname => 'NLS_DATE_FORMAT');
605: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
606: itemkey => L_KEY,

Line 605: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

601: when others then
602: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
603: itemkey => L_KEY,
604: aname => 'NLS_DATE_FORMAT');
605: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
606: itemkey => L_KEY,
607: aname => 'NLS_DATE_FORMAT',
608: avalue => L_NLS_VALUE);
609: end;

Line 614: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

610: select value into L_NLS_VALUE
611: from NLS_SESSION_PARAMETERS
612: where PARAMETER='NLS_DATE_LANGUAGE';
613: begin
614: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
615: itemkey => L_KEY,
616: aname => 'NLS_DATE_LANGUAGE',
617: avalue => L_NLS_VALUE);
618: exception

Line 620: wf_engine.AddItemAttr (itemtype => L_WF_NAME,

616: aname => 'NLS_DATE_LANGUAGE',
617: avalue => L_NLS_VALUE);
618: exception
619: when others then
620: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
621: itemkey => L_KEY,
622: aname => 'NLS_DATE_LANGUAGE');
623: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
624: itemkey => L_KEY,

Line 623: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

619: when others then
620: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
621: itemkey => L_KEY,
622: aname => 'NLS_DATE_LANGUAGE');
623: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
624: itemkey => L_KEY,
625: aname => 'NLS_DATE_LANGUAGE',
626: avalue => L_NLS_VALUE);
627: end;

Line 632: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

628: select '"'||value||'"' into L_NLS_VALUE
629: from NLS_SESSION_PARAMETERS
630: where PARAMETER='NLS_NUMERIC_CHARACTERS';
631: begin
632: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
633: itemkey => L_KEY,
634: aname => 'NLS_NUMERIC_CHARACTERS',
635: avalue => L_NLS_VALUE);
636: exception

Line 638: wf_engine.AddItemAttr (itemtype => L_WF_NAME,

634: aname => 'NLS_NUMERIC_CHARACTERS',
635: avalue => L_NLS_VALUE);
636: exception
637: when others then
638: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
639: itemkey => L_KEY,
640: aname => 'NLS_NUMERIC_CHARACTERS');
641: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
642: itemkey => L_KEY,

Line 641: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,

637: when others then
638: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
639: itemkey => L_KEY,
640: aname => 'NLS_NUMERIC_CHARACTERS');
641: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
642: itemkey => L_KEY,
643: aname => 'NLS_NUMERIC_CHARACTERS',
644: avalue => L_NLS_VALUE);
645: end;

Line 646: wf_engine.SetItemOwner ( itemtype => L_WF_NAME,

642: itemkey => L_KEY,
643: aname => 'NLS_NUMERIC_CHARACTERS',
644: avalue => L_NLS_VALUE);
645: end;
646: wf_engine.SetItemOwner ( itemtype => L_WF_NAME,
647: itemkey => L_KEY,
648: owner => fnd_global.user_name);
649: wf_engine.StartProcess( itemtype => L_WF_NAME,
650: itemkey => L_KEY);

Line 649: wf_engine.StartProcess( itemtype => L_WF_NAME,

645: end;
646: wf_engine.SetItemOwner ( itemtype => L_WF_NAME,
647: itemkey => L_KEY,
648: owner => fnd_global.user_name);
649: wf_engine.StartProcess( itemtype => L_WF_NAME,
650: itemkey => L_KEY);
651:
652: open cur_header_aa(l_contract_id);
653: fetch cur_header_aa into l_estimated_amount,l_scs_code,l_cls_code,l_k_status_code;

Line 882: wf_engine.abortprocess(l_wf_name_active,l_key);

878: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
879: p_msg_name => G_CRT_NOT_ON_APPROVAL);
880: raise OKC_API.G_EXCEPTION_ERROR;
881: end if;
882: wf_engine.abortprocess(l_wf_name_active,l_key);
883: if (p_do_commit = OKC_API.G_TRUE) then
884: commit;
885: end if;
886: x_return_status := OKC_API.G_RET_STS_SUCCESS;