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 569: l_quote_id := wf_engine.GetItemAttrText(itemtype => itemtype,

565: BEGIN
566:
567: IF (funcmode = 'RUN') THEN
568:
569: l_quote_id := wf_engine.GetItemAttrText(itemtype => itemtype,
570: itemkey => itemkey,
571: aname => 'QUOTE_ID');
572:
573: OPEN c_fetch_quote_number(p_quote_id => l_quote_id);

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

573: OPEN c_fetch_quote_number(p_quote_id => l_quote_id);
574: FETCH c_fetch_quote_number INTO l_quote_number;
575: CLOSE c_fetch_quote_number;
576:
577: wf_engine.SetItemAttrText (itemtype => itemtype,
578: itemkey => itemkey,
579: aname => 'QUOTE_ID',
580: avalue => l_quote_number);
581:

Line 674: l_user_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

670:
671: IF (funcmode = 'RUN') THEN
672:
673: -- Code added as part of Bug 15933691 - START
674: l_user_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
675: itemkey => itemkey,
676: aname => 'USER_ID');
677:
678: l_resp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 678: l_resp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

674: l_user_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
675: itemkey => itemkey,
676: aname => 'USER_ID');
677:
678: l_resp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
679: itemkey => itemkey,
680: aname => 'RESPONSIBILITY_ID');
681:
682: OPEN c_get_app_id_csr;

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

808: IF (funcmode = 'RUN') THEN
809:
810: -- get the messages and set the messages accordingly depending on the object type
811:
812: l_quote_id := wf_engine.GetItemAttrText(itemtype => itemtype,
813: itemkey => itemkey,
814: aname => 'QUOTE_ID');
815:
816: -- Start - Added by Venkatho as part of Bug : 15933691

Line 817: l_user_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

813: itemkey => itemkey,
814: aname => 'QUOTE_ID');
815:
816: -- Start - Added by Venkatho as part of Bug : 15933691
817: l_user_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
818: itemkey => itemkey,
819: aname => 'USER_ID');
820: -- End - Added by Venkatho as part of Bug : 15933691
821:

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

823: FETCH c_fetch_quote_number INTO l_quote_number, l_effective_from, l_effective_to,
824: l_parent_code, l_parent_id;
825: CLOSE c_fetch_quote_number;
826:
827: wf_engine.SetItemAttrText (itemtype => itemtype,
828: itemkey => itemkey,
829: aname => 'QUOTE_NUM',
830: avalue => l_quote_number);
831:

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

828: itemkey => itemkey,
829: aname => 'QUOTE_NUM',
830: avalue => l_quote_number);
831:
832: wf_engine.SetItemAttrText (itemtype => itemtype,
833: itemkey => itemkey,
834: aname => 'EFFECTIVE_FROM',
835: avalue => l_effective_from);
836:

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

833: itemkey => itemkey,
834: aname => 'EFFECTIVE_FROM',
835: avalue => l_effective_from);
836:
837: wf_engine.SetItemAttrText (itemtype => itemtype,
838: itemkey => itemkey,
839: aname => 'EFFECTIVE_TO',
840: avalue => l_effective_to);
841:

