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

Line 81: workflow error context to give as much information as possible to wf engine

77: ---------------------------------------------------------------------------
78: -- Procedure set_wf_error_context
79: ---------------------------------------------------------------------------
80: /* Proceedure loops through the FND_MSG_PUB stack and sets the
81: workflow error context to give as much information as possible to wf engine
82: in case an api fails
83: */
84: PROCEDURE set_wf_error_context(
85: p_pkg_name IN VARCHAR2,

Line 186: -- wf_seq_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'TMPL_WF_SEQ_ID', false);

182: RETURN;
183: /*Bug 6329229*/
184: ELSIF (funcmode = 'SET_CTX') THEN
185:
186: -- wf_seq_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'TMPL_WF_SEQ_ID', false);
187:
188:
189: -- Set the database session context
190: fnd_global.apps_initialize(l_user_id,l_resp_id, l_resp_appl_id);

Line 705: wf_engine.CreateProcess( ItemType => l_ItemType,

701: -- If workflowprocess is passed, it will be run.
702: -- If workflowprocess is NOT passed, the selector function
703: -- defined in the item type will determine which process to run.
704: --
705: wf_engine.CreateProcess( ItemType => l_ItemType,
706: ItemKey => l_ItemKey,
707: process => l_WorkflowProcess );
708:
709: wf_engine.SetItemUserKey ( ItemType => l_ItemType,

Line 709: wf_engine.SetItemUserKey ( ItemType => l_ItemType,

705: wf_engine.CreateProcess( ItemType => l_ItemType,
706: ItemKey => l_ItemKey,
707: process => l_WorkflowProcess );
708:
709: wf_engine.SetItemUserKey ( ItemType => l_ItemType,
710: ItemKey => l_ItemKey,
711: UserKey => l_ItemUserKey);
712: --
713: --

Line 716: wf_engine.SetItemAttrText ( itemtype => l_itemtype,

712: --
713: --
714: -- Initialize workflow item attributes
715: --
716: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
717: itemkey => l_itemkey,
718: aname => 'TEMPLATE_NAME',
719: avalue => l_tmpl_rec.template_name);
720: --

Line 721: wf_engine.SetItemAttrText ( itemtype => l_itemtype,

717: itemkey => l_itemkey,
718: aname => 'TEMPLATE_NAME',
719: avalue => l_tmpl_rec.template_name);
720: --
721: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
722: itemkey => l_itemkey,
723: aname => 'TEMPLATE_DESCRIPTION',
724: avalue => l_tmpl_rec.description);
725:

Line 726: wf_engine.SetItemAttrText ( itemtype => l_itemtype,

722: itemkey => l_itemkey,
723: aname => 'TEMPLATE_DESCRIPTION',
724: avalue => l_tmpl_rec.description);
725:
726: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
727: itemkey => l_itemkey,
728: aname => 'SUBMITTED_BY_USER',
729: avalue => l_ProcessOwner);
730:

Line 731: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,

727: itemkey => l_itemkey,
728: aname => 'SUBMITTED_BY_USER',
729: avalue => l_ProcessOwner);
730:
731: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,
732: itemkey => l_itemkey,
733: aname => 'TEMPLATE_ID',
734: avalue => l_tmpl_rec.template_id);
735:

Line 737: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,

733: aname => 'TEMPLATE_ID',
734: avalue => l_tmpl_rec.template_id);
735:
736:
737: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,
738: itemkey => l_itemkey,
739: aname => 'PRINT_TEMPLATE_ID',
740: avalue => l_tmpl_rec.print_template_id);
741:

Line 742: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,

738: itemkey => l_itemkey,
739: aname => 'PRINT_TEMPLATE_ID',
740: avalue => l_tmpl_rec.print_template_id);
741:
742: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,
743: itemkey => l_itemkey,
744: aname => 'ORG_ID',
745: avalue => l_tmpl_rec.org_id);
746:

Line 747: wf_engine.SetItemAttrText ( itemtype => l_itemtype,

743: itemkey => l_itemkey,
744: aname => 'ORG_ID',
745: avalue => l_tmpl_rec.org_id);
746:
747: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
748: itemkey => l_itemkey,
749: aname => 'STATUS_CODE',
750: avalue => l_tmpl_rec.status_code);
751:

Line 752: wf_engine.SetItemAttrText ( itemtype => l_itemtype,

748: itemkey => l_itemkey,
749: aname => 'STATUS_CODE',
750: avalue => l_tmpl_rec.status_code);
751:
752: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
753: itemkey => l_itemkey,
754: aname => 'TMPL_INTENT',
755: avalue => okc_util.decode_lookup('OKC_TERMS_INTENT',l_tmpl_rec.intent) );
756:

Line 757: wf_engine.SetItemAttrText ( itemtype => l_itemtype,

753: itemkey => l_itemkey,
754: aname => 'TMPL_INTENT',
755: avalue => okc_util.decode_lookup('OKC_TERMS_INTENT',l_tmpl_rec.intent) );
756:
757: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
758: itemkey => l_itemkey,
759: aname => 'TMPL_WORKINGCOPY',
760: avalue => NVL(l_tmpl_rec.working_copy_flag,'N'));
761:

Line 762: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,

758: itemkey => l_itemkey,
759: aname => 'TMPL_WORKINGCOPY',
760: avalue => NVL(l_tmpl_rec.working_copy_flag,'N'));
761:
762: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,
763: itemkey => l_itemkey,
764: aname => 'TMPL_WF_SEQ_ID',
765: avalue => l_tmpl_rec.wf_sequence);
766:

Line 771: wf_engine.SetItemAttrText ( itemtype => l_itemtype,

767: OPEN org_name_csr(l_tmpl_rec.org_id);
768: FETCH org_name_csr INTO l_org_name;
769: CLOSE org_name_csr;
770:
771: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
772: itemkey => l_itemkey,
773: aname => 'ORG_NAME',
774: avalue => l_org_name);
775:

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

780: l_attach_key := 'FND:entity=OKC_TERMS_TEMPLATES'||'&pk1name=TEMPLATE_ID&pk1value='||
781: l_tmpl_rec.template_id||'&pk2name=WF_SEQUENCE_ID&pk2value='||l_tmpl_rec.wf_sequence ;
782:
783:
784: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
785: itemkey => l_itemkey,
786: aname => 'TMPL_ATTACHMENT',
787: avalue => l_attach_key);
788:

Line 791: wf_engine.SetItemAttrText( itemtype => l_itemtype,

787: avalue => l_attach_key);
788:
789: --wf_directory.GetRoleDisplayName(RequestorUsername) );
790:
791: wf_engine.SetItemAttrText( itemtype => l_itemtype,
792: itemkey => l_itemkey,
793: aname => 'MONITOR_URL',
794: avalue =>
795: wf_monitor.GetUrl(wf_core.translate('WF_WEB_AGENT')

Line 800: wf_engine.SetItemAttrText ( itemtype => l_itemtype,

796: ,l_itemtype,l_itemkey,'NO'));
797:
798: -- set new attribute expert enabled
799: -- TODO call expert function to set l_expert_enabled
800: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
801: itemkey => l_itemkey,
802: aname => 'TMPL_EXPERT_ENABLED',
803: avalue => l_expert_enabled);
804:

Line 805: wf_engine.SetItemOwner ( itemtype => l_itemtype,

801: itemkey => l_itemkey,
802: aname => 'TMPL_EXPERT_ENABLED',
803: avalue => l_expert_enabled);
804:
805: wf_engine.SetItemOwner ( itemtype => l_itemtype,
806: itemkey => l_itemkey,
807: owner => l_ProcessOwner );
808:
809: -- 11.5.10+ changes

Line 823: wf_engine.SetItemAttrText ( itemtype => l_itemtype,

819: AND nvl(selected_yn, 'N') = 'N';
820:
821: -- end of 11.5.10+ changes
822: --MLS for templates
823: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
824: itemkey => l_itemkey,
825: aname => 'TEMPLATE_LANGUAGE',
826: avalue => l_tmpl_rec.language_desc);
827:

Line 831: wf_engine.StartProcess( itemtype => l_itemtype,

827:
828:
829: -- need to ensure that call to wf start_process is the last to be called
830: -- becuase once invoked, it stops only if a blocking activity is reached.
831: wf_engine.StartProcess( itemtype => l_itemtype,
832: itemkey => l_itemkey );
833:
834: -- Standard call to get message count and if count is 1, get message info.
835: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 947: wf_engine.getItemAttrNumber(itemtype, itemkey, 'TEMPLATE_ID', false);

943:
944: BEGIN
945: IF ( funcmode = 'RUN' ) THEN
946: l_tmpl_id :=
947: wf_engine.getItemAttrNumber(itemtype, itemkey, 'TEMPLATE_ID', false);
948: l_tmpl_status :=
949: wf_engine.getItemAttrText(itemtype, itemkey, 'STATUS_CODE', false);
950: l_tmpl_wc :=
951: wf_engine.getItemAttrText(itemtype, itemkey, 'TMPL_WORKINGCOPY', false);

Line 949: wf_engine.getItemAttrText(itemtype, itemkey, 'STATUS_CODE', false);

945: IF ( funcmode = 'RUN' ) THEN
946: l_tmpl_id :=
947: wf_engine.getItemAttrNumber(itemtype, itemkey, 'TEMPLATE_ID', false);
948: l_tmpl_status :=
949: wf_engine.getItemAttrText(itemtype, itemkey, 'STATUS_CODE', false);
950: l_tmpl_wc :=
951: wf_engine.getItemAttrText(itemtype, itemkey, 'TMPL_WORKINGCOPY', false);
952: l_tmpl_wf_seq_id :=
953: wf_engine.getItemAttrText(itemtype, itemkey, 'TMPL_WF_SEQ_ID', false);

Line 951: wf_engine.getItemAttrText(itemtype, itemkey, 'TMPL_WORKINGCOPY', false);

947: wf_engine.getItemAttrNumber(itemtype, itemkey, 'TEMPLATE_ID', false);
948: l_tmpl_status :=
949: wf_engine.getItemAttrText(itemtype, itemkey, 'STATUS_CODE', false);
950: l_tmpl_wc :=
951: wf_engine.getItemAttrText(itemtype, itemkey, 'TMPL_WORKINGCOPY', false);
952: l_tmpl_wf_seq_id :=
953: wf_engine.getItemAttrText(itemtype, itemkey, 'TMPL_WF_SEQ_ID', false);
954: l_expert_enabled :=
955: wf_engine.getItemAttrText(itemtype, itemkey, 'TMPL_EXPERT_ENABLED', false);

Line 953: wf_engine.getItemAttrText(itemtype, itemkey, 'TMPL_WF_SEQ_ID', false);

949: wf_engine.getItemAttrText(itemtype, itemkey, 'STATUS_CODE', false);
950: l_tmpl_wc :=
951: wf_engine.getItemAttrText(itemtype, itemkey, 'TMPL_WORKINGCOPY', false);
952: l_tmpl_wf_seq_id :=
953: wf_engine.getItemAttrText(itemtype, itemkey, 'TMPL_WF_SEQ_ID', false);
954: l_expert_enabled :=
955: wf_engine.getItemAttrText(itemtype, itemkey, 'TMPL_EXPERT_ENABLED', false);
956: x_return_status := 'S';
957:

Line 955: wf_engine.getItemAttrText(itemtype, itemkey, 'TMPL_EXPERT_ENABLED', false);

951: wf_engine.getItemAttrText(itemtype, itemkey, 'TMPL_WORKINGCOPY', false);
952: l_tmpl_wf_seq_id :=
953: wf_engine.getItemAttrText(itemtype, itemkey, 'TMPL_WF_SEQ_ID', false);
954: l_expert_enabled :=
955: wf_engine.getItemAttrText(itemtype, itemkey, 'TMPL_EXPERT_ENABLED', false);
956: x_return_status := 'S';
957:
958:
959: IF (l_expert_enabled = 'Y') THEN

Line 1041: Wf_engine.setItemAttrNumber(

1037: x_msg_data => x_msg_data,
1038: x_msg_count => x_msg_count,
1039: x_parent_template_id => l_parent_template_id);
1040:
1041: Wf_engine.setItemAttrNumber(
1042: itemtype => itemtype,
1043: itemkey => itemkey,
1044: aname => 'TEMPLATE_ID',
1045: avalue => l_parent_template_id);

Line 1166: wf_engine.getItemAttrNumber(itemtype, itemkey, 'TEMPLATE_ID', false);

1162:
1163: IF ( funcmode = 'RUN' ) THEN
1164:
1165: l_tmpl_id :=
1166: wf_engine.getItemAttrNumber(itemtype, itemkey, 'TEMPLATE_ID', false);
1167: l_tmpl_status :=
1168: wf_engine.getItemAttrText(itemtype, itemkey, 'STATUS_CODE', false);
1169: l_tmpl_wf_seq_id :=
1170: wf_engine.getItemAttrText(itemtype, itemkey, 'TMPL_WF_SEQ_ID', false);

Line 1168: wf_engine.getItemAttrText(itemtype, itemkey, 'STATUS_CODE', false);

1164:
1165: l_tmpl_id :=
1166: wf_engine.getItemAttrNumber(itemtype, itemkey, 'TEMPLATE_ID', false);
1167: l_tmpl_status :=
1168: wf_engine.getItemAttrText(itemtype, itemkey, 'STATUS_CODE', false);
1169: l_tmpl_wf_seq_id :=
1170: wf_engine.getItemAttrText(itemtype, itemkey, 'TMPL_WF_SEQ_ID', false);
1171: x_return_status := 'S';
1172:

Line 1170: wf_engine.getItemAttrText(itemtype, itemkey, 'TMPL_WF_SEQ_ID', false);

1166: wf_engine.getItemAttrNumber(itemtype, itemkey, 'TEMPLATE_ID', false);
1167: l_tmpl_status :=
1168: wf_engine.getItemAttrText(itemtype, itemkey, 'STATUS_CODE', false);
1169: l_tmpl_wf_seq_id :=
1170: wf_engine.getItemAttrText(itemtype, itemkey, 'TMPL_WF_SEQ_ID', false);
1171: x_return_status := 'S';
1172:
1173: CHANGE_CLAUSE_STATUS (
1174: p_api_version => 1,

Line 1271: l_template_id := wf_engine.GetItemAttrNumber(

1267: -- RUN mode - normal process execution
1268: --
1269: IF (funcmode = 'RUN') then
1270:
1271: l_template_id := wf_engine.GetItemAttrNumber(
1272: itemtype => itemtype,
1273: itemkey => itemkey,
1274: aname => 'TEMPLATE_ID' );
1275:

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

1279:
1280: --l_approver := 'CONMGR';
1281:
1282: IF l_approver IS NOT NULL THEN
1283: wf_engine.SetItemAttrText (itemtype => itemtype,
1284: itemkey => itemkey,
1285: aname => 'APPROVER_USERNAME',
1286: avalue => l_approver);
1287:

Line 1341: l_tmpl_attach_exists := wf_engine.GetItemAttrNumber(

1337: IF (funcmode = 'RUN') then
1338:
1339:
1340: -- checking wether the item attribute was already set.
1341: l_tmpl_attach_exists := wf_engine.GetItemAttrNumber(
1342: itemtype => itemtype,
1343: itemkey => itemkey,
1344: aname => 'TMPL_ATTACH_EXISTS' );
1345:

Line 1357: l_template_id := wf_engine.GetItemAttrNumber(

1353:
1354: -- first time ,if item attribute was not set, execute the query
1355: else
1356:
1357: l_template_id := wf_engine.GetItemAttrNumber(
1358: itemtype => itemtype,
1359: itemkey => itemkey,
1360: aname => 'TEMPLATE_ID' );
1361:

Line 1362: l_wf_seq_id := wf_engine.GetItemAttrNumber(

1358: itemtype => itemtype,
1359: itemkey => itemkey,
1360: aname => 'TEMPLATE_ID' );
1361:
1362: l_wf_seq_id := wf_engine.GetItemAttrNumber(
1363: itemtype => itemtype,
1364: itemkey => itemkey,
1365: aname => 'TMPL_WF_SEQ_ID' );
1366:

Line 1373: wf_engine.setItemAttrText(itemtype, itemkey, 'TMPL_ATTACH_EXISTS', 'Y');

1369:
1370:
1371: IF attachment_exists_csr%FOUND THEN
1372: resultout := 'COMPLETE:T';
1373: wf_engine.setItemAttrText(itemtype, itemkey, 'TMPL_ATTACH_EXISTS', 'Y');
1374: ELSE
1375: resultout := 'COMPLETE:F';
1376: wf_engine.setItemAttrText(itemtype, itemkey, 'TMPL_ATTACH_EXISTS', 'N');
1377: END IF;

Line 1376: wf_engine.setItemAttrText(itemtype, itemkey, 'TMPL_ATTACH_EXISTS', 'N');

1372: resultout := 'COMPLETE:T';
1373: wf_engine.setItemAttrText(itemtype, itemkey, 'TMPL_ATTACH_EXISTS', 'Y');
1374: ELSE
1375: resultout := 'COMPLETE:F';
1376: wf_engine.setItemAttrText(itemtype, itemkey, 'TMPL_ATTACH_EXISTS', 'N');
1377: END IF;
1378: CLOSE attachment_exists_csr;
1379:
1380: end if;

Line 1424: l_template_id := wf_engine.GetItemAttrNumber(

1420:
1421: -- RUN mode - normal process execution
1422: IF (funcmode = 'RUN') then
1423:
1424: l_template_id := wf_engine.GetItemAttrNumber(
1425: itemtype => itemtype,
1426: itemkey => itemkey,
1427: aname => 'TEMPLATE_ID' );
1428:

Line 1797: operation Wf_Engine.NameTabTyp;

1793: adoption_type_lst adoption_type_tbl;
1794: organization_id_lst organization_id_tbl;
1795: org_information3_lst org_information3_tbl;
1796:
1797: operation Wf_Engine.NameTabTyp;
1798: operation_list Wf_Engine.TextTabTyp;
1799: organization Wf_Engine.NameTabTyp;
1800: organization_list Wf_Engine.NumTabTyp;
1801: notified Wf_Engine.NameTabTyp;

Line 1798: operation_list Wf_Engine.TextTabTyp;

1794: organization_id_lst organization_id_tbl;
1795: org_information3_lst org_information3_tbl;
1796:
1797: operation Wf_Engine.NameTabTyp;
1798: operation_list Wf_Engine.TextTabTyp;
1799: organization Wf_Engine.NameTabTyp;
1800: organization_list Wf_Engine.NumTabTyp;
1801: notified Wf_Engine.NameTabTyp;
1802: notified_list Wf_Engine.TextTabTyp;

Line 1799: organization Wf_Engine.NameTabTyp;

1795: org_information3_lst org_information3_tbl;
1796:
1797: operation Wf_Engine.NameTabTyp;
1798: operation_list Wf_Engine.TextTabTyp;
1799: organization Wf_Engine.NameTabTyp;
1800: organization_list Wf_Engine.NumTabTyp;
1801: notified Wf_Engine.NameTabTyp;
1802: notified_list Wf_Engine.TextTabTyp;
1803: global_org_id NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);

Line 1800: organization_list Wf_Engine.NumTabTyp;

1796:
1797: operation Wf_Engine.NameTabTyp;
1798: operation_list Wf_Engine.TextTabTyp;
1799: organization Wf_Engine.NameTabTyp;
1800: organization_list Wf_Engine.NumTabTyp;
1801: notified Wf_Engine.NameTabTyp;
1802: notified_list Wf_Engine.TextTabTyp;
1803: global_org_id NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
1804: counter NUMBER;

Line 1801: notified Wf_Engine.NameTabTyp;

1797: operation Wf_Engine.NameTabTyp;
1798: operation_list Wf_Engine.TextTabTyp;
1799: organization Wf_Engine.NameTabTyp;
1800: organization_list Wf_Engine.NumTabTyp;
1801: notified Wf_Engine.NameTabTyp;
1802: notified_list Wf_Engine.TextTabTyp;
1803: global_org_id NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
1804: counter NUMBER;
1805:

Line 1802: notified_list Wf_Engine.TextTabTyp;

1798: operation_list Wf_Engine.TextTabTyp;
1799: organization Wf_Engine.NameTabTyp;
1800: organization_list Wf_Engine.NumTabTyp;
1801: notified Wf_Engine.NameTabTyp;
1802: notified_list Wf_Engine.TextTabTyp;
1803: global_org_id NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
1804: counter NUMBER;
1805:
1806: BEGIN

Line 1808: template_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'TEMPLATE_ID', false);

1804: counter NUMBER;
1805:
1806: BEGIN
1807: counter := 0;
1808: template_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'TEMPLATE_ID', false);
1809: l_tmpl_intent := wf_engine.getItemAttrNumber(itemtype, itemkey, 'TMPL_INTENT', false);
1810:
1811: IF ( funcmode = 'RUN' ) THEN
1812: OPEN notified_csr(l_tmpl_intent , global_org_id);

Line 1809: l_tmpl_intent := wf_engine.getItemAttrNumber(itemtype, itemkey, 'TMPL_INTENT', false);

1805:
1806: BEGIN
1807: counter := 0;
1808: template_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'TEMPLATE_ID', false);
1809: l_tmpl_intent := wf_engine.getItemAttrNumber(itemtype, itemkey, 'TMPL_INTENT', false);
1810:
1811: IF ( funcmode = 'RUN' ) THEN
1812: OPEN notified_csr(l_tmpl_intent , global_org_id);
1813: FETCH notified_csr BULK COLLECT INTO adoption_type_lst,organization_id_lst,org_information3_lst;

Line 1827: wf_engine.AddItemAttrTextArray( itemtype, itemkey, operation, operation_list);

1823: notified(counter):= 'NOTIFIED_LIST$'||counter;
1824: notified_list(counter):= org_information3_lst(i);
1825: END LOOP;
1826:
1827: wf_engine.AddItemAttrTextArray( itemtype, itemkey, operation, operation_list);
1828: wf_engine.AddItemAttrNumberArray( itemtype, itemkey, organization, organization_list);
1829: wf_engine.AddItemAttrTextArray( itemtype, itemkey, notified, notified_list);
1830: wf_engine.AddItemAttr(itemtype, itemkey, 'COUNTER$', null, counter, null);
1831: resultout := 'COMPLETE';

Line 1828: wf_engine.AddItemAttrNumberArray( itemtype, itemkey, organization, organization_list);

1824: notified_list(counter):= org_information3_lst(i);
1825: END LOOP;
1826:
1827: wf_engine.AddItemAttrTextArray( itemtype, itemkey, operation, operation_list);
1828: wf_engine.AddItemAttrNumberArray( itemtype, itemkey, organization, organization_list);
1829: wf_engine.AddItemAttrTextArray( itemtype, itemkey, notified, notified_list);
1830: wf_engine.AddItemAttr(itemtype, itemkey, 'COUNTER$', null, counter, null);
1831: resultout := 'COMPLETE';
1832:

Line 1829: wf_engine.AddItemAttrTextArray( itemtype, itemkey, notified, notified_list);

1825: END LOOP;
1826:
1827: wf_engine.AddItemAttrTextArray( itemtype, itemkey, operation, operation_list);
1828: wf_engine.AddItemAttrNumberArray( itemtype, itemkey, organization, organization_list);
1829: wf_engine.AddItemAttrTextArray( itemtype, itemkey, notified, notified_list);
1830: wf_engine.AddItemAttr(itemtype, itemkey, 'COUNTER$', null, counter, null);
1831: resultout := 'COMPLETE';
1832:
1833: RETURN;

Line 1830: wf_engine.AddItemAttr(itemtype, itemkey, 'COUNTER$', null, counter, null);

1826:
1827: wf_engine.AddItemAttrTextArray( itemtype, itemkey, operation, operation_list);
1828: wf_engine.AddItemAttrNumberArray( itemtype, itemkey, organization, organization_list);
1829: wf_engine.AddItemAttrTextArray( itemtype, itemkey, notified, notified_list);
1830: wf_engine.AddItemAttr(itemtype, itemkey, 'COUNTER$', null, counter, null);
1831: resultout := 'COMPLETE';
1832:
1833: RETURN;
1834: END IF;

Line 1901: counter := wf_engine.getItemAttrNumber(itemtype, itemkey, 'COUNTER$', false);

1897: OPEN wf_admin_csr;
1898: FETCH wf_admin_csr INTO wf_admin_user;
1899: CLOSE wf_admin_csr;
1900:
1901: counter := wf_engine.getItemAttrNumber(itemtype, itemkey, 'COUNTER$', false);
1902: IF counter > 0 THEN
1903: operation := wf_engine.getItemAttrText(itemtype, itemkey, 'OPERATION_LIST$'||counter, false);
1904: organization := wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORGANIZATION_LIST$'||counter, false);
1905: notified := wf_engine.getItemAttrText(itemtype, itemkey, 'NOTIFIED_LIST$'||counter, false);

Line 1903: operation := wf_engine.getItemAttrText(itemtype, itemkey, 'OPERATION_LIST$'||counter, false);

1899: CLOSE wf_admin_csr;
1900:
1901: counter := wf_engine.getItemAttrNumber(itemtype, itemkey, 'COUNTER$', false);
1902: IF counter > 0 THEN
1903: operation := wf_engine.getItemAttrText(itemtype, itemkey, 'OPERATION_LIST$'||counter, false);
1904: organization := wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORGANIZATION_LIST$'||counter, false);
1905: notified := wf_engine.getItemAttrText(itemtype, itemkey, 'NOTIFIED_LIST$'||counter, false);
1906:
1907: OPEN org_name_csr(organization);

Line 1904: organization := wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORGANIZATION_LIST$'||counter, false);

1900:
1901: counter := wf_engine.getItemAttrNumber(itemtype, itemkey, 'COUNTER$', false);
1902: IF counter > 0 THEN
1903: operation := wf_engine.getItemAttrText(itemtype, itemkey, 'OPERATION_LIST$'||counter, false);
1904: organization := wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORGANIZATION_LIST$'||counter, false);
1905: notified := wf_engine.getItemAttrText(itemtype, itemkey, 'NOTIFIED_LIST$'||counter, false);
1906:
1907: OPEN org_name_csr(organization);
1908: FETCH org_name_csr INTO org_name;

Line 1905: notified := wf_engine.getItemAttrText(itemtype, itemkey, 'NOTIFIED_LIST$'||counter, false);

1901: counter := wf_engine.getItemAttrNumber(itemtype, itemkey, 'COUNTER$', false);
1902: IF counter > 0 THEN
1903: operation := wf_engine.getItemAttrText(itemtype, itemkey, 'OPERATION_LIST$'||counter, false);
1904: organization := wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORGANIZATION_LIST$'||counter, false);
1905: notified := wf_engine.getItemAttrText(itemtype, itemkey, 'NOTIFIED_LIST$'||counter, false);
1906:
1907: OPEN org_name_csr(organization);
1908: FETCH org_name_csr INTO org_name;
1909: CLOSE org_name_csr;

Line 1923: wf_engine.setItemAttrText(itemtype, itemkey, 'ADOPTION_DESC', adoption_type_desc);

1919: if (adoption_type_desc is null ) then
1920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1921: end if ;
1922:
1923: wf_engine.setItemAttrText(itemtype, itemkey, 'ADOPTION_DESC', adoption_type_desc);
1924: wf_engine.setItemAttrText(itemtype, itemkey, 'ADOPTION_TYPE', operation);
1925: wf_engine.setItemAttrText(itemtype, itemkey, 'LOCAL_ORG_NAME', org_name);
1926: wf_engine.setItemAttrNumber(itemtype, itemkey, 'LOCAL_ORG_ID', organization);
1927:

Line 1924: wf_engine.setItemAttrText(itemtype, itemkey, 'ADOPTION_TYPE', operation);

1920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1921: end if ;
1922:
1923: wf_engine.setItemAttrText(itemtype, itemkey, 'ADOPTION_DESC', adoption_type_desc);
1924: wf_engine.setItemAttrText(itemtype, itemkey, 'ADOPTION_TYPE', operation);
1925: wf_engine.setItemAttrText(itemtype, itemkey, 'LOCAL_ORG_NAME', org_name);
1926: wf_engine.setItemAttrNumber(itemtype, itemkey, 'LOCAL_ORG_ID', organization);
1927:
1928: IF notified IS NOT NULL THEN

Line 1925: wf_engine.setItemAttrText(itemtype, itemkey, 'LOCAL_ORG_NAME', org_name);

1921: end if ;
1922:
1923: wf_engine.setItemAttrText(itemtype, itemkey, 'ADOPTION_DESC', adoption_type_desc);
1924: wf_engine.setItemAttrText(itemtype, itemkey, 'ADOPTION_TYPE', operation);
1925: wf_engine.setItemAttrText(itemtype, itemkey, 'LOCAL_ORG_NAME', org_name);
1926: wf_engine.setItemAttrNumber(itemtype, itemkey, 'LOCAL_ORG_ID', organization);
1927:
1928: IF notified IS NOT NULL THEN
1929: wf_engine.setItemAttrText(itemtype, itemkey, 'LOCAL_ORG_APPROVER', notified);

Line 1926: wf_engine.setItemAttrNumber(itemtype, itemkey, 'LOCAL_ORG_ID', organization);

1922:
1923: wf_engine.setItemAttrText(itemtype, itemkey, 'ADOPTION_DESC', adoption_type_desc);
1924: wf_engine.setItemAttrText(itemtype, itemkey, 'ADOPTION_TYPE', operation);
1925: wf_engine.setItemAttrText(itemtype, itemkey, 'LOCAL_ORG_NAME', org_name);
1926: wf_engine.setItemAttrNumber(itemtype, itemkey, 'LOCAL_ORG_ID', organization);
1927:
1928: IF notified IS NOT NULL THEN
1929: wf_engine.setItemAttrText(itemtype, itemkey, 'LOCAL_ORG_APPROVER', notified);
1930: ELSE

Line 1929: wf_engine.setItemAttrText(itemtype, itemkey, 'LOCAL_ORG_APPROVER', notified);

1925: wf_engine.setItemAttrText(itemtype, itemkey, 'LOCAL_ORG_NAME', org_name);
1926: wf_engine.setItemAttrNumber(itemtype, itemkey, 'LOCAL_ORG_ID', organization);
1927:
1928: IF notified IS NOT NULL THEN
1929: wf_engine.setItemAttrText(itemtype, itemkey, 'LOCAL_ORG_APPROVER', notified);
1930: ELSE
1931: wf_engine.setItemAttrText(itemtype, itemkey, 'LOCAL_ORG_APPROVER', wf_admin_user);
1932: END IF;
1933:

Line 1931: wf_engine.setItemAttrText(itemtype, itemkey, 'LOCAL_ORG_APPROVER', wf_admin_user);

1927:
1928: IF notified IS NOT NULL THEN
1929: wf_engine.setItemAttrText(itemtype, itemkey, 'LOCAL_ORG_APPROVER', notified);
1930: ELSE
1931: wf_engine.setItemAttrText(itemtype, itemkey, 'LOCAL_ORG_APPROVER', wf_admin_user);
1932: END IF;
1933:
1934: resultout := 'COMPLETE:'||operation;
1935: ELSE

Line 1980: counter := wf_engine.getItemAttrNumber(itemtype, itemkey, 'COUNTER$', false) - 1;

1976: counter number;
1977:
1978: BEGIN
1979: IF (funcmode = 'RUN') THEN
1980: counter := wf_engine.getItemAttrNumber(itemtype, itemkey, 'COUNTER$', false) - 1;
1981: IF counter > 0 THEN
1982: wf_engine.setItemAttrNumber(itemtype, itemkey, 'COUNTER$', counter);
1983: resultout := 'COMPLETE:T';
1984: ELSE

Line 1982: wf_engine.setItemAttrNumber(itemtype, itemkey, 'COUNTER$', counter);

1978: BEGIN
1979: IF (funcmode = 'RUN') THEN
1980: counter := wf_engine.getItemAttrNumber(itemtype, itemkey, 'COUNTER$', false) - 1;
1981: IF counter > 0 THEN
1982: wf_engine.setItemAttrNumber(itemtype, itemkey, 'COUNTER$', counter);
1983: resultout := 'COMPLETE:T';
1984: ELSE
1985: resultout := 'COMPLETE:F';
1986: END IF;

Line 2065: current_org_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORG_ID', false);

2061:
2062: BEGIN
2063: IF (funcmode = 'RUN') THEN
2064: resultout := 'COMPLETE:F';
2065: current_org_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORG_ID', false);
2066: template_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'TEMPLATE_ID', false);
2067: wf_seq_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'TMPL_WF_SEQ_ID', false);
2068:
2069: IF (current_org_id = GLOBAL_ORG_ID ) THEN

Line 2066: template_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'TEMPLATE_ID', false);

2062: BEGIN
2063: IF (funcmode = 'RUN') THEN
2064: resultout := 'COMPLETE:F';
2065: current_org_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORG_ID', false);
2066: template_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'TEMPLATE_ID', false);
2067: wf_seq_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'TMPL_WF_SEQ_ID', false);
2068:
2069: IF (current_org_id = GLOBAL_ORG_ID ) THEN
2070:

Line 2067: wf_seq_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'TMPL_WF_SEQ_ID', false);

2063: IF (funcmode = 'RUN') THEN
2064: resultout := 'COMPLETE:F';
2065: current_org_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORG_ID', false);
2066: template_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'TEMPLATE_ID', false);
2067: wf_seq_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'TMPL_WF_SEQ_ID', false);
2068:
2069: IF (current_org_id = GLOBAL_ORG_ID ) THEN
2070:
2071: OPEN global_articles_csr(template_id,wf_seq_id);