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_LEASE_QUOTE_WORKFLOW_PVT dependencies on WF_ENGINE

Line 142: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'QUOTE_NUM');

138: WHERE id= lease_app_id;
139:
140: BEGIN
141: -- set the attributes
142: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'QUOTE_NUM');
143: l_effective_from := wf_engine.GetItemAttrDate(itemtype,
144: itemkey,
145: 'EFFECTIVE_FROM');
146: l_effective_to := wf_engine.GetItemAttrDate(itemtype,

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

139:
140: BEGIN
141: -- set the attributes
142: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'QUOTE_NUM');
143: l_effective_from := wf_engine.GetItemAttrDate(itemtype,
144: itemkey,
145: 'EFFECTIVE_FROM');
146: l_effective_to := wf_engine.GetItemAttrDate(itemtype,
147: itemkey,

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

142: l_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'QUOTE_NUM');
143: l_effective_from := wf_engine.GetItemAttrDate(itemtype,
144: itemkey,
145: 'EFFECTIVE_FROM');
146: l_effective_to := wf_engine.GetItemAttrDate(itemtype,
147: itemkey,
148: 'EFFECTIVE_TO');
149:
150: l_quote_id:=wf_engine.GetItemAttrText(itemtype, itemkey, 'QUOTE_ID');

Line 150: l_quote_id:=wf_engine.GetItemAttrText(itemtype, itemkey, 'QUOTE_ID');

146: l_effective_to := wf_engine.GetItemAttrDate(itemtype,
147: itemkey,
148: 'EFFECTIVE_TO');
149:
150: l_quote_id:=wf_engine.GetItemAttrText(itemtype, itemkey, 'QUOTE_ID');
151:
152:
153: OPEN get_parent_object(l_quote_id);
154: FETCH get_parent_object INTO l_parent_object_code, l_parent_id;

