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

Line 130: l_contract_id := wf_engine.GetItemAttrNumber(

126: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
127: 'Function mode is: ' || funcmode);
128: END IF;
129: IF (funcmode = 'RUN') THEN
130: l_contract_id := wf_engine.GetItemAttrNumber(
131: itemtype => itemtype,
132: itemkey => itemkey,
133: aname => 'CONTRACT_ID');
134:

Line 144: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_TYPE ' || contract_rec.contract_type);

140: END IF;
141:
142: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
143: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
144: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_TYPE ' || contract_rec.contract_type);
145: END IF;
146: WF_ENGINE.SetItemAttrText (
147: itemtype => itemtype,
148: itemkey => itemkey,

Line 146: WF_ENGINE.SetItemAttrText (

142: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
143: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
144: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_TYPE ' || contract_rec.contract_type);
145: END IF;
146: WF_ENGINE.SetItemAttrText (
147: itemtype => itemtype,
148: itemkey => itemkey,
149: aname => 'CONTRACT_TYPE',
150: avalue => contract_rec.contract_type);

Line 154: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NUMBER ' || contract_rec.contract_number);

150: avalue => contract_rec.contract_type);
151:
152: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
153: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
154: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NUMBER ' || contract_rec.contract_number);
155: END IF;
156: WF_ENGINE.SetItemAttrText (
157: itemtype => itemtype,
158: itemkey => itemkey,

Line 156: WF_ENGINE.SetItemAttrText (

152: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
153: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
154: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NUMBER ' || contract_rec.contract_number);
155: END IF;
156: WF_ENGINE.SetItemAttrText (
157: itemtype => itemtype,
158: itemkey => itemkey,
159: aname => 'CONTRACT_NUMBER',
160: avalue => contract_rec.contract_number);

Line 165: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_VERSION_NUM ' || contract_rec.contract_version_num);

161:
162:
163: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
164: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
165: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_VERSION_NUM ' || contract_rec.contract_version_num);
166: END IF;
167: WF_ENGINE.SetItemAttrNumber (
168: itemtype => itemtype,
169: itemkey => itemkey,

Line 167: WF_ENGINE.SetItemAttrNumber (

163: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
164: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
165: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_VERSION_NUM ' || contract_rec.contract_version_num);
166: END IF;
167: WF_ENGINE.SetItemAttrNumber (
168: itemtype => itemtype,
169: itemkey => itemkey,
170: aname => 'CONTRACT_VERSION',
171: avalue => contract_rec.contract_version_num);

Line 175: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NAME ' || contract_rec.contract_name);

171: avalue => contract_rec.contract_version_num);
172:
173: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
174: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
175: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NAME ' || contract_rec.contract_name);
176: END IF;
177: WF_ENGINE.SetItemAttrText (
178: itemtype => itemtype,
179: itemkey => itemkey,

Line 177: WF_ENGINE.SetItemAttrText (

173: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
174: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
175: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NAME ' || contract_rec.contract_name);
176: END IF;
177: WF_ENGINE.SetItemAttrText (
178: itemtype => itemtype,
179: itemkey => itemkey,
180: aname => 'CONTRACT_NAME',
181: avalue => contract_rec.contract_name);

Line 185: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_ATTACHMENTS');

181: avalue => contract_rec.contract_name);
182:
183: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
184: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
185: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_ATTACHMENTS');
186: END IF;
187: WF_ENGINE.SetItemAttrText (
188: itemtype => itemtype,
189: itemkey => itemkey,

Line 187: WF_ENGINE.SetItemAttrText (

183: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
184: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
185: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_ATTACHMENTS');
186: END IF;
187: WF_ENGINE.SetItemAttrText (
188: itemtype => itemtype,
189: itemkey => itemkey,
190: aname => 'CONTRACT_ATTACHMENTS',
191: avalue => 'FND:entity=OKC_CONTRACT_DOCS&pk1name=BusinessDocumentType&pk1value='||contract_rec.contract_type

Line 312: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');

308: IF (funcmode = 'RUN') then
309: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
310: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
311: g_module || l_api_name,
312: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
313: END IF;
314: l_contract_id := wf_engine.GetItemAttrNumber(
315: itemtype => itemtype,
316: itemkey => itemkey,

Line 314: l_contract_id := wf_engine.GetItemAttrNumber(

310: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
311: g_module || l_api_name,
312: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
313: END IF;
314: l_contract_id := wf_engine.GetItemAttrNumber(
315: itemtype => itemtype,
316: itemkey => itemkey,
317: aname => 'CONTRACT_ID');
318: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 344: wf_engine.SetItemAttrText (

340: 'Number of approvers: ' || to_char(l_next_approvers.count));
341: END IF;
342: IF (l_next_approvers.count = 0) THEN
343: -- No more approver.
344: wf_engine.SetItemAttrText (
345: itemtype => itemtype,
346: itemkey => itemkey,
347: aname => 'APPROVER',
348: avalue => NULL);

Line 352: wf_engine.SetItemAttrText (

348: avalue => NULL);
349: resultout := 'COMPLETE:F';
350: ELSIF (l_next_approvers.count = 1) THEN
351: -- Only 1 approver remaining
352: wf_engine.SetItemAttrText (
353: itemtype => itemtype,
354: itemkey => itemkey,
355: aname => 'APPROVER',
356: avalue => l_next_approvers(1).name);

Line 398: wf_engine.SetItemAttrText (

394: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
395: g_module || l_api_name,
396: 'Completed Adhoc role creation');
397: END IF;
398: wf_engine.SetItemAttrText (
399: itemtype => itemtype,
400: itemkey => itemkey,
401: aname => 'APPROVER',
402: avalue => l_role_name);

Line 524: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');

520: IF (funcmode = 'RUN') then
521: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
522: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
523: g_module || l_api_name,
524: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
525: END IF;
526: l_contract_id := wf_engine.GetItemAttrNumber(
527: itemtype => itemtype,
528: itemkey => itemkey,

Line 526: l_contract_id := wf_engine.GetItemAttrNumber(

522: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
523: g_module || l_api_name,
524: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
525: END IF;
526: l_contract_id := wf_engine.GetItemAttrNumber(
527: itemtype => itemtype,
528: itemkey => itemkey,
529: aname => 'CONTRACT_ID');
530: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 565: l_contract_number := wf_engine.GetItemAttrText(

561: resultout := 'COMPLETE:T';
562: END IF;
563:
564: IF (l_next_approvers.count > 0) THEN
565: l_contract_number := wf_engine.GetItemAttrText(
566: itemtype => itemtype,
567: itemkey => itemkey,
568: aname => 'CONTRACT_NUMBER');
569: l_requester := wf_engine.GetItemAttrText(

Line 569: l_requester := wf_engine.GetItemAttrText(

565: l_contract_number := wf_engine.GetItemAttrText(
566: itemtype => itemtype,
567: itemkey => itemkey,
568: aname => 'CONTRACT_NUMBER');
569: l_requester := wf_engine.GetItemAttrText(
570: itemtype => itemtype,
571: itemkey => itemkey,
572: aname => 'REQUESTER');
573: l_contract_name := wf_engine.GetItemAttrText(

Line 573: l_contract_name := wf_engine.GetItemAttrText(

569: l_requester := wf_engine.GetItemAttrText(
570: itemtype => itemtype,
571: itemkey => itemkey,
572: aname => 'REQUESTER');
573: l_contract_name := wf_engine.GetItemAttrText(
574: itemtype => itemtype,
575: itemkey => itemkey,
576: aname => 'CONTRACT_NAME');
577: l_contract_version := wf_engine.GetItemAttrNumber(

Line 577: l_contract_version := wf_engine.GetItemAttrNumber(

573: l_contract_name := wf_engine.GetItemAttrText(
574: itemtype => itemtype,
575: itemkey => itemkey,
576: aname => 'CONTRACT_NAME');
577: l_contract_version := wf_engine.GetItemAttrNumber(
578: itemtype => itemtype,
579: itemkey => itemkey,
580: aname => 'CONTRACT_VERSION');
581: l_contract_type := wf_engine.GetItemAttrText(

Line 581: l_contract_type := wf_engine.GetItemAttrText(

577: l_contract_version := wf_engine.GetItemAttrNumber(
578: itemtype => itemtype,
579: itemkey => itemkey,
580: aname => 'CONTRACT_VERSION');
581: l_contract_type := wf_engine.GetItemAttrText(
582: itemtype => itemtype,
583: itemkey => itemkey,
584: aname => 'CONTRACT_TYPE');
585: l_notified_count := wf_engine.GetItemAttrNumber(

Line 585: l_notified_count := wf_engine.GetItemAttrNumber(

581: l_contract_type := wf_engine.GetItemAttrText(
582: itemtype => itemtype,
583: itemkey => itemkey,
584: aname => 'CONTRACT_TYPE');
585: l_notified_count := wf_engine.GetItemAttrNumber(
586: itemtype => itemtype,
587: itemkey => itemkey,
588: aname => 'APPROVER_COUNTER');
589: FOR i IN l_next_approvers.first..l_next_approvers.last LOOP

Line 664: 'Calling WF_ENGINE.createprocess for Notification');

660: l_notified_count := l_notified_count + 1;
661: l_item_key := itemkey || '_' || to_char(l_notified_count);
662: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
663: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
664: 'Calling WF_ENGINE.createprocess for Notification');
665: END IF;
666:
667: WF_ENGINE.createprocess (
668: itemtype => itemtype,

Line 667: WF_ENGINE.createprocess (

663: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
664: 'Calling WF_ENGINE.createprocess for Notification');
665: END IF;
666:
667: WF_ENGINE.createprocess (
668: itemtype => itemtype,
669: itemkey => l_item_key,
670: process => G_APPROVAL_NOTIF_PROCESS);
671:

Line 674: 'Calling WF_ENGINE.SetItemOwner for Notification Process');

670: process => G_APPROVAL_NOTIF_PROCESS);
671:
672: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
673: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
674: 'Calling WF_ENGINE.SetItemOwner for Notification Process');
675: END IF;
676: WF_ENGINE.SetItemOwner (
677: itemtype => itemtype,
678: itemkey => l_item_key,

Line 676: WF_ENGINE.SetItemOwner (

672: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
673: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
674: 'Calling WF_ENGINE.SetItemOwner for Notification Process');
675: END IF;
676: WF_ENGINE.SetItemOwner (
677: itemtype => itemtype,
678: itemkey => l_item_key,
679: owner => fnd_global.user_name);
680:

Line 685: WF_ENGINE.SetItemAttrText (

681: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
682: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
683: 'Setting Notification Process Approver to: ' || l_user_name);
684: END IF;
685: WF_ENGINE.SetItemAttrText (
686: itemtype => itemtype,
687: itemkey => l_item_key,
688: aname => 'APPROVER',
689: avalue => l_user_name);

Line 695: WF_ENGINE.SetItemAttrNumber (

691: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
692: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
693: 'Setting Notification Process Contract Id to: ' || l_contract_id);
694: END IF;
695: WF_ENGINE.SetItemAttrNumber (
696: itemtype => itemtype,
697: itemkey => l_item_key,
698: aname => 'CONTRACT_ID',
699: avalue => l_contract_id);

Line 705: WF_ENGINE.SetItemAttrText (

701: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
702: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
703: 'Setting Notification Process Contract Name: ' || l_contract_name);
704: END IF;
705: WF_ENGINE.SetItemAttrText (
706: itemtype => itemtype,
707: itemkey => l_item_key,
708: aname => 'CONTRACT_NAME',
709: avalue => l_contract_name);

Line 715: WF_ENGINE.SetItemAttrNumber (

711: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
712: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
713: 'Setting Notification Process Contract Version: ' || l_contract_version);
714: END IF;
715: WF_ENGINE.SetItemAttrNumber (
716: itemtype => itemtype,
717: itemkey => l_item_key,
718: aname => 'CONTRACT_VERSION',
719: avalue => l_contract_version);

Line 725: WF_ENGINE.SetItemAttrText (

721: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
722: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
723: 'Setting Notification Process Contract Type: ' || l_contract_type);
724: END IF;
725: WF_ENGINE.SetItemAttrText (
726: itemtype => itemtype,
727: itemkey => l_item_key,
728: aname => 'CONTRACT_TYPE',
729: avalue => l_contract_type);

Line 735: WF_ENGINE.SetItemAttrText (

731: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
732: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
733: 'Setting Notification Process Contract Number: ' || l_contract_number);
734: END IF;
735: WF_ENGINE.SetItemAttrText (
736: itemtype => itemtype,
737: itemkey => l_item_key,
738: aname => 'CONTRACT_NUMBER',
739: avalue => l_contract_number);

Line 745: WF_ENGINE.SetItemAttrText (

741: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
742: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
743: 'Setting Notification Process Requester: ' || l_requester);
744: END IF;
745: WF_ENGINE.SetItemAttrText (
746: itemtype => itemtype,
747: itemkey => l_item_key,
748: aname => 'REQUESTER',
749: avalue => l_requester);

Line 755: WF_ENGINE.SetItemAttrText (

751: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
752: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
753: 'Setting Notification Process Contract Attachment');
754: END IF;
755: WF_ENGINE.SetItemAttrText (
756: itemtype => itemtype,
757: itemkey => l_item_key,
758: aname => 'CONTRACT_ATTACHMENTS',
759: avalue => 'FND:entity=OKC_CONTRACT_DOCS&pk1name=BusinessDocumentType&pk1value='||l_contract_type

Line 767: WF_ENGINE.SetItemAttrText (

763: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
764: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
765: 'Setting Notification Process Master Item Key to: ' || itemkey);
766: END IF;
767: WF_ENGINE.SetItemAttrText (
768: itemtype => itemtype,
769: itemkey => l_item_key,
770: aname => 'MASTER_ITEM_KEY',
771: avalue => itemkey);

Line 779: WF_ENGINE.SetItemAttrText (

775: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
776: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
777: 'Setting Notification Process APPROVER_TYPE to: ' || l_approver_type);
778: END IF;
779: WF_ENGINE.SetItemAttrText (
780: itemtype => itemtype,
781: itemkey => itemkey,
782: aname => 'APPROVER_TYPE',
783: avalue => l_approver_type);

Line 790: WF_ENGINE.SetItemAttrText (

786: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
787: 'Setting Notification Process APPROVER_POS_NAME to: ' || l_approver_name);
788: END IF;
789:
790: WF_ENGINE.SetItemAttrText (
791: itemtype => itemtype,
792: itemkey => itemkey,
793: aname => 'APPROVER_POS_NAME',
794: avalue => l_approver_name);

Line 797: WF_ENGINE.SetItemAttrText (

793: aname => 'APPROVER_POS_NAME',
794: avalue => l_approver_name);
795:
796: --Setting attributes for the child notification process
797: WF_ENGINE.SetItemAttrText (
798: itemtype => itemtype,
799: itemkey => l_item_key,
800: aname => 'APPROVER_TYPE',
801: avalue => l_approver_type);

Line 808: WF_ENGINE.SetItemAttrText (

804: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
805: 'Setting Notification Process APPROVER_POS_NAME to: ' || l_approver_name);
806: END IF;
807:
808: WF_ENGINE.SetItemAttrText (
809: itemtype => itemtype,
810: itemkey => l_item_key,
811: aname => 'APPROVER_POS_NAME',
812: avalue => l_approver_name);

Line 818: WF_ENGINE.SetItemAttrText (

814: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
815: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
816: 'Setting Notification Process Approver group Id to: ' || l_group_id);
817: END IF;
818: WF_ENGINE.SetItemAttrText (
819: itemtype => itemtype,
820: itemkey => l_item_key,
821: aname => 'APPROVER_GROUP_ID',
822: avalue => l_group_id);

Line 831: wf_engine.startProcess(

827: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
828: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
829: 'Starting Notification Process ');
830: END IF;
831: wf_engine.startProcess(
832: itemtype => itemtype,
833: itemkey => l_item_key);
834: END IF; -- l_next_approvers.exists(i)
835: END LOOP;

Line 838: 'Calling WF_ENGINE.setitemattrnumber for APPROVER_COUNTER: ' || l_notified_count);

834: END IF; -- l_next_approvers.exists(i)
835: END LOOP;
836: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
837: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
838: 'Calling WF_ENGINE.setitemattrnumber for APPROVER_COUNTER: ' || l_notified_count);
839: END IF;
840: WF_ENGINE.SetItemAttrNumber (
841: itemtype => itemtype,
842: itemkey => itemkey,

Line 840: WF_ENGINE.SetItemAttrNumber (

836: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
837: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
838: 'Calling WF_ENGINE.setitemattrnumber for APPROVER_COUNTER: ' || l_notified_count);
839: END IF;
840: WF_ENGINE.SetItemAttrNumber (
841: itemtype => itemtype,
842: itemkey => itemkey,
843: aname => 'APPROVER_COUNTER',
844: avalue => l_notified_count);

Line 976: l_contract_id := wf_engine.GetItemAttrNumber(

972: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
973: 'Function mode is: ' || funcmode);
974: END IF;
975: -- Get contract id and version attributes
976: l_contract_id := wf_engine.GetItemAttrNumber(
977: itemtype => itemtype,
978: itemkey => itemkey,
979: aname => 'CONTRACT_ID');
980: l_contract_version := wf_engine.GetItemAttrNumber(

Line 980: l_contract_version := wf_engine.GetItemAttrNumber(

976: l_contract_id := wf_engine.GetItemAttrNumber(
977: itemtype => itemtype,
978: itemkey => itemkey,
979: aname => 'CONTRACT_ID');
980: l_contract_version := wf_engine.GetItemAttrNumber(
981: itemtype => itemtype,
982: itemkey => itemkey,
983: aname => 'CONTRACT_VERSION');
984: -- Get the approver comments

Line 986: nid => WF_ENGINE.context_nid,

982: itemkey => itemkey,
983: aname => 'CONTRACT_VERSION');
984: -- Get the approver comments
985: l_wf_note := WF_NOTIFICATION.GetAttrText(
986: nid => WF_ENGINE.context_nid,
987: aname => 'WF_NOTE');
988: -- Get the approval status
989: l_approval_status := WF_NOTIFICATION.GetAttrText(
990: nid => WF_ENGINE.context_nid,

Line 990: nid => WF_ENGINE.context_nid,

986: nid => WF_ENGINE.context_nid,
987: aname => 'WF_NOTE');
988: -- Get the approval status
989: l_approval_status := WF_NOTIFICATION.GetAttrText(
990: nid => WF_ENGINE.context_nid,
991: aname => 'RESULT');
992: --14758583 : kkolukul : HR position support
993: l_approver_type := WF_NOTIFICATION.GetAttrText(
994: nid => WF_ENGINE.context_nid,

Line 994: nid => WF_ENGINE.context_nid,

990: nid => WF_ENGINE.context_nid,
991: aname => 'RESULT');
992: --14758583 : kkolukul : HR position support
993: l_approver_type := WF_NOTIFICATION.GetAttrText(
994: nid => WF_ENGINE.context_nid,
995: aname => 'APPROVER_TYPE');
996: l_approver_name := WF_NOTIFICATION.GetAttrText(
997: nid => WF_ENGINE.context_nid,
998: aname => 'APPROVER_POS_NAME');

Line 997: nid => WF_ENGINE.context_nid,

993: l_approver_type := WF_NOTIFICATION.GetAttrText(
994: nid => WF_ENGINE.context_nid,
995: aname => 'APPROVER_TYPE');
996: l_approver_name := WF_NOTIFICATION.GetAttrText(
997: nid => WF_ENGINE.context_nid,
998: aname => 'APPROVER_POS_NAME');
999:
1000: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1001: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1021: OPEN notif_csr(WF_ENGINE.context_nid);

1017: g_module || l_api_name,
1018: 'Approver Name is : ' || l_approver_name);
1019: END IF;
1020: -- Get the notification recipient
1021: OPEN notif_csr(WF_ENGINE.context_nid);
1022: FETCH notif_csr into notif_rec;
1023: IF(notif_csr%NOTFOUND) THEN
1024: RAISE NO_DATA_FOUND;
1025: END IF;

Line 1318: l_contract_id := wf_engine.GetItemAttrNumber(

1314: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1315: 'Function mode is: ' || funcmode);
1316: END IF;
1317: -- Get contract id and version attributes
1318: l_contract_id := wf_engine.GetItemAttrNumber(
1319: itemtype => itemtype,
1320: itemkey => itemkey,
1321: aname => 'CONTRACT_ID');
1322: l_contract_version := wf_engine.GetItemAttrNumber(

Line 1322: l_contract_version := wf_engine.GetItemAttrNumber(

1318: l_contract_id := wf_engine.GetItemAttrNumber(
1319: itemtype => itemtype,
1320: itemkey => itemkey,
1321: aname => 'CONTRACT_ID');
1322: l_contract_version := wf_engine.GetItemAttrNumber(
1323: itemtype => itemtype,
1324: itemkey => itemkey,
1325: aname => 'CONTRACT_VERSION');
1326: -- Get the approver comments

Line 1328: nid => WF_ENGINE.context_nid,

1324: itemkey => itemkey,
1325: aname => 'CONTRACT_VERSION');
1326: -- Get the approver comments
1327: l_wf_note := WF_NOTIFICATION.GetAttrText(
1328: nid => WF_ENGINE.context_nid,
1329: aname => 'WF_NOTE');
1330: -- Get the approval status
1331: l_approval_status := WF_NOTIFICATION.GetAttrText(
1332: nid => WF_ENGINE.context_nid,

Line 1332: nid => WF_ENGINE.context_nid,

1328: nid => WF_ENGINE.context_nid,
1329: aname => 'WF_NOTE');
1330: -- Get the approval status
1331: l_approval_status := WF_NOTIFICATION.GetAttrText(
1332: nid => WF_ENGINE.context_nid,
1333: aname => 'RESULT');
1334: -- 14758583 : kkolukul : HR position support
1335: l_approver_type := WF_NOTIFICATION.GetAttrText(
1336: nid => WF_ENGINE.context_nid,

Line 1336: nid => WF_ENGINE.context_nid,

1332: nid => WF_ENGINE.context_nid,
1333: aname => 'RESULT');
1334: -- 14758583 : kkolukul : HR position support
1335: l_approver_type := WF_NOTIFICATION.GetAttrText(
1336: nid => WF_ENGINE.context_nid,
1337: aname => 'APPROVER_TYPE');
1338: l_approver_name := WF_NOTIFICATION.GetAttrText(
1339: nid => WF_ENGINE.context_nid,
1340: aname => 'APPROVER_POS_NAME');

Line 1339: nid => WF_ENGINE.context_nid,

1335: l_approver_type := WF_NOTIFICATION.GetAttrText(
1336: nid => WF_ENGINE.context_nid,
1337: aname => 'APPROVER_TYPE');
1338: l_approver_name := WF_NOTIFICATION.GetAttrText(
1339: nid => WF_ENGINE.context_nid,
1340: aname => 'APPROVER_POS_NAME');
1341: --Bug 16231003
1342: l_group_id := WF_NOTIFICATION.GetAttrText(
1343: nid => WF_ENGINE.context_nid,

Line 1343: nid => WF_ENGINE.context_nid,

1339: nid => WF_ENGINE.context_nid,
1340: aname => 'APPROVER_POS_NAME');
1341: --Bug 16231003
1342: l_group_id := WF_NOTIFICATION.GetAttrText(
1343: nid => WF_ENGINE.context_nid,
1344: aname => 'APPROVER_GROUP_ID');
1345:
1346: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1347: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1371: OPEN notif_csr(WF_ENGINE.context_nid);

1367: 'Approver group Id is : ' || l_group_id);
1368:
1369: END IF;
1370: -- Get the notification recipient
1371: OPEN notif_csr(WF_ENGINE.context_nid);
1372: FETCH notif_csr into notif_rec;
1373: IF(notif_csr%NOTFOUND) THEN
1374: RAISE NO_DATA_FOUND;
1375: END IF;

Line 1393: l_notification_record.notification_id := WF_ENGINE.context_nid;

1389:
1390: l_approver_record2.group_or_chain_id := l_group_id;
1391:
1392:
1393: l_notification_record.notification_id := WF_ENGINE.context_nid;
1394: l_notification_record.user_comments := l_wf_note;
1395: -- FUNCTION MODE IS RESPOND.
1396: IF (funcmode = 'RESPOND') THEN
1397: -- CURRENT APPROVER APPROVED THE CONTRACTS

Line 1505: l_forwardTo := wf_notification.GetAttrText(WF_ENGINE.context_nid, 'FORWARD_TO_USERNAME_RESPONSE');

1501: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1502: END IF;
1503:
1504:
1505: l_forwardTo := wf_notification.GetAttrText(WF_ENGINE.context_nid, 'FORWARD_TO_USERNAME_RESPONSE');
1506:
1507: if(l_forwardTo is null) then
1508: fnd_message.set_name('OKC', 'OKC_WF_NOTIF_NO_USER');
1509: app_exception.raise_exception;

Line 1686: l_recipient_record2.name := wf_engine.context_new_role;

1682: END IF; -- (funcmode = 'TIMEOUT')
1683:
1684: --kkolukul: 9825586 - Huaweii ER
1685: IF (funcmode = 'FORWARD' OR funcmode = 'TRANSFER') THEN
1686: l_recipient_record2.name := wf_engine.context_new_role;
1687:
1688: SELECT user_id INTO l_recipient_id
1689: FROM fnd_user
1690: WHERE user_name = l_recipient_record2.name;

Line 1852: l_contract_id := wf_engine.GetItemAttrNumber(

1848: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1849: 'Function mode is: ' || funcmode);
1850: END IF;
1851: IF (funcmode = 'RUN') THEN
1852: l_contract_id := wf_engine.GetItemAttrNumber(
1853: itemtype => itemtype,
1854: itemkey => itemkey,
1855: aname => 'CONTRACT_ID');
1856: l_contract_version := wf_engine.GetItemAttrNumber(

Line 1856: l_contract_version := wf_engine.GetItemAttrNumber(

1852: l_contract_id := wf_engine.GetItemAttrNumber(
1853: itemtype => itemtype,
1854: itemkey => itemkey,
1855: aname => 'CONTRACT_ID');
1856: l_contract_version := wf_engine.GetItemAttrNumber(
1857: itemtype => itemtype,
1858: itemkey => itemkey,
1859: aname => 'CONTRACT_VERSION');
1860: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2179: l_contract_id := wf_engine.GetItemAttrNumber(

2175: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2176: 'Function mode is: ' || funcmode);
2177: END IF;
2178: if (funcmode = 'RUN') then
2179: l_contract_id := wf_engine.GetItemAttrNumber(
2180: itemtype => itemtype,
2181: itemkey => itemkey,
2182: aname => 'CONTRACT_ID');
2183: l_contract_version := wf_engine.GetItemAttrNumber(

Line 2183: l_contract_version := wf_engine.GetItemAttrNumber(

2179: l_contract_id := wf_engine.GetItemAttrNumber(
2180: itemtype => itemtype,
2181: itemkey => itemkey,
2182: aname => 'CONTRACT_ID');
2183: l_contract_version := wf_engine.GetItemAttrNumber(
2184: itemtype => itemtype,
2185: itemkey => itemkey,
2186: aname => 'CONTRACT_VERSION');
2187: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2304: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');

2300: IF (funcmode = 'RUN') then
2301: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2302: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2303: g_module || l_api_name,
2304: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
2305: END IF;
2306: l_contract_id := wf_engine.GetItemAttrNumber(
2307: itemtype => itemtype,
2308: itemkey => itemkey,

Line 2306: l_contract_id := wf_engine.GetItemAttrNumber(

2302: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2303: g_module || l_api_name,
2304: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
2305: END IF;
2306: l_contract_id := wf_engine.GetItemAttrNumber(
2307: itemtype => itemtype,
2308: itemkey => itemkey,
2309: aname => 'CONTRACT_ID');
2310: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2462: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');

2458: IF (funcmode = 'RUN') then
2459: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2460: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2461: g_module || l_api_name,
2462: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
2463: END IF;
2464: l_contract_id := wf_engine.GetItemAttrNumber(
2465: itemtype => itemtype,
2466: itemkey => itemkey,

Line 2464: l_contract_id := wf_engine.GetItemAttrNumber(

2460: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2461: g_module || l_api_name,
2462: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
2463: END IF;
2464: l_contract_id := wf_engine.GetItemAttrNumber(
2465: itemtype => itemtype,
2466: itemkey => itemkey,
2467: aname => 'CONTRACT_ID');
2468: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2518: 'Calling WF_ENGINE.AbortProcess');

2514: FOR wf_process_rec IN wf_process_csr
2515: LOOP
2516: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2517: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,g_module || l_api_name,
2518: 'Calling WF_ENGINE.AbortProcess');
2519: END IF;
2520:
2521: WF_ENGINE.AbortProcess(
2522: itemtype => itemtype,

Line 2521: WF_ENGINE.AbortProcess(

2517: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,g_module || l_api_name,
2518: 'Calling WF_ENGINE.AbortProcess');
2519: END IF;
2520:
2521: WF_ENGINE.AbortProcess(
2522: itemtype => itemtype,
2523: itemkey => wf_process_rec.item_key,
2524: result => 'COMPLETE:',
2525: verify_lock => false,

Line 2645: l_master_key := wf_engine.GetItemAttrText(

2641: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2642: 'Function mode is: ' || funcmode);
2643: END IF;
2644: if (funcmode = 'RUN') then
2645: l_master_key := wf_engine.GetItemAttrText(
2646: itemtype => itemtype,
2647: itemkey => itemkey,
2648: aname => 'MASTER_ITEM_KEY');
2649: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2656: wf_engine.CompleteActivity(

2652: 'Master Item Key is: ' || l_master_key);
2653: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2654: 'Completing master process waiting activity');
2655: END IF;
2656: wf_engine.CompleteActivity(
2657: itemtype => itemtype,
2658: itemkey => l_master_key,
2659: activity => 'WAIT_FOR_APPROVER_RESPONSE',
2660: result => null);

Line 2742: l_contract_id := wf_engine.GetItemAttrNumber(

2738: 'Function mode is: ' || funcmode);
2739: END IF;
2740:
2741: IF (funcmode = 'RUN') THEN
2742: l_contract_id := wf_engine.GetItemAttrNumber(
2743: itemtype => itemtype,
2744: itemkey => itemkey,
2745: aname => 'CONTRACT_ID');
2746:

Line 2747: l_contract_type := wf_engine.GetItemAttrText(

2743: itemtype => itemtype,
2744: itemkey => itemkey,
2745: aname => 'CONTRACT_ID');
2746:
2747: l_contract_type := wf_engine.GetItemAttrText(
2748: itemtype => itemtype,
2749: itemkey => itemkey,
2750: aname => 'CONTRACT_TYPE');
2751:

Line 2840: l_contract_id := wf_engine.GetItemAttrNumber(

2836: 'Function mode is: ' || funcmode);
2837: END IF;
2838:
2839: IF (funcmode = 'RUN') THEN
2840: l_contract_id := wf_engine.GetItemAttrNumber(
2841: itemtype => itemtype,
2842: itemkey => itemkey,
2843: aname => 'CONTRACT_ID');
2844:

Line 2845: l_contract_type := wf_engine.GetItemAttrText(

2841: itemtype => itemtype,
2842: itemkey => itemkey,
2843: aname => 'CONTRACT_ID');
2844:
2845: l_contract_type := wf_engine.GetItemAttrText(
2846: itemtype => itemtype,
2847: itemkey => itemkey,
2848: aname => 'CONTRACT_TYPE');
2849:

Line 2850: l_con_req_id := wf_engine.GetItemAttrNumber(

2846: itemtype => itemtype,
2847: itemkey => itemkey,
2848: aname => 'CONTRACT_TYPE');
2849:
2850: l_con_req_id := wf_engine.GetItemAttrNumber(
2851: itemtype => itemtype,
2852: itemkey => itemkey,
2853: aname => 'CONC_REQUEST_ID' );
2854:

Line 3003: l_contract_type := wf_engine.GetItemAttrText(

2999: END IF;
3000:
3001: IF (funcmode = 'RUN') THEN
3002:
3003: l_contract_type := wf_engine.GetItemAttrText(
3004: itemtype => itemtype,
3005: itemkey => itemkey,
3006: aname => 'CONTRACT_TYPE');
3007:

Line 3087: l_contract_type := wf_engine.GetItemAttrText(

3083: END IF;
3084:
3085: IF (funcmode = 'RUN') THEN
3086:
3087: l_contract_type := wf_engine.GetItemAttrText(
3088: itemtype => itemtype,
3089: itemkey => itemkey,
3090: aname => 'CONTRACT_TYPE');
3091:

Line 3092: l_contract_id := wf_engine.GetItemAttrNumber(

3088: itemtype => itemtype,
3089: itemkey => itemkey,
3090: aname => 'CONTRACT_TYPE');
3091:
3092: l_contract_id := wf_engine.GetItemAttrNumber(
3093: itemtype => itemtype,
3094: itemkey => itemkey,
3095: aname => 'CONTRACT_ID');
3096:

Line 3161: l_contract_id := wf_engine.GetItemAttrNumber(

3157: END IF;
3158:
3159: IF (funcmode = 'RUN') THEN
3160:
3161: l_contract_id := wf_engine.GetItemAttrNumber(
3162: itemtype => itemtype,
3163: itemkey => itemkey,
3164: aname => 'CONTRACT_ID');
3165:

Line 3166: l_user_id := wf_engine.GetItemAttrNumber(

3162: itemtype => itemtype,
3163: itemkey => itemkey,
3164: aname => 'CONTRACT_ID');
3165:
3166: l_user_id := wf_engine.GetItemAttrNumber(
3167: itemtype => itemtype,
3168: itemkey => itemkey,
3169: aname => 'CTX_USER_ID');
3170:

Line 3171: l_resp_appl_id := wf_engine.GetItemAttrNumber(

3167: itemtype => itemtype,
3168: itemkey => itemkey,
3169: aname => 'CTX_USER_ID');
3170:
3171: l_resp_appl_id := wf_engine.GetItemAttrNumber(
3172: itemtype => itemtype,
3173: itemkey => itemkey,
3174: aname => 'CTX_APPL_ID');
3175:

Line 3176: l_resp_id := wf_engine.GetItemAttrNumber(

3172: itemtype => itemtype,
3173: itemkey => itemkey,
3174: aname => 'CTX_APPL_ID');
3175:
3176: l_resp_id := wf_engine.GetItemAttrNumber(
3177: itemtype => itemtype,
3178: itemkey => itemkey,
3179: aname => 'CTX_RESP_ID');
3180: