533: l_aname wf_engine.nametabtyp;
534: l_aname2 wf_engine.nametabtyp;
535: l_avalue wf_engine.numtabtyp;
536: l_avaluetext wf_engine.texttabtyp;
537: l_itemkeys_4NAttr wf_engine_bulk.itemkeytabtype;
538: l_itemkeys_4TAttr wf_engine_bulk.itemkeytabtype;
539:
540: WF_Api_l_item_keys wf_engine_bulk.itemkeytabtype;
541: WF_Api_l_user_keys wf_engine_bulk.userkeytabtype;
534: l_aname2 wf_engine.nametabtyp;
535: l_avalue wf_engine.numtabtyp;
536: l_avaluetext wf_engine.texttabtyp;
537: l_itemkeys_4NAttr wf_engine_bulk.itemkeytabtype;
538: l_itemkeys_4TAttr wf_engine_bulk.itemkeytabtype;
539:
540: WF_Api_l_item_keys wf_engine_bulk.itemkeytabtype;
541: WF_Api_l_user_keys wf_engine_bulk.userkeytabtype;
542: WF_Api_l_owner_roles wf_engine_bulk.ownerroletabtype;
536: l_avaluetext wf_engine.texttabtyp;
537: l_itemkeys_4NAttr wf_engine_bulk.itemkeytabtype;
538: l_itemkeys_4TAttr wf_engine_bulk.itemkeytabtype;
539:
540: WF_Api_l_item_keys wf_engine_bulk.itemkeytabtype;
541: WF_Api_l_user_keys wf_engine_bulk.userkeytabtype;
542: WF_Api_l_owner_roles wf_engine_bulk.ownerroletabtype;
543: /* End of WF Bulk API ER #8601238 */
544: --
537: l_itemkeys_4NAttr wf_engine_bulk.itemkeytabtype;
538: l_itemkeys_4TAttr wf_engine_bulk.itemkeytabtype;
539:
540: WF_Api_l_item_keys wf_engine_bulk.itemkeytabtype;
541: WF_Api_l_user_keys wf_engine_bulk.userkeytabtype;
542: WF_Api_l_owner_roles wf_engine_bulk.ownerroletabtype;
543: /* End of WF Bulk API ER #8601238 */
544: --
545: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
538: l_itemkeys_4TAttr wf_engine_bulk.itemkeytabtype;
539:
540: WF_Api_l_item_keys wf_engine_bulk.itemkeytabtype;
541: WF_Api_l_user_keys wf_engine_bulk.userkeytabtype;
542: WF_Api_l_owner_roles wf_engine_bulk.ownerroletabtype;
543: /* End of WF Bulk API ER #8601238 */
544: --
545: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
546: --
755: l_my_index_ind := l_item_keys.NEXT(l_my_index_ind);
756: END LOOP;
757:
758: -- Calling WF Bulk APIs for Creating the Workflow Process Definition
759: WF_ENGINE_BULK.CreateProcess
760: ( itemtype => OE_GLOBALS.G_WFI_LIN
761: , itemkeys => WF_Api_l_item_keys
762: , process => l_process_name_tbl(l_process_name_ind)
763: , user_keys => WF_Api_l_user_keys
775: END LOOP;
776: END IF;
777:
778: -- Calling WF Bulk APIs for setting Item attributes of Number and Text type
779: WF_ENGINE_BULK.SetItemAttrText
780: ( itemtype => OE_GLOBALS.G_WFI_LIN
781: , itemkeys => l_itemkeys_4TAttr
782: , anames => l_aname2
783: , avalues => l_avaluetext
782: , anames => l_aname2
783: , avalues => l_avaluetext
784: );
785:
786: WF_ENGINE_BULK.SetItemAttrNumber
787: ( itemtype => OE_GLOBALS.G_WFI_LIN
788: , itemkeys => l_itemkeys_4NAttr
789: , anames => l_aname
790: , avalues => l_avalue