Line 369: l_quote_id := wf_engine.GetItemAttrText(itemtype => itemtype,

365: BEGIN
366:
367: IF (funcmode = 'RUN') THEN
368:
369: l_quote_id := wf_engine.GetItemAttrText(itemtype => itemtype,
370: itemkey => itemkey,
371: aname => 'QUOTE_ID');
372:
373: OPEN c_fetch_quote_number(p_quote_id => l_quote_id);

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

373: OPEN c_fetch_quote_number(p_quote_id => l_quote_id);
374: FETCH c_fetch_quote_number INTO l_quote_number;
375: CLOSE c_fetch_quote_number;
376:
377: wf_engine.SetItemAttrText (itemtype => itemtype,
378: itemkey => itemkey,
379: aname => 'QUOTE_ID',
380: avalue => l_quote_number);
381:

Line 563: l_quote_id := wf_engine.GetItemAttrText(itemtype => itemtype,

559: BEGIN
560:
561: IF (funcmode = 'RUN') THEN
562:
563: l_quote_id := wf_engine.GetItemAttrText(itemtype => itemtype,
564: itemkey => itemkey,
565: aname => 'QUOTE_ID');
566:
567: OPEN c_fetch_quote_number(p_quote_id => l_quote_id);

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

567: OPEN c_fetch_quote_number(p_quote_id => l_quote_id);
568: FETCH c_fetch_quote_number INTO l_quote_number;
569: CLOSE c_fetch_quote_number;
570:
571: wf_engine.SetItemAttrText (itemtype => itemtype,
572: itemkey => itemkey,
573: aname => 'QUOTE_ID',
574: avalue => l_quote_number);
575:

Line 765: l_quote_id := wf_engine.GetItemAttrText(itemtype => itemtype,

761: IF (funcmode = 'RUN') THEN
762:
763: -- get the messages and set the messages accordingly depending on the object type
764:
765: l_quote_id := wf_engine.GetItemAttrText(itemtype => itemtype,
766: itemkey => itemkey,
767: aname => 'QUOTE_ID');
768:
769: OPEN c_fetch_quote_number(p_quote_id => l_quote_id);

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

770: FETCH c_fetch_quote_number INTO l_quote_number, l_effective_from, l_effective_to,
771: l_parent_code, l_parent_id;
772: CLOSE c_fetch_quote_number;
773:
774: wf_engine.SetItemAttrText (itemtype => itemtype,
775: itemkey => itemkey,
776: aname => 'QUOTE_NUM',
777: avalue => l_quote_number);
778:

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

775: itemkey => itemkey,
776: aname => 'QUOTE_NUM',
777: avalue => l_quote_number);
778:
779: wf_engine.SetItemAttrText (itemtype => itemtype,
780: itemkey => itemkey,
781: aname => 'EFFECTIVE_FROM',
782: avalue => l_effective_from);
783:

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

780: itemkey => itemkey,
781: aname => 'EFFECTIVE_FROM',
782: avalue => l_effective_from);
783:
784: wf_engine.SetItemAttrText (itemtype => itemtype,
785: itemkey => itemkey,
786: aname => 'EFFECTIVE_TO',
787: avalue => l_effective_to);
788:

Line 819: wf_engine.SetItemAttrText(itemtype,

815: l_quote_number);
816: l_reminder_message := get_message('OKL_FE_REMINDER_APPROVAL_SUB',
817: l_object_name,
818: l_quote_number);
819: wf_engine.SetItemAttrText(itemtype,
820: itemkey,
821: G_WF_ITM_APP_REQUEST_SUB,
822: l_request_message);
823: wf_engine.SetItemAttrText(itemtype,

Line 823: wf_engine.SetItemAttrText(itemtype,

819: wf_engine.SetItemAttrText(itemtype,
820: itemkey,
821: G_WF_ITM_APP_REQUEST_SUB,
822: l_request_message);
823: wf_engine.SetItemAttrText(itemtype,
824: itemkey,
825: G_WF_ITM_APP_REMINDER_SUB,
826: l_reminder_message);
827: wf_engine.SetItemAttrText(itemtype,

Line 827: wf_engine.SetItemAttrText(itemtype,

823: wf_engine.SetItemAttrText(itemtype,
824: itemkey,
825: G_WF_ITM_APP_REMINDER_SUB,
826: l_reminder_message);
827: wf_engine.SetItemAttrText(itemtype,
828: itemkey,
829: G_WF_ITM_APP_REMINDER_HEAD,
830: l_reminder_message);
831: wf_engine.SetItemAttrText(itemtype,

Line 831: wf_engine.SetItemAttrText(itemtype,

827: wf_engine.SetItemAttrText(itemtype,
828: itemkey,
829: G_WF_ITM_APP_REMINDER_HEAD,
830: l_reminder_message);
831: wf_engine.SetItemAttrText(itemtype,
832: itemkey,
833: G_WF_ITM_APP_APPROVED_SUB,
834: l_approved_message);
835: wf_engine.SetItemAttrText(itemtype,

Line 835: wf_engine.SetItemAttrText(itemtype,

831: wf_engine.SetItemAttrText(itemtype,
832: itemkey,
833: G_WF_ITM_APP_APPROVED_SUB,
834: l_approved_message);
835: wf_engine.SetItemAttrText(itemtype,
836: itemkey,
837: G_WF_ITM_APP_APPROVED_HEAD,
838: l_approved_message);
839: wf_engine.SetItemAttrText(itemtype,

Line 839: wf_engine.SetItemAttrText(itemtype,

835: wf_engine.SetItemAttrText(itemtype,
836: itemkey,
837: G_WF_ITM_APP_APPROVED_HEAD,
838: l_approved_message);
839: wf_engine.SetItemAttrText(itemtype,
840: itemkey,
841: G_WF_ITM_APP_REJECTED_SUB,
842: l_rejected_message);
843: wf_engine.SetItemAttrText(itemtype,

Line 843: wf_engine.SetItemAttrText(itemtype,

839: wf_engine.SetItemAttrText(itemtype,
840: itemkey,
841: G_WF_ITM_APP_REJECTED_SUB,
842: l_rejected_message);
843: wf_engine.SetItemAttrText(itemtype,
844: itemkey,
845: G_WF_ITM_APP_REJECTED_HEAD,
846: l_rejected_message);
847: wf_engine.SetItemAttrText(itemtype => itemtype,

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

843: wf_engine.SetItemAttrText(itemtype,
844: itemkey,
845: G_WF_ITM_APP_REJECTED_HEAD,
846: l_rejected_message);
847: wf_engine.SetItemAttrText(itemtype => itemtype,
848: itemkey => itemkey,
849: aname => G_WF_ITM_MESSAGE_BODY,
850: avalue => 'plsql:okl_lease_quote_workflow_pvt.get_quote_msg_doc/' ||
851: itemkey);

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

848: itemkey => itemkey,
849: aname => G_WF_ITM_MESSAGE_BODY,
850: avalue => 'plsql:okl_lease_quote_workflow_pvt.get_quote_msg_doc/' ||
851: itemkey);
852: wf_engine.SetItemAttrText(itemtype => itemtype,
853: itemkey => itemkey,
854: aname => G_WF_ITM_MESSAGE_DESCR,
855: avalue => get_quote_msg_body(itemtype, itemkey));
856:

Line 869: wf_engine.SetItemAttrText(itemtype,

865: CLOSE c_get_app_id_csr;
866:
867: -- set the values of the approver and the requestor
868:
869: wf_engine.SetItemAttrText(itemtype,
870: itemkey,
871: G_WF_ITM_APPROVER,
872: l_user_name);
873: wf_engine.SetItemAttrText(itemtype,

Line 873: wf_engine.SetItemAttrText(itemtype,

869: wf_engine.SetItemAttrText(itemtype,
870: itemkey,
871: G_WF_ITM_APPROVER,
872: l_user_name);
873: wf_engine.SetItemAttrText(itemtype,
874: itemkey,
875: G_WF_ITM_REQUESTER,
876: l_user_name);
877: wf_engine.SetItemAttrText(itemtype,

Line 877: wf_engine.SetItemAttrText(itemtype,

873: wf_engine.SetItemAttrText(itemtype,
874: itemkey,
875: G_WF_ITM_REQUESTER,
876: l_user_name);
877: wf_engine.SetItemAttrText(itemtype,
878: itemkey,
879: G_WF_ITM_REQUESTER_ID,
880: fnd_global.user_id);
881: wf_engine.SetItemAttrText(itemtype,

Line 881: wf_engine.SetItemAttrText(itemtype,

877: wf_engine.SetItemAttrText(itemtype,
878: itemkey,
879: G_WF_ITM_REQUESTER_ID,
880: fnd_global.user_id);
881: wf_engine.SetItemAttrText(itemtype,
882: itemkey,
883: G_WF_ITM_TRANSACTION_TYPE_ID,
884: itemtype);
885: wf_engine.SetItemAttrText(itemtype,

Line 885: wf_engine.SetItemAttrText(itemtype,

881: wf_engine.SetItemAttrText(itemtype,
882: itemkey,
883: G_WF_ITM_TRANSACTION_TYPE_ID,
884: itemtype);
885: wf_engine.SetItemAttrText(itemtype,
886: itemkey,
887: G_WF_ITM_TRANSACTION_ID,
888: l_quote_id);
889: wf_engine.SetItemAttrText(itemtype,

Line 889: wf_engine.SetItemAttrText(itemtype,

885: wf_engine.SetItemAttrText(itemtype,
886: itemkey,
887: G_WF_ITM_TRANSACTION_ID,
888: l_quote_id);
889: wf_engine.SetItemAttrText(itemtype,
890: itemkey,
891: G_WF_ITM_APPLICATION_ID,
892: l_application_id);
893:

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

960: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
961: BEGIN
962:
963: IF (funcmode = 'RUN') THEN
964: l_result := wf_engine.GetItemAttrText(itemtype, itemkey, 'RESULT');
965: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
966: itemkey => itemkey,
967: aname => 'APPROVED_YN');
968:

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

961: BEGIN
962:
963: IF (funcmode = 'RUN') THEN
964: l_result := wf_engine.GetItemAttrText(itemtype, itemkey, 'RESULT');
965: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
966: itemkey => itemkey,
967: aname => 'APPROVED_YN');
968:
969: l_quote_id := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 969: l_quote_id := wf_engine.GetItemAttrText(itemtype => itemtype,

965: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
966: itemkey => itemkey,
967: aname => 'APPROVED_YN');
968:
969: l_quote_id := wf_engine.GetItemAttrText(itemtype => itemtype,
970: itemkey => itemkey,
971: aname => 'QUOTE_ID');
972:
973: OPEN get_parent_object(l_quote_id);