Line 872: wf_engine.SetItemAttrText(itemtype,

868: l_quote_number);
869: l_reminder_message := get_message('OKL_FE_REMINDER_APPROVAL_SUB',
870: l_object_name,
871: l_quote_number);
872: wf_engine.SetItemAttrText(itemtype,
873: itemkey,
874: G_WF_ITM_APP_REQUEST_SUB,
875: l_request_message);
876: wf_engine.SetItemAttrText(itemtype,

Line 876: wf_engine.SetItemAttrText(itemtype,

872: wf_engine.SetItemAttrText(itemtype,
873: itemkey,
874: G_WF_ITM_APP_REQUEST_SUB,
875: l_request_message);
876: wf_engine.SetItemAttrText(itemtype,
877: itemkey,
878: G_WF_ITM_APP_REMINDER_SUB,
879: l_reminder_message);
880: wf_engine.SetItemAttrText(itemtype,

Line 880: wf_engine.SetItemAttrText(itemtype,

876: wf_engine.SetItemAttrText(itemtype,
877: itemkey,
878: G_WF_ITM_APP_REMINDER_SUB,
879: l_reminder_message);
880: wf_engine.SetItemAttrText(itemtype,
881: itemkey,
882: G_WF_ITM_APP_REMINDER_HEAD,
883: l_reminder_message);
884: wf_engine.SetItemAttrText(itemtype,

Line 884: wf_engine.SetItemAttrText(itemtype,

880: wf_engine.SetItemAttrText(itemtype,
881: itemkey,
882: G_WF_ITM_APP_REMINDER_HEAD,
883: l_reminder_message);
884: wf_engine.SetItemAttrText(itemtype,
885: itemkey,
886: G_WF_ITM_APP_APPROVED_SUB,
887: l_approved_message);
888: wf_engine.SetItemAttrText(itemtype,

Line 888: wf_engine.SetItemAttrText(itemtype,

884: wf_engine.SetItemAttrText(itemtype,
885: itemkey,
886: G_WF_ITM_APP_APPROVED_SUB,
887: l_approved_message);
888: wf_engine.SetItemAttrText(itemtype,
889: itemkey,
890: G_WF_ITM_APP_APPROVED_HEAD,
891: l_approved_message);
892: wf_engine.SetItemAttrText(itemtype,

Line 892: wf_engine.SetItemAttrText(itemtype,

888: wf_engine.SetItemAttrText(itemtype,
889: itemkey,
890: G_WF_ITM_APP_APPROVED_HEAD,
891: l_approved_message);
892: wf_engine.SetItemAttrText(itemtype,
893: itemkey,
894: G_WF_ITM_APP_REJECTED_SUB,
895: l_rejected_message);
896: wf_engine.SetItemAttrText(itemtype,

Line 896: wf_engine.SetItemAttrText(itemtype,

892: wf_engine.SetItemAttrText(itemtype,
893: itemkey,
894: G_WF_ITM_APP_REJECTED_SUB,
895: l_rejected_message);
896: wf_engine.SetItemAttrText(itemtype,
897: itemkey,
898: G_WF_ITM_APP_REJECTED_HEAD,
899: l_rejected_message);
900: wf_engine.SetItemAttrText(itemtype => itemtype,

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

896: wf_engine.SetItemAttrText(itemtype,
897: itemkey,
898: G_WF_ITM_APP_REJECTED_HEAD,
899: l_rejected_message);
900: wf_engine.SetItemAttrText(itemtype => itemtype,
901: itemkey => itemkey,
902: aname => G_WF_ITM_MESSAGE_BODY,
903: avalue => 'plsql:okl_lease_quote_workflow_pvt.get_quote_msg_doc/' ||
904: itemkey);

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

901: itemkey => itemkey,
902: aname => G_WF_ITM_MESSAGE_BODY,
903: avalue => 'plsql:okl_lease_quote_workflow_pvt.get_quote_msg_doc/' ||
904: itemkey);
905: wf_engine.SetItemAttrText(itemtype => itemtype,
906: itemkey => itemkey,
907: aname => G_WF_ITM_MESSAGE_DESCR,
908: avalue => get_quote_msg_body(itemtype, itemkey));
909:

Line 925: l_approver_role:= wf_engine.getItemAttrText(itemtype,

921:
922: -- set the values of the approver and the requestor
923:
924: -- Bug16175322 changes start here
925: l_approver_role:= wf_engine.getItemAttrText(itemtype,
926: itemkey,
927: 'APPROVER');
928: IF l_approver_role is null THEN
929: wf_engine.SetItemAttrText(itemtype,

Line 929: wf_engine.SetItemAttrText(itemtype,

925: l_approver_role:= wf_engine.getItemAttrText(itemtype,
926: itemkey,
927: 'APPROVER');
928: IF l_approver_role is null THEN
929: wf_engine.SetItemAttrText(itemtype,
930: itemkey,
931: G_WF_ITM_APPROVER,
932: 'SYSADMIN');
933: END IF;

Line 938: /* wf_engine.SetItemAttrText(itemtype,

934:
935: -- Bug16175322 changes end here
936:
937: -- Start APPROVER Attribute code is commented by venkatho as part of Bug: 15933691
938: /* wf_engine.SetItemAttrText(itemtype,
939: itemkey,
940: G_WF_ITM_APPROVER,
941: l_user_name); */
942: -- End APPROVER Attribute code is commented by venkatho as part of Bug: 15933691

Line 944: wf_engine.SetItemAttrText(itemtype,

940: G_WF_ITM_APPROVER,
941: l_user_name); */
942: -- End APPROVER Attribute code is commented by venkatho as part of Bug: 15933691
943:
944: wf_engine.SetItemAttrText(itemtype,
945: itemkey,
946: G_WF_ITM_REQUESTER,
947: l_user_name);
948: wf_engine.SetItemAttrText(itemtype,

Line 948: wf_engine.SetItemAttrText(itemtype,

944: wf_engine.SetItemAttrText(itemtype,
945: itemkey,
946: G_WF_ITM_REQUESTER,
947: l_user_name);
948: wf_engine.SetItemAttrText(itemtype,
949: itemkey,
950: G_WF_ITM_REQUESTER_ID,
951: -- fnd_global.user_id); -- Commented by venkatho as part of Bug: 15933691
952: l_user_id); -- Added by venkatho as part of Bug: 15933691

Line 953: wf_engine.SetItemAttrText(itemtype,

949: itemkey,
950: G_WF_ITM_REQUESTER_ID,
951: -- fnd_global.user_id); -- Commented by venkatho as part of Bug: 15933691
952: l_user_id); -- Added by venkatho as part of Bug: 15933691
953: wf_engine.SetItemAttrText(itemtype,
954: itemkey,
955: G_WF_ITM_TRANSACTION_TYPE_ID,
956: itemtype);
957: wf_engine.SetItemAttrText(itemtype,

Line 957: wf_engine.SetItemAttrText(itemtype,

953: wf_engine.SetItemAttrText(itemtype,
954: itemkey,
955: G_WF_ITM_TRANSACTION_TYPE_ID,
956: itemtype);
957: wf_engine.SetItemAttrText(itemtype,
958: itemkey,
959: G_WF_ITM_TRANSACTION_ID,
960: l_quote_id);
961: wf_engine.SetItemAttrText(itemtype,

Line 961: wf_engine.SetItemAttrText(itemtype,

957: wf_engine.SetItemAttrText(itemtype,
958: itemkey,
959: G_WF_ITM_TRANSACTION_ID,
960: l_quote_id);
961: wf_engine.SetItemAttrText(itemtype,
962: itemkey,
963: G_WF_ITM_APPLICATION_ID,
964: l_application_id);
965:

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

1032: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
1033: BEGIN
1034:
1035: IF (funcmode = 'RUN') THEN
1036: l_result := wf_engine.GetItemAttrText(itemtype, itemkey, 'RESULT');
1037: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
1038: itemkey => itemkey,
1039: aname => 'APPROVED_YN');
1040:

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

1033: BEGIN
1034:
1035: IF (funcmode = 'RUN') THEN
1036: l_result := wf_engine.GetItemAttrText(itemtype, itemkey, 'RESULT');
1037: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
1038: itemkey => itemkey,
1039: aname => 'APPROVED_YN');
1040:
1041: l_quote_id := wf_engine.GetItemAttrText(itemtype => itemtype,

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

1037: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
1038: itemkey => itemkey,
1039: aname => 'APPROVED_YN');
1040:
1041: l_quote_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1042: itemkey => itemkey,
1043: aname => 'QUOTE_ID');
1044:
1045: OPEN get_parent_object(l_quote_id);