[Home] [Help]
733: into l_organization_id
734: from dual;
735:
736: -- Retrieve Activity Attributes
737: p_inventory_item_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'INVENTORY_ITEM_ID');
738: p_org_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ORGANIZATION_ID');
739: l_organization_id := p_org_id;
740:
741: OPEN c_TradingPartners; -- open cursor
734: from dual;
735:
736: -- Retrieve Activity Attributes
737: p_inventory_item_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'INVENTORY_ITEM_ID');
738: p_org_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ORGANIZATION_ID');
739: l_organization_id := p_org_id;
740:
741: OPEN c_TradingPartners; -- open cursor
742:
982:
983: x_progress VARCHAR2(100);
984: l_error_code NUMBER;
985: l_error_msg VARCHAR2(1000);
986: p_inventory_item_id NUMBER:= Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'INVENTORY_ITEM_ID');
987: p_org_id NUMBER:= Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ORGANIZATION_ID');
988: p_concatenated_segments VARCHAR2(50);
989: p_item_type VARCHAR2(30);
990: p_primary_uom_code VARCHAR2(3);
983: x_progress VARCHAR2(100);
984: l_error_code NUMBER;
985: l_error_msg VARCHAR2(1000);
986: p_inventory_item_id NUMBER:= Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'INVENTORY_ITEM_ID');
987: p_org_id NUMBER:= Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ORGANIZATION_ID');
988: p_concatenated_segments VARCHAR2(50);
989: p_item_type VARCHAR2(30);
990: p_primary_uom_code VARCHAR2(3);
991: p_customer_item_number VARCHAR2(50);
1082: cln_debug_pub.Add('Failure point ' || x_progress, 1);
1083: end if;
1084:
1085: -- Retrieve Activity Attributes
1086: p_inventory_item_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'INVENTORY_ITEM_ID');
1087: p_org_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ORGANIZATION_ID');
1088:
1089: DELETE FROM cln_itemmst_deleted_items
1090: WHERE inventory_item_id = p_inventory_item_id AND organization_id = p_org_id;
1083: end if;
1084:
1085: -- Retrieve Activity Attributes
1086: p_inventory_item_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'INVENTORY_ITEM_ID');
1087: p_org_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ORGANIZATION_ID');
1088:
1089: DELETE FROM cln_itemmst_deleted_items
1090: WHERE inventory_item_id = p_inventory_item_id AND organization_id = p_org_id;
1091: