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

Line 87: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'PAM_NAME');

83: l_effective_to DATE;
84: lv_message_body VARCHAR2(4000);
85:
86: BEGIN
87: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'PAM_NAME');
88: l_version_number := wf_engine.GetItemAttrText(itemtype,
89: itemkey,
90: 'VERSION_NUMBER');
91: l_effective_from := wf_engine.GetItemAttrDate(itemtype,

Line 88: l_version_number := wf_engine.GetItemAttrText(itemtype,

84: lv_message_body VARCHAR2(4000);
85:
86: BEGIN
87: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'PAM_NAME');
88: l_version_number := wf_engine.GetItemAttrText(itemtype,
89: itemkey,
90: 'VERSION_NUMBER');
91: l_effective_from := wf_engine.GetItemAttrDate(itemtype,
92: itemkey,

Line 91: l_effective_from := wf_engine.GetItemAttrDate(itemtype,

87: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'PAM_NAME');
88: l_version_number := wf_engine.GetItemAttrText(itemtype,
89: itemkey,
90: 'VERSION_NUMBER');
91: l_effective_from := wf_engine.GetItemAttrDate(itemtype,
92: itemkey,
93: 'EFFECTIVE_FROM');
94: l_effective_to := wf_engine.GetItemAttrDate(itemtype,
95: itemkey,

Line 94: l_effective_to := wf_engine.GetItemAttrDate(itemtype,

90: 'VERSION_NUMBER');
91: l_effective_from := wf_engine.GetItemAttrDate(itemtype,
92: itemkey,
93: 'EFFECTIVE_FROM');
94: l_effective_to := wf_engine.GetItemAttrDate(itemtype,
95: itemkey,
96: 'EFFECTIVE_TO');
97: lv_message_body := '' ||
98: get_token('OKL_NAME', 'NAME', l_name) ||

Line 143: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'SRT_NAME');

139: l_effective_to DATE;
140: lv_message_body VARCHAR2(4000);
141:
142: BEGIN
143: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'SRT_NAME');
144: l_version_number := wf_engine.GetItemAttrText(itemtype,
145: itemkey,
146: 'VERSION_NUMBER');
147: l_effective_from := wf_engine.GetItemAttrDate(itemtype,

Line 144: l_version_number := wf_engine.GetItemAttrText(itemtype,

140: lv_message_body VARCHAR2(4000);
141:
142: BEGIN
143: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'SRT_NAME');
144: l_version_number := wf_engine.GetItemAttrText(itemtype,
145: itemkey,
146: 'VERSION_NUMBER');
147: l_effective_from := wf_engine.GetItemAttrDate(itemtype,
148: itemkey,

Line 147: l_effective_from := wf_engine.GetItemAttrDate(itemtype,

143: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'SRT_NAME');
144: l_version_number := wf_engine.GetItemAttrText(itemtype,
145: itemkey,
146: 'VERSION_NUMBER');
147: l_effective_from := wf_engine.GetItemAttrDate(itemtype,
148: itemkey,
149: 'EFFECTIVE_FROM');
150: l_effective_to := wf_engine.GetItemAttrDate(itemtype,
151: itemkey,

Line 150: l_effective_to := wf_engine.GetItemAttrDate(itemtype,

146: 'VERSION_NUMBER');
147: l_effective_from := wf_engine.GetItemAttrDate(itemtype,
148: itemkey,
149: 'EFFECTIVE_FROM');
150: l_effective_to := wf_engine.GetItemAttrDate(itemtype,
151: itemkey,
152: 'EFFECTIVE_TO');
153: lv_message_body := '' ||
154: get_token('OKL_NAME', 'NAME', l_name) ||

Line 199: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'EOT_NAME');

195: l_effective_to DATE;
196: lv_message_body VARCHAR2(4000);
197:
198: BEGIN
199: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'EOT_NAME');
200: l_version_number := wf_engine.GetItemAttrText(itemtype,
201: itemkey,
202: 'VERSION_NUMBER');
203: l_effective_from := wf_engine.GetItemAttrDate(itemtype,

Line 200: l_version_number := wf_engine.GetItemAttrText(itemtype,

196: lv_message_body VARCHAR2(4000);
197:
198: BEGIN
199: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'EOT_NAME');
200: l_version_number := wf_engine.GetItemAttrText(itemtype,
201: itemkey,
202: 'VERSION_NUMBER');
203: l_effective_from := wf_engine.GetItemAttrDate(itemtype,
204: itemkey,

Line 203: l_effective_from := wf_engine.GetItemAttrDate(itemtype,

199: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'EOT_NAME');
200: l_version_number := wf_engine.GetItemAttrText(itemtype,
201: itemkey,
202: 'VERSION_NUMBER');
203: l_effective_from := wf_engine.GetItemAttrDate(itemtype,
204: itemkey,
205: 'EFFECTIVE_FROM');
206: l_effective_to := wf_engine.GetItemAttrDate(itemtype,
207: itemkey,

Line 206: l_effective_to := wf_engine.GetItemAttrDate(itemtype,

202: 'VERSION_NUMBER');
203: l_effective_from := wf_engine.GetItemAttrDate(itemtype,
204: itemkey,
205: 'EFFECTIVE_FROM');
206: l_effective_to := wf_engine.GetItemAttrDate(itemtype,
207: itemkey,
208: 'EFFECTIVE_TO');
209: lv_message_body := '' ||
210: get_token('OKL_NAME', 'NAME', l_name) ||

Line 255: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'IRS_NAME');

251: l_effective_to DATE;
252: lv_message_body VARCHAR2(4000);
253:
254: BEGIN
255: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'IRS_NAME');
256: l_version_number := wf_engine.GetItemAttrText(itemtype,
257: itemkey,
258: 'VERSION_NUMBER');
259: l_effective_from := wf_engine.GetItemAttrDate(itemtype,

Line 256: l_version_number := wf_engine.GetItemAttrText(itemtype,

252: lv_message_body VARCHAR2(4000);
253:
254: BEGIN
255: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'IRS_NAME');
256: l_version_number := wf_engine.GetItemAttrText(itemtype,
257: itemkey,
258: 'VERSION_NUMBER');
259: l_effective_from := wf_engine.GetItemAttrDate(itemtype,
260: itemkey,

Line 259: l_effective_from := wf_engine.GetItemAttrDate(itemtype,

255: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'IRS_NAME');
256: l_version_number := wf_engine.GetItemAttrText(itemtype,
257: itemkey,
258: 'VERSION_NUMBER');
259: l_effective_from := wf_engine.GetItemAttrDate(itemtype,
260: itemkey,
261: 'EFFECTIVE_FROM');
262: l_effective_to := wf_engine.GetItemAttrDate(itemtype,
263: itemkey,

Line 262: l_effective_to := wf_engine.GetItemAttrDate(itemtype,

258: 'VERSION_NUMBER');
259: l_effective_from := wf_engine.GetItemAttrDate(itemtype,
260: itemkey,
261: 'EFFECTIVE_FROM');
262: l_effective_to := wf_engine.GetItemAttrDate(itemtype,
263: itemkey,
264: 'EFFECTIVE_TO');
265: lv_message_body := '' ||
266: get_token('OKL_NAME', 'NAME', l_name) ||

Line 311: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'LRS_NAME');

307: l_effective_to DATE;
308: lv_message_body VARCHAR2(4000);
309:
310: BEGIN
311: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'LRS_NAME');
312: l_version_number := wf_engine.GetItemAttrText(itemtype,
313: itemkey,
314: 'VERSION_NUMBER');
315: l_effective_from := wf_engine.GetItemAttrDate(itemtype,

Line 312: l_version_number := wf_engine.GetItemAttrText(itemtype,

308: lv_message_body VARCHAR2(4000);
309:
310: BEGIN
311: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'LRS_NAME');
312: l_version_number := wf_engine.GetItemAttrText(itemtype,
313: itemkey,
314: 'VERSION_NUMBER');
315: l_effective_from := wf_engine.GetItemAttrDate(itemtype,
316: itemkey,

Line 315: l_effective_from := wf_engine.GetItemAttrDate(itemtype,

311: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'LRS_NAME');
312: l_version_number := wf_engine.GetItemAttrText(itemtype,
313: itemkey,
314: 'VERSION_NUMBER');
315: l_effective_from := wf_engine.GetItemAttrDate(itemtype,
316: itemkey,
317: 'EFFECTIVE_FROM');
318: l_effective_to := wf_engine.GetItemAttrDate(itemtype,
319: itemkey,

Line 318: l_effective_to := wf_engine.GetItemAttrDate(itemtype,

314: 'VERSION_NUMBER');
315: l_effective_from := wf_engine.GetItemAttrDate(itemtype,
316: itemkey,
317: 'EFFECTIVE_FROM');
318: l_effective_to := wf_engine.GetItemAttrDate(itemtype,
319: itemkey,
320: 'EFFECTIVE_TO');
321: lv_message_body := '' ||
322: get_token('OKL_NAME', 'NAME', l_name) ||

Line 401: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'PAM_NAME');

397:
398: -- according to Object Type, the message is set
399:
400: IF (object_type = 'PAM') THEN
401: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'PAM_NAME');
402: wf_engine.SetItemAttrDocument(itemtype => itemtype,
403: itemkey => itemkey,
404: aname => G_WF_ITM_MESSAGE_BODY,
405: documentid => 'plsql:okl_fe_wf.get_pam_msg_doc/' ||

Line 402: wf_engine.SetItemAttrDocument(itemtype => itemtype,

398: -- according to Object Type, the message is set
399:
400: IF (object_type = 'PAM') THEN
401: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'PAM_NAME');
402: wf_engine.SetItemAttrDocument(itemtype => itemtype,
403: itemkey => itemkey,
404: aname => G_WF_ITM_MESSAGE_BODY,
405: documentid => 'plsql:okl_fe_wf.get_pam_msg_doc/' ||
406: itemkey);

Line 407: wf_engine.SetItemAttrText(itemtype => itemtype,

403: itemkey => itemkey,
404: aname => G_WF_ITM_MESSAGE_BODY,
405: documentid => 'plsql:okl_fe_wf.get_pam_msg_doc/' ||
406: itemkey);
407: wf_engine.SetItemAttrText(itemtype => itemtype,
408: itemkey => itemkey,
409: aname => G_WF_ITM_MESSAGE_DESCR,
410: avalue => get_pam_msg_body(itemtype,
411: itemkey));

Line 413: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'SRT_NAME');

409: aname => G_WF_ITM_MESSAGE_DESCR,
410: avalue => get_pam_msg_body(itemtype,
411: itemkey));
412: ELSIF (object_type = 'SRT') THEN
413: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'SRT_NAME');
414: wf_engine.SetItemAttrText(itemtype => itemtype,
415: itemkey => itemkey,
416: aname => G_WF_ITM_MESSAGE_BODY,
417: avalue => 'plsql:okl_fe_wf.get_srt_msg_doc/' ||

Line 414: wf_engine.SetItemAttrText(itemtype => itemtype,

410: avalue => get_pam_msg_body(itemtype,
411: itemkey));
412: ELSIF (object_type = 'SRT') THEN
413: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'SRT_NAME');
414: wf_engine.SetItemAttrText(itemtype => itemtype,
415: itemkey => itemkey,
416: aname => G_WF_ITM_MESSAGE_BODY,
417: avalue => 'plsql:okl_fe_wf.get_srt_msg_doc/' ||
418: itemkey);

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

415: itemkey => itemkey,
416: aname => G_WF_ITM_MESSAGE_BODY,
417: avalue => 'plsql:okl_fe_wf.get_srt_msg_doc/' ||
418: itemkey);
419: wf_engine.SetItemAttrText(itemtype => itemtype,
420: itemkey => itemkey,
421: aname => G_WF_ITM_MESSAGE_DESCR,
422: avalue => get_srt_msg_body(itemtype,
423: itemkey));

Line 425: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'LRS_NAME');

421: aname => G_WF_ITM_MESSAGE_DESCR,
422: avalue => get_srt_msg_body(itemtype,
423: itemkey));
424: ELSIF (object_type = 'LRS') THEN
425: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'LRS_NAME');
426: wf_engine.SetItemAttrText(itemtype => itemtype,
427: itemkey => itemkey,
428: aname => G_WF_ITM_MESSAGE_BODY,
429: avalue => 'plsql:okl_fe_wf.get_lrs_msg_doc/' ||

Line 426: wf_engine.SetItemAttrText(itemtype => itemtype,

422: avalue => get_srt_msg_body(itemtype,
423: itemkey));
424: ELSIF (object_type = 'LRS') THEN
425: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'LRS_NAME');
426: wf_engine.SetItemAttrText(itemtype => itemtype,
427: itemkey => itemkey,
428: aname => G_WF_ITM_MESSAGE_BODY,
429: avalue => 'plsql:okl_fe_wf.get_lrs_msg_doc/' ||
430: itemkey);

Line 431: wf_engine.SetItemAttrText(itemtype => itemtype,

427: itemkey => itemkey,
428: aname => G_WF_ITM_MESSAGE_BODY,
429: avalue => 'plsql:okl_fe_wf.get_lrs_msg_doc/' ||
430: itemkey);
431: wf_engine.SetItemAttrText(itemtype => itemtype,
432: itemkey => itemkey,
433: aname => G_WF_ITM_MESSAGE_DESCR,
434: avalue => get_lrs_msg_body(itemtype,
435: itemkey));

Line 437: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'EOT_NAME');

433: aname => G_WF_ITM_MESSAGE_DESCR,
434: avalue => get_lrs_msg_body(itemtype,
435: itemkey));
436: ELSIF (object_type = 'EOT') THEN
437: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'EOT_NAME');
438: wf_engine.SetItemAttrText(itemtype => itemtype,
439: itemkey => itemkey,
440: aname => G_WF_ITM_MESSAGE_BODY,
441: avalue => 'plsql:okl_fe_wf.get_eot_msg_doc/' ||

Line 438: wf_engine.SetItemAttrText(itemtype => itemtype,

434: avalue => get_lrs_msg_body(itemtype,
435: itemkey));
436: ELSIF (object_type = 'EOT') THEN
437: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'EOT_NAME');
438: wf_engine.SetItemAttrText(itemtype => itemtype,
439: itemkey => itemkey,
440: aname => G_WF_ITM_MESSAGE_BODY,
441: avalue => 'plsql:okl_fe_wf.get_eot_msg_doc/' ||
442: itemkey);

Line 443: wf_engine.SetItemAttrText(itemtype => itemtype,

439: itemkey => itemkey,
440: aname => G_WF_ITM_MESSAGE_BODY,
441: avalue => 'plsql:okl_fe_wf.get_eot_msg_doc/' ||
442: itemkey);
443: wf_engine.SetItemAttrText(itemtype => itemtype,
444: itemkey => itemkey,
445: aname => G_WF_ITM_MESSAGE_DESCR,
446: avalue => get_eot_msg_body(itemtype,
447: itemkey));

Line 449: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'IRS_NAME');

445: aname => G_WF_ITM_MESSAGE_DESCR,
446: avalue => get_eot_msg_body(itemtype,
447: itemkey));
448: ELSIF (object_type = 'IRS') THEN
449: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'IRS_NAME');
450: wf_engine.SetItemAttrText(itemtype => itemtype,
451: itemkey => itemkey,
452: aname => G_WF_ITM_MESSAGE_BODY,
453: avalue => 'plsql:okl_fe_wf.get_irs_msg_doc/' ||

Line 450: wf_engine.SetItemAttrText(itemtype => itemtype,

446: avalue => get_eot_msg_body(itemtype,
447: itemkey));
448: ELSIF (object_type = 'IRS') THEN
449: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'IRS_NAME');
450: wf_engine.SetItemAttrText(itemtype => itemtype,
451: itemkey => itemkey,
452: aname => G_WF_ITM_MESSAGE_BODY,
453: avalue => 'plsql:okl_fe_wf.get_irs_msg_doc/' ||
454: itemkey);

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

451: itemkey => itemkey,
452: aname => G_WF_ITM_MESSAGE_BODY,
453: avalue => 'plsql:okl_fe_wf.get_irs_msg_doc/' ||
454: itemkey);
455: wf_engine.SetItemAttrText(itemtype => itemtype,
456: itemkey => itemkey,
457: aname => G_WF_ITM_MESSAGE_DESCR,
458: avalue => get_irs_msg_body(itemtype,
459: itemkey));

Line 476: wf_engine.SetItemAttrText(itemtype,

472: l_name);
473: l_reminder_message := get_message('OKL_FE_REMINDER_APPROVAL_SUB',
474: l_object_name,
475: l_name);
476: wf_engine.SetItemAttrText(itemtype,
477: itemkey,
478: G_WF_ITM_APP_REQUEST_SUB,
479: l_request_message);
480: wf_engine.SetItemAttrText(itemtype,

Line 480: wf_engine.SetItemAttrText(itemtype,

476: wf_engine.SetItemAttrText(itemtype,
477: itemkey,
478: G_WF_ITM_APP_REQUEST_SUB,
479: l_request_message);
480: wf_engine.SetItemAttrText(itemtype,
481: itemkey,
482: G_WF_ITM_APP_REMINDER_SUB,
483: l_reminder_message);
484: wf_engine.SetItemAttrText(itemtype,

Line 484: wf_engine.SetItemAttrText(itemtype,

480: wf_engine.SetItemAttrText(itemtype,
481: itemkey,
482: G_WF_ITM_APP_REMINDER_SUB,
483: l_reminder_message);
484: wf_engine.SetItemAttrText(itemtype,
485: itemkey,
486: G_WF_ITM_APP_REMINDER_HEAD,
487: l_reminder_message);
488: wf_engine.SetItemAttrText(itemtype,

Line 488: wf_engine.SetItemAttrText(itemtype,

484: wf_engine.SetItemAttrText(itemtype,
485: itemkey,
486: G_WF_ITM_APP_REMINDER_HEAD,
487: l_reminder_message);
488: wf_engine.SetItemAttrText(itemtype,
489: itemkey,
490: G_WF_ITM_APP_APPROVED_SUB,
491: l_approved_message);
492: wf_engine.SetItemAttrText(itemtype,

Line 492: wf_engine.SetItemAttrText(itemtype,

488: wf_engine.SetItemAttrText(itemtype,
489: itemkey,
490: G_WF_ITM_APP_APPROVED_SUB,
491: l_approved_message);
492: wf_engine.SetItemAttrText(itemtype,
493: itemkey,
494: G_WF_ITM_APP_APPROVED_HEAD,
495: l_approved_message);
496: wf_engine.SetItemAttrText(itemtype,

Line 496: wf_engine.SetItemAttrText(itemtype,

492: wf_engine.SetItemAttrText(itemtype,
493: itemkey,
494: G_WF_ITM_APP_APPROVED_HEAD,
495: l_approved_message);
496: wf_engine.SetItemAttrText(itemtype,
497: itemkey,
498: G_WF_ITM_APP_REJECTED_SUB,
499: l_rejected_message);
500: wf_engine.SetItemAttrText(itemtype,

Line 500: wf_engine.SetItemAttrText(itemtype,

496: wf_engine.SetItemAttrText(itemtype,
497: itemkey,
498: G_WF_ITM_APP_REJECTED_SUB,
499: l_rejected_message);
500: wf_engine.SetItemAttrText(itemtype,
501: itemkey,
502: G_WF_ITM_APP_REJECTED_HEAD,
503: l_rejected_message);
504: EXCEPTION

Line 643: l_version_id := wf_engine.GetItemAttrText(itemtype,

639: END IF;
640:
641: -- get the value of the version id from the workflow
642:
643: l_version_id := wf_engine.GetItemAttrText(itemtype,
644: itemkey,
645: 'VERSION_ID');
646:
647: -- set the values of the attributes from the values of the cursor

Line 651: wf_engine.SetItemAttrText(itemtype,

647: -- set the values of the attributes from the values of the cursor
648:
649: FOR l_srt_rec IN get_srt_attributes(l_version_id)
650: LOOP
651: wf_engine.SetItemAttrText(itemtype,
652: itemkey,
653: 'SRT_NAME',
654: l_srt_rec.TEMPLATE_NAME);
655: wf_engine.SetItemAttrText(itemtype,

Line 655: wf_engine.SetItemAttrText(itemtype,

651: wf_engine.SetItemAttrText(itemtype,
652: itemkey,
653: 'SRT_NAME',
654: l_srt_rec.TEMPLATE_NAME);
655: wf_engine.SetItemAttrText(itemtype,
656: itemkey,
657: 'DESCRIPTION',
658: l_srt_rec.TEMPLATE_DESC);
659: wf_engine.SetItemAttrText(itemtype,

Line 659: wf_engine.SetItemAttrText(itemtype,

655: wf_engine.SetItemAttrText(itemtype,
656: itemkey,
657: 'DESCRIPTION',
658: l_srt_rec.TEMPLATE_DESC);
659: wf_engine.SetItemAttrText(itemtype,
660: itemkey,
661: 'SRT_TYPE',
662: l_srt_rec.RATE_TYPE_CODE);
663: wf_engine.SetItemAttrText(itemtype,

Line 663: wf_engine.SetItemAttrText(itemtype,

659: wf_engine.SetItemAttrText(itemtype,
660: itemkey,
661: 'SRT_TYPE',
662: l_srt_rec.RATE_TYPE_CODE);
663: wf_engine.SetItemAttrText(itemtype,
664: itemkey,
665: 'VERSION_NUMBER',
666: l_srt_rec.VERSION_NUMBER);
667: wf_engine.SetItemAttrDate(itemtype,

Line 667: wf_engine.SetItemAttrDate(itemtype,

663: wf_engine.SetItemAttrText(itemtype,
664: itemkey,
665: 'VERSION_NUMBER',
666: l_srt_rec.VERSION_NUMBER);
667: wf_engine.SetItemAttrDate(itemtype,
668: itemkey,
669: 'EFFECTIVE_FROM',
670: l_srt_rec.EFFECTIVE_FROM_DATE);
671: wf_engine.SetItemAttrDate(itemtype,

Line 671: wf_engine.SetItemAttrDate(itemtype,

667: wf_engine.SetItemAttrDate(itemtype,
668: itemkey,
669: 'EFFECTIVE_FROM',
670: l_srt_rec.EFFECTIVE_FROM_DATE);
671: wf_engine.SetItemAttrDate(itemtype,
672: itemkey,
673: 'EFFECTIVE_TO',
674: l_srt_rec.EFFECTIVE_TO_DATE);
675: END LOOP;

Line 688: wf_engine.SetItemAttrText(itemtype,

684: CLOSE c_get_app_id_csr;
685:
686: -- set the values of the approver and the requestor
687:
688: wf_engine.SetItemAttrText(itemtype,
689: itemkey,
690: G_WF_ITM_APPROVER,
691: l_user_name);
692: wf_engine.SetItemAttrText(itemtype,

Line 692: wf_engine.SetItemAttrText(itemtype,

688: wf_engine.SetItemAttrText(itemtype,
689: itemkey,
690: G_WF_ITM_APPROVER,
691: l_user_name);
692: wf_engine.SetItemAttrText(itemtype,
693: itemkey,
694: G_WF_ITM_REQUESTER,
695: l_user_name);
696: wf_engine.SetItemAttrText(itemtype,

Line 696: wf_engine.SetItemAttrText(itemtype,

692: wf_engine.SetItemAttrText(itemtype,
693: itemkey,
694: G_WF_ITM_REQUESTER,
695: l_user_name);
696: wf_engine.SetItemAttrText(itemtype,
697: itemkey,
698: G_WF_ITM_REQUESTER_ID,
699: fnd_global.user_id);
700: wf_engine.SetItemAttrText(itemtype,

Line 700: wf_engine.SetItemAttrText(itemtype,

696: wf_engine.SetItemAttrText(itemtype,
697: itemkey,
698: G_WF_ITM_REQUESTER_ID,
699: fnd_global.user_id);
700: wf_engine.SetItemAttrText(itemtype,
701: itemkey,
702: G_WF_ITM_TRANSACTION_TYPE_ID,
703: itemtype);
704: wf_engine.SetItemAttrText(itemtype,

Line 704: wf_engine.SetItemAttrText(itemtype,

700: wf_engine.SetItemAttrText(itemtype,
701: itemkey,
702: G_WF_ITM_TRANSACTION_TYPE_ID,
703: itemtype);
704: wf_engine.SetItemAttrText(itemtype,
705: itemkey,
706: G_WF_ITM_TRANSACTION_ID,
707: l_version_id);
708: wf_engine.SetItemAttrText(itemtype,

Line 708: wf_engine.SetItemAttrText(itemtype,

704: wf_engine.SetItemAttrText(itemtype,
705: itemkey,
706: G_WF_ITM_TRANSACTION_ID,
707: l_version_id);
708: wf_engine.SetItemAttrText(itemtype,
709: itemkey,
710: G_WF_ITM_APPLICATION_ID,
711: l_application_id);
712: EXCEPTION

Line 744: l_result := wf_engine.GetItemAttrText(itemtype, itemkey, 'RESULT');

740:
741: BEGIN
742:
743: IF (funcmode = 'RUN') THEN
744: l_result := wf_engine.GetItemAttrText(itemtype, itemkey, 'RESULT');
745: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
746: itemkey => itemkey,
747: aname => 'APPROVED_YN');
748:

Line 745: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,

741: BEGIN
742:
743: IF (funcmode = 'RUN') THEN
744: l_result := wf_engine.GetItemAttrText(itemtype, itemkey, 'RESULT');
745: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
746: itemkey => itemkey,
747: aname => 'APPROVED_YN');
748:
749: -- if approved, then change the status

Line 752: l_srt_id := wf_engine.GetItemAttrText(itemtype,

748:
749: -- if approved, then change the status
750:
751: IF (l_result = G_WF_ITM_APPROVED_YN_YES OR lv_approval_status_ame = 'Y') THEN
752: l_srt_id := wf_engine.GetItemAttrText(itemtype,
753: itemkey,
754: 'VERSION_ID');
755:
756: -- change the version and header status and end date referenced objects

Line 770: l_srt_id := wf_engine.GetItemAttrText(itemtype,

766: ELSIF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
767: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
768: END IF;
769: ELSE
770: l_srt_id := wf_engine.GetItemAttrText(itemtype,
771: itemkey,
772: 'VERSION_ID');
773:
774: -- populate the version attributes

Line 870: l_adj_mat_version_id := wf_engine.GetItemAttrText(itemtype,

866: END IF;
867:
868: -- get the value of the version id from the workflow
869:
870: l_adj_mat_version_id := wf_engine.GetItemAttrText(itemtype,
871: itemkey,
872: 'VERSION_ID');
873:
874: -- set the values of the attributes from the values of the cursor

Line 878: wf_engine.SetItemAttrText(itemtype,

874: -- set the values of the attributes from the values of the cursor
875:
876: FOR l_adj_mat_rec IN get_adj_mat_attr(l_adj_mat_version_id)
877: LOOP
878: wf_engine.SetItemAttrText(itemtype,
879: itemkey,
880: 'PAM_NAME',
881: l_adj_mat_rec.ADJ_MAT_NAME);
882: wf_engine.SetItemAttrText(itemtype,

Line 882: wf_engine.SetItemAttrText(itemtype,

878: wf_engine.SetItemAttrText(itemtype,
879: itemkey,
880: 'PAM_NAME',
881: l_adj_mat_rec.ADJ_MAT_NAME);
882: wf_engine.SetItemAttrText(itemtype,
883: itemkey,
884: 'CURRENCY',
885: l_adj_mat_rec.CURRENCY_CODE);
886: wf_engine.SetItemAttrText(itemtype,

Line 886: wf_engine.SetItemAttrText(itemtype,

882: wf_engine.SetItemAttrText(itemtype,
883: itemkey,
884: 'CURRENCY',
885: l_adj_mat_rec.CURRENCY_CODE);
886: wf_engine.SetItemAttrText(itemtype,
887: itemkey,
888: 'VERSION_NUMBER',
889: l_adj_mat_rec.VERSION_NUMBER);
890: wf_engine.SetItemAttrDate(itemtype,

Line 890: wf_engine.SetItemAttrDate(itemtype,

886: wf_engine.SetItemAttrText(itemtype,
887: itemkey,
888: 'VERSION_NUMBER',
889: l_adj_mat_rec.VERSION_NUMBER);
890: wf_engine.SetItemAttrDate(itemtype,
891: itemkey,
892: 'EFFECTIVE_FROM',
893: l_adj_mat_rec.EFFECTIVE_FROM_DATE);
894: wf_engine.SetItemAttrDate(itemtype,

Line 894: wf_engine.SetItemAttrDate(itemtype,

890: wf_engine.SetItemAttrDate(itemtype,
891: itemkey,
892: 'EFFECTIVE_FROM',
893: l_adj_mat_rec.EFFECTIVE_FROM_DATE);
894: wf_engine.SetItemAttrDate(itemtype,
895: itemkey,
896: 'EFFECTIVE_TO',
897: l_adj_mat_rec.EFFECTIVE_TO_DATE);
898: END LOOP;

Line 911: wf_engine.SetItemAttrText(itemtype,

907: CLOSE c_get_app_id_csr;
908:
909: -- set the values of the approver and the requestor
910:
911: wf_engine.SetItemAttrText(itemtype,
912: itemkey,
913: G_WF_ITM_APPROVER,
914: l_user_name);
915: wf_engine.SetItemAttrText(itemtype,

Line 915: wf_engine.SetItemAttrText(itemtype,

911: wf_engine.SetItemAttrText(itemtype,
912: itemkey,
913: G_WF_ITM_APPROVER,
914: l_user_name);
915: wf_engine.SetItemAttrText(itemtype,
916: itemkey,
917: G_WF_ITM_REQUESTER,
918: l_user_name);
919: wf_engine.SetItemAttrText(itemtype,

Line 919: wf_engine.SetItemAttrText(itemtype,

915: wf_engine.SetItemAttrText(itemtype,
916: itemkey,
917: G_WF_ITM_REQUESTER,
918: l_user_name);
919: wf_engine.SetItemAttrText(itemtype,
920: itemkey,
921: G_WF_ITM_REQUESTER_ID,
922: fnd_global.user_id);
923: wf_engine.SetItemAttrText(itemtype,

Line 923: wf_engine.SetItemAttrText(itemtype,

919: wf_engine.SetItemAttrText(itemtype,
920: itemkey,
921: G_WF_ITM_REQUESTER_ID,
922: fnd_global.user_id);
923: wf_engine.SetItemAttrText(itemtype,
924: itemkey,
925: G_WF_ITM_TRANSACTION_TYPE_ID,
926: itemtype);
927: wf_engine.SetItemAttrText(itemtype,

Line 927: wf_engine.SetItemAttrText(itemtype,

923: wf_engine.SetItemAttrText(itemtype,
924: itemkey,
925: G_WF_ITM_TRANSACTION_TYPE_ID,
926: itemtype);
927: wf_engine.SetItemAttrText(itemtype,
928: itemkey,
929: G_WF_ITM_TRANSACTION_ID,
930: l_adj_mat_version_id);
931: wf_engine.SetItemAttrText(itemtype,

Line 931: wf_engine.SetItemAttrText(itemtype,

927: wf_engine.SetItemAttrText(itemtype,
928: itemkey,
929: G_WF_ITM_TRANSACTION_ID,
930: l_adj_mat_version_id);
931: wf_engine.SetItemAttrText(itemtype,
932: itemkey,
933: G_WF_ITM_APPLICATION_ID,
934: l_application_id);
935: EXCEPTION

Line 967: l_result := wf_engine.GetItemAttrText(itemtype, itemkey, 'RESULT');

963:
964: BEGIN
965:
966: IF (funcmode = 'RUN') THEN
967: l_result := wf_engine.GetItemAttrText(itemtype, itemkey, 'RESULT');
968: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
969: itemkey => itemkey,
970: aname => 'APPROVED_YN');
971: IF (l_result = G_WF_ITM_APPROVED_YN_YES OR lv_approval_status_ame = 'Y') THEN

Line 968: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,

964: BEGIN
965:
966: IF (funcmode = 'RUN') THEN
967: l_result := wf_engine.GetItemAttrText(itemtype, itemkey, 'RESULT');
968: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
969: itemkey => itemkey,
970: aname => 'APPROVED_YN');
971: IF (l_result = G_WF_ITM_APPROVED_YN_YES OR lv_approval_status_ame = 'Y') THEN
972: l_pam_id := wf_engine.GetItemAttrText(itemtype,

Line 972: l_pam_id := wf_engine.GetItemAttrText(itemtype,

968: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
969: itemkey => itemkey,
970: aname => 'APPROVED_YN');
971: IF (l_result = G_WF_ITM_APPROVED_YN_YES OR lv_approval_status_ame = 'Y') THEN
972: l_pam_id := wf_engine.GetItemAttrText(itemtype,
973: itemkey,
974: 'VERSION_ID');
975:
976: -- change the version and header status and end date referenced objects

Line 990: l_pam_id := wf_engine.GetItemAttrText(itemtype,

986: ELSIF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
987: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
988: END IF;
989: ELSE
990: l_pam_id := wf_engine.GetItemAttrText(itemtype,
991: itemkey,
992: 'VERSION_ID');
993:
994: -- populate the version attributes

Line 1094: l_eot_version_id := wf_engine.GetItemAttrText(itemtype,

1090: END IF;
1091:
1092: -- get the value of the version id from the workflow
1093:
1094: l_eot_version_id := wf_engine.GetItemAttrText(itemtype,
1095: itemkey,
1096: 'VERSION_ID');
1097:
1098: -- set the values of the attributes from the values of the cursor

Line 1102: wf_engine.SetItemAttrText(itemtype,

1098: -- set the values of the attributes from the values of the cursor
1099:
1100: FOR l_eot_val_rec IN get_end_of_term_attr(l_eot_version_id)
1101: LOOP
1102: wf_engine.SetItemAttrText(itemtype,
1103: itemkey,
1104: 'EOT_NAME',
1105: l_eot_val_rec.END_OF_TERM_NAME);
1106: wf_engine.SetItemAttrText(itemtype,

Line 1106: wf_engine.SetItemAttrText(itemtype,

1102: wf_engine.SetItemAttrText(itemtype,
1103: itemkey,
1104: 'EOT_NAME',
1105: l_eot_val_rec.END_OF_TERM_NAME);
1106: wf_engine.SetItemAttrText(itemtype,
1107: itemkey,
1108: 'DESCRIPTION',
1109: l_eot_val_rec.END_OF_TERM_DESC);
1110: wf_engine.SetItemAttrText(itemtype,

Line 1110: wf_engine.SetItemAttrText(itemtype,

1106: wf_engine.SetItemAttrText(itemtype,
1107: itemkey,
1108: 'DESCRIPTION',
1109: l_eot_val_rec.END_OF_TERM_DESC);
1110: wf_engine.SetItemAttrText(itemtype,
1111: itemkey,
1112: 'SOURCE',
1113: l_eot_val_rec.CATEGORY_TYPE_CODE);
1114: wf_engine.SetItemAttrText(itemtype,

Line 1114: wf_engine.SetItemAttrText(itemtype,

1110: wf_engine.SetItemAttrText(itemtype,
1111: itemkey,
1112: 'SOURCE',
1113: l_eot_val_rec.CATEGORY_TYPE_CODE);
1114: wf_engine.SetItemAttrText(itemtype,
1115: itemkey,
1116: 'VALUE_TYPE',
1117: l_eot_val_rec.CATEGORY_TYPE_CODE);
1118: wf_engine.SetItemAttrText(itemtype,

Line 1118: wf_engine.SetItemAttrText(itemtype,

1114: wf_engine.SetItemAttrText(itemtype,
1115: itemkey,
1116: 'VALUE_TYPE',
1117: l_eot_val_rec.CATEGORY_TYPE_CODE);
1118: wf_engine.SetItemAttrText(itemtype,
1119: itemkey,
1120: 'CURRENCY',
1121: l_eot_val_rec.CURRENCY_CODE);
1122: wf_engine.SetItemAttrText(itemtype,

Line 1122: wf_engine.SetItemAttrText(itemtype,

1118: wf_engine.SetItemAttrText(itemtype,
1119: itemkey,
1120: 'CURRENCY',
1121: l_eot_val_rec.CURRENCY_CODE);
1122: wf_engine.SetItemAttrText(itemtype,
1123: itemkey,
1124: 'VERSION_NUMBER',
1125: l_eot_val_rec.VERSION_NUMBER);
1126: wf_engine.SetItemAttrDate(itemtype,

Line 1126: wf_engine.SetItemAttrDate(itemtype,

1122: wf_engine.SetItemAttrText(itemtype,
1123: itemkey,
1124: 'VERSION_NUMBER',
1125: l_eot_val_rec.VERSION_NUMBER);
1126: wf_engine.SetItemAttrDate(itemtype,
1127: itemkey,
1128: 'EFFECTIVE_FROM',
1129: l_eot_val_rec.EFFECTIVE_FROM_DATE);
1130: wf_engine.SetItemAttrDate(itemtype,

Line 1130: wf_engine.SetItemAttrDate(itemtype,

1126: wf_engine.SetItemAttrDate(itemtype,
1127: itemkey,
1128: 'EFFECTIVE_FROM',
1129: l_eot_val_rec.EFFECTIVE_FROM_DATE);
1130: wf_engine.SetItemAttrDate(itemtype,
1131: itemkey,
1132: 'EFFECTIVE_TO',
1133: l_eot_val_rec.EFFECTIVE_TO_DATE);
1134: END LOOP;

Line 1147: wf_engine.SetItemAttrText(itemtype,

1143: CLOSE c_get_app_id_csr;
1144:
1145: -- set the values of the approver and the requestor
1146:
1147: wf_engine.SetItemAttrText(itemtype,
1148: itemkey,
1149: G_WF_ITM_APPROVER,
1150: l_user_name);
1151: wf_engine.SetItemAttrText(itemtype,

Line 1151: wf_engine.SetItemAttrText(itemtype,

1147: wf_engine.SetItemAttrText(itemtype,
1148: itemkey,
1149: G_WF_ITM_APPROVER,
1150: l_user_name);
1151: wf_engine.SetItemAttrText(itemtype,
1152: itemkey,
1153: G_WF_ITM_REQUESTER,
1154: l_user_name);
1155: wf_engine.SetItemAttrText(itemtype,

Line 1155: wf_engine.SetItemAttrText(itemtype,

1151: wf_engine.SetItemAttrText(itemtype,
1152: itemkey,
1153: G_WF_ITM_REQUESTER,
1154: l_user_name);
1155: wf_engine.SetItemAttrText(itemtype,
1156: itemkey,
1157: G_WF_ITM_REQUESTER_ID,
1158: fnd_global.user_id);
1159: wf_engine.SetItemAttrText(itemtype,

Line 1159: wf_engine.SetItemAttrText(itemtype,

1155: wf_engine.SetItemAttrText(itemtype,
1156: itemkey,
1157: G_WF_ITM_REQUESTER_ID,
1158: fnd_global.user_id);
1159: wf_engine.SetItemAttrText(itemtype,
1160: itemkey,
1161: G_WF_ITM_TRANSACTION_TYPE_ID,
1162: itemtype);
1163: wf_engine.SetItemAttrText(itemtype,

Line 1163: wf_engine.SetItemAttrText(itemtype,

1159: wf_engine.SetItemAttrText(itemtype,
1160: itemkey,
1161: G_WF_ITM_TRANSACTION_TYPE_ID,
1162: itemtype);
1163: wf_engine.SetItemAttrText(itemtype,
1164: itemkey,
1165: G_WF_ITM_TRANSACTION_ID,
1166: l_eot_version_id);
1167: wf_engine.SetItemAttrText(itemtype,

Line 1167: wf_engine.SetItemAttrText(itemtype,

1163: wf_engine.SetItemAttrText(itemtype,
1164: itemkey,
1165: G_WF_ITM_TRANSACTION_ID,
1166: l_eot_version_id);
1167: wf_engine.SetItemAttrText(itemtype,
1168: itemkey,
1169: G_WF_ITM_APPLICATION_ID,
1170: l_application_id);
1171: EXCEPTION

Line 1203: l_result := wf_engine.GetItemAttrText(itemtype, itemkey, 'RESULT');

1199:
1200: BEGIN
1201:
1202: IF (funcmode = 'RUN') THEN
1203: l_result := wf_engine.GetItemAttrText(itemtype, itemkey, 'RESULT');
1204: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
1205: itemkey => itemkey,
1206: aname => 'APPROVED_YN');
1207: IF (l_result = G_WF_ITM_APPROVED_YN_YES OR lv_approval_status_ame = 'Y') THEN

Line 1204: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,

1200: BEGIN
1201:
1202: IF (funcmode = 'RUN') THEN
1203: l_result := wf_engine.GetItemAttrText(itemtype, itemkey, 'RESULT');
1204: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
1205: itemkey => itemkey,
1206: aname => 'APPROVED_YN');
1207: IF (l_result = G_WF_ITM_APPROVED_YN_YES OR lv_approval_status_ame = 'Y') THEN
1208: l_eot_id := wf_engine.GetItemAttrText(itemtype,

Line 1208: l_eot_id := wf_engine.GetItemAttrText(itemtype,

1204: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
1205: itemkey => itemkey,
1206: aname => 'APPROVED_YN');
1207: IF (l_result = G_WF_ITM_APPROVED_YN_YES OR lv_approval_status_ame = 'Y') THEN
1208: l_eot_id := wf_engine.GetItemAttrText(itemtype,
1209: itemkey,
1210: 'VERSION_ID');
1211:
1212: -- change the version and header status and end date referenced objects

Line 1226: l_eot_id := wf_engine.GetItemAttrText(itemtype,

1222: ELSIF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1223: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1224: END IF;
1225: ELSE
1226: l_eot_id := wf_engine.GetItemAttrText(itemtype,
1227: itemkey,
1228: 'VERSION_ID');
1229:
1230: -- populate the version attributes

Line 1335: l_rate_set_ver_id := wf_engine.GetItemAttrText(itemtype,

1331: END IF;
1332:
1333: -- get the value of the version id from the workflow
1334:
1335: l_rate_set_ver_id := wf_engine.GetItemAttrText(itemtype,
1336: itemkey,
1337: 'VERSION_ID');
1338:
1339: -- set the values of the attributes from the values of the cursor

Line 1347: wf_engine.SetItemAttrText(itemtype,

1343: CLOSE get_lrs_attr;
1344:
1345: -- set all the attributes of Lease Rate Set
1346:
1347: wf_engine.SetItemAttrText(itemtype,
1348: itemkey,
1349: 'LRS_NAME',
1350: l_lrv_rec.name);
1351: wf_engine.SetItemAttrText(itemtype,

Line 1351: wf_engine.SetItemAttrText(itemtype,

1347: wf_engine.SetItemAttrText(itemtype,
1348: itemkey,
1349: 'LRS_NAME',
1350: l_lrv_rec.name);
1351: wf_engine.SetItemAttrText(itemtype,
1352: itemkey,
1353: 'DESCRIPTION',
1354: l_lrv_rec.description);
1355: wf_engine.SetItemAttrText(itemtype,

Line 1355: wf_engine.SetItemAttrText(itemtype,

1351: wf_engine.SetItemAttrText(itemtype,
1352: itemkey,
1353: 'DESCRIPTION',
1354: l_lrv_rec.description);
1355: wf_engine.SetItemAttrText(itemtype,
1356: itemkey,
1357: 'TYPE',
1358: l_lrv_rec.lrs_type_code);
1359: wf_engine.SetItemAttrText(itemtype,

Line 1359: wf_engine.SetItemAttrText(itemtype,

1355: wf_engine.SetItemAttrText(itemtype,
1356: itemkey,
1357: 'TYPE',
1358: l_lrv_rec.lrs_type_code);
1359: wf_engine.SetItemAttrText(itemtype,
1360: itemkey,
1361: 'EOT_ID',
1362: l_lrv_rec.end_of_term_id);
1363: wf_engine.SetItemAttrText(itemtype,

Line 1363: wf_engine.SetItemAttrText(itemtype,

1359: wf_engine.SetItemAttrText(itemtype,
1360: itemkey,
1361: 'EOT_ID',
1362: l_lrv_rec.end_of_term_id);
1363: wf_engine.SetItemAttrText(itemtype,
1364: itemkey,
1365: 'CURRENCY',
1366: l_lrv_rec.currency_code);
1367: wf_engine.SetItemAttrText(itemtype,

Line 1367: wf_engine.SetItemAttrText(itemtype,

1363: wf_engine.SetItemAttrText(itemtype,
1364: itemkey,
1365: 'CURRENCY',
1366: l_lrv_rec.currency_code);
1367: wf_engine.SetItemAttrText(itemtype,
1368: itemkey,
1369: 'FREQUENCY',
1370: l_lrv_rec.frq_code);
1371: wf_engine.SetItemAttrText(itemtype,

Line 1371: wf_engine.SetItemAttrText(itemtype,

1367: wf_engine.SetItemAttrText(itemtype,
1368: itemkey,
1369: 'FREQUENCY',
1370: l_lrv_rec.frq_code);
1371: wf_engine.SetItemAttrText(itemtype,
1372: itemkey,
1373: 'VERSION_ID',
1374: l_lrv_rec.rate_set_version_id);
1375: wf_engine.SetItemAttrText(itemtype,

Line 1375: wf_engine.SetItemAttrText(itemtype,

1371: wf_engine.SetItemAttrText(itemtype,
1372: itemkey,
1373: 'VERSION_ID',
1374: l_lrv_rec.rate_set_version_id);
1375: wf_engine.SetItemAttrText(itemtype,
1376: itemkey,
1377: 'VERSION_NUMBER',
1378: l_lrv_rec.version_number);
1379: wf_engine.SetItemAttrText(itemtype,

Line 1379: wf_engine.SetItemAttrText(itemtype,

1375: wf_engine.SetItemAttrText(itemtype,
1376: itemkey,
1377: 'VERSION_NUMBER',
1378: l_lrv_rec.version_number);
1379: wf_engine.SetItemAttrText(itemtype,
1380: itemkey,
1381: 'VERSION_STATUS',
1382: l_lrv_rec.STS_CODE);
1383: wf_engine.SetItemAttrDate(itemtype,

Line 1383: wf_engine.SetItemAttrDate(itemtype,

1379: wf_engine.SetItemAttrText(itemtype,
1380: itemkey,
1381: 'VERSION_STATUS',
1382: l_lrv_rec.STS_CODE);
1383: wf_engine.SetItemAttrDate(itemtype,
1384: itemkey,
1385: 'EFFECTIVE_FROM',
1386: l_lrv_rec.EFFECTIVE_FROM_DATE);
1387: wf_engine.SetItemAttrDate(itemtype,

Line 1387: wf_engine.SetItemAttrDate(itemtype,

1383: wf_engine.SetItemAttrDate(itemtype,
1384: itemkey,
1385: 'EFFECTIVE_FROM',
1386: l_lrv_rec.EFFECTIVE_FROM_DATE);
1387: wf_engine.SetItemAttrDate(itemtype,
1388: itemkey,
1389: 'EFFECTIVE_TO',
1390: l_lrv_rec.EFFECTIVE_TO_DATE);
1391: wf_engine.SetItemAttrText(itemtype,

Line 1391: wf_engine.SetItemAttrText(itemtype,

1387: wf_engine.SetItemAttrDate(itemtype,
1388: itemkey,
1389: 'EFFECTIVE_TO',
1390: l_lrv_rec.EFFECTIVE_TO_DATE);
1391: wf_engine.SetItemAttrText(itemtype,
1392: itemkey,
1393: 'EOT_VERSION_ID',
1394: l_lrv_rec.end_of_term_ver_id);
1395: wf_engine.SetItemAttrText(itemtype,

Line 1395: wf_engine.SetItemAttrText(itemtype,

1391: wf_engine.SetItemAttrText(itemtype,
1392: itemkey,
1393: 'EOT_VERSION_ID',
1394: l_lrv_rec.end_of_term_ver_id);
1395: wf_engine.SetItemAttrText(itemtype,
1396: itemkey,
1397: 'SRT_VERSION_ID',
1398: l_lrv_rec.STD_RATE_TMPL_VER_ID);
1399: wf_engine.SetItemAttrNumber(itemtype,

Line 1399: wf_engine.SetItemAttrNumber(itemtype,

1395: wf_engine.SetItemAttrText(itemtype,
1396: itemkey,
1397: 'SRT_VERSION_ID',
1398: l_lrv_rec.STD_RATE_TMPL_VER_ID);
1399: wf_engine.SetItemAttrNumber(itemtype,
1400: itemkey,
1401: 'RATE',
1402: l_lrv_rec.lrs_Rate);
1403: wf_engine.SetItemAttrText(itemtype,

Line 1403: wf_engine.SetItemAttrText(itemtype,

1399: wf_engine.SetItemAttrNumber(itemtype,
1400: itemkey,
1401: 'RATE',
1402: l_lrv_rec.lrs_Rate);
1403: wf_engine.SetItemAttrText(itemtype,
1404: itemkey,
1405: 'ARREARS',
1406: l_lrv_rec.arrears_yn);
1407: wf_engine.SetItemAttrNumber(itemtype,

Line 1407: wf_engine.SetItemAttrNumber(itemtype,

1403: wf_engine.SetItemAttrText(itemtype,
1404: itemkey,
1405: 'ARREARS',
1406: l_lrv_rec.arrears_yn);
1407: wf_engine.SetItemAttrNumber(itemtype,
1408: itemkey,
1409: 'RATE_TOLERANCE',
1410: l_lrv_rec.RATE_TOLERANCE);
1411: wf_engine.SetItemAttrNumber(itemtype,

Line 1411: wf_engine.SetItemAttrNumber(itemtype,

1407: wf_engine.SetItemAttrNumber(itemtype,
1408: itemkey,
1409: 'RATE_TOLERANCE',
1410: l_lrv_rec.RATE_TOLERANCE);
1411: wf_engine.SetItemAttrNumber(itemtype,
1412: itemkey,
1413: 'RESIDUAL_TOLERANCE',
1414: l_lrv_rec.RESIDUAL_TOLERANCE);
1415: wf_engine.SetItemAttrNumber(itemtype,

Line 1415: wf_engine.SetItemAttrNumber(itemtype,

1411: wf_engine.SetItemAttrNumber(itemtype,
1412: itemkey,
1413: 'RESIDUAL_TOLERANCE',
1414: l_lrv_rec.RESIDUAL_TOLERANCE);
1415: wf_engine.SetItemAttrNumber(itemtype,
1416: itemkey,
1417: 'DEFERRED_PAYMENT',
1418: l_lrv_rec.deferred_pmts);
1419: wf_engine.SetItemAttrNumber(itemtype,

Line 1419: wf_engine.SetItemAttrNumber(itemtype,

1415: wf_engine.SetItemAttrNumber(itemtype,
1416: itemkey,
1417: 'DEFERRED_PAYMENT',
1418: l_lrv_rec.deferred_pmts);
1419: wf_engine.SetItemAttrNumber(itemtype,
1420: itemkey,
1421: 'ADVANCE_PAYMENT',
1422: l_lrv_rec.advance_pmts);
1423: wf_engine.SetItemAttrText(itemtype,

Line 1423: wf_engine.SetItemAttrText(itemtype,

1419: wf_engine.SetItemAttrNumber(itemtype,
1420: itemkey,
1421: 'ADVANCE_PAYMENT',
1422: l_lrv_rec.advance_pmts);
1423: wf_engine.SetItemAttrText(itemtype,
1424: itemkey,
1425: 'ADJ_MAT_ID',
1426: l_lrv_rec.ADJ_MAT_VERSION_ID);
1427:

Line 1442: wf_engine.SetItemAttrText(itemtype,

1438: CLOSE c_get_app_id_csr;
1439:
1440: -- set the values of the approver and the requestor
1441:
1442: wf_engine.SetItemAttrText(itemtype,
1443: itemkey,
1444: G_WF_ITM_APPROVER,
1445: l_user_name);
1446: wf_engine.SetItemAttrText(itemtype,

Line 1446: wf_engine.SetItemAttrText(itemtype,

1442: wf_engine.SetItemAttrText(itemtype,
1443: itemkey,
1444: G_WF_ITM_APPROVER,
1445: l_user_name);
1446: wf_engine.SetItemAttrText(itemtype,
1447: itemkey,
1448: G_WF_ITM_REQUESTER,
1449: l_user_name);
1450: wf_engine.SetItemAttrText(itemtype,

Line 1450: wf_engine.SetItemAttrText(itemtype,

1446: wf_engine.SetItemAttrText(itemtype,
1447: itemkey,
1448: G_WF_ITM_REQUESTER,
1449: l_user_name);
1450: wf_engine.SetItemAttrText(itemtype,
1451: itemkey,
1452: G_WF_ITM_REQUESTER_ID,
1453: fnd_global.user_id);
1454: wf_engine.SetItemAttrText(itemtype,

Line 1454: wf_engine.SetItemAttrText(itemtype,

1450: wf_engine.SetItemAttrText(itemtype,
1451: itemkey,
1452: G_WF_ITM_REQUESTER_ID,
1453: fnd_global.user_id);
1454: wf_engine.SetItemAttrText(itemtype,
1455: itemkey,
1456: G_WF_ITM_TRANSACTION_TYPE_ID,
1457: itemtype);
1458: wf_engine.SetItemAttrText(itemtype,

Line 1458: wf_engine.SetItemAttrText(itemtype,

1454: wf_engine.SetItemAttrText(itemtype,
1455: itemkey,
1456: G_WF_ITM_TRANSACTION_TYPE_ID,
1457: itemtype);
1458: wf_engine.SetItemAttrText(itemtype,
1459: itemkey,
1460: G_WF_ITM_TRANSACTION_ID,
1461: l_rate_set_ver_id);
1462: wf_engine.SetItemAttrText(itemtype,

Line 1462: wf_engine.SetItemAttrText(itemtype,

1458: wf_engine.SetItemAttrText(itemtype,
1459: itemkey,
1460: G_WF_ITM_TRANSACTION_ID,
1461: l_rate_set_ver_id);
1462: wf_engine.SetItemAttrText(itemtype,
1463: itemkey,
1464: G_WF_ITM_APPLICATION_ID,
1465: l_application_id);
1466: EXCEPTION

Line 1499: l_result := wf_engine.GetItemAttrText(itemtype, itemkey, 'RESULT');

1495:
1496: BEGIN
1497:
1498: IF (funcmode = 'RUN') THEN
1499: l_result := wf_engine.GetItemAttrText(itemtype, itemkey, 'RESULT');
1500: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
1501: itemkey => itemkey,
1502: aname => 'APPROVED_YN');
1503:

Line 1500: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,

1496: BEGIN
1497:
1498: IF (funcmode = 'RUN') THEN
1499: l_result := wf_engine.GetItemAttrText(itemtype, itemkey, 'RESULT');
1500: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
1501: itemkey => itemkey,
1502: aname => 'APPROVED_YN');
1503:
1504: -- check if the workflow is approved or rejected

Line 1510: l_rate_set_ver_id := wf_engine.GetItemAttrText(itemtype,

1506: IF (l_result = G_WF_ITM_APPROVED_YN_YES OR lv_approval_status_ame = 'Y') THEN
1507:
1508: -- change the status of the Lease Rate Set
1509:
1510: l_rate_set_ver_id := wf_engine.GetItemAttrText(itemtype,
1511: itemkey,
1512: 'VERSION_ID');
1513: okl_lease_rate_Sets_pvt.activate_lease_rate_set(1,
1514: 'T',

Line 1525: l_rate_set_ver_id := wf_engine.GetItemAttrText(itemtype,

1521: ELSIF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1522: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1523: END IF;
1524: ELSE
1525: l_rate_set_ver_id := wf_engine.GetItemAttrText(itemtype,
1526: itemkey,
1527: 'VERSION_ID');
1528:
1529: -- populate the version attributes

Line 1692: l_item_resdl_version_id := wf_engine.GetItemAttrText(itemtype,

1688: END IF;
1689:
1690: -- get the value of the version id from the workflow
1691:
1692: l_item_resdl_version_id := wf_engine.GetItemAttrText(itemtype,
1693: itemkey,
1694: 'VERSION_ID');/*
1695: Select the category type of the item residual.
1696: */

Line 1717: wf_engine.SetItemAttrText(itemtype,

1713: END CASE;
1714:
1715: -- set the attributes of the workflow
1716:
1717: wf_engine.SetItemAttrText(itemtype,
1718: itemkey,
1719: 'IRS_NAME',
1720: l_attr_rec.name);
1721: wf_engine.SetItemAttrText(itemtype,

Line 1721: wf_engine.SetItemAttrText(itemtype,

1717: wf_engine.SetItemAttrText(itemtype,
1718: itemkey,
1719: 'IRS_NAME',
1720: l_attr_rec.name);
1721: wf_engine.SetItemAttrText(itemtype,
1722: itemkey,
1723: 'SOURCE',
1724: l_attr_rec.category_type_code);
1725: wf_engine.SetItemAttrText(itemtype,

Line 1725: wf_engine.SetItemAttrText(itemtype,

1721: wf_engine.SetItemAttrText(itemtype,
1722: itemkey,
1723: 'SOURCE',
1724: l_attr_rec.category_type_code);
1725: wf_engine.SetItemAttrText(itemtype,
1726: itemkey,
1727: 'INVENTORY_ITEM_ID',
1728: l_attr_rec.inventory_item_id);
1729: wf_engine.SetItemAttrText(itemtype,

Line 1729: wf_engine.SetItemAttrText(itemtype,

1725: wf_engine.SetItemAttrText(itemtype,
1726: itemkey,
1727: 'INVENTORY_ITEM_ID',
1728: l_attr_rec.inventory_item_id);
1729: wf_engine.SetItemAttrText(itemtype,
1730: itemkey,
1731: 'ORGANIZATION_ID',
1732: l_attr_rec.organization_id);
1733: wf_engine.SetItemAttrText(itemtype,

Line 1733: wf_engine.SetItemAttrText(itemtype,

1729: wf_engine.SetItemAttrText(itemtype,
1730: itemkey,
1731: 'ORGANIZATION_ID',
1732: l_attr_rec.organization_id);
1733: wf_engine.SetItemAttrText(itemtype,
1734: itemkey,
1735: 'CATEGORY_ID',
1736: l_attr_rec.category_id);
1737: wf_engine.SetItemAttrText(itemtype,

Line 1737: wf_engine.SetItemAttrText(itemtype,

1733: wf_engine.SetItemAttrText(itemtype,
1734: itemkey,
1735: 'CATEGORY_ID',
1736: l_attr_rec.category_id);
1737: wf_engine.SetItemAttrText(itemtype,
1738: itemkey,
1739: 'CATEGORY_SET_ID',
1740: l_attr_rec.category_set_id);
1741: wf_engine.SetItemAttrText(itemtype,

Line 1741: wf_engine.SetItemAttrText(itemtype,

1737: wf_engine.SetItemAttrText(itemtype,
1738: itemkey,
1739: 'CATEGORY_SET_ID',
1740: l_attr_rec.category_set_id);
1741: wf_engine.SetItemAttrText(itemtype,
1742: itemkey,
1743: 'RCS_ID',
1744: l_attr_rec.resi_category_set_id);
1745: wf_engine.SetItemAttrText(itemtype,

Line 1745: wf_engine.SetItemAttrText(itemtype,

1741: wf_engine.SetItemAttrText(itemtype,
1742: itemkey,
1743: 'RCS_ID',
1744: l_attr_rec.resi_category_set_id);
1745: wf_engine.SetItemAttrText(itemtype,
1746: itemkey,
1747: 'RESIDUAL_TYPE',
1748: l_attr_rec.residual_type_code);
1749: wf_engine.SetItemAttrText(itemtype,

Line 1749: wf_engine.SetItemAttrText(itemtype,

1745: wf_engine.SetItemAttrText(itemtype,
1746: itemkey,
1747: 'RESIDUAL_TYPE',
1748: l_attr_rec.residual_type_code);
1749: wf_engine.SetItemAttrText(itemtype,
1750: itemkey,
1751: 'CURRENCY',
1752: l_attr_rec.currency_code);
1753: wf_engine.SetItemAttrText(itemtype,

Line 1753: wf_engine.SetItemAttrText(itemtype,

1749: wf_engine.SetItemAttrText(itemtype,
1750: itemkey,
1751: 'CURRENCY',
1752: l_attr_rec.currency_code);
1753: wf_engine.SetItemAttrText(itemtype,
1754: itemkey,
1755: 'IRS_NAME',
1756: l_attr_rec.name);
1757: wf_engine.SetItemAttrText(itemtype,

Line 1757: wf_engine.SetItemAttrText(itemtype,

1753: wf_engine.SetItemAttrText(itemtype,
1754: itemkey,
1755: 'IRS_NAME',
1756: l_attr_rec.name);
1757: wf_engine.SetItemAttrText(itemtype,
1758: itemkey,
1759: 'VERSION_NUMBER',
1760: l_attr_rec.version_number);
1761: wf_engine.SetItemAttrText(itemtype,

Line 1761: wf_engine.SetItemAttrText(itemtype,

1757: wf_engine.SetItemAttrText(itemtype,
1758: itemkey,
1759: 'VERSION_NUMBER',
1760: l_attr_rec.version_number);
1761: wf_engine.SetItemAttrText(itemtype,
1762: itemkey,
1763: 'VERSION_STATUS',
1764: l_attr_rec.sts_code);
1765: wf_engine.SetItemAttrDate(itemtype,

Line 1765: wf_engine.SetItemAttrDate(itemtype,

1761: wf_engine.SetItemAttrText(itemtype,
1762: itemkey,
1763: 'VERSION_STATUS',
1764: l_attr_rec.sts_code);
1765: wf_engine.SetItemAttrDate(itemtype,
1766: itemkey,
1767: 'EFFECTIVE_FROM',
1768: l_attr_rec.start_date);
1769: wf_engine.SetItemAttrDate(itemtype,

Line 1769: wf_engine.SetItemAttrDate(itemtype,

1765: wf_engine.SetItemAttrDate(itemtype,
1766: itemkey,
1767: 'EFFECTIVE_FROM',
1768: l_attr_rec.start_date);
1769: wf_engine.SetItemAttrDate(itemtype,
1770: itemkey,
1771: 'EFFECTIVE_TO',
1772: l_attr_rec.end_date);
1773: OPEN fnd_user_csr;

Line 1785: wf_engine.SetItemAttrText(itemtype,

1781: CLOSE c_get_app_id_csr;
1782:
1783: -- set the values of the approver and the requestor
1784:
1785: wf_engine.SetItemAttrText(itemtype,
1786: itemkey,
1787: G_WF_ITM_APPROVER,
1788: l_user_name);
1789: wf_engine.SetItemAttrText(itemtype,

Line 1789: wf_engine.SetItemAttrText(itemtype,

1785: wf_engine.SetItemAttrText(itemtype,
1786: itemkey,
1787: G_WF_ITM_APPROVER,
1788: l_user_name);
1789: wf_engine.SetItemAttrText(itemtype,
1790: itemkey,
1791: G_WF_ITM_REQUESTER,
1792: l_user_name);
1793: wf_engine.SetItemAttrText(itemtype,

Line 1793: wf_engine.SetItemAttrText(itemtype,

1789: wf_engine.SetItemAttrText(itemtype,
1790: itemkey,
1791: G_WF_ITM_REQUESTER,
1792: l_user_name);
1793: wf_engine.SetItemAttrText(itemtype,
1794: itemkey,
1795: G_WF_ITM_REQUESTER_ID,
1796: fnd_global.user_id);
1797: wf_engine.SetItemAttrText(itemtype,

Line 1797: wf_engine.SetItemAttrText(itemtype,

1793: wf_engine.SetItemAttrText(itemtype,
1794: itemkey,
1795: G_WF_ITM_REQUESTER_ID,
1796: fnd_global.user_id);
1797: wf_engine.SetItemAttrText(itemtype,
1798: itemkey,
1799: G_WF_ITM_TRANSACTION_TYPE_ID,
1800: itemtype);
1801: wf_engine.SetItemAttrText(itemtype,

Line 1801: wf_engine.SetItemAttrText(itemtype,

1797: wf_engine.SetItemAttrText(itemtype,
1798: itemkey,
1799: G_WF_ITM_TRANSACTION_TYPE_ID,
1800: itemtype);
1801: wf_engine.SetItemAttrText(itemtype,
1802: itemkey,
1803: G_WF_ITM_TRANSACTION_ID,
1804: l_item_resdl_version_id);
1805: wf_engine.SetItemAttrText(itemtype,

Line 1805: wf_engine.SetItemAttrText(itemtype,

1801: wf_engine.SetItemAttrText(itemtype,
1802: itemkey,
1803: G_WF_ITM_TRANSACTION_ID,
1804: l_item_resdl_version_id);
1805: wf_engine.SetItemAttrText(itemtype,
1806: itemkey,
1807: G_WF_ITM_APPLICATION_ID,
1808: l_application_id);
1809: EXCEPTION

Line 1842: l_result := wf_engine.GetItemAttrText(itemtype, itemkey, 'RESULT');

1838:
1839: BEGIN
1840:
1841: IF (funcmode = 'RUN') THEN
1842: l_result := wf_engine.GetItemAttrText(itemtype, itemkey, 'RESULT');
1843: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
1844: itemkey => itemkey,
1845: aname => 'APPROVED_YN');
1846: IF (l_result = G_WF_ITM_APPROVED_YN_YES OR lv_approval_status_ame = 'Y') THEN

Line 1843: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,

1839: BEGIN
1840:
1841: IF (funcmode = 'RUN') THEN
1842: l_result := wf_engine.GetItemAttrText(itemtype, itemkey, 'RESULT');
1843: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
1844: itemkey => itemkey,
1845: aname => 'APPROVED_YN');
1846: IF (l_result = G_WF_ITM_APPROVED_YN_YES OR lv_approval_status_ame = 'Y') THEN
1847: l_item_resdl_version_id := wf_engine.GetItemAttrText(itemtype,

Line 1847: l_item_resdl_version_id := wf_engine.GetItemAttrText(itemtype,

1843: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
1844: itemkey => itemkey,
1845: aname => 'APPROVED_YN');
1846: IF (l_result = G_WF_ITM_APPROVED_YN_YES OR lv_approval_status_ame = 'Y') THEN
1847: l_item_resdl_version_id := wf_engine.GetItemAttrText(itemtype,
1848: itemkey,
1849: 'VERSION_ID');
1850:
1851: -- change the version and header status and end date referenced objects

Line 1865: l_item_resdl_version_id := wf_engine.GetItemAttrText(itemtype,

1861: ELSIF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1862: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1863: END IF;
1864: ELSE
1865: l_item_resdl_version_id := wf_engine.GetItemAttrText(itemtype,
1866: itemkey,
1867: 'VERSION_ID');
1868:
1869: -- populate the version attributes

Line 1937: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'PAM_NAME');

1933: CLOSE obj_name_csr;
1934:
1935: -- get the messages and set the messages accordingly depending on the object type
1936:
1937: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'PAM_NAME');
1938: l_request_message := get_message('OKL_FE_REQUEST_APPROVAL_SUB',
1939: l_object_name,
1940: l_name);
1941: l_approved_message := get_message('OKL_FE_REQUEST_APPROVED_SUB',

Line 1950: wf_engine.SetItemAttrText(itemtype,

1946: l_name);
1947: l_reminder_message := get_message('OKL_FE_REMINDER_APPROVAL_SUB',
1948: l_object_name,
1949: l_name);
1950: wf_engine.SetItemAttrText(itemtype,
1951: itemkey,
1952: G_WF_ITM_APP_REQUEST_SUB,
1953: l_request_message);
1954: wf_engine.SetItemAttrText(itemtype,

Line 1954: wf_engine.SetItemAttrText(itemtype,

1950: wf_engine.SetItemAttrText(itemtype,
1951: itemkey,
1952: G_WF_ITM_APP_REQUEST_SUB,
1953: l_request_message);
1954: wf_engine.SetItemAttrText(itemtype,
1955: itemkey,
1956: G_WF_ITM_APP_REMINDER_SUB,
1957: l_reminder_message);
1958: wf_engine.SetItemAttrText(itemtype,

Line 1958: wf_engine.SetItemAttrText(itemtype,

1954: wf_engine.SetItemAttrText(itemtype,
1955: itemkey,
1956: G_WF_ITM_APP_REMINDER_SUB,
1957: l_reminder_message);
1958: wf_engine.SetItemAttrText(itemtype,
1959: itemkey,
1960: G_WF_ITM_APP_REMINDER_HEAD,
1961: l_reminder_message);
1962: wf_engine.SetItemAttrText(itemtype,

Line 1962: wf_engine.SetItemAttrText(itemtype,

1958: wf_engine.SetItemAttrText(itemtype,
1959: itemkey,
1960: G_WF_ITM_APP_REMINDER_HEAD,
1961: l_reminder_message);
1962: wf_engine.SetItemAttrText(itemtype,
1963: itemkey,
1964: G_WF_ITM_APP_APPROVED_SUB,
1965: l_approved_message);
1966: wf_engine.SetItemAttrText(itemtype,

Line 1966: wf_engine.SetItemAttrText(itemtype,

1962: wf_engine.SetItemAttrText(itemtype,
1963: itemkey,
1964: G_WF_ITM_APP_APPROVED_SUB,
1965: l_approved_message);
1966: wf_engine.SetItemAttrText(itemtype,
1967: itemkey,
1968: G_WF_ITM_APP_APPROVED_HEAD,
1969: l_approved_message);
1970: wf_engine.SetItemAttrText(itemtype,

Line 1970: wf_engine.SetItemAttrText(itemtype,

1966: wf_engine.SetItemAttrText(itemtype,
1967: itemkey,
1968: G_WF_ITM_APP_APPROVED_HEAD,
1969: l_approved_message);
1970: wf_engine.SetItemAttrText(itemtype,
1971: itemkey,
1972: G_WF_ITM_APP_REJECTED_SUB,
1973: l_rejected_message);
1974: wf_engine.SetItemAttrText(itemtype,

Line 1974: wf_engine.SetItemAttrText(itemtype,

1970: wf_engine.SetItemAttrText(itemtype,
1971: itemkey,
1972: G_WF_ITM_APP_REJECTED_SUB,
1973: l_rejected_message);
1974: wf_engine.SetItemAttrText(itemtype,
1975: itemkey,
1976: G_WF_ITM_APP_REJECTED_HEAD,
1977: l_rejected_message);
1978: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 1978: wf_engine.SetItemAttrText(itemtype => itemtype,

1974: wf_engine.SetItemAttrText(itemtype,
1975: itemkey,
1976: G_WF_ITM_APP_REJECTED_HEAD,
1977: l_rejected_message);
1978: wf_engine.SetItemAttrText(itemtype => itemtype,
1979: itemkey => itemkey,
1980: aname => G_WF_ITM_MESSAGE_BODY,
1981: avalue => 'plsql:okl_fe_wf.get_pam_msg_doc/' ||
1982: itemkey);

Line 1983: wf_engine.SetItemAttrText(itemtype => itemtype,

1979: itemkey => itemkey,
1980: aname => G_WF_ITM_MESSAGE_BODY,
1981: avalue => 'plsql:okl_fe_wf.get_pam_msg_doc/' ||
1982: itemkey);
1983: wf_engine.SetItemAttrText(itemtype => itemtype,
1984: itemkey => itemkey,
1985: aname => G_WF_ITM_MESSAGE_DESCR,
1986: avalue => get_pam_msg_body(itemtype,
1987: itemkey));

Line 2094: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'SRT_NAME');

2090:
2091: OPEN obj_name_csr;
2092: FETCH obj_name_csr INTO l_object_name ;
2093: CLOSE obj_name_csr;
2094: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'SRT_NAME');
2095: l_request_message := get_message('OKL_FE_REQUEST_APPROVAL_SUB',
2096: l_object_name,
2097: l_name);
2098: l_approved_message := get_message('OKL_FE_REQUEST_APPROVED_SUB',

Line 2107: wf_engine.SetItemAttrText(itemtype,

2103: l_name);
2104: l_reminder_message := get_message('OKL_FE_REMINDER_APPROVAL_SUB',
2105: l_object_name,
2106: l_name);
2107: wf_engine.SetItemAttrText(itemtype,
2108: itemkey,
2109: G_WF_ITM_APP_REQUEST_SUB,
2110: l_request_message);
2111: wf_engine.SetItemAttrText(itemtype,

Line 2111: wf_engine.SetItemAttrText(itemtype,

2107: wf_engine.SetItemAttrText(itemtype,
2108: itemkey,
2109: G_WF_ITM_APP_REQUEST_SUB,
2110: l_request_message);
2111: wf_engine.SetItemAttrText(itemtype,
2112: itemkey,
2113: G_WF_ITM_APP_REMINDER_SUB,
2114: l_reminder_message);
2115: wf_engine.SetItemAttrText(itemtype,

Line 2115: wf_engine.SetItemAttrText(itemtype,

2111: wf_engine.SetItemAttrText(itemtype,
2112: itemkey,
2113: G_WF_ITM_APP_REMINDER_SUB,
2114: l_reminder_message);
2115: wf_engine.SetItemAttrText(itemtype,
2116: itemkey,
2117: G_WF_ITM_APP_REMINDER_HEAD,
2118: l_reminder_message);
2119: wf_engine.SetItemAttrText(itemtype,

Line 2119: wf_engine.SetItemAttrText(itemtype,

2115: wf_engine.SetItemAttrText(itemtype,
2116: itemkey,
2117: G_WF_ITM_APP_REMINDER_HEAD,
2118: l_reminder_message);
2119: wf_engine.SetItemAttrText(itemtype,
2120: itemkey,
2121: G_WF_ITM_APP_APPROVED_SUB,
2122: l_approved_message);
2123: wf_engine.SetItemAttrText(itemtype,

Line 2123: wf_engine.SetItemAttrText(itemtype,

2119: wf_engine.SetItemAttrText(itemtype,
2120: itemkey,
2121: G_WF_ITM_APP_APPROVED_SUB,
2122: l_approved_message);
2123: wf_engine.SetItemAttrText(itemtype,
2124: itemkey,
2125: G_WF_ITM_APP_APPROVED_HEAD,
2126: l_approved_message);
2127: wf_engine.SetItemAttrText(itemtype,

Line 2127: wf_engine.SetItemAttrText(itemtype,

2123: wf_engine.SetItemAttrText(itemtype,
2124: itemkey,
2125: G_WF_ITM_APP_APPROVED_HEAD,
2126: l_approved_message);
2127: wf_engine.SetItemAttrText(itemtype,
2128: itemkey,
2129: G_WF_ITM_APP_REJECTED_SUB,
2130: l_rejected_message);
2131: wf_engine.SetItemAttrText(itemtype,

Line 2131: wf_engine.SetItemAttrText(itemtype,

2127: wf_engine.SetItemAttrText(itemtype,
2128: itemkey,
2129: G_WF_ITM_APP_REJECTED_SUB,
2130: l_rejected_message);
2131: wf_engine.SetItemAttrText(itemtype,
2132: itemkey,
2133: G_WF_ITM_APP_REJECTED_HEAD,
2134: l_rejected_message);
2135: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 2135: wf_engine.SetItemAttrText(itemtype => itemtype,

2131: wf_engine.SetItemAttrText(itemtype,
2132: itemkey,
2133: G_WF_ITM_APP_REJECTED_HEAD,
2134: l_rejected_message);
2135: wf_engine.SetItemAttrText(itemtype => itemtype,
2136: itemkey => itemkey,
2137: aname => G_WF_ITM_MESSAGE_BODY,
2138: avalue => 'plsql:okl_fe_wf.get_srt_msg_doc/' ||
2139: itemkey);

Line 2140: wf_engine.SetItemAttrText(itemtype => itemtype,

2136: itemkey => itemkey,
2137: aname => G_WF_ITM_MESSAGE_BODY,
2138: avalue => 'plsql:okl_fe_wf.get_srt_msg_doc/' ||
2139: itemkey);
2140: wf_engine.SetItemAttrText(itemtype => itemtype,
2141: itemkey => itemkey,
2142: aname => G_WF_ITM_MESSAGE_DESCR,
2143: avalue => get_srt_msg_body(itemtype,
2144: itemkey));

Line 2249: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'EOT_NAME');

2245:
2246: OPEN obj_name_csr;
2247: FETCH obj_name_csr INTO l_object_name ;
2248: CLOSE obj_name_csr;
2249: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'EOT_NAME');
2250: l_request_message := get_message('OKL_FE_REQUEST_APPROVAL_SUB',
2251: l_object_name,
2252: l_name);
2253: l_approved_message := get_message('OKL_FE_REQUEST_APPROVED_SUB',

Line 2262: wf_engine.SetItemAttrText(itemtype,

2258: l_name);
2259: l_reminder_message := get_message('OKL_FE_REMINDER_APPROVAL_SUB',
2260: l_object_name,
2261: l_name);
2262: wf_engine.SetItemAttrText(itemtype,
2263: itemkey,
2264: G_WF_ITM_APP_REQUEST_SUB,
2265: l_request_message);
2266: wf_engine.SetItemAttrText(itemtype,

Line 2266: wf_engine.SetItemAttrText(itemtype,

2262: wf_engine.SetItemAttrText(itemtype,
2263: itemkey,
2264: G_WF_ITM_APP_REQUEST_SUB,
2265: l_request_message);
2266: wf_engine.SetItemAttrText(itemtype,
2267: itemkey,
2268: G_WF_ITM_APP_REMINDER_SUB,
2269: l_reminder_message);
2270: wf_engine.SetItemAttrText(itemtype,

Line 2270: wf_engine.SetItemAttrText(itemtype,

2266: wf_engine.SetItemAttrText(itemtype,
2267: itemkey,
2268: G_WF_ITM_APP_REMINDER_SUB,
2269: l_reminder_message);
2270: wf_engine.SetItemAttrText(itemtype,
2271: itemkey,
2272: G_WF_ITM_APP_REMINDER_HEAD,
2273: l_reminder_message);
2274: wf_engine.SetItemAttrText(itemtype,

Line 2274: wf_engine.SetItemAttrText(itemtype,

2270: wf_engine.SetItemAttrText(itemtype,
2271: itemkey,
2272: G_WF_ITM_APP_REMINDER_HEAD,
2273: l_reminder_message);
2274: wf_engine.SetItemAttrText(itemtype,
2275: itemkey,
2276: G_WF_ITM_APP_APPROVED_SUB,
2277: l_approved_message);
2278: wf_engine.SetItemAttrText(itemtype,

Line 2278: wf_engine.SetItemAttrText(itemtype,

2274: wf_engine.SetItemAttrText(itemtype,
2275: itemkey,
2276: G_WF_ITM_APP_APPROVED_SUB,
2277: l_approved_message);
2278: wf_engine.SetItemAttrText(itemtype,
2279: itemkey,
2280: G_WF_ITM_APP_APPROVED_HEAD,
2281: l_approved_message);
2282: wf_engine.SetItemAttrText(itemtype,

Line 2282: wf_engine.SetItemAttrText(itemtype,

2278: wf_engine.SetItemAttrText(itemtype,
2279: itemkey,
2280: G_WF_ITM_APP_APPROVED_HEAD,
2281: l_approved_message);
2282: wf_engine.SetItemAttrText(itemtype,
2283: itemkey,
2284: G_WF_ITM_APP_REJECTED_SUB,
2285: l_rejected_message);
2286: wf_engine.SetItemAttrText(itemtype,

Line 2286: wf_engine.SetItemAttrText(itemtype,

2282: wf_engine.SetItemAttrText(itemtype,
2283: itemkey,
2284: G_WF_ITM_APP_REJECTED_SUB,
2285: l_rejected_message);
2286: wf_engine.SetItemAttrText(itemtype,
2287: itemkey,
2288: G_WF_ITM_APP_REJECTED_HEAD,
2289: l_rejected_message);
2290: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 2290: wf_engine.SetItemAttrText(itemtype => itemtype,

2286: wf_engine.SetItemAttrText(itemtype,
2287: itemkey,
2288: G_WF_ITM_APP_REJECTED_HEAD,
2289: l_rejected_message);
2290: wf_engine.SetItemAttrText(itemtype => itemtype,
2291: itemkey => itemkey,
2292: aname => G_WF_ITM_MESSAGE_BODY,
2293: avalue => 'plsql:okl_fe_wf.get_eot_msg_doc/' ||
2294: itemkey);

Line 2295: wf_engine.SetItemAttrText(itemtype => itemtype,

2291: itemkey => itemkey,
2292: aname => G_WF_ITM_MESSAGE_BODY,
2293: avalue => 'plsql:okl_fe_wf.get_eot_msg_doc/' ||
2294: itemkey);
2295: wf_engine.SetItemAttrText(itemtype => itemtype,
2296: itemkey => itemkey,
2297: aname => G_WF_ITM_MESSAGE_DESCR,
2298: avalue => get_eot_msg_body(itemtype,
2299: itemkey));

Line 2404: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'IRS_NAME');

2400:
2401: OPEN obj_name_csr;
2402: FETCH obj_name_csr INTO l_object_name ;
2403: CLOSE obj_name_csr;
2404: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'IRS_NAME');
2405: l_request_message := get_message('OKL_FE_REQUEST_APPROVAL_SUB',
2406: l_object_name,
2407: l_name);
2408: l_approved_message := get_message('OKL_FE_REQUEST_APPROVED_SUB',

Line 2417: wf_engine.SetItemAttrText(itemtype,

2413: l_name);
2414: l_reminder_message := get_message('OKL_FE_REMINDER_APPROVAL_SUB',
2415: l_object_name,
2416: l_name);
2417: wf_engine.SetItemAttrText(itemtype,
2418: itemkey,
2419: G_WF_ITM_APP_REQUEST_SUB,
2420: l_request_message);
2421: wf_engine.SetItemAttrText(itemtype,

Line 2421: wf_engine.SetItemAttrText(itemtype,

2417: wf_engine.SetItemAttrText(itemtype,
2418: itemkey,
2419: G_WF_ITM_APP_REQUEST_SUB,
2420: l_request_message);
2421: wf_engine.SetItemAttrText(itemtype,
2422: itemkey,
2423: G_WF_ITM_APP_REMINDER_SUB,
2424: l_reminder_message);
2425: wf_engine.SetItemAttrText(itemtype,

Line 2425: wf_engine.SetItemAttrText(itemtype,

2421: wf_engine.SetItemAttrText(itemtype,
2422: itemkey,
2423: G_WF_ITM_APP_REMINDER_SUB,
2424: l_reminder_message);
2425: wf_engine.SetItemAttrText(itemtype,
2426: itemkey,
2427: G_WF_ITM_APP_REMINDER_HEAD,
2428: l_reminder_message);
2429: wf_engine.SetItemAttrText(itemtype,

Line 2429: wf_engine.SetItemAttrText(itemtype,

2425: wf_engine.SetItemAttrText(itemtype,
2426: itemkey,
2427: G_WF_ITM_APP_REMINDER_HEAD,
2428: l_reminder_message);
2429: wf_engine.SetItemAttrText(itemtype,
2430: itemkey,
2431: G_WF_ITM_APP_APPROVED_SUB,
2432: l_approved_message);
2433: wf_engine.SetItemAttrText(itemtype,

Line 2433: wf_engine.SetItemAttrText(itemtype,

2429: wf_engine.SetItemAttrText(itemtype,
2430: itemkey,
2431: G_WF_ITM_APP_APPROVED_SUB,
2432: l_approved_message);
2433: wf_engine.SetItemAttrText(itemtype,
2434: itemkey,
2435: G_WF_ITM_APP_APPROVED_HEAD,
2436: l_approved_message);
2437: wf_engine.SetItemAttrText(itemtype,

Line 2437: wf_engine.SetItemAttrText(itemtype,

2433: wf_engine.SetItemAttrText(itemtype,
2434: itemkey,
2435: G_WF_ITM_APP_APPROVED_HEAD,
2436: l_approved_message);
2437: wf_engine.SetItemAttrText(itemtype,
2438: itemkey,
2439: G_WF_ITM_APP_REJECTED_SUB,
2440: l_rejected_message);
2441: wf_engine.SetItemAttrText(itemtype,

Line 2441: wf_engine.SetItemAttrText(itemtype,

2437: wf_engine.SetItemAttrText(itemtype,
2438: itemkey,
2439: G_WF_ITM_APP_REJECTED_SUB,
2440: l_rejected_message);
2441: wf_engine.SetItemAttrText(itemtype,
2442: itemkey,
2443: G_WF_ITM_APP_REJECTED_HEAD,
2444: l_rejected_message);
2445: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 2445: wf_engine.SetItemAttrText(itemtype => itemtype,

2441: wf_engine.SetItemAttrText(itemtype,
2442: itemkey,
2443: G_WF_ITM_APP_REJECTED_HEAD,
2444: l_rejected_message);
2445: wf_engine.SetItemAttrText(itemtype => itemtype,
2446: itemkey => itemkey,
2447: aname => G_WF_ITM_MESSAGE_BODY,
2448: avalue => 'plsql:okl_fe_wf.get_irs_msg_doc/' ||
2449: itemkey);

Line 2450: wf_engine.SetItemAttrText(itemtype => itemtype,

2446: itemkey => itemkey,
2447: aname => G_WF_ITM_MESSAGE_BODY,
2448: avalue => 'plsql:okl_fe_wf.get_irs_msg_doc/' ||
2449: itemkey);
2450: wf_engine.SetItemAttrText(itemtype => itemtype,
2451: itemkey => itemkey,
2452: aname => G_WF_ITM_MESSAGE_DESCR,
2453: avalue => get_irs_msg_body(itemtype,
2454: itemkey));

Line 2559: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'LRS_NAME');

2555:
2556: OPEN obj_name_csr;
2557: FETCH obj_name_csr INTO l_object_name ;
2558: CLOSE obj_name_csr;
2559: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'LRS_NAME');
2560: l_request_message := get_message('OKL_FE_REQUEST_APPROVAL_SUB',
2561: l_object_name,
2562: l_name);
2563: l_approved_message := get_message('OKL_FE_REQUEST_APPROVED_SUB',

Line 2572: wf_engine.SetItemAttrText(itemtype,

2568: l_name);
2569: l_reminder_message := get_message('OKL_FE_REMINDER_APPROVAL_SUB',
2570: l_object_name,
2571: l_name);
2572: wf_engine.SetItemAttrText(itemtype,
2573: itemkey,
2574: G_WF_ITM_APP_REQUEST_SUB,
2575: l_request_message);
2576: wf_engine.SetItemAttrText(itemtype,

Line 2576: wf_engine.SetItemAttrText(itemtype,

2572: wf_engine.SetItemAttrText(itemtype,
2573: itemkey,
2574: G_WF_ITM_APP_REQUEST_SUB,
2575: l_request_message);
2576: wf_engine.SetItemAttrText(itemtype,
2577: itemkey,
2578: G_WF_ITM_APP_REMINDER_SUB,
2579: l_reminder_message);
2580: wf_engine.SetItemAttrText(itemtype,

Line 2580: wf_engine.SetItemAttrText(itemtype,

2576: wf_engine.SetItemAttrText(itemtype,
2577: itemkey,
2578: G_WF_ITM_APP_REMINDER_SUB,
2579: l_reminder_message);
2580: wf_engine.SetItemAttrText(itemtype,
2581: itemkey,
2582: G_WF_ITM_APP_REMINDER_HEAD,
2583: l_reminder_message);
2584: wf_engine.SetItemAttrText(itemtype,

Line 2584: wf_engine.SetItemAttrText(itemtype,

2580: wf_engine.SetItemAttrText(itemtype,
2581: itemkey,
2582: G_WF_ITM_APP_REMINDER_HEAD,
2583: l_reminder_message);
2584: wf_engine.SetItemAttrText(itemtype,
2585: itemkey,
2586: G_WF_ITM_APP_APPROVED_SUB,
2587: l_approved_message);
2588: wf_engine.SetItemAttrText(itemtype,

Line 2588: wf_engine.SetItemAttrText(itemtype,

2584: wf_engine.SetItemAttrText(itemtype,
2585: itemkey,
2586: G_WF_ITM_APP_APPROVED_SUB,
2587: l_approved_message);
2588: wf_engine.SetItemAttrText(itemtype,
2589: itemkey,
2590: G_WF_ITM_APP_APPROVED_HEAD,
2591: l_approved_message);
2592: wf_engine.SetItemAttrText(itemtype,

Line 2592: wf_engine.SetItemAttrText(itemtype,

2588: wf_engine.SetItemAttrText(itemtype,
2589: itemkey,
2590: G_WF_ITM_APP_APPROVED_HEAD,
2591: l_approved_message);
2592: wf_engine.SetItemAttrText(itemtype,
2593: itemkey,
2594: G_WF_ITM_APP_REJECTED_SUB,
2595: l_rejected_message);
2596: wf_engine.SetItemAttrText(itemtype,

Line 2596: wf_engine.SetItemAttrText(itemtype,

2592: wf_engine.SetItemAttrText(itemtype,
2593: itemkey,
2594: G_WF_ITM_APP_REJECTED_SUB,
2595: l_rejected_message);
2596: wf_engine.SetItemAttrText(itemtype,
2597: itemkey,
2598: G_WF_ITM_APP_REJECTED_HEAD,
2599: l_rejected_message);
2600: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 2600: wf_engine.SetItemAttrText(itemtype => itemtype,

2596: wf_engine.SetItemAttrText(itemtype,
2597: itemkey,
2598: G_WF_ITM_APP_REJECTED_HEAD,
2599: l_rejected_message);
2600: wf_engine.SetItemAttrText(itemtype => itemtype,
2601: itemkey => itemkey,
2602: aname => G_WF_ITM_MESSAGE_BODY,
2603: avalue => 'plsql:okl_fe_wf.get_lrs_msg_doc/' ||
2604: itemkey);

Line 2605: wf_engine.SetItemAttrText(itemtype => itemtype,

2601: itemkey => itemkey,
2602: aname => G_WF_ITM_MESSAGE_BODY,
2603: avalue => 'plsql:okl_fe_wf.get_lrs_msg_doc/' ||
2604: itemkey);
2605: wf_engine.SetItemAttrText(itemtype => itemtype,
2606: itemkey => itemkey,
2607: aname => G_WF_ITM_MESSAGE_DESCR,
2608: avalue => get_lrs_msg_body(itemtype,
2609: itemkey));