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

Line 132: l_contract_id := wf_engine.GetItemAttrNumber(

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

Line 139: 'Calling WF_ENGINE.getitemattrnumber for l_contract_id ' || l_contract_id);

135: aname => 'CONTRACT_ID');
136:
137: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
138: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
139: 'Calling WF_ENGINE.getitemattrnumber for l_contract_id ' || l_contract_id);
140: END IF;
141:
142: -- Get contract attributes
143: OPEN contract_csr(l_contract_id);

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

147: END IF;
148:
149: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
150: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
151: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_TYPE ' || contract_rec.contract_type);
152: END IF;
153: WF_ENGINE.SetItemAttrText (
154: itemtype => itemtype,
155: itemkey => itemkey,

Line 153: WF_ENGINE.SetItemAttrText (

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

Line 164: 'Calling WF_ENGINE.setitemattrtext for CONTRACT_HDR_TOKEN ' || l_resolved_token);

160: l_resolved_token := OKC_API.resolve_hdr_token(contract_rec.contract_type);
161:
162: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
163: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
164: 'Calling WF_ENGINE.setitemattrtext for CONTRACT_HDR_TOKEN ' || l_resolved_token);
165: END IF;
166:
167:
168: WF_ENGINE.SetItemAttrText (

Line 168: WF_ENGINE.SetItemAttrText (

164: 'Calling WF_ENGINE.setitemattrtext for CONTRACT_HDR_TOKEN ' || l_resolved_token);
165: END IF;
166:
167:
168: WF_ENGINE.SetItemAttrText (
169: itemtype => itemtype,
170: itemkey => itemkey,
171: aname => 'CONTRACT_HDR_TOKEN',
172: avalue => l_resolved_token);

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

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

Line 180: WF_ENGINE.SetItemAttrText (

176: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
177: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NUMBER ' || contract_rec.contract_number);
178: END IF;
179:
180: WF_ENGINE.SetItemAttrText (
181: itemtype => itemtype,
182: itemkey => itemkey,
183: aname => 'CONTRACT_NUMBER',
184: avalue => contract_rec.contract_number);

Line 189: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_VERSION ' || contract_rec.contract_version_num);

185:
186:
187: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
188: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
189: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_VERSION ' || contract_rec.contract_version_num);
190: END IF;
191:
192: WF_ENGINE.SetItemAttrNumber (
193: itemtype => itemtype,

Line 192: WF_ENGINE.SetItemAttrNumber (

188: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
189: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_VERSION ' || contract_rec.contract_version_num);
190: END IF;
191:
192: WF_ENGINE.SetItemAttrNumber (
193: itemtype => itemtype,
194: itemkey => itemkey,
195: aname => 'CONTRACT_VERSION',
196: avalue => contract_rec.contract_version_num);

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

196: avalue => contract_rec.contract_version_num);
197:
198: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
199: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
200: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NAME ' || contract_rec.contract_name);
201: END IF;
202:
203: WF_ENGINE.SetItemAttrText (
204: itemtype => itemtype,

Line 203: WF_ENGINE.SetItemAttrText (

199: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
200: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NAME ' || contract_rec.contract_name);
201: END IF;
202:
203: WF_ENGINE.SetItemAttrText (
204: itemtype => itemtype,
205: itemkey => itemkey,
206: aname => 'CONTRACT_NAME',
207: avalue => contract_rec.contract_name);

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

207: avalue => contract_rec.contract_name);
208:
209: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
210: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
211: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_ATTACHMENTS');
212: END IF;
213:
214: WF_ENGINE.SetItemAttrText (
215: itemtype => itemtype,

Line 214: WF_ENGINE.SetItemAttrText (

210: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
211: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_ATTACHMENTS');
212: END IF;
213:
214: WF_ENGINE.SetItemAttrText (
215: itemtype => itemtype,
216: itemkey => itemkey,
217: aname => 'CONTRACT_ATTACHMENTS',
218: avalue => 'FND:entity=OKC_CONTRACT_DOCS&pk1name=BusinessDocumentType&pk1value='||contract_rec.contract_type

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

508: IF (funcmode = 'RUN') then
509: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
510: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
511: g_module || l_api_name,
512: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
513: END IF;
514:
515: l_contract_id := wf_engine.GetItemAttrNumber(
516: itemtype => itemtype,

Line 515: l_contract_id := wf_engine.GetItemAttrNumber(

511: g_module || l_api_name,
512: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
513: END IF;
514:
515: l_contract_id := wf_engine.GetItemAttrNumber(
516: itemtype => itemtype,
517: itemkey => itemkey,
518: aname => 'CONTRACT_ID');
519:

Line 559: l_contract_number := wf_engine.GetItemAttrText(

555: resultout := 'COMPLETE:T';
556: END IF;
557:
558: IF (l_next_signers.count > 0) THEN
559: l_contract_number := wf_engine.GetItemAttrText(
560: itemtype => itemtype,
561: itemkey => itemkey,
562: aname => 'CONTRACT_NUMBER');
563: l_requester := wf_engine.GetItemAttrText(

Line 563: l_requester := wf_engine.GetItemAttrText(

559: l_contract_number := wf_engine.GetItemAttrText(
560: itemtype => itemtype,
561: itemkey => itemkey,
562: aname => 'CONTRACT_NUMBER');
563: l_requester := wf_engine.GetItemAttrText(
564: itemtype => itemtype,
565: itemkey => itemkey,
566: aname => 'REQUESTER');
567: l_contract_name := wf_engine.GetItemAttrText(

Line 567: l_contract_name := wf_engine.GetItemAttrText(

563: l_requester := wf_engine.GetItemAttrText(
564: itemtype => itemtype,
565: itemkey => itemkey,
566: aname => 'REQUESTER');
567: l_contract_name := wf_engine.GetItemAttrText(
568: itemtype => itemtype,
569: itemkey => itemkey,
570: aname => 'CONTRACT_NAME');
571: l_contract_version := wf_engine.GetItemAttrNumber(

Line 571: l_contract_version := wf_engine.GetItemAttrNumber(

567: l_contract_name := wf_engine.GetItemAttrText(
568: itemtype => itemtype,
569: itemkey => itemkey,
570: aname => 'CONTRACT_NAME');
571: l_contract_version := wf_engine.GetItemAttrNumber(
572: itemtype => itemtype,
573: itemkey => itemkey,
574: aname => 'CONTRACT_VERSION');
575: l_contract_type := wf_engine.GetItemAttrText(

Line 575: l_contract_type := wf_engine.GetItemAttrText(

571: l_contract_version := wf_engine.GetItemAttrNumber(
572: itemtype => itemtype,
573: itemkey => itemkey,
574: aname => 'CONTRACT_VERSION');
575: l_contract_type := wf_engine.GetItemAttrText(
576: itemtype => itemtype,
577: itemkey => itemkey,
578: aname => 'CONTRACT_TYPE');
579: l_contract_hdr_token := wf_engine.GetItemAttrText(

Line 579: l_contract_hdr_token := wf_engine.GetItemAttrText(

575: l_contract_type := wf_engine.GetItemAttrText(
576: itemtype => itemtype,
577: itemkey => itemkey,
578: aname => 'CONTRACT_TYPE');
579: l_contract_hdr_token := wf_engine.GetItemAttrText(
580: itemtype => itemtype,
581: itemkey => itemkey,
582: aname => 'CONTRACT_HDR_TOKEN');
583:

Line 589: l_notified_count := wf_engine.GetItemAttrNumber(

585: OPEN get_owner;
586: FETCH get_owner INTO l_owner;
587: CLOSE get_owner;
588:
589: l_notified_count := wf_engine.GetItemAttrNumber(
590: itemtype => itemtype,
591: itemkey => itemkey,
592: aname => 'SIGN_COUNTER');
593:

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

605: l_item_key := itemkey || '_' || to_char(l_notified_count);
606:
607: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
608: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
609: 'Calling WF_ENGINE.createprocess for Notification');
610: END IF;
611:
612: WF_ENGINE.createprocess (
613: itemtype => itemtype,

Line 612: WF_ENGINE.createprocess (

608: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
609: 'Calling WF_ENGINE.createprocess for Notification');
610: END IF;
611:
612: WF_ENGINE.createprocess (
613: itemtype => itemtype,
614: itemkey => l_item_key,
615: process => G_SIGN_NOTIF_PROCESS);
616:

Line 619: 'Calling WF_ENGINE.SetItemOwner for Notification Process '||l_owner);

615: process => G_SIGN_NOTIF_PROCESS);
616:
617: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
618: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
619: 'Calling WF_ENGINE.SetItemOwner for Notification Process '||l_owner);
620: END IF;
621:
622: WF_ENGINE.SetItemOwner (
623: itemtype => itemtype,

Line 622: WF_ENGINE.SetItemOwner (

618: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
619: 'Calling WF_ENGINE.SetItemOwner for Notification Process '||l_owner);
620: END IF;
621:
622: WF_ENGINE.SetItemOwner (
623: itemtype => itemtype,
624: itemkey => l_item_key,
625: owner => l_owner);
626:

Line 632: WF_ENGINE.SetItemAttrText (

628: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
629: 'Setting Notification Process Signer to: ' || l_user_name);
630: END IF;
631:
632: WF_ENGINE.SetItemAttrText (
633: itemtype => itemtype,
634: itemkey => l_item_key,
635: aname => 'SIGNER',
636: avalue => l_user_name);

Line 643: wf_engine.SetItemAttrNumber(

639: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
640: 'Setting current sequence id to: ' || l_next_signers(i).seq );
641: END IF;
642:
643: wf_engine.SetItemAttrNumber(
644: itemtype => itemtype,
645: itemkey => l_item_key,
646: aname => 'CURRENT_SEQUENCE_ID',
647: avalue => l_next_signers(i).seq);

Line 655: wf_engine.SetItemAttrNumber(

651: 'Setting current contact id: ' || l_next_signers(i).contact_id );
652: END IF;
653:
654:
655: wf_engine.SetItemAttrNumber(
656: itemtype => itemtype,
657: itemkey => l_item_key,
658: aname => 'CURRENT_CONTACT_ID',
659: avalue => l_next_signers(i).contact_id);

Line 667: wf_engine.SetItemAttrNumber(

663: 'Setting current party id: ' || l_next_signers(i).party_id );
664: END IF;
665:
666:
667: wf_engine.SetItemAttrNumber(
668: itemtype => itemtype,
669: itemkey => l_item_key,
670: aname => 'CURRENT_PARTY_ID',
671: avalue => l_next_signers(i).party_id);

Line 678: wf_engine.SetItemAttrText(

674: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
675: 'Setting current party role code : ' || l_next_signers(i).party_role_code );
676: END IF;
677:
678: wf_engine.SetItemAttrText(
679: itemtype => itemtype,
680: itemkey => l_item_key,
681: aname => 'CURRENT_PARTY_ROLE_CODE',
682: avalue => l_next_signers(i).party_role_code);

Line 690: WF_ENGINE.SetItemAttrNumber (

686: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
687: 'Setting Notification Process Contract Id to: ' || l_contract_id);
688: END IF;
689:
690: WF_ENGINE.SetItemAttrNumber (
691: itemtype => itemtype,
692: itemkey => l_item_key,
693: aname => 'CONTRACT_ID',
694: avalue => l_contract_id);

Line 702: WF_ENGINE.SetItemAttrText (

698: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
699: 'Setting Notification Process Contract Header Token to: ' || l_contract_hdr_token);
700: END IF;
701:
702: WF_ENGINE.SetItemAttrText (
703: itemtype => itemtype,
704: itemkey => l_item_key,
705: aname => 'CONTRACT_HDR_TOKEN',
706: avalue => l_contract_hdr_token);

Line 714: WF_ENGINE.SetItemAttrText (

710: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
711: 'Setting Notification Process Contract Name: ' || l_contract_name);
712: END IF;
713:
714: WF_ENGINE.SetItemAttrText (
715: itemtype => itemtype,
716: itemkey => l_item_key,
717: aname => 'CONTRACT_NAME',
718: avalue => l_contract_name);

Line 725: WF_ENGINE.SetItemAttrNumber (

721: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
722: 'Setting Notification Process Contract Version: ' || l_contract_version);
723: END IF;
724:
725: WF_ENGINE.SetItemAttrNumber (
726: itemtype => itemtype,
727: itemkey => l_item_key,
728: aname => 'CONTRACT_VERSION',
729: avalue => l_contract_version);

Line 736: WF_ENGINE.SetItemAttrText (

732: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
733: 'Setting Notification Process Contract Type: ' || l_contract_type);
734: END IF;
735:
736: WF_ENGINE.SetItemAttrText (
737: itemtype => itemtype,
738: itemkey => l_item_key,
739: aname => 'CONTRACT_TYPE',
740: avalue => l_contract_type);

Line 747: WF_ENGINE.SetItemAttrText (

743: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
744: 'Setting Notification Process Contract Number: ' || l_contract_number);
745: END IF;
746:
747: WF_ENGINE.SetItemAttrText (
748: itemtype => itemtype,
749: itemkey => l_item_key,
750: aname => 'CONTRACT_NUMBER',
751: avalue => l_contract_number);

Line 758: WF_ENGINE.SetItemAttrText (

754: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
755: 'Setting Notification Process Requester: ' || l_requester);
756: END IF;
757:
758: WF_ENGINE.SetItemAttrText (
759: itemtype => itemtype,
760: itemkey => l_item_key,
761: aname => 'REQUESTER',
762: avalue => l_requester);

Line 769: WF_ENGINE.SetItemAttrText (

765: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
766: 'Setting Notification Process Subject to : ' || l_next_signers(i).SUBJECT);
767: END IF;
768:
769: WF_ENGINE.SetItemAttrText (
770: itemtype => itemtype,
771: itemkey => l_item_key,
772: aname => 'SUBJECT',
773: avalue => l_next_signers(i).SUBJECT);

Line 783: WF_ENGINE.SetItemAttrText (

779: END IF;
780:
781:
782:
783: WF_ENGINE.SetItemAttrText (
784: itemtype => itemtype,
785: itemkey => itemkey,
786: aname => 'CONTRACT_ATTACHMENTS',
787: avalue => 'FND:entity=OKC_CONTRACT_DOCS&pk1name=BusinessDocumentType&pk1value='||l_contract_type

Line 798: WF_ENGINE.SetItemAttrText (

794: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
795: 'Setting Notification Process Master Item Key to: ' || itemkey);
796: END IF;
797:
798: WF_ENGINE.SetItemAttrText (
799: itemtype => itemtype,
800: itemkey => l_item_key,
801: aname => 'MASTER_ITEM_KEY',
802: avalue => itemkey);

Line 809: wf_engine.startProcess(

805: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
806: 'Starting Notification Process with item type '||itemtype ||'itemkey '||l_item_key );
807: END IF;
808:
809: wf_engine.startProcess(
810: itemtype => itemtype,
811: itemkey => l_item_key);
812: END IF; -- l_next_signers.exists(i)
813:

Line 818: 'Calling WF_ENGINE.setitemattrnumber for SIGNER_COUNTER: ' || l_notified_count);

814: END LOOP;
815:
816: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
817: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
818: 'Calling WF_ENGINE.setitemattrnumber for SIGNER_COUNTER: ' || l_notified_count);
819: END IF;
820:
821:
822: WF_ENGINE.SetItemAttrNumber (

Line 822: WF_ENGINE.SetItemAttrNumber (

818: 'Calling WF_ENGINE.setitemattrnumber for SIGNER_COUNTER: ' || l_notified_count);
819: END IF;
820:
821:
822: WF_ENGINE.SetItemAttrNumber (
823: itemtype => itemtype,
824: itemkey => itemkey,
825: aname => 'SIGN_COUNTER',
826: avalue => l_notified_count);

Line 972: l_contract_id := wf_engine.GetItemAttrNumber(

968: 'Function mode is: ' || funcmode);
969: END IF;
970:
971: -- Get contract id and version Fs
972: l_contract_id := wf_engine.GetItemAttrNumber(
973: itemtype => itemtype,
974: itemkey => itemkey,
975: aname => 'CONTRACT_ID');
976: l_sequence_id := wf_engine.GetItemAttrNumber(

Line 976: l_sequence_id := wf_engine.GetItemAttrNumber(

972: l_contract_id := wf_engine.GetItemAttrNumber(
973: itemtype => itemtype,
974: itemkey => itemkey,
975: aname => 'CONTRACT_ID');
976: l_sequence_id := wf_engine.GetItemAttrNumber(
977: itemtype => itemtype,
978: itemkey => itemkey,
979: aname => 'CURRENT_SEQUENCE_ID');
980:

Line 981: l_contact_id:= wf_engine.GetItemAttrNumber(

977: itemtype => itemtype,
978: itemkey => itemkey,
979: aname => 'CURRENT_SEQUENCE_ID');
980:
981: l_contact_id:= wf_engine.GetItemAttrNumber(
982: itemtype => itemtype,
983: itemkey => itemkey,
984: aname => 'CURRENT_CONTACT_ID');
985:

Line 986: l_party_id:= wf_engine.GetItemAttrNumber(

982: itemtype => itemtype,
983: itemkey => itemkey,
984: aname => 'CURRENT_CONTACT_ID');
985:
986: l_party_id:= wf_engine.GetItemAttrNumber(
987: itemtype => itemtype,
988: itemkey => itemkey,
989: aname => 'CURRENT_PARTY_ID');
990:

Line 991: l_party_role_code:= wf_engine.GetItemAttrText(

987: itemtype => itemtype,
988: itemkey => itemkey,
989: aname => 'CURRENT_PARTY_ID');
990:
991: l_party_role_code:= wf_engine.GetItemAttrText(
992: itemtype => itemtype,
993: itemkey => itemkey,
994: aname => 'CURRENT_PARTY_ROLE_CODE');
995: l_contract_version := wf_engine.GetItemAttrNumber(

Line 995: l_contract_version := wf_engine.GetItemAttrNumber(

991: l_party_role_code:= wf_engine.GetItemAttrText(
992: itemtype => itemtype,
993: itemkey => itemkey,
994: aname => 'CURRENT_PARTY_ROLE_CODE');
995: l_contract_version := wf_engine.GetItemAttrNumber(
996: itemtype => itemtype,
997: itemkey => itemkey,
998: aname => 'CONTRACT_VERSION');
999: -- Get the signer comments

Line 1001: nid => WF_ENGINE.context_nid,

997: itemkey => itemkey,
998: aname => 'CONTRACT_VERSION');
999: -- Get the signer comments
1000: l_wf_note := WF_NOTIFICATION.GetAttrText(
1001: nid => WF_ENGINE.context_nid,
1002: aname => 'WF_NOTE');
1003: -- Get the sign status
1004: l_SIGN_status := WF_NOTIFICATION.GetAttrText(
1005: nid => WF_ENGINE.context_nid,

Line 1005: nid => WF_ENGINE.context_nid,

1001: nid => WF_ENGINE.context_nid,
1002: aname => 'WF_NOTE');
1003: -- Get the sign status
1004: l_SIGN_status := WF_NOTIFICATION.GetAttrText(
1005: nid => WF_ENGINE.context_nid,
1006: aname => 'RESULT');
1007:
1008: OPEN c_get_contract_details_csr(l_contract_id);
1009: FETCH c_get_contract_details_csr INTO l_contract_type , l_org_id;

Line 1015: nid => WF_ENGINE.context_nid,

1011:
1012: IF(l_contract_type = 'REP_SBCR') THEN
1013:
1014: l_control_number := WF_NOTIFICATION.GetAttrText(
1015: nid => WF_ENGINE.context_nid,
1016: aname => 'CONTROL_NUMBER');
1017:
1018: IF (l_control_number IS NOT NULL) THEN
1019:

Line 1070: OPEN notif_csr(WF_ENGINE.context_nid);

1066:
1067:
1068:
1069: -- Get the notification recipient
1070: OPEN notif_csr(WF_ENGINE.context_nid);
1071: FETCH notif_csr into notif_rec;
1072: IF(notif_csr%NOTFOUND) THEN
1073: RAISE NO_DATA_FOUND;
1074: END IF;

Line 1167: l_master_key := wf_engine.GetItemAttrText(

1163: END IF;
1164:
1165:
1166:
1167: l_master_key := wf_engine.GetItemAttrText(
1168: itemtype => itemtype,
1169: itemkey => itemkey,
1170: aname => 'MASTER_ITEM_KEY');
1171: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1184: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NUMBER ' || l_control_number);

1180: IF(l_control_number IS NOT NULL) THEN
1181:
1182: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1183: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1184: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NUMBER ' || l_control_number);
1185: END IF;
1186:
1187: WF_ENGINE.SetItemAttrText (
1188: itemtype => itemtype,

Line 1187: WF_ENGINE.SetItemAttrText (

1183: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1184: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NUMBER ' || l_control_number);
1185: END IF;
1186:
1187: WF_ENGINE.SetItemAttrText (
1188: itemtype => itemtype,
1189: itemkey => l_master_key,
1190: aname => 'CONTRACT_NUMBER',
1191: avalue => l_control_number);

Line 1193: WF_ENGINE.SetItemAttrText (

1189: itemkey => l_master_key,
1190: aname => 'CONTRACT_NUMBER',
1191: avalue => l_control_number);
1192:
1193: WF_ENGINE.SetItemAttrText (
1194: itemtype => itemtype,
1195: itemkey => itemkey,
1196: aname => 'CONTRACT_NUMBER',
1197: avalue => l_control_number);

Line 1216: wf_engine.CompleteActivity(

1212: g_module || l_api_name,
1213: 'Complete the activity WAIT_FOR_SIGNER_RESPONSE with l_sign_status : ' || l_sign_status);
1214: END IF;
1215:
1216: wf_engine.CompleteActivity(
1217: itemtype => itemtype,
1218: itemkey => To_Char(l_master_key),
1219: activity => 'WAIT_FOR_SIGNER_RESPONSE',
1220: result => l_sign_status );

Line 1231: wf_engine.CompleteActivity(

1227: g_module || l_api_name,
1228: 'Complete the activity WAIT_FOR_SIGNER_RESPONSE with l_sign_status : ' || l_sign_status);
1229: END IF;
1230:
1231: wf_engine.CompleteActivity(
1232: itemtype => itemtype,
1233: itemkey => To_Char(l_master_key),
1234: activity => 'WAIT_FOR_SIGNER_RESPONSE',
1235: result => l_sign_status );

Line 1410: l_contract_id := wf_engine.GetItemAttrNumber(

1406: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1407: 'Function mode is: ' || funcmode);
1408: END IF;
1409: IF (funcmode = 'RUN') THEN
1410: l_contract_id := wf_engine.GetItemAttrNumber(
1411: itemtype => itemtype,
1412: itemkey => itemkey,
1413: aname => 'CONTRACT_ID');
1414: l_contract_version := wf_engine.GetItemAttrNumber(

Line 1414: l_contract_version := wf_engine.GetItemAttrNumber(

1410: l_contract_id := wf_engine.GetItemAttrNumber(
1411: itemtype => itemtype,
1412: itemkey => itemkey,
1413: aname => 'CONTRACT_ID');
1414: l_contract_version := wf_engine.GetItemAttrNumber(
1415: itemtype => itemtype,
1416: itemkey => itemkey,
1417: aname => 'CONTRACT_VERSION');
1418: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1730: l_contract_id := wf_engine.GetItemAttrNumber(

1726: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1727: 'Function mode is: ' || funcmode);
1728: END IF;
1729: if (funcmode = 'RUN') then
1730: l_contract_id := wf_engine.GetItemAttrNumber(
1731: itemtype => itemtype,
1732: itemkey => itemkey,
1733: aname => 'CONTRACT_ID');
1734: l_contract_version := wf_engine.GetItemAttrNumber(

Line 1734: l_contract_version := wf_engine.GetItemAttrNumber(

1730: l_contract_id := wf_engine.GetItemAttrNumber(
1731: itemtype => itemtype,
1732: itemkey => itemkey,
1733: aname => 'CONTRACT_ID');
1734: l_contract_version := wf_engine.GetItemAttrNumber(
1735: itemtype => itemtype,
1736: itemkey => itemkey,
1737: aname => 'CONTRACT_VERSION');
1738: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1855: l_contract_id := wf_engine.GetItemAttrNumber(

1851: 'Function mode is: ' || funcmode);
1852: END IF;
1853:
1854: IF (funcmode = 'RUN') THEN
1855: l_contract_id := wf_engine.GetItemAttrNumber(
1856: itemtype => itemtype,
1857: itemkey => itemkey,
1858: aname => 'CONTRACT_ID');
1859:

Line 1860: l_contract_type := wf_engine.GetItemAttrText(

1856: itemtype => itemtype,
1857: itemkey => itemkey,
1858: aname => 'CONTRACT_ID');
1859:
1860: l_contract_type := wf_engine.GetItemAttrText(
1861: itemtype => itemtype,
1862: itemkey => itemkey,
1863: aname => 'CONTRACT_TYPE');
1864:

Line 1954: l_contract_id := wf_engine.GetItemAttrNumber(

1950: 'Function mode is: ' || funcmode);
1951: END IF;
1952:
1953: IF (funcmode = 'RUN') THEN
1954: l_contract_id := wf_engine.GetItemAttrNumber(
1955: itemtype => itemtype,
1956: itemkey => itemkey,
1957: aname => 'CONTRACT_ID');
1958:

Line 1959: l_contract_type := wf_engine.GetItemAttrText(

1955: itemtype => itemtype,
1956: itemkey => itemkey,
1957: aname => 'CONTRACT_ID');
1958:
1959: l_contract_type := wf_engine.GetItemAttrText(
1960: itemtype => itemtype,
1961: itemkey => itemkey,
1962: aname => 'CONTRACT_TYPE');
1963:

Line 1964: l_con_req_id := wf_engine.GetItemAttrNumber(

1960: itemtype => itemtype,
1961: itemkey => itemkey,
1962: aname => 'CONTRACT_TYPE');
1963:
1964: l_con_req_id := wf_engine.GetItemAttrNumber(
1965: itemtype => itemtype,
1966: itemkey => itemkey,
1967: aname => 'CONC_REQUEST_ID' );
1968:

Line 2050: l_contract_type := wf_engine.GetItemAttrText(

2046: END IF;
2047:
2048: IF (funcmode = 'RUN') THEN
2049:
2050: l_contract_type := wf_engine.GetItemAttrText(
2051: itemtype => itemtype,
2052: itemkey => itemkey,
2053: aname => 'CONTRACT_TYPE');
2054:

Line 2055: l_contract_id := wf_engine.GetItemAttrNumber(

2051: itemtype => itemtype,
2052: itemkey => itemkey,
2053: aname => 'CONTRACT_TYPE');
2054:
2055: l_contract_id := wf_engine.GetItemAttrNumber(
2056: itemtype => itemtype,
2057: itemkey => itemkey,
2058: aname => 'CONTRACT_ID');
2059:

Line 2124: l_contract_id := wf_engine.GetItemAttrNumber(

2120: END IF;
2121:
2122: IF (funcmode = 'RUN') THEN
2123:
2124: l_contract_id := wf_engine.GetItemAttrNumber(
2125: itemtype => itemtype,
2126: itemkey => itemkey,
2127: aname => 'CONTRACT_ID');
2128:

Line 2129: l_user_id := wf_engine.GetItemAttrNumber(

2125: itemtype => itemtype,
2126: itemkey => itemkey,
2127: aname => 'CONTRACT_ID');
2128:
2129: l_user_id := wf_engine.GetItemAttrNumber(
2130: itemtype => itemtype,
2131: itemkey => itemkey,
2132: aname => 'CTX_USER_ID');
2133:

Line 2134: l_resp_appl_id := wf_engine.GetItemAttrNumber(

2130: itemtype => itemtype,
2131: itemkey => itemkey,
2132: aname => 'CTX_USER_ID');
2133:
2134: l_resp_appl_id := wf_engine.GetItemAttrNumber(
2135: itemtype => itemtype,
2136: itemkey => itemkey,
2137: aname => 'CTX_APPL_ID');
2138:

Line 2139: l_resp_id := wf_engine.GetItemAttrNumber(

2135: itemtype => itemtype,
2136: itemkey => itemkey,
2137: aname => 'CTX_APPL_ID');
2138:
2139: l_resp_id := wf_engine.GetItemAttrNumber(
2140: itemtype => itemtype,
2141: itemkey => itemkey,
2142: aname => 'CTX_RESP_ID');
2143: